public int GetOldterPostbacktimes(string TerNo, ref string msg)
{
if (TerNo.Trim() != "")
{
ISqlMapper NewMap = SqlMapper.Instance();
NewMap.BeginTransaction();
try
{
OldterPostbacktimes optSel = new OldterPostbacktimes();
optSel.TerNo = TerNo;
OldterPostbacktimes opt = (OldterPostbacktimes)ExecuteQueryForObjectTrans("OldterPostbacktimes.SelectOldterPostbacktimes", optSel, NewMap);
if (opt != null)
{
opt.Postbacktimes = opt.Postbacktimes + 1;
ExecuteUpdateTrans("OldterPostbacktimes.UpdateOldterPostbacktimes", opt, NewMap);
NewMap.CommitTransaction();
return(Convert.ToInt32(opt.Postbacktimes));
}
else
{
NewMap.RollBackTransaction();
msg = "无此编号的数据！";
return(0);
}
}
catch (Exception e)
{
NewMap.RollBackTransaction();
msg = e.Message;
return(-1);
}
}
else
{
msg = "请输入终端编号！";
return(-1);
}
}
public object Insert(TerminalInfo entity)
{
ISqlMapper NewMap = SqlMapper.Instance();
NewMap.BeginTransaction();
try
{
object Tercnt = ExecuteQueryForObjectTrans("TerminalInfo.SelectTerminalCountByTerNo", entity.TerNo, NewMap);
if ((int)Tercnt == 0)
{
ExecuteInsertTrans("TerminalInfo.InsertTerminalInfo", entity, NewMap);
object count = ExecuteQueryForObjectTrans("OldterPostbacktimes.SelectOldterPostbacktimesCount", entity.TerNo, NewMap);
if ((int)count == 0)
{
OldterPostbacktimes opt = new OldterPostbacktimes();
opt.Id = System.Guid.NewGuid().ToString();
opt.TerNo = entity.TerNo;
opt.Updatetime = DateTime.Now;
opt.Postbacktimes = 0;
ExecuteInsertTrans("OldterPostbacktimes.InsertOldterPostbacktimes", opt, NewMap);
}
NewMap.CommitTransaction();
return(0);
}
else
{
NewMap.RollBackTransaction();
return(-2);
}
}
catch (Exception e)
{
NewMap.RollBackTransaction();
return(-1);
}
}
public string upLoadData(UpLoadTerBind ut, string DeptId)
{
Hashtable htTerType = new Hashtable();
ProductsInfo pi = new ProductsInfo();
ProductsInfoDao _iProductsInfoDao = new ProductsInfoDao();
IList <ProductsInfo> lpt = _iProductsInfoDao.GetProductsInfoPage(pi);
for (int n = 0; n < lpt.Count; n++)
{
if (!htTerType.ContainsKey(lpt[n].ProName))
{
htTerType.Add(lpt[n].ProName, lpt[n].ProId);
}
}
ISqlMapper NewMap = SqlMapper.Instance();
NewMap.BeginTransaction();
try
{
TerminalInfo ti = (TerminalInfo)ExecuteQueryForObjectTrans("TerminalInfo.SelectTerminalInfoByTerNo", ut.TerNo, NewMap);
if (ti == null)
{
ti = new TerminalInfo();
ti.TerGuid = System.Guid.NewGuid().ToString();
ti.TerNo = ut.TerNo;
ti.TerTypeid = htTerType[ut.TerType].ToString();
ti.TerSimcard = ut.SimCard;
ti.TerInnettime = ut.TerInnettime;
ti.DeptId = DeptId;
if (DeptId != null && DeptId != "")
{
GDAL.Basic.DeptInfoDao deptInfoBll = new Basic.DeptInfoDao();
DeptInfo di = deptInfoBll.GetDeptInfoById(DeptId);
ti.TerDeptcode = di.Businessdivisioncode;
}
ExecuteInsertTrans("TerminalInfo.InsertTerminalInfo", ti, NewMap);
object count = ExecuteQueryForObjectTrans("OldterPostbacktimes.SelectOldterPostbacktimesCount", ut.TerNo, NewMap);
if ((int)count == 0)
{
OldterPostbacktimes opt = new OldterPostbacktimes();
opt.Id = System.Guid.NewGuid().ToString();
opt.TerNo = ut.TerNo;
opt.Updatetime = DateTime.Now;
opt.Postbacktimes = 0;
ExecuteInsertTrans("OldterPostbacktimes.InsertOldterPostbacktimes", opt, NewMap);
}
NewMap.CommitTransaction();
return("true");
}
else
{
NewMap.RollBackTransaction();
return("false");
}
}
catch (Exception e)
{
NewMap.RollBackTransaction();
return("false");
}
}
public int Update(OldterPostbacktimes entity)
{
return(ExecuteUpdate("OldterPostbacktimes.UpdateOldterPostbacktimes", entity));
}
public object Insert(OldterPostbacktimes entity)
{
return(ExecuteInsert("OldterPostbacktimes.InsertOldterPostbacktimes", entity));
}
public int Insert(OldterPostbacktimes entity)
{
return(Convert.ToInt32(_iOldterPostbacktimesDao.Insert(entity)));
}
