/// <summary>
/// 保存数据
/// </summary>
/// <returns>返回Json串</returns>
public string Save()
{
string procurementproceduresformData = System.Web.HttpContext.Current.Request.Form["procurementproceduresformData"];
var procurementproceduresforminfo = DataConverterHelper.JsonToEntity <ProcurementProceduresModel>(procurementproceduresformData);
SavedResult <Int64> savedresult = new SavedResult <Int64>();
PagedResult <ProcurementProceduresModel> result = this.GetList();
try
{
foreach (ProcurementProceduresModel procurementProcedures in procurementproceduresforminfo.AllRow)
{
//where条件已经包括新增以及修改，反证法
var pt = from pt1 in result.Results
where (pt1.FName == procurementProcedures.FName || pt1.FCode == procurementProcedures.FCode) && pt1.PhId != procurementProcedures.PhId
select pt1;
if (pt.Count() > 0)
{
throw new Exception("代码或名称重复");
}
}
savedresult = ProcurementProceduresService.Save <Int64>(procurementproceduresforminfo.AllRow, "");
}
catch (Exception ex)
{
savedresult.Status = ResponseStatus.Error;
savedresult.Msg = ex.Message.ToString();
}
return(DataConverterHelper.SerializeObject(savedresult));
}
/// <summary>
/// 根据主键获取数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetProcurementProceduresInfo()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string tabtype = System.Web.HttpContext.Current.Request.Params["tabtype"]; //Tab类型
var findedresult = ProcurementProceduresService.Find(id);
return(DataConverterHelper.ResponseResultToJson(findedresult));
}
public PagedResult <ProcurementProceduresModel> GetList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
DataStoreParam storeparam = this.GetDataStoreParam();
var result = ProcurementProceduresService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere);
return(result);
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetProcurementProceduresList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
DataStoreParam storeparam = this.GetDataStoreParam();
var result = ProcurementProceduresService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "FCode Asc" });
return(DataConverterHelper.EntityListToJson <ProcurementProceduresModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns>返回Json串</returns>
public string Delete()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
//var deletedresult = ProcurementProceduresService.Delete<System.Int64>(id);
//return DataConverterHelper.SerializeObject(deletedresult);
string codes = System.Web.HttpContext.Current.Request.Params["code"].ToString();
string names = "";
if (CanDelete(codes, out names))
{
var deletedresult = ProcurementProceduresService.Delete <System.Int64>(id);
return(DataConverterHelper.SerializeObject(deletedresult));
}
else
{
return("{\"result\":\"fail\",\"names\":\"" + names + "\"}");
}
}
