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