/// <summary> /// 导入数据 /// </summary> /// <returns></returns> public string ImportData(HttpPostedFileBase file, string clear) { if (file == null) { return(DataConverterHelper.SerializeObject(new { success = false, message = "文件为空,请上传.xls格式的Excel文件!" })); } //上传文件 string filePath = Server.MapPath("~/UpLoadFiles/GQT"); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } string filename = Path.GetFileName(file.FileName); string fileExtension = Path.GetExtension(filename); string savename = Guid.NewGuid().ToString() + fileExtension; //var result = Json(new { success = true, message = "上传成功"}); //return JsonConvert.SerializeObject(result.Data); if (".xls".Equals(fileExtension)) { file.SaveAs(filePath + "/" + savename); SavedResult <Int64> savedResult = BudgetAccountsService.ImportData(filePath + "/" + savename, clear); if (savedResult == null) { return(DataConverterHelper.SerializeObject(new { success = false, message = "导入失败,请重新导入!" })); } //if ("0".Equals(clear)) //{ //} //using (FileStream fs = new FileStream(filePath + "/" + savename, FileMode.Open, FileAccess.Read)) //{ // HSSFWorkbook workbook = new HSSFWorkbook(fs); // ISheet sheet = workbook.GetSheetAt(0); // int rowCount = sheet.LastRowNum; // for (int i = 1; i <= rowCount; i++) // { // BudgetAccountsModel budgetAccounts = new BudgetAccountsModel(); // IRow row = sheet.GetRow(i); // ICell cell1 = row.GetCell(0); // ICell cell2 = row.GetCell(1); // ICell cell3 = row.GetCell(2); // cell1.SetCellType(CellType.String); // cell2.SetCellType(CellType.String); // cell3.SetCellType(CellType.String); // string kmdm = cell1.StringCellValue; // string kmmc = cell2.StringCellValue; // string kmlb = (cell3.StringCellValue == "收入" ? "0" : "1"); // budgetAccounts.KMDM = kmdm; // budgetAccounts.KMMC = kmmc; // budgetAccounts.KMLB = kmlb; // BudgetAccountsService.ImportData(budgetAccounts); // } //} } else { return(DataConverterHelper.SerializeObject(new { success = false, message = "文件格式错误,请上传.xls格式的Excel文件!" })); } return(DataConverterHelper.SerializeObject(new { success = true, message = "导入成功!" })); }
/// <summary> /// 获得help数据列表; /// </summary> /// <param name="helpId">帮助id;</param> /// <param name="pageSize">分页大小;</param> /// <param name="pageIndex">页码;</param> /// <param name="totalRecord">总记录长度;</param> /// <param name="clientFilter">过滤条件;</param> /// <returns></returns> public DataTable GetHelpList(string helpId, int pageSize, int pageIndex, ref int totalRecord, string clientFilter, bool isAutoComplete) { CustomHelpEntity item = GetHelpItem(helpId); DataTable dt; /*如果没有sql则返回;*/ if (item.FromSql != "1") { return(new DataTable()); } string sortField = string.Empty; string sql = item.Sql; int n = sql.ToUpper().IndexOf("ORDER BY"); if (n > 0) { sortField = sql.Substring(n); sql = sql.Substring(0, n - 1); } else { sortField = item.CodeField + " asc"; } if (!string.IsNullOrEmpty(clientFilter)) { IDataParameter[] p; if (isAutoComplete) { string query = string.Empty; p = BuildInputQuery(helpId, clientFilter, string.Empty, string.Empty, ref query); if (!string.IsNullOrEmpty(query)) { sql += " where " + query; } } else { string query = string.Empty; p = DataConverterHelper.BuildQueryWithParam(clientFilter, string.Empty, ref query); if (!string.IsNullOrEmpty(query)) { sql += " where " + query; } } string sqlstr = PaginationAdapter.GetPageDataSql(sql, pageSize, ref pageIndex, ref totalRecord, sortField, p); dt = DbHelper.GetDataTable(sqlstr, p); } else { string sqlstr = PaginationAdapter.GetPageDataSql(sql, pageSize, ref pageIndex, ref totalRecord, sortField); dt = DbHelper.GetDataTable(sqlstr); } return(dt); }
public string GetYsIncome([FromUri] BaseListModel param) { if (param.orgid == 0 || string.IsNullOrEmpty(param.orgCode)) { return(DCHelper.ErrorMessage("组织信息不能为空!")); } if (string.IsNullOrEmpty(param.Year)) { return(DCHelper.ErrorMessage("年度信息不能为空!")); } try { //存主信息 YsIncomeMstModel ysIncomeMst = new YsIncomeMstModel(); //预算部门集合(收入归属) IList <OrganizeModel> organizes = new List <OrganizeModel>(); organizes = this.YsIncomeMstService.GetAllOrganize(); //存明细信息 IList <YsIncomeDtlModel> ysIncomeDtls = new List <YsIncomeDtlModel>(); var ysIncomeMsts = this.YsIncomeMstService.Find(t => t.FOrgID == param.orgid && t.FYear == param.Year).Data; if (ysIncomeMsts != null && ysIncomeMsts.Count > 0) { ysIncomeMst = ysIncomeMsts[0]; ysIncomeDtls = this.YsIncomeMstService.FindYsIncomeDtlByForeignKey(ysIncomeMsts[0].PhId).Data; } else { ysIncomeMst.FOrgID = param.orgid; ysIncomeMst.FOrgcode = param.orgCode; ysIncomeMst.FYear = param.Year; //预算科目的基本信息 IList <BudgetAccountsModel> budgetAccounts = new List <BudgetAccountsModel>(); budgetAccounts = this.BudgetAccountsService.Find(t => t.PhId > 0).Data; if (budgetAccounts == null || budgetAccounts.Count <= 0) { return(DCHelper.ErrorMessage("预算科目基础配置信息为空!")); } //获取该组织的所对应的所有预算科目 IList <CorrespondenceSettingsModel> correspondenceSettingss = new List <CorrespondenceSettingsModel>(); correspondenceSettingss = this.CorrespondenceSettingsService.Find(t => t.Dylx == "02" && t.Dwdm == param.orgid.ToString()).Data; if (correspondenceSettingss != null && correspondenceSettingss.Count > 0) { foreach (var corr in correspondenceSettingss) { YsIncomeDtlModel ysIncomeDtl = new YsIncomeDtlModel(); ysIncomeDtl.FSubjectCode = corr.Dydm; ysIncomeDtl.FSubjectname = budgetAccounts.ToList().Find(t => t.KMDM == corr.Dydm) == null ? "" : budgetAccounts.ToList().Find(t => t.KMDM == corr.Dydm).KMMC; ysIncomeDtl.FProcessStatus = "";//进度控制暂定 ysIncomeDtls.Add(ysIncomeDtl); } } else { return(DCHelper.ErrorMessage("此单位对应的预算科目信息为空!")); } } if (ysIncomeDtls != null && ysIncomeDtls.Count > 0) { foreach (var dtl in ysIncomeDtls) { if (ysIncomeDtls.ToList().Find(t => t.FSubjectCode.StartsWith(dtl.FSubjectCode) && t.FSubjectCode != dtl.FSubjectCode) == null) { dtl.IsLast = 1; } if (organizes != null && organizes.Count > 0) { dtl.FBudgetName = organizes.ToList().Find(t => t.OCode == dtl.FBudgetcode) == null ? "" : organizes.ToList().Find(t => t.OCode == dtl.FBudgetcode).OName; } } } if (!string.IsNullOrEmpty(param.Search) && ysIncomeDtls != null && ysIncomeDtls.Count > 0) { ysIncomeDtls = ysIncomeDtls.ToList().FindAll(t => (t.FSubjectCode.Contains(param.Search) || t.FSubjectname.Contains(param.Search))); } var data = new { Status = ResponseStatus.Success, Msg = "获取成功!", Mst = ysIncomeMst, Dtls = ysIncomeDtls.OrderBy(t => t.FSubjectCode).ToList() }; return(DataConverterHelper.SerializeObject(data)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public string BuildQRCode() { try { string masterData = System.Web.HttpContext.Current.Request.Form["masterData"]; DataTable masterDt = new DataTable(); if (!string.IsNullOrWhiteSpace(masterData)) { masterDt = DataConverterHelper.ToDataTable(masterData, "select * from fg3_qrcode_style"); string imgName = proxy.GetImgName(); string strPath = "NG3Resource\\QRCodeLogo\\" + imgName; string dirPath = Request.PhysicalApplicationPath + strPath; int imgsize = 0; int.TryParse(masterDt.Rows[0]["imgsize"].ToString(), out imgsize); Color BackC; Color ForeC; switch (masterDt.Rows[0]["backcolor"].ToString()) { case "1": BackC = Color.White; break; case "2": BackC = Color.PowderBlue; break; case "3": BackC = Color.NavajoWhite; break; case "4": BackC = Color.LightGray; break; default: BackC = Color.White; break; } switch (masterDt.Rows[0]["frontcolor"].ToString()) { case "1": ForeC = Color.Black; break; case "2": ForeC = Color.DodgerBlue; break; case "3": ForeC = Color.Maroon; break; case "4": ForeC = Color.DarkOrange; break; default: ForeC = Color.Black; break; } Bitmap bitmap = Generate3(dirPath, masterDt.Rows[0]["content"].ToString(), imgsize, imgsize, masterDt.Rows[0]["addLogo"].ToString(), BackC, ForeC); strPath = "NG3Resource\\QRCodeLogo\\qrcode.png"; dirPath = Request.PhysicalApplicationPath + strPath; bitmap.Save(dirPath, System.Drawing.Imaging.ImageFormat.Png); return("true"); } else { return(""); } } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// /// </summary> /// <returns></returns> public string GetFuncList() { var result = MethodAroundMstService.GetSupportFunctions(); return(DataConverterHelper.EntityListToJson <SupportFunctionBizModel>(result, result.Count)); }
/// <summary> /// 获取模块 /// </summary> /// <returns>返回Json串</returns> public string GetModules() { List <QtModulesModel> data = CorrespondenceSettingsService.GetModules(); return(DataConverterHelper.SerializeObject(data)); }
/// <summary> /// 注意,默认tab和设置是分别加载,一起保存 /// </summary> /// <returns></returns> public string SaveDefaultOpenTab() { string defaultOpenTab = System.Web.HttpContext.Current.Request.Form["defaultOpenTab"]; //string userid = System.Web.HttpContext.Current.Request.Form["userid"]; long userid = AppInfoBase.UserID; //保存默认tab页设置 DataTable defaultOpenTabTable = DataConverterHelper.ToDataTable(defaultOpenTab, "select * from fg3_defaultopen_tab"); int iret1 = proxy.SaveDefaultOpenTab(userid, defaultOpenTabTable); //保存系统设置 string individualSetting = System.Web.HttpContext.Current.Request.Form["individualSetting"]; bool iret2 = proxy.SaveSysSetting(userid, individualSetting); if (String.Compare(AppInfoBase.UserType, UserType.System, true) == 0) { //保存管理员权限下的路由设置和显示设置,注意这两个会改了数据库连接串,不再连0002 string ServerIpAndNetWorkIpConfig = System.Web.HttpContext.Current.Request.Form["ServerIpAndNetWorkIpConfig"]; string DisplaySetting = System.Web.HttpContext.Current.Request.Form["DisplaySetting"]; this.SaveServerIpAndNetWorkIpConfig(ServerIpAndNetWorkIpConfig); this.SaveDisplaySetting(DisplaySetting); } //保存小铃铛设置 string alertconfig = System.Web.HttpContext.Current.Request.Form["alertconfig"]; bool iret3 = proxy.SaveAlertItem(alertconfig); //bool iret3 = this.SaveAlertItem(alertconfig); //保存换肤设置 string uitheme = System.Web.HttpContext.Current.Request.Form["uitheme"]; int tempuitheme = 0; Int32.TryParse(uitheme.ToString(), out tempuitheme); bool iret4 = MenuConfigProxy.SaveUITheme(tempuitheme, userid); ////保存登陆单位信息 //string SSOOrgValue = System.Web.HttpContext.Current.Request.Form["SSOOrgValue"]; //proxy.SetSSOOrg(SSOOrgValue); //保存APP启动页Logo string APPlogo = System.Web.HttpContext.Current.Request.Form["APPlogo"]; string filePath = Request.PhysicalApplicationPath + "NG3Resource\\APPLogo\\" + APPlogo; bool iret5 = true; if (!string.IsNullOrEmpty(APPlogo) && System.IO.File.Exists(filePath)) { byte[] buffer; using (FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read)) { buffer = new byte[fs.Length]; fs.Read(buffer, 0, (int)fs.Length); } string attachid = proxy.GetAPPLogoAttachId(); try { if (string.IsNullOrEmpty(attachid)) { string result = NG3UploadFileService.NG3UploadEx("", buffer); JObject jo = (JObject)JsonConvert.DeserializeObject(result); if (jo["success"] != null && jo["success"].ToString() == "true") { attachid = jo["phid"].ToString(); } else { return("{status : \"error\", msg: \"APPLogo上传到附件出错\"}"); } } else { NG3UploadFileService.NG3ModifyEx("", long.Parse(attachid), buffer); } } catch { return("{status : \"error\", msg: \"APPLogo上传到附件出错\"}"); } iret5 = proxy.SaveAPPLogo(APPlogo, attachid); if (iret5) { string dirPath = Request.PhysicalApplicationPath + "NG3Resource\\APPLogo"; if (Directory.Exists(dirPath)) { Directory.Delete(dirPath, true); } } } if (iret1 >= 0 && iret2 && iret3 && iret4 && iret5) { return("{status : \"ok\"}"); } else { return("{status : \"error\"}"); } }
public IList <TreeJSONBase> GetTreeList(string helpid, string clientQuery, string outJsonQuery, string leftLikeJsonQuery, string clientSqlFilter, string nodeid, bool ormMode) { string filter = string.Empty; CommonHelpEntity item = richDac.GetCommonHelpItem(helpid); TreeListBuilder builder = new TreeListBuilder(); string treePid = item.TreePid; string treeChildId = item.TreeChildId; if (ormMode) { string tableName = item.TableName; string[] s = item.TableName.Split(' ');//有别名 if (s.Length > 0) { tableName = s[s.Length - 1].Trim(); } builder.ID = DataConverterHelper.FieldToProperty(tableName, item.CodeField); //item.CodeField; builder.Text = DataConverterHelper.FieldToProperty(tableName, item.NameField); //item.NameField; treePid = DataConverterHelper.FieldToProperty(tableName, item.TreePid); item.TreeChildId = DataConverterHelper.FieldToProperty(tableName, item.TreeChildId); } else { builder.ID = item.CodeField; builder.Text = item.NameField; } DataTable dt = richDac.GetTreeList(helpid, clientQuery, outJsonQuery, leftLikeJsonQuery, clientSqlFilter, nodeid, ormMode); string sort = string.Empty; if (!string.IsNullOrWhiteSpace(item.SortProperty)) { sort = item.SortProperty + " asc "; } if (string.IsNullOrEmpty(treePid)) { throw new Exception("树节点pid未设置,请在通用帮助注册设置[父节点id]和[子节点id]!"); } Type type = dt.Columns[treePid].DataType; if ("root" == nodeid)//首次加载 { if (type == typeof(Int64) || type == typeof(Int32)) { filter = "(" + treePid + "=0 or " + treePid + " is null)"; } else { filter = "(" + treePid + "='' or " + treePid + "is null)"; } return(builder.GetExtTreeList(dt, treePid, treeChildId, filter, sort, TreeDataLevelType.TopLevel, 2)); } else//懒加载 { //return builder.GetExtTreeList(dt, item.TreePid, item.TreeChildId, filter, TreeDataLevelType.LazyLevel); return(builder.LazyLoadTreeList(dt, treePid, treeChildId, nodeid)); } }
/// <summary> /// 根据code判断是否是末级 /// </summary> /// <returns>返回Json串</returns> public string IfLastStage(string Code) { var findResult = SourceOfFundsService.IfLastStage(Code); return(DataConverterHelper.SerializeObject(findResult)); }
public string GetinfoByProjCode([FromUri] long YsPhid) { var result = ExpenseMstService.GetinfoByProjCode(YsPhid); return(DataConverterHelper.SerializeObject(result)); }
public string GetinfoByDept([FromUri] BaseListModel param) { var result = ExpenseMstService.GetinfoByDept(param.orgCode, param.Year); return(DataConverterHelper.SerializeObject(result)); }
public string GetDeleteReturn([FromUri] long id) { var deletedresult = ExpenseMstService.DeleteReturn(id); return(DataConverterHelper.SerializeObject(deletedresult)); }
public async Task <string> PostSave2() { List <QtAttachmentModel> attachmentModels = new List <QtAttachmentModel>(); List <QtAttachmentModel> oldattachmentModels = new List <QtAttachmentModel>(); //具体数据对象 long expensePhid = 0; //判断form表单类型是否正确 if (!Request.Content.IsMimeMultipartContent()) { var data1 = new { Status = ResponseStatus.Error, Msg = "请求数据不是multipart/form-data类型", Data = "" }; return(DataConverterHelper.SerializeObject(data1)); } //I6WebAppInfo i6AppInfo = (I6WebAppInfo)HttpContext.Current.Session["NGWebAppInfo"] ?? null; //获取AppInfo值 头部信息记录 var base64EncodedBytes = Convert.FromBase64String(HttpContext.Current.Request.Headers.GetValues("AppInfo").First()); var jsonText = Encoding.UTF8.GetString(base64EncodedBytes); var AppInfo = JsonConvert.DeserializeObject <AppInfoBase>(jsonText); //如果路径不存在,创建路径 var root = System.Web.Hosting.HostingEnvironment.MapPath("~/UpLoadFiles/ExpenseMst/"); string date = DateTime.Now.ToString("yyyy-MM-dd"); string filePath = Path.Combine(root, date); if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } var multipartMemoryStreamProvider = await Request.Content.ReadAsMultipartAsync(); var contentsList = multipartMemoryStreamProvider.Contents; foreach (var content in contentsList) { //通过判断fileName是否为空,是否为文件 if (!string.IsNullOrEmpty(content.Headers.ContentDisposition.FileName)) { //处理文件名字符串 string fileName = content.Headers.ContentDisposition.FileName.Replace("\"", string.Empty); using (Stream stream = await content.ReadAsStreamAsync()) { //文件如果大于100MB 提示不允许 if (stream.Length > 104857600) { return(DCHelper.ErrorMessage("上传的文件不能大于100MB!")); } byte[] bytes = new byte[stream.Length]; stream.Read(bytes, 0, bytes.Length); stream.Seek(0, SeekOrigin.Begin); //获取对应文件后缀名 string extension = Path.GetExtension(fileName); //获取文件名 string b_name = Path.GetFileName(fileName); //修改文件名 string newFileName = Guid.NewGuid().ToString("N") + extension; string uploadPath = Path.Combine(filePath, newFileName); //保存文件 MemoryStream ms = new MemoryStream(bytes); FileStream fs = new FileStream(uploadPath, FileMode.Create); ms.WriteTo(fs); ms.Close(); fs.Close(); string b_urlpath = "/UpLoadFiles/ExpenseMst/" + date + "/" + newFileName; QtAttachmentModel attachmentModel = new QtAttachmentModel(); attachmentModel.BName = b_name; attachmentModel.BSize = decimal.Round((decimal)stream.Length / 1024, 2); attachmentModel.BTable = "YS3_EXPENSEMST"; attachmentModel.BType = extension; attachmentModel.BUrlpath = b_urlpath; attachmentModel.PersistentState = PersistentState.Added; attachmentModels.Add(attachmentModel); } } else { //获取键值对值,并通过反射获取对象中的属性 string key = content.Headers.ContentDisposition.Name.Replace("\"", string.Empty); string value = await content.ReadAsStringAsync(); //取项目主键 //projectPhid = long.Parse(value); //取用款计划主键 if (key == "PhId") { expensePhid = long.Parse(value); } else if (key == "OldAttachments") { var value2 = JsonConvert.DeserializeObject <List <QtAttachmentModel> >(value); oldattachmentModels = value2; } ////取用款计划主键 //expensePhid = long.Parse(value); } } if (expensePhid <= 0) { return(DCHelper.ErrorMessage("用款计划保存附件失败!")); } try { SavedResult <long> savedResult = new SavedResult <long>(); //原有的附件要删除 IList <QtAttachmentModel> oldAttachments = new List <QtAttachmentModel>(); oldAttachments = this.QtAttachmentService.Find(t => t.BTable == "YS3_EXPENSEMST" && t.RelPhid == expensePhid).Data; if (oldAttachments != null && oldAttachments.Count > 0) { foreach (var oldAtt in oldAttachments) { oldAtt.PersistentState = PersistentState.Deleted; } this.QtAttachmentService.Save <long>(oldAttachments, ""); } if (attachmentModels != null && attachmentModels.Count > 0) { foreach (var att in attachmentModels) { att.RelPhid = expensePhid; att.BTable = "YS3_EXPENSEMST"; att.PersistentState = PersistentState.Added; } //savedResult = this.QtAttachmentService.Save<long>(attachmentModels, ""); } if (oldattachmentModels != null && oldattachmentModels.Count > 0) { foreach (var oldAtt in oldattachmentModels) { oldAtt.RelPhid = expensePhid; oldAtt.BTable = "YS3_EXPENSEMST"; oldAtt.PersistentState = PersistentState.Added; attachmentModels.Add(oldAtt); } } if (attachmentModels != null && attachmentModels.Count > 0) { savedResult = this.QtAttachmentService.Save <long>(attachmentModels, ""); } return(DataConverterHelper.SerializeObject(savedResult)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
/// <summary> /// 根据code判断是否是末级 /// </summary> /// <returns>返回Json串</returns> public string IfLastStage(string budgetAccountsCode) { var findResult = BudgetAccountsService.IfLastStage(budgetAccountsCode); return(DataConverterHelper.SerializeObject(findResult)); }
public string GetDescriptionDocx([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条件为空!")); } //查询预算主表对象,获取预算说明书 string description = ""; try { IList <YsAccountMstModel> mstModels = YsAccountMstService.Find(t => t.Orgid == parameter.orgid && t.Uyear == parameter.Year).Data; if (mstModels != null && mstModels.Count > 0) { if ("1".Equals(parameter.value)) { description = mstModels[0].DescriptionStart; } else if ("2".Equals(parameter.value)) { description = mstModels[0].DescriptionMiddle; } else if ("3".Equals(parameter.value)) { description = mstModels[0].DescriptionEnd; } } else { description = ""; } } catch (Exception e) { return(DCHelper.ErrorMessage("预算主表对象失败!")); } FileStream fs = null; FileStream output = null; try { 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("{$content}")) { context = context.Replace("{$content}", description); } 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 e) { if (fs != null) { fs.Close(); fs.Dispose(); } if (output != null) { output.Close(); output.Dispose(); } return(DCHelper.ErrorMessage("导出预算说明书失败!" + e.Message)); } }
public string PostDelete([FromBody] BaseSingleModel parameter) { if (string.IsNullOrEmpty(parameter.id)) { return(DCHelper.ErrorMessage("单据主键Phid为空!")); } if (parameter == null || string.IsNullOrEmpty(parameter.uid)) { return(DCHelper.ErrorMessage("用户id为空!")); } if (string.IsNullOrEmpty(parameter.orgid)) { return(DCHelper.ErrorMessage("组织编码为空!")); } if (string.IsNullOrEmpty(parameter.Ryear)) { return(DCHelper.ErrorMessage("年度为空!")); } try { var result = GKPaymentMstService.Find <long>(long.Parse(parameter.id)); if (!result.IsError && result.Data != null) { //判断要删除的支付单的状态 if (result.Data.FApproval == (int)EnumBillApproval.Approved) { return(DCHelper.ErrorMessage("单据已审批,不能删除!")); } if (result.Data.FApproval == (int)EnumBillApproval.InApproval) { return(DCHelper.ErrorMessage("单据在审批中,不能删除!")); } if (result.Data.FApproval == (int)EnumBillApproval.Approved) { return(DCHelper.ErrorMessage("单据已审批通过,不能删除!")); } if (result.Data.FState == (int)EnumPaymentState.AbnormalPayment) { return(DCHelper.ErrorMessage("单据已审批通过,不能删除!")); } var result2 = GKPaymentMstService.Delete(long.Parse(parameter.id)); return(DataConverterHelper.SerializeObject(result2)); } else { result.Msg = "单据不存在或已被其他人删除!"; } return(DataConverterHelper.SerializeObject(result)); } catch (Exception e) { return(DCHelper.ErrorMessage(e.Message)); } }
/// <summary> /// 获取所有审批种类对应的审批单据的总数量 /// </summary> /// <returns>返回Json串</returns> public string GetRecordListNum() { long Uid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Uid"]); long Orgid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Orgid"]); string Year = System.Web.HttpContext.Current.Request.Params["Year"]; if (Uid == 0) { return(DCHelper.ErrorMessage("用户id为空!")); } if (Orgid == 0) { return(DCHelper.ErrorMessage("组织id为空!")); } if (string.IsNullOrEmpty(Year)) { return(DCHelper.ErrorMessage("年度为空!")); } //设置当前数据库连接信息 ConnectionInfoService.SetCallContextConnectString(NG3.AppInfoBase.UserConnectString); MultiDelegatingDbProvider.CurrentDbProviderName = NG3.AppInfoBase.DbName; BillRequestModel billRequest = new BillRequestModel(); billRequest.Uid = Uid; billRequest.Orgid = Orgid; billRequest.Year = Year; var YNum = 0; //已审数量 var NNum = 0; //待审数量 try { //获取审批所有类型 List <QTSysSetModel> procTypes = QTSysSetService.GetProcTypes(); if (procTypes != null && procTypes.Count > 0) { foreach (var sysSet in procTypes) { billRequest.BType = sysSet.Value; billRequest.Splx_Phid = sysSet.PhId; int total = 0; List <AppvalRecordVo> recordVos = GAppvalRecordService.GetDoneRecordList(billRequest, out total); int total2 = 0; List <AppvalRecordVo> recordVos2 = GAppvalRecordService.GetUnDoRecordList(billRequest, out total2); YNum += total; NNum += total2; } } var dic = new Dictionary <string, object>(); new CreateCriteria(dic).Add(ORMRestrictions <Int64> .NotEq("PhId", 0)); new CreateCriteria(dic).Add(ORMRestrictions <List <Int32> > .In("FState", new List <int>() { 2, 0 })); new CreateCriteria(dic).Add(ORMRestrictions <Int64> .Eq("OrgPhid", Orgid)); new CreateCriteria(dic).Add(ORMRestrictions <string> .Eq("FYear", Year)); //var Query = GKPaymentMstService.GetPaymentFailure(dic); var Query = GKPaymentMstService.Find(dic).Data; return(DataConverterHelper.SerializeObject(new { Status = "success", YNum = YNum, NNum = NNum, PaymentState = Query.Count//【待支付】信息提醒需求 })); } catch (Exception e) { return(DCHelper.ErrorMessage(e.Message)); } }
public string PostNaviSort([FromBody] QtNaviGationdtlModel qtNaviGationdtl) { List <QtNaviGationModel> list = new List <QtNaviGationModel>(); SavedResult <Int64> savedResult = new SavedResult <Int64>(); var area1 = qtNaviGationdtl.area1; var area2 = qtNaviGationdtl.area2; var index = 0; if (area1 != null) { for (int i = 0; i < area1.Count(); i++) { QtNaviGationModel model = new QtNaviGationModel { Buttoncode = area1[i].Buttoncode, Invisible = area1[i].Invisible, PhId = area1[i].PhId, Name = area1[i].Name, Menu = area1[i].Menu, Srcs = area1[i].Srcs, Sortvalue = i + 1, Operator = area1[i].Operator, Creator = area1[i].Creator, Createtime = area1[i].Createtime, Editor = area1[i].Editor, CurOrgId = area1[i].CurOrgId, NgInsertDt = area1[i].NgInsertDt, NgUpdateDt = area1[i].NgUpdateDt, NgRecordVer = area1[i].NgRecordVer, Modifier = area1[i].Modifier, Modifiertime = area1[i].Modifiertime, PersistentState = PersistentState.Modified }; list.Add(model); index = area1.Count(); } } if (area2 != null) { for (int j = 0; j < area2.Count(); j++) { QtNaviGationModel model = new QtNaviGationModel { Buttoncode = area2[j].Buttoncode, Sortvalue = index + j + 1, Invisible = area2[j].Invisible, PhId = area2[j].PhId, Name = area2[j].Name, Menu = area2[j].Menu, Srcs = area2[j].Srcs, Operator = area2[j].Operator, Creator = area2[j].Creator, Createtime = area2[j].Createtime, Editor = area2[j].Editor, CurOrgId = area2[j].CurOrgId, NgInsertDt = area2[j].NgInsertDt, NgUpdateDt = area2[j].NgUpdateDt, NgRecordVer = area2[j].NgRecordVer, Modifier = area2[j].Modifier, Modifiertime = area2[j].Modifiertime, PersistentState = PersistentState.Modified }; list.Add(model); } } foreach (var item in list) { var dic = new Dictionary <string, object>(); new CreateCriteria(dic).Add(ORMRestrictions <Int64> .Eq("PhId", item.PhId)); var Query = QtNaviGationService.Find(dic); if (Query.Data.Count < 0) { savedResult.Status = ResponseStatus.Error; savedResult.Msg = "找不到匹配数据"; } } try { var Result = QtNaviGationService.Save <Int64>(list, ""); } catch (Exception ex) { savedResult.Status = ResponseStatus.Error; savedResult.Msg = ex.Message.ToString(); } return(DataConverterHelper.SerializeObject(savedResult));; }
/// <summary> /// 根据支出类别(项目类型)的code判断是否是末级 /// </summary> /// <returns>返回Json串</returns> public string IfLastStage(string expenseCategoryCode) { var findResult = ExpenseCategoryService.IfLastStage(expenseCategoryCode); return(DataConverterHelper.SerializeObject(findResult)); }
public string GetNaviCode([FromUri] long Operator) { if (Operator != 0) { var dic = new Dictionary <string, object>(); new CreateCriteria(dic).Add(ORMRestrictions <Int64> .NotEq("PhId", 0)); new CreateCriteria(dic).Add(ORMRestrictions <Int64> .Eq("Operator", Operator)); var Query = QtNaviGationService.Find(dic); if (Query.Data.Count > 0) { var area1 = Query.Data.Where(m => m.Invisible == 1).OrderBy(m => m.Sortvalue).ToList(); var area2 = Query.Data.Where(m => m.Invisible == 2).OrderBy(m => m.Sortvalue).ToList(); var data = new { area1, area2 }; return(DataConverterHelper.SerializeObject(data)); } else { List <QtNaviGationModel> qtlist = new List <QtNaviGationModel>(); QtNaviGationModel model = new QtNaviGationModel(); SavedResult <Int64> savedResult = new SavedResult <long>(); var list = new List <QtNaviGationModel> { new QtNaviGationModel { Sortvalue = 1, Buttoncode = "projectmanage", Operator = Operator, PersistentState = PersistentState.Added, Invisible = 2, Name = "预算项目", Menu = "projectmanage", Srcs = "yunsuan" }, new QtNaviGationModel { Sortvalue = 2, Buttoncode = "fund", Operator = Operator, PersistentState = PersistentState.Added, Invisible = 2, Name = "资金拨付", Menu = "fund", Srcs = "zjbf" }, new QtNaviGationModel { Sortvalue = 3, Buttoncode = "approvalcenter", Operator = Operator, PersistentState = PersistentState.Added, Invisible = 2, Name = "审批中心", Menu = "approvalcenter", Srcs = "spzx" }, new QtNaviGationModel { Sortvalue = 4, Buttoncode = "paycenter", Operator = Operator, PersistentState = PersistentState.Added, Invisible = 2, Name = "支付中心", Menu = "paycenter", Srcs = "zfzx" }, new QtNaviGationModel { Sortvalue = 5, Buttoncode = "bankaccount", Operator = Operator, PersistentState = PersistentState.Added, Invisible = 2, Name = "银行档案", Menu = "bankaccount", Srcs = "yhdn" }, new QtNaviGationModel { Sortvalue = 6, Buttoncode = "setting", Operator = Operator, PersistentState = PersistentState.Added, Invisible = 2, Name = "系统设置", Menu = "sysSetting", Srcs = "xtsz" }, new QtNaviGationModel { Sortvalue = 7, Buttoncode = "projectspent", Operator = Operator, PersistentState = PersistentState.Added, Invisible = 2, Name = "项目用款", Menu = "projectspent", Srcs = "xmyk" }, }; #region 通过反射的方式获取object的属性数据 // foreach (var item in list) //{ //Type type = item.GetType(); //var pro = type.GetProperties(); //for (int i = 0, j = pro.Length; i < j; i++) //{ // if (pro[i].CanRead) // { // try // { // var o = pro[i].GetValue(item, null); // if (o != null) // { // if (o.GetType() == typeof(int)) // { // model.Sortvalue = (int)o; // } // else if (o.GetType() == typeof(string)) // { // model.Buttoncode = o.ToString(); // } // else if (o.GetType() == typeof(long)) // { // model.Operator = (long)o; // } // model.Invisible = 2; // model.PersistentState = PersistentState.Added; // } // else // { // return DCHelper.ErrorMessage("数据赋值失败"); // } // } // catch (Exception ex) // { // return DCHelper.ErrorMessage(ex.ToString()); // } // } //} //qtlist.Add(model); // } #endregion try { savedResult = QtNaviGationService.Save <Int64>(list, string.Empty); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.ToString())); } var QueryS = QtNaviGationService.Find(dic); if (QueryS.Data.Count > 0) { var area1 = Query.Data.Where(m => m.Invisible == 2).OrderBy(m => m.Sortvalue); var area2 = Query.Data.Where(m => m.Invisible == 1).OrderBy(m => m.Sortvalue); var data = new { area1, area2 }; return(DataConverterHelper.SerializeObject(data)); } else { return(DCHelper.ErrorMessage("数据列表获取失败")); } } } else { return(DCHelper.ErrorMessage("参数传递失败")); } }
public string Save() { string masterId = System.Web.HttpContext.Current.Request.Form["masterid"]; string masterData = System.Web.HttpContext.Current.Request.Form["masterData"]; string detailData = System.Web.HttpContext.Current.Request.Form["detailData"]; string productData = System.Web.HttpContext.Current.Request.Form["productData"]; DataTable masterDt = new DataTable(); DataTable detailDt = new DataTable(); DataTable productDt = new DataTable(); if (!string.IsNullOrWhiteSpace(masterData)) { masterDt = DataConverterHelper.ToDataTable(masterData, "select * from fg3_qrcode_rule"); } if (!string.IsNullOrWhiteSpace(detailData)) { detailDt = DataConverterHelper.ToDataTable(detailData, "select * from fg3_qrcode_rule_detail"); } if (!string.IsNullOrWhiteSpace(productData)) { productDt = DataConverterHelper.ToDataTable(productData, "select * from fg_busiproduct"); } foreach (DataRow dr in masterDt.Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } if (dr.RowState == DataRowState.Added) { dr["phid"] = masterId; productDt.Rows[0]["code"] = Guid.NewGuid().ToString(); } productDt.Rows[0]["busid"] = "fg3_qrcode_rule"; productDt.Rows[0]["busikey"] = masterId; } bool temp; long detailPhid = proxy.GetMaxID("fg3_qrcode_rule_detail", out temp); foreach (DataRow dr in detailDt.Rows) { if (dr.RowState == DataRowState.Deleted) { continue; } if (dr.RowState == DataRowState.Added) { dr["phid"] = ++detailPhid; dr["originalphid"] = masterId; } } ResponseResult result = new ResponseResult(); try { result = proxy.Save(masterId, masterDt, detailDt, productDt); } catch (Exception ex) { result.Status = "error"; result.Msg = ex.Message.ToString(); } string response = JsonConvert.SerializeObject(result); return(response); }
/// <summary> /// 获取请求参数 /// </summary> /// <returns></returns> public string GetServiceRequestParameters() { var result = BasicSettingService.GetServiceRequestParameters(); return(DataConverterHelper.EntityListToJson <ServiceUIParamBizModel>(result, result.Count)); }
public string getUrlByCode(string code) { DataTable dt = proxy.getUrlByCode(code); return(DataConverterHelper.ToJson(dt, 1)); }
/// <summary> /// 取系统变量 /// </summary> /// <returns></returns> public string GetSystemVariables() { var result = BasicSettingService.GetSystemVariables(); return(DataConverterHelper.EntityListToJson <SupportVariableBizModel>(result, result.Count)); }
public string InitService() { var services = InterceptedServiceScanner.GetInterceptedService(); return(DataConverterHelper.EntityListToJson <InterceptedServiceBizModel>(services, services.Count)); }
public string PostSaveAccountList([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); } if (ysAccounts != null && ysAccounts.Count > 0) { //后端重新算一遍数据(防止前端传入错误数据) foreach (var ysAcc in ysAccounts) { if (ysAcc.SUBJECTCODE == "4BNHJSR") { ysAcc.FINALACCOUNTSTOTAL = ysAccounts.ToList().FindAll(t => (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).StartsWith("4") && (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).Length == 3) == null ? 0 : ysAccounts.ToList().FindAll(t => (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).StartsWith("4") && (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).Length == 3).Sum(t => t.FINALACCOUNTSTOTAL); ysAcc.BUDGETTOTAL = ysAccounts.ToList().FindAll(t => (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).StartsWith("4") && (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).Length == 3) == null ? 0 : ysAccounts.ToList().FindAll(t => (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).StartsWith("4") && (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).Length == 3).Sum(t => t.BUDGETTOTAL); ysAcc.ADJUSTMENT = ysAccounts.ToList().FindAll(t => (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).StartsWith("4") && (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).Length == 3) == null ? 0 : ysAccounts.ToList().FindAll(t => (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).StartsWith("4") && (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).Length == 3).Sum(t => t.ADJUSTMENT); ysAcc.APPROVEDBUDGETTOTAL = ysAccounts.ToList().FindAll(t => (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).StartsWith("4") && (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).Length == 3) == null ? 0 : ysAccounts.ToList().FindAll(t => (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).StartsWith("4") && (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).Length == 3).Sum(t => t.APPROVEDBUDGETTOTAL); ysAcc.ThisaccountsTotal = ysAccounts.ToList().FindAll(t => (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).StartsWith("4") && (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).Length == 3) == null ? 0 : ysAccounts.ToList().FindAll(t => (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).StartsWith("4") && (t.SUBJECTCODE == null ? "" : t.SUBJECTCODE).Length == 3).Sum(t => t.ThisaccountsTotal); } if (ysAcc.SUBJECTCODE == "5QM1") { ysAcc.FINALACCOUNTSTOTAL = (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "4BNHJSR") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "4BNHJSR").FINALACCOUNTSTOTAL) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5BNHJZC") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5BNHJZC").FINALACCOUNTSTOTAL); ysAcc.BUDGETTOTAL = (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "4BNHJSR") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "4BNHJSR").BUDGETTOTAL) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5BNHJZC") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5BNHJZC").BUDGETTOTAL); ysAcc.ADJUSTMENT = (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "4BNHJSR") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "4BNHJSR").ADJUSTMENT) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5BNHJZC") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5BNHJZC").ADJUSTMENT); ysAcc.APPROVEDBUDGETTOTAL = (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "4BNHJSR") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "4BNHJSR").APPROVEDBUDGETTOTAL) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5BNHJZC") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5BNHJZC").APPROVEDBUDGETTOTAL); ysAcc.ThisaccountsTotal = (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "4BNHJSR") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "4BNHJSR").ThisaccountsTotal) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5BNHJZC") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5BNHJZC").ThisaccountsTotal); } if (ysAcc.SUBJECTCODE == "5QM6") { ysAcc.FINALACCOUNTSTOTAL = (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM1") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM1").FINALACCOUNTSTOTAL) + (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM2") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM2").FINALACCOUNTSTOTAL) + (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM3") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM3").FINALACCOUNTSTOTAL) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM4") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM4").FINALACCOUNTSTOTAL) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM5") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM5").FINALACCOUNTSTOTAL); ysAcc.BUDGETTOTAL = (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM1") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM1").BUDGETTOTAL) + (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM2") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM2").BUDGETTOTAL) + (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM3") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM3").BUDGETTOTAL) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM4") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM4").BUDGETTOTAL) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM5") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM5").BUDGETTOTAL); ysAcc.ADJUSTMENT = (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM1") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM1").ADJUSTMENT) + (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM2") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM2").ADJUSTMENT) + (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM3") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM3").ADJUSTMENT) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM4") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM4").ADJUSTMENT) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM5") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM5").ADJUSTMENT); ysAcc.APPROVEDBUDGETTOTAL = (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM1") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM1").APPROVEDBUDGETTOTAL) + (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM2") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM2").APPROVEDBUDGETTOTAL) + (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM3") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM3").APPROVEDBUDGETTOTAL) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM4") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM4").APPROVEDBUDGETTOTAL) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM5") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM5").APPROVEDBUDGETTOTAL); ysAcc.ThisaccountsTotal = (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM1") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM1").ThisaccountsTotal) + (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM2") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM2").ThisaccountsTotal) + (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM3") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM3").ThisaccountsTotal) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM4") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM4").ThisaccountsTotal) - (ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM5") == null ? 0 : ysAccounts.ToList().Find(t => t.SUBJECTCODE == "5QM5").ThisaccountsTotal); } if (ysAcc.BUDGETTOTAL == 0) { ysAcc.BudgetComplete = 100; } else { ysAcc.BudgetComplete = ysAcc.APPROVEDBUDGETTOTAL / ysAcc.BUDGETTOTAL * 100; } if (ysAcc.APPROVEDBUDGETTOTAL == 0) { ysAcc.COMPLETE = 100; } else { ysAcc.COMPLETE = ysAcc.ThisaccountsTotal / ysAcc.APPROVEDBUDGETTOTAL * 100; } } } param.infoData.YsAccounts = ysAccounts; } //if ("1".Equals(param.value)) //{ // if(param.infoData.VerifyStart == 1) // { // return DCHelper.ErrorMessage("年初申报数据已上报,不能修改!"); // } //} //else if ("2".Equals(param.value)) //{ // if (param.infoData.VerifyMiddle == 1) // { // return DCHelper.ErrorMessage("年中调整数据已上报,不能修改!"); // } //} //else if ("3".Equals(param.value)) //{ // if (param.infoData.VerifyEnd == 1) // { // return DCHelper.ErrorMessage("年末决算数据已上报,不能修改!"); // } //} SavedResult <long> savedResult = new SavedResult <long>(); savedResult = this.YsAccountMstService.SaveYsAccount(param.infoData, param.orgid, param.orgCode, param.Year, param.uid, param.value); return(DataConverterHelper.SerializeObject(savedResult)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public string PostSave([FromBody] AllYsIncomeRequestModel param) { if (param.YsIncomeMst == null || param.YsIncomeDtls == null || param.YsIncomeDtls.Count <= 0) { return(DCHelper.ErrorMessage("传递的收入预算信息不能为空!")); } if (param.orgid == 0 || param.YsIncomeMst.FOrgID == 0) { return(DCHelper.ErrorMessage("组织信息不能为空!")); } if (string.IsNullOrEmpty(param.Year) || string.IsNullOrEmpty(param.YsIncomeMst.FYear)) { return(DCHelper.ErrorMessage("年度信息不能为空!")); } try { if (param.YsIncomeMst.FApproval != 0 || param.YsIncomeMst.FIsbudget != 0) { return(DCHelper.ErrorMessage("只有待送审,未生成预算的收入预算可以进行修改!")); } IList <YsIncomeDtlModel> ysIncomeDtls = new List <YsIncomeDtlModel>(); //先进行数据调整 if (param.YsIncomeMst.PhId == 0) { param.YsIncomeMst.FDeclareTime = DateTime.Now; param.YsIncomeMst.PersistentState = PersistentState.Added; foreach (var dtl in param.YsIncomeDtls) { if (dtl.PhId == 0) { if (dtl.PersistentState == PersistentState.Deleted) { continue; } dtl.PersistentState = PersistentState.Added; } else { if (dtl.PersistentState != PersistentState.Deleted) { dtl.PersistentState = PersistentState.Modified; } } ysIncomeDtls.Add(dtl); } } else { param.YsIncomeMst.FDeclareTime = DateTime.Now; //没打上删除标记的都是修改 if (param.YsIncomeMst.PersistentState != PersistentState.Deleted) { param.YsIncomeMst.PersistentState = PersistentState.Modified; foreach (var dtl in param.YsIncomeDtls) { if (dtl.PhId == 0) { if (dtl.PersistentState == PersistentState.Deleted) { continue; } dtl.PersistentState = PersistentState.Added; } else { if (dtl.PersistentState != PersistentState.Deleted) { dtl.PersistentState = PersistentState.Modified; } } ysIncomeDtls.Add(dtl); } } else { foreach (var dtl in param.YsIncomeDtls) { if (dtl.PhId == 0) { continue; } dtl.PersistentState = PersistentState.Deleted; ysIncomeDtls.Add(dtl); } } } param.YsIncomeMst.FDeclareAmount = ysIncomeDtls.ToList().FindAll(t => t.PersistentState != PersistentState.Deleted).Sum(t => t.FBudgetamount); SavedResult <long> savedResult = new SavedResult <long>(); savedResult = this.YsIncomeMstService.SaveYsIncome(param.YsIncomeMst, ysIncomeDtls); return(DataConverterHelper.SerializeObject(savedResult)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
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)); } }
//系统功能树 public ActionResult MainFrameView() { long userid = AppInfoBase.UserID; string usertype = AppInfoBase.UserType; //把用户自定义添加的管理对象,从数据库取出,以viewbag传到页面 string ExistId = MenuConfigProxy.Load(userid); ViewBag.ExistId = ExistId; //把系统的全部管理对象,从配置文件取出,以viewbag传到页面 string logid = NG3.AppInfoBase.LoginID; string xmlFile = AppDomain.CurrentDomain.BaseDirectory + @"/NG3Config/TabPageChoose.xml"; //string xmlFile = "TabPageChoose.xml"; DataSet ds = MenuConfigProxy.ConvertXMLToDataSet(xmlFile); //路径怎么破 DataTable dt = ds.Tables[0]; //i6s没有合同树套件 string product = AppInfoBase.UP.Product; string series = AppInfoBase.UP.Series; //i8 15.1 去掉合同和文档 DataRow[] dr = dt.Select("TabPageID = 'TabPageContractManage'"); if (dr.Length > 0) { dt.Rows.Remove(dr[0]); } dr = dt.Select("TabPageID = 'tabPageWmDocTree'"); if (dr.Length > 0) { dt.Rows.Remove(dr[0]); } dr = dt.Select("TabPageID = 'tabPageNavigation'"); if (dr.Length > 0) { dt.Rows.Remove(dr[0]); } ViewBag.ProductId = product + series; int totalRecord = 0; string json = DataConverterHelper.ToJson(dt, totalRecord); ViewBag.DT = json; //把企业功能树是否启用、是否显示,系统功能树是否显示,从数据库读出,以viewbag传到页面 //系统管理员固定显示系统功能树和我的功能树 if (String.Compare(usertype, UserType.System, true) == 0) { ViewBag.LoadEnFuncTreeRight = "001"; } else { json = MenuConfigProxy.LoadEnFuncTreeRight(); ViewBag.LoadEnFuncTreeRight = json; } //把页面隐藏与否的状态从数据库读出,以viewbag传到页面 json = MenuConfigProxy.GetDockControl(userid); ViewBag.isDockControl = json; //把页面换肤的主题状态从数据库读出,以viewbag传到页面 json = MenuConfigProxy.GetUITheme(userid); ViewBag.UITheme = json; //把用户类型传到页面,控制是否显示管理对象栏 ViewBag.UserType = AppInfoBase.UserType; return(View("MainFrameView")); }
public async Task <string> PostUploadFile() { try { if (!Request.Content.IsMimeMultipartContent()) { var data1 = new { Status = ResponseStatus.Error, Msg = "请求数据不是multipart/form-data类型", Data = "" }; return(DataConverterHelper.SerializeObject(data1)); } //web api 获取项目根目录下指定的文件下 var root = System.Web.Hosting.HostingEnvironment.MapPath("~/UpLoadFiles/Payment/"); string date = DateTime.Now.ToString("yyyy-MM-dd"); string resourcePath = Path.Combine(root, date); if (!Directory.Exists(resourcePath)) { Directory.CreateDirectory(resourcePath); } var multipartMemoryStreamProvider = await Request.Content.ReadAsMultipartAsync(); var contentsList = multipartMemoryStreamProvider.Contents; //获取表单数据 Dictionary <string, string> dic = new Dictionary <string, string>(); //List<FileParameter> paraList = new List<FileParameter>(); List <string> files = new List <string>(); //原始文件名 List <string> oldnames = new List <string>(); List <QtAttachmentModel> list = new List <QtAttachmentModel>(); foreach (var content in contentsList) { //通过判断fileName是否为空,判断是否为文件类型 if (!string.IsNullOrEmpty(content.Headers.ContentDisposition.FileName)) { string fileName = content.Headers.ContentDisposition.FileName.Replace("\"", string.Empty); using (Stream stream = await content.ReadAsStreamAsync()) { //文件如果大于100MB 提示不允许 if (stream.Length > 104857600) { return(DCHelper.ErrorMessage("上传的文件不能大于100MB!")); } byte[] bytes = new byte[stream.Length]; stream.Read(bytes, 0, bytes.Length); stream.Seek(0, SeekOrigin.Begin); //获取对应文件后缀名 string extension = Path.GetExtension(fileName); //获取文件名 string b_name = Path.GetFileName(fileName); //修改文件名 string newFileName = Guid.NewGuid().ToString("N") + extension; string uploadPath = Path.Combine(resourcePath, newFileName); //保存文件 MemoryStream ms = new MemoryStream(bytes); FileStream fs = new FileStream(uploadPath, FileMode.Create); ms.WriteTo(fs); ms.Close(); fs.Close(); string b_urlpath = "/UpLoadFiles/Payment/" + date + "/" + newFileName; QtAttachmentModel model = new QtAttachmentModel(); model.BName = b_name; model.BType = extension; model.BSize = decimal.Round((decimal)stream.Length / (1024), 2); //保留2位小数 //model.BFilebody = bytes; model.BUrlpath = b_urlpath; model.BTable = "BK3_PAYMENT_XM"; model.BRemark = ""; list.Add(model); //返回文件相对路径 files.Add(b_urlpath); oldnames.Add(b_name); } } else { string val = await content.ReadAsStringAsync(); dic.Add(content.Headers.ContentDisposition.Name.ToString(), val); } } var data = new { Status = ResponseStatus.Success, Msg = "附件上传成功。", Data = list, Attachment = files, Oldnames = oldnames }; return(DataConverterHelper.SerializeObject(data)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }