~yxj/MES-WEB-API.git

			@@ -1,4 +1,5 @@
			ï»¿using Pub_Class;
			ï»¿using gregn6Lib;
			using Pub_Class;
			using System;
			using System.Collections.Generic;
			using System.ComponentModel;
			@@ -6,9 +7,10 @@
			using System.Drawing;
			using System.Linq;
			using System.Text;
			using System.Threading;
			using System.Windows.Forms;

			namespace WarM.ä»åºç®¡ç
			namespace WarM
			{
			public partial class Gy_BarCodeBill_ChaiMa : Form
			{
			@@ -40,7 +42,7 @@
			public const Int16 HMaterMould2 = 8;
			public const Int16 HBatchNo2 = 9;

			public const string ModName = ""; //åæ®ç±»å
			public const string ModName = "3302"; //åæ®ç±»å
			public const string ModCaption = "æ¡ç æç "; //åæ®åç§°
			public const string ModRightName = "Gy_BarCodeBill_ChaiMa";
			public DBUtility.ClsPub.Enum_BillStatus BillStatus; //åæ®ç¶æï¼æ°å¢ï¼ä¿®æ¹ï¼æµè§ï¼æ´æ°åä»·ï¼åæ´ï¼
			@@ -61,7 +63,24 @@
			oSumGrid_Pay.NoCol = HSnoCol2;
			}

			#region çªä½å¤çæ¹æ³
			#region çªä½å¤çæ¹æ³
			//åå§åé¡µç¾1æ°æ®
			private void intoDate()
			{
			try
			{
			DataSet Ds;
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			Ds = oCn.RunProcReturn("select * from h_v_Gy_BarCodeBill_ChaiMa", "h_v_Gy_BarCodeBill_ChaiMa");
			grdMain.DataSource = Ds.Tables[0].DefaultView;

			}
			catch (Exception ex )
			{
			MessageBox.Show(ex.Message.ToString());
			}

			}

			//åå§åé¡µç¾1
			private void initGrid()
			@@ -82,10 +101,15 @@
			////éèå
			grdMain.Columns[HTagCol].Visible = false;
			grdMain.Columns[HInterID].Visible = false;
			//è®¾ç½®å¯ç¼è¾å
			string sAllowCol = HNum.ToString();
			//è®¾ç½®åè®¡å
			string sTotalCol = HTagCol.ToString() + "0";
			//ç½®ç°
			grdMain.Columns[HSnoCol].ReadOnly = true;
			grdMain.Columns[HBarCode].ReadOnly = true;
			grdMain.Columns[HQty].ReadOnly = true;
			grdMain.Columns[HMaterCol].ReadOnly = true;
			grdMain.Columns[HMaterName].ReadOnly = true;
			grdMain.Columns[HMaterMould].ReadOnly = true;
			grdMain.Columns[HBatchNo].ReadOnly = true;
			//intoDate();
			//æ ¼å¼åç½æ ¼
			//DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid_Mater);
			}
			@@ -108,6 +132,14 @@
			////éèå
			grdMain_Pay.Columns[HTagCol].Visible = false;
			grdMain_Pay.Columns[HInterID].Visible = false;
			//ç½®ç°
			grdMain_Pay.Columns[HSnoCol].ReadOnly = true;
			grdMain_Pay.Columns[HBarCode].ReadOnly = true;
			grdMain_Pay.Columns[HQty].ReadOnly = true;
			grdMain_Pay.Columns[HMaterCol].ReadOnly = true;
			grdMain_Pay.Columns[HMaterName].ReadOnly = true;
			grdMain_Pay.Columns[HMaterMould].ReadOnly = true;
			grdMain_Pay.Columns[HBatchNo].ReadOnly = true;
			//è®¾ç½®å¯ç¼è¾å
			string sAllowCol = HNum2.ToString();
			//è®¾ç½®åè®¡å
			@@ -134,26 +166,26 @@
			Sub_ClearBill();
			}

			//æ°æ®éªè¯
			private bool Sub_AllowSave()
			{
			for (int i = 0; i <= grdMain_Pay.RowCount - 1; i++)
			{
			if (ClsPub.isLong(grdMain_Pay.Rows[i].Cells[HSnoCol2].Value) != 0)
			{
			if (ClsPub.isStrNull(grdMain_Pay.Rows[i].Cells[HNum2].Value) ==null)
			{
			MessageBox.Show("è¯·å°è¡¨æ ¼æåæ°éå¡«åå®æ´", "æç¤º");
			return false;
			}
			}
			else
			{
			return false;
			}
			}
			return true;
			}
			////æ°æ®éªè¯
			//private bool Sub_AllowSave()
			//{
			// for (int i = 0; i <= grdMain_Pay.RowCount - 1; i++)
			// {
			// if (ClsPub.isLong(grdMain_Pay.Rows[i].Cells[HSnoCol2].Value) != 0)
			// {
			// if (ClsPub.isStrNull(grdMain_Pay.Rows[i].Cells[HNum2].Value) ==null)
			// {
			// MessageBox.Show("è¯·å°è¡¨æ ¼æåæ°éå¡«åå®æ´", "æç¤º");
			// return false;
			// }
			// }
			// else
			// {
			// return true;
			// }
			// }
			// return true;
			//}

			//çææé®
			private void xz_Click(object sender, EventArgs e)
			@@ -170,13 +202,13 @@
			//å¤æä¼è®¡ææ¯å¦åç
			string HBillNo = txtHBillNo.Text;
			DataSet Ds;
			double sum = 0.00000000;
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			Ds = oCn.RunProcReturn("select top 1* from h_v_Gy_BarCodeBill_ChaiMa where æ¡ç ç¼å·='" + HBillNo + "'", "h_v_Gy_BarCodeBill_ChaiMa");
			Ds = oCn.RunProcReturn("select top 1* from Gy_BarCodeBill 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[HSnoCol2].Value) != 0)
			{

			Model.ClsGy_BarCodeEdit_Model model = new Model.ClsGy_BarCodeEdit_Model();
			//åºå®èµå¼========================================
			model.HEntryID = i + 1;
			@@ -185,7 +217,7 @@
			model.HQty = DBUtility.ClsPub.isLong(grdMain_Pay.Rows[i].Cells[HNum2].Value);
			model.HQty = 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.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"].ToString());
			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());
			@@ -198,7 +230,6 @@
			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());
			@@ -211,33 +242,40 @@
			model.HMakeDate = DateTime.Now;
			model.HMaker = ClsPub.CurUserName;

			if (model.HPieceQty <= 0 \|\| model.HPieceQty.ToString() == "")
			if (model.HQty <= 0 \|\| model.HQty.ToString() == "")
			{
			MessageBox.Show("ç¬¬" + ClsPub.isStrNull(i + 1) + "è¡ï¼æåæ°éå¿é¡»å¤§äº0ï¼");
			MessageBox.Show("é¡µ2ç¬¬" + ClsPub.isStrNull(i + 1) + "è¡ï¼æåæ°éå¿é¡»å¤§äº0ï¼");
			return false;
			}
			sum += model.HQty;
			BillNew.DetailColl_Mater.Add(model);
			}
			else
			{
			break;
			}
			}

			//ä¿å
			bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
			//æç¤º
			if (bResult == true)
			if (sum > DBUtility.ClsPub.isDoule(grdMain.Rows[0].Cells[HQty].Value))
			{
			MessageBox.Show("åæ®åçå®æ¯!åæ®å·:" + this.txtHBillNo.Text.Trim(), "æç¤º");
			return true;
			MessageBox.Show("é¡µ2æåæ°éä¹åå¿é¡»å°äºæ¡ç æ°éï¼");
			return false;
			}
			else
			{
			MessageBox.Show("ä¿åå¤±è´¥!åå :" + ClsPub.sExeReturnInfo, "æç¤º");
			return false;
			//ä¿å
			bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo, HBillNo);
			//æç¤º
			if (bResult == true)
			{
			MessageBox.Show("åæ®åçå®æ¯!åæ®å·:" + this.txtHBillNo.Text.Trim(), "æç¤º");
			return true;
			}
			else
			{
			MessageBox.Show("ä¿åå¤±è´¥!åå :" + ClsPub.sExeReturnInfo, "æç¤º");
			return false;
			}
			}
			//}
			//else
			//{
			// return false;
			//}
			}
			//ç¡®å®æé®
			private void button1_Click(object sender, EventArgs e)
			@@ -295,5 +333,118 @@
			{
			this.Close();
			}

			GridppReport Report;
			private void yl_Click(object sender, EventArgs e)
			{
			//éæ©æå°æ¨¡æ¿
			BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
			oFrm.sBillName = ModName;
			oFrm.sBillModel = "æ¡ç æ¡£æ¡åè¡¨";
			oFrm.ShowDialog();
			if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
			{
			Sub_SetReport(oFrm.sOpenTmp);
			Report.PrintPreview(false);
			Thread.Sleep(1000);
			}
			}

			private void dy_Click(object sender, EventArgs e)
			{
			//æå°åå¤ææ¡ç æ¯å¦å·²æå°è¿
			string sBarCode = "";
			string sRelQty = "";
			int i = 0;
			DAL.ClsGy_BarCodeBill_Ctl oBar = new DAL.ClsGy_BarCodeBill_Ctl();

			if (ClsPub.isLong(grdMain_Pay.Rows[0].Cells[HSnoCol2].Value) == 0)
			{
			MessageBox.Show("è¯·åçææç æ¡ç ï¼");
			}

			while (ClsPub.isLong(grdMain_Pay.Rows[i].Cells[HSnoCol2].Value) != 0)
			{
			sBarCode = sBarCode + "," + DBUtility.ClsPub.isStrNull(grdMain_Pay.Rows[i].Cells[HBarCode2].Value);
			i++;
			}

			//éæ©æå°æ¨¡æ¿
			BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
			oFrm.sBillName = ModName;
			oFrm.sBillModel = "æ¡ç æ¡£æ¡åè¡¨";
			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 Sub_SetReport(string sOpenTmp)
			{
			//å¤æè¡æ°
			for (int i = 0; i < grdMain_Pay.Rows.Count; i++)
			{
			grdMain_Pay.Rows[i].Cells[0].Value = "";
			}
			for (int i = 0; i < grdMain_Pay.SelectedRows.Count; i++)
			{
			grdMain_Pay.Rows[grdMain_Pay.SelectedRows[i].Index].Cells[0].Value = "*";
			}
			//
			Report = new GridppReport();
			Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf"); //here .
			Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
			Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
			}
			//å¡«å¥åæ®è¡¨å¤´ä¿¡æ¯
			private void ReportBeforePostRecord()//your report?kao
			{
			try
			{
			//Report.FieldByName("ç©æä»£ç ").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("ç©æä»£ç ")].Value.ToString();
			//Report.FieldByName("ç©æåç§°").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("ç©æåç§°")].Value.ToString();
			//Report.FieldByName("è§æ ¼åå·").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("è§æ ¼åå·")].Value.ToString();
			//Report.FieldByName("èªå®ä¹è§æ ¼").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("èªå®ä¹è§æ ¼")].Value.ToString();
			//Report.FieldByName("æ¡ç ç¼å·").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value.ToString();
			//Report.FieldByName("æ°é").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("æ°é")].Value.ToString();
			//Report.FieldByName("æ¹æ¬¡").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("æ¹å·")].Value.ToString();
			//Report.FieldByName("æºååå·").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("æºååå·")].Value.ToString();
			//Report.FieldByName("éå®è®¢åå·").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("éå®è®¢åå·")].Value.ToString();
			//Report.FieldByName("éè´è®¢åå·").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("éè´è®¢åå·")].Value.ToString();
			//Report.FieldByName("ä¾åºå").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("å¾æ¥åä½")].Value.ToString();
			//Report.FieldByName("çäº§è½¦é´").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("çäº§è½¦é´")].Value.ToString();
			//Report.FieldByName("å¤æ³¨").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("å¤æ³¨")].Value.ToString();
			//Report.FieldByName("æ»ææ°").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("æ»ææ°")].Value.ToString();
			//Report.FieldByName("æå·").AsString = grdMain.Rows[CurRows].Cells[Fun_GetCol("æå·")].Value.ToString();
			}
			catch (Exception e)
			{
			MessageBox.Show("æå°å¤±è´¥!è¡¨å¤´ï¼" + e.Message);
			}
			//CurRows = CurRows + 1;
			}
			private void ReportFetchRecordByDataTable()
			{
			try
			{
			DataTable ds = new DataTable();
			BLL.Utility.FillRecordToReport_Sel(Report, grdMain_Pay, ds, Fun_GetCol("åºå·"));
			}
			catch (Exception e)
			{
			MessageBox.Show("æå°å¤±è´¥!è¡¨ä½ï¼" + e.Message);
			}
			}
			private Int32 Fun_GetCol(string sCol)
			{
			return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain_Pay);
			}
			}
			}