public void InsertListData(Entity.ModifyList md) { DataAccess.ModifyList daMD = new ModifyList(); if (daMD.Exists(md.ListID)) { daMD.Update(md); } else { daMD.Add(md); } }
public void ChangeFlow(Entity.JobInfo job) { DataTable handle = new HandleList().GetList("JobID='" + job.JobID + "'").Tables[0]; Entity.FlowInfo flowNow = new FlowInfo().DataRowToModel(new FlowInfo().GetList("JobID='" + job.JobID + "' and IsDelete=0 order by SubmitDate desc").Tables[0].Rows[0]); DataAccess.TranHelper.BeginTran(); bool IsChange = false; switch (flowNow.FlowID) { case 7: #region 当流程处于7(工单已受理)时 //是否资料已经确认 if (handle.Select("OpeartionID=11 and IsChecked=1").Length > 0) { bool isChange = new ModifyList().GetList("IsDelete=0 and IsChangeName=1 and JobID='" + job.JobID + "'").Tables[0].Rows.Count > 0 ? true : false; //是否变更法人名或企业名 if (isChange) { //将流程从7修改成8 Entity.FlowInfo flowSP = new Entity.FlowInfo(); flowSP.Guid = Guid.NewGuid().ToString(); flowSP.JobID = job.JobID; flowSP.FlowID = 8; flowSP.SubmitDate = DateTime.Now; flowSP.SubmitUser = handle.Select("OpeartionID=11 and IsChecked=1")[0]["OpeartionUser"].ToString(); flowSP.Content = handle.Select("OpeartionID=11 and IsChecked=1")[0]["Remark"].ToString(); flowSP.IsDelete = false; new FlowInfo().Add(flowSP); IsChange = true; if ((bool)job.ExpressFlat) { //是否资料确认、收卡、制卡、快递 if (handle.Select("OpeartionID=11 and IsChecked=1").Length > 0 && handle.Select("FunctionID='A07' and IsChecked=1").Length > 0 && handle.Select("OpeartionID=14 and IsChecked=1").Length > 0 && handle.Select("OpeartionID=10 and IsChecked=1").Length > 0) { //将流程从8修改为6 Entity.FlowInfo flow = new Entity.FlowInfo(); flow.Guid = Guid.NewGuid().ToString(); flow.JobID = job.JobID; flow.FlowID = 6; flow.SubmitDate = DateTime.Now; flow.SubmitUser = handle.Select("OpeartionID=10 and IsChecked=1")[0]["OpeartionUser"].ToString(); flow.Content = handle.Select("OpeartionID=10 and IsChecked=1")[0]["Remark"].ToString(); flow.IsDelete = false; new FlowInfo().Add(flow); IsChange = true; } } else { //是否资料确认、收卡、制卡 if (handle.Select("OpeartionID=11 and IsChecked=1").Length > 0 && handle.Select("FunctionID='A07' and IsChecked=1").Length > 0 && handle.Select("OpeartionID=14 and IsChecked=1").Length > 0) { if (handle.Select("OpeartionID=9 and IsChecked=1").Length > 0) { //将流程从8修改为5 Entity.FlowInfo flow = new Entity.FlowInfo(); flow.Guid = Guid.NewGuid().ToString(); flow.JobID = job.JobID; flow.FlowID = 5; flow.SubmitDate = DateTime.Now; flow.SubmitUser = handle.Select("OpeartionID=9 and IsChecked=1")[0]["OpeartionUser"].ToString(); flow.Content = handle.Select("OpeartionID=9 and IsChecked=1")[0]["Remark"].ToString(); flow.IsDelete = false; new FlowInfo().Add(flow); IsChange = true; } else { //将流程从8修改为11 Entity.FlowInfo flow = new Entity.FlowInfo(); flow.Guid = Guid.NewGuid().ToString(); flow.JobID = job.JobID; flow.FlowID = 11; flow.SubmitDate = DateTime.Now; flow.SubmitUser = handle.Select("", "OpeartionTime desc")[0]["OpeartionUser"].ToString(); flow.IsDelete = false; new FlowInfo().Add(flow); IsChange = true; } } } } else { //将流程从7修改成9 Entity.FlowInfo flow = new Entity.FlowInfo(); flow.Guid = Guid.NewGuid().ToString(); flow.JobID = job.JobID; flow.FlowID = 9; flow.SubmitDate = DateTime.Now; flow.SubmitUser = handle.Select("OpeartionID=11 and IsChecked=1")[0]["OpeartionUser"].ToString(); flow.Content = handle.Select("OpeartionID=11 and IsChecked=1")[0]["Remark"].ToString(); flow.IsDelete = false; new FlowInfo().Add(flow); IsChange = true; } } #endregion break; case 8: #region 当流程处于8(资料已去确认)时 //是否快递领取 if ((bool)job.ExpressFlat) { //是否资料确认、收卡、制卡、快递 if (handle.Select("OpeartionID=11 and IsChecked=1").Length > 0 && handle.Select("FunctionID='A07' and IsChecked=1").Length > 0 && handle.Select("OpeartionID=14 and IsChecked=1").Length > 0 && handle.Select("OpeartionID=10 and IsChecked=1").Length > 0) { //将流程从8修改为6 Entity.FlowInfo flow = new Entity.FlowInfo(); flow.Guid = Guid.NewGuid().ToString(); flow.JobID = job.JobID; flow.FlowID = 6; flow.SubmitDate = DateTime.Now; flow.SubmitUser = handle.Select("OpeartionID=10 and IsChecked=1")[0]["OpeartionUser"].ToString(); flow.Content = handle.Select("OpeartionID=10 and IsChecked=1")[0]["Remark"].ToString(); flow.IsDelete = false; new FlowInfo().Add(flow); IsChange = true; } } else { //是否资料确认、收卡、制卡 if (handle.Select("OpeartionID=11 and IsChecked=1").Length > 0 && handle.Select("FunctionID='A07' and IsChecked=1").Length > 0 && handle.Select("OpeartionID=14 and IsChecked=1").Length > 0) { if (handle.Select("OpeartionID=9 and IsChecked=1").Length > 0) { //将流程从8修改为5 Entity.FlowInfo flow = new Entity.FlowInfo(); flow.Guid = Guid.NewGuid().ToString(); flow.JobID = job.JobID; flow.FlowID = 5; flow.SubmitDate = DateTime.Now; flow.SubmitUser = handle.Select("OpeartionID=9 and IsChecked=1")[0]["OpeartionUser"].ToString(); flow.Content = handle.Select("OpeartionID=9 and IsChecked=1")[0]["Remark"].ToString(); flow.IsDelete = false; new FlowInfo().Add(flow); IsChange = true; } else { //将流程从8修改为11 Entity.FlowInfo flow = new Entity.FlowInfo(); flow.Guid = Guid.NewGuid().ToString(); flow.JobID = job.JobID; flow.FlowID = 11; flow.SubmitDate = DateTime.Now; flow.SubmitUser = handle.Select("", "OpeartionTime desc")[0]["OpeartionUser"].ToString(); flow.IsDelete = false; new FlowInfo().Add(flow); IsChange = true; } } } #endregion break; case 11: #region 当流程处于11(等待现场领取)时 //是否已现场领取 if (handle.Select("OpeartionID=9 and IsChecked=1").Length > 0) { //将流程从11修改为5 Entity.FlowInfo flow = new Entity.FlowInfo(); flow.Guid = Guid.NewGuid().ToString(); flow.JobID = job.JobID; flow.FlowID = 5; flow.SubmitDate = DateTime.Now; flow.SubmitUser = handle.Select("OpeartionID=9 and IsChecked=1")[0]["OpeartionUser"].ToString(); flow.Content = handle.Select("OpeartionID=9 and IsChecked=1")[0]["Remark"].ToString(); flow.IsDelete = false; new FlowInfo().Add(flow); IsChange = true; } #endregion break; } try { DataAccess.TranHelper.CommitTran(); if (IsChange) { DataAccess.CardCenterHelper.SendMessage(job.JobID); } } catch (Exception ex) { throw new Exception("流程提交失败!" + ex.ToString()); } }