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;
//
}
