public void SaveToolData(string toolType, string Barcode, float clearance, float height, float width, float length, string comments, string byWho, out string resCode, out string resDesc) { try { Log.AppendText("กำลังบันทึกข้อมูล Tool {" + toolType + ", " + Barcode + ", " + clearance.ToString() + ", " + height.ToString() + ", " + width.ToString() + ", " + length.ToString() + "} by " + byWho); ManageBiz ms = new ManageBiz(); DataTable dtUser; dtUser = ms.GetToolBy(toolType); if (dtUser.Rows.Count == 0) { Log.AppendText("ตรวจสอบ ToolType เรียบร้อย"); ms.AddNewTool(toolType, Barcode, clearance, height, width, length, comments); resCode = "00"; resDesc = ""; } else { Log.AppendText("WARNING! : ToolType ซ้ำ"); Log.AppendText("เริ่มต้น Update Tool..."); ms.UpdateToolData(toolType, Barcode, clearance, height, width, length, comments); resCode = "01"; resDesc = ""; } } catch (Exception ex) { resCode = "EX"; resDesc = ex.Message; Log.AppendText(ex.Message); } }
public void LoadToolData(string toolType, ref TextBox _clearance, ref TextBox _height, ref TextBox _width, ref TextBox _length, ref TextBox _barcode, ref TextBox _comments) { try { Log.AppendText("กำลังเรียกข้อมูล Tools {" + toolType + "}"); _clearance.Text = ""; _height.Text = ""; _width.Text = ""; _length.Text = ""; _barcode.Text = ""; _comments.Text = ""; ManageBiz ms = new ManageBiz(); DataTable dtUser; dtUser = ms.GetToolBy(toolType); if (dtUser.Rows.Count > 0) { _clearance.Text = dtUser.Rows[0]["Clearance"].ToString(); _height.Text = dtUser.Rows[0]["Height"].ToString(); _width.Text = dtUser.Rows[0]["Width"].ToString(); _length.Text = dtUser.Rows[0]["Length"].ToString(); _barcode.Text = dtUser.Rows[0]["Barcode"].ToString(); _comments.Text = dtUser.Rows[0]["Comments"].ToString(); Log.AppendText("เรียกข้อมูล Tools เรียบร้อย"); } else { Log.AppendText("ไม่พบข้อมูล Tools"); } } catch (Exception ex) { Log.AppendText(ex.Message); MessageBox.Show(ex.Message); } }
// // --------------------------------------------------------- // Constructor // --------------------------------------------------------- public ConnectorInfo(string connectorType, float x, float y, float angle, string comments, float fixtureThickness, float boardThickness) { // Preseting ToolType = ""; ProfileName = ""; // NumberOfPins = 0; CONBaseThickness = 0; CONUnseatedTop = 0; CONHeight = 0; CONSeatedHeight = 0; // GraphFPerPin = 0; GraphDistance = 0; // MinFPerPin = 0; MaxFPerPin = 0; UserFPerPin = 0; OtherForce = 0; // PARSPercent = 0; PARSStartHeight = 0; PARSDistance = 0; // FGradDegrees = 0; CONComments = ""; // ToolClearance = 0; ToolHeight = 0; ToolWidth = 0; ToolLength = 0; // ToolBarcode = ""; ToolComments = ""; // PARSSamplingStartHeight = 0; PARSSamplingDistance = 0; // Error1 = ""; Error2 = ""; Error3 = ""; Error4 = ""; Error5 = ""; // H1Par = 0; H2Par = 0; H3Par = 0; H4Par = 0; H5Par = 0; H6Par = 0; H7Par = 0; // HAC1 = ""; HAC2 = ""; HAC3 = ""; HAC4 = ""; HAC5 = ""; HAC6 = ""; HAC7 = ""; // F1Par = 0; F2Par = 0; F3Par = 0; F4Par = 0; F5Par = 0; F6Par = 0; F7Par = 0; // FAC1 = ""; FAC2 = ""; FAC3 = ""; FAC4 = ""; FAC5 = ""; FAC6 = ""; FAC7 = ""; // SP1 = 0; SP2 = 0; SP3 = 0; SP4 = 0; SP5 = 0; SP6 = 0; SP7 = 0; // // Assigning this.ConnectorType = connectorType; // this.X = x; this.Y = y; this.Angle = angle; this.Comments = comments; // this.FixtureThickness = fixtureThickness; this.BoardThickness = boardThickness; // this.Location = new PointF(x, y); // // Connector type database ManageBiz ms = new ManageBiz(); DataTable dtCON; dtCON = ms.GetConnectorBy(connectorType); if (dtCON != null) { if (dtCON.Rows.Count > 0) { ToolType = dtCON.Rows[0]["ToolType"].ToString(); ProfileName = dtCON.Rows[0]["ProfileName"].ToString(); // NumberOfPins = int.Parse(dtCON.Rows[0]["NumberOfPins"].ToString()); CONBaseThickness = float.Parse(dtCON.Rows[0]["BaseThickness"].ToString()); CONUnseatedTop = float.Parse(dtCON.Rows[0]["UnseatedTop"].ToString()); CONHeight = float.Parse(dtCON.Rows[0]["Height"].ToString()); CONSeatedHeight = float.Parse(dtCON.Rows[0]["SeatedHeight"].ToString()); // GraphFPerPin = float.Parse(dtCON.Rows[0]["GraphFPerPin"].ToString()); GraphDistance = float.Parse(dtCON.Rows[0]["GraphDistance"].ToString()); // MinFPerPin = float.Parse(dtCON.Rows[0]["MinFPerPin"].ToString()); MaxFPerPin = float.Parse(dtCON.Rows[0]["MaxFPerPin"].ToString()); UserFPerPin = float.Parse(dtCON.Rows[0]["UserFPerPin"].ToString()); OtherForce = float.Parse(dtCON.Rows[0]["OtherForce"].ToString()); // PARSPercent = float.Parse(dtCON.Rows[0]["PARSPercent"].ToString()); PARSStartHeight = float.Parse(dtCON.Rows[0]["PARSStartHeight"].ToString()); PARSDistance = float.Parse(dtCON.Rows[0]["PARSDistance"].ToString()); // FGradDegrees = float.Parse(dtCON.Rows[0]["FGradDegrees"].ToString()); // CONComments = dtCON.Rows[0]["Comments"].ToString(); } } dtCON.Dispose(); dtCON = null; // // Tool type database DataTable dtTOOL; dtTOOL = ms.GetToolBy(ToolType); if (dtTOOL != null) { if (dtTOOL.Rows.Count > 0) { ToolClearance = float.Parse(dtTOOL.Rows[0]["Clearance"].ToString()); ToolHeight = float.Parse(dtTOOL.Rows[0]["Height"].ToString()); ToolWidth = float.Parse(dtTOOL.Rows[0]["Width"].ToString()); ToolLength = float.Parse(dtTOOL.Rows[0]["Length"].ToString()); // ToolBarcode = dtTOOL.Rows[0]["Barcode"].ToString(); ToolComments = dtTOOL.Rows[0]["Comments"].ToString(); } } dtTOOL.Dispose(); dtTOOL = null; // // Profile database DataTable dtPF; dtPF = ms.GetProfileBy(ProfileName); if (dtPF != null) { if (dtPF.Rows.Count > 0) { PARSSamplingStartHeight = float.Parse(dtPF.Rows[0]["StartHeight"].ToString()); PARSSamplingDistance = float.Parse(dtPF.Rows[0]["Distance"].ToString()); // Error1 = dtPF.Rows[0]["Error1"].ToString(); Error2 = dtPF.Rows[0]["Error2"].ToString(); Error3 = dtPF.Rows[0]["Error3"].ToString(); Error4 = dtPF.Rows[0]["Error4"].ToString(); Error5 = dtPF.Rows[0]["Error5"].ToString(); // H1Par = float.Parse(dtPF.Rows[0]["H1Par"].ToString()); H2Par = float.Parse(dtPF.Rows[0]["H2Par"].ToString()); H3Par = float.Parse(dtPF.Rows[0]["H3Par"].ToString()); H4Par = float.Parse(dtPF.Rows[0]["H4Par"].ToString()); H5Par = float.Parse(dtPF.Rows[0]["H5Par"].ToString()); H6Par = float.Parse(dtPF.Rows[0]["H6Par"].ToString()); H7Par = float.Parse(dtPF.Rows[0]["H7Par"].ToString()); // HAC1 = dtPF.Rows[0]["HAC1"].ToString(); HAC2 = dtPF.Rows[0]["HAC2"].ToString(); HAC3 = dtPF.Rows[0]["HAC3"].ToString(); HAC4 = dtPF.Rows[0]["HAC4"].ToString(); HAC5 = dtPF.Rows[0]["HAC5"].ToString(); HAC6 = dtPF.Rows[0]["HAC6"].ToString(); HAC7 = dtPF.Rows[0]["HAC7"].ToString(); // F1Par = float.Parse(dtPF.Rows[0]["F1Par"].ToString()); F2Par = float.Parse(dtPF.Rows[0]["F2Par"].ToString()); F3Par = float.Parse(dtPF.Rows[0]["F3Par"].ToString()); F4Par = float.Parse(dtPF.Rows[0]["F4Par"].ToString()); F5Par = float.Parse(dtPF.Rows[0]["F5Par"].ToString()); F6Par = float.Parse(dtPF.Rows[0]["F6Par"].ToString()); F7Par = float.Parse(dtPF.Rows[0]["F7Par"].ToString()); // FAC1 = dtPF.Rows[0]["FAC1"].ToString(); FAC2 = dtPF.Rows[0]["FAC2"].ToString(); FAC3 = dtPF.Rows[0]["FAC3"].ToString(); FAC4 = dtPF.Rows[0]["FAC4"].ToString(); FAC5 = dtPF.Rows[0]["FAC5"].ToString(); FAC6 = dtPF.Rows[0]["FAC6"].ToString(); FAC7 = dtPF.Rows[0]["FAC7"].ToString(); // SP1 = float.Parse(dtPF.Rows[0]["SP1"].ToString()); SP2 = float.Parse(dtPF.Rows[0]["SP2"].ToString()); SP3 = float.Parse(dtPF.Rows[0]["SP3"].ToString()); SP4 = float.Parse(dtPF.Rows[0]["SP4"].ToString()); SP5 = float.Parse(dtPF.Rows[0]["SP5"].ToString()); SP6 = float.Parse(dtPF.Rows[0]["SP6"].ToString()); SP7 = float.Parse(dtPF.Rows[0]["SP7"].ToString()); } } dtPF.Dispose(); dtPF = null; // // Compute tool parameters this.ToolSize = new SizeF(this.ToolWidth, this.ToolLength); if (this.ToolSize.Width <= 0) { this.ToolSize.Width = 1; } if (this.ToolSize.Height <= 0) { this.ToolSize.Height = 1; } // // /* ----------------------------------------------------------------------------------------- * ชุดคำสั่ง ต่อไปนี้ ถูกออกแบบตามความต้องการ เข้าถึงข้อมูลจากฐานข้อมูล * เช่น ระยะสั่งให้เลื่อนแท่นกด เป็นต้น * ----------------------------------------------------------------------------------------*/ /* ---------------------------------------------- * Graph scaling * ----------------------------------------------*/ GraphHorizontalFrom = CONUnseatedTop - CONHeight; GraphHorizontalTo = GraphHorizontalFrom - GraphDistance; // GraphVerticalFrom = 0; GraphVerticalTo = GraphFPerPin; // GraphForceLimit = MaxFPerPin / 2 + MinFPerPin / 2; GraphHeightLimit = 0; // /* ---------------------------------------------- * Height parameters * ----------------------------------------------*/ GotoZeroSpeed = Properties.Settings.Default.GotoZeroSpeed; // mm per sec ZeroClearance = Properties.Settings.Default.ZeroClearance; //mm ZeroHeight = Properties.Settings.Default.ZeroHeight; // mm // /* ---------------------------------------------- * Distance parameters * ----------------------------------------------*/ UnseatedToolTop = FixtureThickness + BoardThickness + CONUnseatedTop - CONHeight + CONBaseThickness + ToolHeight; Distance_UnseatedToolTop = ZeroHeight - UnseatedToolTop; AboveBoardBaseHeight = CONUnseatedTop - CONHeight; Distance_Seated = AboveBoardBaseHeight - CONSeatedHeight; // /* ---------------------------------------------- * Profiled distance parameters * เครื่องหมาย (-) ให้กำหนดระยะ Jog แบบทิศขึ้นเป็น (-) * ----------------------------------------------*/ PF_Row0_Distance = Distance_UnseatedToolTop - Properties.Settings.Default.OffsetTopDistance; PF_Row1_Distance = Properties.Settings.Default.OffsetTopDistance - H1Par; PF_Row2_Distance = Distance_Seated - H2Par + H1Par; PF_Row3_Distance = Distance_Seated - H3Par + H1Par; PF_Row4_Distance = Distance_Seated - H4Par + H1Par; PF_Row5_Distance = Distance_Seated - H5Par + H1Par; PF_Row6_Distance = Distance_Seated - H6Par + H1Par; PF_Row7_Distance = Distance_Seated - H7Par + H1Par; // /* ---------------------------------------------- * Profiled distance parameters * ----------------------------------------------*/ PF_Row1_Force = F1Par; PF_Row2_Force = MinFPerPin * NumberOfPins + F2Par; PF_Row3_Force = MaxFPerPin * NumberOfPins + F3Par; PF_Row4_PARS = F4Par; PF_Row5_Force = F5Par; PF_Row6_Force = MaxFPerPin * NumberOfPins + F6Par; PF_Row7_Grad = F7Par; // }