MES-WEB-API.git

			@@ -11,6 +11,8 @@
			using System.Threading;
			using System.IO;
			using Pub_Class;
			using System.IO.Ports;
			using System.Linq;

			namespace WarM
			{
			@@ -35,7 +37,7 @@
			public Int64 HSourceEntryID = 0;
			public string HSourceBillNo = "";
			public string HSourceBillType = "";
			public Int64 ProcessExchangeInterID = 0;
			public Int64 HProcessExchangeInterID = 0;
			public Int64 HSupID = 0;
			public double HSourceQty = 0;
			public double HMaterWeight = 0; //ç©æåé
			@@ -62,6 +64,9 @@
			grdMain.DataSource = null;
			grdSub.DataSource = null;
			chkHDYFlag.Checked = true;

			//è¯»å æå¼ä¸²å£çéç½®ä¿¡æ¯
			readParams();
			}

			//çªä½å è½½
			@@ -383,7 +388,13 @@

			private void tc_Click(object sender, EventArgs e)
			{
			this.Close();
			//éåºæ¶å³éä¸²å£
			if (ComDevice != null)
			{
			CloseCom();
			}

			this.Close();
			}

			#endregion
			@@ -523,6 +534,17 @@
			//æ¡ç çæåå¤æ
			private bool Sub_AllowSave()
			{
			//å¤æå½ååæ®IDæ¯å¦å·²ä¸ä¼ çæåæ®
			DataSet Ds = oCn.RunProcReturn("select top 1 1 from KF_WeighSource_Temp with(nolock) where HInterID=" + HInterID.ToString() + " and HRelationInterID=1 ", "KF_WeighSource_Temp", ref DBUtility.ClsPub.sExeReturnInfo);
			if (Ds == null \|\| Ds.Tables[0].Rows.Count == 0)
			{
			}
			else
			{
			MessageBox.Show("å½åæ¡ç è®°å½å·²æ¢çä¸ä¼ çæåæ®ï¼è¯·éåºåéæ°è¿å¥è¯¥æ¨¡åè¿è¡æ¡ç çææä½ï¼", "æç¤º");
			return false;
			}

			if (HInterID==0 \|\| HBillNo=="")
			{
			MessageBox.Show("è·åæ¡ç å¯¹åºåæ®IDæåæ®å·å¤±è´¥ï¼è¯·éæ°å·æ°çé¢ï¼", "æç¤º");
			@@ -567,6 +589,38 @@
			{
			if (MessageBox.Show("ç©æç»´æ¤åéä¸ºï¼"+HMaterWeight.ToString()+ "ï¼å®éåéä¸ºï¼" + sQty.ToString() + "ï¼æè¾å¥å®éåéè¶åºç©æç»´æ¤åéçç¾åä¹äºåæä¸è¶³ç©æç»´æ¤åéçç¾åä¹å«åï¼è¯·æ£æ¥è¾å¥çæ°æ®æ¯å¦æ£ç¡®ï¼", "æç¤º", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
			{
			//return true;
			}
			else
			{
			return false;
			}
			}

			//æ¡ç çæåæ§å¶å¤æ
			double HNowQty = 0; //ç±³æ°
			double HWeightQyt = 0; //éé
			double HKDQty = 0; //æ£ç¹æ°
			HNowQty = DBUtility.ClsPub.isDoule(txtHQty.Text);
			HWeightQyt = DBUtility.ClsPub.isDoule(txtHWeightQyt.Text);
			HKDQty = DBUtility.ClsPub.isDoule(txtHKDQty.Text);

			DataSet oDsCheck = oCn.RunProcReturn("exec h_p_Kf_WeighToBarCode_AddBarCodeCheck " + HInterID.ToString() + "," + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + "," + HProcessExchangeInterID.ToString() + "," + HSourceQty.ToString() + "," + HNowQty.ToString() + "," + HWeightQyt.ToString() + "," + HKDQty.ToString(), "h_p_Kf_WeighToBarCode_AddBarCodeCheck");
			//
			if (oDsCheck == null && oDsCheck.Tables[0].Rows.Count == 0)
			{
			MessageBox.Show("æ¡ç çæåå¤æéè¯¯ï¼");
			return false;
			}
			else if (DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0][0]) == "1")
			{
			MessageBox.Show(DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0]["HRemark"]), "æç¤º");
			return false;
			}
			else if (DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0][0]) == "2")
			{
			if (MessageBox.Show(DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0]["HRemark"]), "æç¤º", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
			{
			return true;
			}
			else
			@@ -574,7 +628,10 @@
			return false;
			}
			}
			return true;
			else
			{
			return true;
			}
			}

			//çææ¡ç
			@@ -641,7 +698,7 @@
			string HRemark = "";
			string HMaterName = "";
			string HMaterModel = "";
			string ProcessExchangeBillNo = "";
			string HProcessExchangeBillNo = "";
			Int64 HBarcodeNo = 0; //åæ°
			Int64 HBadReasonID = 0; //ä¸è¯åå ID
			string HCusMaterName = ""; //å®¢æ·ç©æåç§°
			@@ -657,7 +714,7 @@
			HRemark = DBUtility.ClsPub.isStrNull(txtHRemark.Text);
			HMaterName = DBUtility.ClsPub.isStrNull(txtHMaterName.Text);
			HMaterModel = DBUtility.ClsPub.isStrNull(txtHMaterModel.Text);
			ProcessExchangeBillNo = DBUtility.ClsPub.isStrNull(txtHBillNo.Text);
			HProcessExchangeBillNo = DBUtility.ClsPub.isStrNull(txtHBillNo.Text);
			HBarcodeNo = DBUtility.ClsPub.isLong(txtHBarcodeNo.Text);
			HBadReasonID = DBUtility.ClsPub.isLong(txtHRemark.Tag);
			HCusMaterName = DBUtility.ClsPub.isStrNull(txtHCusMaterName.Text);
			@@ -683,14 +740,14 @@
			+ ", 1," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + "," + HWhID.ToString() + "," + HSPID.ToString() + ",'" + HRemark + "'"
			+ ", 0,'',getdate(),'','" + sDate + "'," + HMaterialJQty.ToString() + "," + HMaterialMQty.ToString() + "," + HNowQty.ToString()
			+ ", " + HStockOrgID.ToString() + "," + HStockOrgID.ToString() + ",''," + HInterID.ToString() + ",0"
			+ ", " + ProcessExchangeInterID.ToString() + ",0,'" + ProcessExchangeBillNo + "'," + HBadReasonID.ToString() + ",'" + HCusMaterName + "','" + HCusModel + "'"
			+ ", " + HProcessExchangeInterID.ToString() + ",0,'" + HProcessExchangeBillNo + "'," + HBadReasonID.ToString() + ",'" + HCusMaterName + "','" + HCusModel + "'"
			+ ",'" + HMaterName + "','" + HMaterModel + "',''," + HAuxPropID.ToString() + ",'','','1')");

			//åå¡«æå¤§æµæ°´å·
			oCn.RunProc("exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "',1 ");

			//åå¡«æºåä¸´æ¶è¡¨HInterID
			oCn.RunProc("update a set a.HInterID=" + HInterID.ToString() + ",a.HBillNo='" + HBillNo +"',a.HRelationInterID= 0 from KF_WeighSource_Temp a where a.HInterID<>" + HInterID.ToString() + " and a.HMaker='" + HMaker + "' and a.HSourceBillNo='" + ProcessExchangeBillNo + "'");
			oCn.RunProc("update a set a.HInterID=" + HInterID.ToString() + ",a.HBillNo='" + HBillNo +"',a.HRelationInterID= 0 from KF_WeighSource_Temp a where a.HInterID<>" + HInterID.ToString() + " and a.HMaker='" + HMaker + "' and a.HSourceBillNo='" + HProcessExchangeBillNo + "'");

			//åå¥æ¡ç åºå¥åºä¸´æ¶è¡¨
			oCn.RunProc("Insert into KF_PonderationBillMain_Temp " +
			@@ -746,9 +803,10 @@
			HSourceBillNo = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("çäº§è®¢å")].Value);
			HSourceBillType = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HSourceBillType")].Value);
			HSourceQty = DBUtility.ClsPub.isDoule(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("æ°é")].Value);
			ProcessExchangeInterID = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("ProcessExchangeInterID")].Value);
			HProcessExchangeInterID = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("ProcessExchangeInterID")].Value);
			HSupID = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HSupID")].Value);
			HMaterWeight = DBUtility.ClsPub.isDoule(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HMaterWeight")].Value);
			txtHOrderPickRemark.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("è®¢ååè£å¤æ³¨")].Value);
			}

			//è¿åæºååè¡¨ä¿¡æ¯
			@@ -988,8 +1046,304 @@



			#region è¯»åè®¾å¤ç§°éä¿¡æ¯



			private static string repeatData = string.Empty;
			private SerialPort ComDevice = null;

			private int HGetWeight = 0;
			private string Message = "";

			private int timeIndex = 0;

			private string value_COM = ""; //COM
			private string value_BaudRate = "9600"; //æ¯ç¹ç
			private string value_StopBits = "1"; //åæ¢ä½
			private string value_Parity = "0"; //æ ¡éªä½
			private string value_DataBits = "8"; //æ°æ®ä½

			#region æå¼ä¸²å£æé®è§¦åäºä»¶
			private void button_OpenCom_Click(object sender, EventArgs e)
			{
			value_COM = textBox_COM.Text;
			OpenCom();
			}
			#endregion

			#region æå¼ä¸²å£
			public void OpenCom()
			{
			//åå§åä¸²å£
			ComDevice = new SerialPort();
			ComDevice.DataReceived += new SerialDataReceivedEventHandler(Com_DataReceived);//ç»å®äºä»¶
			string[] PortNames = SerialPort.GetPortNames();

			if (!ComDevice.IsOpen)
			{
			try
			{
			ComDevice.PortName = value_COM;
			ComDevice.BaudRate = int.Parse(value_BaudRate);
			switch (value_Parity)
			{
			case "0":
			ComDevice.Parity = Parity.None;
			break;
			case "1":
			ComDevice.Parity = Parity.Odd;
			break;
			case "2":
			ComDevice.Parity = Parity.Even;
			break;
			case "3":
			ComDevice.Parity = Parity.Mark;
			break;
			case "4":
			ComDevice.Parity = Parity.Space;
			break;
			default:
			break;
			}

			ComDevice.DataBits = int.Parse(value_DataBits);
			switch (value_StopBits)
			{
			case "0":
			ComDevice.StopBits = StopBits.None;
			break;
			case "1":
			ComDevice.StopBits = StopBits.One;
			break;
			case "2":
			ComDevice.StopBits = StopBits.Two;
			break;
			case "1.5":
			ComDevice.StopBits = StopBits.OnePointFive;
			break;
			default:
			break;
			}

			ComDevice.Open();

			MessageBox.Show("ä¸²å£æå¼æåï¼");

			//ä¿åä¸²å£çéç½®ä¿¡æ¯
			saveParams();
			}
			catch (Exception ex)
			{
			MessageBox.Show("æå¼ä¸²å£å¤±è´¥ï¼" + ex.Message, "éè¯¯", MessageBoxButtons.OK, MessageBoxIcon.Error);
			return;
			}
			}
			else
			{

			}
			}
			#endregion

			#region å³éä¸²å£
			public void CloseCom()
			{
			if (!ComDevice.IsOpen)
			{
			MessageBox.Show("ä¸²å£å³éå¤±è´¥ï¼å½åä¸²å£æªæå¼ï¼");
			}
			else
			{
			try
			{
			Thread.Sleep(100);
			ComDevice.Close();

			MessageBox.Show("ä¸²å£å³éæåï¼");
			}
			catch (Exception ex)
			{
			MessageBox.Show(ex.Message, "éè¯¯", MessageBoxButtons.OK, MessageBoxIcon.Error);
			return;
			}
			}
			}
			#endregion

			#region æ¥æ¶æ°æ®
			private void Com_DataReceived(object sender, SerialDataReceivedEventArgs e)
			{
			if (HGetWeight == 1)
			{
			byte[] ReDatas = new byte[ComDevice.BytesToRead];
			ComDevice.Read(ReDatas, 0, ReDatas.Length);//è¯»åæ°æ®
			this.AddData(ReDatas);//è¾åºæ°æ®
			}
			}
			#endregion

			#region å¤çæ¥æ¶å°çæ°æ®
			public void AddData(byte[] data)
			{
			StringBuilder sb = new StringBuilder();
			sb.Append(Encoding.ASCII.GetString(data));

			var str = sb.ToString();
			str = str.Replace("w", "").Replace("n", "").Replace("kg\r\n", ";");


			if (str != repeatData)
			{
			repeatData = str;
			string[] strArray = str.Split(';');

			for (int i = 0; i < strArray.Length; i++)
			{
			if (double.TryParse(strArray[i], out double ret))//å¤ææ¯å¦æ¯æ°å
			{
			//ä¿çä¸ä½å°æ°
			double temp = double.Parse(strArray[i]);
			temp = Math.Round(temp,1);

			Message += double.Parse(strArray[i]) + ";";
			}
			}
			}
			}
			#endregion

			#region è·åæ°ç»ä¸åºç°é¢çæé«çæ°æ®
			private string getMostStr(string message)
			{
			string[] strArray = message.Split(';');
			// ä½¿ç¨LINQæ¥è¯¢åºç°æ¬¡æ°æå¤çåç´
			var maxElement = strArray.GroupBy(x => x)
			.OrderByDescending(g => g.Count())
			.First()
			.Key;


			return maxElement;
			}
			#endregion

			#region è®¡æ¶å¨è§¦åäºä»¶ï¼ç¨äºè·åæ¶é´é´éåæ¥æ¶å°çæ°æ®
			private void timer2_Tick(object sender, EventArgs e)
			{
			if (timeIndex == 0)
			{
			timeIndex = 1;
			}
			else
			{
			timer2.Enabled = false;

			string str = getMostStr(Message);

			txtHWeightQyt.Text = str;


			Message = "";
			timeIndex = 0;
			HGetWeight = 0;
			}
			}
			#endregion

			#region ç§°éæé®è§¦åäºä»¶
			private void button_getHWeight_Click(object sender, EventArgs e)
			{
			HGetWeight = 1;
			timer2.Enabled = true;
			}
			#endregion


			#region ä¿åéç½®ä¿¡æ¯
			//åå¥éç½®åæ°
			private void saveParams()
			{
			//å¤ææä»¶æ¯å¦åå¨
			if (!File.Exists(Application.StartupPath + "//Kf_WeightToBarCodeParams.txt"))
			{
			FileStream fs1 = new FileStream(Application.StartupPath + "//Kf_WeightToBarCodeParams.txt", FileMode.Create, FileAccess.Write);//åå»ºåå¥æä»¶
			StreamWriter sw = new StreamWriter(fs1);
			sw.WriteLine(value_COM);//å¼å§åå¥å¼
			sw.WriteLine(value_BaudRate);

			sw.WriteLine(value_StopBits);

			sw.WriteLine(value_Parity);
			sw.WriteLine(value_DataBits);
			sw.Close();
			fs1.Close();
			}
			else
			{
			FileStream fs1 = new FileStream(Application.StartupPath + "//Kf_WeightToBarCodeParams.txt", FileMode.Create, FileAccess.Write);//åå»ºåå¥æä»¶
			StreamWriter sw = new StreamWriter(fs1);
			sw.WriteLine(value_COM);//å¼å§åå¥å¼
			sw.WriteLine(value_BaudRate);

			sw.WriteLine(value_StopBits);

			sw.WriteLine(value_Parity);
			sw.WriteLine(value_DataBits);
			sw.Close();
			fs1.Close();
			}
			}
			#endregion

			#region è¯»åéç½®ä¿¡æ¯
			//è¯»åéç½®æä»¶
			private void readParams()
			{
			//å³éä¸²å£
			//CloseCom();

			if (File.Exists(Application.StartupPath + "//Kf_WeightToBarCodeParams.txt"))
			{
			//è¯»åæä»¶å¼å¹¶æ¾ç¤ºå°çªä½
			FileStream fs = new FileStream(Application.StartupPath + "//Kf_WeightToBarCodeParams.txt", FileMode.Open, FileAccess.ReadWrite);
			StreamReader sr = new StreamReader(fs);
			string line = sr.ReadLine();
			int curLine = 0;
			while (line != null)
			{
			if (++curLine == 1)
			{
			value_COM = line;
			textBox_COM.Text = value_COM;
			}
			else if (curLine == 2)
			{
			value_BaudRate = line;
			}
			else if (curLine == 3)
			{
			value_StopBits = line;
			}
			else if (curLine == 4)
			{
			value_Parity = line;
			}
			else if (curLine == 5)
			{
			value_DataBits = line;
			}
			else
			{

			}
			line = sr.ReadLine();
			}
			sr.Close();
			fs.Close();
			}
			}
			#endregion
			#endregion
			}
			}