public IActionResult GetSiteInfo(int id)
{
DataAccess.TASM_SUPPORT_SITE_Da manager = new DataAccess.TASM_SUPPORT_SITE_Da();
TASM_SUPPORT_SITE model = manager.CurrentDb.GetById(id);
return(SuccessResult(model));
}
private bool InsertSite(TASM_SUPPORT_SITE model, TASM_SUPPORT_SITE_Da manager, ref int siteId)
{
model.CREATETIME = DateTime.Now;
siteId = manager.Db.Insertable(model).ExecuteReturnIdentity();
return(siteId > 0);
}
private bool InsertHistory(TASM_SUPPORT_SITE model, TASM_SUPPORT supportModel, int siteId, int supportStatus, int nextUser)
{
DataAccess.TASM_SUPPORT_HIS_Da his_manager = new TASM_SUPPORT_HIS_Da();
TASM_SUPPORT_HIS hisModel = new TASM_SUPPORT_HIS();
hisModel.CREATETIME = DateTime.Now;
hisModel.PRE_USER = supportModel.CONDUCTOR;
hisModel.NEXT_USER = nextUser;
hisModel.SID = model.SID;
hisModel.REMARKS = "现场已处理，等待审核";
hisModel.PRE_STATUS = supportModel.STATUS;
hisModel.NEXT_STATUS = supportStatus;
hisModel.TYPE = (int)Entites.SupportHisType.现场处理;
hisModel.TID = siteId;
return(his_manager.CurrentDb.Insert(hisModel));
}
public IActionResult SiteUpdate(HisSiteModel info)
{
TASM_SUPPORT_SITE_Da site = new TASM_SUPPORT_SITE_Da();
TASM_SUPPORT_HIS_Da his = new TASM_SUPPORT_HIS_Da();
var hisModel = his.SelectBySidType(info.SID, 3);
site.Db.BeginTran();
hisModel.NEXT_USER = int.Parse(info.NEXT_USER);
if (his.Db.Updateable(hisModel).ExecuteCommand() < 1)
{
site.Db.RollbackTran();
return(FailMessage());
}
TASM_SUPPORT_SITE model = new TASM_SUPPORT_SITE()
{
ID = info.TID,
DESCRIPTION = info.DESCRIPTION,
ENDDATE = DateTime.Parse(info.ENDDATE),
REAMRKS = info.REAMRKS,
SID = info.SID
};
if (site.Db.Updateable(model).ExecuteCommand() < 1)
{
site.Db.RollbackTran();
return(FailMessage());
}
site.Db.CommitTran();
return(SuccessMessage());
}
/// <summary>
/// 现场处理
/// </summary>
/// <returns></returns>
private bool CreateSiteCheck(TASM_SUPPORT supportModel, ExcelModel item, int sid)
{
try
{
logger.Info("===创建现场处理开始===！");
TASM_SUPPORT_SITE_Da supportSite = new TASM_SUPPORT_SITE_Da();
TASM_SUPPORT_SITE siteMode = new TASM_SUPPORT_SITE();
siteMode.CREATETIME = DateTime.Now;
siteMode.DESCRIPTION = item.Description;
siteMode.ENDDATE = ConventDateTime(item.EndDate);
siteMode.REAMRKS = "导入数据";
int siteId = supportSite.Db.Insertable(siteMode).ExecuteReturnIdentity();
TASM_SUPPORT_HIS_Da supportHis = new TASM_SUPPORT_HIS_Da();
TASM_SUPPORT_HIS supportHisModel = new TASM_SUPPORT_HIS();
supportHisModel.SID = sid;
supportHisModel.PRE_USER = supportModel.CONDUCTOR; //上一处理人
supportHisModel.NEXT_USER = supportModel.CONDUCTOR; //下一处理人
supportHisModel.PRE_STATUS = item.IsPmcPoint == "是" ? 2 : 1; //上一状态，订单初始创建，为0
supportHisModel.NEXT_STATUS = 3; //下一状态，订单初始创建 下一状态为 现场处理，状态0，此处创建订单不做为状态，默认创建 和 创建后未处理状态都是0
supportHisModel.TYPE = 3; //类型，也代表着是哪个表的数据 初始为0
supportHisModel.TID = siteId; //数据id 根据type 那张表，看是哪一条数据。
supportHisModel.REMARKS = "现场已处理，等待审核导入数据";
supportHisModel.CREATETIME = DateTime.Now;
supportHis.Db.Insertable(supportHisModel);
logger.Info("插入历史表，现场处理完成");
TASM_SUPPORT_PERSONAL_Da supportPersonal = new TASM_SUPPORT_PERSONAL_Da();
TASM_SUPPORT_PERSONAL personalModel = new TASM_SUPPORT_PERSONAL();
personalModel.CID = supportModel.CONDUCTOR;
personalModel.DID = supportModel.CONDUCTOR;
personalModel.CREATETIME = DateTime.Now;
personalModel.SID = sid;
personalModel.STATUS = 2;
personalModel.TID = 3;
personalModel.CREATETIME = DateTime.Now;
personalModel.REMARKS = "数据导入";
supportPersonal.Db.Insertable(personalModel);
logger.Info("插入个人处理表，现场处理完成");
logger.Info("===创建现场处理结束===！");
return(true);
}
catch (Exception ex)
{
logger.Error("创建现场处理失败" + ex);
return(false);
}
}
