From aa9075b4c1e51d90f516ec7590a5e915ac73c66c Mon Sep 17 00:00:00 2001
From: YL <YL@LAPTOP-SE03PLUR>
Date: 星期四, 25 十一月 2021 20:01:36 +0800
Subject: [PATCH] nothing
---
WarM/条码打印/Sc_ICMOToBarCode.cs | 711 +++++++++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 643 insertions(+), 68 deletions(-)
diff --git "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs" "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs"
index 4d1622c..49e50fe 100644
--- "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs"
+++ "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Sc_ICMOToBarCode.cs"
@@ -28,15 +28,19 @@
public const string ModRightNameCheck = ModRightName + "_Check";
public const string ModRightNameClose = ModRightName + "_Close";
public const string ModRightNameDelete = ModRightName + "_Delete";
+ public DAL.ClsGy_BarCodeBill_Ctl oBar = new DAL.ClsGy_BarCodeBill_Ctl();
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
//DAL.ClsGy_ICBomBill oBill = new DAL.ClsGy_ICBomBill();
//public Gy_ICBomBill oFrm;
public int selectRow = 0;
public int selectRow2 = 0;
public string sDlgWhere = ""; //澶栫獥浣撻�掑叆
+ public DBUtility.ClsPub.Enum_BillStatus BillStatus;
+ public Int64 HInterID = 0;
//
private void initGrid()
{
- DBUtility.Xt_BaseBillFun.initGridList(grdMain,this.Name);
+ DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
}
//
@@ -45,12 +49,56 @@
ClsCN SubCn = new ClsCN();
DataSet DSet;
string sSql = "";
+ string sFastSQL = "";
+ //鐢熶骇璁㈠崟鍙�
+ //if (txtHICMOBillNo.Text.Trim() != "")
+ //{
+ // sFastSQL = sFastSQL + " and HICMOBillNo like '%" + txtHICMOBillNo.Text + "%'";
+ //}
+ string HICMOBillNo = "";
+ HICMOBillNo = txtHICMOBillNo.Text.Trim().ToString();
+ //鐗╂枡
+ //if (txtHMaterID.Text.Trim() != "")
+ //{
+ // sFastSQL = sFastSQL + " and HMaterName like '%" + txtHMaterID.Text + "%'";
+ //}
+ string HMaterName = "";
+ HMaterName = txtHMaterID.Text.Trim().ToString();
+ //鏈哄彴
+ //if (txtHSourceID.Text.Trim() != "")
+ //{
+ // sFastSQL = sFastSQL + " and HSourceName like '%" + txtHSourceID.Text + "%'";
+ //}
+ string HSourceName = "";
+ HSourceName = txtHSourceID.Text.Trim().ToString();
+ //鑱屽憳
+ string HEmpName = "";
+ HEmpName = txtHEmpID.Text.Trim().ToString();
+ //鍒ゆ柇寮�濮嬫棩鏈�
+ //if (dtpHBeginDate.Checked)
+ //{
+ // sFastSQL = sFastSQL + " and 鏃ユ湡>='" + dtpHBeginDate.Value.ToShortDateString() + "'";
+ //}
+ string HBeginDate = "";
+ HBeginDate = dtpHBeginDate.Value.ToShortDateString();
+
+ //鍒ゆ柇缁撴潫鏃ユ湡
+ //if (dtpHEndDate.Checked)
+ //{
+ // sFastSQL = sFastSQL + " and 鏃ユ湡<='" + dtpHEndDate.Value.ToShortDateString() + "'";
+ //}
+ string HEndDate = "";
+ HEndDate = dtpHEndDate.Value.ToShortDateString();
+ //if (sFastSQL.Trim() == "")
+ //{
+ // MessageBox.Show("娌℃湁杈撳叆鏉′欢!");
+ // return;
+ //}
+
//杩囨护鏉′欢
- if (frmCondition.SqlStr.Trim().Length == 0)
- return;
- sSql = "Select * from " + ViewName + " Where 1=1 " + sDlgWhere + " order by HICMOBillNo asc";
+
//
- DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
+ DSet = SubCn.RunProcReturn("exec h_p_KSTMSC '" + HICMOBillNo + "' , '" + HMaterName + "' , '" + HSourceName + "' ,'" + HEmpName + "' ,'" + HBeginDate + "', '" + HEndDate + "'", "h_p_KSTMSC", ref DBUtility.ClsPub.sExeReturnInfo);
//鐢熸垚棣栬鏍囬
if (DSet == null)
{
@@ -59,15 +107,20 @@
}
//
grdMain.DataSource = DSet.Tables[0].DefaultView;
+
//鏍囧噯瑁呯
- for (int i = 0; i < grdMain.SelectedRows.Count; i++)
- {
- txtHMiniQty.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[Fun_GetCol("HMiniQty")].Value);
- }
+ //for (int i = 0; i < grdMain.SelectedRows.Count; i++)
+ //{
+ // txtHMiniQty.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[Fun_GetCol("HMiniQty")].Value);
+ // if (txtHMiniQty.Text.Trim() != "")
+ // {
+ // txtHMiniQty.Enabled = false;
+ // }
+ //}
//鍐荤粨
- int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
- string s = frmCondition.cmbHComplete.Text;
- DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s,FrCol);
+ //int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
+ //string s = frmCondition.cmbHComplete.Text;
+ //DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s,FrCol);
//鐢荤嚎
GraphLine();
@@ -132,11 +185,16 @@
{
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
}
+
+ private Int32 Fun_GetColList(string sCol)
+ {
+ return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdList);
+ }
//
private void Sc_ICMOToBarCode_Load(object sender, EventArgs e)
{
//
- frmCondition = new frmBillQueryCondition_New();
+ //frmCondition = new frmBillQueryCondition_New();
this.Text = ModCaption;
//lblCaption.Text = ModCaption;
initGrid();
@@ -149,21 +207,21 @@
private void cx_Click(object sender, EventArgs e)
{
- frmCondition = new frmBillQueryCondition_New();
- SetCondition(frmCondition, ViewName, this.Name);
- frmCondition.ShowDialog();
- if (frmCondition.Tag.ToString() == "OK")
- {
- Display();
- }
+ //frmCondition = new frmBillQueryCondition_New();
+ //SetCondition(frmCondition, ViewName, this.Name);
+ //frmCondition.ShowDialog();
+ //if (frmCondition.Tag.ToString() == "OK")
+ //{
+ // Display();
+ //}
}
- public void SetCondition(frmBillQueryCondition_New frmCondition, string ViewName, string Name)
- {
- frmCondition.Tag = "";
- frmCondition.ViewName = ViewName;
- frmCondition.ModName = Name;
- }
+ //public void SetCondition(frmBillQueryCondition_New frmCondition, string ViewName, string Name)
+ //{
+ // frmCondition.Tag = "";
+ // frmCondition.ViewName = ViewName;
+ // frmCondition.ModName = Name;
+ //}
private void xz_Click(object sender, EventArgs e)
{
@@ -257,14 +315,14 @@
private void timer2_Tick(object sender, EventArgs e)
{
- timer2.Enabled = false;
- frmCondition = new frmBillQueryCondition_New();
- SetCondition(frmCondition, ViewName, this.Name);
- frmCondition.ShowDialog();
- if (frmCondition.Tag.ToString() == "OK")
- {
- timer1.Enabled = true;
- }
+ //timer2.Enabled = false;
+ //frmCondition = new frmBillQueryCondition_New();
+ //SetCondition(frmCondition, ViewName, this.Name);
+ //frmCondition.ShowDialog();
+ //if (frmCondition.Tag.ToString() == "OK")
+ //{
+ // timer1.Enabled = true;
+ //}
}
@@ -282,11 +340,11 @@
//
private void GraphLine()
{
- int MainIDCol = Fun_GetCol("hmainid");
- int SubIDCol = Fun_GetCol("hsubid");
- string s = frmCondition.cmbHComplete.Text;
- long n=0;
- DBUtility.Xt_BaseBillFun.GraphLine(grdMain, MainIDCol, SubIDCol, s,ref n);
+ //int MainIDCol = Fun_GetCol("hmainid");
+ //int SubIDCol = Fun_GetCol("hsubid");
+ //string s = frmCondition.cmbHComplete.Text;
+ //long n=0;
+ //DBUtility.Xt_BaseBillFun.GraphLine(grdMain, MainIDCol, SubIDCol, s,ref n);
//鏄剧ず
//lbldj.Text = "鏌ヨ鍑� " + n.ToString() + " 寮犲崟鎹�";
//lbljl.Text = "鍏辨湁 " + grdMain.RowCount.ToString() + " 鏉¤褰�";
@@ -693,40 +751,557 @@
private void cmdHSaveBill_Click(object sender, EventArgs e)
{
- string sFastSQL = "";
- //鐢熶骇璁㈠崟鍙�
- if (txtHICMOBillNo.Text.Trim() != "")
+
+ Display();
+ }
+
+ private void button4_Click(object sender, EventArgs e)
+ {
+ HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
+ string HMaterNumber = "";
+ string HBatchNo = "";
+ string HDate = "";
+ string HYear = "";
+ string HPeriod = "";
+ string HDay = "";
+ string HTMNumber = "";
+ string HOrgNumber = "";
+ DataSet Ds;
+ int LSH = 0; //娴佹按鍙�
+ string LSH2 = ""; //娴佹按鍙疯浆鎹㈡垚瀛楃
+ double HSumQty = 0; //浜у搧鏁伴噺
+ double HMinQty = 0; //鏈�灏忓寘瑁呮暟
+ double HBQty = 0; //绠辨暟
+ int k = 0;
+ int n = 0; //鍚屼竴鎵圭敓鎴愭潯鐮佷腑鐨勭鍑犳潯
+ string WeiShu = ""; //灏炬暟
+ int LSHlen = 6; //娴佹按鍙烽暱搴�
+ string TM = ""; //鏉＄爜
+ for (int j = 0; j < grdMain.SelectedRows.Count; j++)
{
- sFastSQL = sFastSQL + " and HICMOBillNo like '%" + txtHICMOBillNo.Text + "%'";
+ HMaterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[j].Index].Cells[Fun_GetCol("鐗╂枡浠ｇ爜")].Value);
+ HBatchNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[j].Index].Cells[Fun_GetCol("鎵规")].Value);
+ HDate = DateTime.Now.ToShortDateString();
+ HYear = ClsPub.isDate(HDate).Year.ToString().Substring(2, 2);
+ HPeriod = "0" + ClsPub.isDate(HDate).Month.ToString();
+ HPeriod = HPeriod.Substring(HPeriod.Length - 2, 2);
+ HDay = "0" + ClsPub.isDate(HDate).Day.ToString();
+ HDay = HDay.Substring(HDay.Length - 2, 2);
+ HOrgNumber = ClsPub.HOrgNumber;
+ //绠辨暟鍒�=鏁伴噺/鏈�灏忓寘瑁呮暟
+ //double sMoney = 0;
+ //if ((DBUtility.ClsPub.isLong(grdMain.SelectedRows[j].Cells[Fun_GetCol("HMiniQty")].Value) == 0))
+ //{
+ // sMoney = 0;
+ //}
+ //else
+ //{
+ // sMoney = ClsPub.isDoule(grdMain.SelectedRows[j].Cells[Fun_GetCol("HQty")].Value) / ClsPub.isDoule(grdMain.SelectedRows[j].Cells[Fun_GetCol("HMiniQty")].Value);
+ //}
+ //sMoney = Math.Ceiling(sMoney);
+ //grdMain.SelectedRows[j].Cells[Fun_GetCol("HBQty")].Value = sMoney;
+
+
+ HBQty = HBQty + ClsPub.isInt(txtHBQty.Text);
+ HMinQty = ClsPub.isDoule(txtHMiniQty.Text);
+ HSumQty = ClsPub.isDoule(txtHICMOQty.Text);
+
+
+ if (cmbHBarCodeType.Text == "鍞竴鏉＄爜")
+ {
+ HTMNumber = HOrgNumber + HMaterNumber + HYear + HPeriod + HDay;
+ Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HTMNumber + "'", "h_p_WMS_GetMaxNo"); //鑾峰彇鏈�澶ф祦姘村彿
+ LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
+ }
+ else if (cmbHBarCodeType.Text == "鎵规鏉＄爜")
+ {
+ TM = HOrgNumber + HMaterNumber + HBatchNo;
+ }
+ n = 0;
+ for (int i = k; i < HBQty; i++)
+ {
+ if (HSumQty - HMinQty > 0)
+ {
+ WeiShu = "";
+ HSumQty = HSumQty - HMinQty;
+ }
+ else
+ {
+ if (HSumQty == HMinQty)
+ {
+ WeiShu = "";
+ }
+ else
+ {
+ WeiShu = "灏炬暟";
+ }
+ HMinQty = HSumQty;
+ }
+ //
+ LSH = LSH + 1;
+ LSH2 = LSH.ToString();
+ while (LSH2.Length < LSHlen) //濡傛灉娴佹按鍙峰皬浜�6浣嶆暟鍓嶉潰琛�0
+ {
+ LSH2 = "0" + LSH2;
+ }
+ if (cmbHBarCodeType.Text == "鍞竴鏉＄爜")
+ {
+ //鏉＄爜缂栧彿 = 鏉＄爜鍓嶇紑 + 娴佹按鍙�
+ TM = HTMNumber + LSH2;
+ }
+ if (TM.Trim() == "")
+ {
+ MessageBox.Show("鏉″舰鐮佷笉鑳戒负绌猴紝涓嶈兘鐢熸垚鏉＄爜锛�");
+ return;
+ }
+ string HWei = ""; //灏炬暟
+ string HBarCode = "";
+ string HBarCodeType = "";
+ Int64 HMaterID = 0;
+ Int64 HAuxPropID = 0;
+ Int64 HUnitID = 0;
+ double HQty2 = 0;
+ string HBatchNo2 = "";
+ Int64 HSupID = 0;
+ Int64 HGroupID = 0;
+ int HPrintQty = 0;
+ Int64 HSourceInterID = 0;
+ Int64 HSourceEntryID = 0;
+ string HSourceBillNo = "";
+ string HSourceBillType = "";
+ Int64 HBarcodeNo = 0; //鎵樺彿
+ Int64 HBarcodeQtys = 0; //鎬绘墭鏁�
+ Int64 HDeptID = 0;
+ Int64 HWhID = 0;
+ Int64 HSPID = 0;
+ string HRemark = "";
+ string HMaterName = "";
+ string HMaterModel = "";
+ string HPinfan = "";
+ string HMTONo = "";
+ Int64 HCusID = 0;
+ string HCusType = "";
+ DateTime HEndDate;
+ string HWorkLineName = "";
+ string HSeOrderBillNo = "";
+ string HInnerBillNo = "";
+ try
+ {
+ oCn.BeginTran();
+ HWei = WeiShu;
+ HBarCode = TM;
+ HBarCodeType = ClsPub.isStrNull(cmbHBarCodeType.Text);
+ HMaterID = ClsPub.isLong(grdMain.SelectedRows[j].Cells[Fun_GetCol("HMaterID")].Value);
+ HAuxPropID = 0;
+ HUnitID = 0;
+ HQty2 = HMinQty;
+ HBatchNo2 = ClsPub.isStrNull(grdMain.SelectedRows[j].Cells[Fun_GetCol("鎵规")].Value);
+ HSourceInterID = 0;
+ HSourceEntryID = 0;
+ HSourceBillNo = ClsPub.isStrNull(grdMain.SelectedRows[j].Cells[Fun_GetCol("鐢熶骇璁㈠崟鍙�")].Value);
+ HSourceBillType = "3710";
+ HBarcodeQtys = 0;
+ HBarcodeNo = 0;
+ HSupID = 0;
+ HDeptID = 0;
+ HWhID = 0;
+ HSPID = 0;
+ HRemark = "";
+ HMaterName = ClsPub.isStrNull(grdMain.SelectedRows[j].Cells[Fun_GetCol("鐗╂枡鍚嶇О")].Value);
+ HMaterModel = ClsPub.isStrNull(grdMain.SelectedRows[j].Cells[Fun_GetCol("瑙勬牸鍨嬪彿")].Value);
+ HPinfan = "";
+ HMTONo = "";
+ HCusID = 0;
+ HCusType = "";
+ HEndDate = ClsPub.isDate(grdMain.SelectedRows[j].Cells[Fun_GetCol("鏃ユ湡")].Value);
+ HWorkLineName = "";
+ HSeOrderBillNo = "";
+ HInnerBillNo = "";
+ oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
+ ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
+ ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
+ ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
+ ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate " +
+ ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID " +
+ ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo " +
+ ") values ("
+ + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()
+ + ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString()
+ + ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HWei + "'"
+ + ", " + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + "," + HWhID.ToString() + "," + HSPID.ToString() + ",'" + HRemark + "'"
+ + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HEndDate.ToShortDateString() + "','" + HWorkLineName + "','" + HDate + "'"
+ + ", " + ClsPub.HOrgID.ToString() + "," + ClsPub.HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString()
+ + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "')");
+ oCn.Commit();
+ MessageBox.Show("鏉＄爜鐢熸垚瀹屾瘯锛�");
+ //grdSub.RowCount = 0;
+ DisplayTM();
+ }
+
+ catch (Exception e1)
+ {
+ oCn.RollBack();
+ MessageBox.Show("鏉＄爜鐢熸垚澶辫触锛�" + e1.Message);
+ }
+
+ }
}
- //鐗╂枡
- if (txtHMaterID.Text.Trim() != "")
+ }
+
+
+ private void DisplayTM()
+ {
+ DataSet DSet = oCn.RunProcReturn("select * from h_v_IF_BarCodeBillList Where HinterID=" + HInterID.ToString() + " order by HItemID", "h_v_IF_BarCodeBillList", ref DBUtility.ClsPub.sExeReturnInfo);
+ //鐢熸垚棣栬鏍囬
+ if (DSet == null)
{
- sFastSQL = sFastSQL + " and HMaterID like '%" + txtHMaterID.Text + "%'";
- }
- //鏈哄彴
- if (txtHSourceID.Text.Trim() != "")
- {
- sFastSQL = sFastSQL + " and HSourceID like '%" + txtHSourceID.Text + "%'";
- }
- //鍒ゆ柇寮�濮嬫棩鏈�
- if (dtpHBeginDate.Checked)
- {
- sFastSQL = sFastSQL + " and 鏃ユ湡>='" + dtpHBeginDate.Value.ToShortDateString() + "'";
- }
- //鍒ゆ柇缁撴潫鏃ユ湡
- if (dtpHEndDate.Checked)
- {
- sFastSQL = sFastSQL + " and 鏃ユ湡<='" + dtpHEndDate.Value.ToShortDateString() + "'";
- }
- if (sFastSQL.Trim() == "")
- {
- MessageBox.Show("娌℃湁杈撳叆鏉′欢!");
+ MessageBox.Show("娌℃湁杩斿洖浠讳綍缁撴灉,鏉＄爜涓嶅瓨鍦紒" + DBUtility.ClsPub.sExeReturnInfo);
return;
}
- sDlgWhere = sFastSQL;
- Display();
- sDlgWhere = "";
+ //
+ grdList.DataSource = DSet.Tables[0].DefaultView;
+ //鍐荤粨
+ int FrCol = 0;
+ string s = "鏄�";
+ DBUtility.Xt_BaseBillFun.DisplayGrid(grdList, this.Name + "grdList", s, FrCol);
+ //鐢荤嚎
+ //GraphLine();
+ //
+ }
+
+ //private void button5_Click(object sender, EventArgs e)
+ //{
+ // //鍒ゆ柇鏄惁宸茬粡鐢熸垚鏉＄爜
+ // for (int j = 0; j < grdMain.SelectedRows.Count; j++)
+ // {
+ // if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[j].Cells[Fun_GetCol("HBarCode")].Value) == "")
+ // {
+ // MessageBox.Show("鏉＄爜鏈敓鎴愶紝璇峰厛鐢熸垚鏉＄爜鍚庡啀棰勮锛�");
+ // return;
+ // }
+
+ // //鎵撳嵃鍓嶅垽鏂潯鐮佹槸鍚﹀凡鎵撳嵃杩�
+ // if (ReportPrintBegin())
+ // {
+ // return;
+ // }
+
+ // //閫夋嫨鎵撳嵃妯℃澘
+ // BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
+ // oFrm.sBillName = ModName;
+ // oFrm.sBillModel = ModCaption;
+ // oFrm.ShowDialog();
+ // if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
+ // {
+ // Sub_SetReport(oFrm.sOpenTmp);
+ // Report.PrintPreview(false);
+ // Thread.Sleep(1000);
+ // }
+ // }
+ //}
+
+
+ //鎵撳嵃鍓嶅垽鏂潯鐮佹槸鍚﹀凡鎵撳嵃杩�
+ //private bool ReportPrintBegin()
+ //{
+ // string sRelQty = "";
+
+ // if (oBar.Set_BPrintQty(DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[j].Cells[Fun_GetCol("HBarCode")].Value), ref sRelQty))
+ // {
+ // MessageBox.Show("鏉＄爜宸茬粡鎵撳嵃杩囷紝涓嶅彲閲嶅鎵撳嵃锛�");
+ // return true;
+ // }
+ // else
+ // {
+ // return false;
+ // }
+ //}
+
+ private void button1_Click(object sender, EventArgs e)
+ {
+ DAL.ClsGy_BarCodeBill_Ctl oBar = new DAL.ClsGy_BarCodeBill_Ctl();
+ //鎵撳嵃鍓嶅垽鏂潯鐮佹槸鍚﹀凡鎵撳嵃杩�
+ string sBarCode = "";
+ string sRelQty = "";
+ for (int i = 0; i < grdSub.SelectedRows.Count; i++)
+ {
+ sBarCode = sBarCode + "," + DBUtility.ClsPub.isStrNull(grdSub.Rows[grdSub.SelectedRows[i].Index].Cells[Fun_GetCol("HBarcode")].Value);
+ }
+ //if (oBar.Set_BPrintQty(sBarCode.Substring(1), ref sRelQty))
+ //{
+ // MessageBox.Show(sRelQty);
+ // return;
+ //}
+
+ //閫夋嫨鎵撳嵃妯℃澘
+ BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
+ //DAL.ClsGy_BarCodeBill_Ctl oBar = new DAL.ClsGy_BarCodeBill_Ctl();
+ oFrm.sBillName = ModName;
+ oFrm.sBillModel = ModCaption;
+ oFrm.ShowDialog();
+ if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
+ {
+ Sub_SetReport(oFrm.sOpenTmp);
+ Report.Print(false);
+ //oBar.Set_PrintQty(DBUtility.ClsPub.isStrNull(grdMain.Rows[CurRows].Cells[Fun_GetCol("鏉＄爜缂栧彿")].Value));
+ Thread.Sleep(1000);
+ }
+
+ //鎵归噺鏇存柊鏉＄爜鎵撳嵃娆℃暟
+ oBar.Set_EPrintQty(sBarCode.Substring(1));
+ }
+
+ private void cmdHSaveBill1_Click(object sender, EventArgs e)
+ {
+ Display1();
+ }
+
+ private void Display1()
+ {
+ ClsCN SubCn = new ClsCN();
+ DataSet DSet;
+ string sSql = "";
+ string sFastSQL = "";
+ //鐢熶骇璁㈠崟鍙�
+ //if (txtHICMOBillNo.Text.Trim() != "")
+ //{
+ // sFastSQL = sFastSQL + " and HICMOBillNo like '%" + txtHICMOBillNo.Text + "%'";
+ //}
+ string HICMOBillNo = "";
+ HICMOBillNo = txtHICMOBillNo1.Text.Trim().ToString();
+ //鐗╂枡
+ //if (txtHMaterID.Text.Trim() != "")
+ //{
+ // sFastSQL = sFastSQL + " and HMaterName like '%" + txtHMaterID.Text + "%'";
+ //}
+ string HMaterName = "";
+ HMaterName = txtHMaterID1.Text.Trim().ToString();
+ //鍒ゆ柇寮�濮嬫棩鏈�
+ //if (dtpHBeginDate.Checked)
+ //{
+ // sFastSQL = sFastSQL + " and 鏃ユ湡>='" + dtpHBeginDate.Value.ToShortDateString() + "'";
+ //}
+ string HBeginDate = "";
+ HBeginDate = dtpHBeginDate1.Value.ToShortDateString();
+
+ //鍒ゆ柇缁撴潫鏃ユ湡
+ //if (dtpHEndDate.Checked)
+ //{
+ // sFastSQL = sFastSQL + " and 鏃ユ湡<='" + dtpHEndDate.Value.ToShortDateString() + "'";
+ //}
+ string HEndDate = "";
+ HEndDate = dtpHEndDate1.Value.ToShortDateString();
+ //if (sFastSQL.Trim() == "")
+ //{
+ // MessageBox.Show("娌℃湁杈撳叆鏉′欢!");
+ // return;
+ //}
+
+ //杩囨护鏉′欢
+
+ //
+ DSet = SubCn.RunProcReturn("exec h_p_KSTMCX '" + HICMOBillNo + "' , '" + HMaterName + "' ,'" + HBeginDate + "', '" + HEndDate + "'", "h_p_KSTMCX", ref DBUtility.ClsPub.sExeReturnInfo);
+ //鐢熸垚棣栬鏍囬
+ if (DSet == null)
+ {
+ MessageBox.Show("娌℃湁杩斿洖浠讳綍缁撴灉,璇峰湪杩囨护妗嗕腑鐐瑰嚮銆愭仮澶嶃�戞寜閽�,灏濊瘯鍐嶆鏌ヨ锛�" + DBUtility.ClsPub.sExeReturnInfo);
+ return;
+ }
+ //
+ grdSub.DataSource = DSet.Tables[0].DefaultView;
+ //鍐荤粨
+ //int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
+ //string s = frmCondition.cmbHComplete.Text;
+ //DBUtility.Xt_BaseBillFun.DisplayGrid(grdSub, this.Name, s, FrCol);
+ //鐢荤嚎
+ GraphLine();
+
+
+ //
+ }
+
+ private void cmdHSourceID_Click(object sender, EventArgs e)
+ {
+ DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
+ if (oSource.RefreshView())
+ {
+ this.txtHSourceID.Text = oSource.oModel.HName;
+ this.txtHSourceID.Tag = oSource.oModel.HItemID.ToString();
+ }
+ else
+ {
+ this.txtHSourceID.Text = "";
+ }
+ }
+
+ private void cmdHEmpID_Click(object sender, EventArgs e)
+ {
+ DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
+ if (oEmp.RefreshView())
+ {
+ this.txtHEmpID.Text = oEmp.oModel.HName;
+ this.txtHEmpID.Tag = oEmp.oModel.HItemID.ToString();
+ }
+ else
+ {
+ this.txtHEmpID.Text = "";
+ }
+ }
+
+ private void cmdHMaterID_Click(object sender, EventArgs e)
+ {
+ DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
+ if (oMater.RefreshView())
+ {
+ this.txtHMaterID.Text = oMater.oModel.HName;
+ this.txtHMaterID.Tag = oMater.oModel.HItemID.ToString();
+ }
+ else
+ {
+ this.txtHMaterID.Text = "";
+ }
+ }
+
+ private void cmdHMaterID1_Click(object sender, EventArgs e)
+ {
+ DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
+ if (oMater.RefreshView())
+ {
+ this.txtHMaterID1.Text = oMater.oModel.HName;
+ this.txtHMaterID1.Tag = oMater.oModel.HItemID.ToString();
+ }
+ else
+ {
+ this.txtHMaterID1.Text = "";
+ }
+ }
+
+ private void txtHMiniQty_TextChanged(object sender, EventArgs e)
+ {
+ //double HMiniQty = 0;
+ //double HBQty = 0;
+ //HMiniQty = DBUtility.ClsPub.isDoule(txtHMiniQty.Text.Trim());
+ //HBQty =
+
+
+ }
+
+ private void txtHBQty_TextChanged(object sender, EventArgs e)
+ {
+ double HICMOQty = 0;
+ double HMiniQty = 0;
+ double HBQty = 0;
+
+
+
+
+ for (int i = 0; i < grdMain.SelectedRows.Count; i++)
+ {
+ txtHICMOQty.Text = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("璁㈠崟鏁伴噺")].Value);
+ }
+ HICMOQty = DBUtility.ClsPub.isDoule(txtHICMOQty.Text.Trim());
+ HMiniQty = DBUtility.ClsPub.isDoule(txtHMiniQty.Text.Trim());
+ if (HMiniQty == 0)
+ {
+ HBQty = 0;
+ }
+ else
+ {
+ HBQty = HICMOQty / HMiniQty;
+ }
+ HBQty = Math.Ceiling(HBQty);
+ txtHBQty.Text = DBUtility.ClsPub.isStrNull(HBQty);
+ }
+
+ private void button5_Click(object sender, EventArgs e)
+ {
+ //鍒ゆ柇鏄惁宸茬粡鐢熸垚鏉＄爜
+ for (int i = 0; i < grdList.SelectedRows.Count; i++)
+ {
+ if (DBUtility.ClsPub.isStrNull(grdList.SelectedRows[i].Cells[Fun_GetColList("鏉＄爜缂栧彿")].Value) == "")
+ {
+ MessageBox.Show("鏉＄爜鏈敓鎴愶紝璇峰厛鐢熸垚鏉＄爜鍚庡啀棰勮锛�");
+ return;
+ }
+ }
+
+ //鎵撳嵃鍓嶅垽鏂潯鐮佹槸鍚﹀凡鎵撳嵃杩�
+ if (ReportPrintBegin())
+ {
+ return;
+ }
+
+ //閫夋嫨鎵撳嵃妯℃澘
+ BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
+ oFrm.sBillName = ModName;
+ oFrm.sBillModel = ModCaption;
+ oFrm.ShowDialog();
+ if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
+ {
+ Sub_SetReport(oFrm.sOpenTmp);
+ Report.PrintPreview(false);
+ Thread.Sleep(1000);
+ }
+ }
+
+ private bool ReportPrintBegin()
+ {
+ string sRelQty = "";
+
+ if (oBar.Set_BPrintQty(DBUtility.ClsPub.isStrNull(grdList.Rows[0].Cells[Fun_GetColList("鏉＄爜缂栧彿")].Value), ref sRelQty))
+ {
+ MessageBox.Show("鏉＄爜宸茬粡鎵撳嵃杩囷紝涓嶅彲閲嶅鎵撳嵃锛�");
+ return true;
+ }
+ else
+ {
+ return false;
+ }
+ }
+
+ private void button6_Click(object sender, EventArgs e)
+ {
+ //鍒ゆ柇鏄惁宸茬粡鐢熸垚鏉＄爜
+ if (DBUtility.ClsPub.isStrNull(grdList.Rows[0].Cells[Fun_GetColList("鏉＄爜缂栧彿")].Value) == "")
+ {
+ MessageBox.Show("鏉＄爜鏈敓鎴愶紝璇峰厛鐢熸垚鏉＄爜鍚庡啀棰勮锛�");
+ return;
+ }
+
+ //鎵撳嵃鍓嶅垽鏂潯鐮佹槸鍚﹀凡鎵撳嵃杩�
+ if (ReportPrintBegin())
+ {
+ return;
+ }
+
+ //閫夋嫨鎵撳嵃妯℃澘
+ BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
+ oFrm.sBillName = ModName;
+ oFrm.sBillModel = ModCaption;
+ oFrm.ShowDialog();
+ if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
+ {
+ Sub_SetReport(oFrm.sOpenTmp);
+ Report.PrintPreview(false);
+ Thread.Sleep(1000);
+ }
+ }
+
+ private void cz_Click(object sender, EventArgs e)
+ {
+ txtHBQty.Text = "";
+ txtHEmpID.Text = "";
+ txtHICMOBillNo.Text = "";
+ txtHICMOBillNo1.Text = "";
+ txtHICMOQty.Text = "";
+ txtHMaterID.Text = "";
+ txtHMaterID1.Text = "";
+ txtHMiniQty.Text = "";
+ txtHSourceID.Text = "";
+ cmbHBarCodeType.Items.Clear();
+ grdList.DataSource = null;
+ grdSub.DataSource = null;
+ grdMain.DataSource = null;
}
}
}
\ No newline at end of file
--
Gitblit v1.9.1