CCN.Modules.CustRelations.DataAccess.CustRelationsDA.DeleteRelations C# (CSharp) Method

DeleteRelations() public method

删除好友关系
public DeleteRelations ( string fromid, string toid ) : int
fromid string
toid string
return int
        public int DeleteRelations(string fromid, string toid)
        {
            const string sql2 =
                "delete from cust_relations where (userid=@fromid and friendsid=@toid) or (userid=@toid and friendsid=@fromid);";
            using (var conn = Helper.GetConnection())
            {
                var tran = conn.BeginTransaction();
                try
                {
                    conn.Execute(sql2, new {fromid, toid}, tran);
                    tran.Commit();
                    return 1;
                }
                catch (Exception ex)
                {
                    tran.Rollback();
                    return 0;
                }
            }
        }