public string SetSendStatus(Hashtable ht) { try { IList <SendinfoyxLast> isi = ExecuteQueryForList <SendinfoyxLast>("SendinfoyxLast.SelectSendPageByTerNoAndCommand", ht); if (isi != null && isi.Count > 0 && isi[0].SendinfoStatus == 2) { for (int i = 0; i < isi.Count; i++) { ExecuteUpdate("SendinfoyxLast.DeleteSendinfoyxLast", isi[i].Id); } //ExecuteUpdate("SendinfoyxLast.DeleteSendinfoyxLast", isi[0].Id); return("2"); } else if (isi != null && isi.Count > 0 && isi[0].SendinfoStatus == 3) { for (int i = 0; i < isi.Count; i++) { ExecuteUpdate("SendinfoyxLast.DeleteSendinfoyxLast", isi[i].Id); } return("3"); } else if (isi != null && isi.Count > 0 && isi[0].SendinfoStatus != 2) { SendinfoyxLast sil = new SendinfoyxLast(); sil.Id = isi[0].Id; sil.SendinfoStatus = 3; ExecuteUpdate("SendinfoyxLast.UpdateSendinfoToFails", sil); return("3"); } else { return("3"); } } catch (Exception) { return("false"); } }
public string InsertData(Sendinfoyx entity) { ISqlMapper NewMap = SqlMapper.Instance(); try { NewMap.BeginTransaction(); int reCount = ExecuteUpdateTrans("Sendinfoyx.UpdateSendInfoyxCommand", entity, NewMap); SendinfoyxLast sil = new SendinfoyxLast(); if (reCount == 0) { entity.Id = System.Guid.NewGuid().ToString(); ExecuteInsertTrans("Sendinfoyx.InsertSendinfoyx", entity, NewMap); sil.Sendinfoyxid = entity.Id; sil.Id = System.Guid.NewGuid().ToString(); sil.CarinfoSim = entity.CarinfoSim; sil.DeviceId = entity.DeviceId; sil.SendinfoCommand = entity.SendinfoCommand; sil.Swiftnumber = entity.Swiftnumber; sil.SendinfoPtime = entity.SendinfoPtime; sil.SendinfoStatus = entity.SendinfoStatus; sil.SendinfoUserid = entity.SendinfoUserid; sil.SendinfoDescription = entity.SendinfoDescription; sil.Sendmethod = entity.Sendmethod; sil.Isonline = entity.Isonline; sil.Sendtotime = entity.Sendtotime; sil.Sendtocmd = entity.Sendtocmd; sil.ReceCmd = entity.ReceCmd; sil.ReceTime = entity.ReceTime; ExecuteInsertTrans("SendinfoyxLast.InsertSendinfoyxLast", sil, NewMap); } else { sil.Sendinfoyxid = entity.Id; sil.Id = System.Guid.NewGuid().ToString(); sil.CarinfoSim = entity.CarinfoSim; sil.DeviceId = entity.DeviceId; sil.SendinfoCommand = entity.SendinfoCommand; sil.Swiftnumber = entity.Swiftnumber; sil.SendinfoPtime = entity.SendinfoPtime; sil.SendinfoStatus = entity.SendinfoStatus; sil.SendinfoUserid = entity.SendinfoUserid; sil.SendinfoDescription = entity.SendinfoDescription; sil.Sendmethod = entity.Sendmethod; sil.Isonline = entity.Isonline; sil.Sendtotime = entity.Sendtotime; sil.Sendtocmd = entity.Sendtocmd; sil.ReceCmd = entity.ReceCmd; sil.ReceTime = entity.ReceTime; ExecuteUpdateTrans("SendinfoyxLast.UpdateSendinfoyxLastCommand", sil, NewMap); } NewMap.CommitTransaction(); return("true"); } catch (Exception e) { NewMap.RollBackTransaction(); return(entity.DeviceId); } }