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;
}
}
