/// <summary>
/// 保存数据
/// </summary>
/// <returns>返回Json串</returns>
public string Save()
{
string procurementcatalogformData = System.Web.HttpContext.Current.Request.Form["procurementcatalogformData"];
var procurementcatalogforminfo = DataConverterHelper.JsonToEntity <ProcurementCatalogModel>(procurementcatalogformData);
SavedResult <Int64> savedresult = new SavedResult <Int64>();
PagedResult <ProcurementCatalogModel> result = this.GetList();
try
{
foreach (ProcurementCatalogModel procurementCatalog in procurementcatalogforminfo.AllRow)
{
//where条件已经包括新增以及修改，反证法
var pt = from pt1 in result.Results
where (pt1.FName == procurementCatalog.FName || pt1.FCode == procurementCatalog.FCode) && pt1.PhId != procurementCatalog.PhId
select pt1;
if (pt.Count() > 0)
{
throw new Exception("代码或名称重复");
}
}
savedresult = ProcurementCatalogService.Save <Int64>(procurementcatalogforminfo.AllRow, "");
}
catch (Exception ex)
{
savedresult.Status = ResponseStatus.Error;
savedresult.Msg = ex.Message.ToString();
}
return(DataConverterHelper.SerializeObject(savedresult));
}
/// <summary>
/// 导出数据
/// </summary>
/// <returns></returns>
public void ExportData()
{
//string ProductBZ = System.Web.HttpContext.Current.Request.Params["ProductBZ"];
HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
ISheet sheet = book.CreateSheet("sheet1");
IRow row1 = sheet.CreateRow(0);
row1.CreateCell(0).SetCellValue("代码");
row1.CreateCell(1).SetCellValue("名称");
//row1.CreateCell(2).SetCellValue("备注");
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
new CreateCriteria(dicWhere)
.Add(ORMRestrictions <System.Int64> .NotEq("PhId", 0));
IList <ProcurementCatalogModel> procurementCatalogs = ProcurementCatalogService.Find(dicWhere).Data;
for (int i = 0; i < procurementCatalogs.Count; i++)
{
ProcurementCatalogModel model = procurementCatalogs[i];
IRow row = sheet.CreateRow(i + 1);
row.CreateCell(0).SetCellValue(model.FCode);
row.CreateCell(1).SetCellValue(model.FName);
//row.CreateCell(2).SetCellValue(model.FRemark);
}
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssfff")));
Response.BinaryWrite(ms.ToArray());
book = null;
ms.Close();
ms.Dispose();
}
/// <summary>
/// 根据主键获取数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetProcurementCatalogInfo()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string tabtype = System.Web.HttpContext.Current.Request.Params["tabtype"]; //Tab类型
var findedresult = ProcurementCatalogService.Find(id);
return(DataConverterHelper.ResponseResultToJson(findedresult));
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public PagedResult <ProcurementCatalogModel> GetList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
DataStoreParam storeparam = this.GetDataStoreParam();
var result = ProcurementCatalogService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere);
return(result);
}
/// <summary>
/// 取列表数据
/// </summary>
/// <returns>返回Json串</returns>
public string GetProcurementCatalogList()
{
string clientJsonQuery = System.Web.HttpContext.Current.Request.Params["queryfilter"]; //查询条件
Dictionary <string, object> dicWhere = DataConverterHelper.ConvertToDic(clientJsonQuery); //查询条件转Dictionary
DataStoreParam storeparam = this.GetDataStoreParam();
var result = ProcurementCatalogService.LoadWithPage(storeparam.PageIndex, storeparam.PageSize, dicWhere, new string[] { "FCode Asc" });
return(DataConverterHelper.EntityListToJson <ProcurementCatalogModel>(result.Results, (Int32)result.TotalItems));
}
/// <summary>
/// 删除数据
/// </summary>
/// <returns>返回Json串</returns>
public string Delete()
{
long id = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["id"]); //主表主键
string codes = System.Web.HttpContext.Current.Request.Params["code"].ToString();
string names = "";
if (CanDelete(codes, out names))
{
var deletedresult = ProcurementCatalogService.Delete <System.Int64>(id);
return(DataConverterHelper.SerializeObject(deletedresult));
}
else
{
return("{\"result\":\"fail\",\"names\":\"" + names + "\"}");
}
}
/// <summary>
/// 导入数据
/// </summary>
/// <returns></returns>
public string ImportData(HttpPostedFileBase file, string clear)
{
if (file == null)
{
return(DataConverterHelper.SerializeObject(new { success = false, message = "文件为空，请上传.xls格式的Excel文件！" }));
}
//string ProductBZ = System.Web.HttpContext.Current.Request.Params["ProductBZ"];
//long ProductPhid = Convert.ToInt64(System.Web.HttpContext.Current.Request.Params["ProductPhid"]);
//上传文件
string filePath = Server.MapPath("~/UpLoadFiles/GQT");
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
string filename = Path.GetFileName(file.FileName);
string fileExtension = Path.GetExtension(filename);
string savename = Guid.NewGuid().ToString() + fileExtension;
//var result = Json(new { success = true, message = "上传成功"});
//return JsonConvert.SerializeObject(result.Data);
if (".xls".Equals(fileExtension) || ".xlsx".Equals(fileExtension))
{
file.SaveAs(filePath + "/" + savename);
SavedResult <Int64> savedResult = ProcurementCatalogService.SaveImportData(fileExtension, filePath + "/" + savename, clear);
if (savedResult == null)
{
return(DataConverterHelper.SerializeObject(new { success = false, message = "导入失败，请重新导入！" }));
}
}
else
{
return(DataConverterHelper.SerializeObject(new { success = false, message = "文件格式错误，请上传.xls格式的Excel文件！" }));
}
return(DataConverterHelper.SerializeObject(new { success = true, message = "导入成功！" }));
}
