private bool SaveMain(Ins_Record ir)
{
bool bRet = false;
string ins_SQL_MAIN = SQL_TEXT.I_NEW_INS_MAIN;
ins_SQL_MAIN = ins_SQL_MAIN.Replace(":INS_NO", lbINS_NO.Text);
ins_SQL_MAIN = ins_SQL_MAIN.Replace(":ART_NO", tbART_NO.Text);
ins_SQL_MAIN = ins_SQL_MAIN.Replace(":EQP_NO", cbEQP.Text);
ins_SQL_MAIN = ins_SQL_MAIN.Replace(":LENGTH", tbTotalYard.Text);
ins_SQL_MAIN = ins_SQL_MAIN.Replace(":OPLENGTH", ir.LENGTH);
ins_SQL_MAIN = ins_SQL_MAIN.Replace(":PTS", ir.POINT);
ins_SQL_MAIN = ins_SQL_MAIN.Replace(":GRADE", ir.GRADE);
ins_SQL_MAIN = ins_SQL_MAIN.Replace(":REMARK", tbAllMark.Text);
ins_SQL_MAIN = ins_SQL_MAIN.Replace(":SPONSOR", cbSpr.Text);
ins_SQL_MAIN = ins_SQL_MAIN.Replace(":GRP", ir.GRP);
try
{
dbTool.ExecData(ins_SQL_MAIN);
bRet = true;
}
catch (Exception ex)
{
}
return(bRet);
}
private bool SaveReasonDetail(Ins_Record ir)
{
bool bRet = false;
string ins_SQL_DETAIL_FINAL = string.Empty;
string ins_SQL_DETAIL_1 = SQL_TEXT.I_NEW_INS_DETAIL_1;
ins_SQL_DETAIL_FINAL = ins_SQL_DETAIL_1;
DataTable dtRTmp = ir.dtREASON;
for (int i = 0; i < dtRTmp.Rows.Count; i++)
{
string ins_SQL_DETAIL_2 = SQL_TEXT.I_NEW_INS_DETAIL_2;
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":INS_NO", lbINS_NO.Text);
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":CHK_PT", dtRTmp.Rows[i][1].ToString());
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":REASON_CODE", (dtRTmp.Rows[i][2].ToString()).Substring(0, 1));
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":REMARK", dtRTmp.Rows[i][4].ToString());
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":SHIFT", dtRTmp.Rows[i][0].ToString());
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":GRP", ir.GRP);
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":PTS", dtRTmp.Rows[i][3].ToString());
if (i == dtRTmp.Rows.Count - 1)
{
ins_SQL_DETAIL_FINAL = ins_SQL_DETAIL_FINAL + ins_SQL_DETAIL_2;
}
else
{
ins_SQL_DETAIL_FINAL = ins_SQL_DETAIL_FINAL + ins_SQL_DETAIL_2 + " UNION ALL ";
}
}
try
{
if (dtRTmp.Rows.Count > 0)
{
dbTool.ExecData(ins_SQL_DETAIL_FINAL);
bRet = true;
}
else
{
bRet = true;
}
//MessageBox.Show(lbINS_NO.Text + " 儲存成功!");
//CreateNo(gpMode);
//this.Close();
}
catch (Exception ex)
{
//MessageBox.Show("儲存失敗!");
}
return(bRet);
}
private bool SaveMainOutput(Ins_Record ir)
{
bool bRet = false;
DataTable dtTmp = ir.dtOUTPUT;
string ins_SQL_DETAIL_FINAL = string.Empty;
string I_DETAAIL_OUTPUT_1 = SQL_TEXT.I_NEW_INS_DETAIL_OUTPUT_1;
for (int i = 0; i < dtTmp.Rows.Count; i++)
{// ':INS_NO',':SHIFT',':GRP',':sYard',':eYard'
string ins_SQL_DETAIL_2 = SQL_TEXT.I_NEW_INS_DETAIL_OUTPUT_2;
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":INS_NO", lbINS_NO.Text);
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":SHIFT", dtTmp.Rows[i][0].ToString());
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":GRP", ir.GRP);
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":sYard", dtTmp.Rows[i][1].ToString());
ins_SQL_DETAIL_2 = ins_SQL_DETAIL_2.Replace(":eYard", dtTmp.Rows[i][2].ToString());
if (i == dtTmp.Rows.Count - 1)
{
ins_SQL_DETAIL_FINAL = ins_SQL_DETAIL_FINAL + ins_SQL_DETAIL_2;
}
else
{
ins_SQL_DETAIL_FINAL = ins_SQL_DETAIL_FINAL + ins_SQL_DETAIL_2 + " UNION ALL ";
}
}
try
{
ins_SQL_DETAIL_FINAL = I_DETAAIL_OUTPUT_1 + ins_SQL_DETAIL_FINAL;
dbTool.ExecData(ins_SQL_DETAIL_FINAL);
bRet = true;
//MessageBox.Show(lbINS_NO.Text + " 儲存成功!");
//CreateNo(gpMode);
//this.Close();
}
catch (Exception ex)
{
//MessageBox.Show("儲存失敗!");
}
return(bRet);
}
private void SummaryData()
{
lIR.Clear();
for (int i = 1; i <= 4; i++)
{
int TotalPts = 0;
string Grade = "";
DataGridView dgvProc = (DataGridView)this.Controls.Find("dgvR" + i, true)[0];
DataGridView dgvOProc = (DataGridView)this.Controls.Find("dgvO" + i, true)[0];
Label lbPts = (Label)this.Controls.Find("lbPts" + i, true)[0];
Label lbG = (Label)this.Controls.Find("lbG" + i, true)[0];
Label lbY = (Label)this.Controls.Find("lbY" + i, true)[0];
if (dgvOProc.DataSource != null)
{
Ins_Record ir = new Ins_Record();
ir.INS_NO = lbINS_NO.Text;
ir.GRP = i.ToString();
ir.dtOUTPUT = (DataTable)dgvOProc.DataSource;
DataTable dtOTmp = (DataTable)dgvOProc.DataSource;
if (dgvProc.DataSource != null)
{
ir.dtREASON = (DataTable)dgvProc.DataSource;
DataTable dtTmp = (DataTable)dgvProc.DataSource;
foreach (DataRow dr in dtTmp.Rows)
{
TotalPts = TotalPts + Convert.ToInt32(dr[3].ToString());
}
lbPts.Text = TotalPts.ToString();
ir.POINT = TotalPts.ToString();
if (TotalPts >= 0)
{
if (TotalPts <= 18)
{
Grade = "A";
lbG.ForeColor = Color.Blue;
}
else if (TotalPts > 18 && TotalPts <= 24)
{
Grade = "B";
lbG.ForeColor = Color.Orange;
}
else if (TotalPts > 24)
{
Grade = "C";
lbG.ForeColor = Color.Red;
}
lbG.Text = Grade;
ir.GRADE = Grade;
}
}
else
{
lbG.Text = "A";
ir.GRADE = lbG.Text;
lbG.ForeColor = Color.Blue;
lbPts.Text = "0";
ir.POINT = TotalPts.ToString();
}
if (dtOTmp.Rows.Count > 0)
{
lbY.Text = dtOTmp.Rows[dtOTmp.Rows.Count - 1][2].ToString();
}
else
{
lbY.Text = "0";
}
ir.LENGTH = lbY.Text;
if (dtOTmp.Rows.Count > 0)
{
lIR.Add(ir);
}
}
else
{
}
}
}
private void LoadINS_Detail(string INS_NO)
{
string ssql = SQL_TEXT.Q_INS_MAIN_OUTPUT;
string ssql2 = SQL_TEXT.Q_INS_MAIN_REASON;
ssql = ssql.Replace(":INS_NO", INS_NO);
ssql2 = ssql2.Replace(":INS_NO", INS_NO);
string sDT = dateTimePicker1.Value.ToString("yyyyMMdd");
// dgvINS.Rows.Clear();
DataTable dtORet = dbTool.QueryData(ssql);
DataTable dtRRet = dbTool.QueryData(ssql2);
lbINS_LIST.Text = sDT + " 單號:";
lIR.Clear();
if (dtORet.Rows.Count > 0)
{
for (int i = 0; i < 4; i++)
{
Ins_Record ir = new Ins_Record();
string[] INS = (dtORet.Rows[0]["INS_NO"].ToString()).Split('_');
ir.INS_NO = dtORet.Rows[0]["INS_NO"].ToString();
ir.ART_NO = INS[1];
ir.EQP = INS[2];
ir.Sponsor = dtORet.Rows[0]["Sponsor"].ToString();
ir.OUT_LENGTH = dtORet.Rows[0]["LENGTH"].ToString();
ir.ALL_REMARK = dtORet.Rows[0]["REMARK"].ToString();
ir.OUT_SHIFT = dtORet.Rows[0]["OUT_SHIFT"].ToString();
ir.GRP = (i + 1).ToString();
DataRow[] foundRows = dtORet.Select("GRP=" + (i + 1).ToString(), "sYard ASC");
if (foundRows.Length > 0)
{
DataTable dtOTmp = ir.dtOUTPUT;
ir.GRADE = foundRows[0]["GRADE"].ToString();
ir.LENGTH = foundRows[0]["LENGTH_OUTPUT"].ToString();
ir.POINT = foundRows[0]["PTS"].ToString();
for (int j = 0; j < foundRows.Length; j++)
{
DataRow drOTmp = dtOTmp.NewRow();
drOTmp[0] = foundRows[j][10].ToString();
drOTmp[1] = foundRows[j][12].ToString();
drOTmp[2] = foundRows[j][13].ToString();
drOTmp[3] = (Convert.ToInt32(foundRows[j][13].ToString()) - Convert.ToInt32(foundRows[j][12].ToString()) + 1).ToString();
dtOTmp.Rows.Add(drOTmp);
}
}
DataRow[] foundRRows = dtRRet.Select("GRP=" + (i + 1).ToString(), "CHK_PT ASC");
if (foundRRows.Length > 0)
{
DataTable dtRTmp = ir.dtREASON;
for (int j = 0; j < foundRRows.Length; j++)
{
DataRow drRTmp = dtRTmp.NewRow();
drRTmp[0] = foundRRows[j][14].ToString();
drRTmp[1] = foundRRows[j][10].ToString();
drRTmp[2] = foundRRows[j][11].ToString();
drRTmp[3] = foundRRows[j][7].ToString();
drRTmp[4] = foundRRows[j][12].ToString();
dtRTmp.Rows.Add(drRTmp);
}
}
lIR.Add(ir);
}
FillContent();
}
}