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);
}
}
