public bool Update(User2Model model) { string msgError = ""; try { var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "user_update", "@user_id", model.user_id, "@hoten", model.hoten, "@ngaysinh", model.ngaysinh, "@diachi", model.diachi, "@gioitinh", model.gioitinh, "@email", model.email, "@taikhoan", model.taikhoan, "@matkhau", model.matkhau, "@role", model.role, "@image_url", model.image_url); if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError)) { throw new Exception(Convert.ToString(result) + msgError); } return(true); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据流程id获取整个流程的岗位人员 /// </summary> /// <param name="refbillPhid">单据主键</param> /// <param name="procPhid">流程id</param> /// <returns></returns> public List <GAppvalPostModel> GetBackApprovalPost2(long refbillPhid, long procPhid) { List <GAppvalPostModel> postModels = new List <GAppvalPostModel>(); postModels.Add(new GAppvalPostModel { PhId = 0, FName = "发起人" }); //当前审批流程的所有审批岗位 List <GAppvalPostModel> allPosts = GAppvalPostFacade.FindAppvalPostByProcID(procPhid).OrderBy(t => t.Seq).ToList(); postModels.AddRange(allPosts); foreach (GAppvalPostModel postModel in postModels) { if (postModel.PhId == 0) { if (refbillPhid == 0) { postModel.Operators = null; } else { try { List <GAppvalPost4OperModel> operModels = new List <GAppvalPost4OperModel>(); GAppvalRecordModel model = GAppvalRecordFacade.Find(t => t.RefbillPhid == refbillPhid && t.PostPhid == 0 && t.FBilltype == BillType.BeginProject).Data.ToList().OrderByDescending(t => t.FSendDate).ToList()[0]; User2Model user = UserFacade.Find(model.OperaPhid).Data; operModels.Add(new GAppvalPost4OperModel { PostPhid = 0, OperatorPhid = user.PhId, OperatorName = user.UserName }); postModel.Operators = operModels; } catch (Exception e) { throw new Exception("查询发起人失败!"); } } } else { try { postModel.Operators = GAppvalPost4OperFacade.GetOperatorsByPostID(postModel.PhId); } catch (Exception e) { throw new Exception("根据岗位id查找操作失败!"); } } } return(postModels); }
/// <summary> /// 根据id获取用户 /// </summary> /// <param name="userid"></param> /// <returns></returns> public User2Model GetUser(long userid) { if (userid != 0) { User2Model user = UserFacade.Find(userid).Data; return(user); } else { return(null); } }
public string GetAllReportExcel([FromUri] BaseListModel param) { if (param.orgid == 0) { return(DCHelper.ErrorMessage("组织id不能为空!")); } if (param.uid == 0) { return(DCHelper.ErrorMessage("用户id不能为空!")); } if (string.IsNullOrEmpty(param.orgCode)) { return(DCHelper.ErrorMessage("组织编码不能为空!")); } if (string.IsNullOrEmpty(param.Year)) { return(DCHelper.ErrorMessage("年份参数不能为空!")); } try { string result = ""; YsAccountMstModel ysAccountMst = new YsAccountMstModel(); ysAccountMst = this.YsAccountMstService.GetAllYsAccountList(param.orgid, param.orgCode, param.Year, param.ChooseOwn, param.value); if (ysAccountMst.YsAccounts != null && ysAccountMst.YsAccounts.Count > 0) { //获取组织和用户信息 User2Model userModel = new User2Model(); OrganizeModel organizeModel = new OrganizeModel(); userModel = this.BudgetMstService.GetUser(param.uid); organizeModel = this.BudgetMstService.GetOrganize(param.orgid); if (param.value == "1") { result = this.YsAccountMstService.GetBeginExcel(ysAccountMst.YsAccounts.ToArray(), null, userModel, organizeModel); } else if (param.value == "2") { result = this.YsAccountMstService.GetMiddleExcel(ysAccountMst.YsAccounts.ToArray(), null, userModel, organizeModel); } else if (param.value == "3") { result = this.YsAccountMstService.GetEndExcel(ysAccountMst.YsAccounts.ToArray(), null, userModel, organizeModel); } } return(result); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public User2Model UpdateUser([FromBody] User2Model model) { if (model.image_url != null) { var arrData = model.image_url.Split(';'); if (arrData.Length == 3) { var savePath = $@"assets/images/{arrData[0]}"; model.image_url = $"{savePath}"; SaveFileFromBase64String(savePath, arrData[2]); } } _userBusiness.Create(model); return(model); }
/// <summary> /// 不删除设置对应关系 /// </summary> /// <param name="ProductBZ"></param> /// <returns></returns> public CommonResult SaveByProductNoDelete(string ProductBZ) { CommonResult result = new CommonResult(); try { Dictionary <string, object> dic = new Dictionary <string, object>(); new CreateCriteria(dic).Add(ORMRestrictions <EnumUserStatus> .Eq("Status", EnumUserStatus.Activate)); //var Users = UserFacade.FacadeHelper.LoadWithPageInfinity("GQT.QT.GetAllUsers", dic2); var Users = UserFacade.Find(dic).Data; for (var i = 0; i < Users.Count; i++) { User2Model user = Users[i]; Dictionary <string, object> dic2 = new Dictionary <string, object>(); new CreateCriteria(dic2).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ)) .Add(ORMRestrictions <string> .Eq("Fg3userno", user.UserNo)); var IfDYGX = base.Find(dic2).Data; Dictionary <string, object> dic3 = new Dictionary <string, object>(); new CreateCriteria(dic3).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ)) .Add(ORMRestrictions <string> .Eq("ProductUserCode", user.UserNo)); var IfUser = QTProductUserFacade.Find(dic3).Data; if (IfDYGX.Count == 0 && IfUser.Count > 0) { QTProductUserModel qTProductUserModel = IfUser[0]; QTProductUserDygxModel qTProductUserDygxModel = new QTProductUserDygxModel { ProductBZ = ProductBZ, ProductUserCode = user.UserNo, ProductPhid = qTProductUserModel.ProductPhid, ProductUserPhid = qTProductUserModel.PhId, ProductUserName = qTProductUserModel.ProductUserName, ProductUserPwd = qTProductUserModel.ProductUserPwd, Fg3userPhid = user.PhId, Fg3userno = user.UserNo, Fg3username = user.UserName, PersistentState = PersistentState.Added }; base.Save <Int64>(qTProductUserDygxModel, ""); } } } catch (Exception e) { result.Status = ResponseStatus.Error; result.Msg = "同步失败!"; } return(result); }
public string PostExportMiddleYear([FromBody] BaseInfoModel <YsAccountMstModel> param) { if (param.uid == 0) { return(DCHelper.ErrorMessage("用户id不能为空!")); } if (param.orgid == 0) { return(DCHelper.ErrorMessage("组织id不能为空!")); } if (param.infoData == null) { return(DCHelper.ErrorMessage("参数传递有误!")); } try { if (param.infoData.YsAccounts != null && param.infoData.YsAccounts.Count > 0) { IList <YsAccountModel> ysAccounts = new List <YsAccountModel>(); foreach (var acc in param.infoData.YsAccounts) { ysAccounts.Add(acc); GetYsAccountsChilds(acc, ysAccounts); } param.infoData.YsAccounts = ysAccounts; } else { return(DCHelper.ErrorMessage("导出参数传递有误!")); } //获取组织和用户信息 User2Model userModel = new User2Model(); OrganizeModel organizeModel = new OrganizeModel(); userModel = this.BudgetMstService.GetUser(param.uid); organizeModel = this.BudgetMstService.GetOrganize(param.orgid); //string result = ""; // ysAccountMst = new YsAccountMstModel(); //ysAccountMst = this.YsAccountMstService.GetMiddleAccounts(488181024000002,"101", "2019"); string result = this.YsAccountMstService.GetMiddleExcel(param.infoData.YsAccounts.ToArray(), null, userModel, organizeModel); return(result); } catch (Exception e) { return(DCHelper.ErrorMessage(e.Message)); } }
public IEnumerable <User2Model> Get(int level) { var model = new List <User2Model>(); using (OdbcConnection conn = new OdbcConnection(connectionString)) { OdbcCommand cmd = new OdbcCommand(connectionString); cmd.Connection = conn; try { conn.Open(); // 현재 로그인 사용자와 같거나 낮은 레벨의 사람만 조회해서 가져옴 cmd.CommandText = $"SELECT ID, NAME, ENTRY, MODIFICATION, LEVEL FROM MEMBER WHERE LEVEL <= {level.ToString()}"; OdbcDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var user = new User2Model(); user.Id = (string)reader[0]; user.Name = (string)reader[1]; user.Entry = (DateTime)reader[2]; user.Modify = (DateTime)reader[3]; user.Level = (int)reader[4]; model.Add(user); } if (reader != null) { reader.Close(); } } catch (Exception ex) { logger.Error("Error Read All Member", ex); } finally { if (conn != null) { conn.Dispose(); } } } return(model); }
/// <summary> /// 根据审批岗位获取审批人(包括岗位id为0的发起人) /// </summary> /// <param name="recordModel"></param> /// <returns></returns> public List <GAppvalPost4OperModel> GetOperators(GAppvalRecordModel recordModel) { List <GAppvalPost4OperModel> operModels = new List <GAppvalPost4OperModel>(); if (recordModel == null) { return(operModels); } if (recordModel.PostPhid == 0) { if (recordModel.RefbillPhid == 0) { return(operModels); } else { try { GAppvalRecordModel model = GAppvalRecordFacade.Find(t => t.RefbillPhid == recordModel.RefbillPhid && t.PostPhid == 0).Data[0]; User2Model user = UserFacade.Find(model.OperaPhid).Data; operModels.Add(new GAppvalPost4OperModel { PostPhid = 0, OperatorPhid = user.PhId, OperatorName = user.UserName }); } catch (Exception e) { throw new Exception("查询发起人失败!"); } } } else { try { operModels = GAppvalPost4OperFacade.GetOperatorsByPostID(recordModel.PostPhid); } catch (Exception e) { throw new Exception("根据岗位id查找操作失败!"); } } return(operModels); }
/// <summary> /// 保存 /// </summary> /// <returns></returns> public string Save2() { string Userdata = System.Web.HttpContext.Current.Request.Params["Userdata"]; string adddata = System.Web.HttpContext.Current.Request.Params["adddata"]; string deletedata = System.Web.HttpContext.Current.Request.Params["deletedata"]; User2Model User = JsonConvert.DeserializeObject <User2Model>(Userdata); var addinfo = JsonConvert.DeserializeObject <List <QTProductUserDygxModel> >(adddata); var deleteinfo = JsonConvert.DeserializeObject <List <string> >(deletedata); CommonResult savedresult = new CommonResult(); try { savedresult = QTProductUserDygxService.Save2(User, addinfo, deleteinfo); } catch (Exception ex) { savedresult.Status = ResponseStatus.Error; savedresult.Msg = ex.Message.ToString(); } return(DataConverterHelper.SerializeObject(savedresult)); }
/// <summary> /// 保存预决算报表 /// </summary> /// <param name="ysAccountMst">对象</param> /// <param name="orgId">组织id</param> /// <param name="orgCode">组织code</param> /// <param name="year">年份</param> /// <param name="uid">用户id</param> /// <param name="verify">用来判断年初,年中,年末(1、年初,2、年中,3、年末)</param> /// <returns></returns> public SavedResult <long> SaveYsAccount(YsAccountMstModel ysAccountMst, long orgId, string orgCode, string year, long uid, string verify) { //根据用户id获取用户对象 User2Model user = new User2Model(); if (this.UserRule.Find(t => t.PhId == uid) != null && this.UserRule.Find(t => t.PhId == uid).Count > 0) { user = this.UserRule.Find(t => t.PhId == uid)[0]; } else { throw new Exception("用户查询失败!"); } //根据组织id获取组织对象 OrganizeModel org = new OrganizeModel(); if (this.OrganizationRule.Find(t => t.PhId == orgId) != null && this.OrganizationRule.Find(t => t.PhId == orgId).Count > 0) { org = this.OrganizationRule.Find(t => t.PhId == orgId)[0]; } else { throw new Exception("组织查询失败!"); } SavedResult <long> savedResult = new SavedResult <long>(); IList <YsAccountMstModel> ysAccountMsts = new List <YsAccountMstModel>(); ysAccountMsts = this.YsAccountMstRule.Find(t => t.Orgid == orgId && t.Uyear == year); if (ysAccountMsts != null && ysAccountMsts.Count > 0) { if (ysAccountMst.PhId == 0) { throw new Exception("主表主键传递有误!"); } if ("1".Equals(verify) && ysAccountMsts[0].VerifyStart == 1) { throw new Exception("年初申报数据已上报,不能修改!"); } else if ("2".Equals(verify) && ysAccountMsts[0].VerifyMiddle == 1) { throw new Exception("年中调整数据已上报,不能修改!"); } else if ("3".Equals(verify) && ysAccountMsts[0].VerifyEnd == 1) { throw new Exception("年末决算数据已上报,不能修改!"); } ysAccountMst.PersistentState = PersistentState.Modified; if ("1".Equals(verify) && ysAccountMst.VerifyStart == 1) { ysAccountMst.VerifyStartTime = DateTime.Now; ysAccountMst.StartReportDate = DateTime.Now; ysAccountMst.StartReportMan = user.UserName; } else if ("2".Equals(verify) && ysAccountMst.VerifyMiddle == 1) { if (ysAccountMsts[0].VerifyStart != 1) { throw new Exception("年初还未上报,不能进行年中的上报!"); } ysAccountMst.VerifyMiddleTime = DateTime.Now; ysAccountMst.MiddleReportDate = DateTime.Now; ysAccountMst.MiddleReportMan = user.UserName; } else if ("3".Equals(verify) && ysAccountMst.VerifyEnd == 1) { if (ysAccountMsts[0].VerifyStart != 1 || ysAccountMsts[0].VerifyMiddle != 1) { throw new Exception("年初或者年中还未上报,不能进行年末的上报!"); } ysAccountMst.VerifyEndTime = DateTime.Now; ysAccountMst.EndReportDate = DateTime.Now; ysAccountMst.EndReportMan = user.UserName; } //保存主表数据 savedResult = this.YsAccountMstRule.Save <long>(ysAccountMst); IList <YsAccountModel> ysAccounts = new List <YsAccountModel>(); //已存在的明细数据 ysAccounts = this.YsAccountRule.Find(t => t.PHIDMST == ysAccountMst.PhId && t.UYEAR == year && t.ORGID == org.PhId); if (ysAccountMst.YsAccounts != null && ysAccountMst.YsAccounts.Count > 0) { foreach (var account in ysAccountMst.YsAccounts) { account.PHIDMST = savedResult.KeyCodes[0]; if (ysAccounts != null && ysAccounts.Count > 0) { if (ysAccounts.ToList().Find(t => t.PhId == account.PhId) != null) { account.PersistentState = PersistentState.Modified; } else { account.PersistentState = PersistentState.Added; } if ("1".Equals(verify)) { account.VERIFYSTART = ysAccountMst.VerifyStart; account.VERIFYSTARTTIME = ysAccountMst.VerifyStartTime; } else if ("2".Equals(verify)) { account.VERIFYMIDDLE = ysAccountMst.VerifyMiddle; account.VERIFYMIDDLETIME = ysAccountMst.VerifyMiddleTime; } else if ("3".Equals(verify)) { account.VERIFYEND = ysAccountMst.VerifyEnd; account.VERIFYENDTIME = ysAccountMst.VerifyEndTime; } } else { throw new Exception("原明细数据有误!"); } } //保存明细表数据 this.YsAccountRule.Save <long>(ysAccountMst.YsAccounts); } else { throw new Exception("明细表数据不能为空!"); } } else { ysAccountMst.PersistentState = PersistentState.Added; if ("1".Equals(verify) && ysAccountMst.VerifyStart == 1) { ysAccountMst.VerifyStartTime = DateTime.Now; ysAccountMst.StartReportDate = DateTime.Now; ysAccountMst.StartReportMan = user.UserName; } else if ("2".Equals(verify) && ysAccountMst.VerifyMiddle == 1) { throw new Exception("年初还未上报,不能进行年中的上报!"); //ysAccountMst.VerifyMiddleTime = DateTime.Now; //ysAccountMst.MiddleReportDate = DateTime.Now; //ysAccountMst.MiddleReportMan = user.UserName; } else if ("3".Equals(verify) && ysAccountMst.VerifyEnd == 1) { throw new Exception("年初或者年中还未上报,不能进行年末的上报!"); //ysAccountMst.VerifyEndTime = DateTime.Now; //ysAccountMst.EndReportDate = DateTime.Now; //ysAccountMst.EndReportMan = user.UserName; } //保存主表数据 savedResult = this.YsAccountMstRule.Save <long>(ysAccountMst); if (ysAccountMst.YsAccounts != null && ysAccountMst.YsAccounts.Count > 0) { foreach (var account in ysAccountMst.YsAccounts) { account.PersistentState = PersistentState.Added; account.PHIDMST = savedResult.KeyCodes[0]; if ("1".Equals(verify)) { account.VERIFYSTART = ysAccountMst.VerifyStart; account.VERIFYSTARTTIME = ysAccountMst.VerifyStartTime; } else if ("2".Equals(verify)) { account.VERIFYMIDDLE = ysAccountMst.VerifyMiddle; account.VERIFYMIDDLETIME = ysAccountMst.VerifyMiddleTime; } else if ("3".Equals(verify)) { account.VERIFYEND = ysAccountMst.VerifyEnd; account.VERIFYENDTIME = ysAccountMst.VerifyEndTime; } } //保存明细表数据 this.YsAccountRule.Save <long>(ysAccountMst.YsAccounts); } else { throw new Exception("明细表数据不能为空!"); } } return(savedResult); }
public bool Update(User2Model model) { return(_res.Update(model)); }
public bool Create(User2Model model) { return(_res.Create(model)); }
public string GetYearStartCover([FromUri] BaseListModel parameter) { if (parameter == null) { return(DCHelper.ErrorMessage("请求参数为空!")); } if (parameter.orgid == 0) { return(DCHelper.ErrorMessage("组织id为空!")); } if (parameter.uid == 0) { return(DCHelper.ErrorMessage("用户id为空!")); } if (String.IsNullOrEmpty(parameter.Year)) { return(DCHelper.ErrorMessage("年度为空!")); } //value来判断是年初,年中,年末预算说明说 if (String.IsNullOrEmpty(parameter.value)) { return(DCHelper.ErrorMessage("判断年初,年中,年末的value条件为空!")); } //获取组织和用户信息 User2Model userModel = new User2Model(); OrganizeModel organizeModel = new OrganizeModel(); try { userModel = this.BudgetMstService.GetUser(parameter.uid); } catch (Exception e) { return(DCHelper.ErrorMessage("获取用户信息失败!")); } try { organizeModel = this.BudgetMstService.GetOrganize(parameter.orgid); } catch (Exception e) { return(DCHelper.ErrorMessage("获取组织信息失败!")); } FileStream fs = null; FileStream output = null; try { string title = ""; string content1 = ""; string content2 = ""; if ("1".Equals(parameter.value)) { title = "预算表"; content1 = "预算说明书"; content2 = "经费收支预算表"; } else if ("2".Equals(parameter.value)) { title = "预算表(年中调整)"; content1 = "预算说明书(年中调整)"; content2 = "经费收支预算表(年中调整)"; } else if ("3".Equals(parameter.value)) { title = "决算表"; content1 = "决算说明书"; content2 = "经费决算预算表"; } string filename = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".docx"; string filePath = HostingEnvironment.MapPath("~/DownLoadFiles/SubjectBudget"); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } File.Copy(HostingEnvironment.MapPath("~" + "/DownLoadFiles/template/预算封面.docx"), filePath + "/" + filename, true); fs = new FileStream(filePath + "/" + filename, FileMode.Open, FileAccess.Read); XWPFDocument document = new XWPFDocument(fs); foreach (var para in document.Paragraphs) { string oldContext = para.ParagraphText; if (String.IsNullOrEmpty(oldContext)) { continue; } string context = para.ParagraphText; if (context.Contains("{$date}")) { context = context.Replace("{$date}", DateTime.Now.ToString("yyyy/MM/dd")); } if (context.Contains("{$chairman}")) { context = context.Replace("{$chairman}", userModel.UserName); } if (context.Contains("{$treasurer}")) { context = context.Replace("{$treasurer}", userModel.UserName); } if (context.Contains("{$maker}")) { context = context.Replace("{$maker}", userModel.UserName); } if (context.Contains("{$checker}")) { context = context.Replace("{$checker}", ""); } if (context.Contains("{$year}")) { context = context.Replace("{$year}", DateTime.Now.Year.ToString()); } if (context.Contains("{$month}")) { context = context.Replace("{$month}", DateTime.Now.Month.ToString()); } if (context.Contains("{$day}")) { context = context.Replace("{$day}", DateTime.Now.Day.ToString()); } if (context.Contains("{$title}")) { context = context.Replace("{$title}", title); } if (context.Contains("{$content1}")) { context = context.Replace("{$content1}", content1); } if (context.Contains("{$content2}")) { context = context.Replace("{$content2}", content2); } if (oldContext != context) { para.ReplaceText(oldContext, context); } } output = new FileStream(filePath + "/" + filename, FileMode.Create); document.Write(output); fs.Close(); fs.Dispose(); output.Close(); output.Dispose(); return(DataConverterHelper.SerializeObject(new { path = filePath, filename = filename })); } catch (Exception ex) { if (fs != null) { fs.Close(); fs.Dispose(); } if (output != null) { output.Close(); output.Dispose(); } return(DCHelper.ErrorMessage("导出年初申报的封面失败!" + ex.Message)); } }
/// <summary> /// 保存 /// </summary> /// <param name="User"></param> /// <param name="adddata"></param> /// <param name="deletedata"></param> /// <returns></returns> public CommonResult Save2(User2Model User, List <QTProductUserDygxModel> adddata, List <string> deletedata) { CommonResult result = new CommonResult(); try { if (adddata != null && adddata.Count > 0) { for (var i = 0; i < adddata.Count; i++) { QTProductUserDygxModel qTProductUserDygxModel = adddata[i]; //Dictionary<string, object> dic1 = new Dictionary<string, object>(); //new CreateCriteria(dic1).Add(ORMRestrictions<string>.Eq("ProductBZ", qTProductUserDygxModel.ProductBZ)); //QTProductModel qTProductModel = QTProductFacade.Find(dic1).Data[0]; //qTProductUserDygxModel.ProductPhid = qTProductModel.PhId; Dictionary <string, object> dic2 = new Dictionary <string, object>(); new CreateCriteria(dic2).Add(ORMRestrictions <string> .Eq("ProductBZ", qTProductUserDygxModel.ProductBZ)) .Add(ORMRestrictions <string> .Eq("ProductUserCode", qTProductUserDygxModel.ProductUserCode)); QTProductUserModel qTProductUserModel = QTProductUserFacade.Find(dic2).Data[0]; if (qTProductUserDygxModel.PhId == 0) { qTProductUserDygxModel.ProductPhid = qTProductUserModel.ProductPhid; qTProductUserDygxModel.ProductUserPhid = qTProductUserModel.PhId; qTProductUserDygxModel.ProductUserName = qTProductUserModel.ProductUserName; qTProductUserDygxModel.ProductUserPwd = qTProductUserModel.ProductUserPwd; qTProductUserDygxModel.Fg3userPhid = User.PhId; qTProductUserDygxModel.Fg3userno = User.UserNo; qTProductUserDygxModel.Fg3username = User.UserName; qTProductUserDygxModel.PersistentState = PersistentState.Added; base.Save <Int64>(qTProductUserDygxModel, ""); } else { QTProductUserDygxModel qTProductUserDygxModel2 = base.Find(qTProductUserDygxModel.PhId).Data; qTProductUserDygxModel2.ProductBZ = qTProductUserDygxModel.ProductBZ; qTProductUserDygxModel2.ProductUserCode = qTProductUserDygxModel.ProductUserCode; qTProductUserDygxModel2.ProductPhid = qTProductUserModel.ProductPhid; qTProductUserDygxModel2.ProductUserPhid = qTProductUserModel.PhId; qTProductUserDygxModel2.ProductUserName = qTProductUserModel.ProductUserName; qTProductUserDygxModel2.ProductUserPwd = qTProductUserModel.ProductUserPwd; qTProductUserDygxModel2.Fg3userPhid = User.PhId; qTProductUserDygxModel2.Fg3userno = User.UserNo; qTProductUserDygxModel2.Fg3username = User.UserName; qTProductUserDygxModel2.PersistentState = PersistentState.Modified; base.Save <Int64>(qTProductUserDygxModel2, ""); } } } if (deletedata != null && deletedata.Count > 0) { for (var j = 0; j < deletedata.Count; j++) { base.Delete(deletedata[j]); } } } catch (Exception e) { result.Status = ResponseStatus.Error; result.Msg = "保存失败!"; } return(result); }
/// <summary> /// 回退时,获取之前的所有岗位,包括发起人(岗位id为0) /// </summary> /// <param name="recordModel"></param> /// <returns></returns> public List <GAppvalPostModel> GetBackApprovalPost(GAppvalRecordModel recordModel) { List <GAppvalPostModel> postModels = new List <GAppvalPostModel>(); if (recordModel == null || recordModel.ProcPhid == 0 || recordModel.PostPhid == 0) { return(postModels); } postModels.Add(new GAppvalPostModel { PhId = 0, FName = "发起人" }); //当前审批流程的所有审批岗位 List <GAppvalPostModel> allPosts = GAppvalPostFacade.FindAppvalPostByProcID(recordModel.ProcPhid).OrderBy(t => t.Seq).ToList(); //当前岗位 GAppvalPostModel presentPost = allPosts.Find(t => t.PhId == recordModel.PostPhid); //当前岗位之前的岗位 List <GAppvalPostModel> beforePosts = allPosts.FindAll(t => t.Seq < presentPost.Seq); postModels.AddRange(beforePosts); foreach (GAppvalPostModel postModel in postModels) { if (postModel.PhId == 0) { if (recordModel.RefbillPhid == 0) { postModel.Operators = null; } else { try { List <GAppvalPost4OperModel> operModels = new List <GAppvalPost4OperModel>(); GAppvalRecordModel model = GAppvalRecordFacade.Find(t => t.RefbillPhid == recordModel.RefbillPhid && t.PostPhid == 0).Data[0]; User2Model user = UserFacade.Find(model.OperaPhid).Data; operModels.Add(new GAppvalPost4OperModel { PostPhid = 0, OperatorPhid = user.PhId, OperatorName = user.UserName }); postModel.Operators = operModels; } catch (Exception e) { throw new Exception("查询发起人失败!"); } } } else { try { postModel.Operators = GAppvalPost4OperFacade.GetOperatorsByPostID(postModel.PhId); } catch (Exception e) { throw new Exception("根据岗位id查找操作失败!"); } } } return(postModels); }