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));
}
}
