/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetQtBaseProjectList()
{
//string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"];//查询条件
//Dictionary<string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary
long Fphid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Fphid"]);
string FKMLB = System.Web.HttpContext.Current.Request.Params["FKMLB"];
string FYear = System.Web.HttpContext.Current.Request.Params["FYear"];
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).
Add(ORMRestrictions <System.Int64> .Eq("Fphid", Fphid))
.Add(ORMRestrictions <string> .Eq("FKMLB", FKMLB));
if (!string.IsNullOrEmpty(FYear))//取科目及当前年度的子科目
{
Dictionary <string, object> dicWhere2 = new Dictionary <string, object>();
Dictionary <string, object> dicWhere3 = new Dictionary <string, object>();
new CreateCriteria(dicWhere2).
Add(ORMRestrictions <string> .Eq("FYear", FYear));
new CreateCriteria(dicWhere3).
Add(ORMRestrictions <string> .Eq("FProjCode", ""));
new CreateCriteria(dicWhere).Add(ORMRestrictions.Or(dicWhere2, dicWhere3));
}
DataStoreParam storeparam = this.GetDataStoreParam();
var result = QtBaseProjectService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "FKmdm", "NgInsertDt" });
return(DataConverterHelper.EntityListToJson <QtBaseProjectModel>(result.Results, (Int32)result.TotalItems));
}
/**
* 根据组织ID获取，该组织下选择了哪些项目类型（支出类别）设置了阈值，也是一个支出类型（项目类型）的集合
* **/
public String GetUnSetExpenseCategoryModel(String Ocode)
{
IList <ExpenseCategoryModel> eMresult = new List <ExpenseCategoryModel>();
IList <ExpenseCategoryModel> expenseCategoryModels = this.GetAllExpenseCategoryModel(Ocode);
IList <ProjectThresholdModel> projectThresholdModels = this.GetPTMList();
IList <ProjectThresholdModel> pt = (from pt1 in projectThresholdModels
where pt1.Orgcode.Equals(Ocode)
select pt1).ToList <ProjectThresholdModel>();
if (pt.Count == 1)
{
IList <String> alcodes = (pt[0].ProjTypeId ?? "").Split(',').ToList <String>();
eMresult = (from ex1 in expenseCategoryModels
where !(alcodes.Contains(ex1.Dm))
select ex1).ToList <ExpenseCategoryModel>();
}
else
{
eMresult = expenseCategoryModels;
}
return(DataConverterHelper.EntityListToJson <ExpenseCategoryModel>(eMresult, (Int32)eMresult.Count));
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetExpenseMstList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
var userId = System.Web.HttpContext.Current.Request.Params["userId"];
var dicWhereDept = new Dictionary <string, object>();
new CreateCriteria(dicWhereDept)
.Add(ORMRestrictions <string> .Eq("Dwdm", userId)).Add(ORMRestrictions <string> .Eq("Dylx", "97")); //闭区间
var deptList = CorrespondenceSettingsService.Find(dicWhereDept);
List <string> deptL = new List <string>();
for (var i = 0; i < deptList.Data.Count; i++)
{
deptL.Add(deptList.Data[i].Dydm);
}
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <IList <String> > .In("FBudgetDept", deptL));
DataStoreParam storeparam = this.GetDataStoreParam();
var result = ExpenseMstService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "FPerformevaltype Desc" });
return(DataConverterHelper.EntityListToJson <ExpenseMstModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 取对应关系列表数据 取所有org（包括部门）
/// </summary>
/// <returns>返回Json串</returns>
public string GetAllOrg()
{
DataStoreParam dataStoreParam = this.GetDataStoreParam();
var result = CorrespondenceSettingsService.LoadWithPageAllOrg(dataStoreParam);
return(DataConverterHelper.EntityListToJson <OrganizeModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 根据操作员取申报单位
/// </summary>
/// <returns></returns>
public string GetSBUnit()
{
long uid = long.Parse(System.Web.HttpContext.Current.Request.Params["uid"]);
IList <OrganizeModel> organizes = CorrespondenceSettings2Service.GetSBUnit(uid);
return(DataConverterHelper.EntityListToJson <OrganizeModel>(organizes, (Int32)organizes.Count));
}
/// <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>
/// <returns>返回Json串</returns>
public string GetRelationYSBMList()
{
DataStoreParam storeparam = this.GetDataStoreParam();
var result = CorrespondenceSettingsService.LoadWithPageYSBM(storeparam);
return(DataConverterHelper.EntityListToJson <User2Model>(result.Results, (Int32)result.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>返回Json串</returns>
public string GetLogPerfList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
DataStoreParam storeparam = this.GetDataStoreParam();
string sortbyparm = System.Web.HttpContext.Current.Request.Params["sortby"];
if (string.IsNullOrEmpty(sortbyparm))
{
sortbyparm = "2";
}
string[] sortby = null;
if (sortbyparm == "0")
{
sortby = new string[] { "Duration Asc" };
}
else if (sortbyparm == "1")
{
sortby = new string[] { "Duration Desc" };
}
else if (sortbyparm == "2")
{
sortby = new string[] { "Phid Asc" };
}
else if (sortbyparm == "3")
{
sortby = new string[] { "Phid Desc" };
}
var result = LogPerfService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, sortby);
return(DataConverterHelper.EntityListToJson <LogPerfModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 取操作员对应预算部门
/// </summary>
/// <returns>返回Json串</returns>
public string FindYSBM()
{
string userCode = System.Web.HttpContext.Current.Request.Params["userCode"];
var result = CorrespondenceSettingsService.FindYSBM(userCode);
return(DataConverterHelper.EntityListToJson <OrganizeModel>(result, (Int32)result.Count));
}
/// <summary>
/// 根据项目代码获取对应部门
/// </summary>
/// <returns></returns>
public string GetBMListDYGXdtl()
{
string Dwdm = System.Web.HttpContext.Current.Request.Params["Dwdm"];
var result = CorrespondenceSettings2Service.GetBMListDYGXdtl(Dwdm);
return(DataConverterHelper.EntityListToJson <OrganizeModel>(result, (Int32)result.Count));
}
public string GetNotice()
{
IList <Notice> noticeList = new List <Notice>
{
new Notice {
id = 1, title = "1.关于推荐申报全国模范职工之家、全国模范", datetime = "2018-09-05"
},
new Notice {
id = 2, title = "2.关于推荐申报全国模范职工之家、全国模范", datetime = "2018-09-05"
},
new Notice {
id = 3, title = "3.关于推荐申报全国模范职工之家、全国模范", datetime = "2018-09-05"
},
new Notice {
id = 4, title = "4.关于推荐申报全国模范职工之家、全国模范", datetime = "2018-09-05"
},
new Notice {
id = 5, title = "5.关于推荐申报全国模范职工之家、全国模范", datetime = "2018-09-05"
},
new Notice {
id = 6, title = "6.关于推荐申报全国模范职工之家、全国模范", datetime = "2018-09-05"
},
new Notice {
id = 7, title = "7.关于推荐申报全国模范职工之家、全国模范", datetime = "2018-09-05"
}
};
return(DataConverterHelper.EntityListToJson <Notice>(noticeList, (Int32)noticeList.Count));
}
/// <summary>
/// 取数据对接配置文件
/// </summary>
/// <returns>返回Json串</returns>
public string GetConnDbConfig()
{
var dicWhere = new Dictionary <string, object>();
var result = CorrespondenceSettings2Service.ServiceHelper.LoadWithPageInfinity("GQT.QT.GetConnDBConfig", dicWhere);
return(DataConverterHelper.EntityListToJson <CorrespondenceSettings2Model>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 申报部门项目汇总表
/// </summary>
/// <returns>返回Json串</returns>
public string GetQTProjectMstHZ()
{
/*string FDeclarationDept = System.Web.HttpContext.Current.Request.Params["FDeclarationDept"];
* string FBudgetDept = System.Web.HttpContext.Current.Request.Params["FBudgetDept"];
* string FAccount = System.Web.HttpContext.Current.Request.Params["FAccount"];
* Dictionary<string, object> dicWhere = new Dictionary<string, object>();
* if (!string.IsNullOrEmpty(FDeclarationDept))
* {
* new CreateCriteria(dicWhere).Add(ORMRestrictions<string>.Eq("FDeclarationDept", FDeclarationDept));
* }
* if (!string.IsNullOrEmpty(FBudgetDept))
* {
* new CreateCriteria(dicWhere).Add(ORMRestrictions<string>.Eq("FBudgetDept", FBudgetDept));
* }
* if (!string.IsNullOrEmpty(FAccount))
* {
* new CreateCriteria(dicWhere).Add(ORMRestrictions<string>.Eq("FAccount", FAccount));
* }*/
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
DataStoreParam storeparam = this.GetDataStoreParam();
var result = QTProjectMstService.GetQTProjectMstHZ(dicWhere, storeparam.PageIndex, storeparam.PageSize, out int TotalItems);
return(DataConverterHelper.EntityListToJson <QTProjectMstHZModel>(result, TotalItems));
}
/// <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>
/// 根据组织取对应关系列表基础数据详细(得到的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 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>
/// 取all列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetBudgetAccountsListAll()
{
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
var result = BudgetAccountsService.ServiceHelper.LoadWithPageInfinity("GQT.QT.GetBudgetAccountAll", dicWhere);
return(DataConverterHelper.EntityListToJson <BudgetAccountsModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public string GetList()
{
//GQT.QT.GetList
long userId = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["userId"]);
PagedResult <RWReportModel> result = UserOrgService.GetList(userId);
return(DataConverterHelper.EntityListToJson <RWReportModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 取对应关系列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetRelationYSBMRightList()
{
string userCode = System.Web.HttpContext.Current.Request.Params["userCode"];//查询条件
//DataStoreParam dataStoreParam = this.GetDataStoreParam();
var result = CorrespondenceSettingsService.GetRelationYSBMRightList(userCode);
return(DataConverterHelper.EntityListToJson <OrganizeModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 取对应关系列表数据 根据组织id取部门
/// </summary>
/// <returns>返回Json串</returns>
public string GetBM()
{
string OrgId = System.Web.HttpContext.Current.Request.Params["OrgId"];//查询条件
DataStoreParam dataStoreParam = this.GetDataStoreParam();
var result = CorrespondenceSettingsService.LoadWithPageBM(dataStoreParam, OrgId);
return(DataConverterHelper.EntityListToJson <OrganizeModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public string GetAddinExpressionList()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
IList <AddinExpressionModel> Models = MethodAroundMstService.FindAddinExpressionByMstPhid(id);
return(DataConverterHelper.EntityListToJson <AddinExpressionModel>(Models, Models.Count));
}
/// <summary>
/// 取对应关系列表数据 操作员对应组织部门
/// </summary>
/// <returns>返回Json串</returns>
public string GetRelationUser_OrgList()
{
string userCode = System.Web.HttpContext.Current.Request.Params["userCode"];//查询条件
DataStoreParam dataStoreParam = this.GetDataStoreParam();
var result = CorrespondenceSettingsService.LoadWithPageUser_Org(dataStoreParam, userCode);
return(DataConverterHelper.EntityListToJson <CorrespondenceSettingsModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetQTIndividualInfoNoOrg()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
var data = QTIndividualInfoService.Find(id).Data;
var Org = QTIndividualInfoService.GetNoUseOrg(data.DEFSTR9);
return(DataConverterHelper.EntityListToJson <OrganizeModel>(Org, (Int32)Org.Count));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public string GetAddinAssemblyList()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
IList <AddinAssemblyModel> Models = ExtendFunctionMstService.FindAddinAssemblyByMstPhid(id);
return(DataConverterHelper.EntityListToJson <AddinAssemblyModel>(Models, Models.Count));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public string GetAddinUrlList()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
var url = ExtendFunctionMstService.GetUrl(id);
return(DataConverterHelper.EntityListToJson <ExtendFuncUrlBizModel>(url, url.Count));
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetBudgetProcessCtrlDistinctList()
{
DataStoreParam storeparam = this.GetDataStoreParam();
string query = System.Web.HttpContext.Current.Request.Params["FOcode"];//查询条件
string userId = System.Web.HttpContext.Current.Request.Params["userId"];
var result = BudgetProcessCtrlService.GetBudgetProcessCtrlDistinctList(storeparam, query, userId);
return(DataConverterHelper.EntityListToJson <BudgetProcessCtrlModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 取操作员能操作的org
/// </summary>
/// <returns></returns>
public string OrgByUser()
{
string userid = System.Web.HttpContext.Current.Request.Params["userid"];
DataStoreParam storeparam = this.GetDataStoreParam();
var result = CorrespondenceSettingsService.LoadWithPageOrgByUser(storeparam, userid);
//return DataConverterHelper.ResponseResultToJson(result);
return(DataConverterHelper.EntityListToJson <OrganizeModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 判断是否是末级组织（获取所有的父类信息）
/// </summary>
/// <returns></returns>
public string JudgeIsend()
{
//string ParentOrg = System.Web.HttpContext.Current.Request.Params["ParentOrg"];
//var result = CorrespondenceSettings2Service.LoadWithPageIsend();
var dicWhere = new Dictionary <string, object>();
var result = OrgRelatitem2Service.ServiceHelper.LoadWithPageInfinity("GQT.QT.GetAllorgrelatitem", dicWhere);
return(DataConverterHelper.EntityListToJson <OrgRelatitem2Model>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetExamplesList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
DataStoreParam storeparam = this.GetDataStoreParam();
var result = ExamplesService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere);
return(DataConverterHelper.EntityListToJson <ExamplesModel>(result.Results.ToList(), (Int32)result.TotalItems));
}
