private void btn_OK_Click(object sender, EventArgs e)
{
if (this.txt_MaterialNo.Text.Trim().Length > 0 &&
this.txt_MaterialName.Text.Trim().Length > 0 &&
RegularHelper.isNumericString(this.txt_MaterialPos.Text.Trim()) &&
RegularHelper.isNumericString(this.txt_CountPerBox.Text.Trim()) &&
RegularHelper.isNumericString(this.txt_UsageTime.Text.Trim()))
{
if (MaterialInfoBLL.UpdateMaterial(this.txt_MaterialNo.Text.Trim(), this.txt_MaterialName.Text.Trim(),
byte.Parse(this.txt_MaterialPos.Text.Trim()), int.Parse(this.txt_CountPerBox.Text.Trim()), int.Parse(this.txt_UsageTime.Text.Trim())))
{
ShowLoginTip("零件信息更新成功.");
updateCurrentRow();
}
else if (MaterialInfoBLL.InsertMaterial(this.txt_MaterialNo.Text.Trim(), this.txt_MaterialName.Text.Trim(),
byte.Parse(this.txt_MaterialPos.Text.Trim()), int.Parse(this.txt_CountPerBox.Text.Trim()), int.Parse(this.txt_UsageTime.Text.Trim())))
{
ShowLoginTip("零件信息添加成功.");
Load_lsv_MaterialInfo();
}
else
{
SpMessageBox.Show(this.txt_MaterialName.Text.Trim() + "信息更新失败.", "零件信息维护");
}
}
}
public void Select(object obj)
{
try
{
LogHelper.WriteLog($"成功选择计划，索引为{ProducePlanIndex}");
if (ProducePlanIndex.Equals(-1))
{
return;
}
StoreInfoModel.ProducePlanInfo = StoreInfoModel.ProducePlanInfos[ProducePlanIndex];
//下料
if (StoreInfoModel.WorkGroupInfo.GetWorkGroup.DepartID.Equals("0218" /*"0209"*/))
{
LogHelper.WriteLog($"当前计划为下料");
WindowHelper.ShowPageBlankingRecord();
}
//生产
else
{
LogHelper.WriteLog($"当前为普通生产计划");
//加载该生产计划所需物料详情
var getMaterialInfo = new MaterialInfoBLL().GetMaterialDetail();
if (!getMaterialInfo.Result)
{
MessageBox.Show(getMaterialInfo.Msg, "提示", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
LogHelper.WriteLog($"成功加载物料信息");
//下载图纸文件
var drawResult = new ProducePlanInfoBLL().DownLoadDrawing();
if (!drawResult.Result)
{
MessageBox.Show(drawResult.Msg, "提示", MessageBoxButton.OK, MessageBoxImage.Warning);
//return;
}
LogHelper.WriteLog($"成功加载图纸信息");
WindowHelper.ShowOperatorStatistical();
}
}
catch (Exception ex)
{
LogHelper.WriteLog($"异常：{ex}");
}
}
public static List <MaterialInfo> GetMaterialInfosList()
{
List <MaterialInfo> productMaterialsList = new List <MaterialInfo>();
foreach (var val in MaterialInfoBLL.GetMaterialInfos())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.MaterialNo;
materialTemp.MaterialName = val.MaterialName;
materialTemp.UsageTimePerBox = val.UsageTimePerBox;
materialTemp.CountPerBox = val.CountPerBox;
materialTemp.Position = val.Position;
productMaterialsList.Add(materialTemp);
}
return(productMaterialsList);
}
/// <summary>
/// List GetSampleQryResult, get 4 COLUMNs from samplemain and patien to a list to show in listview
/// </summary>
/// <returns></returns>
public List <MaterialInfo> GetProductBOMList(string _productNo)
{
List <MaterialInfo> productMaterialsList = new List <MaterialInfo>();
if (productMaterialsList.Count > 0)
{
productMaterialsList.Clear();
}
foreach (var val in ProductBOMBLL.GetProductBOMList(_productNo))
{
if (val.ProductNo != "" && val.ProductNo != null)
{
if (!val.IsMaterial1NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material1No;
materialTemp.MaterialPcs = val.Material1Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial2NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material2No;
materialTemp.MaterialPcs = val.Material2Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial3NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material3No;
materialTemp.MaterialPcs = val.Material3Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial4NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material4No;
materialTemp.MaterialPcs = val.Material4Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial5NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material5No;
materialTemp.MaterialPcs = val.Material5Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial6NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material6No;
materialTemp.MaterialPcs = val.Material6Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial7NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material7No;
materialTemp.MaterialPcs = val.Material7Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial8NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material8No;
materialTemp.MaterialPcs = val.Material8Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial9NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material9No;
materialTemp.MaterialPcs = val.Material9Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial10NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material10No;
materialTemp.MaterialPcs = val.Material10Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial11NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material11No;
materialTemp.MaterialPcs = val.Material11Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial12NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material12No;
materialTemp.MaterialPcs = val.Material12Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial13NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material13No;
materialTemp.MaterialPcs = val.Material13Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial14NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material14No;
materialTemp.MaterialPcs = val.Material14Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial15NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material15No;
materialTemp.MaterialPcs = val.Material15Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial16NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material16No;
materialTemp.MaterialPcs = val.Material16Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial17NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material17No;
materialTemp.MaterialPcs = val.Material17Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial18NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material18No;
materialTemp.MaterialPcs = val.Material18Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial19NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material19No;
materialTemp.MaterialPcs = val.Material19Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
if (!val.IsMaterial20NoNull())
{
MaterialInfo materialTemp = new MaterialInfo();
materialTemp.MaterialNo = val.Material20No;
materialTemp.MaterialPcs = val.Material20Count;
materialTemp.MaterialName = MaterialInfoBLL.GetMaterialName(materialTemp.MaterialNo);
materialTemp.MaterialSeq = MaterialInfoBLL.GetMaterialPostion(materialTemp.MaterialNo);
productMaterialsList.Add(materialTemp);
}
}
}
return(productMaterialsList);
}
public static void UpdateProdLineMaterialRcvCount(string _materialNo, byte _productLineNo, string _orderNo, int _receivedCount)
{//string _materialNo, byte _productionLineNo, string _orderNo, int _usedCount
if (_productLineNo > 0 && _productLineNo < 10 && _orderNo.Length > 0 && _materialNo.Length > 0 && _receivedCount > 0)
{
int _recordNo = ProductionLineMaterialBLL.GetProdLineMaterialRecord(_materialNo, _productLineNo, _orderNo);
if (_recordNo > 0)
{
int _previousReceivedCount = ProductionLineMaterialBLL.GetProdLineMaterialReceivedCount(_materialNo, _productLineNo, _orderNo);
if (ProductionLineMaterialBLL.UpdateProdLineMaterialReceivedCount(_materialNo, _productLineNo, _orderNo, _receivedCount + _previousReceivedCount))
{
LogerHelper.ToLog("新物料箱更新database " + _orderNo + ":" + _materialNo + "," + _receivedCount + "+" + _previousReceivedCount, false);
}
else
{
LogerHelper.ToLog("更新databse出错 " + _orderNo + ":" + _materialNo + "," + _receivedCount + "+" + _previousReceivedCount, false);
}
}
else
{
if (ProductionLineMaterialBLL.InsertProdLineMaterial(_materialNo, MaterialInfoBLL.GetMaterialName(_materialNo), 0, _productLineNo, _receivedCount, _orderNo))
{
LogerHelper.ToLog("新物料写入database " + _orderNo + ":" + _materialNo + "," + _receivedCount, false);
}
else
{
LogerHelper.ToLog("写databse出错 " + _orderNo + ":" + _materialNo + "," + _receivedCount, false);
}
}
}
}
public void BarCodeScan(object obj)
{
try
{
string barCode = obj.ToString();
BarCode = "";
LogHelper.WriteLog($"条码：{barCode}");
if (string.IsNullOrEmpty(barCode))
{
return;
}
MaterialScanModel materialScan_Left = LeftData.SingleOrDefault(item => item.BarCode.Equals(barCode));
LogHelper.WriteLog($"正在左侧搜索...");
if (materialScan_Left == null)
{
MaterialScanModel materialScan_Center = CenterData.SingleOrDefault(item => item.BarCode.Equals(barCode));
LogHelper.WriteLog($"正在中间搜索...");
if (materialScan_Center == null)
{
MaterialScanModel materialScan_Right = RightData.SingleOrDefault(item => item.BarCode.Equals(barCode));
LogHelper.WriteLog($"正在右侧搜索...");
if (materialScan_Right == null)
{
//查该条码为何物
LogHelper.WriteLog($"正在调用接口搜索...\r\n{string.Format(@"http://{0}/api/Mms/WinFormClient/GetPartAndPBomByBarCode?barCode={1}", ConfigInfoModel.API, barCode)}");
var result = new MaterialInfoBLL().GetPartAndPBomByBarCode(barCode);
LogHelper.WriteLog($"搜索结果：{result.Result},详情：{result.Msg ?? ""}");
if (result.Result)
{
RightData.Add(new MaterialScanModel()
{
PartCode = result.Data.GetPart.PartCode ?? "",
PartFigureCode = result.Data.GetProcessBom.PartFigureCode ?? "",
AlreadyScanQuantity = 1,
BarCode = barCode
});
var aaa = new MaterialInfoBLL().SaveBarCodeScanLog(barCode);
LogHelper.WriteLog($"记录扫码日志结果：{aaa.Result} {aaa.Msg ?? ""}");
}
else
{
RightData.Add(new MaterialScanModel()
{
PartCode = "",
PartFigureCode = $"无图号({barCode})",
AlreadyScanQuantity = 1,
BarCode = barCode
});
//MessageBox.Show(result.Msg, "提示", MessageBoxButton.OK, MessageBoxImage.Asterisk);
}
}
else
{
materialScan_Right.AlreadyScanQuantity++;
var aaa = new MaterialInfoBLL().SaveBarCodeScanLog(barCode);
LogHelper.WriteLog($"记录扫码日志结果：{aaa.Result} {aaa.Msg ?? ""}");
}
}
else
{
if (materialScan_Center.IsCrux.Equals(1))
{
if (materialScan_Center.AlreadyScanQuantity < materialScan_Center.DemandScanQuantity)
{
//执行出库
var result = new MaterialInfoBLL().MaterialInventory(materialScan_Center.PartCode);
if (result.Result)
{
//出库成功
materialScan_Center.AlreadyScanQuantity++;
}
else
{
//出库失败
MessageBox.Show(result.Msg, "提示", MessageBoxButton.OK, MessageBoxImage.Asterisk);
}
}
else
{
materialScan_Center.AlreadyScanQuantity++;
}
var aaa = new MaterialInfoBLL().SaveBarCodeScanLog(barCode);
LogHelper.WriteLog($"记录扫码日志结果：{aaa.Result} {aaa.Msg ?? ""}");
}
else
{
materialScan_Center.AlreadyScanQuantity = materialScan_Center.DemandScanQuantity;
var aaa = new MaterialInfoBLL().SaveBarCodeScanLog(barCode, materialScan_Center.DemandScanQuantity);
LogHelper.WriteLog($"记录扫码日志结果：{aaa.Result} {aaa.Msg ?? ""}");
}
}
}
else
{
LeftData.Remove(materialScan_Left);
CenterData.Add(materialScan_Left);
if (materialScan_Left.IsCrux.Equals(1))
{
//执行出库
var result = new MaterialInfoBLL().MaterialInventory(materialScan_Left.PartCode);
if (result.Result)
{
//出库成功
materialScan_Left.AlreadyScanQuantity++;
}
else
{
//出库失败
MessageBox.Show(result.Msg, "提示", MessageBoxButton.OK, MessageBoxImage.Asterisk);
}
var aaa = new MaterialInfoBLL().SaveBarCodeScanLog(barCode);
LogHelper.WriteLog($"记录扫码日志结果：{aaa.Result} {aaa.Msg ?? ""}");
}
else
{
materialScan_Left.AlreadyScanQuantity = materialScan_Left.DemandScanQuantity;
var aaa = new MaterialInfoBLL().SaveBarCodeScanLog(barCode, materialScan_Left.DemandScanQuantity);
LogHelper.WriteLog($"记录扫码日志结果：{aaa.Result} {aaa.Msg ?? ""}");
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog($"扫码异常：{ex}");
}
}
