/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, StopreturnworkEntity entity) { //开始事务 var res = DbFactory.Base().BeginTrans(); try { entity.ID = keyValue; StopreturnworkEntity se = this.BaseRepository().FindEntity(keyValue); if (se == null) { entity.Create(); res.Insert <StopreturnworkEntity>(entity); } else { entity.Modify(keyValue); res.Update <StopreturnworkEntity>(entity); } Repository <OutsouringengineerEntity> ourEngineer = new Repository <OutsouringengineerEntity>(DbFactory.Base()); OutsouringengineerEntity engineerEntity = ourEngineer.FindEntity(entity.OUTENGINEERID); engineerEntity.STOPRETURNSTATE = "1"; res.Update <OutsouringengineerEntity>(engineerEntity); res.Commit(); } catch (System.Exception) { res.Rollback(); } }
/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, OutsouringengineerEntity entity) { try { service.SaveForm(keyValue, entity); } catch (Exception) { throw; } }
/// <summary> /// 删除数据 /// </summary> /// <param name="keyValue">主键</param> public void RemoveForm(string keyValue) { var res = DbFactory.Base().BeginTrans(); try { StopreturnworkEntity se = this.BaseRepository().FindEntity(keyValue); Repository <OutsouringengineerEntity> ourEngineer = new Repository <OutsouringengineerEntity>(DbFactory.Base()); OutsouringengineerEntity engineerEntity = ourEngineer.FindEntity(se.OUTENGINEERID); engineerEntity.STOPRETURNSTATE = "0"; res.Update <OutsouringengineerEntity>(engineerEntity); res.Delete <StopreturnworkEntity>(keyValue); res.Commit(); } catch (Exception) { res.Rollback(); } }
public ActionResult GetFormJson(string keyValue) { OutsouringengineerBLL engneerBll = new OutsouringengineerBLL(); var data = workMeetingbll.GetEntity(keyValue); if (data == null) { var loginUser = ERCHTMS.Code.OperatorProvider.Provider.Current(); OutsouringengineerEntity eEntity = null; if (loginUser.isEpiboly == true) { eEntity = engneerBll.GetEntity(loginUser.ProjectID); } data = new WorkMeetingEntity() { MEETINGDATE = DateTime.Now }; if (eEntity != null) { data.ENGINEERID = eEntity.ID; data.ENGINEERNAME = eEntity.ENGINEERNAME; data.ENGINEERLEVEL = eEntity.ENGINEERLEVEL; data.ENGINEERTYPE = eEntity.ENGINEERTYPE; data.ENGINEERAREA = eEntity.ENGINEERAREA; data.ENGINEERLETDEPT = eEntity.ENGINEERLETDEPT; data.ENGINEERCONTENT = eEntity.ENGINEERCONTENT; data.ENGINEERCODE = eEntity.ENGINEERCODE; data.MEETINGNAME = string.Format("{0}{1}开工会", DateTime.Now.ToString("yyyyMMdd"), data.ENGINEERNAME); } } var engneer = engneerBll.GetEntity(data.ENGINEERID); if (engneer != null) { data.OUTPROJECTNAME = new DepartmentBLL().GetEntity(engneer.OUTPROJECTID).FullName; } return(ToJsonResult(data)); }
private void ExportDataByCode(string keyValue, string tempPath, string fileName) { var userInfo = OperatorProvider.Provider.Current(); //获取当前用户 string strDocPath = Server.MapPath(tempPath); Aspose.Words.Document doc = new Aspose.Words.Document(strDocPath); DocumentBuilder builder = new DocumentBuilder(doc); DataSet ds = new DataSet(); DataTable dtPro = new DataTable("project"); dtPro.Columns.Add("EngineerName"); //外包工程名称 dtPro.Columns.Add("OUTPROJECTNAME"); //承包单位名称 dtPro.Columns.Add("OrgName"); //电厂名称 dtPro.Columns.Add("Reason"); //申请理由 dtPro.Columns.Add("AUDITSIGNIMG1"); //承包商单位负责人 dtPro.Columns.Add("AUDITOPINION1"); //部门负责人意见 dtPro.Columns.Add("AUDITSIGNIMG2"); //部门负责人签名 dtPro.Columns.Add("DATE1"); //部门审核时间 dtPro.Columns.Add("AUDITOPINION2"); //生技部负责人意见 dtPro.Columns.Add("AUDITSIGNIMG3"); //生技部负责人签名 dtPro.Columns.Add("DATE2"); //生技部审核时间 dtPro.Columns.Add("AUDITOPINION3"); //安环部负责人意见 dtPro.Columns.Add("AUDITSIGNIMG4"); //安环部负责人签名 dtPro.Columns.Add("DATE3"); //安环部审核时间 HttpResponse resp = System.Web.HttpContext.Current.Response; var sc = SafetyCollectbll.GetEntity(keyValue); DataRow row = dtPro.NewRow(); if (sc != null) { OutsouringengineerEntity eng = outsouringengineerbll.GetEntity(sc.EngineerId); OutsourcingprojectEntity pro = outProjectbll.GetOutProjectInfo(eng.OUTPROJECTID); row["EngineerName"] = eng.ENGINEERNAME; row["OUTPROJECTNAME"] = pro.OUTSOURCINGNAME; row["OrgName"] = userInfo.OrganizeName; row["Reason"] = sc.Reason; row["AUDITSIGNIMG1"] = eng.UnitSuper; //审核记录 List <AptitudeinvestigateauditEntity> list = aptitudeinvestigateauditbll.GetAuditList(keyValue); #region 通用版本审核记录 var i = 0; foreach (AptitudeinvestigateauditEntity entity in list) { i++; if (i == 1) { if (string.IsNullOrWhiteSpace(entity.AUDITSIGNIMG)) { row["AUDITSIGNIMG2"] = Server.MapPath("~/content/Images/no_1.png"); } else { var filepath = Server.MapPath("~/") + entity.AUDITSIGNIMG.ToString().Replace("../../", "").ToString(); if (System.IO.File.Exists(filepath)) { row["AUDITSIGNIMG2"] = filepath; } else { row["AUDITSIGNIMG2"] = Server.MapPath("~/content/Images/no_1.png"); } } builder.MoveToMergeField("AUDITSIGNIMG2"); builder.InsertImage(row["AUDITSIGNIMG2"].ToString(), 80, 35); row["AUDITOPINION1"] = !string.IsNullOrEmpty(entity.AUDITOPINION) ? entity.AUDITOPINION.ToString() : ""; row["DATE1"] = entity.AUDITTIME.Value.ToString("yyyy年MM月dd日"); } if (i == 2) { if (string.IsNullOrWhiteSpace(entity.AUDITSIGNIMG)) { row["AUDITSIGNIMG3"] = Server.MapPath("~/content/Images/no_1.png"); } else { var filepath = Server.MapPath("~/") + entity.AUDITSIGNIMG.ToString().Replace("../../", "").ToString(); if (System.IO.File.Exists(filepath)) { row["AUDITSIGNIMG3"] = filepath; } else { row["AUDITSIGNIMG3"] = Server.MapPath("~/content/Images/no_1.png"); } } builder.MoveToMergeField("AUDITSIGNIMG3"); builder.InsertImage(row["AUDITSIGNIMG3"].ToString(), 80, 35); row["AUDITOPINION2"] = !string.IsNullOrEmpty(entity.AUDITOPINION) ? entity.AUDITOPINION.ToString() : ""; row["DATE2"] = entity.AUDITTIME.Value.ToString("yyyy年MM月dd日"); } if (i == 3) { if (string.IsNullOrWhiteSpace(entity.AUDITSIGNIMG)) { row["AUDITSIGNIMG4"] = Server.MapPath("~/content/Images/no_1.png"); } else { var filepath = Server.MapPath("~/") + entity.AUDITSIGNIMG.ToString().Replace("../../", "").ToString(); if (System.IO.File.Exists(filepath)) { row["AUDITSIGNIMG4"] = filepath; } else { row["AUDITSIGNIMG4"] = Server.MapPath("~/content/Images/no_1.png"); } } builder.MoveToMergeField("AUDITSIGNIMG4"); builder.InsertImage(row["AUDITSIGNIMG4"].ToString(), 80, 35); row["AUDITOPINION3"] = !string.IsNullOrEmpty(entity.AUDITOPINION) ? entity.AUDITOPINION.ToString() : ""; row["DATE3"] = entity.AUDITTIME.Value.ToString("yyyy年MM月dd日"); } } #endregion } dtPro.Rows.Add(row); doc.MailMerge.Execute(dtPro); doc.MailMerge.DeleteFields(); doc.Save(resp, Server.UrlEncode(fileName), Aspose.Words.ContentDisposition.Attachment, Aspose.Words.Saving.SaveOptions.CreateSaveOptions(SaveFormat.Doc)); }
private void ExportDataByCode(string keyValue, string tempPath, string fileName) { var userInfo = OperatorProvider.Provider.Current(); //获取当前用户 string strDocPath = Server.MapPath(tempPath); Aspose.Words.Document doc = new Aspose.Words.Document(strDocPath); DataSet ds = new DataSet(); DataTable dtPro = new DataTable("project"); dtPro.Columns.Add("untilname");//单位名称 dtPro.Columns.Add("legalperson");//法人代表 dtPro.Columns.Add("projectname");//工程名称 dtPro.Columns.Add("nowtime"); dtPro.Columns.Add("itemopinion"); dtPro.Columns.Add("itemhead"); //项目负责人 dtPro.Columns.Add("techhead"); //生成技术负责人 dtPro.Columns.Add("safehead"); //安全监督负责人 dtPro.Columns.Add("contractperiod");//合同期限 dtPro.Columns.Add("dutydept");//项目管理部门 dtPro.Columns.Add("applyperson");//制表人 dtPro.Columns.Add("applytime");//制表时间 dtPro.Columns.Add("outhead"); DataTable dt = new DataTable("people"); dt.Columns.Add("no"); dt.Columns.Add("name"); dt.Columns.Add("sex"); dt.Columns.Add("idcard"); dt.Columns.Add("worktype"); dt.Columns.Add("health"); dt.Columns.Add("workyear"); dt.Columns.Add("education"); dt.Columns.Add("birthday"); dt.Columns.Add("cardno"); HttpResponse resp = System.Web.HttpContext.Current.Response; PeopleReviewEntity p = peoplereviewbll.GetEntity(keyValue); OutsouringengineerEntity eng = Outsouringengineernll.GetEntity(p.OUTENGINEERID); OutsourcingprojectEntity pro = Outsourcingprojectbll.GetOutProjectInfo(eng.OUTPROJECTID); DataRow row = dtPro.NewRow(); var comList = new CompactBLL().GetComoactTimeByProjectId(eng.ID); if (comList.Rows.Count > 0) { var startTime = string.Empty; DateTime r = new DateTime(); if (DateTime.TryParse(comList.Rows[0]["mintime"].ToString(), out r)) { startTime = r.ToString("yyyy年MM月dd日"); } var endTime = string.Empty; DateTime e= new DateTime(); if (DateTime.TryParse(comList.Rows[0]["maxtime"].ToString(), out e)) { endTime = e.ToString("yyyy年MM月dd日"); } row["contractperiod"] = startTime + "至" + endTime; } row["untilname"] = pro.OUTSOURCINGNAME; row["legalperson"] = pro.LEGALREP; row["projectname"] = eng.ENGINEERNAME; row["nowtime"] = DateTime.Now.ToString("yyyy-MM-dd"); row["dutydept"] = eng.ENGINEERLETDEPT; row["applyperson"] = p.CREATEUSERNAME; row["applytime"] = p.CREATEDATE.Value.ToString("yyyy年MM月dd日"); var sendDeptid = eng.ENGINEERLETDEPTID; List<AptitudeinvestigateauditEntity> list = auditbll.GetAuditList(keyValue).OrderByDescending(x => x.AUDITTIME).ToList(); if (list.Count > 0) { for (int i = 0; i < list.Count; i++) { if (sendDeptid == list[i].AUDITDEPTID) { var person = new UserBLL().GetEntity(list[i].AUDITPEOPLEID); if (person != null) { //if (person.RoleName.Contains("负责人")) //{ row["itemopinion"] = list[i].AUDITOPINION; row["itemhead"] = list[i].AUDITPEOPLE; //} } } if (eng.OUTPROJECTID == list[i].AUDITDEPTID) { var person = new UserBLL().GetEntity(list[i].AUDITPEOPLEID); if (person != null) { if (person.RoleName.Contains("负责人")) { row["outhead"] = list[i].AUDITPEOPLE; } } } string val = new DataItemDetailBLL().GetItemValue(userInfo.OrganizeCode); if (!string.IsNullOrEmpty(val)) { var deptList = val.Split(','); if (deptList.Length > 1) { if (list[i].AUDITDEPTID.ToString() == deptList[0]) { row["techhead"] = list[i].AUDITPEOPLE; } if (list[i].AUDITDEPTID == deptList[1]) { row["safehead"] = list[i].AUDITPEOPLE; } } } } } dtPro.Rows.Add(row); List<AptitudeinvestigatepeopleEntity> PeopleList = new AptitudeinvestigatepeopleBLL().GetList("").Where(x => x.PEOPLEREVIEWID == keyValue).ToList(); if (PeopleList.Count > 0) { for (int i = 0; i < PeopleList.Count; i++) { DataRow dtrow = dt.NewRow(); dtrow["no"] = (i + 1); dtrow["name"] = PeopleList[i].REALNAME; dtrow["sex"] = PeopleList[i].GENDER; dtrow["idcard"] = PeopleList[i].IDENTIFYID; dtrow["worktype"] = PeopleList[i].WORKOFTYPE; dtrow["health"] = PeopleList[i].STATEOFHEALTH; dtrow["workyear"] = PeopleList[i].WORKYEAR; dtrow["education"] = PeopleList[i].DEGREESID; dtrow["birthday"] = PeopleList[i].BIRTHDAY == null ? "" : PeopleList[i].BIRTHDAY.Value.ToString("yyyy-MM-dd"); string queryJson = Newtonsoft.Json.JsonConvert.SerializeObject(new { UserId = PeopleList[i].ID }); var cardlist = new CertificateinspectorsBLL().GetList(queryJson).ToList(); for (int j = 0; j < cardlist.Count; j++) { dtrow["cardno"] += cardlist[j].CREDENTIALSCODE + ","; } if (dtrow["cardno"].ToString().Length > 0) { dtrow["cardno"] = dtrow["cardno"].ToString().Substring(0, dtrow["cardno"].ToString().Length - 1); } dt.Rows.Add(dtrow); } } ds.Tables.Add(dt); ds.Tables.Add(dtPro); doc.MailMerge.Execute(dtPro); doc.MailMerge.ExecuteWithRegions(dt); doc.MailMerge.DeleteFields(); doc.Save(resp, Server.UrlEncode(fileName), ContentDisposition.Attachment, Aspose.Words.Saving.SaveOptions.CreateSaveOptions(SaveFormat.Doc)); }
public void ExportReport(string keyValue) { try { var userInfo = OperatorProvider.Provider.Current(); //获取当前用户 string strDocPath = Server.MapPath("~/Resource/ExcelTemplate/人员资质审批表华润版本.doc"); string fileName = "相关方施工人员进厂申请表_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".doc"; Aspose.Words.Document doc = new Aspose.Words.Document(strDocPath); DocumentBuilder builder = new DocumentBuilder(doc); DataSet ds = new DataSet(); DataTable dtPro = new DataTable("project"); dtPro.Columns.Add("createdate");//申请时间 dtPro.Columns.Add("outsourcingproject");//单位名称 dtPro.Columns.Add("outsouringengineer");//工程名称 dtPro.Columns.Add("predicttime");//计划工期 dtPro.Columns.Add("engineerdirector");//施工负责人 dtPro.Columns.Add("workpeoplecount"); //施工人数 dtPro.Columns.Add("engineerletdeptid"); //用工部门 dtPro.Columns.Add("linkman"); //联系人 dtPro.Columns.Add("ygauditidea");//用工部门审核意见 dtPro.Columns.Add("ygauditdate");//用工部门审核时间 dtPro.Columns.Add("ehsauditidea");//EHS部审核意见 dtPro.Columns.Add("ehsauditdate");//EHS部审核时间 dtPro.Columns.Add("bgsauditidea");//办公室审核意见 dtPro.Columns.Add("bgsauditdate");//办公室审核时间 HttpResponse resp = System.Web.HttpContext.Current.Response; PeopleReviewEntity p = peoplereviewbll.GetEntity(keyValue); OutsouringengineerEntity eng = Outsouringengineernll.GetEntity(p.OUTENGINEERID); OutsourcingprojectEntity pro = Outsourcingprojectbll.GetOutProjectInfo(eng.OUTPROJECTID); DataRow row = dtPro.NewRow(); row["createdate"] =Convert.ToDateTime(p.CREATEDATE).ToString("yyyy年MM月dd日"); row["outsourcingproject"] = pro.OUTSOURCINGNAME; row["outsouringengineer"] = eng.ENGINEERNAME; row["predicttime"] = eng.PREDICTTIME; row["engineerdirector"] = eng.ENGINEERDIRECTOR; row["engineerletdeptid"] = eng.ENGINEERLETDEPT; row["linkman"] = pro.LINKMAN; row["workpeoplecount"] = aptitudeinvestigatepeoplebll.GetList("").Where(t => t.PEOPLEREVIEWID == keyValue).Count(); List<AptitudeinvestigateauditEntity> list = auditbll.GetAuditList(keyValue).OrderByDescending(x => x.AUDITTIME).ToList(); string pic = Server.MapPath("~/content/Images/no_1.png");//默认图片 if (list.Count > 0) { for (int i = 0; i < list.Count; i++) { var filepath = list[i].AUDITSIGNIMG == null ? "" : (Server.MapPath("~/") + list[i].AUDITSIGNIMG.ToString().Replace("../../", "").ToString()).Replace(@"\/", "/").ToString(); var stime = Convert.ToDateTime(list[i].AUDITTIME); if (i == 0) { row["ygauditidea"] = list[i].AUDITOPINION; //zauditusername = list[i].AuditUserName; builder.MoveToMergeField("ygauditusername"); row["ygauditdate"] = stime.ToString("yyyy年MM月dd日"); } else if (i == 1) { row["ehsauditidea"] = list[i].AUDITOPINION; //sauditusername = list[i].AuditUserName; builder.MoveToMergeField("ehsauditusername"); row["ehsauditdate"] = stime.ToString("yyyy年MM月dd日"); } else if (i == 2) { row["bgsauditidea"] = list[i].AUDITOPINION; //aauditusername = list[i].AuditUserName; builder.MoveToMergeField("bgsauditusername"); row["bgsauditdate"] = stime.ToString("yyyy年MM月dd日"); } if (!System.IO.File.Exists(filepath)) { filepath = pic; } builder.InsertImage(filepath, 80, 35); } } dtPro.Rows.Add(row); doc.MailMerge.Execute(dtPro); doc.MailMerge.DeleteFields(); doc.Save(resp, Server.UrlEncode(fileName), ContentDisposition.Attachment, Aspose.Words.Saving.SaveOptions.CreateSaveOptions(SaveFormat.Doc)); } catch (Exception ex) { throw; } }
/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, string type, ToolsEntity entity) { Operator curUser = ERCHTMS.Code.OperatorProvider.Provider.Current(); var res = DbFactory.Base().BeginTrans(); try { List <ProjecttoolsEntity> list = ProjecttoolsService.GetList(" and TOOLSID='" + keyValue + "'").ToList(); List <string> zylist = new List <string>(); string zystr = ""; foreach (var item in list.Select(t => t.TOOLTYPE).ToArray().Distinct().ToList()) { zylist = zylist.AsEnumerable().Union(DataItemDetailService.GetDataItemByDetailValue("ToolEquipmentType", item).FirstOrDefault().Description.Split(',')).ToList(); } zystr = string.Join(",", zylist.Distinct().ToList()); entity.SpecialtyType = zystr; #region 保存 if (type == "1") //保存 { entity.ISSAVED = "0"; //标记当前记录处于登记阶段 entity.ISOVER = "0"; //流程未完成,1表示完成 entity.TOOLSID = keyValue; if (!string.IsNullOrEmpty(keyValue)) { ToolsEntity se = this.BaseRepository().FindEntity(keyValue); if (se == null) { entity.Create(); res.Insert <ToolsEntity>(entity); } else { entity.Modify(keyValue); res.Update <ToolsEntity>(entity); } } else { entity.Create(); res.Insert <ToolsEntity>(entity); } } #endregion #region 提交 if (type == "2")//提交 { string state = string.Empty; string moduleName = entity.EQUIPTYPE == "2" ? "特种设备工器具" : "设备工器具"; string outengineerid = entity.OUTENGINEERID; Repository <OutsouringengineerEntity> ourEngineer = new Repository <OutsouringengineerEntity>(DbFactory.Base()); OutsouringengineerEntity engineerEntity = ourEngineer.FindEntity(entity.OUTENGINEERID); //currUser:当前登录人,state:是否有权限审核 1:能审核 0 :不能审核,moduleName:模块名称,outengineerid:工程Id ManyPowerCheckEntity mpcEntity = peopleReview.CheckAuditPower(curUser, out state, moduleName, outengineerid, false); if (null != mpcEntity) { //保存设备工器具记录 entity.FLOWDEPT = mpcEntity.CHECKDEPTID; entity.FLOWDEPTNAME = mpcEntity.CHECKDEPTNAME; entity.FLOWROLE = mpcEntity.CHECKROLEID; entity.FLOWROLENAME = mpcEntity.CHECKROLENAME; entity.ISSAVED = "1"; //标记已经从登记到审核阶段 entity.ISOVER = "0"; //流程未完成,1表示完成 entity.FlowId = mpcEntity.ID; entity.FLOWNAME = mpcEntity.FLOWNAME; } else //为空则表示已经完成流程 { entity.FLOWDEPT = ""; entity.FLOWDEPTNAME = ""; entity.FLOWROLE = ""; entity.FLOWROLENAME = ""; entity.ISSAVED = "1"; //标记已经从登记到审核阶段 entity.ISOVER = "1"; //流程未完成,1表示完成 entity.FLOWNAME = ""; entity.FlowId = ""; #region 更新工程流程状态 Repository <StartappprocessstatusEntity> proecss = new Repository <StartappprocessstatusEntity>(DbFactory.Base()); StartappprocessstatusEntity startProecss = proecss.FindList(string.Format("select * from epg_startappprocessstatus t where t.outengineerid='{0}'", entity.OUTENGINEERID)).ToList().FirstOrDefault(); startProecss.EQUIPMENTTOOLSTATUS = "1"; res.Update <StartappprocessstatusEntity>(startProecss); #endregion #region 步设备 if (entity.EQUIPTYPE == "2") { new SpecialEquipmentService().SyncSpecificTools(entity.OUTENGINEERID, entity.OUTPROJECTID, entity.TOOLSID); } #endregion } entity.TOOLSID = keyValue; if (!string.IsNullOrEmpty(keyValue)) { ToolsEntity se = this.BaseRepository().FindEntity(keyValue); if (se == null) { entity.Create(); res.Insert <ToolsEntity>(entity); } else { entity.Modify(keyValue); res.Update <ToolsEntity>(entity); } } else { entity.Create(); res.Insert <ToolsEntity>(entity); } } #endregion res.Commit(); } catch (Exception ex) { res.Rollback(); throw ex; } }
/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, ReturntoworkEntity entity) { Operator currUser = OperatorProvider.Provider.Current(); //开始事务 var res = DbFactory.Base().BeginTrans(); try { entity.ID = keyValue; ReturntoworkEntity re = this.BaseRepository().FindEntity(keyValue); if (re == null) { entity.Create(); string sql = string.Format("select * from epg_returntowork t where t.createuserorgcode ='{0}'", entity.CREATEUSERORGCODE); int Code = this.BaseRepository().FindList(sql).ToList().Count; switch (Code.ToString().Length) { case 1: entity.APPLYNO = "FG000" + (Code + 1); break; case 2: entity.APPLYNO = "FG00" + (Code + 1); break; case 3: entity.APPLYNO = "FG0" + (Code + 1); break; default: entity.APPLYNO = "FG" + (Code + 1); break; } res.Insert <ReturntoworkEntity>(entity); } else { entity.Modify(keyValue); res.Update <ReturntoworkEntity>(entity); } if (entity.ISCOMMIT == "1") { var sendDeptid = new DepartmentService().GetList().Where(x => x.DepartmentId == entity.OUTPROJECTID).ToList().FirstOrDefault().SendDeptID; if (currUser.RoleName.Contains("公司级用户") || currUser.RoleName.Contains("厂级部门用户") || (sendDeptid == currUser.DeptId && currUser.RoleName.Contains("负责人")) || (sendDeptid == currUser.DeptId && currUser.RoleName.Contains("安全管理人员"))) { AptitudeinvestigateauditEntity e = new AptitudeinvestigateauditEntity(); e.AUDITDEPT = currUser.DeptId; e.AUDITDEPT = currUser.DeptName; e.AUDITPEOPLE = currUser.UserName; e.AUDITPEOPLEID = currUser.UserId; e.AUDITRESULT = "0"; e.APTITUDEID = entity.ID; e.ID = Guid.NewGuid().ToString(); res.Insert <AptitudeinvestigateauditEntity>(e); Repository <OutsouringengineerEntity> ourEngineer = new Repository <OutsouringengineerEntity>(DbFactory.Base()); OutsouringengineerEntity engineerEntity = ourEngineer.FindEntity(entity.OUTENGINEERID); engineerEntity.STOPRETURNSTATE = "0"; res.Update <OutsouringengineerEntity>(engineerEntity); } } res.Commit(); } catch (System.Exception) { res.Rollback(); } }
/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, string state, string auditid, SafetyEamestMoneyEntity entity, List <SafetyMoneyExamineEntity> list) { var res = DbFactory.Base().BeginTrans(); try { Operator currUser = OperatorProvider.Provider.Current(); entity.ID = keyValue; entity.ISSEND = state; if (!string.IsNullOrEmpty(keyValue)) { SafetyEamestMoneyEntity se = this.BaseRepository().FindEntity(keyValue); if (se == null) { entity.Create(); res.Insert <SafetyEamestMoneyEntity>(entity); } else { entity.Modify(keyValue); res.Update <SafetyEamestMoneyEntity>(entity); } } else { entity.Create(); res.Insert <SafetyEamestMoneyEntity>(entity); } //1发送审核,0保存 if (state == "1") { Repository <OutsouringengineerEntity> repEng = new Repository <OutsouringengineerEntity>(DbFactory.Base()); OutsouringengineerEntity outeng = repEng.FindEntity(entity.PROJECTID); var sendDeptid = outeng.ENGINEERLETDEPTID; if (currUser.RoleName.Contains("公司级用户") || currUser.RoleName.Contains("厂级部门用户") || (sendDeptid == currUser.DeptId && currUser.RoleName.Contains("负责人")) || (sendDeptid == currUser.DeptId && currUser.RoleName.Contains("安全管理员")) || (sendDeptid == currUser.DeptId && currUser.RoleName.Contains("专工"))) { AptitudeinvestigateauditEntity e = new AptitudeinvestigateauditEntity(); if (!string.IsNullOrEmpty(auditid)) { e = Aptitudeinvestigateaudit.GetEntity(auditid); e.AUDITDEPT = currUser.DeptId; e.AUDITDEPT = currUser.DeptName; e.AUDITPEOPLE = currUser.UserName; e.AUDITPEOPLEID = currUser.UserId; e.AUDITRESULT = "0"; } else { e.AUDITRESULT = "0"; e.AUDITDEPT = currUser.DeptId; e.AUDITDEPT = currUser.DeptName; e.AUDITPEOPLE = currUser.UserName; e.AUDITPEOPLEID = currUser.UserId; e.APTITUDEID = entity.ID; //Aptitudeinvestigateaudit.SaveForm(auditid, e); } Aptitudeinvestigateaudit.SaveForm(auditid, e); Repository <StartappprocessstatusEntity> proecss = new Repository <StartappprocessstatusEntity>(DbFactory.Base()); StartappprocessstatusEntity startProecss = proecss.FindList(string.Format("select * from epg_startappprocessstatus t where t.outengineerid='{0}'", entity.PROJECTID)).ToList().FirstOrDefault(); startProecss.SECURITYSTATUS = "1"; startprocess.SaveForm(startProecss.ID, startProecss); } else { AptitudeinvestigateauditEntity e = new AptitudeinvestigateauditEntity(); if (!string.IsNullOrEmpty(auditid)) { e = Aptitudeinvestigateaudit.GetEntity(auditid); e.AUDITDEPT = currUser.DeptId; e.AUDITDEPT = currUser.DeptName; e.AUDITPEOPLE = currUser.UserName; e.AUDITPEOPLEID = currUser.UserId; e.AUDITRESULT = "2"; Aptitudeinvestigateaudit.SaveForm(auditid, e); } else { e.AUDITRESULT = "2"; e.AUDITDEPT = currUser.DeptId; e.AUDITDEPT = currUser.DeptName; e.AUDITPEOPLE = currUser.UserName; e.AUDITPEOPLEID = currUser.UserId; e.APTITUDEID = entity.ID; Aptitudeinvestigateaudit.SaveForm(auditid, e); } } } //string sql = string.Format("delete epg_safetymoneyexamine t where t.safetymoneyid='{0}'", keyValue); //res.ExecuteBySql(sql); if (list.Count > 0) { for (int i = 0; i < list.Count; i++) { list[i].Create(); list[i].ExamineDept = currUser.DeptName; list[i].ExamineDeptId = currUser.DeptId; list[i].ExamineToDept = entity.DEPTNAME; list[i].ExamineToDeptId = entity.DEPTID; } res.Insert <SafetyMoneyExamineEntity>(list); } res.Commit(); } catch (System.Exception) { res.Rollback(); } }