/// <summary> /// 添加好友申请 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddRelationsApply(CustRelationsApplyModels model) { int result; const string sql = "insert into cust_relations_apply (innerid, fromid, toid, status, createdtime, modifiedtime, remark, sourceid) values (@innerid, @fromid, @toid, @status, @createdtime, @modifiedtime, @remark, @sourceid);"; try { result = Helper.Execute(sql, model); } catch (Exception ex) { result = 0; } return result; }
/// <summary> /// 修改好友申请By id /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateRelationsApplyById(CustRelationsApplyModels model) { int result; const string sql = "update cust_relations_apply set remark=@remark, sourceid=@sourceid where innerid=@innerid;"; try { result = Helper.Execute(sql, model); } catch (Exception ex) { result = 0; } return result; }
/// <summary> /// 修改好友申请[重复申请] by fromid and toid /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateRelationsApply(CustRelationsApplyModels model) { int result; const string sql = "update cust_relations_apply set remark=@remark, sourceid=@sourceid where fromid=@fromid and toid=@toid and `status`=0;"; try { result = Helper.Execute(sql, model); } catch (Exception ex) { result = 0; } return result; }