public int HandleRelationsApply(string innerid, int status,string fromid ,string toid)
{
var result = 1;
const string sqlUpdate = "update cust_relations_apply set `status`=@status where innerid=@innerid;";
const string sqlInsert = "insert into cust_relations (innerid, userid, friendsid, createdtime) values (uuid(), @userid, @friendsid, @createdtime);";
using (var conn = Helper.GetConnection())
{
var tran = conn.BeginTransaction();
try
{
conn.Execute(sqlUpdate, new {innerid, status}, tran);
//接受
if (status == 1)
{
const string sqlR = "select count(1) as count from cust_relations where userid=@userid and friendsid=@friendsid;";
var isR = conn.Query<int>(sqlR, new {userid = fromid, friendsid = toid}).FirstOrDefault();
if (isR == 0)
{
conn.Execute(sqlInsert, new { userid = fromid, friendsid = toid, createdtime = DateTime.Now }, tran);
conn.Execute(sqlInsert, new { userid = toid, friendsid = fromid, createdtime = DateTime.Now }, tran);
}
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
result = 0;
}
}
return result;
}