public async Task <ResponseModel> GetList(FilterModel filter) { ResponseModel response = new ResponseModel(); try { var query = from m in _context.ContractTypeRepository.Query() where !m.Deleted orderby m.Precedence select new ContractTypeModel() { Id = m.Id, Code = m.Code, Name = m.Name, Description = m.Description, AllowInsurance = m.AllowInsurance, AllowLeaveDate = m.AllowLeaveDate, Precedence = m.Precedence, IsActive = m.IsActive, RowVersion = m.RowVersion, }; if (!string.IsNullOrEmpty(filter.Text)) { query = query.Where(m => m.Code.ToLower().Contains(filter.Text) || m.Name.ToLower().Contains(filter.Text) || m.Description.ToLower().Contains(filter.Text)); } BaseListModel <ContractTypeModel> listItems = new BaseListModel <ContractTypeModel>(); listItems.TotalItems = await _context.ContractTypeRepository.Query().Where(m => !m.Deleted).CountAsync(); listItems.Items = await query.Skip(filter.Paging.PageIndex *filter.Paging.PageSize).Take(filter.Paging.PageSize).ToListAsync().ConfigureAwait(false); response.Result = listItems; } catch (Exception ex) { throw ex; } return(response); }
/// <summary> /// Process list of data based on pagesize and page index. /// </summary> /// <typeparam name="T">Object type.</typeparam> /// <param name="source">Source query.</param> /// <param name="pageIndex">Current page.</param> /// <param name="pageSize">Page size.</param> /// <returns>BaseListModel.</returns> public static async Task <BaseListModel <T> > ToBaseListDistinct <T>(this IQueryable <T> source, int pageIndex, int pageSize) where T : class { var result = new BaseListModel <T>(); if (source != null || source.Any()) { result.TotalItems = await source.CountAsync().ConfigureAwait(false); if (pageSize > 0) { var skipCount = (pageIndex - 1) * pageSize; source = source.Skip(skipCount).Take(pageSize); } result.Items = await source.Distinct().ToListAsync().ConfigureAwait(false); } return(result); }
public string GetPendingTaskInstances([FromUri] BaseListModel paramters) { try { DbHelper.Open(); int index = paramters.pageindex; int psize = 15; if (paramters.pagesize != 0) { psize = paramters.pagesize; } string filter = ""; if (!string.IsNullOrWhiteSpace(paramters.filter)) { filter = paramters.filter; } string sortstr = ""; if (!string.IsNullOrWhiteSpace(paramters.sortstr)) { sortstr = paramters.sortstr; } int rowCount = 0; DataTable dt = WorkFlowDac.Instance.GetPendingTaskInstances4MobileApp(paramters.userid, psize, index, ref rowCount, filter, sortstr); return(DCHelper.ModelListToJson(dt, rowCount, paramters.pageindex, paramters.pagesize)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } finally { DbHelper.Close(); } }
public string GetExpenseCategoryList([FromUri] BaseListModel baseList) { try { //Dictionary<string, object> dic = new Dictionary<string, object>(); //new CreateCriteria(dic).Add(ORMRestrictions<long>.NotEq("PhId", (long)0)); //var result = this.ExpenseCategoryService.Find(dic); Dictionary <string, object> dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dylx", "08")); if (!string.IsNullOrEmpty(baseList.orgid)) { new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dwdm", baseList.orgid)); } var result = ExpenseCategoryService.ServiceHelper.LoadWithPageInfinity("GQT.QT.DYGX2-ZCLB", dicWhere).Results; return(DataConverterHelper.SerializeObject(result)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public string PostCancetPaymentList([FromBody] BaseListModel paramters) { try { if (paramters.fPhIdList == null || paramters.fPhIdList.Count() < 1) { return(DCHelper.ErrorMessage("传递的单据集合有误!")); } List <long> fCodes = new List <long>(); for (int i = 0; i < paramters.fPhIdList.Count(); i++) { fCodes.Add(long.Parse(paramters.fPhIdList[i])); } var result = this.PaymentMstService.PostCancetPaymentList(fCodes); return(DataConverterHelper.SerializeObject(result)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public object GetBizFiledHelpData([FromUri] BaseListModel paramters) { try { DbHelper.Open(); int rowCount = 0; DataTable dt = WorkFlowDac.Instance.GetMobileBizFiledHelpData(paramters.sqlstr, paramters.pagesize, paramters.pageindex, ref rowCount, paramters.filter); return(AppJsonHelper.ConvertDtToJson(dt, "data", rowCount)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } finally { DbHelper.Close(); } }
private string GetXmlFilePath(BaseListModel model) { //string filePath = System.AppDomain.CurrentDomain.BaseDirectory + "realdata\\2012-10-19-9-4-27_AI.xml"; string filePath; try { int sobjectid = model.ObjectId; int stype = model.CategoryId; string queryString = "sobjectid=" + sobjectid + "&stype=" + stype; string queryCache = NTS.WEB.Common.CacheHelper.GetCache("CurQueryString") == null ? "" : NTS.WEB.Common.CacheHelper.GetCache("CurQueryString").ToString(); object queryPath = NTS.WEB.Common.CacheHelper.GetCache("CurQueryPath"); if (queryCache != string.Empty && queryPath != null && queryCache == queryString) { filePath = queryPath.ToString(); } else { var inter = new IRealtimeData(); filePath = inter.sergetcurrentdata(sobjectid, 3, stype); if (ConfigurationManager.AppSettings["realtimedataurl"].IndexOf("localhost", System.StringComparison.Ordinal) == -1) { filePath = string.Format("{0}{1}", ConfigurationManager.AppSettings["serverurl"], filePath.Substring(filePath.LastIndexOf("\\", StringComparison.Ordinal))); } NTS.WEB.Common.CacheHelper.SetCache("CurQueryString", queryString); NTS.WEB.Common.CacheHelper.SetCache("CurQueryPath", filePath); } } catch (Exception ex) { throw new Exception(ex.Message); } return(filePath); }
public async Task <ResponseModel> GetList(FilterModel filter) { ResponseModel response = new ResponseModel(); try { var query = from m in _context.DistrictRepository.Query() join p in _context.ProvinceRepository.Query() on m.ProvinceId equals p.Id where !m.Deleted orderby p.Precedence ascending, m.Precedence ascending select new DistrictModel { Id = m.Id, Name = m.Name, ProvinceId = m.ProvinceId, ProvinceName = p.Name, Precedence = m.Precedence, IsActive = m.IsActive, RowVersion = m.RowVersion, }; if (!string.IsNullOrEmpty(filter.Text)) { query = query.Where(m => m.Name.ToLower().Contains(filter.Text) || m.ProvinceName.ToLower().Contains(filter.Text)); } BaseListModel <DistrictModel> listItems = new BaseListModel <DistrictModel>(); listItems.TotalItems = await _context.DistrictRepository.Query().Where(m => !m.Deleted).CountAsync(); listItems.Items = await query.Skip(filter.Paging.PageIndex *filter.Paging.PageSize).Take(filter.Paging.PageSize).ToListAsync().ConfigureAwait(false); response.Result = listItems; } catch (Exception ex) { throw ex; } return(response); }
public string PostSaveUserYear([FromBody] BaseListModel parameters) { if (string.IsNullOrEmpty(parameters.uid)) { return(DCHelper.ErrorMessage("用户主键不能为空!")); } if (string.IsNullOrEmpty(parameters.Year)) { return(DCHelper.ErrorMessage("年份信息不能为空!")); } try { var dicWhere = new Dictionary <string, object>(); new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dylx", "YEAR")) .Add(ORMRestrictions <string> .Eq("Dwdm", parameters.uid)); var Model2 = CorrespondenceSettings2Service.Find(dicWhere).Data; if (Model2 != null && Model2.Count > 0) { Model2[0].Dydm = parameters.Year; Model2[0].PersistentState = PersistentState.Modified; var result = CorrespondenceSettings2Service.Save <Int64>(Model2[0], ""); return(DataConverterHelper.SerializeObject(result)); } else { CorrespondenceSettings2Model model = new CorrespondenceSettings2Model(); model.Dydm = parameters.Year; model.Dylx = "YEAR"; model.Dwdm = parameters.uid; model.PersistentState = PersistentState.Added; var result = CorrespondenceSettings2Service.Save <Int64>(model, ""); return(DataConverterHelper.SerializeObject(result)); } } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public string GetMSYHProjectReport([FromUri] BaseListModel param) { if (param.FPhid == 0) { return(DCHelper.ErrorMessage("单据主键不能为空!")); } try { var result = this.XmReportMstService.GetMSYHProjectReport(param.FPhid); var data = new { Status = ResponseStatus.Success, Msg = "获取成功!", Data = result }; return(DataConverterHelper.SerializeObject(data)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public async Task <ResponseModel> GetList(FilterModel filter) { ResponseModel response = new ResponseModel(); try { var query = from m in _context.AppraiseQuestionRepository.Query() where !m.Deleted orderby m.CreateDate descending select new AppraiseQuestionModel() { Id = m.Id, Name = m.Name, Description = m.Description, IsInputAnswer = m.IsInputAnswer, AppraiseSectionId = m.AppraiseSectionId, IsActive = m.IsActive, RowVersion = m.RowVersion, }; if (!string.IsNullOrEmpty(filter.Text)) { query = query.Where(m => m.Name.ToLower().Contains(filter.Text) || m.Description.ToLower().Contains(filter.Text)); } BaseListModel <AppraiseQuestionModel> listItems = new BaseListModel <AppraiseQuestionModel>(); listItems.TotalItems = await _context.AppraiseQuestionRepository.Query().Where(m => !m.Deleted).CountAsync(); listItems.Items = await query.Skip(filter.Paging.PageIndex *filter.Paging.PageSize).Take(filter.Paging.PageSize).ToListAsync().ConfigureAwait(false); response.Result = listItems; } catch (Exception ex) { throw ex; } return(response); }
public async Task <ResponseModel> GetList(FilterModel filter) { ResponseModel response = new ResponseModel(); try { var query = from m in _context.ProfessionalQualificationRepository.Query() where !m.Deleted orderby m.Precedence ascending select new ProfessionalQualificationModel { Id = m.Id, Name = m.Name, Precedence = m.Precedence, IsActive = m.IsActive, CreateBy = m.CreateBy.ToString(), CreateDate = m.CreateDate, RowVersion = m.RowVersion, }; if (!string.IsNullOrEmpty(filter.Text)) { query = query.Where(m => m.Name.ToLower().Contains(filter.Text)); } BaseListModel <ProfessionalQualificationModel> listItems = new BaseListModel <ProfessionalQualificationModel>(); listItems.TotalItems = await _context.ProfessionalQualificationRepository.Query().Where(m => !m.Deleted).CountAsync(); listItems.Items = await query.Skip(filter.Paging.PageIndex *filter.Paging.PageSize).Take(filter.Paging.PageSize).ToListAsync().ConfigureAwait(false); response.Result = listItems; } catch (Exception ex) { throw ex; } return(response); }
public string GetJXJLset([FromUri] BaseListModel param) { if (string.IsNullOrEmpty(param.orgCode)) { return(DCHelper.ErrorMessage("组织编码不能为空!")); } try { IList <CorrespondenceSettings2Model> correspondenceSettings2s = new List <CorrespondenceSettings2Model>(); correspondenceSettings2s = this.CorrespondenceSettings2Service.Find(t => t.Dylx == "JXJL" && t.Dwdm == param.orgCode).Data; var data = new { Status = ResponseStatus.Success, Msg = "获取成功!", Data = correspondenceSettings2s }; return(DataConverterHelper.SerializeObject(data)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public async Task <ResponseModel> GetList(FilterModel filter) { ResponseModel response = new ResponseModel(); try { var query = from p in _context.PositionRepository.Query() where !p.Deleted && p.IsActive orderby p.Name ascending select new PositionModel() { Id = p.Id, Name = p.Name, Description = p.Description, Precedence = p.Precedence, IsActive = p.IsActive, RowVersion = p.RowVersion, }; if (!string.IsNullOrEmpty(filter.Text)) { query = query.Where(p => p.Name.ToLower().Contains(filter.Text)); } var listItems = new BaseListModel <PositionModel>(); listItems.TotalItems = await _context.PositionRepository.Query().Where(p => !p.Deleted).CountAsync(); listItems.Items = await query.Skip(filter.Paging.PageIndex *filter.Paging.PageSize).Take(filter.Paging.PageSize).ToListAsync().ConfigureAwait(false); response.Result = listItems; } catch (Exception ex) { throw ex; } return(response); }
public async Task <ResponseModel> GetList(FilterModel filter) { ResponseModel response = new ResponseModel(); try { var query = from m in _context.EmployeeInfoRepository.Query() where !m.Deleted orderby m.FirstName ascending select new EmployeeInfoModel { Id = m.Id, FirstName = m.FirstName, LastName = m.LastName, IsActive = m.IsActive, RowVersion = m.RowVersion, }; if (!string.IsNullOrEmpty(filter.Text)) { query = query.Where(m => m.FirstName.ToLower().Contains(filter.Text) || m.LastName.ToLower().Contains(filter.Text)); } BaseListModel <EmployeeInfoModel> listItems = new BaseListModel <EmployeeInfoModel>(); listItems.TotalItems = await _context.EmployeeInfoRepository.Query().Where(m => !m.Deleted).CountAsync(); listItems.Items = await query.Skip(filter.Paging.PageIndex *filter.Paging.PageSize).Take(filter.Paging.PageSize).ToListAsync().ConfigureAwait(false); response.Result = listItems; } catch (Exception ex) { throw ex; } return(response); }
public string PostBudget([FromBody] BaseListModel param) { //if (param.FPhIds == null || param.FPhIds.Count <= 0) //{ // return DCHelper.ErrorMessage("生成收入预算集合不能为空!"); //} if (param.FPhId == 0) { return(DCHelper.ErrorMessage("生成预算信息不能为空!")); } if (param.uid == 0) { return(DCHelper.ErrorMessage("生成预算人员信息不能为空!")); } try { var result = this.YsIncomeMstService.SaveBudget(param.FPhId, param.uid); return(DataConverterHelper.SerializeObject(result)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public object GetAllUser([FromUri] BaseListModel paramters) { try { string jsonStr = string.Empty; DbHelper.Open(); int rowCount = 0; DataTable dt = UserOrgIntegrationDac.Instance.SearchUsersByPageIndex(string.Empty, paramters.filter, paramters.pageindex.ToString(), paramters.pagesize.ToString(), ref rowCount); dt.Columns["phid"].ColumnName = "userId"; dt.Columns["userno"].ColumnName = "userNo"; dt.Columns["username"].ColumnName = "userName"; dt.Columns["deptname"].ColumnName = "deptName"; return(AppJsonHelper.ConvertDtToJson(dt, "data", rowCount)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } finally { DbHelper.Close(); } }
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 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 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 string getUserByOrg([FromUri] string OrgCode, [FromUri] BaseListModel parameters, [FromUri] string queryStr) { var result = CorrespondenceSettingsService.getUserByOrg(OrgCode, queryStr); return(DCHelper.ModelListToJson <CorrespondenceSettingsModel>(result.Data, (Int32)result.Data.Count)); }
public string GetinfoByDept([FromUri] BaseListModel param) { var result = ExpenseMstService.GetinfoByDept(param.orgCode, param.Year); return(DataConverterHelper.SerializeObject(result)); }
public ResultReal GetRealTime(NTS.WEB.DataContact.RealQuery query) { ResultReal result = new ResultReal(); var objectList = new NTS.WEB.BLL.BaseLayerObject().GetDeviceObjectList(string.Format(" and deviceid={0}", query.ObjectId), " order by deviceid"); var itemList = new BLL.Itemcode().GetItemcodeList(" and ItemCodeNumber='" + objectList[0].ItemCodeID + "'", " order by ItemcodeID")[0]; result.Info = new DeviceInfo(); result.Data = new RealData(); result.Info.Affiliations = objectList[0].Organization; result.Info.DevType = objectList[0].DeviceType.ToString(CultureInfo.InvariantCulture); result.Info.Category = (itemList.ItemCodeNumber == "01000" || itemList.ItemCodeNumber == "01A00" || itemList.ItemCodeNumber == "01B00" || itemList.ItemCodeNumber == "01C00" || itemList.ItemCodeNumber == "01D00") ? "电表" : itemList.ItemCodeName + "表"; result.Info.Nature = objectList[0].DEVMODE; result.Info.Number = objectList[0].DeviceNumber; result.Info.Status = objectList[0].Status; result.Info.Location = objectList[0].Location; result.Info.Rating = objectList[0].Rating.ToString(); if (query.IsDetail == 1) { for (int i = 1; i < 4; i++) { BaseListModel model = new BaseListModel(); model.Page = 1; model.PageSize = 10000; model.ObjectId = objectList[0].DeviceID; model.CategoryId = i; DataTable dt = new Real().GetRealTimeData(model); if (dt.Rows.Count > 0) { if (i == 1) { result.Data.Pulse = new List <dataUnit>(); for (int j = 0; j < dt.Rows.Count; j++) { result.Data.Pulse.Add(new dataUnit() { Id = j + 1, DataName = dt.Rows[j]["DataPoint_Name"].ToString(), Unit = itemList.Unit, Value = decimal.Parse(dt.Rows[j]["Result"].ToString()) }); } } else if (i == 2) { result.Data.Analog = new List <dataUnit>(); for (int j = 0; j < dt.Rows.Count; j++) { result.Data.Analog.Add(new dataUnit() { Id = j + 1, DataName = dt.Rows[j]["DataPoint_Name"].ToString(), Unit = itemList.Unit, Value = decimal.Parse(dt.Rows[j]["Result"].ToString()) }); } } else { result.Data.Switch = new List <dataUnit>(); for (int j = 0; j < dt.Rows.Count; j++) { result.Data.Switch.Add(new dataUnit() { Id = j + 1, DataName = dt.Rows[j]["DataPoint_Name"].ToString(), Unit = itemList.Unit, Value = decimal.Parse(dt.Rows[j]["Result"].ToString()) }); } } } } } //result.Data.Analog = new List<dataUnit>(); //result.Data.Analog.Add(new dataUnit() { Id = 1, DataName = "29189H92-00", Unit = "kwh", Value = 900.88m }); //result.Data.Pulse = new List<dataUnit>(); //result.Data.Pulse.Add(new dataUnit() { Id = 1, DataName = "29189H92-10", Unit = "kwh", Value = 400.88m }); //result.Data.Switch = new List<dataUnit>(); //result.Data.Switch.Add(new dataUnit() { Id = 1, DataName = "29189H92-20", Unit = "kwh", Value = 200.88m }); return(result); }
public string GetAllCoverUpList([FromUri] BaseListModel param) { if (string.IsNullOrEmpty(param.uCode)) { return(DCHelper.ErrorMessage("用户编码不能为空!")); } if (string.IsNullOrEmpty(param.processCode)) { return(DCHelper.ErrorMessage("过程选择不能为空!")); } try { if (param.uCode != "Admin") { return(DCHelper.ErrorMessage("非Admin用户无权限访问此功能!")); } //内置的模板数据 var allCoverUps = this.QtCoverUpDataService.GetQtCoverUpDataList(); IList <AllCoverUpModel> allCoverUpModels = new List <AllCoverUpModel>(); if (param.processCode.Equals("001")) { AllCoverUpModel allCoverUpModel = new AllCoverUpModel(); allCoverUpModel.ProcessCode = "001"; allCoverUpModel.ProcessName = "预立项"; allCoverUpModel.QtCoverUpForOrgs = this.QtCoverUpForOrgService.GetQtCoverUpForOrgs(allCoverUpModel.ProcessCode, allCoverUpModel.ProcessName); allCoverUpModels.Add(allCoverUpModel); } else if (param.processCode.Equals("002")) { AllCoverUpModel allCoverUpModel = new AllCoverUpModel(); allCoverUpModel.ProcessCode = "002"; allCoverUpModel.ProcessName = "项目立项"; allCoverUpModel.QtCoverUpForOrgs = this.QtCoverUpForOrgService.GetQtCoverUpForOrgs(allCoverUpModel.ProcessCode, allCoverUpModel.ProcessName); allCoverUpModels.Add(allCoverUpModel); } else if (param.processCode.Equals("003")) { AllCoverUpModel allCoverUpModel = new AllCoverUpModel(); allCoverUpModel.ProcessCode = "003"; allCoverUpModel.ProcessName = "年中新增"; allCoverUpModel.QtCoverUpForOrgs = this.QtCoverUpForOrgService.GetQtCoverUpForOrgs(allCoverUpModel.ProcessCode, allCoverUpModel.ProcessName); allCoverUpModels.Add(allCoverUpModel); } else if (param.processCode.Equals("004")) { AllCoverUpModel allCoverUpModel = new AllCoverUpModel(); allCoverUpModel.ProcessCode = "004"; allCoverUpModel.ProcessName = "年中调整"; allCoverUpModel.QtCoverUpForOrgs = this.QtCoverUpForOrgService.GetQtCoverUpForOrgs(allCoverUpModel.ProcessCode, allCoverUpModel.ProcessName); allCoverUpModels.Add(allCoverUpModel); } //else if (param.processCode.Equals("003")) //{ // AllCoverUpModel allCoverUpModel = new AllCoverUpModel(); // allCoverUpModel.ProcessCode = "003"; // allCoverUpModel.ProcessName = "项目立项申报"; // allCoverUpModel.QtCoverUpForOrgs = this.QtCoverUpForOrgService.GetQtCoverUpForOrgs(allCoverUpModel.ProcessCode, allCoverUpModel.ProcessName); // allCoverUpModels.Add(allCoverUpModel); //} //else if (param.processCode.Equals("004")) //{ // AllCoverUpModel allCoverUpModel = new AllCoverUpModel(); // allCoverUpModel.ProcessCode = "004"; // allCoverUpModel.ProcessName = "项目立项汇总"; // allCoverUpModel.QtCoverUpForOrgs = this.QtCoverUpForOrgService.GetQtCoverUpForOrgs(allCoverUpModel.ProcessCode, allCoverUpModel.ProcessName); // allCoverUpModels.Add(allCoverUpModel); //} else { //(获取四个过程项) AllCoverUpModel allCoverUpModel1 = new AllCoverUpModel(); allCoverUpModel1.ProcessCode = "001"; allCoverUpModel1.ProcessName = "预立项"; allCoverUpModel1.QtCoverUpForOrgs = this.QtCoverUpForOrgService.GetQtCoverUpForOrgs(allCoverUpModel1.ProcessCode, allCoverUpModel1.ProcessName); allCoverUpModels.Add(allCoverUpModel1); AllCoverUpModel allCoverUpModel2 = new AllCoverUpModel(); allCoverUpModel2.ProcessCode = "002"; allCoverUpModel2.ProcessName = "项目立项"; allCoverUpModel2.QtCoverUpForOrgs = this.QtCoverUpForOrgService.GetQtCoverUpForOrgs(allCoverUpModel2.ProcessCode, allCoverUpModel2.ProcessName); allCoverUpModels.Add(allCoverUpModel2); AllCoverUpModel allCoverUpModel3 = new AllCoverUpModel(); allCoverUpModel3.ProcessCode = "003"; allCoverUpModel3.ProcessName = "年中新增"; allCoverUpModel3.QtCoverUpForOrgs = this.QtCoverUpForOrgService.GetQtCoverUpForOrgs(allCoverUpModel3.ProcessCode, allCoverUpModel3.ProcessName); allCoverUpModels.Add(allCoverUpModel3); AllCoverUpModel allCoverUpModel4 = new AllCoverUpModel(); allCoverUpModel4.ProcessCode = "004"; allCoverUpModel4.ProcessName = "年中调整"; allCoverUpModel4.QtCoverUpForOrgs = this.QtCoverUpForOrgService.GetQtCoverUpForOrgs(allCoverUpModel4.ProcessCode, allCoverUpModel4.ProcessName); allCoverUpModels.Add(allCoverUpModel4); } var data = new { Status = ResponseStatus.Success, Msg = "获取成功!", Data = allCoverUpModels, }; return(DataConverterHelper.SerializeObject(data)); } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }
public string PostDelete([FromBody] BaseListModel paramters) { try { List <long> fCodes = new List <long>(); if (paramters.fPhIdList.Count() < 1) { return(DCHelper.ErrorMessage("删除的申请单编码列表不能为空!")); } else { for (int i = 0; i < paramters.fPhIdList.Count(); i++) { fCodes.Add(long.Parse(paramters.fPhIdList[i])); } Dictionary <string, object> dic = new Dictionary <string, object>(); new CreateCriteria(dic) .Add(ORMRestrictions <List <long> > .In("PhId", fCodes)); var result = this.PaymentMstService.Find(dic).Data; if (result.Count > 0) { string str = ""; foreach (var payment in result) { if (payment.FApproval != 0 && payment.FApproval != 2) { str = str + payment.FCode + ","; } } if (str.Length > 0) { return(DCHelper.ErrorMessage(str + "这些单据无法进行删除操作!")); } } else { return(DCHelper.ErrorMessage("删除的申请单不存在!")); } } var deleteResult = this.PaymentMstService.DeleteSignle(fCodes); if (deleteResult > 0) { var data = new { Status = ResponseStatus.Success, Msg = "删除成功!", }; return(DataConverterHelper.SerializeObject(data)); } else { var data = new { Status = ResponseStatus.Error, Msg = "删除失败!", }; return(DataConverterHelper.SerializeObject(data)); } } catch (Exception ex) { return(DCHelper.ErrorMessage(ex.Message)); } }