private void GetListQueryData() { bsMain.EndEdit(); bool bResult = false; string strErr = string.Empty; GetQueryMain(); ChensControl.DividPage clientPage = pageList.dDividPage; Common.Common_Func.GetServerPageFromClientPage(ref _serverMainPage, clientPage); bResult = Query_Func.GetStockListByPage(ref lstMain, queryMain, ref _serverMainPage, ref strErr); Common.Common_Func.GetClientPageFromServerPage(_serverMainPage, ref clientPage); pageList.ShowPage(); //添加总计 Stock_Model sum_model = new Stock_Model(); foreach (Stock_Model st_model in lstMain) { sum_model.Qty += st_model.Qty; } sum_model.AreaName = "总计"; lstMain.Add(sum_model); dgvList.DataSource = lstMain; if (!bResult || !string.IsNullOrEmpty(strErr)) { Common.Common_Func.ErrorMessage(strErr, "查询失败"); } txtWarehouseNo.Focus(); }
private void pageList_ChensPageChange(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; bsMain.EndEdit(); string strErr = string.Empty; if (queryMain == null) { queryMain = new Stock_Model(); bsMain.DataSource = queryMain; } ChensControl.DividPage clientPage = pageList.dDividPage; Common.Common_Func.GetServerPageFromClientPage(ref _serverMainPage, clientPage); bool bResult = WMS.Common.WMSWebService.service.GetImportPrintStockByPage(ref lstMain, queryMain, ref _serverMainPage, Common.Common_Var.CurrentUser, ref strErr); Common.Common_Func.GetClientPageFromServerPage(_serverMainPage, ref clientPage); pageList.ShowPage(); dgvList.DataSource = lstMain; if (!bResult || !string.IsNullOrEmpty(strErr)) { Common.Common_Func.ErrorMessage(strErr, "查询失败"); } } catch (Exception ex) { Common.Common_Func.ErrorMessage(ex.Message, "查询失败"); } finally { this.Cursor = Cursors.Default; } }
private void GetQueryMain() { if (queryMain == null) { queryMain = new Stock_Model(); bsMain.DataSource = queryMain; } }
private void tsmiImport_Click(object sender, EventArgs e) { try { //导入Excel OpenFileDialog openFile = new OpenFileDialog(); filename = ""; if (openFile.ShowDialog() == DialogResult.OK) { filename = openFile.FileNames[0]; } if (filename != "") { if (!filename.Substring(filename.Length - 4).Equals(".xls") && !filename.Substring(filename.Length - 5).Equals(".xlsx")) { MessageBox.Show("该文件不是指定文件类型!"); filename = ""; return; } } else { MessageBox.Show("该文件不是指定文件类型或配置文件错误!"); return; } string table = filename.Substring(filename.LastIndexOf("_", filename.Length) + 1, filename.LastIndexOf(".", filename.Length) - filename.LastIndexOf("_", filename.Length) - 1); //将Excel表中的数据导入到Datatable中 DataTable dt = LoadExcelToDataTable(filename, "Sheet1"); List <Stock_Model> list = new List <Stock_Model>(); for (int i = 0; i < dt.Rows.Count; i++) { Stock_Model stockmodel = new Stock_Model(); stockmodel.MaterialNo = dt.Rows[i]["物料号"].ToString(); stockmodel.MaterialDesc = dt.Rows[i]["U8规格型号"].ToString(); stockmodel.WarehouseNo = dt.Rows[i]["货位编号"].ToString().Split('-')[0]; stockmodel.HouseNo = dt.Rows[i]["货位编号"].ToString().Split('-')[1]; stockmodel.AreaNo = dt.Rows[i]["货位编号"].ToString();// dt.Rows[i]["货位编号"].ToString().Split('-')[2] + "-" + dt.Rows[i]["货位编号"].ToString().Split('-')[3]; stockmodel.Qty = dt.Rows[i]["数量"].ToInt32(); stockmodel.cvencode = dt.Rows[i]["供应商代码"].ToString(); list.Add(stockmodel); } string strErrMsg = ""; if (!WMS.Common.WMSWebService.service.ImportMaterialStock(list, ref strErrMsg)) { MessageBox.Show("导入数据失败:" + strErrMsg); return; } else { MessageBox.Show("导入成功"); } } catch (Exception ex) { MessageBox.Show("导入数据失败:" + ex.Message); return; } }
private void button1_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; ChensControl.DividPage clientPage = pageList.dDividPage; DividPage _serverMainPage = new DividPage(); Common.Common_Func.GetServerPageFromClientPage(ref _serverMainPage, clientPage); queryMain = new Stock_Model(); if (txtWhereMaterialNo.Text.Trim().Length > 0)//物料号 { queryMain.MaterialNo = txtWhereMaterialNo.Text.Trim(); } if (txtWhereWarehouseNo.Text.Trim().Length > 0)//库存仓库 { queryMain.WarehouseNo = txtWhereWarehouseNo.Text.Trim(); } if (txtWhereHouseNo.Text.Trim().Length > 0)//库存库区 { queryMain.HouseNo = txtWhereHouseNo.Text.Trim(); } if (txtWhereAreaNo.Text.Trim().Length > 0)//库存货位 { queryMain.AreaNo = txtWhereAreaNo.Text.Trim(); } //queryMain.BatchNo = "期初"; string strErrMsg = ""; bool bResult = WMS.Common.WMSWebService.service.GetImportPrintStockByPage(ref lstMain, queryMain, ref _serverMainPage, Common.Common_Var.CurrentUser, ref strErrMsg); Common.Common_Func.GetClientPageFromServerPage(_serverMainPage, ref clientPage); pageList.ShowPage(); bsMain.DataSource = lstMain; if (bResult == false) { Common.Common_Func.ErrorMessage(strErrMsg, "程序异常"); return; } //txtWhereMaterialNo.Text = ""; //txtWhereWarehouseNo.Text = ""; //txtWhereHouseNo.Text = ""; //txtWhereAreaNo.Text = ""; } catch (Exception ex) { Common.Common_Func.ErrorMessage(ex.Message, "程序异常"); } finally { this.Cursor = Cursors.Default; } }
private void InitMainQuery() { _serverMainPage = new DividPage(); queryMain = new Stock_Model(); lstMain = new List <Stock_Model>(); pageList.GetShowCountsByDGV(dgvList); bsMain.DataSource = queryMain; if (Common.Common_Func.IsWarehouseUserNo(Common.Common_Var.CurrentUser.UserNo)) { queryMain.WarehouseNo = Common.Common_Var.CurrentUser.UserNo.Substring(0, 1); } }
private void GetQueryMain() { if (queryMain == null) { queryMain = new Stock_Model(); bsMain.DataSource = queryMain; } if (dtpBeginTime.Checked) { queryMain.StartTime = dtpBeginTime.Value; } else { queryMain.StartTime = null; } if (dtpEndTime.Checked) { queryMain.EndTime = dtpEndTime.Value; } else { queryMain.EndTime = null; } }
void PrintStock(int model) { if (currentDetail != null) { try { if (model == 0) { //验证 if (new System.Text.RegularExpressions.Regex(@"[\u4e00-\u9fa5]").IsMatch(txtcinvstd.Text)) { MessageBox.Show("规格型号中包含有中文"); txtcinvstd.SelectAll(); txtcinvstd.Focus(); return; } } if (!new System.Text.RegularExpressions.Regex(@"^[0-9]\d*$").IsMatch(txtOutPackQty.Text)) { MessageBox.Show("外箱包装量必须是正整数"); return; } if (!new System.Text.RegularExpressions.Regex(@"^[0-9]\d*$").IsMatch(txtPrintQty.Text)) { MessageBox.Show("打印份数必须是正整数"); return; } if (!new System.Text.RegularExpressions.Regex(@"^[0-9]\d*$").IsMatch(txtBatchQty.Text)) { MessageBox.Show("打印数量必须是正整数"); return; } //生成条码 string strErrMsg = ""; List <WebService.ProductLabel_Model> label_lst = null; WebService.ProductLabel_Model label = new WebService.ProductLabel_Model(); label.invstd = txtcinvstd.Text; label.Remark = "内部使用"; label.labeltype = "15";//国内的成品外箱 label.outpackqty = txtOutPackQty.Text; label.materialno = txtMaterialNo.Text; label.materialdesc = txtMaterialDesc.Text; Stock_Model stockmodel = new Stock_Model(); stockmodel.AreaNo = currentDetail.AreaNo; stockmodel.MaterialNo = currentDetail.MaterialNo; stockmodel.MaterialDesc = currentDetail.MaterialDesc; stockmodel.MaterialStd = currentDetail.MaterialStd; stockmodel.WarehouseNo = currentDetail.WarehouseNo; stockmodel.HouseNo = currentDetail.HouseNo; if (!WMS.Common.WMSWebService.service.CreateInitialProductBarcode(stockmodel, label, Convert.ToInt16(txtBatchQty.Text), ref label_lst, ref strErrMsg)) { MessageBox.Show("生成条码失败:" + strErrMsg); return; } int printqty = Convert.ToInt16(txtPrintQty.Text); List <WebService.ProductLabel_Model> list = new List <WebService.ProductLabel_Model>(); for (int i = 0; i < label_lst.Count; i++) { label_lst[i].qrbarcode = Print_Func.ConvertImageToString(Print_Func.CreateQRCode(label_lst[i].barcode)); for (int j = 0; j < printqty; j++) { list.Add(label_lst[i]); } } FrmStockLabelPrint frm = new FrmStockLabelPrint(model, list); frm.ShowDialog(); txtWhereMaterialNo.Text = ""; txtWhereWarehouseNo.Text = ""; txtWhereHouseNo.Text = ""; txtWhereAreaNo.Text = ""; btnSearch_Click(null, null); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void 原料标签打印ToolStripMenuItem_Click(object sender, EventArgs e) { if (currentDetail != null) { if (!new System.Text.RegularExpressions.Regex(@"^[0-9]\d*$").IsMatch(txtOutPackQty.Text)) { MessageBox.Show("外箱包装量必须是正整数"); return; } if (!new System.Text.RegularExpressions.Regex(@"^[0-9]\d*$").IsMatch(txtPrintQty.Text)) { MessageBox.Show("打印份数必须是正整数"); return; } if (!new System.Text.RegularExpressions.Regex(@"^[0-9]\d*$").IsMatch(txtBatchQty.Text)) { MessageBox.Show("打印数量必须是正整数"); return; } //生成条码 string strErrMsg = ""; WebService.MaterialLabel_Model label = new WebService.MaterialLabel_Model(); label.prdversion = "3"; label.labeltype = "09"; label.outpackqty = txtOutPackQty.Text; label.materialno = currentDetail.MaterialNo; label.materialdesc = currentDetail.MaterialDesc; label.invstd = currentDetail.MaterialStd; label.cvencode = currentDetail.cvencode != null ? currentDetail.cvencode : ""; label.cvenabbname = currentDetail.cvenname != null ? currentDetail.cvenname : ""; Stock_Model stockmodel = new Stock_Model(); stockmodel.AreaNo = currentDetail.AreaNo; stockmodel.MaterialNo = currentDetail.MaterialNo; stockmodel.MaterialDesc = currentDetail.MaterialDesc; stockmodel.MaterialStd = currentDetail.MaterialStd; stockmodel.WarehouseNo = currentDetail.WarehouseNo; stockmodel.HouseNo = currentDetail.HouseNo; List <WebService.MaterialLabel_Model> label_lst = null; if (!WMS.Common.WMSWebService.service.CreateInitialMaterialBarcode(stockmodel, label, Convert.ToInt16(txtBatchQty.Text), ref label_lst, ref strErrMsg)) { MessageBox.Show("生成条码失败:" + strErrMsg); return; } int printqty = Convert.ToInt16(txtPrintQty.Text); int count = Convert.ToInt16(txtBatchQty.Text); for (int j = 0; j < printqty; j++) { for (int i = 0; i < count; i++) { string printStr = ""; //将文本框中的内容按行转成图片 StringBuilder ReturnBarcodeCMD = new StringBuilder(10240); RawPrinterHelper.GETFONTHEX("货位:" + label_lst[i].Locale, "宋体", "txt1", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; if (label_lst[i].cvenabbname.Length > 0) { if (label_lst[i].cvenabbname.Length > 6) { RawPrinterHelper.GETFONTHEX("供应商:" + label_lst[i].cvenabbname.Substring(0, 6), "宋体", "txt2", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; RawPrinterHelper.GETFONTHEX(label_lst[i].cvenabbname.Substring(6), "宋体", "txt3", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; } else { RawPrinterHelper.GETFONTHEX("供应商:" + label_lst[i].cvenabbname, "宋体", "txt2", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; } } RawPrinterHelper.GETFONTHEX("物料编码:" + label_lst[i].materialno, "宋体", "txt4", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; if (label_lst[i].materialdesc.Length > 8) { RawPrinterHelper.GETFONTHEX("物料名称:" + label_lst[i].materialdesc.Substring(0, 8), "宋体", "txt5", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; RawPrinterHelper.GETFONTHEX(label_lst[i].materialdesc.Substring(8), "宋体", "txt6", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; } else { RawPrinterHelper.GETFONTHEX("物料名称:" + label_lst[i].materialdesc, "宋体", "txt5", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; } if (label_lst[i].invstd.Length > 8) { RawPrinterHelper.GETFONTHEX("规格型号:" + label_lst[i].invstd.Substring(0, 8), "宋体", "txt7", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; RawPrinterHelper.GETFONTHEX(label_lst[i].invstd.Substring(8), "宋体", "txt8", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; } else { RawPrinterHelper.GETFONTHEX("规格型号:" + label_lst[i].invstd, "宋体", "txt7", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; } //RawPrinterHelper.GETFONTHEX("生产日期:" + dtpBatchNo.Value.ToString("yyyy/MM/dd"), "宋体", "txt9", 0, 26, 14, 1, 0, ReturnBarcodeCMD); //printStr += ReturnBarcodeCMD; RawPrinterHelper.GETFONTHEX("包装量:" + label_lst[i].outpackqty, "宋体", "txt10", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; RawPrinterHelper.GETFONTHEX("箱号:" + label_lst[i].Remark, "宋体", "txt11", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; RawPrinterHelper.GETFONTHEX(label_lst[i].BarcodeExpress, "宋体", "txt12", 0, 26, 14, 1, 0, ReturnBarcodeCMD); printStr += ReturnBarcodeCMD; printStr += "^XA^MMT^PW559^LL0559^LS0"; printStr += "^FT160,66^XGtxt1,1,1^FS"; if (label_lst[i].cvenabbname.Length > 0) { printStr += "^FT160,120^XGtxt2,1,1^FS"; if (label_lst[i].cvenabbname.Length > 6) { printStr += "^FT270,150^XGtxt3,1,1^FS"; } } printStr += "^FT32,226^XGtxt4,1,1^FS"; printStr += "^FT32,268^XGtxt5,1,1^FS"; if (label_lst[i].materialdesc.Length > 8) { printStr += "^FT165,296^XGtxt6,1,1^FS"; } printStr += "^FT32,332^XGtxt7,1,1^FS"; if (label_lst[i].invstd.Length > 8) { printStr += "^FT165,360^XGtxt8,1,1^FS"; } //printStr += "^FT32,400^XGtxt9,1,1^FS"; printStr += "^FT32,462^XGtxt10,1,1^FS"; printStr += "^FT32,522^XGtxt11,1,1^FS"; printStr += "^FT330,522^XGtxt12,1,1^FS"; printStr += "^FO10,10^GB530,530,4^FS"; printStr += "^FO10,170^GB530,0,4^FS"; //printStr += "^FT45,167^BQN,2,5"; //printStr += "^FDMA," + label_lst[i].cpoid + "^FS"; printStr += "^FT400,500^BQN,2,4"; printStr += "^FDMA," + label_lst[i].barcode + "^FS"; printStr += "^PQ1,0,1,Y^XZ"; printStr += "^XA^IDtxt1^FS^XZ"; if (label_lst[i].cvenabbname.Length > 0) { printStr += "^XA^IDtxt2^FS^XZ"; if (label_lst[i].cvenabbname.Length > 6) { printStr += "^XA^IDtxt3^FS^XZ"; } } printStr += "^XA^IDtxt4^FS^XZ"; printStr += "^XA^IDtxt5^FS^XZ"; if (label_lst[i].materialdesc.Length > 8) { printStr += "^XA^IDtxt6^FS^XZ"; } printStr += "^XA^IDtxt7^FS^XZ"; if (label_lst[i].invstd.Length > 8) { printStr += "^XA^IDtxt8^FS^XZ"; } //printStr += "^XA^IDtxt9^FS^XZ"; printStr += "^XA^IDtxt10^FS^XZ"; printStr += "^XA^IDtxt11^FS^XZ"; printStr += "^XA^IDtxt12^FS^XZ"; string xPath = "/configuration/appSettings//add[@key='Printer']"; XmlDocument doc = new XmlDocument(); string exeFileName = System.Reflection.Assembly.GetExecutingAssembly().GetName().Name; doc.Load(exeFileName + ".exe.config"); XmlNode node = doc.SelectSingleNode(xPath); RawPrinterHelper.SendStringToPrinter(node.Attributes["value"].Value.ToString(), printStr); System.Threading.Thread.Sleep(1000); } } } }
public static bool GetStockDetailListByPage(ref List <Stock_Model> modelList, Stock_Model model, ref DividPage page, ref string strError) { return(WMSWebService.service.GetStockDetailListByPage(ref modelList, model, ref page, Common_Var.CurrentUser, ref strError)); }
private void btnSearch_Click(object sender, EventArgs e) { if (dtpStartTime.Value > dtpEndTime.Value) { MessageBox.Show("开始时间大于结束时间"); return; } //if(txtProductLineNo.Text.Trim().Equals("")) //{ // MessageBox.Show("请输入产线"); // txtProductLineNo.Focus(); // return; //} //if(txtProductLineNo.Text.Trim().Length != 3) //{ // MessageBox.Show("产线必须为3位"); // txtProductLineNo.SelectAll(); // txtProductLineNo.Focus(); // return; //} WebService.QueryConditions conditions = new QueryConditions(); if (txtProductLineNo.Text.Trim().Length > 0) { conditions.ProductLineNo = txtProductLineNo.Text.Trim(); } if (txtMaterialNo.Text.Trim().Length > 0) { conditions.MaterialNo = txtMaterialNo.Text.Trim(); } if (txtMaterialDesc.Text.Trim().Length > 0) { conditions.MaterialDesc = txtMaterialDesc.Text.Trim(); } if (txtMaterialStd.Text.Trim().Length > 0) { conditions.MaterialStd = txtMaterialStd.Text.Trim(); } if (dtpStartTime.Checked) { conditions.StartTime = dtpStartTime.Value; } if (dtpEndTime.Checked) { conditions.EndTime = dtpEndTime.Value; } List <WebService.Stock_Model> modelList = null; string strError = ""; if (!WMS.Common.WMSWebService.service.GetCapacityForWMS(ref modelList, conditions, ref strError)) { MessageBox.Show("查询失败:" + strError); return; } //添加总计 Stock_Model sum_model = new Stock_Model(); foreach (Stock_Model st_model in modelList) { sum_model.ErpQty += st_model.ErpQty; sum_model.SaveQty += st_model.SaveQty; sum_model.TrayQty += st_model.TrayQty; sum_model.TotalQty += st_model.TotalQty; } sum_model.ProductLineNo = "总计"; modelList.Add(sum_model); dataGridView1.DataSource = modelList; for (int i = 0; i < dataGridView1.Columns.Count; i++) { if (dataGridView1.Columns[i].Name.Equals("ProductLineNo")) { dataGridView1.Columns[i].HeaderText = "产线"; continue; } if (dataGridView1.Columns[i].Name.Equals("MaterialNo")) { dataGridView1.Columns[i].HeaderText = "物料编码"; continue; } if (dataGridView1.Columns[i].Name.Equals("MaterialDesc")) { dataGridView1.Columns[i].HeaderText = "物料名称"; continue; } if (dataGridView1.Columns[i].Name.Equals("MaterialStd")) { dataGridView1.Columns[i].HeaderText = "规格型号"; continue; } if (dataGridView1.Columns[i].Name.Equals("ErpQty")) { dataGridView1.Columns[i].HeaderText = "已入库数量"; continue; } if (dataGridView1.Columns[i].Name.Equals("SaveQty")) { dataGridView1.Columns[i].HeaderText = "已保存未过账数量"; continue; } if (dataGridView1.Columns[i].Name.Equals("TrayQty")) { dataGridView1.Columns[i].HeaderText = "已组托未入库数量"; continue; } if (dataGridView1.Columns[i].Name.Equals("TotalQty")) { dataGridView1.Columns[i].HeaderText = "总数量"; continue; } dataGridView1.Columns[i].Visible = false; } }