private string transProcessNo(string _kind, string _no)
{
string sql = @"select min(s.proc_no) from tb_gi_process s where s.proc_std = '" + _kind + "' and proc_no > " + _no;
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
object maxVal = m.dbRonlyOne(sql, ref msg);
if (msg != "OK" || maxVal == null || string.IsNullOrEmpty(maxVal.ToString()))
{
return(getProcessNo(_kind));
}
sql = @"select max(s.proc_no) from tb_gi_process s where s.proc_std = '" + _kind + "' and proc_no < " + _no;
m = new MariaCRUD();
object minVal = m.dbRonlyOne(sql, ref msg);
if (msg != "OK" || minVal == null || string.IsNullOrEmpty(minVal.ToString()))
{
minVal = 0;
}
int q = Int32.Parse(minVal.ToString()) + (Int32.Parse(maxVal.ToString()) - Int32.Parse(minVal.ToString())) / 2;
return(q.ToString());
}
private string getCode()
{
string sql = @"select UF_ClaimNoGenerator()";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
return m.dbRonlyOne(sql, ref msg).ToString();
}
private string getUserID()
{
string sql = @"select UF_UserIDGenerator()";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
return(m.dbRonlyOne(sql, ref msg).ToString());
}
private string getCommonCode(string _kind)
{
string sql = @"select UF_CommonCodeGenerator('" + _kind + "')";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
return(m.dbRonlyOne(sql, ref msg).ToString());
}
private string getProdCode(string _gubun)
{
string sql = @"select UF_ProdCodeGenerator('" + _gubun + "')";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
return(m.dbRonlyOne(sql, ref msg).ToString());
}
private string getDeliNo()
{
string sql = @"select UF_DeliveryNoGenerator('" + G.Pos + "')";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
return(m.dbRonlyOne(sql, ref msg).ToString());
}
private string getROrderSeq(string sNo)
{
string sql = @"select UF_ROrderSeqGenerator('" + sNo + "')";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
return(m.dbRonlyOne(sql, ref msg).ToString());
}
private void FormLogin_Load(object sender, EventArgs e)
{
//if (!IsRunningAsAdministrator())
//{
// ProcessStartInfo processStartInfo = new ProcessStartInfo(Assembly.GetEntryAssembly().CodeBase);
// {
// var withBlock = processStartInfo;
// withBlock.UseShellExecute = true;
// withBlock.Verb = "runas";
// Process.Start(processStartInfo);
// Application.Exit();
// }
//}
//
timer1.Start();
lblMsg.Text = "";
string sql = @"select com_name from tb_sys_pos where pos = 'A'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
string com = m.dbRonlyOne(sql, ref msg).ToString();
if (msg == "OK")
{
lblCompany.Text = com;
}
else
{
lblCompany.Text = "";
}
sql = @"select user_id, concat(user_name, if(authority='B',' (관리자)','')) as user_name from tb_sys_user where user_flag = 1 order by authority, user_id";
DataTable table = m.dbDataTable(sql, ref msg);
if (msg == "OK")
{
cbID.DataSource = table;
cbID.ValueMember = "user_id";
cbID.DisplayMember = "user_name";
}
string ID = string.Empty;
if (ReadRegistry(ref ID))
{
cbID.SelectedValue = ID;
}
}
private bool isExist(string _pos, string _ho, string _name, string _group)
{
string sql = @"select machine_id from tb_machinecard where pos = '" + _pos + "' and machine_no = '" + _ho + "' and machine_name = '" + _name + "' and model_no = '" + _group + "'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
object id = m.dbRonlyOne(sql, ref msg);
if (msg == "OK" && id != null)
{
return(true);
}
else
{
return(false);
}
}
private bool isCommonItem(string _kind, string _item)
{
string sql = @"select co_code from tb_gi_common where co_kind = '" + _kind + "' and co_item = '" + _item + "'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
object id = m.dbRonlyOne(sql, ref msg);
if (msg == "OK" && id != null)
{
return(true);
}
else
{
return(false);
}
}
private bool isUserID(string ID)
{
string sql = @"select user_id from tb_sys_user where user_id = '" + ID + "'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
object id = m.dbRonlyOne(sql, ref msg);
if (msg == "OK" && id != null)
{
return(true);
}
else
{
return(false);
}
}
private void pbLogo_Click(object sender, EventArgs e)
{
string sql = "select homepage from tb_sys_pos where pos = '" + G.Pos + "'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
string url = m.dbRonlyOne(sql, ref msg).ToString();
if (msg == "OK" && !string.IsNullOrEmpty(url))
{
if (!url.Contains("http"))
{
url = "http://" + url;
}
System.Diagnostics.Process.Start(url);
}
}
private bool isProdName(string _gubun, string _prodName)
{
string sql = @"select prod_id from tb_gi_product where gubun = '" + _gubun + "' and prod_name = '" + _prodName + "'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
object id = m.dbRonlyOne(sql, ref msg);
if (msg == "OK" && id != null)
{
return(true);
}
else
{
return(false);
}
}
private bool isCustName(string _custName)
{
string sql = @"select cust_id from tb_gi_customer where fullname = '" + _custName + "' or abbname = '" + _custName + "'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
object id = m.dbRonlyOne(sql, ref msg);
if (msg == "OK" && id != null)
{
return(true);
}
else
{
return(false);
}
}
private bool isPdCloseExist(string _pos, string _date, string _depot, string _prod)
{
string sql = @"select prod_id from tb_gi_pdclose where pos = '" + _pos + "' and close_date = '" + _date + "' and depot = '" + _depot + "' and prod_id = '" + _prod + "'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
object id = m.dbRonlyOne(sql, ref msg);
if (msg == "OK" && id != null)
{
return(true);
}
else
{
return(false);
}
}
private bool isExist(string _kind, string _no)
{
string sql = @"select proc_no from tb_gi_process where proc_std = '" + _kind + "' and proc_no = " + _no;
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
object id = m.dbRonlyOne(sql, ref msg);
if (msg == "OK" && id != null)
{
return(true);
}
else
{
return(false);
}
}
private void pbPrint_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
string sNo = tbNo.Text;
if (string.IsNullOrEmpty(sNo))
{
lblMsg.Text = "저장된 출하건만 명세서 출력이 가능합니다.";
return;
}
sP_Delivery_PrintTableAdapter.Fill(dataSetP1B.SP_Delivery_Print, sNo);
string sql = @"select sum(amount+vat) from tb_delivery_sub where deli_id = '" + sNo + "'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
long lTotAmount = long.Parse(m.dbRonlyOne(sql, ref msg).ToString());
//
string reportFileName = "SmartMES_SinMyung.Reports.P1B05_DELIVERY.rdlc";
string reportParm1 = "합계금액 : ";
reportParm1 = reportParm1 + new MyClass().Number2Hangle(lTotAmount) + " 원정";
ViewReport_V viewReport = new ViewReport_V();
viewReport.reportViewer1.ProcessingMode = ProcessingMode.Local;
viewReport.reportViewer1.LocalReport.ReportEmbeddedResource = reportFileName;
ReportParameter rp1 = new ReportParameter("ReportParameter1", reportParm1);
viewReport.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1 });
ReportDataSource rds = new ReportDataSource("DataSet1", sPDeliveryPrintBindingSource);
viewReport.reportViewer1.LocalReport.DataSources.Add(rds);
viewReport.reportViewer1.LocalReport.Refresh();
viewReport.ShowDialog();
}
private void btnOk_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
string sql = @"select count(*) from tb_prod_result " +
"where job_no = '" + tbJobNo.Text + "' and jobtime_finish is not null";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
string com = m.dbRonlyOne(sql, ref msg).ToString();
if (msg == "OK" && Int32.Parse(com) > 0)
{
Save("1");
}
else
{
lblMsg.Text = "생산 진행중인 LotNo.로 생산종료할 수 없습니다.";
return;
}
}
private string getSeq(string _mid)
{
string sql = @"select seq from tb_machine_repair where machine_id = " + _mid + " order by seq desc limit 1";
MariaCRUD m = new MariaCRUD();
try
{
string msg = string.Empty;
string seq = m.dbRonlyOne(sql, ref msg).ToString();
seq = (Int32.Parse(seq) + 1).ToString();
return(seq);
}
catch (NullReferenceException)
{
return("1");
}
}
private void Save()
{
lblMsg.Text = "";
if (tbProd.Tag == null)
{
lblMsg.Text = "품목명을 선택해 주세요.";
lblProd.Focus();
return;
}
string sProd = tbProd.Tag.ToString();
string sQty = tbQty.Text.Replace(",", "").Trim();
if (String.IsNullOrEmpty(sQty))
{
lblMsg.Text = "조정수량을 입력해 주세요.";
tbQty.Focus();
return;
}
if (sQty.Substring(0, 1) == "-")
{
DialogResult dr = MessageBox.Show("0보다 적은 수량을 입력했습니다.\r\r조정수량을 저장하시겠습니까?", this.lblTitle.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
}
string sDate = dtpDate.Value.ToString("yyyy-MM-dd");
string sDepot = cbDepot.SelectedValue.ToString();
string sKind = cbKind.SelectedValue.ToString();
string sContents = tbContents.Text.Trim();
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]")
{
sql = "insert into tb_stock_move (pos, move_date, depot, prod_id, move_kind, move_qty, contents, enter_man) " +
"values('" + G.Pos + "','" + sDate + "','" + sDepot + "','" + sProd + "','" + sKind + "'," + sQty + ",'" + sContents + "','" + G.UserID + "')";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
lblMsg.Text = "저장되었습니다.";
sql = @"select move_id from tb_stock_move order by move_id desc limit 1";
m = new MariaCRUD();
string com = m.dbRonlyOne(sql, ref msg).ToString();
parentWin.ListSearch();
for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++)
{
if (parentWin.dataGridView1.Rows[i].Cells[0].Value.ToString() == com)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
tbProd.Tag = null;
tbProd.Text = string.Empty;
tbQty.Text = string.Empty;
tbContents.Text = string.Empty;
lblMsg.Focus();
}
else
{
sql = "update tb_stock_move " +
"set move_date = '" + sDate + "', depot = '" + sDepot + "', prod_id = '" + sProd + "', move_kind = '" + sKind + "', move_qty = " + sQty + ", contents = '" + sContents + "'" +
" where move_id = " + moveID;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, moveID + " " + sDate + " " + sProd);
parentWin.ListSearch();
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, rowIndex];
parentWin.dataGridView1.Rows[rowIndex].Selected = true;
this.DialogResult = DialogResult.OK;
}
}
private void btnBatch_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
if (dataGridView1.RowCount < 1)
{
return;
}
int iCnt = 0;
int iNoCnt = 0;
string sSujuNo = string.Empty;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if (dataGridView1.Rows[i].Cells[4].Value != null &&
dataGridView1.Rows[i].Cells[4].Value.ToString() == "1")
{
iCnt++;
if (iCnt == 1)
{
sSujuNo = dataGridView1.Rows[i].Cells[0].Value.ToString();
}
else
if (sSujuNo != dataGridView1.Rows[i].Cells[0].Value.ToString())
{
iNoCnt++;
}
}
}
if (iCnt < 1)
{
MessageBox.Show("작업지시대상이 선택되지 않았습니다.");
return;
}
if (iNoCnt > 0)
{
MessageBox.Show("동일 수주건만 선택 가능합니다.");
return;
}
//
string sql;
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
string sProc = cbProcStd.SelectedValue.ToString();
string sDate = dtpDate.Value.ToString("yyyy-MM-dd");
string sProd = string.Empty;
string sName = string.Empty;
string sSize = string.Empty;
string sSujuSeq = string.Empty;
string sPart = cbPart.Text.Substring(0, 1);
string sQty = string.Empty;
string sSujuQty = sQty;
string sqlQty;
MariaCRUD mQty;
string msgQty = string.Empty;
string com;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if (dataGridView1.Rows[i].Cells[4].Value != null &&
dataGridView1.Rows[i].Cells[4].Value.ToString() == "1")
{
sSujuNo = dataGridView1.Rows[i].Cells[0].Value.ToString();
sProd = dataGridView1.Rows[i].Cells[6].Value.ToString();
sName = dataGridView1.Rows[i].Cells[8].Value.ToString();
sSize = dataGridView1.Rows[i].Cells[9].Value.ToString();
sSujuSeq = dataGridView1.Rows[i].Cells[5].Value.ToString();
sQty = dataGridView1.Rows[i].Cells[10].Value.ToString();
//
sqlQty = "select qty from vw_rorder where rorder_id = '" + sSujuNo + "' and rorder_seq = " + sSujuSeq;
mQty = new MariaCRUD();
com = mQty.dbRonlyOne(sqlQty, ref msgQty).ToString();
if (msgQty == "OK")
{
sSujuQty = com;
}
//
sql = "insert into tb_prod_order (job_no, proc_no, pos, lot_date, prod_id, add_name, add_size, rorder_id, rorder_seq, proc_std, rorder_date, job_part, order_qty, enter_man) " +
"select '" + getCode() + "',p.proc_no,'" + G.Pos + "','" + sDate + "','" + sProd + "','" + sName + "','" + sSize + "','" + sSujuNo + "'," + sSujuSeq + ",'" + sProc + "','" + sDate + "','" + sPart + "'," + sSujuQty + " - ifnull((select sum(v.gd_qty) from vw_production v where v.rorder_id = '" + sSujuNo + "' and v.rorder_seq = " + sSujuSeq + " and v.proc_no = p.proc_no),0),'" + G.UserID + "' " +
"from tb_gi_process p where p.proc_std = '" + sProc + "' order by p.proc_no";
//m = new MariaCRUD();
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
//
}
}
parentWin.ListSearch();
this.Dispose();
}
private void Save()
{
lblMsg.Text = "";
if (tbProd.Tag == null)
{
lblMsg.Text = "자재명을 선택해 주세요.";
lblProd.Focus();
return;
}
string sProd = tbProd.Tag.ToString();
string sQty = tbQty.Text.Replace(",", "").Trim();
if (String.IsNullOrEmpty(sQty))
{
lblMsg.Text = "소모량을 입력해 주세요.";
tbQty.Focus();
return;
}
string sDate = dtpDate.Value.ToString("yyyy-MM-dd");
string sDepot = cbDepot.SelectedValue.ToString();
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]")
{
sql = "insert into tb_material_use (pos, prod_date, prod_id, use_qty, depot, enter_man) " +
"values('" + G.Pos + "','" + sDate + "','" + sProd + "'," + sQty + ",'" + sDepot + "','" + G.UserID + "')";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
lblMsg.Text = "저장되었습니다.";
sql = @"select use_id from tb_material_use order by use_id desc limit 1";
m = new MariaCRUD();
string com = m.dbRonlyOne(sql, ref msg).ToString();
parentWin.ListSearch();
for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++)
{
if (parentWin.dataGridView1.Rows[i].Cells[0].Value != null &&
!string.IsNullOrEmpty(parentWin.dataGridView1.Rows[i].Cells[0].Value.ToString()) &&
parentWin.dataGridView1.Rows[i].Cells[0].Value.ToString() == com)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
tbProd.Tag = null;
tbProd.Text = string.Empty;
tbQty.Text = string.Empty;
lblMsg.Focus();
}
else
{
sql = "update tb_material_use " +
"set prod_date = '" + sDate + "', prod_id = '" + sProd + "', use_qty = " + sQty + ", depot = '" + sDepot + "'" +
" where use_id = " + useID;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, useID + " " + sDate + " " + sProd);
parentWin.ListSearch();
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, rowIndex];
parentWin.dataGridView1.Rows[rowIndex].Selected = true;
this.DialogResult = DialogResult.OK;
}
}
private void pbDel_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
if (G.Authority == "D")
{
return;
}
if (dataGridView1.RowCount == 0)
{
return;
}
int index = 0;
string sLotNo = string.Empty;
try
{
index = dataGridView1.CurrentRow.Index;
sLotNo = dataGridView1.Rows[index].Cells[1].Value.ToString();
if (dataGridView1.Rows[index].Selected != true)
{
MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
catch (NullReferenceException)
{
MessageBox.Show("삭제 정보가 선택되지 않았습니다.", this.lblTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DialogResult dr = MessageBox.Show("LotNo. : " + sLotNo + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
string sql = @"select count(job_no) from tb_prod_result where job_no = '" + sLotNo + "'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
string com = m.dbRonlyOne(sql, ref msg).ToString();
if (msg == "OK" && Int32.Parse(com) > 0)
{
MessageBox.Show("실적처리된 Lot번호는 삭제할 수 없습니다.");
return;
}
sql = "delete from tb_prod_order where job_no = '" + sLotNo + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sLotNo);
ListSearch();
}
private void Save()
{
lblMsg.Text = "";
if (tbProd.Tag == null)
{
lblMsg.Text = "품목명을 선택해 주세요.";
lblProd.Focus();
return;
}
string sQty = tbQty.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sQty))
{
lblMsg.Text = "지시수량을 입력해 주세요.";
tbQty.Focus();
return;
}
string sDate = dtpDate.Value.ToString("yyyy-MM-dd");
string sPart = cbPart.Text.Substring(0, 1);
string sProd = tbProd.Tag.ToString();
string sName = tbName.Text.Trim();
string sSize = tbSize.Text.Trim();
string sProc = cbProcStd.SelectedValue.ToString();
string sJobNo = getCode();
string sSujuQty = sQty;
if (string.IsNullOrEmpty(rorderSeq))
{
rorderSeq = "null";
}
else
{
string sqlQty = "select qty from vw_rorder where rorder_id = '" + rorderID + "' and rorder_seq = " + rorderSeq;
MariaCRUD mQty = new MariaCRUD();
string msgQty = string.Empty;
string com = mQty.dbRonlyOne(sqlQty, ref msgQty).ToString();
if (msgQty == "OK")
{
sSujuQty = com;
}
}
string sql = "insert into tb_prod_order (job_no, proc_no, pos, lot_date, prod_id, add_name, add_size, rorder_id, rorder_seq, proc_std, rorder_date, job_part, order_qty, enter_man) " +
"select '" + sJobNo + "',p.proc_no,'" + G.Pos + "','" + sDate + "','" + sProd + "','" + sName + "','" + sSize + "','" + rorderID + "'," + rorderSeq + ",'" + sProc + "','" + sDate + "','" + sPart + "'," + sSujuQty + " - ifnull((select sum(v.gd_qty) from vw_production v where v.rorder_id = '" + rorderID + "' and v.rorder_seq = " + rorderSeq + " and v.proc_no = p.proc_no),0),'" + G.UserID + "' " +
"from tb_gi_process p where p.proc_std = '" + sProc + "' order by p.proc_no";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
lblMsg.Text = "저장되었습니다.";
parentWin.ListSearch();
for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++)
{
if (parentWin.dataGridView1.Rows[i].Cells[1].Value.ToString() == sJobNo)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
parentWin.LotSearch(sJobNo);
break;
}
}
tbJobNo.Text = getCode();
tbProd.Tag = null;
tbProd.Text = string.Empty;
tbName.Text = string.Empty;
tbSize.Text = string.Empty;
tbQty.Text = string.Empty;
}
private void btnStart_Click(object sender, EventArgs e)
{
string sql = @"select max(idle_seq) from tb_prod_idle where job_no = '" + jobNo + "' and proc_no = " + procNo + " and machine_id = " + facID;
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
seq = m.dbRonlyOne(sql, ref msg).ToString();
if (msg != "OK" || string.IsNullOrEmpty(seq))
{
seq = "1";
}
else
{
seq = (Int32.Parse(seq) + 1).ToString();
}
string sItem = lbIdleList.SelectedValue.ToString();
string sStart = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
sql = "insert into tb_prod_idle (job_no, proc_no, machine_id, idle_seq, idle_item, idle_start, enter_man) " +
"values('" + jobNo + "'," + procNo + "," + facID + "," + seq + ",'" + sItem + "','" + sStart + "','" + G.UserID + "')";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
this.lblMsg.Text = msg;
return;
}
DateTime dtDate = DateTime.Parse(parentWin.dtpDate.Value.ToString("yyyy-MM-dd"));
string sPart = parentWin.cbPart.Text.Substring(0, 1);
if (sGroup == "A")
{
parentWin.sP_ProdResult_QueryATableAdapter.Fill(parentWin.dataSetP1C.SP_ProdResult_QueryA, dtDate, sPart, sGroup);
}
else if (sGroup == "B")
{
parentWin.sP_ProdResult_QueryBTableAdapter.Fill(parentWin.dataSetP1C.SP_ProdResult_QueryB, dtDate, sPart, sGroup);
}
else if (sGroup == "C")
{
parentWin.sP_ProdResult_QueryCTableAdapter.Fill(parentWin.dataSetP1C.SP_ProdResult_QueryC, dtDate, sPart, sGroup);
}
else if (sGroup == "D")
{
parentWin.sP_ProdResult_QueryDTableAdapter.Fill(parentWin.dataSetP1C.SP_ProdResult_QueryD, dtDate, sPart, sGroup);
}
else if (sGroup == "E")
{
parentWin.sP_ProdResult_QueryETableAdapter.Fill(parentWin.dataSetP1C.SP_ProdResult_QueryE, dtDate, sPart, sGroup);
}
Label lblMsg = parentWin.Controls.Find("lblMsg" + sGroup, true).FirstOrDefault() as Label;
DataGridView dataGridView = parentWin.Controls.Find("dataGridView" + sGroup, true).FirstOrDefault() as DataGridView;
int rowIndex = 0;
for (int i = 0; i < dataGridView.Rows.Count; i++)
{
if (dataGridView.Rows[i].Cells[0].Value.ToString() == jobNo &&
dataGridView.Rows[i].Cells[1].Value.ToString() == facID &&
dataGridView.Rows[i].Cells[20].Value.ToString() == procNo)
{
dataGridView.CurrentCell = dataGridView[3, i];
dataGridView.CurrentCell.Selected = true;
rowIndex = i;
break;
}
}
parentWin.SettingValues(sGroup, rowIndex);
lblMsg.Text = "비가동시작되었습니다.";
this.DialogResult = DialogResult.OK;
}
