private void MainView_Load(object sender, EventArgs e)
{
MainFrameHandler.SetMainFrame(this);
//this.splitContainerControl1.SplitterPosition = (int)(this.splitContainerControl1.Height * 0.8);
DatabaseCfg();
Console.SetOut(new TextBoxWriter(this.richTextBoxLog));
InitTabbedMDI();
LoadForms();
//this.mainPresenter.Init(this, FormCloseEventHandler);
//string licenseFile = AppDomain.CurrentDomain.BaseDirectory + @"NBSSLicense.lic";
//this.licenseMonitor = new LicenseMonitor(this, 60000, licenseFile, "zzkeyFT1");
//if (!this.licenseMonitor.StartMonitor())
//{
// throw new Exception("license 监控失败");
//}
//string reStr = "";
//if (!this.licenseMonitor.IslicenseValid(ref reStr))
//{
// MessageBox.Show(reStr);
// return;
//}
}
/// <summary>
/// 出入库订单用一个接口，只是订单类型不同
/// </summary>
/// <param name="materialInBoundOrderJson"></param>
/// <returns></returns>
public string MaterialPlanOrder(string materialPlanOrderJson)
{
ResponseData response = new ResponseData();
try
{
Console.WriteLine(materialPlanOrderJson);
//materialPlanOrderJson = GetInBoundOrderTestJson();
InHouseOrder inHouseOrder = Newtonsoft.Json.JsonConvert.DeserializeObject <InHouseOrder>(materialPlanOrderJson);
if (inHouseOrder == null)
{
response.Describe = "订单数据格式错误！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialPlanOrderJson);
return(response.ToJson());
}
if (inHouseOrder.order_code == "")
{
response.Describe = "订单编码不能为空！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialPlanOrderJson);
return(response.ToJson());
}
if (inHouseOrder.InOut_Flag == "")
{
response.Describe = "出入库标识不能为空！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialPlanOrderJson);
return(response.ToJson());
}
//if (inHouseOrder.warehouse_code == "")
//{
// response.Describe = "库房编码不能为空！";
// response.Status = false;
// MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialPlanOrderJson);
// return response.ToJson();
//}
List <PlanListModel> planList = new List <PlanListModel>();
foreach (OderMaterialInfo material in inHouseOrder.MaterilaList)
{
PlanListModel plm = new PlanListModel();
plm.规格型号 = material.material_model;
plm.计划创建时间 = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
plm.计划单号 = inHouseOrder.order_code;
plm.计划列表编码 = Guid.NewGuid().ToString();
plm.计划数量 = material.material_number;
plm.计量单位 = material.material_unit;
plm.物料编码 = material.material_code;
plm.物料名称 = material.material_name;
plm.物料批次 = material.material_batch;
planList.Add(plm);
}
string planTypeName = "";
if (inHouseOrder.InOut_Flag.Trim() == "1")//入库
{
planTypeName = "入库";
}
else//出库
{
planTypeName = "出库";
}
string restr = "";
bool status = wmsExtern.AddExternPlan(inHouseOrder.order_code, planTypeName,
inHouseOrder.order_maker, DateTime.Parse(inHouseOrder.order_date), inHouseOrder.warehouse_code, planList, inHouseOrder.order_voucherType, ref restr);
if (status == false)
{
response.Describe = "入库订单数据导入失败！" + restr;
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialPlanOrderJson);
return(response.ToJson());
}
ERP_Plan_ReportModel existPlan = bllErpPlanReport.GetModelByPlanCode(inHouseOrder.order_code);
if (existPlan == null)
{
ERP_Plan_ReportModel erpReport = new ERP_Plan_ReportModel();
erpReport.ERP_Plan_Code = inHouseOrder.order_code;
erpReport.ERP_Plan_IsReported = false;
erpReport.ERP_Plan_Report_Content = materialPlanOrderJson;
erpReport.ERP_Plan_Report_ID = Guid.NewGuid().ToString();
bllErpPlanReport.Add(erpReport);
}
response.Describe = "订单数据导入成功！";
response.Status = true;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialPlanOrderJson);
return(response.ToJson());
}
catch (Exception ex)
{
response.Describe = "订单数据导入失败！错误原因：" + ex.StackTrace.ToString();
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "错误", response.Describe + "信息内容：" + materialPlanOrderJson);
return(response.ToJson());
}
}
/// <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 string WareHouseInfo(string wareHouseInfoJson, string operateType)
{
ResponseData response = new ResponseData();
WH_WareHouseModel wareHouseDb = new WH_WareHouseModel();
//WareHouse wareHouse = new WareHouse();
//wareHouseInfoJson = GetWareHouseTestJson();//测试
try
{
WareHouse wareHouse = Newtonsoft.Json.JsonConvert.DeserializeObject <WareHouse>(wareHouseInfoJson);
if (wareHouse == null)
{
response.Describe = "库房档案数据格式错误！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + wareHouseInfoJson);
return(response.ToJson());
}
if (wareHouse.warehouse_code == "")
{
response.Describe = "库房编码不能为空！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + wareHouseInfoJson);
return(response.ToJson());
}
if (wareHouse.warehouse_name == "")
{
response.Describe = "库房名称不能为空！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + wareHouseInfoJson);
return(response.ToJson());
}
if (operateType != "1" && operateType != "2" && operateType != "3")
{
response.Describe = "接口操作标识错误！operateType，1为增加，2为更新，3为删除！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + wareHouseInfoJson);
return(response.ToJson());
}
switch (operateType)
{
case "1": //增加
{
wareHouseDb = bllWareHouse.GetModelByCode(wareHouse.warehouse_code);
if (wareHouseDb != null)
{
response.Describe = "库房档案添加失败，已经存在此库房编码：" + wareHouse.warehouse_code;
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + wareHouseInfoJson);
return(response.ToJson());
}
wareHouseDb = new WH_WareHouseModel();
wareHouseDb.WareHouse_ID = Guid.NewGuid().ToString();
wareHouseDb.WareHouse_Code = wareHouse.warehouse_code;
wareHouseDb.WareHouse_Name = wareHouse.warehouse_name;
bllWareHouse.Add(wareHouseDb);
break;
}
case "2": //更新
{
wareHouseDb = bllWareHouse.GetModelByCode(wareHouse.warehouse_code);
if (wareHouseDb == null)
{
response.Describe = "库房档案数据更细失败，此库房编码不存在：" + wareHouse.warehouse_code;
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + wareHouseInfoJson);
return(response.ToJson());
}
wareHouseDb.WareHouse_Code = wareHouse.warehouse_code;
wareHouseDb.WareHouse_Name = wareHouse.warehouse_name;
bllWareHouse.Update(wareHouseDb);
break;
}
case "3": //删除
{
bllWareHouse.DeleteByCode(wareHouse.warehouse_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 + "信息内容：" + wareHouseInfoJson);
return(response.ToJson());
}
catch (Exception ex)
{
response.Describe = "物料单位数据导入失败！错误原因：" + ex.StackTrace.ToString();
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "错误", response.Describe + "信息内容：" + wareHouseInfoJson);
return(response.ToJson());
}
}
public string MaterialUnit(string materialUnitJson, string operateType)
{
ResponseData response = new ResponseData();
Goods_UnitModel unitDBModel = new Goods_UnitModel();
//materialUnitJson = GetMaterialUnitTestJson();//测试
try
{
MaterialUnit materialUnit = Newtonsoft.Json.JsonConvert.DeserializeObject <MaterialUnit>(materialUnitJson);
if (materialUnit == null)
{
response.Describe = "物料单位基础数据格式错误！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialUnitJson);
return(response.ToJson());
}
if (materialUnit.unit_code == "")
{
response.Describe = "物料单位不能为空！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialUnitJson);
return(response.ToJson());
}
if (materialUnit.unit_name == "")
{
response.Describe = "物料单位名称不能为空！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialUnitJson);
return(response.ToJson());
}
if (operateType != "1" && operateType != "2" && operateType != "3")
{
response.Describe = "接口操作标识错误！operateType，1为增加，2为更新，3为删除！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialUnitJson);
return(response.ToJson());
}
switch (operateType)
{
case "1": //增加
{
unitDBModel = bllUnit.GetModelByCode(materialUnit.unit_code);
if (unitDBModel != null)
{
response.Describe = "物料单位添加失败，已经存在此物料单位编码：" + materialUnit.unit_code;
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialUnitJson);
return(response.ToJson());
}
unitDBModel = new Goods_UnitModel();
unitDBModel.Goods_Unit_ID = Guid.NewGuid().ToString();
unitDBModel.Goods_Unit_Name = materialUnit.unit_name;
unitDBModel.Goods_Unit_Code = materialUnit.unit_code;
bllUnit.Add(unitDBModel);
break;
}
case "2": //更新
{
unitDBModel = bllUnit.GetModelByCode(materialUnit.unit_code);
if (unitDBModel == null)
{
response.Describe = "物料单位数据更细失败，此物料单位编码不存在：" + materialUnit.unit_code;
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + materialUnitJson);
return(response.ToJson());
}
unitDBModel.Goods_Unit_Name = materialUnit.unit_name;
unitDBModel.Goods_Unit_Code = materialUnit.unit_code;
bllUnit.Update(unitDBModel);
break;
}
case "3": //删除
{
bllUnit.DeleteByCode(materialUnit.unit_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 + "信息内容：" + materialUnitJson);
return(response.ToJson());
}
catch (Exception ex)
{
response.Describe = "物料单位数据导入失败！错误原因：" + ex.StackTrace.ToString();
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "错误", response.Describe + "信息内容：" + materialUnitJson);
return(response.ToJson());
}
}
public string SupplierInfo(string supplierInfoJson, string operateType)
{
ResponseData response = new ResponseData();
Goods_SupplierModel supplierModel = new Goods_SupplierModel();
//supplierInfoJson = GetSuppierTestJson();//测试
try
{
Supplier supplier = Newtonsoft.Json.JsonConvert.DeserializeObject <Supplier>(supplierInfoJson);
if (supplier == null)
{
response.Describe = "供应商基础数据格式错误！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + supplierInfoJson);
return(response.ToJson());
}
if (supplier.supplier_code == "")
{
response.Describe = "供应商编码不能为空！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + supplierInfoJson);
return(response.ToJson());
}
if (supplier.supplier_name == "")
{
response.Describe = "供应商名称不能为空！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + supplierInfoJson);
return(response.ToJson());
}
if (operateType != "1" && operateType != "2" && operateType != "3")
{
response.Describe = "接口操作标识错误！operateType，1为增加，2为更新，3为删除！";
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + supplierInfoJson);
return(response.ToJson());
}
switch (operateType)
{
case "1": //增加
{
supplierModel = bllSupplier.GetModelByCode(supplier.supplier_code);
if (supplierModel != null)
{
response.Describe = "供应商基础数据添加失败，已经存在此供应商编码：" + supplier.supplier_code;
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + supplierInfoJson);
return(response.ToJson());
}
supplierModel = new Goods_SupplierModel();
supplierModel.Goods_Supplier_ID = Guid.NewGuid().ToString();
supplierModel.Goods_Supplier_Name = supplier.supplier_name;
supplierModel.Goods_Supplier_Code = supplier.supplier_code;
bllSupplier.Add(supplierModel);
break;
}
case "2": //更新
{
supplierModel = bllSupplier.GetModelByCode(supplier.supplier_code);
if (supplierModel == null)
{
response.Describe = "供应商基础数据更细失败，此供应商编码不存在：" + supplier.supplier_code;
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + supplierInfoJson);
return(response.ToJson());
}
supplierModel.Goods_Supplier_Name = supplier.supplier_name;
supplierModel.Goods_Supplier_Code = supplier.supplier_code;
bllSupplier.Update(supplierModel);
break;
}
case "3": //删除
{
bllSupplier.DeleteByCode(supplier.supplier_code);
break;
}
default:
{
response.Status = false;
response.Describe = "操作类型错误，operateType，1为增加，2为更新，3为删除！";
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + supplierInfoJson);
return(response.ToJson());
}
}
response.Describe = "物料供应商数据导入成功！";
response.Status = true;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + supplierInfoJson);
return(response.ToJson());
}
catch (Exception ex)
{
response.Describe = "物料供应商数据导入失败！错误原因：" + ex.StackTrace.ToString();
response.Status = false;
MainFrameHandler.GetMainFrame().WriteLog("WMS_To_ERP服务", "", "提示", response.Describe + "信息内容：" + supplierInfoJson);
return(response.ToJson());
}
}
