/// <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 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 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());
}
public string PostSaveUserYear([FromBody] BaseListModel parameters)
{
if (string.IsNullOrEmpty(parameters.uid))
{
return(DCHelper.ErrorMessage("用户主键不能为空！"));
}
if (string.IsNullOrEmpty(parameters.Year))
{
return(DCHelper.ErrorMessage("年份信息不能为空！"));
}
try
{
var dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere).Add(ORMRestrictions <string> .Eq("Dylx", "YEAR"))
.Add(ORMRestrictions <string> .Eq("Dwdm", parameters.uid));
var Model2 = CorrespondenceSettings2Service.Find(dicWhere).Data;
if (Model2 != null && Model2.Count > 0)
{
Model2[0].Dydm = parameters.Year;
Model2[0].PersistentState = PersistentState.Modified;
var result = CorrespondenceSettings2Service.Save <Int64>(Model2[0], "");
return(DataConverterHelper.SerializeObject(result));
}
else
{
CorrespondenceSettings2Model model = new CorrespondenceSettings2Model();
model.Dydm = parameters.Year;
model.Dylx = "YEAR";
model.Dwdm = parameters.uid;
model.PersistentState = PersistentState.Added;
var result = CorrespondenceSettings2Service.Save <Int64>(model, "");
return(DataConverterHelper.SerializeObject(result));
}
}
catch (Exception ex)
{
return(DCHelper.ErrorMessage(ex.Message));
}
}
/// <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]);
}
