/// <summary>
/// 判断是否允许修改
/// </summary>
/// <returns></returns>
public string JudgeCode()
{
string code = System.Web.HttpContext.Current.Request.Params["code"];
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic).Add(ORMRestrictions <string> .LLike("DM", code));
IList <ProjLibProjModel> ProjLibProjList = ProjLibProjService.Find(dic).Data;
if (ProjLibProjList.Count > 0)
{
var dmList = ProjLibProjList.ToList().Select(x => x.DM).ToList();
Dictionary <string, object> dic2 = new Dictionary <string, object>();
new CreateCriteria(dic2).Add(ORMRestrictions <List <string> > .In("FProjCode", dmList))
.Add(ORMRestrictions <List <string> > .In("FApproveStatus", new List <string>()
{
"2", "3"
}))
.Add(ORMRestrictions <Int32> .Eq("FLifeCycle", 0));;
var mst = ProjectMstService.Find(dic2).Data;
if (mst.Count > 0)
{
return("false");
}
else
{
return("true");
}
}
else
{
return("true");
}
}
/// <summary>
/// 根据项目代码获取对应归口部门
/// </summary>
/// <param name="Dwdm"></param>
/// <returns></returns>
public List <OrganizeModel> GetBMListDYGXdtl(string Dwdm)
{
List <OrganizeModel> result = new List <OrganizeModel>();
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("Dylx", "GKBM")).
Add(ORMRestrictions <string> .Eq("Dwdm", Dwdm));
IList <CorrespondenceSettings2Model> correspondenceSettings2s = CorrespondenceSettings2Facade.Find(dicWhere, new string[] { "Dydm Asc" }).Data;
if (correspondenceSettings2s.Count > 0)
{
var dicWhereOrg = new Dictionary <string, object>();
new CreateCriteria(dicWhereOrg).
Add(ORMRestrictions <string> .Eq("IfCorp", "N")).
Add(ORMRestrictions <string> .Eq("IsActive", "1"));
IList <OrganizeModel> OrgList = OrganizationFacade.Find(dicWhereOrg).Data;
foreach (CorrespondenceSettings2Model a in correspondenceSettings2s)
{
OrganizeModel b = new OrganizeModel();
b.PhId = a.PhId;
b.OCode = a.Dydm;
b.OName = OrgList.ToList().Find(x => x.OCode == a.Dydm).OName;
result.Add(b);
}
}
return(result);
}
/// <summary>
/// 根据操作员和申报单位取预算部门
/// </summary>
/// <param name="Usercoode"></param>
/// <param name="Unit"></param>
/// <returns></returns>
public IList <OrganizeModel> GetDept(string Usercoode, string Unit)
{
Dictionary <string, object> dic_Corr = new Dictionary <string, object>();
new CreateCriteria(dic_Corr)
.Add(ORMRestrictions <String> .Eq("Dwdm", Usercoode))
.Add(ORMRestrictions <String> .Eq("Dylx", "97"))
.Add(ORMRestrictions <String> .LLike("Dydm", Unit));
IList <CorrespondenceSettingsModel> correspondenceSettings = CorrespondenceSettingsRule.Find(dic_Corr);
List <string> ocodeList = new List <string>();
if (correspondenceSettings.Count > 0)
{
for (var i = 0; i < correspondenceSettings.Count; i++)
{
if (!ocodeList.Contains(correspondenceSettings[i].Dydm))
{
ocodeList.Add(correspondenceSettings[i].Dydm);
}
}
}
Dictionary <string, object> dic_org = new Dictionary <string, object>();
new CreateCriteria(dic_org)
.Add(ORMRestrictions <String> .Eq("IfCorp", "N"))
.Add(ORMRestrictions <String> .Eq("IsActive", "1"))
.Add(ORMRestrictions <List <String> > .In("OCode", ocodeList));
IList <OrganizeModel> organizes = OrganizationRule.Find(dic_org);
return(organizes);
}
/// <summary>
/// 验证数据
/// </summary>
/// <returns></returns>
public FindedResults <BudgetAccountsModel> ExecuteDataCheck(ref List <BudgetAccountsModel> budgetAccounts, string otype)
{
IList <string> kmdm = new List <string>();
FindedResults <BudgetAccountsModel> results = new FindedResults <BudgetAccountsModel>();
if (budgetAccounts == null)
{
results.Status = ResponseStatus.Error;
results.Msg = "保存失败，数据异常！";
}
else
{
for (int i = 0; i < budgetAccounts.Count; i++)
{
budgetAccounts[i].KMDM = budgetAccounts[i].KMDM.Replace(" ", "");
budgetAccounts[i].KMMC = budgetAccounts[i].KMMC.Replace(" ", "");
budgetAccounts[i].KMLB = budgetAccounts[i].KMLB.Replace(" ", "");
kmdm.Add(budgetAccounts[i].KMDM);
}
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <IList <string> > .In("KMDM", kmdm));
results = base.Find(dicWhere);
if (results != null && results.Data.Count > 0 && otype != "edit")
{
results.Status = ResponseStatus.Error;
results.Msg = "保存失败，科目代码重复！";
}
}
return(results);
}
/// <summary>
/// 生成申请单编号
/// </summary>
/// <returns></returns>
public string GetPaymentCode()
{
string paymentCode = "";
string payment = "";
string code = "";
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic).
Add(ORMRestrictions <long> .Ge("PhId", (long)0));
var result = this.PaymentMstRule.Find(dic, new string[] { "FCode Desc" });
if (result != null && result.Count > 0)
{
string fCode = result[0].FCode;
if (fCode.Length == 12)
{
payment = DateTime.Now.ToString("yyyyMMdd");
string fcode1 = fCode.Substring(0, 8);
if (payment.Equals(fcode1))
{
int fcode2 = int.Parse(fCode.Substring(8)) + 1;
if (fcode2 > 999 && fcode2 < 10000)
{
code = fcode2.ToString();
}
else if (fcode2 > 99 && fcode2 < 1000)
{
code = "0" + fcode2;
}
else if (fcode2 > 9 && fcode2 < 100)
{
code = "00" + fcode2;
}
else if (fcode2 > 0 && fcode2 < 10)
{
code = "000" + fcode2;
}
else
{
throw new Exception("申请单号生成失败！");
}
}
else
{
code = "0001";
}
}
else
{
throw new Exception("申请单号为：" + fCode + "的申请编码生成错误，请联系管理员！");
}
}
else
{
payment = DateTime.Now.ToString("yyyyMMdd");
code = "0001";
}
paymentCode = payment + code;
return(paymentCode);
}
public string PostDelete([FromBody] InfoBaseModel <List <long> > phids)
{
var deletedresult = new DeletedResult();
if (phids.infoData.Count > 0)
{
List <long> usePhids = BankAccountService.judgeIfUse(phids.infoData);
if (usePhids.Count > 0)
{
string Msg = "银行账户名称为";
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PhId", usePhids));
IList <BankAccountModel> bankAccounts = BankAccountService.Find(dic).Data;
foreach (BankAccountModel bankAccount in bankAccounts)
{
Msg = Msg + bankAccount.FBankname + ",";
}
Msg = Msg.Substring(0, Msg.Length - 1) + "已被引用不能删除";
deletedresult.Status = ResponseStatus.Error;
deletedresult.Msg = Msg;
}
else
{
for (var i = 0; i < phids.infoData.Count; i++)
{
deletedresult = BankAccountService.Delete <System.Int64>(phids.infoData[i]);
//BankAccountService.Find(t => phids.infoData.Contains(t.PhId));
}
}
}
return(DataConverterHelper.SerializeObject(deletedresult));
}
public string GetProjectThresholdByOrgAndZCLB([FromUri] ProjectMstModel parameters)
{
if (string.IsNullOrEmpty(parameters.FDeclarationUnit))
{
return(DCHelper.ErrorMessage("组织编码为空！"));
}
if (string.IsNullOrEmpty(parameters.FExpenseCategory))
{
return(DCHelper.ErrorMessage("项目类型为空！"));
}
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Orgcode", parameters.FDeclarationUnit));
IList <ProjectThresholdModel> projectThresholds = ProjectThresholdService.Find(dicWhere).Data;
if (projectThresholds.Count > 0)
{
foreach (var projectThreshold in projectThresholds)
{
IList <String> useCodeList = (projectThreshold.ProjTypeId ?? "").Split(',').ToList <String>();
if (useCodeList.Contains(parameters.FExpenseCategory))
{
return(JsonConvert.SerializeObject(projectThreshold));
}
}
}
return(JsonConvert.SerializeObject(new ProjectThresholdModel()));
}
/// <summary>
/// 通过项目主键list获取已使用金钱与已冻结金钱的汇总
/// </summary>
/// <param name="xmPhidList">项目主键list</param>
/// <returns></returns>
public Dictionary <string, object> GetSummary2(List <long> xmPhidList)
{
Dictionary <string, object> keyValue = new Dictionary <string, object>();
decimal sum1 = 0, sum2 = 0;
foreach (long xmPhid in xmPhidList)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic)
.Add(ORMRestrictions <long> .Eq("XmMstPhid", xmPhid))
.Add(ORMRestrictions <long> .NotEq("MstPhid", 0));
var result = this.PaymentDtlRule.Find(dic);
if (result.Count > 0)
{
foreach (var paymentDtl in result)
{
if (paymentDtl.FPayment == 9)
{
sum1 = sum1 + paymentDtl.FAmount;
}
else
{
sum2 = sum2 + paymentDtl.FAmount;
}
}
}
}
keyValue.Add("Use", sum1);
keyValue.Add("Frozen", sum2);
return(keyValue);
}
/// <summary>
/// 保存时获取产品主键
/// </summary>
/// <param name="entities"></param>
/// <returns></returns>
public SavedResult <Int64> Save2(IList <QTProductUserModel> entities)
{
SavedResult <Int64> savedresult = new SavedResult <Int64>();
try
{
for (var i = 0; i < entities.Count; i++)
{
if (entities[i].ProductBZ != "")
{
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic).Add(ORMRestrictions <string> .Eq("ProductBZ", entities[i].ProductBZ));
QTProductModel qTProductModel = QTProductFacade.Find(dic).Data[0];
entities[i].ProductPhid = qTProductModel.PhId;
}
}
savedresult = base.Save <Int64>(entities, "");
}
catch (Exception ex)
{
savedresult.Status = ResponseStatus.Error;
savedresult.Msg = ex.Message.ToString();
}
return(savedresult);
}
/// <summary>
/// 根据主键更新数据
/// </summary>
/// <param name="SetPhId"></param>
/// <returns></returns>
public SavedResult <long> UpdateOrg(string SetPhId)
{
string ControlOrgName = "";
var result = new SavedResult <long>();
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("Dylx", "button")).
Add(ORMRestrictions <string> .Eq("Dwdm", SetPhId));
IList <CorrespondenceSettings2Model> correspondenceSettings2 = CorrespondenceSettings2Facade.Find(dicWhere).Data;
if (correspondenceSettings2.Count > 0)
{
for (var i = 0; i < correspondenceSettings2.Count; i++)
{
ControlOrgName = ControlOrgName + correspondenceSettings2[i].DefStr2 + ";";
}
}
QTControlSetModel qTControlSet = base.Find(long.Parse(SetPhId)).Data;
qTControlSet.ControlOrgName = ControlOrgName;
qTControlSet.PersistentState = PersistentState.Modified;
result = base.Save <long>(qTControlSet, "");
return(result);
}
/// <summary>
/// 根据组织取对应关系列表基础数据详细(得到的PhId为对应关系的主键)（没有对应关系的数据）
/// </summary>
/// <returns>返回Json串</returns>
public string GetBudgetAccountsListNoDYGXdtl()
{
string Dwdm = System.Web.HttpContext.Current.Request.Params["Dwdm"];//查询条件
List <string> list = new List <string>();
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
Dictionary <string, object> dicWhere2 = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dylx", "02"));
if (Dwdm != null)
{
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dwdm", Dwdm));
}
var result = BudgetAccountsService.ServiceHelper.LoadWithPageInfinity("GQT.QT.DYGX-YSKM", dicWhere);
for (var i = 0; i < result.TotalItems; i++)
{
list.Add(result.Results[i].KMDM);
}
if (list.Count > 0)
{
new CreateCriteria(dicWhere2).Add(ORMRestrictions <List <string> > .NotIn("KMDM", list));
}
var result2 = BudgetAccountsService.ServiceHelper.LoadWithPageInfinity("GQT.QT.YSKMAll", dicWhere2);
return(DataConverterHelper.EntityListToJson <BudgetAccountsModel>(result2.Results, (Int32)result2.TotalItems));
}
/// <summary>
/// 导出数据
/// </summary>
/// <returns></returns>
public void ExportData()
{
//string ProductBZ = System.Web.HttpContext.Current.Request.Params["ProductBZ"];
HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
ISheet sheet = book.CreateSheet("sheet1");
IRow row1 = sheet.CreateRow(0);
row1.CreateCell(0).SetCellValue("代码");
row1.CreateCell(1).SetCellValue("名称");
//row1.CreateCell(2).SetCellValue("备注");
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <System.Int64> .NotEq("PhId", 0));
IList <ProcurementCatalogModel> procurementCatalogs = ProcurementCatalogService.Find(dicWhere).Data;
for (int i = 0; i < procurementCatalogs.Count; i++)
{
ProcurementCatalogModel model = procurementCatalogs[i];
IRow row = sheet.CreateRow(i + 1);
row.CreateCell(0).SetCellValue(model.FCode);
row.CreateCell(1).SetCellValue(model.FName);
//row.CreateCell(2).SetCellValue(model.FRemark);
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
Response.BinaryWrite(ms.ToArray());
book = null;
ms.Close();
ms.Dispose();
}
/// <summary>
/// 保存
/// </summary>
/// <returns></returns>
public string Save2()
{
string Orgcode = System.Web.HttpContext.Current.Request.Params["Orgcode"];
string data = System.Web.HttpContext.Current.Request.Params["data"];
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Orgcode", Orgcode));
IList <ProjectThresholdModel> projectThresholdModels = ProjectThresholdService.Find(dicWhere).Data;
List <long> phidList = projectThresholdModels.ToList().Select(x => x.PhId).ToList();
List <ProjectThresholdModel> SaveData = new List <ProjectThresholdModel>();
if (data.EndsWith("|"))
{
data = data.Substring(0, data.Length - 1);
}
String[] Items = data.Split('|');
foreach (String item in Items)
{
//取到item，即序列化对象
String[] attrs = item.Split(':');
if (string.IsNullOrEmpty(attrs[0]) || attrs[0] == "0")
{
var p1 = new ProjectThresholdModel();
p1.Orgcode = attrs[1];
p1.FThreshold = attrs[2];
p1.ProjTypeId = attrs[3];
p1.ProjTypeName = attrs[4];
p1.Orgid = long.Parse(attrs[5]);
p1.PersistentState = PersistentState.Added;
SaveData.Add(p1);
}
else
{
if (phidList.Contains(long.Parse(attrs[0])))
{
phidList.Remove(long.Parse(attrs[0]));
}
var p1 = projectThresholdModels.ToList().Find(x => x.PhId == long.Parse(attrs[0]));
p1.FThreshold = attrs[2];
p1.ProjTypeId = attrs[3];
p1.ProjTypeName = attrs[4];
p1.PersistentState = PersistentState.Modified;
SaveData.Add(p1);
}
}
if (phidList.Count > 0)
{
foreach (var phid in phidList)
{
var p1 = projectThresholdModels.ToList().Find(x => x.PhId == phid);
p1.PersistentState = PersistentState.Deleted;
SaveData.Add(p1);
}
}
SavedResult <Int64> savedresult = ProjectThresholdService.Save <Int64>(SaveData, "");
return(DataConverterHelper.SerializeObject(savedresult));
}
public ActionResult SaveOrUpdate(String data)
{
DataStoreParam dataStoreParam = this.GetDataStoreParam();
var result = CorrespondenceSettingsService.LoadWithPageOrg(dataStoreParam);
//Dictionary<string, object> dicWhere = DataConverterHelper.ConvertToDic("");
IList <OrganizeModel> organizes = result.Results as List <OrganizeModel>;
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <Int64> .NotEq("PhId", 0));
IList <CorrespondenceSettings2Model> correspondenceSettings2s = CorrespondenceSettings2Service.Find(dicWhere).Data as List <CorrespondenceSettings2Model>;
//IList<CorrespondenceSettings2Model> correspondenceSettings2s = CorrespondenceSettings2Service.LoadWithPage(dataStoreParam.PageIndex, dataStoreParam.PageSize, dicWhere).Results as List<CorrespondenceSettings2Model>;
organizes = ProjectThresholdService.GetSBOrganizes(organizes, correspondenceSettings2s);
//IList<ProjectThresholdModel> projectThresholds = (ProjectThresholdService.LoadWithPage(dataStoreParam.PageIndex, dataStoreParam.PageSize, dicWhere)).Results as List<ProjectThresholdModel>;
IList <ProjectThresholdModel> projectThresholds = ProjectThresholdService.Find(dicWhere).Data as List <ProjectThresholdModel>;
if (this.ProjectThresholdService.SaveOrUpdate(data, organizes, projectThresholds, dataStoreParam))
{
return(Content("{\"result\":\"success\"}"));
}
else
{
return(Content("{\"result\":\"fail\"}"));
}
}
/// <summary>
/// 根据申报部门获取设置过对应关系的项目+项目的预算部门为该申报部门的项目
/// </summary>
/// <returns></returns>
public string GetXMbySBDept()
{
string Dept = System.Web.HttpContext.Current.Request.Params["Dept"];
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dylx", "GKBM"))
.Add(ORMRestrictions <string> .Eq("Dydm", Dept));
List <string> ProjcodeList = CorrespondenceSettings2Service.Find(dicWhere).Data.ToList().Select(x => x.Dwdm).Distinct().ToList();
Dictionary <string, object> dicWhereys = new Dictionary <string, object>();
Dictionary <string, object> dicWhereys1 = new Dictionary <string, object>();
Dictionary <string, object> dicWhereys2 = new Dictionary <string, object>();
Dictionary <string, object> dicWhereys3 = new Dictionary <string, object>();
new CreateCriteria(dicWhereys1).Add(ORMRestrictions <List <string> > .In("FProjCode", ProjcodeList));
new CreateCriteria(dicWhereys2).Add(ORMRestrictions <string> .Eq("FYear", DateTime.Now.Year.ToString()))
.Add(ORMRestrictions <string> .Eq("FBudgetDept", Dept))
.Add(ORMRestrictions <System.Int32> .Eq("FLifeCycle", 0))
.Add(ORMRestrictions <System.String> .Eq("FApproveStatus", "3"))
.Add(ORMRestrictions <String> .Eq("FMidYearChange", "0"));
new CreateCriteria(dicWhereys3).Add(ORMRestrictions <string> .Eq("FYear", DateTime.Now.Year.ToString()))
.Add(ORMRestrictions <string> .Eq("FDeclarationDept", Dept))
.Add(ORMRestrictions <System.Int32> .Eq("FLifeCycle", 0))
.Add(ORMRestrictions <System.String> .Eq("FApproveStatus", "3"))
.Add(ORMRestrictions <String> .Eq("FMidYearChange", "0"));
new CreateCriteria(dicWhereys).Add(ORMRestrictions.Or(dicWhereys1, dicWhereys2, dicWhereys3));
string[] Array = BudgetMstService.Find(dicWhereys).Data.ToList().Select(x => x.FProjCode).Distinct().ToArray();
var result = JsonConvert.SerializeObject(Array);
return(result);
}
/// <summary>
/// 通过外键值获取PerformanceDtlTarImpl明细数据
/// </summary>
/// <param name="id">外键值</param>
/// <returns></returns>
public FindedResults <PerformanceDtlTarImplModel> FindPerformanceDtlTarImplByForeignKey <TValType>(TValType id)
{
FindedResults <PerformanceDtlTarImplModel> results = PerformanceDtlTarImplFacade.FindByForeignKey(id);
if (results != null)
{
var data = results.Data;
for (int i = 0; i < data.Count; i++)
{
PerformanceDtlTarImplModel model = data[i];
string typeCode = model.FTargetTypeCode;
string classCode = model.FTargetClassCode;
Dictionary <string, object> dicWhere1 = new Dictionary <string, object>();
Dictionary <string, object> dicWhere2 = new Dictionary <string, object>();
new CreateCriteria(dicWhere1).Add(ORMRestrictions <string> .Eq("FCode", typeCode));
FindedResults <PerformEvalTargetTypeModel> typeModel = PerformEvalTargetTypeFacade.Find(dicWhere1);
new CreateCriteria(dicWhere2).Add(ORMRestrictions <string> .Eq("FCode", classCode));
FindedResults <PerformEvalTargetClassModel> classModel = PerformEvalTargetClassFacade.Find(dicWhere2);
if (typeModel != null && typeModel.Data.Count > 0)
{
model.FTargetTypeCode = typeModel.Data[0].FName;
}
if (classModel != null && classModel.Data.Count > 0)
{
model.FTargetClassCode = classModel.Data[0].FName;
}
}
}
return(results);
}
/// <summary>
/// 保存用户设置的当前年度
/// </summary>
/// <returns></returns>
public string SaveUserYear()
{
string UserCode = System.Web.HttpContext.Current.Request.Params["UserCode"];
string FYear = System.Web.HttpContext.Current.Request.Params["FYear"];
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dylx", "YEAR"))
.Add(ORMRestrictions <string> .Eq("Dwdm", UserCode));
var Model2 = CorrespondenceSettings2Service.Find(dicWhere).Data;
if (Model2.Count > 0)
{
Model2[0].Dydm = FYear;
Model2[0].PersistentState = PersistentState.Modified;
var result = CorrespondenceSettings2Service.Save <Int64>(Model2[0], "");
return(DataConverterHelper.SerializeObject(result));
}
else
{
CorrespondenceSettings2Model model = new CorrespondenceSettings2Model();
model.Dydm = FYear;
model.Dylx = "YEAR";
model.Dwdm = UserCode;
model.PersistentState = PersistentState.Added;
var result = CorrespondenceSettings2Service.Save <Int64>(model, "");
return(DataConverterHelper.SerializeObject(result));
}
}
///// <summary>
///// 方法实例
///// </summary>
///// <returns></returns>
//public IList<CorrespondenceSettingsModel> ExampleMethod<CorrespondenceSettingsModel>(string param)
//{
// //编写代码
//}
/// <summary>
/// 根据当前usercode 获取所拥有部门信息
/// </summary>
/// <param name="usercode"></param>
/// <returns></returns>
public List <CorrespondenceSettingsModel> GetUserDepementList(string usercode)
{
var dic = new Dictionary <string, object>();
new CreateCriteria(dic).Add(ORMRestrictions <string> .Eq("Dylx", "97"))
.Add(ORMRestrictions <string> .Eq("Dwdm", usercode));
#region 取最大的200，循环取LastPage
List <CorrespondenceSettingsModel> Result = new List <CorrespondenceSettingsModel>();
int pagesize = 100;
int pageindex = 0;
//去第一次200的数据
var resultt = base.FacadeHelper.LoadWithPage(pageindex, pagesize, dic);
long total = resultt.TotalItems;
//IList<CorrespondenceSettingsModel> list1 = resultt.Results;
Result.AddRange(resultt.Results.ToList());
while (total > (pageindex + 1) * pagesize)
{
pageindex++;
var resulttemp = base.FacadeHelper.LoadWithPage(pageindex, pagesize, dic);
Result.AddRange(resulttemp.Results);
}
#endregion
return(Result);
}
public string GetBankAccountareaList([FromUri] long OrgPhid, [FromUri] string selectStr)
{
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <Int64> .Eq("OrgPhid", OrgPhid));
var data = BankAccountService.Find(dicWhere).Data.ToList();
List <string> list = null;
if (data.Count > 0 && !string.IsNullOrEmpty(selectStr))
{
data = data.FindAll(t => t.FAccount.IndexOf(selectStr) > -1 || t.FBankname.IndexOf(selectStr) > -1);
var dataresult = data.Select(m => m.BankName);
list = dataresult.Distinct().ToList();
//string[] area = (data.Select(m => m.BankName).ToString()).Split(',');
//List<string> list = new List<string>();
//foreach (var item in area)
//{
// if (!list.Contains(item))
// {
// list.Add(item);
// }
//}
}
if (list.Count > 0)
{
return(DCHelper.ModelListToJson <string>(list, list.Count));
}
else
{
return(DCHelper.ModelListToJson <string>(list, 0));
}
}
/// <summary>
/// 根据BZ获取数据（只取控制的）
/// </summary>
/// <returns>返回Json串</returns>
public string GetQTControlByBZ()
{
string BZ = System.Web.HttpContext.Current.Request.Params["BZ"];
SavedResult <Int64> savedresult = new SavedResult <Int64>();
Dictionary <string, object> dicWhereSet = new Dictionary <string, object>();
new CreateCriteria(dicWhereSet)
.Add(ORMRestrictions <string> .Eq("BZ", BZ))
.Add(ORMRestrictions <string> .Eq("ControlOrNot", "1"));
IList <QTControlSetModel> SetResult = QTControlSetService.Find(dicWhereSet).Data;
if (SetResult.Count > 0)
{
savedresult.Msg = "true";
}
else
{
savedresult.Msg = "false";
}
savedresult.Status = ResponseStatus.Success;
return(DataConverterHelper.SerializeObject(savedresult));
}
/// <summary>
/// 验证数据
/// </summary>
/// <returns></returns>
public FindedResults <PerformEvalTargetTypeModel> ExecuteDataCheck(ref List <PerformEvalTargetTypeModel> performEvalTargetType, string otype)
{
IList <string> dm = new List <string>();
FindedResults <PerformEvalTargetTypeModel> results = new FindedResults <PerformEvalTargetTypeModel>();
if (performEvalTargetType == null)
{
results.Status = ResponseStatus.Error;
results.Msg = "保存失败，数据异常！";
}
else
{
for (int i = 0; i < performEvalTargetType.Count; i++)
{
performEvalTargetType[i].FCode = performEvalTargetType[i].FCode.Replace(" ", "");
performEvalTargetType[i].FName = performEvalTargetType[i].FName.Replace(" ", "");
performEvalTargetType[i].FRemark.Trim();
dm.Add(performEvalTargetType[i].FCode);
}
var dicWhere1 = new Dictionary <string, object>();
new CreateCriteria(dicWhere1).
Add(ORMRestrictions <IList <string> > .In("FCode", dm));
if (base.Find(dicWhere1) != null && base.Find(dicWhere1).Data.Count > 0 && otype != "edit")
{
results = base.Find(dicWhere1);
results.Status = ResponseStatus.Error;
results.Msg = "保存失败，代码重复！";
}
}
return(results);
}
/// <summary>
/// 取对应关系列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetCorrespondenceSettingsListbyRelation(string Dylx, string Dwdm, string DefStr1)
{
//string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"];//查询条件
//Dictionary<string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary
var dicWhere = new Dictionary <string, object>();
if (Dylx != null)
{
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("Dylx", Dylx));
}
if (Dwdm != null)
{
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("Dwdm", Dwdm));
}
if (DefStr1 != null)
{
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("DefStr1", DefStr1));
}
DataStoreParam storeparam = this.GetDataStoreParam();
//var result = CorrespondenceSettingsService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere);
//var result = CorrespondenceSettingsService.LoadWithPage(storeparam.PageIndex, 100, dicWhere);
var result = CorrespondenceSettingsService.ServiceHelper.LoadWithPageInfinity("GQT3.QT.DYGX_All", dicWhere);
return(DataConverterHelper.EntityListToJson <CorrespondenceSettingsModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 根据项目代码获取额度核销总金额
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public decimal GetHXsumByCode(string code)
{
decimal sum = 0;
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FProjcode", code))
.Add(ORMRestrictions <System.Int32> .Eq("FLifeCycle", 0))
.Add(ORMRestrictions <System.Int32> .NotEq("FIfpurchase", 1));
IList <ExpenseMstModel> ExpenseMstList = ExpenseMstFacade.Find(dicWhere).Data;
if (ExpenseMstList.Count > 0)
{
for (var i = 0; i < ExpenseMstList.Count; i++)
{
if (ExpenseMstList[i].FIfKeyEvaluation == 1)
{
var dicWhere2 = new Dictionary <string, object>();
new CreateCriteria(dicWhere2).Add(ORMRestrictions <Int64> .Eq("MstPhid", ExpenseMstList[i].PhId));
IList <ExpenseHxModel> ExpenseHxList = ExpenseHxFacade.Find(dicWhere2).Data;
if (ExpenseHxList.Count > 0)
{
for (var j = 0; j < ExpenseHxList.Count; j++)
{
sum += ExpenseHxList[j].FAmount;
}
}
}
}
}
return(sum);
}
/// <summary>
/// 根据组织取对应关系列表基础数据详细(得到的PhId为对应关系的主键)（没有对应关系的数据）
/// </summary>
/// <returns>返回Json串</returns>
public string GetExpenseCategoryListNoDYGXdtl()
{
string Dwdm = System.Web.HttpContext.Current.Request.Params["Dwdm"];//查询条件
List <string> list = new List <string>();
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
Dictionary <string, object> dicWhere2 = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dylx", "08"));
if (Dwdm != null)
{
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dwdm", Dwdm));
}
var result = ExpenseCategoryService.ServiceHelper.LoadWithPageInfinity("GQT.QT.DYGX2-ZCLB", dicWhere);
for (var i = 0; i < result.TotalItems; i++)
{
list.Add(result.Results[i].Dm);
}
if (list.Count > 0)
{
new CreateCriteria(dicWhere2).Add(ORMRestrictions <List <string> > .NotIn("Dm", list));
}
var result2 = ExpenseCategoryService.ServiceHelper.LoadWithPageInfinity("GQT.QT.ZCLBALL", dicWhere2, false, new string[] { "Dm Asc" });
return(DataConverterHelper.EntityListToJson <ExpenseCategoryModel>(result2.Results, (Int32)result2.TotalItems));
}
/// <summary>
/// 根据按钮主键取对应关系列表基础数据详细(得到的PhId为对应关系的主键)（没有对应关系的数据）(按钮权限)
/// </summary>
/// <returns>返回Json串</returns>
public string GetOrgListNoDYGXdtl(string Dwdm)
{
List <string> list = new List <string>();
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
Dictionary <string, object> dicWhere2 = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dylx", "button"))
.Add(ORMRestrictions <string> .Eq("Dwdm", Dwdm));
var result = CorrespondenceSettings2Facade.FacadeHelper.LoadWithPageInfinity("GQT3.QT.DYGX2_All", dicWhere);
new CreateCriteria(dicWhere2).Add(ORMRestrictions <string> .Eq("IfCorp", "Y"))
.Add(ORMRestrictions <string> .Eq("IsActive", "1"));
for (var i = 0; i < result.TotalItems; i++)
{
list.Add(result.Results[i].Dydm);
}
if (list.Count > 0)
{
new CreateCriteria(dicWhere2)
.Add(ORMRestrictions <List <string> > .NotIn("OCode", list));
}
var result2 = OrganizationFacade.FacadeHelper.LoadWithPageInfinity("GQT.QT.GetOrganize", dicWhere2, false, new string[] { "OCode Asc" });
return(DataConverterHelper.EntityListToJson <OrganizeModel>(result2.Results, (Int32)result2.TotalItems));
}
/// <summary>
/// 导出数据
/// </summary>
/// <returns></returns>
public void ExportData()
{
string ProductBZ = System.Web.HttpContext.Current.Request.Params["ProductBZ"];
HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
ISheet sheet = book.CreateSheet("sheet1");
IRow row1 = sheet.CreateRow(0);
row1.CreateCell(0).SetCellValue("账号");
row1.CreateCell(1).SetCellValue("密码");
row1.CreateCell(2).SetCellValue("姓名");
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ));
IList <QTProductUserModel> qTProductUsers = QTProductUserService.ServiceHelper.LoadWithPageInfinity("GQT.QT.ALLProductUsers", dicWhere).Results;
//List<BudgetAccountsModel> models = budgetAccounts.ToList();
for (int i = 0; i < qTProductUsers.Count; i++)
{
QTProductUserModel model = qTProductUsers[i];
IRow row = sheet.CreateRow(i + 1);
row.CreateCell(0).SetCellValue(model.ProductUserCode);
row.CreateCell(1).SetCellValue(model.ProductUserPwd);
row.CreateCell(2).SetCellValue(model.ProductUserName);
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
Response.BinaryWrite(ms.ToArray());
book = null;
ms.Close();
ms.Dispose();
}
/// <summary>
/// 根据项目代码获取对应归口部门（没有对应关系的）
/// </summary>
/// <param name="Dwdm"></param>
/// <param name="OrgId"></param>
/// <returns></returns>
public IList <OrganizeModel> GetBMListNoDYGXdtl(string Dwdm, string OrgId)
{
//取出设置了对应关系的部门
var dicWhereDYGX = new Dictionary <string, object>();
new CreateCriteria(dicWhereDYGX).
Add(ORMRestrictions <string> .Eq("Dylx", "GKBM")).
Add(ORMRestrictions <string> .Eq("Dwdm", Dwdm));
IList <CorrespondenceSettings2Model> correspondenceSettings2s = CorrespondenceSettings2Facade.Find(dicWhereDYGX).Data;
List <string> OrgDYGX = correspondenceSettings2s.ToList().Select(x => x.Dydm).Distinct().ToList();
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("IfCorp", "N"))
.Add(ORMRestrictions <string> .Eq("IsActive", "1"))
.Add(ORMRestrictions <List <string> > .NotIn("OCode", OrgDYGX));
if (!string.IsNullOrEmpty(OrgId))
{
new CreateCriteria(dicWhere).Add(ORMRestrictions <Int64> .Eq("ParentOrgId", long.Parse(OrgId)));
}
var result = OrganizationFacade.Find(dicWhere, new string[] { "OCode" }).Data;
if (result.Count > 0)
{
foreach (var a in result)
{
a.PhId = 0;
}
}
return(result);
}
/// <summary>
/// 取对应关系列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetCorrespondenceSettings2ListbyRelation(string Dylx, string Dwdm, string DefStr1)
{
var dicWhere = new Dictionary <string, object>();
if (Dylx != null)
{
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("Dylx", Dylx));
}
if (Dwdm != null)
{
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("Dwdm", Dwdm));
}
if (DefStr1 != null)
{
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("DefStr1", DefStr1));
}
DataStoreParam storeparam = this.GetDataStoreParam();
//var result = CorrespondenceSettings2Service.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere);
var result = CorrespondenceSettings2Service.ServiceHelper.LoadWithPageInfinity("GQT3.QT.DYGX2_All", dicWhere);
return(DataConverterHelper.EntityListToJson <CorrespondenceSettings2Model>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 得到子级
/// </summary>
/// <param name="orgTree"></param>
/// <param name="OrgPhids"></param>
/// <returns></returns>
public List <OrganizeModel> GetChild(OrganizeModel orgTree, List <Int64> OrgPhids)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic)
.Add(ORMRestrictions <String> .Eq("RelatId", "lg"))
.Add(ORMRestrictions <Int64> .Eq("ParentOrgId", orgTree.PhId));
IList <OrgRelatitem2Model> orgRelatitems = OrgRelatitem2Rule.Find(dic, new string[] { "RelId Asc" });
if (orgRelatitems.Count > 0)
{
for (var i = 0; i < orgRelatitems.Count; i++)
{
OrganizeModel Orgdata = OrganizationRule.Find(orgRelatitems[i].OrgId);
if (Orgdata.IfCorp == "Y" && Orgdata.IsActive == "1")//筛选组织
{
if (!OrgPhids.Contains(Orgdata.PhId))
{
Orgdata.WeChatId = "false";//用于判断是否没有权限
}
Orgdata.children = GetChild(Orgdata, OrgPhids);
if (orgTree.children == null)
{
orgTree.children = new List <OrganizeModel>();
}
orgTree.children.Add(Orgdata);
}
}
}
return(orgTree.children);
}
/// <summary>
/// 同级增加获取代码
/// </summary>
/// <returns></returns>
public string getCode()
{
string parentCode = System.Web.HttpContext.Current.Request.Params["parentCode"];
string year = System.Web.HttpContext.Current.Request.Params["year"];
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic).Add(ORMRestrictions <string> .Eq("DEFSTR2", parentCode));
if (parentCode == "")
{
new CreateCriteria(dic).Add(ORMRestrictions <string> .LLike("DM", year));
}
List <ProjLibProjModel> ProjLibProjList = ProjLibProjService.Find(dic, new string[] { "DM Desc" }).Data.ToList().FindAll(x => !x.DM.Contains("."));
if (ProjLibProjList.Count > 0)
{
var Top = ProjLibProjList[0].DM.Substring(0, ProjLibProjList[0].DM.Length - 4);
var End = ProjLibProjList[0].DM.Substring(ProjLibProjList[0].DM.Length - 4);
var End2 = "0000" + (Convert.ToInt64(End) + 1).ToString();
return(Top + End2.Substring(End2.Length - 4));
}
else
{
if (parentCode == "")
{
return(ProjectMstService.CreateOrGetMaxProjCode(year));
}
else
{
return(parentCode + "0001");
}
}
}
