/// <summary>
/// 创建工单
/// </summary>
/// <param name="daSupport"></param>
/// <param name="item"></param>
/// <returns></returns>
private bool CreateSupport(TASM_SUPPORT_Da daSupport, ExcelModel item, ref int sid, ref TASM_SUPPORT supportModel)
{
try
{
logger.Info("===创建工单开始===！");
//step1 添加工单主表，
supportModel = new Entites.CodeGenerator.TASM_SUPPORT();
supportModel.CREATOR = GetUserIdByName(item.CreateName); //工单初始创建人
supportModel.CONTENT = item.Content; //问题描述
supportModel.TYPE = item.SupportType;
supportModel.SEVERITY = item.Severity;
supportModel.FINDATE = ConventDateTime(item.Createtime);
supportModel.CONDUCTOR = GetUserIdByName(item.ConductorName);
supportModel.STATUS = item.EndPiont;
supportModel.STATE = item.ConductorStatus;
supportModel.MID = GetsMachineByName(item.MachineCode);
supportModel.CODE = GetSupportCode(Project.CODE);
supportModel.TITLE = "导入数据";
supportModel.CREATETIME = DateTime.Now;
sid = daSupport.Db.Insertable(supportModel).ExecuteReturnIdentity();
logger.Info("插入工单表");
//step2 添加历史表
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.CREATOR; //上一处理人
supportHisModel.NEXT_USER = supportModel.CONDUCTOR; //下一处理人
supportHisModel.PRE_STATUS = 0; //上一状态，订单初始创建，为0
supportHisModel.NEXT_STATUS = 0; //下一状态，订单初始创建 下一状态为 现场处理，状态0，此处创建订单不做为状态，默认创建 和 创建后未处理状态都是0
supportHisModel.TYPE = 0; //类型，也代表着是哪个表的数据 初始为0
supportHisModel.TID = sid; //数据id 根据type 那张表，看是哪一条数据。
supportHisModel.REMARKS = "工单创建，等待技术处理,导入数据";
supportHisModel.CREATETIME = DateTime.Now;
supportHis.Db.Insertable(supportHisModel);
logger.Info("插入历史表：创建工单");
logger.Info("===创建工单结束===！");
return(true);
}
catch (Exception ex)
{
logger.Error("创建工单失败" + ex);
return(false);
}
}
/// <summary>
/// 创建负责人审核
/// </summary>
/// <param name="supportModel"></param>
/// <param name="item"></param>
/// <param name="sid"></param>
/// <returns></returns>
private bool CreatePrincipal(TASM_SUPPORT supportModel, ExcelModel item, int sid)
{
try
{
logger.Info("===创建审核开始===！");
DataAccess.TASM_SUPPORT_PRINCIPAL_Da supportPrincipal = new TASM_SUPPORT_PRINCIPAL_Da();
TASM_SUPPORT_PRINCIPAL princalModel = new TASM_SUPPORT_PRINCIPAL();
princalModel.CHECKUSER = item.CheckName;
princalModel.CREATETIME = DateTime.Now;
princalModel.ENDDATE = ConventDateTime(item.FinishDate);
princalModel.RESULT = item.CheckResult;
princalModel.SID = sid;
princalModel.STATUS = 0;
princalModel.REMARKS = "导入数据";
int prId = supportPrincipal.Db.Insertable(princalModel).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 = 4; //下一状态，订单初始创建 下一状态为 现场处理，状态0，此处创建订单不做为状态，默认创建 和 创建后未处理状态都是0
supportHisModel.TYPE = 4; //类型，也代表着是哪个表的数据 初始为0
supportHisModel.TID = prId; //数据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 = 4;
personalModel.CREATETIME = DateTime.Now;
personalModel.REMARKS = "数据导入";
supportPersonal.Db.Insertable(personalModel);
logger.Info("插入个人处理表，审核处理完成");
logger.Info("===创建审核结束===！");
return(true);
}
catch (Exception ex)
{
logger.Error("创建审核失败" + ex);
return(false);
}
}
/// <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);
}
}
/// <summary>
/// PMC处理
/// </summary>
/// <param name="supportModel"></param>
/// <param name="item"></param>
/// <param name="sid"></param>
/// <returns></returns>
private bool CreatePmcOrder(TASM_SUPPORT supportModel, ExcelModel item, int sid)
{
try
{
logger.Info("===创建PMC处理开始===！");
DataAccess.TASM_SUPPORT_PMC_Da supportPmcOrder = new TASM_SUPPORT_PMC_Da();
TASM_SUPPORT_PMC pmcModel = new TASM_SUPPORT_PMC();
pmcModel.BOOKNO = item.BookNo;
pmcModel.DELIVERY = ConventDateTime(item.Delivery);
pmcModel.SENDDATE = ConventDateTime(item.SendDate);
pmcModel.SENDNO = item.SendNo;
pmcModel.CONSIGNEE = item.Consignee;
pmcModel.STATUS = 0;
pmcModel.CREATETIME = DateTime.Now;
pmcModel.REMARKS = "导入数据";
int pmcid = supportPmcOrder.Db.Insertable(pmcModel).ExecuteReturnIdentity();
logger.Info("插入PMC处理表，处理完成");
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 = 1; //上一状态，订单初始创建，为0
supportHisModel.NEXT_STATUS = 2; //下一状态，订单初始创建 下一状态为 现场处理，状态0，此处创建订单不做为状态，默认创建 和 创建后未处理状态都是0
supportHisModel.TYPE = 2; //类型，也代表着是哪个表的数据 初始为0
supportHisModel.TID = pmcid; //数据id 根据type 那张表，看是哪一条数据。
supportHisModel.REMARKS = "PMC已处理,等待现场处理,导入数据";
supportHisModel.CREATETIME = DateTime.Now;
supportHis.Db.Insertable(supportHisModel);
logger.Info("插入历史表，PMC处理完成");
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 = 2;
personalModel.CREATETIME = DateTime.Now;
personalModel.REMARKS = "数据导入";
supportPersonal.Db.Insertable(personalModel);
logger.Info("插入个人处理表，PMC处理完成");
logger.Info("===创建PMC处理结束===！");
return(true);
}
catch (Exception ex)
{
logger.Error("创建Pmc失败" + ex);
return(false);
}
}
/// <summary>
/// 技术处理
/// </summary>
/// <param name="supportModel"></param>
/// <param name="item"></param>
/// <param name="sid"></param>
/// <param name="disid"></param>
/// <returns></returns>
private bool CreateDisposer(TASM_SUPPORT supportModel, ExcelModel item, int sid)
{
try
{
logger.Info("===创建现场处理开始===！");
//step3 现场处理表
TASM_SUPPORT_DISPOSER_Da supportDisposer = new TASM_SUPPORT_DISPOSER_Da();
TASM_SUPPORT_DISPOSER disposerModel = new TASM_SUPPORT_DISPOSER();
disposerModel.SID = sid;
disposerModel.ANALYZEUSER = GetUserIdByName(item.AnalyzeUserName);
disposerModel.ANALYZE = item.Analyze;
disposerModel.SOLUTION = item.Solution;
disposerModel.STATUS = 0;
disposerModel.REMARKS = "导入数据";
disposerModel.RESPONSIBLE = item.Responsible;
disposerModel.DUTY = item.Duty;
disposerModel.BOM = item.Bom;
disposerModel.ORDERMAN = item.OrderMan;
disposerModel.ORDERTIME = ConventDateTime(item.OrderTime);
disposerModel.ISORDER = item.IsOrder == "是" ? 1 : 0;
int disid = supportDisposer.Db.Insertable(disposerModel).ExecuteReturnIdentity();
logger.Info("插入技术处理表完成");
//step4 现场处理
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 = 0; //上一状态，订单初始创建，为0
supportHisModel.NEXT_STATUS = item.IsPmcPoint == "是" ? 2 : 1; //下一状态，订单初始创建 下一状态为 现场处理，状态0，此处创建订单不做为状态，默认创建 和 创建后未处理状态都是0
supportHisModel.TYPE = 1; //类型，也代表着是哪个表的数据 初始为0
supportHisModel.TID = disid; //数据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 = 0; //2代表现场完成，PMC 介入， 1则是 现场处理完成，无需PMC，直接跳到现场处理。
personalModel.CREATETIME = DateTime.Now;
personalModel.REMARKS = "数据导入";
supportPersonal.Db.Insertable(personalModel);
logger.Info("插入个人处理表，技术处理完成");
logger.Info("===创建现场处理结束===！");
return(true);
}
catch (Exception ex)
{
logger.Error("创建Disposer失败" + ex);
return(false);
}
}
