/// <summary>
/// 修改岗位与操作员信息
/// </summary>
/// <param name="gAppvalPostAndOpers">岗位以及操作员对象</param>
/// <returns></returns>
public SavedResult <long> UpdateSignle(GAppvalPostAndOpersModel gAppvalPostAndOpers)
{
GAppvalPostModel gAppvalPost = gAppvalPostAndOpers.GAppvalPost;
IList <GAppvalPost4OperModel> gAppvalOpers = gAppvalPostAndOpers.GAppvalPost4Opers;
SavedResult <long> savedResult = new SavedResult <long>();
if (gAppvalPost.PhId == 0 || gAppvalPost.OrgPhid == 0)
{
throw new Exception("所传的岗位信息有误！");
}
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic)
.Add(ORMRestrictions <long> .Eq("PostPhid", gAppvalPost.PhId));
var record = this.GAppvalRecordFacade.Find(dic).Data;
//if (record.Count > 0)
//{
// throw new Exception("此岗位已被使用，无法进行修改！");
//}
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <string> .Eq("FCode", gAppvalPost.FCode))
.Add(ORMRestrictions <long> .Eq("OrgPhid", gAppvalPost.OrgPhid))
.Add(ORMRestrictions <long> .NotEq("PhId", gAppvalPost.PhId));
var result = this.GAppvalPostFacade.Find(dic).Data;
if (result.Count > 0)
{
throw new Exception("岗位编码重复，请重新填写！");
}
gAppvalPost.PersistentState = PersistentState.Modified;
savedResult = this.GAppvalPostFacade.Save <long>(gAppvalPost);
if (savedResult.KeyCodes.Count > 0)
{
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <long> .Eq("PostPhid", gAppvalPost.PhId));
var operList = this.GAppvalPost4OperFacade.Find(dic).Data;
if (operList.Count > 0)
{
var delete = this.GAppvalPost4OperFacade.Delete(dic);
}
var postPhid = savedResult.KeyCodes[0];
foreach (var oper in gAppvalOpers)
{
oper.PostPhid = postPhid;
oper.PersistentState = PersistentState.Added;
}
savedResult = this.GAppvalPost4OperFacade.Save <long>(gAppvalOpers);
}
return(savedResult);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IList <AddinAssemblyModel> FindAddinAssemblyByMstPhid(long id)
{
var dic = new Dictionary <string, object>();
new CreateCriteria(dic)
.Add(ORMRestrictions <Int64> .Eq("MstPhid", id))
.Add(ORMRestrictions <Int32> .Eq("AssemblyCatalog", (int)EnumCatalog.Extend));
var assemblyModels = assemblyRule.Find <AddinAssemblyModel>(dic, new string[] { "Phid asc" });
return(assemblyModels);
}
/// <summary>
/// 报表
/// </summary>
public PagedResult <RWReportModel> GetList(long userId)
{
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("RepType", "2"))
.Add(ORMRestrictions <string> .Eq("RepGenre", "1"))
.Add(ORMRestrictions <string> .Eq("OCode", base.OrgID.ToString()));
PagedResult <RWReportModel> result = RWReportFacade.FacadeHelper.LoadWithPageInfinity("GQT.QT.GetList", dicWhere);
return(result);
}
/// <summary>
/// 根据组织获取岗位（2019.10.17改成岗位根据操作员对应组织权限取）
/// </summary>
/// <param name="userId">操作员id</param>
/// <returns></returns>
public IList <GAppvalPostModel> GetAppvalPostList(long userId)
{
List <Int64> orgs = OrganizationFacade.GetSBUnit(userId).ToList().Select(x => x.PhId).ToList();
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("OrgPhid", orgs))
.Add(ORMRestrictions <byte> .Eq("FEnable", (byte)EnumYesNo.Yes));
var result = this.GAppvalPostFacade.Find(dic, new string[] { "IsSystem desc", "FCode Asc" }).Data;
return(result);
}
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);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IList <AddinSqlModel> FindAddinSqlByMstPhid(long id)
{
var dic = new Dictionary <string, object>();
new CreateCriteria(dic)
.Add(ORMRestrictions <Int64> .Eq("MstPhid", id))
.Add(ORMRestrictions <Int32> .Eq("SqlCatalog", (int)EnumCatalog.Interceptor));
var sqlModels = SqlRule.Find <AddinSqlModel>(dic, new string[] { "Phid asc" });
return(sqlModels);
}
/// <summary>
/// 根据主键获取数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetProjectThresholdInfoToOrgcode()
{
string orgcode = System.Web.HttpContext.Current.Request.Params["orgcode"]; //组织号
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("Orgcode", orgcode));
var findedresult = ProjectThresholdService.Find(dicWhere);
return(DataConverterHelper.ResponseResultToJson(findedresult));
}
/// <summary>
/// 判断是否是末级组织
/// </summary>
/// <param name="ParentOrg"></param>
/// <returns></returns>
public PagedResult <OrgRelatitem2Model> LoadWithPageIsend(string ParentOrg)
{
//CommonResult<OrgRelatitem2Model> result = new CommonResult<OrgRelatitem2Model>();
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("ParentOrg", ParentOrg));
var result = OrgRelatitem2Facade.FacadeHelper.LoadWithPageInfinity("GQT.QT.GetAllorgrelatitem", dicWhere);
return(result);
}
/// <summary>
/// 根据岗位主键集合删除岗位与岗位对应操作员信息
/// </summary>
/// <param name="phidList">岗位主键集合</param>
/// <param name="uCode">用户账号</param>
/// <returns></returns>
public DeletedResult DeletedPostOpers(List <long> phidList, string uCode)
{
DeletedResult deletedResult = new DeletedResult();
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PostPhid", phidList));
var record = this.GAppvalRecordFacade.Find(dic).Data;
if (record.Count > 0)
{
throw new Exception("此岗位已被审批使用，无法进行删除！");
}
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PostPhid", phidList));
var procPost = this.GAppvalProc4PostFacade.Find(dic).Data;
if (procPost.Count > 0)
{
throw new Exception("此岗位已被流程使用，无法进行删除！");
}
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PhId", phidList))
.Add(ORMRestrictions <byte> .Eq("IsSystem", (byte)1));
var sysPosts = this.GAppvalPostFacade.Find(dic).Data;
if (sysPosts.Count > 0 && uCode != "Admin")
{
throw new Exception("内置岗位普通操作员不能进行删除！");
}
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PhId", phidList));
var posts = this.GAppvalPostFacade.Find(dic).Data;
if (posts.Count > 0)
{
deletedResult = this.GAppvalPostFacade.Delete(dic);
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PostPhid", phidList));
var opers = this.GAppvalPost4OperFacade.Find(dic).Data;
if (opers.Count > 0)
{
deletedResult = this.GAppvalPost4OperFacade.Delete(dic);
}
}
return(deletedResult);
}
/// <summary>
/// 根据预算单位和预算部门查找部门所在预算进度
/// </summary>
/// <param name="oCode"></param>
/// <param name="deptCode"></param>
/// <returns></returns>
public string FindBudgetProcessCtrl(string oCode, string deptCode, string FYear)
{
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FOcode", oCode))
.Add(ORMRestrictions <string> .Eq("FDeptCode", deptCode)).Add(ORMRestrictions <string> .Eq("FYear", FYear));
FindedResults <BudgetProcessCtrlModel> results = base.ServiceHelper.Find <BudgetProcessCtrlModel>(dicWhere);
if (results.Data.Count() > 0)
{
return(results.Data[0].FProcessStatus);
}
return("");
}
/// <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 string GetGHSubjectList([FromUri] GHSubjectRequestModel param)
{
if (string.IsNullOrEmpty(param.UserId))
{
return(DCHelper.ErrorMessage("用户编码不能为空！"));
}
if (string.IsNullOrEmpty(param.Fkmlb))
{
return(DCHelper.ErrorMessage("申报种类不能为空！"));
}
try
{
Dictionary <string, object> dicWhere = new Dictionary <string, object>();//查询条件转Dictionary
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FProjAttr", param.Fkmlb));
//增加搜索条件
if (!string.IsNullOrEmpty(param.FApproveStatus) && !"0".Equals(param.FApproveStatus))
{
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("FApproveStatus", param.FApproveStatus));
}
if (!string.IsNullOrEmpty(param.Year))
{
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FYear", param.Year));
}
//增加根据操作员对应预算部门的过滤
var dicWhereDept = new Dictionary <string, object>();
new CreateCriteria(dicWhereDept)
.Add(ORMRestrictions <string> .Eq("Dwdm", param.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("FDeclarationDept", deptL))
.Add(ORMRestrictions <string> .Eq("FYear", DateTime.Today.Year.ToString()));
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FType", "c"));
var result = GHSubjectService.LoadWithPage(param.PageIndex, param.PageSize, dicWhere, new string[] { "NgInsertDt Desc", "NgUpdateDt Desc" });
//return DataConverterHelper.EntityListToJson<GHSubjectModel>(result.Results, (Int32)result.TotalItems);
return(DCHelper.ModelListToJson <GHSubjectModel>(result.Results, (Int32)result.TotalItems));
}
catch (Exception ex)
{
return(DCHelper.ErrorMessage(ex.Message));
}
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetQtBaseProjectSelect()
{
//long Fphid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Fphid"]);
string userCode = System.Web.HttpContext.Current.Request.Params["userCode"];
string FKMLB = System.Web.HttpContext.Current.Request.Params["FKMLB"];
string FType = System.Web.HttpContext.Current.Request.Params["FType"];
string FYear = System.Web.HttpContext.Current.Request.Params["FYear"];
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
var DeptList = CorrespondenceSettingsService.GetRelationYSBMRightList(userCode).Results.ToList().Select(x => x.OCode).Distinct().ToList();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("FKMLB", FKMLB))
.Add(ORMRestrictions <string> .NotEq("FProjCode", ""))
.Add(ORMRestrictions <List <string> > .In("FFillDept", DeptList));
if (!string.IsNullOrEmpty(FYear))
{
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("FYear", FYear));
}
DataStoreParam storeparam = this.GetDataStoreParam();
//var result = QtBaseProjectService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "FKmdm", "NgInsertDt" });
var result = new PagedResult <QtBaseProjectModel>();
if (FType == "c")
{
result = QtBaseProjectService.ServiceHelper.LoadWithPageInfinity("GQT.QT.TBJD.c", dicWhere);
}
else
{
result = QtBaseProjectService.ServiceHelper.LoadWithPageInfinity("GQT.QT.TBJD.z", dicWhere);
foreach (QtBaseProjectModel a in result.Results)
{
if (a.FType == "c")
{
a.FProjName = a.FProjName + "(年初新增)";
}
if (a.FType == "z")
{
a.FProjName = a.FProjName + "(年中新增)";
}
if (a.FType == "tz")
{
a.FProjName = a.FProjName + "(年中调整)";
}
}
}
//var result = QtBaseProjectService.ServiceHelper.LoadWithPageInfinity("GQT.QT.TBJD", dicWhere);
return(DataConverterHelper.EntityListToJson <QtBaseProjectModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="expenseCategory"></param>
/// <param name="edittype"></param>
/// <returns></returns>
public SavedResult <Int64> Save2(ExpenseCategoryModel expenseCategory, string edittype)
{
SavedResult <Int64> result = new SavedResult <Int64>();
if (edittype == "edit")
{
ExpenseCategoryModel expenseCategory2 = base.Find(expenseCategory.PhId).Data;
if (expenseCategory.Mc != expenseCategory2.Mc)
{
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("Mc", expenseCategory.Mc));
if (base.Find(dicWhere).Data.Count > 0)
{
result.Status = ResponseStatus.Error;
result.Msg = "保存失败，名称重复！";
return(result);
}
}
expenseCategory2.Mc = expenseCategory.Mc;
expenseCategory2.Bz = expenseCategory.Bz;
expenseCategory2.PersistentState = PersistentState.Modified;
result = base.Save <Int64>(expenseCategory2, "");
}
if (edittype == "add")
{
var dicWhere1 = new Dictionary <string, object>();
new CreateCriteria(dicWhere1).
Add(ORMRestrictions <string> .Eq("Dm", expenseCategory.Dm));
if (base.Find(dicWhere1).Data.Count > 0)
{
result.Status = ResponseStatus.Error;
result.Msg = "保存失败，代码重复！";
return(result);
}
var dicWhere2 = new Dictionary <string, object>();
new CreateCriteria(dicWhere2).
Add(ORMRestrictions <string> .Eq("Mc", expenseCategory.Mc));
if (base.Find(dicWhere2).Data.Count > 0)
{
result.Status = ResponseStatus.Error;
result.Msg = "保存失败，名称重复！";
return(result);
}
expenseCategory.PersistentState = PersistentState.Added;
result = base.Save <Int64>(expenseCategory, "");
}
return(result);
}
/// <summary>
/// 根据操作员取申报单位
/// </summary>
/// <param name="USERID"></param>
/// <returns></returns>
public IList <OrganizeModel> GetSBUnit(long USERID)
{
//SELECT DISTINCT fg3_userorg.ORGID FROM fg3_userorg WHERE USERID=488181024000001
List <Int64> PHIDs1 = new List <Int64>();
List <Int64> PHIDs2 = new List <Int64>();
Dictionary <string, object> dic_userorg = new Dictionary <string, object>();
new CreateCriteria(dic_userorg)
.Add(ORMRestrictions <Int64> .Eq("UserId", USERID));
IList <UserOrganize2Model> userOrganize2s = UserOrgRule.Find(dic_userorg);
if (userOrganize2s.Count > 0)
{
for (var i = 0; i < userOrganize2s.Count; i++)
{
if (!PHIDs1.Contains(userOrganize2s[i].OrgId))
{
PHIDs1.Add(userOrganize2s[i].OrgId);
}
}
}
Dictionary <string, object> dic_Corr2 = new Dictionary <string, object>();
new CreateCriteria(dic_Corr2)
.Add(ORMRestrictions <String> .Eq("Dylx", "SB"));
IList <CorrespondenceSettings2Model> correspondenceSettings2 = CorrespondenceSettings2Rule.Find(dic_Corr2);
if (correspondenceSettings2.Count > 0)
{
for (var i = 0; i < correspondenceSettings2.Count; i++)
{
if (!PHIDs2.Contains(long.Parse(correspondenceSettings2[i].DefStr2)))
{
PHIDs2.Add(long.Parse(correspondenceSettings2[i].DefStr2));
}
}
}
List <Int64> phid3 = PHIDs1.Intersect(PHIDs2).ToList();
Dictionary <string, object> dic_org = new Dictionary <string, object>();
new CreateCriteria(dic_org)
.Add(ORMRestrictions <String> .Eq("IfCorp", "Y"))
.Add(ORMRestrictions <String> .Eq("IsActive", "1"))
.Add(ORMRestrictions <List <Int64> > .In("PhId", phid3));
IList <OrganizeModel> organizes = OrganizationRule.Find(dic_org, new string[] { "OCode" });
return(organizes);
}
/// <summary>
/// 得到子级(包括部门)(树)
/// </summary>
/// <param name="orgTree"></param>
/// <returns></returns>
public List <OrganizeModel> GetAllChild(OrganizeModel orgTree)
{
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);
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")//筛选组织
{
Orgdata.children = GetAllChild(Orgdata);
if (orgTree.children == null)
{
orgTree.children = new List <OrganizeModel>();
}
orgTree.children.Add(Orgdata);
}
}
}
Dictionary <string, object> dicDept = new Dictionary <string, object>();
new CreateCriteria(dicDept)
.Add(ORMRestrictions <Int64> .Eq("ParentOrgId", orgTree.PhId))
.Add(ORMRestrictions <String> .Eq("IfCorp", "N"))
.Add(ORMRestrictions <String> .Eq("IsActive", "1"));
List <OrganizeModel> Depts = OrganizationRule.Find(dicDept).ToList();
if (Depts.Count > 0)
{
if (orgTree.children == null)
{
orgTree.children = new List <OrganizeModel>();
}
for (var i = 0; i < Depts.Count; i++)
{
Depts[i].OName = orgTree.OName + "-" + Depts[i].OName;//部门名称变为 组织-部门
orgTree.children.Add(Depts[i]);
}
}
return(orgTree.children);
}
/// <summary>
/// 取列表数据根据绩效项目评价指标类型
/// </summary>
/// <returns>返回Json串</returns>
public string GetPerformEvalTargetListByClassCode()
{
string TypeCode = System.Web.HttpContext.Current.Request.Params["TypeCode"];//查询条件
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("FTargetTypeCode", TypeCode));
DataStoreParam storeparam = this.GetDataStoreParam();
var result = PerformEvalTargetService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "FTargetCode" });
result = PerformEvalTargetService.CodeToName(result);
return(DataConverterHelper.EntityListToJson <PerformEvalTargetModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetQTProductUserDygxList()
{
/*string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"];//查询条件
* Dictionary<string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary
*/
long Fg3userPhid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["Fg3userPhid"]);//查询条件
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <System.Int64> .Eq("Fg3userPhid", Fg3userPhid));
DataStoreParam storeparam = this.GetDataStoreParam();
var result = QTProductUserDygxService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere);
return(DataConverterHelper.EntityListToJson <QTProductUserDygxModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 根据组织取对应关系列表基础数据详细(得到的PhId为对应关系的主键)
/// </summary>
/// <returns>返回Json串</returns>
public string GetExpenseCategoryListDYGXdtl()
{
string Dwdm = System.Web.HttpContext.Current.Request.Params["Dwdm"];//查询条件
Dictionary <string, object> dicWhere = 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);
return(DataConverterHelper.EntityListToJson <ExpenseCategoryModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 不删除设置对应关系
/// </summary>
/// <param name="ProductBZ"></param>
/// <returns></returns>
public CommonResult SaveByProductNoDelete(string ProductBZ)
{
CommonResult result = new CommonResult();
try
{
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic).Add(ORMRestrictions <EnumUserStatus> .Eq("Status", EnumUserStatus.Activate));
//var Users = UserFacade.FacadeHelper.LoadWithPageInfinity("GQT.QT.GetAllUsers", dic2);
var Users = UserFacade.Find(dic).Data;
for (var i = 0; i < Users.Count; i++)
{
User2Model user = Users[i];
Dictionary <string, object> dic2 = new Dictionary <string, object>();
new CreateCriteria(dic2).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ))
.Add(ORMRestrictions <string> .Eq("Fg3userno", user.UserNo));
var IfDYGX = base.Find(dic2).Data;
Dictionary <string, object> dic3 = new Dictionary <string, object>();
new CreateCriteria(dic3).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ))
.Add(ORMRestrictions <string> .Eq("ProductUserCode", user.UserNo));
var IfUser = QTProductUserFacade.Find(dic3).Data;
if (IfDYGX.Count == 0 && IfUser.Count > 0)
{
QTProductUserModel qTProductUserModel = IfUser[0];
QTProductUserDygxModel qTProductUserDygxModel = new QTProductUserDygxModel
{
ProductBZ = ProductBZ,
ProductUserCode = user.UserNo,
ProductPhid = qTProductUserModel.ProductPhid,
ProductUserPhid = qTProductUserModel.PhId,
ProductUserName = qTProductUserModel.ProductUserName,
ProductUserPwd = qTProductUserModel.ProductUserPwd,
Fg3userPhid = user.PhId,
Fg3userno = user.UserNo,
Fg3username = user.UserName,
PersistentState = PersistentState.Added
};
base.Save <Int64>(qTProductUserDygxModel, "");
}
}
}
catch (Exception e)
{
result.Status = ResponseStatus.Error;
result.Msg = "同步失败!";
}
return(result);
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetQTProductUserList()
{
/*string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"];//查询条件
* Dictionary<string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery);//查询条件转Dictionary*/
string ProductBZ = System.Web.HttpContext.Current.Request.Params["ProductBZ"];
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
if (ProductBZ != null && ProductBZ.Length > 0)
{
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("ProductBZ", ProductBZ));
}
DataStoreParam storeparam = this.GetDataStoreParam();
var result = QTProductUserService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere);
return(DataConverterHelper.EntityListToJson <QTProductUserModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 判断是否有明细
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Boolean JudgeHaveDtl(long id)
{
QtBaseProjectModel qtBaseProjectModel = base.Find(id).Data;
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).
Add(ORMRestrictions <string> .Eq("FProjCode", qtBaseProjectModel.FProjCode));
if (SubjectMstBudgetDtlFacade.Find(dicWhere).Data.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据组织代码串得到组织(非)
/// </summary>
/// <param name="OrgStr"></param>
/// <returns></returns>
public IList <OrganizeModel> GetNoUseOrg(string OrgStr)
{
var dicWhere = new Dictionary <string, object>();
if (!string.IsNullOrEmpty(OrgStr))
{
var OrgCodeList = OrgStr.Split(',').ToList();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <List <string> > .NotIn("OCode", OrgCodeList));
}
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("IfCorp", "Y"));
var result = OrganizationFacade.Find(dicWhere, new string[] { "OCode Asc" }).Data;
return(result);
}
///// <summary>
///// 方法实例
///// </summary>
///// <returns></returns>
//public IList<PerformEvalTargetTypeModel> ExampleMethod<PerformEvalTargetTypeModel>(string param)
//{
// //编写代码
//}
/// <summary>
/// 通过代码找名称
/// </summary>
/// <param name="Dm"></param>
/// <returns></returns>
public string FindMcByDm(string Dm)
{
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("FCode", Dm));
IList <PerformEvalTargetTypeModel> performEvalTargetTypes = PerformEvalTargetTypeRule.Find(dicWhere);
if (performEvalTargetTypes.Count > 0)
{
return(performEvalTargetTypes[0].FName);
}
else
{
return("");
}
}
/// <summary>
/// 通过代码找名称
/// </summary>
/// <param name="Dm"></param>
/// <returns></returns>
public string FindMcByDm(string Dm)
{
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("OCode", Dm));
IList <OrganizeModel> organizes = OrganizationRule.Find(dicWhere);
if (organizes.Count > 0)
{
return(organizes[0].OName);
}
else
{
return("");
}
}
///// <summary>
///// 方法实例
///// </summary>
///// <returns></returns>
//public IList<BudgetAccountsModel> ExampleMethod<BudgetAccountsModel>(string param)
//{
// //编写代码
//}
/// <summary>
/// 通过代码找名称
/// </summary>
/// <param name="Dm"></param>
/// <returns></returns>
public string FindMcByDm(string Dm)
{
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("KMDM", Dm));
IList <BudgetAccountsModel> budgetAccounts = BudgetAccountsRule.Find(dicWhere);
if (budgetAccounts.Count > 0)
{
return(budgetAccounts[0].KMMC);
}
else
{
return("");
}
}
/// <summary>
/// 根据多个单据号删除多条单据以及单据明细
/// </summary>
/// <param name="fCodes">多个单据号</param>
/// <returns></returns>
public int DeleteSignle(List <long> fCodes)
{
int deletedResult = 0;
Dictionary <string, object> dic = new Dictionary <string, object>();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PhId", fCodes));
var result = this.PaymentMstRule.Find(dic);
if (result != null && result.Count > 0)
{
//删除单据主表
deletedResult = this.PaymentMstRule.Delete(dic);
var mstIdList = result.ToList().Select(t => t.PhId).ToList();
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("MstPhid", mstIdList));
var result2 = this.PaymentXmRule.Find(dic);
if (result2 != null && result2.Count > 0)
{
//删除单据集合对应的项目表
deletedResult = this.PaymentXmRule.Delete(dic);
var xmIdList = result2.ToList().Select(t => t.PhId).ToList();
//删除明细
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("PayXmPhid", xmIdList));
var result3 = this.PaymentDtlRule.Find(dic);
if (result3 != null && result3.Count > 0)
{
deletedResult = this.PaymentDtlRule.Delete(dic);
}
//根据项目集合删除附件
dic.Clear();
new CreateCriteria(dic)
.Add(ORMRestrictions <List <long> > .In("RelPhid", xmIdList))
.Add(ORMRestrictions <string> .Eq("BTable", "BK3_PAYMENT_XM"));
var result4 = this.QtAttachmentRule.Find(dic);
if (result4 != null && result4.Count > 0)
{
deletedResult = this.QtAttachmentRule.Delete(dic);
}
}
}
return(deletedResult);
}
/// <summary>
/// 根据项目代码取预计支出金额的和
/// </summary>
/// <param name="FProjCode"></param>
/// <returns></returns>
public string SumFSurplusamount(string FProjCode)
{
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("FProjcode", FProjCode))
.Add(ORMRestrictions <System.Int32> .Eq("FLifeCycle", 0))
.Add(ORMRestrictions <System.Int32> .NotEq("FIfpurchase", 1)); //是否额度返还
var findedresultmst = base.Find(dicWhere).Data;
Decimal Sum = 0;
for (var i = 0; i < findedresultmst.Count; i++)
{
Sum += findedresultmst[i].FSurplusamount;
Sum -= findedresultmst[i].FReturnamount;
}
return(Sum.ToString());
}
///// <summary>
///// 方法实例
///// </summary>
///// <returns></returns>
//public IList<QtZcgnflModel> ExampleMethod<QtZcgnflModel>(string param)
//{
// //编写代码
//}
/// <summary>
/// 通过代码找名称
/// </summary>
/// <param name="Dm"></param>
/// <returns></returns>
public string FindMcByDm(string Dm)
{
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <string> .Eq("KMDM", Dm));
IList <QtZcgnflModel> qtZcgnfls = QtZcgnflRule.Find(dicWhere);
if (qtZcgnfls.Count > 0)
{
return(qtZcgnfls[0].KMMC);
}
else
{
return("");
}
}
