/// <summary>
/// 保存首页显示设置
/// </summary>
/// <returns></returns>
public string SaveIndexSet()
{
string UserCode = System.Web.HttpContext.Current.Request.Params["UserCode"];
string data = System.Web.HttpContext.Current.Request.Params["data"];
var datainfo = JsonConvert.DeserializeObject <CorrespondenceSettings2Model>(data);
if (datainfo.PhId == 0)
{
datainfo.Dwdm = UserCode;
datainfo.Dylx = "IndexSet";
datainfo.PersistentState = PersistentState.Added;
var result = CorrespondenceSettings2Service.Save <Int64>(datainfo, "");
return(DataConverterHelper.SerializeObject(result));
}
else
{
var Model2 = CorrespondenceSettings2Service.Find(datainfo.PhId).Data;
Model2.DefStr1 = datainfo.DefStr1;
Model2.DefStr2 = datainfo.DefStr2;
Model2.DefStr3 = datainfo.DefStr3;
Model2.DefStr4 = datainfo.DefStr4;
Model2.PersistentState = PersistentState.Modified;
var result = CorrespondenceSettings2Service.Save <Int64>(Model2, "");
return(DataConverterHelper.SerializeObject(result));
}
}
/// <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 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>
/// 保存数据对接配置
/// </summary>
/// <returns></returns>
public string SaveDbConfig()
{
string Models = System.Web.HttpContext.Current.Request.Params["Models"];
var datas = JsonConvert.DeserializeObject <List <CorrespondenceSettings2Model> >(Models);
//var datas = DataConverterHelper.JsonToEntity<CorrespondenceSettings2Model>(Models).AllRow;
for (var i = 0; i < datas.Count; i++)
{
if (datas[i].PhId == 0)
{
datas[i].PersistentState = PersistentState.Added;
}
else
{
CorrespondenceSettings2Model correspondenceSettings2 = datas[i];
datas[i] = CorrespondenceSettings2Service.Find(datas[i].PhId).Data;
datas[i].DefStr2 = correspondenceSettings2.DefStr2;
datas[i].DefStr3 = correspondenceSettings2.DefStr3;
datas[i].DefStr4 = correspondenceSettings2.DefStr4;
datas[i].PersistentState = PersistentState.Modified;
}
}
SavedResult <Int64> savedresult = CorrespondenceSettings2Service.Save <Int64>(datas, "");
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>返回Json串</returns>
public string GetCorrespondenceSettings2Info()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string tabtype = System.Web.HttpContext.Current.Request.Params["tabtype"]; //Tab类型
var findedresult = CorrespondenceSettings2Service.Find(id);
return(DataConverterHelper.ResponseResultToJson(findedresult));
}
/// <summary>
/// 查找操作员默认组织跟部门
/// </summary>
/// <returns></returns>
public string FindFDeclarationUnit()
{
string userID = System.Web.HttpContext.Current.Request.Params["userID"]; //操作员id
SavedResult <Int64> savedresult = new SavedResult <Int64>();
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dylx", "08"))
.Add(ORMRestrictions <Int32> .Eq("DefInt1", 1)).Add(ORMRestrictions <string> .Eq("Dwdm", userID));
var orgCode = "";
var dept = "";
var orgName = "";
var deptName = "";
var orgCodeList = CorrespondenceSettingsService.Find(dicWhere);
if (orgCodeList.Data.Count > 0)
{
orgCode = orgCodeList.Data[0].Dydm;
dept = orgCodeList.Data[0].DefStr3;
if (!string.IsNullOrEmpty(orgCode))
{
orgName = CorrespondenceSettingsService.GetOrg(orgCode).OName;
}
else
{
savedresult.Status = ResponseStatus.Error;
savedresult.Msg = "该操作员未设置默认组织！";
return(DataConverterHelper.SerializeObject(savedresult));
}
if (!string.IsNullOrEmpty(dept))
{
deptName = CorrespondenceSettingsService.GetOrg(dept).OName;
}
else
{
savedresult.Status = ResponseStatus.Error;
savedresult.Msg = "该操作员未设置默认部门！";
return(DataConverterHelper.SerializeObject(savedresult));
}
var dicWhere1 = new Dictionary <string, object>();
new CreateCriteria(dicWhere1).Add(ORMRestrictions <string> .Eq("Dylx", "SB"))
.Add(ORMRestrictions <string> .Eq("Dwdm", orgCode));
var orgSbList = CorrespondenceSettings2Service.Find(dicWhere1);
if (orgSbList.Data.Count > 0)
{
}
else
{
orgCode = "";
dept = "";
orgName = "";
deptName = "";
}
}
savedresult.Status = "success";
savedresult.Msg = orgCode + "," + dept + "," + orgName + "," + deptName;
return(DataConverterHelper.SerializeObject(savedresult));
}
/// <summary>
/// 根据申报单位组装数据发送给前台
/// </summary>
/// <returns>返回Json串</returns>
/**
* 需要借用orange组件
*
*
* */
public string GetProjectThresholdListByUserPower()
{
DataStoreParam dataStoreParam = this.GetDataStoreParam();
var result = CorrespondenceSettingsService.LoadWithPageOrg(dataStoreParam);
IList <OrganizeModel> organizes = result.Results as List <OrganizeModel>;
//Dictionary<string, object> dicWhere = DataConverterHelper.ConvertToDic("");//查询条件转Dictionary
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>;
organizes = ProjectThresholdService.GetSBOrganizes(organizes, correspondenceSettings2s);
IList <ProjectThresholdModel> projectThresholds = ProjectThresholdService.Find(dicWhere).Data as List <ProjectThresholdModel>;
IList <VProjectThresholdModel> vprojectThresholds = new List <VProjectThresholdModel>();
foreach (OrganizeModel organize in organizes)
{
var q1 = from dt1 in projectThresholds
where dt1.Orgid == organize.PhId
select dt1;
VProjectThresholdModel pt1 = new VProjectThresholdModel();
if (q1.Count() == 0)
{
pt1.Orgcode = organize.OCode;
pt1.Orgid = organize.PhId;
pt1.FThreshold = "未设置";
}
if (q1.Count() == 1)
{
var pm = q1.ToList()[0];
pt1.PhId = pm.PhId;
pt1.Orgid = pm.Orgid;
pt1.Orgcode = pm.Orgcode;
pt1.FThreshold = pm.FThreshold;
pt1.ProjTypeId = pm.ProjTypeId;
pt1.ProjTypeName = pm.ProjTypeName;
}
pt1.Orgname = organize.OName;
vprojectThresholds.Add(pt1);
}
return(DataConverterHelper.EntityListToJson <VProjectThresholdModel>(vprojectThresholds, (Int32)vprojectThresholds.Count()));
//return DataConverterHelper.EntityListToJson<ProjectThresholdModel>(result.Results, (Int32)result.TotalItems);
}
/// <summary>
/// 查找用户设置的年度
/// </summary>
/// <returns></returns>
public string FindUserYear()
{
string UserCode = System.Web.HttpContext.Current.Request.Params["UserCode"];
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;
SavedResult <Int64> savedresult = new SavedResult <Int64>();
savedresult.Status = ResponseStatus.Success;
savedresult.Msg = "";
if (Model2.Count > 0)
{
savedresult.Msg = Model2[0].Dydm;
}
return(DataConverterHelper.SerializeObject(savedresult));
}
/// <summary>
/// 根据操作员代码获取对应首页显示设置
/// </summary>
/// <returns></returns>
public string GetIndexSet2()
{
string UserCode = System.Web.HttpContext.Current.Request.Params["UserCode"];
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dylx", "IndexSet"))
.Add(ORMRestrictions <string> .Eq("Dwdm", UserCode));
var result = CorrespondenceSettings2Service.Find(dicWhere).Data;
if (result.Count > 0)
{
}
else
{
CorrespondenceSettings2Model model = new CorrespondenceSettings2Model();
model.DefStr1 = "0";
model.DefStr2 = "0";
model.DefStr3 = "0";
model.DefStr4 = "0";
result.Add(model);
}
return(JsonConvert.SerializeObject(result[0]));
//return DataConverterHelper.ResponseResultToJson(result[0]);
}
