public bool AddMatirialModel(Goods goods)
{
GoodsModel model = new GoodsModel();
Goods_ClassModel classModel = bllGoodsClass.GetModelByClassName(goods.MaterialType);
model.Goods_Class_ID = classModel.Goods_Class_ID;
model.Goods_Code = goods.MaterialCode;
model.Goods_Flag = goods.MaterialFlag;
model.Goods_Name = goods.MaterialName;
model.Goods_Unit = goods.MaterialUnit;
model.Goods_ID = Guid.NewGuid().ToString();
model.Goods_Category = goods.MaterialType;
model.Goods_Model = goods.MaterialModel;
return(bllGoods.Add(model));
}
public bool ModifyMatirialModel(Goods goods)
{
GoodsModel model = bllGoods.GetModel(goods.MaterialID);
if (model == null)
{
return(false);
}
Goods_ClassModel classModel = bllGoodsClass.GetModelByClassName(goods.MaterialType);
model.Goods_Class_ID = classModel.Goods_Class_ID;
model.Goods_Code = goods.MaterialCode;
model.Goods_Flag = goods.MaterialFlag;
model.Goods_Name = goods.MaterialName;
model.Goods_Unit = goods.MaterialUnit;
model.Goods_Category = goods.MaterialType;
model.Goods_Model = goods.MaterialModel;
return(bllGoods.Update(model));
}
public void QueryStock(StockQueryParm stockParam)
{
Goods_ClassModel goodsClass = bllMaterialClasl.GetModelByClassName(stockParam.MaterialCate);
string materialClassID = stockParam.MaterialCate;
if (materialClassID != "所有")
{
if (goodsClass != null)
{
materialClassID = goodsClass.Goods_Class_ID;
}
else
{
this.View.ShowMessage("信息提示", "物料类别错误！");
}
}
ViewDataManager.STOCKQUERYDATAVIEWDATA.StockList.Clear();
ViewDataManager.STOCKQUERYDATAVIEWDATA.StockDetailList.Clear();
List <View_StockListModel> stockList = bllViewStockList.GetListByParams(stockParam.HouseName, stockParam.Rowth, stockParam.Colth, stockParam.Layer, materialClassID, stockParam.PalletCode);
var sdf = stockList.Distinct(new ListCompare <View_StockListModel>((x, y)
=> x.Stock_Tray_Barcode == y.Stock_Tray_Barcode));
List <View_StockListModel> distinctStockList = sdf.ToList();
//foreach (View_StockListModel vsm in stockList)
//{
// var existPallet = distinctStockList.Where(s => s.Stock_Tray_Barcode == vsm.Stock_Tray_Barcode);
// if (existPallet == null || existPallet.Count() == 0)
// {
// distinctStockList.Add(vsm);
// }
//}
foreach (View_StockListModel item in distinctStockList)
{
StockViewModel svm = new StockViewModel();
svm.货位编码 = item.Cell_Chlid_ID;
svm.托盘条码 = item.Stock_Tray_Barcode;
svm.货位名称 = item.Cell_Name;
if (item.Cell_Type != EnumCellType.货位.ToString())
{
svm.库房名称 = "暂存工位";
svm.位置 = item.Cell_Name;
}
else
{
svm.库房名称 = item.WareHouse_Name;
svm.位置 = item.Cell_Chlid_Position;
}
svm.库区 = item.Area_Name;
if (item.Stock_List_Entry_Time != null)
{
svm.入库时间 = item.Stock_List_Entry_Time.ToString();
}
ViewDataManager.STOCKQUERYDATAVIEWDATA.StockList.Add(svm);
}
}
/// <summary>
/// 基础物料数据信息
/// </summary>
/// <param name="materialInfoJson">物料信息json串</param>
/// <param name="operateType">操作类型：1增加、2更新、3删除</param>
/// <returns></returns>
public string MaterialInfo(string materialInfoJson, string operateType)
{
//materialInfoJson = GetMaterialTestJson();//测试
ResponseData response = new ResponseData();
try
{
MaterialInfo materialInfo = Newtonsoft.Json.JsonConvert.DeserializeObject <MaterialInfo>(materialInfoJson);
if (materialInfo == null)
{
response.Describe = "物料基础数据格式错误！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialInfoJson);
return(response.ToJson());
}
if (materialInfo.material_class == "" || materialInfo.material_class == null)
{
response.Describe = "物料基础数据的物料大类为空！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialInfoJson);
return(response.ToJson());
}
Goods_ClassModel gsClassModel = bllGoods_Class.GetModelByClassName(materialInfo.material_class);//物料大类型
if (gsClassModel == null)
{
gsClassModel = new Goods_ClassModel();
gsClassModel.Goods_Class_Name = materialInfo.material_class;
string gsClassMainID = Guid.NewGuid().ToString();
gsClassModel.Goods_Class_ID = gsClassMainID;
gsClassModel.Goods_Class_Flag = "true";
bllGoods_Class.Add(gsClassModel);
}
else
{
gsClassModel.Goods_Class_Name = materialInfo.material_class;
gsClassModel.Goods_Class_Flag = "true";
bllGoods_Class.Update(gsClassModel);
}
if (operateType != "1" && operateType != "2" && operateType != "3")
{
response.Describe = "接口操作标识错误！operateType，1为增加，2为更新，3为删除！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialInfoJson);
return(response.ToJson());
}
switch (operateType)
{
case "1": //增加
{
GoodsModel existgoods = bllGoods.GetModelByCode(materialInfo.material_code);
if (existgoods != null)
{
response.Describe = "物料基础数据添加失败，已经存在此物料编码：" + materialInfo.material_code;
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialInfoJson);
return(response.ToJson());
}
GoodsModel goods = new GoodsModel();
goods.Goods_ID = Guid.NewGuid().ToString();
goods.Goods_Code = materialInfo.material_code;
goods.Goods_Class_ID = gsClassModel.Goods_Class_ID;
goods.Goods_Suppier_Code = materialInfo.material_supplier_code;
goods.Goods_Category = materialInfo.material_category;
goods.Goods_Name = materialInfo.material_name;
if (materialInfo.material_enabled == true)
{
goods.Goods_Flag = "1";
}
else
{
goods.Goods_Flag = "0";
}
goods.Goods_Type = materialInfo.material_category;
goods.Goods_Unit = materialInfo.material_unit;
goods.Goods_Model = materialInfo.material_model;
bllGoods.Add(goods);
GoodsPropertyOperate(goods.Goods_ID, "shelflife", "保质期", materialInfo.material_shelflife.ToString(), true); //保质期
break;
}
case "2": //更新
{
GoodsModel goods = bllGoods.GetModelByCode(materialInfo.material_code);
if (goods == null)
{
response.Describe = "物料基础数据更新失败，不存此物料编码：" + materialInfo.material_code;
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialInfoJson);
return(response.ToJson());
}
goods.Goods_Code = materialInfo.material_code;
goods.Goods_Class_ID = gsClassModel.Goods_Class_ID;
goods.Goods_Suppier_Code = materialInfo.material_supplier_code;
goods.Goods_Name = materialInfo.material_name;
if (materialInfo.material_enabled == true)
{
goods.Goods_Flag = "1";
}
else
{
goods.Goods_Flag = "0";
}
goods.Goods_Type = materialInfo.material_category;
goods.Goods_Unit = materialInfo.material_unit;
goods.Goods_Model = materialInfo.material_model;
bllGoods.Update(goods);
GoodsPropertyOperate(goods.Goods_ID, "shelflife", "保质期", materialInfo.material_shelflife.ToString(), false); //保质期
break;
}
case "3":
{
bllGoods.DeleteByCode(materialInfo.material_code);
bllGoodsProperty.DeleteByGoodsCode(materialInfo.material_code);
break;
}
default:
{
response.Status = false;
response.Describe = "操作类型错误，operateType，1为增加，2为更新，3为删除！";
return(response.ToJson());
}
}
response.Describe = "物料基础数据导入成功！";
response.Status = true;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialInfoJson);
return(response.ToJson());
}
catch (Exception ex)
{
response.Describe = "物料基础数据导入失败！错误原因：" + ex.StackTrace.ToString();
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialInfoJson);
return(response.ToJson());
}
}
//public bool Login(string userName, string password)
//{
// if(this.userName == userName && this.password == password)
// {
// UserInfor user = new UserInfor();
// user.UserName = userName;
// user.PassWord = password;
// string sessionID = OperationContext.Current.SessionId;
// clientUser.Add(sessionID, user);
// return true;
// }
// else
// {
// return false;
// }
//}
public ResponseData BasicGoodsInfoImport(BasicGoodsInfo basicGoodsInfo)
{
ResponseData response = new ResponseData();
try
{
//if(this.GetSvrEnabled() == false)
//{
// return false;
//}
if (basicGoodsInfo == null)
{
response.Describe = "物料基础数据对象为空！";
response.Status = false;
return(response);
}
if (basicGoodsInfo.GoodsClass == "" || basicGoodsInfo.GoodsClass == null)
{
response.Describe = "物料基础数据的物料大类为空！";
response.Status = false;
return(response);
}
Goods_ClassModel gsClassModel = bllGoods_Class.GetModelByClassName(basicGoodsInfo.GoodsClass);
if (gsClassModel == null)
{
gsClassModel = new Goods_ClassModel();
gsClassModel.Goods_Class_Name = basicGoodsInfo.GoodsClass;
string gsClassMainID = Guid.NewGuid().ToString();
gsClassModel.Goods_Class_ID = gsClassMainID;
gsClassModel.Goods_Class_Flag = "true";
bllGoods_Class.Add(gsClassModel);
}
else
{
gsClassModel.Goods_Class_Name = basicGoodsInfo.GoodsClass;
gsClassModel.Goods_Class_Flag = "true";
bllGoods_Class.Update(gsClassModel);
}
GoodsModel goods = bllGoods.GetModelByReserve1(basicGoodsInfo.GoodsInnerCode.ToString());
if (goods == null)//没有就添加否则更新
{
goods = new GoodsModel();
goods.Goods_ID = Guid.NewGuid().ToString();
goods.Goods_Code = basicGoodsInfo.GoodsID;
goods.Goods_Class_ID = gsClassModel.Goods_Class_ID;
goods.Goods_Suppier_Code = basicGoodsInfo.GoodsApplierCode;
goods.Goods_Reserve1 = basicGoodsInfo.GoodsInnerCode.ToString();
goods.Goods_Name = basicGoodsInfo.GoodsName;
goods.Goods_Flag = basicGoodsInfo.GoodsStatus;
goods.Goods_Type = basicGoodsInfo.GoodsType;
goods.Goods_Unit = basicGoodsInfo.GoodsUnit;
bllGoods.Add(goods);
GoodsPropertyOperate(goods.Goods_ID, "fzxx", basicGoodsInfo.GoodsAssistProperty, true); //辅助信息
GoodsPropertyOperate(goods.Goods_ID, "zxbzsl", basicGoodsInfo.GoodsMinPackNum.ToString(), true); //辅助信息
GoodsPropertyOperate(goods.Goods_ID, "wljx", basicGoodsInfo.GoodsPolar, true); //辅助信息
}
else
{
goods.Goods_Code = basicGoodsInfo.GoodsID;
goods.Goods_Class_ID = gsClassModel.Goods_Class_ID;
goods.Goods_Suppier_Code = basicGoodsInfo.GoodsApplierCode;
goods.Goods_Reserve1 = basicGoodsInfo.GoodsInnerCode.ToString();
goods.Goods_Name = basicGoodsInfo.GoodsName;
goods.Goods_Flag = basicGoodsInfo.GoodsStatus;
goods.Goods_Type = basicGoodsInfo.GoodsType;
goods.Goods_Unit = basicGoodsInfo.GoodsUnit;
bllGoods.Update(goods);
GoodsPropertyOperate(goods.Goods_ID, "fzxx", basicGoodsInfo.GoodsAssistProperty, false); //辅助信息
GoodsPropertyOperate(goods.Goods_ID, "zxbzsl", basicGoodsInfo.GoodsMinPackNum.ToString(), false); //辅助信息
GoodsPropertyOperate(goods.Goods_ID, "wljx", basicGoodsInfo.GoodsPolar, false); //辅助信息
}
response.Describe = "数据导入成功！";
response.Status = true;
return(response);
}
catch (Exception ex)
{
response.Describe = "数据导入错误！" + ex.Message;
response.Status = false;
return(response);
}
}
