From cb920f768593ea2d5c0483d4b1d7c73e5e2de0c0 Mon Sep 17 00:00:00 2001
From: 杨乐 <yang.le.192@qq.com>
Date: 星期三, 19 一月 2022 17:04:35 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
---
WarM/仓库管理/Gy_BarCodeBill_ChaiMa.cs | 259 +++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 248 insertions(+), 11 deletions(-)
diff --git "a/WarM/\344\273\223\345\272\223\347\256\241\347\220\206/Gy_BarCodeBill_ChaiMa.cs" "b/WarM/\344\273\223\345\272\223\347\256\241\347\220\206/Gy_BarCodeBill_ChaiMa.cs"
index 04b19b3..2cd9c33 100644
--- "a/WarM/\344\273\223\345\272\223\347\256\241\347\220\206/Gy_BarCodeBill_ChaiMa.cs"
+++ "b/WarM/\344\273\223\345\272\223\347\256\241\347\220\206/Gy_BarCodeBill_ChaiMa.cs"
@@ -1,4 +1,5 @@
-锘縰sing System;
+锘縰sing Pub_Class;
+using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
@@ -15,24 +16,260 @@
{
InitializeComponent();
}
+
//瀹氫箟鍒�
public const Int16 HTagCol = 0;
- public const Int16 HBarCode = 1;
- public const Int16 HQty = 2;
- public const Int16 HNum = 3;
- public const Int16 HMaterCol = 4;
- public const Int16 HMaterName = 5;
- public const Int16 HMaterMould = 6;
- public const Int16 HBatchNo = 7;
- //
- private void txtHBillNo_TextChanged(object sender, EventArgs e)
- {
+ public const Int16 HSnoCol = 1;
+ public const Int16 HInterID = 2;
+ public const Int16 HBarCode = 3;
+ public const Int16 HQty = 4;
+ public const Int16 HNum = 5;
+ public const Int16 HMaterCol = 6;
+ public const Int16 HMaterName = 7;
+ public const Int16 HMaterMould = 8;
+ public const Int16 HBatchNo =9;
+ //=======================================================================
+ public const Int16 HTagCol2 = 0;
+ public const Int16 HSnoCol2 = 1;
+ public const Int16 HInterID2 = 2;
+ public const Int16 HBarCode2 = 3;
+ public const Int16 HQty2 = 4;
+ public const Int16 HNum2 = 5;
+ public const Int16 HMaterCol2 = 6;
+ public const Int16 HMaterName2 = 7;
+ public const Int16 HMaterMould2 = 8;
+ public const Int16 HBatchNo2 = 9;
+ public const string ModName = ""; //鍗曟嵁绫诲瀷
+ public const string ModCaption = "鏉＄爜鎷嗙爜"; //鍗曟嵁鍚嶇О
+ public const string ModRightName = "Gy_BarCodeBill_ChaiMa";
+ ClsGridViewSum oSumGrid_Mater = new ClsGridViewSum();
+ ClsGridViewSum oSumGrid_Pay = new ClsGridViewSum();
+ public DAL.ClsGy_BarCodeBill_ChaiMa BillNew = new DAL.ClsGy_BarCodeBill_ChaiMa(); //瀵瑰簲鍗曟嵁绫�
+ public DAL.ClsGy_BarCodeBill_ChaiMa BillOld = new DAL.ClsGy_BarCodeBill_ChaiMa(); //瀵瑰簲鍗曟嵁绫�
+
+ //娓呯┖鐣岄潰
+ public void Sub_ClearBill()
+ {
+ DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp);
+ //
+ txtHMaker.Text = DBUtility.ClsPub.CurUserName;
+ initGrid();
+ initGrid_Pay();
}
+ #region 绐椾綋澶勭悊鏂规硶
+
+ //鍒濆鍖栭〉绛�1
+ private void initGrid()
+ {
+ grdMain.ColumnCount = 9; //鎬诲垪鏁�
+ DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name + "1");
+ grdMain.Columns[HSnoCol].HeaderText = "搴忓彿";
+ grdMain.Columns[HInterID].HeaderText = "HInterID";
+ grdMain.Columns[HBarCode].HeaderText = "鏉＄爜缂栧彿";
+ grdMain.Columns[HQty].HeaderText = "鏉＄爜鏁伴噺";
+ grdMain.Columns[HNum].HeaderText = "鎷嗗垎鏁伴噺";
+ grdMain.Columns[HMaterCol].HeaderText = "鐗╂枡浠ｇ爜";
+ grdMain.Columns[HMaterName].HeaderText = "鐗╂枡鍚嶇О";
+ grdMain.Columns[HMaterMould].HeaderText = "瑙勬牸鍨嬪彿";
+ grdMain.Columns[HBatchNo].HeaderText = "鎵瑰彿";
+ //=============================================================================
+
+ ////闅愯棌鍒�
+ grdMain.Columns[HTagCol].Visible = false;
+ grdMain.Columns[HInterID].Visible = false;
+ //璁剧疆鍙紪杈戝垪
+ string sAllowCol = HNum.ToString();
+ //璁剧疆鍚堣鍒�
+ string sTotalCol = HTagCol.ToString() + "0";
+ //鏍煎紡鍖栫綉鏍�
+ DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid_Mater);
+ }
+
+ //鍒濆鍖栭〉绛�2
+ private void initGrid_Pay()
+ {
+ grdMain.ColumnCount = 9; //鎬诲垪鏁�
+ DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name + "1");
+ grdMain.Columns[HSnoCol2].HeaderText = "搴忓彿";
+ grdMain.Columns[HInterID2].HeaderText = "HInterID";
+ grdMain.Columns[HBarCode2].HeaderText = "鏉＄爜缂栧彿";
+ grdMain.Columns[HQty2].HeaderText = "鏉＄爜鏁伴噺";
+ grdMain.Columns[HNum2].HeaderText = "鎷嗗垎鏁伴噺";
+ grdMain.Columns[HMaterCol2].HeaderText = "鐗╂枡浠ｇ爜";
+ grdMain.Columns[HMaterName2].HeaderText = "鐗╂枡鍚嶇О";
+ grdMain.Columns[HMaterMould2].HeaderText = "瑙勬牸鍨嬪彿";
+ grdMain.Columns[HBatchNo2].HeaderText = "鎵瑰彿";
+ //=============================================================================
+ ////闅愯棌鍒�
+ grdMain.Columns[HTagCol].Visible = false;
+ grdMain.Columns[HInterID].Visible = false;
+ //璁剧疆鍙紪杈戝垪
+ string sAllowCol = HNum2.ToString();
+ //璁剧疆鍚堣鍒�
+ string sTotalCol = HTagCol2.ToString() + "0";
+ //鏍煎紡鍖栫綉鏍�
+ DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid_Pay);
+ }
+
+ // 鍩烘湰涓嶅彉
+
+ private void grdMain_RowHeadersWidthChanged(object sender, EventArgs e)
+ {
+ DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid_Mater);
+ }
+
+ #endregion
+
+ //椤甸潰鍔犺浇
private void Gy_BarCodeBill_ChaiMa_Load(object sender, EventArgs e)
{
+ txtHBillNo.Text = "";
+ txtNum.Text = "";
+ txtHMaker.Text = DBUtility.ClsPub.CurUserName;
+ }
+ //鏁版嵁楠岃瘉
+ private bool Sub_AllowSave()
+ {
+ int i = 0;
+ while (grdMain_Pay.Rows[i].Cells[HSnoCol].Value.ToString() != "")
+ {
+ if (grdMain_Pay.Rows[i].Cells[HNum2].Value.ToString() == "")
+ {
+ MessageBox.Show("璇峰皢琛ㄦ牸鎷嗗垎鏁伴噺濉啓瀹屾暣", "鎻愮ず");
+ return false;
+ }
+ }
+ return true;
+ }
+ private bool SeverDate()
+ {
+ Int32 i;
+ bool bResult;
+ BillNew = new DAL.ClsGy_BarCodeBill_ChaiMa();
+
+ if (!Sub_AllowSave())//鍗曟嵁瀹屾暣鎬у垽鏂�
+ return false;
+
+ //鍒ゆ柇浼氳鏈熸槸鍚﹀悎鐞�
+ string s = "";
+ int sYear = 0;
+ int sPeriod = 0;
+ string HBillNo = txtHBillNo.Text;
+ DataSet Ds;
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+ Ds = oCn.RunProcReturn("select top 1* from h_v_Gy_BarCodeBill_ChaiMa where HBarCode='" + HBillNo + "'", "h_v_Gy_BarCodeBill_ChaiMa");
+
+ for (i = 0; i <= grdMain_Pay.RowCount - 1; i++)
+ {
+ if (ClsPub.isLong(grdMain_Pay.Rows[i].Cells[HBarCode].Value) != 0)
+ {
+
+ Model.ClsGy_BarCodeEdit_Model model = new Model.ClsGy_BarCodeEdit_Model();
+ //鍥哄畾璧嬪��========================================
+ model.HEntryID = i + 1;
+ model.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString());
+ model.HBarCode = DBUtility.ClsPub.isStrNull(grdMain_Pay.Rows[i].Cells[HBarCode].Value);
+ model.HQty = DBUtility.ClsPub.isLong(grdMain_Pay.Rows[i].Cells[HQty].Value);
+ model.HPieceQty = DBUtility.ClsPub.isInt(grdMain_Pay.Rows[i].Cells[HNum2].Value);
+ model.HBatchNo = DBUtility.ClsPub.isStrNull(grdMain_Pay.Rows[i].Cells[HBatchNo].Value);
+ model.HMaterID = DBUtility.ClsPub.isLong(grdMain_Pay.Rows[i].Cells[HMaterCol].Value);
+ model.HUnitID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HUnitID"].ToString());
+ model.HSupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSupID"].ToString());
+ model.HDeptID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HDeptID"].ToString());
+ model.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HEmpID"].ToString());
+ model.HBarCodeType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBarCodeType"].ToString());
+ model.HItemSubID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HItemSubID"].ToString());
+ model.HGroupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HGroupID"].ToString());
+ model.HSourceInterID= DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceInterID"].ToString());
+ model.HSourceEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceEntryID"].ToString());
+ model.HSourceBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSourceBillNo"].ToString());
+ model.HSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSourceBillType"].ToString());
+ model.HUseFlag = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HUseFlag"].ToString());
+ model.HStopflag = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HStopflag"].ToString());
+ model.HInitQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HInitQty"].ToString());
+ model.HSourceID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInitQty"].ToString());
+ model.HCusID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCusID"].ToString());
+ model.HSTOCKORGID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSTOCKORGID"].ToString());
+ model.HOWNERID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HOWNERID"].ToString());
+ model.HBarCodeDate= DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HBarCodeDate"].ToString());
+ model.HInnerBillNo= DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HInnerBillNo"].ToString());
+ model.HMZ= DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HMZ"].ToString());
+
+ model.HMakeDate = DateTime.Now;
+ model.HMaker = ClsPub.CurUserName;
+
+ if (model.HPieceQty <= 0|| model.HPieceQty.ToString() =="")
+ {
+ MessageBox.Show("绗�" + ClsPub.isStrNull(i + 1) + "琛岋紝鎷嗗垎鏁伴噺蹇呴』澶т簬0锛�");
+ return false;
+ }
+ BillNew.DetailColl_Mater.Add(model);
+ }
+ }
+ return true;
+ //淇濆瓨
+ bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
+ //鎻愮ず
+ if (bResult == true)
+ {
+ MessageBox.Show("鍗曟嵁瀛樼洏瀹屾瘯!鍗曟嵁鍙�:" + this.txtHBillNo.Text.Trim(), "鎻愮ず");
+ return true;
+ }
+ else
+ {
+ MessageBox.Show("淇濆瓨澶辫触!鍘熷洜:" + ClsPub.sExeReturnInfo, "鎻愮ず");
+ return false;
+ }
+ }
+ //鐢熸垚鎸夐挳
+ private void xz_Click(object sender, EventArgs e)
+ {
+ this.SeverDate();
+ }
+ //纭畾鎸夐挳
+ private void button1_Click(object sender, EventArgs e)
+ {
+ if (DBUtility.ClsPub.isStrNull(txtHBillNo.Text) != ""|| DBUtility.ClsPub.isStrNull(txtNum.Text) != "")
+ {
+ string HBillNo = txtHBillNo.Text;
+ int HNum = int.Parse(txtNum.Text);
+ DataSet Ds;
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+ Ds = oCn.RunProcReturn("select top 1* from h_v_Gy_BarCodeBill_ChaiMa where HBarCode='" + HBillNo + "'", "h_v_Gy_BarCodeBill_ChaiMa");
+ grdMain.Rows[0].Cells[HTagCol].Value = "*";
+ grdMain.Rows[0].Cells[HInterID].Value = Ds.Tables[0].Rows[0]["HInterID"].ToString();
+ grdMain.Rows[0].Cells[HBarCode].Value = Ds.Tables[0].Rows[0]["鏉＄爜缂栧彿"].ToString();
+ grdMain.Rows[0].Cells[HQty].Value = Ds.Tables[0].Rows[0]["鏉＄爜鏁伴噺"].ToString();
+ grdMain.Rows[0].Cells[HNum].Value = 0;
+ grdMain.Rows[0].Cells[HMaterCol].Value = Ds.Tables[0].Rows[0]["鐗╂枡浠ｇ爜"].ToString();
+ grdMain.Rows[0].Cells[HMaterName].Value = Ds.Tables[0].Rows[0]["鐗╂枡鍚嶇О"].ToString();
+ grdMain.Rows[0].Cells[HMaterMould].Value = Ds.Tables[0].Rows[0]["瑙勬牸鍨嬪彿"].ToString();
+ grdMain.Rows[0].Cells[HBatchNo].Value = Ds.Tables[0].Rows[0]["鎵瑰彿"].ToString();
+ for (int i = 0; i < HNum; i++)
+ {
+ int Code = 65 + i;
+ System.Text.ASCIIEncoding asciiEncoding = new System.Text.ASCIIEncoding();
+ byte[] byteArray = new byte[] { (byte)Code };
+ string A = asciiEncoding.GetString(byteArray);
+ string No = Ds.Tables[0].Rows[0]["鏉＄爜缂栧彿"].ToString();
+ grdMain_Pay.Rows[i].Cells[HTagCol2].Value = "*";
+ grdMain_Pay.Rows[0].Cells[HInterID2].Value = Ds.Tables[0].Rows[0]["HInterID"].ToString();
+ grdMain_Pay.Rows[0].Cells[HBarCode2].Value = No + A;
+ grdMain_Pay.Rows[0].Cells[HQty2].Value = Ds.Tables[0].Rows[0]["鏉＄爜鏁伴噺"].ToString();
+ grdMain_Pay.Rows[0].Cells[HMaterCol2].Value = Ds.Tables[0].Rows[0]["鐗╂枡浠ｇ爜"].ToString();
+ grdMain_Pay.Rows[0].Cells[HMaterName2].Value = Ds.Tables[0].Rows[0]["鐗╂枡鍚嶇О"].ToString();
+ grdMain_Pay.Rows[0].Cells[HMaterMould2].Value = Ds.Tables[0].Rows[0]["瑙勬牸鍨嬪彿"].ToString();
+ grdMain_Pay.Rows[0].Cells[HBatchNo2].Value = Ds.Tables[0].Rows[0]["鎵瑰彿"].ToString();
+ }
+ }
+ else
+ {
+ MessageBox.Show("璇峰～鍐欐潯鐮佺紪鍙峰拰鎷嗗垎鏉℃暟", "鎻愮ず");
+ }
+
}
}
}
--
Gitblit v1.9.1