/// <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>
/// 取列表数据
/// </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 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));
}
public string UpdateR(String dwphid, String dwdm, String selected, String unselected)
{
int dr = -1;
int sr = 1;
//第一步，获得该单位已保存的所有支出渠道
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(null);
CreateCriteria createCriteria = new CreateCriteria(dicWhere);
createCriteria.Add(ORMRestrictions <string> .Eq("Dylx", "ZC"));
if (dwdm != null)
{
createCriteria.Add(ORMRestrictions <string> .Eq("Dwdm", dwdm));
}
List <CorrespondenceSettings2Model> correspondenceSettings2s = CorrespondenceSettings2Service.LoadWithPage(0, Int32.MaxValue, dicWhere).Results as List <CorrespondenceSettings2Model>;
ArrayList dbSave = new ArrayList();
String[] selects = selected.Split(',');
String[] unseleteds = unselected.Split(',');
foreach (CorrespondenceSettings2Model c2m in correspondenceSettings2s)
{
foreach (String us in unseleteds)
{
if (c2m.Dydm.Equals(us))
{
CorrespondenceSettings2Service.Delete(c2m.PhId);
dr--;
break;
}
else
{
dbSave.Add(c2m.Dydm);
}
}
}
foreach (String s in selects)
{
if (!dbSave.Contains(s) && s != null && !s.Equals("") && !s.Equals(" "))
{
CorrespondenceSettings2Model c2m = new CorrespondenceSettings2Model();
c2m.Dylx = "ZC";
c2m.Dydm = s;
c2m.Dwdm = dwdm;
c2m.DefStr2 = dwphid;
c2m.PersistentState = PersistentState.Added;
//List<CorrespondenceSettings2Model> tc2 = new List<CorrespondenceSettings2Model>();
//tc2.Add(c2m);
String resulet = DataConverterHelper.SerializeObject(CorrespondenceSettings2Service.Save <Int64>(c2m, ""));
//c2m.PhId = 55466;
//tc2.Clear();
//tc2.Add(c2m);
//resulet = DataConverterHelper.SerializeObject(CorrespondenceSettings2Service.Save<Int64>(tc2));
sr++;
}
}
return((dr * sr).ToString());
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public PagedResult <PerformEvalTypeModel> GetList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
DataStoreParam storeparam = this.GetDataStoreParam();
var result = PerformEvalTypeService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere);
return(result);
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetLogSortingSlowPerfList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
DataStoreParam storeparam = this.GetDataStoreParam();
var result = LogSortingSlowPerfService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "Duration desc" });
return(DataConverterHelper.EntityListToJson <LogSortingSlowPerfModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 取预算执行情况表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetBuImplementReportList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
DataStoreParam storeparam = this.GetDataStoreParam();
var result = BuDeptReportService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, "GHBudgetImplement", dicWhere, false);
return(DataConverterHelper.EntityListToJson <BuDeptReportModel>(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));
}
public IList <VCorrespondenceSetting2Model> GetVc2mList(String dwdm)
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"];
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary
CreateCriteria createCriteria = new CreateCriteria(dicWhere);
createCriteria.Add(ORMRestrictions <string> .Eq("Dylx", "ZC"));
createCriteria.Add(ORMRestrictions <string> .NotEq("Dydm", "NULL"));
if (dwdm != null)
{
createCriteria.Add(ORMRestrictions <string> .Eq("Dwdm", dwdm));
}
DataStoreParam storeparam = this.GetDataStoreParam();
var cr2s = this.CorrespondenceSettings2Service.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere).Results as List <CorrespondenceSettings2Model>;
var ors = this.GetOrg();
IList <VCorrespondenceSetting2Model> vcr2s = new List <VCorrespondenceSetting2Model>();
foreach (CorrespondenceSettings2Model cr2 in cr2s)
{
VCorrespondenceSetting2Model vc2 = new VCorrespondenceSetting2Model();
vc2.PhId = cr2.PhId;
vc2.DWDM = cr2.Dwdm;
vc2.DYDM = cr2.Dydm;
vc2.DYLX = cr2.Dylx;
var or = from or1 in ors
where or1.OCode.Equals(cr2.Dydm)
select or1;
if (or.Count() == 1)
{
vc2.Dymc = or.ToList()[0].OName;
}
else
{
vc2.Dymc = "未设置";
}
or = from or1 in ors
where or1.OCode.Equals(cr2.Dwdm)
select or1;
if (or.Count() == 1)
{
vc2.Dwmc = or.ToList()[0].OName;
}
else
{
vc2.Dymc = "未设置";
}
vcr2s.Add(vc2);
}
return(vcr2s);
}
public string GetPaymentList4Zjbf2([FromUri] Parameter parameters)
{
if (parameters == null || string.IsNullOrEmpty(parameters.uid))
{
return(DCHelper.ErrorMessage("用户id为空！"));
}
if (string.IsNullOrEmpty(parameters.orgid))
{
return(DCHelper.ErrorMessage("组织编码为空！"));
}
if (string.IsNullOrEmpty(parameters.Ryear))
{
return(DCHelper.ErrorMessage("年度为空！"));
}
if (parameters.pageindex < 0 || parameters.pagesize == 0)
{
return(DCHelper.ErrorMessage("分页参数不正确！"));
}
string[] sorts = parameters.sort;
if (sorts == null || sorts.Length < 1)
{
sorts = new string[] { "NgInsertDt desc" };
}
try
{
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(parameters.queryfilter ?? "");
//二次处理dic
DCHelper.ConvertDic <GKPaymentMstModel>(dicWhere);
BillRequestModel billRequest = new BillRequestModel();
billRequest.Year = parameters.Ryear;
billRequest.Uid = long.Parse(parameters.uid);
billRequest.BType = "002";
billRequest.Orgid = long.Parse(parameters.orgid);
var result = GKPaymentMstService.GetPaymentList4Zjbf2(billRequest, parameters.pageindex, parameters.pagesize, dicWhere, sorts);
IList <GKPayment4ZjbfModel> list = new List <GKPayment4ZjbfModel>();
if (result != null && result.Results != null)
{
list = result.Results;
}
return(DCHelper.ModelListToJson <GKPayment4ZjbfModel>(list, result.TotalItems, parameters.pageindex, parameters.pagesize));
}
catch (Exception e)
{
return(DCHelper.ErrorMessage(e.Message));
}
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回对象集合</returns>
public IList <ProjectThresholdModel> GetPTMList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
new CreateCriteria(dicWhere).Add(ORMRestrictions <Int64> .NotEq("PhId", 0));
DataStoreParam storeparam = this.GetDataStoreParam();
var result = ProjectThresholdService.Find(dicWhere).Data;
//ProjectThresholdService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere);
return(result);
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetQTMemoList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"];//查询条件
long userId = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["userId"]);
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <System.Int64> .Eq("Creator", userId));
DataStoreParam storeparam = this.GetDataStoreParam();
var result = QTMemoService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere);
return(DataConverterHelper.EntityListToJson <QTMemoModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetQTEditMemoList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
var Memophid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Memophid"]);
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <Int64> .Eq("Memophid", Memophid));
DataStoreParam storeparam = this.GetDataStoreParam();
var result = QTEditMemoService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "NgInsertDt Desc", "NgUpdateDt Desc" });
return(DataConverterHelper.EntityListToJson <QTEditMemoModel>(result.Results, (Int32)result.TotalItems));
}
public List <OrganizeModel> GetOrange()
{
IOrganizationFacade OrganizationFacade = this.Organization;
//var t = new EntDacBase<OrganizeModel>();
//var t = new OrganizationDac();
//Dictionary<string, object> dicWhere = DataConverterHelper.ConvertToDic(null);
//CreateCriteria createCriteria = new CreateCriteria(dicWhere);
//createCriteria.Add(ORMRestrictions<string>.Eq("OrgType", "Y"));
//List<OrganizeModel> oli = t.Find(dicWhere) as List<OrganizeModel>;
//var result=new EntDacBase<OrganizeModel>().LoadWithPage(0, Int32.MaxValue, DataConverterHelper.ConvertToDic(null));
var result = OrganizationFacade.LoadWithPage(0, Int32.MaxValue, DataConverterHelper.ConvertToDic(null));
//return new EntDacBase<OrganizeModel>().LoadWithPage(0, Int32.MaxValue, DataConverterHelper.ConvertToDic(null)).Results as List<OrganizeModel>;
return(null);
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetQTModifyList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"];//查询条件
string FProjCode = System.Web.HttpContext.Current.Request.Params["FProjCode"];
Dictionary<string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary
if (!string.IsNullOrEmpty(FProjCode))
{
new CreateCriteria(dicWhere).Add(ORMRestrictions<string>.Eq("FProjCode", FProjCode));
}
else
{
new CreateCriteria(dicWhere).Add(ORMRestrictions<Int64>.Eq("PhId", 0));
}
DataStoreParam storeparam = this.GetDataStoreParam();
var result = QTModifyService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "NgInsertDt Desc" });
return DataConverterHelper.EntityListToJson<QTModifyModel>(result.Results, (Int32)result.TotalItems);
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetPerformanceMstList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
string ysmstphid = System.Web.HttpContext.Current.Request.Params["ysmstphid"]; //预算项目主键
string FType = System.Web.HttpContext.Current.Request.Params["FType"];
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
if (ysmstphid != null && !string.IsNullOrEmpty(ysmstphid))
{
new CreateCriteria(dicWhere).Add(ORMRestrictions <Int64> .Eq("YSMstPhId", Int64.Parse(ysmstphid)));
}
if (!string.IsNullOrEmpty(FType))
{
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FType", FType));
}
DataStoreParam storeparam = this.GetDataStoreParam();
var result = PerformanceMstService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "NgInsertDt Desc", "NgUpdateDt Desc" });
return(DataConverterHelper.EntityListToJson <PerformanceMstModel>(result.Results, (Int32)result.TotalItems));
}
public string GetPaymentList([FromUri] Parameter parameters)
{
if (parameters == null || string.IsNullOrEmpty(parameters.uid))
{
return(DCHelper.ErrorMessage("用户id为空！"));
}
if (string.IsNullOrEmpty(parameters.orgid))
{
return(DCHelper.ErrorMessage("组织编码为空！"));
}
if (string.IsNullOrEmpty(parameters.Ryear))
{
return(DCHelper.ErrorMessage("年度为空！"));
}
if (parameters.pageindex < 0 || parameters.pagesize == 0)
{
return(DCHelper.ErrorMessage("分页参数不正确！"));
}
try
{
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(parameters.queryfilter ?? "");
//二次处理dic
DCHelper.ConvertDic <GKPaymentMstModel>(dicWhere);
//var result = GKPaymentMstService.Find(dicWhere); //this.GKPaymentMstService.FindList(parameters.uid, parameters.orgid, parameters.pageindex, parameters.pagesize, dicWhere, parameters.sort);
var result = GKPaymentMstService.LoadWithPage(parameters.pageindex, parameters.pagesize, dicWhere, new string[] { "NgInsertDt asc" });
IList <GKPaymentMstModel> list = result.Results;
return(DCHelper.ModelListToJson <GKPaymentMstModel>(list, result.TotalItems, parameters.pageindex, parameters.pagesize));
}
catch (Exception e)
{
return(DCHelper.ErrorMessage(e.Message));
}
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetQTIndividualInfoList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
string IndividualinfoBustype = System.Web.HttpContext.Current.Request.Params["IndividualinfoBustype"];
string OrgCode = System.Web.HttpContext.Current.Request.Params["OrgCode"];
if (!string.IsNullOrEmpty(IndividualinfoBustype))
{
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("IndividualinfoBustype", IndividualinfoBustype));
}
DataStoreParam storeparam = this.GetDataStoreParam();
var result = QTIndividualInfoService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "IndividualinfoBustype", "DEFINT1 ASC", "NgInsertDt Desc", "NgUpdateDt Desc" });
if (result.Results.Count > 0 && !string.IsNullOrEmpty(OrgCode))
{
result.Results = result.Results.ToList().FindAll(x => !string.IsNullOrEmpty(x.DEFSTR9) && x.DEFSTR9.Split(',').ToList().Contains(OrgCode));
}
return(DataConverterHelper.EntityListToJson <QTIndividualInfoModel>(result.Results, (Int32)result.Results.Count));
}
/**
* 根据组织代码获取所有的支出类型
* **/
public IList <ExpenseCategoryModel> GetAllExpenseCategoryModel(String ocode)
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
new CreateCriteria(dicWhere).Add(ORMRestrictions <Int64> .NotEq("PhId", 0));
DataStoreParam storeparam = this.GetDataStoreParam();
//var result = ExpenseCategoryService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere);
var result = ExpenseCategoryService.Find(dicWhere).Data;
IList <ExpenseCategoryModel> expenseCategoryModels = result;
IList <CorrespondenceSettings2Model> cr2s = this.GetAllCR2(ocode);
IList <String> ecmCodes = new List <String>();
foreach (CorrespondenceSettings2Model cr2 in cr2s)
{
ecmCodes.Add(cr2.Dydm);
}
IList <ExpenseCategoryModel> expenseCategoryModelsByOcode = (from et1 in expenseCategoryModels
where ecmCodes.Contains(et1.Dm)
select et1).ToList <ExpenseCategoryModel>();
return(expenseCategoryModelsByOcode);
}
