public async Task <AjaxResult> AddSolutions(string id, List <Hard_GroupByProLine> obj)
{
string ProLineNo = id;
//删除旧数据
List <Hard_GroupByProLine> delList = BLLSession.IHard_GroupByProLineBLL.Query(u => u.ProLineNo.Equals(id)).ToList();
await BLLSession.DbSession.Hard_GroupByProLineRepository.DelEntitiesAsync(delList);
//生成新数据
List <Hard_GroupByProLine> applyDetails = obj;
applyDetails.ForEach(u =>
{
u.SerialNo = Guid.NewGuid().ToString();
u.CreateTime = DateTime.Now;
u.CreateUser = CurUser.userId;
});
await BLLSession.DbSession.Hard_GroupByProLineRepository.AddEntitiesAsync(applyDetails);
int result = await BLLSession.DbSession.SaveChangesAsync();
if (result >= 0)
{
return(AjaxResult.OK("保存成功", obj));
}
else
{
return(AjaxResult.Cancel("保存失败"));
}
}
public async Task <AjaxResult> AddNotGroupByItem(string id, List <Hard_GroupByItme> obj)
{
var param = id.Split(',');
string ProLineNo = param[0];
string SubItemNo = param[1];
//删除旧数据
List <Hard_GroupByItme> delList = BLLSession.IHard_GroupByItmeBLL.Query(u => u.ProLineNo.Equals(ProLineNo) && u.SubItemNo.Equals(SubItemNo)).ToList();
await BLLSession.DbSession.Hard_GroupByItmeRepository.DelEntitiesAsync(delList);
//生成新数据
List <Hard_GroupByItme> applyDetails = obj;
applyDetails.ForEach(u =>
{
u.SerialNo = Guid.NewGuid().ToString();
u.CreateTime = DateTime.Now;
u.CreateUser = CurUser.userId;
});
await BLLSession.DbSession.Hard_GroupByItmeRepository.AddEntitiesAsync(applyDetails);
var result = await BLLSession.DbSession.SaveChangesAsync() >= 0 ? "" : "数据库操作失败";
if (string.IsNullOrEmpty(result))
{
return(AjaxResult.OK("保存成功", obj));
}
else
{
return(AjaxResult.Cancel("保存失败"));
}
}
public async Task <AjaxResult> SaveHardType(Hard_MaterialType obj)
{
var SerialNo = obj.SerialNo;
var ParentNo = obj.ParentNo;
var MatTypeNo = obj.MatTypeNo;
int isOk;
Hard_MaterialType entity = new Hard_MaterialType();
//新增
if (string.IsNullOrEmpty(SerialNo))
{
var p_matObj = BLLSession.IHard_MaterialTypeBLL.Query(u => u.MatTypeNo.Equals(MatTypeNo)).FirstOrDefault();
var c_matObj = BLLSession.IHard_MaterialTypeBLL.Query(u => u.ParentNo.Equals(p_matObj.SerialNo)).OrderByDescending(u => u.MatTypeNo).FirstOrDefault();
entity.SerialNo = Guid.NewGuid().ToString();
entity.MatTypeName = obj.MatTypeName;
entity.MatTypeNo = (c_matObj == null ? p_matObj.MatTypeNo + "01" :
(p_matObj.MatTypeNo.Remove(1) == "0" ? "0" : "") + (Convert.ToInt32(c_matObj.MatTypeNo) + 1).ToString());
entity.ParentNo = p_matObj.SerialNo;
entity.MatTypeMemo = obj.MatTypeMemo;
entity.CreateTime = DateTime.Now;
entity.CreateUser = CurUser.userId;
isOk = await BLLSession.IHard_MaterialTypeBLL.AddEntityAsync(entity);
if (isOk < 0)
{
return(AjaxResult.Cancel("保存失败！"));
}
}
//编辑
else
{
entity = BLLSession.IHard_MaterialTypeBLL.Query(u => u.MatTypeNo.Equals(MatTypeNo)).FirstOrDefault <Hard_MaterialType>();
entity.MatTypeName = obj.MatTypeName;
entity.MatTypeNo = obj.MatTypeNo;
entity.ParentNo = obj.ParentNo;
entity.MatTypeMemo = obj.MatTypeMemo;
entity.LastTime = DateTime.Now;
entity.LastUser = CurUser.userId;
isOk = await BLLSession.IHard_MaterialTypeBLL.UpdateEntityAsync(entity);
if (isOk < 0)
{
return(AjaxResult.Cancel("修改失败！"));
}
}
return(AjaxResult.OK("保存成功！", entity));
}
public async Task <AjaxResult> SaveTypeConfig(Hard_MaterialConfig obj)
{
var SerialNo = obj.SerialNo;
var ParentNo = obj.ParentNo;
int isOk;
Hard_MaterialConfig entity = new Hard_MaterialConfig();
//新增
if (string.IsNullOrEmpty(SerialNo))
{
entity.SerialNo = Guid.NewGuid().ToString();
entity.ItmeName = obj.ItmeName;
entity.ParentNo = obj.ParentNo;
entity.IsEnabled = obj.IsEnabled;
entity.Memo = obj.Memo;
entity.CreateTime = DateTime.Now;
entity.CreateUser = CurUser.userId;
isOk = await BLLSession.IHard_MaterialConfigBLL.AddEntityAsync(entity);
if (isOk < 0)
{
return(AjaxResult.Cancel("保存失败！"));
}
}
//编辑
else
{
entity = BLLSession.IHard_MaterialConfigBLL.Query(u => u.SerialNo.Equals(SerialNo)).FirstOrDefault <Hard_MaterialConfig>();
entity.ItmeName = obj.ItmeName;
entity.ParentNo = obj.ParentNo;
entity.IsEnabled = obj.IsEnabled;
entity.Memo = obj.Memo;
entity.LastTime = DateTime.Now;
entity.LastUser = CurUser.userId;
isOk = await BLLSession.IHard_MaterialConfigBLL.UpdateEntityAsync(entity);
if (isOk < 0)
{
return(AjaxResult.Cancel("修改失败！"));
}
}
return(AjaxResult.OK("保存成功！", entity));
}
public async Task <AjaxResult> AddProLine(Hard_BaseDict obj)
{
string SerialNo = Guid.NewGuid().ToString();
if (obj == null)
{
return(AjaxResult.Cancel("参数不容许为空"));
}
string DictNo = obj.DictNo;
var BaseData = BLLSession.IHard_BaseDictBLL.Query(u => u.DictNo.Equals(DictNo)).FirstOrDefault();
if (BaseData != null)
{
return(AjaxResult.Cancel("该产品线编号已存在！"));
}
Hard_BaseDict basedict = new Hard_BaseDict();
basedict.SerialNo = SerialNo;
basedict.DictType = "产品线";
basedict.DictNo = obj.DictNo;
basedict.DictName = obj.DictName;
basedict.DictSort = obj.DictSort;
basedict.Memo = obj.Memo;
basedict.IsEnabled = obj.IsEnabled;
basedict.BelongArea = "Product";
basedict.DictParam = obj.DictParam;
basedict.CreateTime = DateTime.Now;
basedict.CreateUser = CurUser.userId;
int result = await BLLSession.IHard_BaseDictBLL.AddEntityAsync(basedict);
if (result >= 0)
{
return(AjaxResult.OK("保存成功", basedict));
}
else
{
return(AjaxResult.Cancel("保存失败"));
}
}
public async Task <AjaxResult> SetItemConfig(dynamic obj)
{
string SerialNo = obj.SerialNo;
string ConfigDesc = obj.ConfigDesc;
int isOk;
var entity = BLLSession.IHard_MaterialItemBLL.Query(u => u.SerialNo.Equals(SerialNo)).FirstOrDefault <Hard_MaterialItem>();
if (entity == null)
{
return(AjaxResult.Cancel("找不到对象！"));
}
entity.ConfigDesc = obj.ConfigDesc;
entity.LastTime = DateTime.Now;
entity.LastUser = CurUser.userId;
isOk = await BLLSession.IHard_MaterialItemBLL.UpdateEntityAsync(entity);
if (isOk < 0)
{
return(AjaxResult.Cancel("配置失败！"));
}
return(AjaxResult.OK("配置成功！", entity));
}
public async Task <AjaxResult> EditProLine(string id, dynamic obj)
{
if (string.IsNullOrEmpty(id))
{
return(AjaxResult.Cancel("该单据不存在"));
}
string DictNo = obj.DictNo;
var BaseData = BLLSession.IHard_BaseDictBLL.Query(u => u.DictNo.Equals(DictNo) & u.SerialNo != id).FirstOrDefault();
if (BaseData != null)
{
return(AjaxResult.Cancel("该产品线编号已存在！"));
}
var BaseInfo = BLLSession.IHard_BaseDictBLL.Query(u => u.SerialNo.Equals(id)).FirstOrDefault();
BaseInfo.DictNo = obj.DictNo;
BaseInfo.DictName = obj.DictName;
BaseInfo.DictSort = obj.DictSort;
BaseInfo.Memo = obj.Memo;
BaseInfo.IsEnabled = obj.IsEnabled;
BaseInfo.DictParam = obj.DictParam;
BaseInfo.LastTime = DateTime.Now;
BaseInfo.LastUser = CurUser.userId;
int result = await BLLSession.IHard_BaseDictBLL.UpdateEntityAsync(BaseInfo);
if (result >= 0)
{
return(AjaxResult.OK("保存成功", BaseInfo));
}
else
{
return(AjaxResult.Cancel("保存失败"));
}
}
public async Task <AjaxResult> UploadFile()
{
List <Resource> resources = new List <Resource>();
// multipart/form-data
// 采用MultipartMemoryStreamProvider
var provider = new MultipartMemoryStreamProvider();
//读取文件数据
await Request.Content.ReadAsMultipartAsync(provider);
var FileUrl = "";
foreach (var item in provider.Contents)
{
// 判断是否是文件
if (item.Headers.ContentDisposition.FileName != null)
{
//获取到流
var ms = item.ReadAsStreamAsync().Result;
//进行流操作
using (var br = new BinaryReader(ms))
{
if (ms.Length <= 0)
{
break;
}
//读取文件内容到内存中
var data = br.ReadBytes((int)ms.Length);
//Info
FileInfo info = new FileInfo(item.Headers.ContentDisposition.FileName.Replace("\"", ""));
Resource resource = new Resource()
{
Id = DateTime.Now.ToString("yyyyMMddHHmmssffff")
};
//文件类型
var FileType = info.Extension;
//文件存储地址
string rootPath = "E:\\PMIS_DOC\\Hard";
var dirTempPath = rootPath + "\\" + DateTime.Now.ToString("yyyyMMdd") + "\\";
string dirPath = Path.Combine(dirTempPath);
string FileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + FileType;
//Write
try
{
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
File.WriteAllBytes(Path.Combine(dirPath, FileName), data);
FileUrl = ContextHelper.Current.GetDocFile(Path.Combine(dirPath, FileName));
}
catch (Exception exception)
{
return(AjaxResult.Cancel(exception.Message.ToString()));
}
}
}
}
return(AjaxResult.OK("上传成功", FileUrl));
//string rootPath = "D:\\HardImg";
//var dirTempPath = rootPath + "\\" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + "\\";
////检查文档目录是否存在,如果不存在目录,就新增
//if (!Directory.Exists(dirTempPath))
//{
// Directory.CreateDirectory(dirTempPath);
//}
//// 设置上传目录
//var provider = new MyMultipartFormDataStreamProvider(dirTempPath);
//Dictionary<string, string> dictParam = new Dictionary<string, string>();
//AjaxResult result = null;
//if (!Request.Content.IsMimeMultipartContent("form-data"))
// return AjaxResult.Cancel("没有要上传的文档", dictParam);
//var task = await Request.Content.ReadAsMultipartAsync(provider).
// ContinueWith<AjaxResult>(o =>
// {
// //1：读取文件传递的参数
// foreach (var key in provider.FormData.AllKeys)
// {//接收FormData
// dictParam.Add(key, provider.FormData[key]);
// }
// var files = provider.FileData;
// if (files.Count() == 0)
// {
// return AjaxResult.OK("没有文件", dictParam);
// }
// var file = files[0];
// // 2：设置最大文件大小
// // 4：获取文件名称
// string orfilename = file.Headers.ContentDisposition.FileName.TrimStart('"').TrimEnd('"');
// var fileinfo = new FileInfo(file.LocalFileName);
// var info = new
// {
// orfilename = orfilename,
// LocalFileName = file.LocalFileName
// };
// if (fileinfo.Length <= 0)
// {
// result = AjaxResult.Cancel("请选择上传文件");
// }
// else
// {
// result = AjaxResult.OK("上传成功", info);
// }
// return result;
// });
//return task;
}
public async Task <AjaxResult> SaveItem(Hard_MaterialItem obj)
{
var SerialNo = obj.SerialNo;
var MatTypeNo = obj.MatTypeNo;
var SubItemNo = obj.SubItemNo;
int isOk;
Hard_MaterialItem entity = new Hard_MaterialItem();
//新增
if (string.IsNullOrEmpty(SerialNo))
{
var p_matObj = BLLSession.IHard_MaterialTypeBLL.Query(u => u.MatTypeNo.Equals(SubItemNo)).FirstOrDefault();
var c_matObj = BLLSession.IHard_MaterialItemBLL.Query(u => u.SubItemNo.Equals(p_matObj.MatTypeNo)).OrderByDescending(u => u.ItemNo).FirstOrDefault();
entity.SerialNo = Guid.NewGuid().ToString();
entity.ItemNo = (c_matObj == null ? p_matObj.MatTypeNo + "0001" : (p_matObj.MatTypeNo.Remove(1) == "0" ? "0" : "") + (Convert.ToInt32(c_matObj.ItemNo) + 1).ToString());
entity.MatTypeNo = obj.MatTypeNo;
entity.SubItemNo = obj.SubItemNo;
entity.Brand = obj.Brand;
entity.ItemModel = obj.ItemModel;
entity.WarrantyPeriod = obj.WarrantyPeriod;
entity.warrantyType = obj.warrantyType;
entity.WarrantyCost = obj.WarrantyCost;
entity.AttachFiles = obj.AttachFiles;
entity.IsEnergy = obj.IsEnergy;
entity.IsStop = obj.IsStop;
entity.PurchasePrice = obj.PurchasePrice;
entity.Offer = obj.Offer;
entity.DeliveryDay = obj.DeliveryDay;
entity.CreateTime = DateTime.Now;
entity.CreateUser = CurUser.userId;
isOk = await BLLSession.IHard_MaterialItemBLL.AddEntityAsync(entity);
if (isOk < 0)
{
return(AjaxResult.Cancel("保存失败！"));
}
}
//编辑
else
{
entity = BLLSession.IHard_MaterialItemBLL.Query(u => u.SerialNo.Equals(SerialNo)).FirstOrDefault <Hard_MaterialItem>();
entity.MatTypeNo = obj.MatTypeNo;
entity.SubItemNo = obj.SubItemNo;
entity.Brand = obj.Brand;
entity.ItemModel = obj.ItemModel;
entity.WarrantyPeriod = obj.WarrantyPeriod;
entity.warrantyType = obj.warrantyType;
entity.WarrantyCost = obj.WarrantyCost;
entity.AttachFiles = obj.AttachFiles;
entity.IsEnergy = obj.IsEnergy;
entity.IsStop = obj.IsStop;
entity.PurchasePrice = obj.PurchasePrice;
entity.Offer = obj.Offer;
entity.DeliveryDay = obj.DeliveryDay;
entity.LastTime = DateTime.Now;
entity.LastUser = CurUser.userId;
isOk = await BLLSession.IHard_MaterialItemBLL.UpdateEntityAsync(entity);
if (isOk < 0)
{
return(AjaxResult.Cancel("修改失败！"));
}
}
return(AjaxResult.OK("保存成功！", entity));
}
