private void pbSave_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
string sHo = tbHo.Text.Trim();
string sName = tbName.Text.Trim();
if (String.IsNullOrEmpty(sHo))
{
lblMsg.Text = "호기를 입력해 주세요.";
tbHo.Focus();
return;
}
if (String.IsNullOrEmpty(sName))
{
lblMsg.Text = "설비명을 입력해 주세요.";
tbName.Focus();
return;
}
string sID = lblID.Text.Substring(6, lblID.Text.Length - 6);
string sModel = cbGroup.SelectedValue.ToString();
string sMadeCom = tbMadeCom.Text.Trim();
string sMadeDate = tbMadeDate.Text.Trim();
string sBuyCom = tbBuyCom.Text.Trim();
string sBuyDate = tbBuyDate.Text.Trim();
string sMoney = tbMoney.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sMoney))
{
sMoney = "NULL";
}
string sLocation = tbLocation.Text.Trim();
string sCharge = cbCharge.Text.Trim();
string sAsCom = tbAsCom.Text.Trim();
string sSpec = tbSpec.Text.Trim();
string sIP = tbIP.Text.Trim();
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
if (Int32.Parse(sID) == 0) //추가
{
if (isExist(G.Pos, sHo, sName, sModel))
{
lblMsg.Text = "이미 존재하는 설비정보입니다.";
lblID.Focus();
return;
}
sql = "insert into tb_machinecard " +
"(pos, model_no, machine_name, machine_no, made_com, made_date, buy_com, buy_date, buy_money, location, charge, as_com, machine_spec, ip, enter_man) " +
"values('" + G.Pos + "','" + sModel + "','" + sName + "','" + sHo + "','" + sMadeCom + "','" + sMadeDate + "','" + sBuyCom + "','" + sBuyDate + "'," + sMoney + ",'" + sLocation + "','" + sCharge + "','" + sAsCom + "','" + sSpec + "','" + sIP + "','" + G.UserID + "')";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
ListSearch();
lblMsg.Text = "저장되었습니다.";
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
if (dataGridView1.Rows[i].Cells[1].Value.ToString() == sHo &&
dataGridView1.Rows[i].Cells[2].Value.ToString() == sName &&
dataGridView1.Rows[i].Cells[3].Value.ToString() == sModel)
{
dataGridView1.CurrentCell = dataGridView1[1, i];
dataGridView1.CurrentCell.Selected = true;
sID = dataGridView1.Rows[i].Cells[0].Value.ToString();
lblID.Text = "관리No. " + sID;
break;
}
}
}
else //수정
{
sql = "update tb_machinecard " +
"set model_no = '" + sModel + "', machine_name = '" + sName + "', machine_no = '" + sHo + "', made_com = '" + sMadeCom + "', made_date = '" + sMadeDate + "', buy_com = '" + sBuyCom + "', buy_date = '" + sBuyDate + "', buy_money = " + sMoney + ", location = '" + sLocation + "', charge = '" + sCharge + "', as_com = '" + sAsCom + "', machine_spec = '" + sSpec + "', ip = '" + sIP + "'" +
" where machine_id = " + sID;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sID + " " + sHo + " " + sName + " " + sModel);
ListSearch();
lblMsg.Text = "저장되었습니다.";
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
if (dataGridView1.Rows[i].Cells[0].Value.ToString() == sID)
{
dataGridView1.CurrentCell = dataGridView1[1, i];
dataGridView1.CurrentCell.Selected = true;
break;
}
}
}
FacilityImageSave(sID);
txtPath.Text = "";
}
private void pbSave_Click(object sender, EventArgs e)
{
if (G.Authority == "D")
{
return;
}
dataGridView1.CurrentCell = dataGridView1[4, 0];
lblMsg.Text = "";
if (tbCust.Tag == null || string.IsNullOrEmpty(tbCust.Tag.ToString()))
{
lblMsg.Text = "거래처명을 선택해 주세요.";
lblCust.Focus();
return;
}
int iCnt = 0;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if (!(dataGridView1.Rows[i].Cells[2].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[i].Cells[2].Value.ToString())))
{
iCnt++;
}
}
if (iCnt == 0)
{
lblMsg.Text = "품목정보를 확인해 주세요.";
dataGridView1.Focus();
return;
}
//
string sNo = tbNo.Text;
string sDate = dtpDate.Value.ToString("yyyy-MM-dd");
string sCust = tbCust.Tag.ToString();
string sCustName = tbCust.Text;
string sProject = tbCust.Text + "의 건";
string sPlace = tbPlace.Text.Trim();
string sDeliDate = dtpDeliDate.Value.ToString("yyyy-MM-dd");
string sContents = tbContents.Text.Trim();
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
string sSeq = string.Empty;
string sProdID = string.Empty;
string sAddSize = string.Empty;
string sAddName = string.Empty;
string sQty = string.Empty;
string sWeight = string.Empty;
string sDanga = string.Empty;
string sCost1 = string.Empty;
string sCost2 = string.Empty;
string sAmount = string.Empty;
string sDocNo = string.Empty;
string sProdNo = string.Empty;
string sMatKind = string.Empty;
string sProcStd = "0001";
if (string.IsNullOrEmpty(sNo)) //추가
{
sNo = getROrderNo();
sql = "insert into tb_rorder_main (rorder_id, pos, rorder_date, cust_id, project, place, deli_date, contents, enter_man) " +
"values('" + sNo + "','" + G.Pos + "','" + sDate + "','" + sCust + "','" + sProject + "','" + sPlace + "','" + sDeliDate + "','" + sContents + "','" + G.UserID + "')";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
tbNo.Text = sNo;
int seq = 0;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if (dataGridView1.Rows[i].Cells[2].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[i].Cells[2].Value.ToString()))
{
continue;
}
seq = seq + 10;
sSeq = seq.ToString();
sProdID = dataGridView1.Rows[i].Cells[2].Value.ToString().Trim();
sAddSize = dataGridView1.Rows[i].Cells[5].Value.ToString().Trim();
sAddName = dataGridView1.Rows[i].Cells[6].Value.ToString().Trim();
sQty = dataGridView1.Rows[i].Cells[7].Value.ToString().Trim();
sWeight = dataGridView1.Rows[i].Cells[8].Value.ToString().Trim();
sDanga = dataGridView1.Rows[i].Cells[9].Value.ToString().Trim();
sCost1 = dataGridView1.Rows[i].Cells[10].Value.ToString().Trim();
sCost2 = dataGridView1.Rows[i].Cells[11].Value.ToString().Trim();
sAmount = dataGridView1.Rows[i].Cells[12].Value.ToString().Trim();
sDocNo = dataGridView1.Rows[i].Cells[13].Value.ToString().Trim();
sProdNo = dataGridView1.Rows[i].Cells[14].Value.ToString().Trim();
sMatKind = dataGridView1.Rows[i].Cells[15].Value.ToString().Trim();
if (string.IsNullOrEmpty(sQty))
{
sQty = "0";
}
if (string.IsNullOrEmpty(sWeight))
{
sWeight = "0";
}
if (string.IsNullOrEmpty(sDanga))
{
sDanga = "0";
}
if (string.IsNullOrEmpty(sCost1))
{
sCost1 = "0";
}
if (string.IsNullOrEmpty(sCost2))
{
sCost2 = "0";
}
if (string.IsNullOrEmpty(sAmount))
{
sAmount = "0";
}
sql = "insert into tb_rorder_sub (rorder_id, rorder_seq, prod_id, add_name, add_size, qty, weight, danga, cost1, cost2, amount, doc_no, prod_no, mat_kind, proc_std) " +
"values('" + sNo + "'," + sSeq + ",'" + sProdID + "','" + sAddName + "','" + sAddSize + "'," + sQty + "," + sWeight + "," + sDanga + "," + sCost1 + "," + sCost2 + "," + sAmount + ",'" + sDocNo + "','" + sProdNo + "','" + sMatKind + "','" + sProcStd + "')";
m.dbCUD(sql, ref msg);
}
}
else //수정
{
sql = "update tb_rorder_main " +
"set rorder_date = '" + sDate + "', cust_id = '" + sCust + "', project = '" + sProject + "', place = '" + sPlace + "', deli_date = '" + sDeliDate + "', contents = '" + sContents + "'" +
" where rorder_id = '" + sNo + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if (dataGridView1.Rows[i].Cells[2].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[i].Cells[2].Value.ToString()))
{
continue;
}
sProdID = dataGridView1.Rows[i].Cells[2].Value.ToString().Trim();
sAddSize = dataGridView1.Rows[i].Cells[5].Value.ToString().Trim();
sAddName = dataGridView1.Rows[i].Cells[6].Value.ToString().Trim();
sQty = dataGridView1.Rows[i].Cells[7].Value.ToString().Trim();
sWeight = dataGridView1.Rows[i].Cells[8].Value.ToString().Trim();
sDanga = dataGridView1.Rows[i].Cells[9].Value.ToString().Trim();
sCost1 = dataGridView1.Rows[i].Cells[10].Value.ToString().Trim();
sCost2 = dataGridView1.Rows[i].Cells[11].Value.ToString().Trim();
sAmount = dataGridView1.Rows[i].Cells[12].Value.ToString().Trim();
sDocNo = dataGridView1.Rows[i].Cells[13].Value.ToString().Trim();
sProdNo = dataGridView1.Rows[i].Cells[14].Value.ToString().Trim();
sMatKind = dataGridView1.Rows[i].Cells[15].Value.ToString().Trim();
if (dataGridView1.Rows[i].Cells[1].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[i].Cells[1].Value.ToString()))
{
sSeq = getROrderSeq(sNo);
}
else
{
sSeq = dataGridView1.Rows[i].Cells[1].Value.ToString();
}
if (string.IsNullOrEmpty(sQty))
{
sQty = "0";
}
if (string.IsNullOrEmpty(sWeight))
{
sWeight = "0";
}
if (string.IsNullOrEmpty(sDanga))
{
sDanga = "0";
}
if (string.IsNullOrEmpty(sCost1))
{
sCost1 = "0";
}
if (string.IsNullOrEmpty(sCost2))
{
sCost2 = "0";
}
if (string.IsNullOrEmpty(sAmount))
{
sAmount = "0";
}
sql = "insert into tb_rorder_sub (rorder_id, rorder_seq, prod_id, add_name, add_size, qty, weight, danga, cost1, cost2, amount, doc_no, prod_no, mat_kind, proc_std)" +
" values('" + sNo + "'," + sSeq + ",'" + sProdID + "','" + sAddName + "','" + sAddSize + "'," + sQty + "," + sWeight + "," + sDanga + "," + sCost1 + "," + sCost2 + "," + sAmount + ",'" + sDocNo + "','" + sProdNo + "','" + sMatKind + "','" + sProcStd + "')" +
" on duplicate key update" +
" prod_id = '" + sProdID + "', add_name = '" + sAddName + "', add_size = '" + sAddSize + "', qty = " + sQty + ", weight = " + sWeight + ", danga = " + sDanga + ", cost1 = " + sCost1 + ", cost2 = " + sCost2 + ", amount = " + sAmount + ", doc_no = '" + sDocNo + "', prod_no = '" + sProdNo + "', mat_kind = '" + sMatKind + "', proc_std = '" + sProcStd + "'";
m.dbCUD(sql, ref msg);
}
}
////견적정보 업데이트
//if (!string.IsNullOrEmpty(sEstimateNo))
// estimateUpdate(sEstimateNo);
tbSearch.Text = "";
ListSearch1();
for (int i = 0; i < dataGridViewList.Rows.Count; i++)
{
if (dataGridViewList.Rows[i].Cells[0].Value.ToString() == sNo)
{
dataGridViewList.CurrentCell = dataGridViewList[2, i];
dataGridViewList.CurrentCell.Selected = true;
ListSearch2(i);
ListSearch3();
ListSearch4();
break;
}
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sNo + "-" + tbCust.Text);
lblMsg.Text = "저장되었습니다.";
}
private void Save()
{
lblMsg.Text = "";
string userID, userName, job, phone, authority;
int useFlag = 1;
userID = tbID.Text.Trim();
userName = tbName.Text.Trim();
job = tbJob.Text.Trim();
phone = tbPhone.Text.Trim();
authority = cbAuthority.Text.Substring(0, 1);
if (cbFlag.Checked)
{
useFlag = 0;
}
if (String.IsNullOrEmpty(userID))
{
lblMsg.Text = "사용자ID를 입력해 주세요.";
tbID.Focus();
return;
}
if (String.IsNullOrEmpty(userName))
{
lblMsg.Text = "사용자명을 입력해 주세요.";
tbName.Focus();
return;
}
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]")
{
//입력한 ID가 중복인지 확인..
if (isUserID(userID))
{
lblMsg.Text = "이미 존재하는 사용자ID입니다.";
tbID.Focus();
return;
}
string pwd = "1234";
pwd = new MyClass().EncryptSHA512(pwd);
sql = "insert into tb_sys_user (user_id, user_name, pos, job, user_tel, pwd, authority, user_flag, enter_man) " +
"values('" + userID + "','" + userName + "','A','" + job + "','" + phone + "','" + pwd + "','" + authority + "'," + useFlag.ToString() + ",'" + G.UserID + "')";
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[0].Value.ToString() == userID)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
tbID.Text = getUserID();
tbName.Text = string.Empty;
tbJob.Text = string.Empty;
tbPhone.Text = string.Empty;
tbName.Focus();
}
else
{
sql = "update tb_sys_user " +
"set user_name = '" + userName + "', job = '" + job + "', user_tel = '" + phone + "', authority = '" + authority + "', user_flag = " + useFlag.ToString() +
" where user_id = '" + userID + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, userID);
parentWin.ListSearch();
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, rowIndex];
parentWin.dataGridView1.Rows[rowIndex].Selected = true;
this.DialogResult = DialogResult.OK;
}
}
private void Save()
{
lblMsg.Text = "";
if (string.IsNullOrEmpty(tbDeli.Text))
{
lblMsg.Text = "출하(전표)번호를 입력해 주세요.";
lblDeliID.Focus();
return;
}
if (cbCharge.SelectedValue == null
|| string.IsNullOrEmpty(cbCharge.SelectedValue.ToString()))
{
lblMsg.Text = "책임자를 선택해 주세요.";
cbCharge.Focus();
return;
}
string sCode = tbNo.Text;
string sDeliID = tbDeli.Text;
string sQty = tbQty.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sQty)) sQty = "NULL";
string sClaimDate = dtpClaimDate.Value.ToString("yyyy-MM-dd");
string sClaimContents = tbClaimContents.Text.Trim();
string sActionDate = dtpActionDate.Value.ToString("yyyy-MM-dd");
string sActionContents = tbActionContents.Text.Trim();
string sMoney = tbMoney.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sMoney)) sMoney = "0";
string sCharge = cbCharge.SelectedValue.ToString();
string sState = cbState.Text.Substring(0, 1);
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]")
{
sCode = getCode();
sql = "insert into tb_qc_claim (claim_id, deli_id, claim_qty, claim_date, claim_contents, action_date, action_contents, claim_money, charge, state_flag, enter_man) " +
"values('" + sCode + "','" + sDeliID + "'," + sQty + ",'" + sClaimDate + "','" + sClaimContents + "', IF('" + sActionContents + "' = '',null,'" + sActionDate + "'),'" + sActionContents + "'," + sMoney + ",'" + sCharge + "'," + sState + ",'" + G.UserID + "')";
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[0].Value.ToString() == sCode)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
tbDeli.Text = string.Empty;
tbQty.Text = string.Empty;
tbClaimContents.Text = string.Empty;
tbActionContents.Text = string.Empty;
tbMoney.Text = string.Empty;
}
else
{
sql = "update tb_qc_claim " +
"set deli_id = '" + sDeliID + "', claim_qty = " + sQty + ", claim_date = '" + sClaimDate + "', claim_contents = '" + sClaimContents + "', action_date = IF('" + sActionContents + "' = '',null,'" + sActionDate + "'), action_contents = '" + sActionContents + "', claim_money = " + sMoney + ", charge = '" + sCharge + "', state_flag = " + sState +
" where claim_id = '" + sCode + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sCode + " - " + sDeliID);
parentWin.ListSearch();
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, rowIndex];
parentWin.dataGridView1.Rows[rowIndex].Selected = true;
this.DialogResult = DialogResult.OK;
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
lblMsg.Text = "";
if (G.Authority == "D")
{
return;
}
if (e.RowIndex < 0)
{
return;
}
if (e.ColumnIndex == 3) //"품목"
{
ProdFinder pop = new ProdFinder();
pop.cbGubun.SelectedIndex = 1;
pop._kind = "%";
pop._stockFlag = "%";
pop.FormSendEvent += new ProdFinder.FormSendDataHandler(ProdEventMethod);
pop.ShowDialog();
}
else if (e.ColumnIndex == 23) //"도면 자료관리"
{
int lastRow = dataGridView1.Rows.GetLastRow(DataGridViewElementStates.Visible);
if (e.RowIndex == lastRow)
{
return;
}
if ((dataGridView1.Rows[e.RowIndex].Cells[0].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString())) ||
(dataGridView1.Rows[e.RowIndex].Cells[1].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString())))
{
lblMsg.Text = "저장 후 사용이 가능합니다.";
return;
}
P1B03_RORDER_DOC sub = new P1B03_RORDER_DOC();
sub.parentWin = this;
sub.rowIdx = e.RowIndex;
sub.sNo = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
sub.sSeq = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
sub.sFileName = dataGridView1.Rows[e.RowIndex].Cells[22].Value.ToString();
sub.ShowDialog();
}
else if (e.ColumnIndex == 24) //"X"
{
try
{
string sNo = tbNo.Text;
if (string.IsNullOrEmpty(sNo))
{
dataGridView1.Rows.Remove(dataGridView1.Rows[e.RowIndex]);
return;
}
if (dataGridView1.Rows[e.RowIndex].Cells[1].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString()))
{
dataGridView1.Rows.Remove(dataGridView1.Rows[e.RowIndex]);
return;
}
string sSeq = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
DialogResult dr = MessageBox.Show("해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "delete from tb_rorder_sub where rorder_id = '" + sNo + "' and rorder_seq = " + sSeq;
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
//string sEstimateNo = dataGridView1.Rows[e.RowIndex].Cells[17].Value.ToString();
//string sEstimateSeq = dataGridView1.Rows[e.RowIndex].Cells[18].Value.ToString();
//if (!string.IsNullOrEmpty(sEstimateNo))
//{
// sql = "update tb_estimate_sub set rorder_flag = 0 where estimate_id = '" + sEstimateNo + "' and estimate_seq = " + sEstimateSeq;
// m.dbCUD(sql, ref msg);
//}
dataGridView1.Rows.Remove(dataGridView1.Rows[e.RowIndex]);
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sNo + " " + sSeq);
}
catch (Exception)
{
return;
}
}
ListSearch4();
}
private void Save()
{
lblMsg.Text = "";
string sCustName = tbCustName.Text.Trim();
if (String.IsNullOrEmpty(sCustName))
{
lblMsg.Text = "거래처명을 입력해 주세요.";
tbCustName.Focus();
return;
}
string sCeo = tbCeo.Text.Trim();
string sGubun = cbGubun.Text.Substring(0, 1);
string sBusiNo = tbBusiNo.Text.Trim();
string sSaleMan = cbSaleMan.Text.Trim();
string sPostNo = tbPostNo.Text.Trim();
string sAddr1 = tbAddr1.Text.Trim();
string sAddr2 = tbAddr2.Text.Trim();
string sTel = tbTel.Text.Trim();
string sFax = tbFax.Text.Trim();
string sCustMan = tbCustMan.Text.Trim();
string sManHp = tbHp.Text.Trim();
string sContents = tbContents.Text.Trim();
string sFlag = "O";
if (cbFlag.Checked)
{
sFlag = "X";
}
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]")
{
//입력한 거래처명이 중복인지 확인..
if (isCustName(sCustName))
{
lblMsg.Text = "이미 존재하는 거래처명입니다.";
tbCustName.Focus();
return;
}
custCode = getCustCode();
sql = "insert into tb_gi_customer (cust_id, fullname, abbname, gubun, busi_no, ceo, post_no, address1, address2, tel, fax, cust_man, man_hp, saleman, contents, use_flag, enter_man) " +
"values('" + custCode + "','" + sCustName + "','" + sCustName + "'," + sGubun + ",'" + sBusiNo + "','" + sCeo + "','" + sPostNo + "','" + sAddr1 + "','" + sAddr2 + "','" + sTel + "','" + sFax + "','" + sCustMan + "','" + sManHp + "','" + sSaleMan + "','" + sContents + "','" + sFlag + "','" + G.UserID + "')";
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() == custCode)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
tbCustName.Text = string.Empty;
tbCeo.Text = string.Empty;
tbBusiNo.Text = string.Empty;
tbPostNo.Text = string.Empty;
tbAddr1.Text = string.Empty;
tbAddr2.Text = string.Empty;
tbTel.Text = string.Empty;
tbFax.Text = string.Empty;
tbCustMan.Text = string.Empty;
tbHp.Text = string.Empty;
tbContents.Text = string.Empty;
tbCustName.Focus();
}
else
{
sql = "update tb_gi_customer " +
"set fullname = '" + sCustName + "', abbname = '" + sCustName + "', gubun = " + sGubun + ", busi_no = '" + sBusiNo + "', ceo = '" + sCeo + "', post_no = '" + sPostNo + "', address1 = '" + sAddr1 + "', address2 = '" + sAddr2 + "', tel = '" + sTel + "', fax = '" + sFax + "', cust_man = '" + sCustMan + "', man_hp = '" + sManHp + "', saleman = '" + sSaleMan + "', contents = '" + sContents + "', use_flag = '" + sFlag + "' " +
" where cust_id = '" + custCode + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, custCode + " " + sCustName);
parentWin.ListSearch();
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, rowIndex];
parentWin.dataGridView1.Rows[rowIndex].Selected = true;
this.DialogResult = DialogResult.OK;
}
}
private void Save()
{
lblMsg.Text = "";
string subject, contents;
int notiFlag = 0;
subject = tbSubject.Text.Trim();
contents = tbContents.Text.Trim();
if (cbFlag.Checked)
{
notiFlag = 1;
}
if (String.IsNullOrEmpty(subject))
{
lblMsg.Text = "공지제목을 입력해 주세요.";
tbSubject.Focus();
return;
}
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
if (notiFlag == 1)
{
sql = "update tb_sys_notify set noti_flag = 0";
m.dbCUD(sql, ref msg);
}
if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]")
{
sql = "insert into tb_sys_notify (subject, contents, user_id, noti_flag) " +
"values('" + subject + "','" + contents + "','" + G.UserID + "'," + notiFlag + ")";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
parentWin.ListSearch();
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, 0];
parentWin.dataGridView1.CurrentCell.Selected = true;
this.DialogResult = DialogResult.OK;
}
else
{
sql = "update tb_sys_notify " +
"set subject = '" + subject + "', contents = '" + contents + "', noti_flag = " + notiFlag +
" where noti_dt = '" + sDateTime + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sDateTime);
parentWin.ListSearch();
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, rowIndex];
parentWin.dataGridView1.Rows[rowIndex].Selected = true;
this.DialogResult = DialogResult.OK;
}
}
private void Save()
{
lblMsg.Text = "";
string sInQty = tbInQty.Text.Replace(",", "").Trim();
string sAmount = tbAmount.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sInQty))
{
lblMsg.Text = "입고수량을 입력해 주세요.";
tbInQty.Focus();
return;
}
if (string.IsNullOrEmpty(sAmount))
{
lblMsg.Text = "가공액을 입력해 주세요.";
tbAmount.Focus();
return;
}
string sNo = tbNo.Text;
string sInDate = dtpInDate.Value.ToString("yyyy-MM-dd");
string sVat = tbVat.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sVat))
{
sVat = "0";
}
string sDepot = cbDepot.SelectedValue.ToString();
string sBigo = tbBigo.Text.Trim();
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
string sql = "update tb_purchase_toll " +
"set putch_flag = 1, in_date = '" + sInDate + "', in_qty = " + sInQty + ", amount = " + sAmount + ", vat = " + sVat + ", depot = '" + sDepot + "', contents = '" + sBigo + "', enter_dt2 = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', enter_man2 = '" + G.UserID + "'" +
" where purch_id = '" + sNo + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
if (lblDel.Visible)
{
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sNo + " " + sInDate);
}
parentWin.ListSearch();
for (int i = 0; i < parentWin.dataGridView1.Rows.Count - 1; i++)
{
if (parentWin.dataGridView1.Rows[i].Cells[0].Value.ToString() == sNo)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
this.DialogResult = DialogResult.OK;
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (G.Authority == "D")
{
return;
}
if (dataGridView1.RowCount <= 1)
{
return;
}
if (e.ColumnIndex != 0)
{
return;
}
string sJobNo = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
string sFacID = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
string sFacName = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
string sProcNo = dataGridView1.Rows[e.RowIndex].Cells[26].Value.ToString();
if (string.IsNullOrEmpty(sFacID))
{
return;
}
DialogResult dr = MessageBox.Show("JobNo.: " + sJobNo + "\r설비명 : " + sFacName + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "delete from tb_prod_result where job_no = '" + sJobNo + "' and proc_no = " + sProcNo + " and machine_id = " + sFacID;
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
sql = "update tb_prod_order set prod_flag = 0 where job_no = '" + sJobNo + "' and proc_no = " + sProcNo;
m.dbCUD(sql, ref msg);
string finalFlag = dataGridView1.Rows[e.RowIndex].Cells[23].Value.ToString();
string sujuNo = dataGridView1.Rows[e.RowIndex].Cells[24].Value.ToString();
string sujuSeq = dataGridView1.Rows[e.RowIndex].Cells[25].Value.ToString();
if (finalFlag == "1")
{
sql = "update tb_rorder_sub set prod_flag = 0 where rorder_id = '" + sujuNo + "' and rorder_seq = " + sujuSeq;
m.dbCUD(sql, ref msg);
}
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sJobNo + " " + sFacID + "-" + sFacName);
ListSearch();
}
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 = udY.Value.ToString() + "-12-31";
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) == "[추가]")
{
if (isPdCloseExist(G.Pos, sDate, sDepot, sProd))
{
lblMsg.Text = "이미 존재하는 마감 품목입니다.";
lblProd.Focus();
return;
}
sql = "insert into tb_gi_pdclose (pos, close_date, depot, prod_id, close_qty, enter_man) " +
"values('" + G.Pos + "','" + sDate + "','" + sDepot + "','" + sProd + "'," + sQty + ",'" + G.UserID + "')";
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() == sProd)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
tbProd.Tag = null;
tbProd.Text = string.Empty;
tbQty.Text = string.Empty;
lblMsg.Focus();
}
else
{
sql = "update tb_gi_pdclose " +
"set close_qty = " + sQty +
" where pos = '" + G.Pos + "' and close_date = '" + sDate + "' and depot = '" + sDepot + "' and prod_id = '" + sProd + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sDate + " " + cbDepot.Text + " " + tbProd.Text);
parentWin.ListSearch();
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, rowIndex];
parentWin.dataGridView1.Rows[rowIndex].Selected = true;
this.DialogResult = DialogResult.OK;
}
}
private void pbSave_Click(object sender, EventArgs e)
{
if (G.Authority == "D")
{
return;
}
dataGridView1.CurrentCell = dataGridView1[3, 0];
lblMsg.Text = "";
string sROrderNo = tbROderNo.Text;
if (string.IsNullOrEmpty(sROrderNo))
{
lblMsg.Text = "출하건이 선택되지 않았습니다.";
return;
}
int iCnt = 0;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if (!(dataGridView1.Rows[i].Cells[2].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[i].Cells[2].Value.ToString())))
{
iCnt++;
}
}
if (iCnt == 0)
{
lblMsg.Text = "품목정보를 확인해 주세요.";
dataGridView1.Focus();
return;
}
//
string sNo = tbNo.Text;
string sDate = dtpDate.Value.ToString("yyyy-MM-dd");
string sCust = tbCust.Tag.ToString();
string sPlace = tbPlace.Text.Trim();
string sDeliCar = cbDeliCar.Text.Substring(0, 1);
string sDeliInfo = tbDeliInfo.Text.Trim();
string sContents = tbContents.Text.Trim();
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
string sSeq = string.Empty;
string sDepot = string.Empty;
string sProdID = string.Empty;
string sAddName = string.Empty;
string sAddSize = string.Empty;
string sQty = string.Empty;
string sDanga = string.Empty;
string sAmount = string.Empty;
string sVat = string.Empty;
string sROrderSeq = string.Empty;
if (string.IsNullOrEmpty(sNo)) //추가
{
sNo = getDeliNo();
sql = "insert into tb_delivery_main (deli_id, pos, deli_date, cust_id, place, deli_car, deli_info, rorder_id, contents, enter_man) " +
"values('" + sNo + "','" + G.Pos + "','" + sDate + "','" + sCust + "','" + sPlace + "'," + sDeliCar + ",'" + sDeliInfo + "','" + sROrderNo + "','" + sContents + "','" + G.UserID + "')";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
tbNo.Text = sNo;
int seq = 0;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if (dataGridView1.Rows[i].Cells[2].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[i].Cells[2].Value.ToString()))
{
continue;
}
seq = seq + 10;
sSeq = seq.ToString();
sDepot = dataGridView1.Rows[i].Cells[11].Value.ToString().Trim();
sProdID = dataGridView1.Rows[i].Cells[2].Value.ToString().Trim();
sAddName = dataGridView1.Rows[i].Cells[4].Value.ToString().Trim();
sAddSize = dataGridView1.Rows[i].Cells[5].Value.ToString().Trim();
sQty = dataGridView1.Rows[i].Cells[6].Value.ToString().Trim();
sDanga = dataGridView1.Rows[i].Cells[7].Value.ToString().Trim();
sAmount = dataGridView1.Rows[i].Cells[8].Value.ToString().Trim();
sVat = dataGridView1.Rows[i].Cells[9].Value.ToString().Trim();
sROrderSeq = dataGridView1.Rows[i].Cells[13].Value.ToString().Trim();
if (string.IsNullOrEmpty(sQty))
{
sQty = "0";
}
if (string.IsNullOrEmpty(sDanga))
{
sDanga = "0";
}
if (string.IsNullOrEmpty(sAmount))
{
sAmount = "0";
}
if (string.IsNullOrEmpty(sVat))
{
sVat = "0";
}
sql = "insert into tb_delivery_sub (deli_id, deli_seq, depot, prod_id, add_name, add_size, qty, danga, amount, vat, rorder_id, rorder_seq) " +
"values('" + sNo + "'," + sSeq + ",'" + sDepot + "','" + sProdID + "','" + sAddName + "','" + sAddSize + "'," + sQty + "," + sDanga + "," + sAmount + "," + sVat + ",'" + sROrderNo + "'," + sROrderSeq + ")";
m.dbCUD(sql, ref msg);
sql = "update tb_rorder_sub " +
"set deli_flag = if(qty > ifnull((select sum(qty) from tb_delivery_sub where rorder_id = '" + sROrderNo + "' and rorder_seq = " + sROrderSeq + "),0),0,1) " +
"where rorder_id = '" + sROrderNo + "' and rorder_seq = " + sROrderSeq;
m.dbCUD(sql, ref msg);
}
}
else //수정
{
sql = "update tb_delivery_main " +
"set deli_date = '" + sDate + "', cust_id = '" + sCust + "', place = '" + sPlace + "', deli_car = '" + sDeliCar + "', deli_info = '" + sDeliInfo + "', rorder_id = '" + sROrderNo + "', contents = '" + sContents + "'" +
" where deli_id = '" + sNo + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if (dataGridView1.Rows[i].Cells[2].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[i].Cells[2].Value.ToString()))
{
continue;
}
sDepot = dataGridView1.Rows[i].Cells[11].Value.ToString().Trim();
sProdID = dataGridView1.Rows[i].Cells[2].Value.ToString().Trim();
sAddName = dataGridView1.Rows[i].Cells[4].Value.ToString().Trim();
sAddSize = dataGridView1.Rows[i].Cells[5].Value.ToString().Trim();
sQty = dataGridView1.Rows[i].Cells[6].Value.ToString().Trim();
sDanga = dataGridView1.Rows[i].Cells[7].Value.ToString().Trim();
sAmount = dataGridView1.Rows[i].Cells[8].Value.ToString().Trim();
sVat = dataGridView1.Rows[i].Cells[9].Value.ToString().Trim();
sROrderSeq = dataGridView1.Rows[i].Cells[13].Value.ToString().Trim();
if (dataGridView1.Rows[i].Cells[1].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[i].Cells[1].Value.ToString()))
{
sSeq = getDeliSeq(sNo);
}
else
{
sSeq = dataGridView1.Rows[i].Cells[1].Value.ToString();
}
if (string.IsNullOrEmpty(sQty))
{
sQty = "0";
}
if (string.IsNullOrEmpty(sDanga))
{
sDanga = "0";
}
if (string.IsNullOrEmpty(sAmount))
{
sAmount = "0";
}
if (string.IsNullOrEmpty(sVat))
{
sVat = "0";
}
sql = "insert into tb_delivery_sub (deli_id, deli_seq, depot, prod_id, add_name, add_size, qty, danga, amount, vat, rorder_id, rorder_seq)" +
" values('" + sNo + "'," + sSeq + ",'" + sDepot + "','" + sProdID + "','" + sAddName + "','" + sAddSize + "'," + sQty + "," + sDanga + "," + sAmount + "," + sVat + ",'" + sROrderNo + "'," + sROrderSeq + ")" +
" on duplicate key update" +
" depot = '" + sDepot + "', prod_id = '" + sProdID + "', add_name = '" + sAddName + "', add_size = '" + sAddSize + "', qty = " + sQty + ", danga = " + sDanga + ", amount = " + sAmount + ", vat = " + sVat + ", rorder_id = '" + sROrderNo + "', rorder_seq = " + sROrderSeq;
m.dbCUD(sql, ref msg);
}
}
tbSearch.Text = "";
ListSearch1();
for (int i = 0; i < dataGridViewList.Rows.Count; i++)
{
if (dataGridViewList.Rows[i].Cells[0].Value.ToString() == sNo)
{
dataGridViewList.CurrentCell = dataGridViewList[2, i];
dataGridViewList.CurrentCell.Selected = true;
ListSearch2(i);
ListSearch3();
ListSearch4();
break;
}
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sNo + "-" + tbProject.Text);
lblMsg.Text = "저장되었습니다.";
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
lblMsg.Text = "";
if (G.Authority == "D")
{
return;
}
if (e.RowIndex < 0)
{
return;
}
if (e.ColumnIndex == 14)
{
try
{
string sNo = tbNo.Text;
if (string.IsNullOrEmpty(sNo))
{
dataGridView1.Rows.Remove(dataGridView1.Rows[e.RowIndex]);
return;
}
if (dataGridView1.Rows[e.RowIndex].Cells[1].Value == null ||
string.IsNullOrEmpty(dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString()))
{
dataGridView1.Rows.Remove(dataGridView1.Rows[e.RowIndex]);
return;
}
string sSeq = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
DialogResult dr = MessageBox.Show("해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "delete from tb_delivery_sub where deli_id = '" + sNo + "' and deli_seq = " + sSeq;
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
string sROrderNo = dataGridView1.Rows[e.RowIndex].Cells[12].Value.ToString();
string sROrderSeq = dataGridView1.Rows[e.RowIndex].Cells[13].Value.ToString();
if (!string.IsNullOrEmpty(sROrderNo))
{
sql = "update tb_rorder_sub set deli_flag = 0 where rorder_id = '" + sROrderNo + "' and rorder_seq = " + sROrderSeq;
m.dbCUD(sql, ref msg);
}
dataGridView1.Rows.Remove(dataGridView1.Rows[e.RowIndex]);
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sNo + " " + sSeq);
}
//catch (InvalidOperationException)
catch (Exception)
{
return;
}
}
ListSearch4();
}
private void Save()
{
lblMsg.Text = "";
string sNo = tbNo.Text.Trim();
string sName = tbName.Text.Trim();
string sTool = tbTool.Text.Trim();
string sTime = tbTime.Text.Trim();
string sGroup = cbGroup.Text.Substring(0, 1);
string sFinal = "0";
if (ckFinalFlag.Checked)
{
sFinal = "1";
}
if (String.IsNullOrEmpty(sNo))
{
lblMsg.Text = "공정번호를 입력해 주세요.";
tbNo.Focus();
return;
}
if (String.IsNullOrEmpty(sName))
{
lblMsg.Text = "공정명을 입력해 주세요.";
tbName.Focus();
return;
}
float f = 0;
if (!String.IsNullOrEmpty(sTime) && float.TryParse(sTime, out f) == false)
{
lblMsg.Text = "표준공정시간을 확인해 주세요.";
tbTime.Focus();
return;
}
if (!String.IsNullOrEmpty(sTime) && float.Parse(sTime) < 0)
{
lblMsg.Text = "표준공정시간을 확인해 주세요.";
tbTime.Focus();
return;
}
if (sGroup != "Y" && sFinal == "1")
{
lblMsg.Text = "마지막공정은 출하대기 공정이어야 합니다.";
cbGroup.Focus();
return;
}
if (String.IsNullOrEmpty(sTime))
{
sTime = "NULL";
}
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]")
{
procStd = cbKind.SelectedValue.ToString();
if (isExist(procStd, sNo))
{
lblMsg.Text = "이미 존재하는 공정번호입니다.";
tbNo.Focus();
return;
}
sNo = transProcessNo(procStd, sNo);
if (sFinal == "1")
{
sql = "update tb_gi_process set final_flag = 0 where proc_std = '" + procStd + "'";
m.dbCUD(sql, ref msg);
}
sql = "insert into tb_gi_process (proc_std, proc_no, proc_name, proc_tools, std_time, job_group, final_flag) " +
"values('" + procStd + "'," + sNo + ",'" + sName + "','" + sTool + "'," + sTime + ",'" + sGroup + "'," + sFinal + ")";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
lblMsg.Text = "저장되었습니다.";
parentWin.cbStd.Text = cbKind.Text;
parentWin.ListSearch();
for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++)
{
if (parentWin.dataGridView1.Rows[i].Cells[2].Value.ToString() == sNo)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
tbNo.Text = string.Empty;
tbName.Text = string.Empty;
tbTool.Text = string.Empty;
tbTime.Text = string.Empty;
ckFinalFlag.Checked = false;
tbNo.Focus();
}
else
{
if (sFinal == "1")
{
sql = "update tb_gi_process set final_flag = 0 where proc_std = '" + procStd + "'";
m.dbCUD(sql, ref msg);
}
sql = "update tb_gi_process " +
"set proc_name = '" + sName + "', proc_tools = '" + sTool + "', std_time = " + sTime + ", job_group = '" + sGroup + "', final_flag = " + sFinal +
" where proc_std = '" + procStd + "' and proc_no = " + procNo;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, procStd + " " + cbKind.Text + " " + procNo);
parentWin.ListSearch();
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, rowIndex];
parentWin.dataGridView1.Rows[rowIndex].Selected = true;
this.DialogResult = DialogResult.OK;
}
}
private void Save()
{
lblMsg.Text = "";
string sCust = string.Empty;
string sProd = string.Empty;
if (tbCust.Tag != null)
{
sCust = tbCust.Tag.ToString();
}
if (tbProd.Tag != null)
{
sProd = tbProd.Tag.ToString();
}
string sQty = tbQty.Text.Replace(",", "").Trim();
string sDanga = tbDanga.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sCust))
{
lblMsg.Text = "가공처를 선택해 주세요.";
tbCust.Focus();
return;
}
if (string.IsNullOrEmpty(sProd))
{
lblMsg.Text = "품목명을 선택해 주세요.";
tbProd.Focus();
return;
}
if (string.IsNullOrEmpty(sQty))
{
lblMsg.Text = "발주수량을 입력해 주세요.";
tbQty.Focus();
return;
}
if (string.IsNullOrEmpty(sDanga))
{
lblMsg.Text = "단가를 입력해 주세요.";
tbDanga.Focus();
return;
}
if (dtpPutchDate.Value.Date > dtpRequestDate.Value.Date)
{
lblMsg.Text = "입고요청일자를 다시 확인해 주세요.";
dtpRequestDate.Focus();
return;
}
string sPutchDate = dtpPutchDate.Value.ToString("yyyy-MM-dd");
string sRequestDate = dtpRequestDate.Value.ToString("yyyy-MM-dd");
string sAddName = tbAddName.Text.Trim();
string sSize = tbSize.Text.Trim();
string sProcessID = string.Empty;
if (tbProcessID.Tag == null || string.IsNullOrEmpty(tbProcessID.Tag.ToString()))
{
sROrderNo = "";
sROrderSeq = "null";
sProcessID = "null";
}
else
{
sProcessID = tbProcessID.Tag.ToString();
}
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]")
{
sNo = getCode("PT");
sql = "insert into tb_purchase_toll (purch_id, pos, putch_date, cust_id, request_date, prod_id, add_name, add_size, putch_qty, danga, rorder_id, rorder_seq, process_id, enter_man1) " +
"values('" + sNo + "','" + G.Pos + "','" + sPutchDate + "','" + sCust + "','" + sRequestDate + "','" + sProd + "','" + sAddName + "','" + sSize + "'," + sQty + "," + sDanga + ",'" + sROrderNo + "'," + sROrderSeq + "," + sProcessID + ",'" + G.UserID + "')";
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 - 1; i++)
{
if (parentWin.dataGridView1.Rows[i].Cells[0].Value.ToString() == sNo)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
sNo = string.Empty;
tbAddName.Text = string.Empty;
tbSize.Text = string.Empty;
tbQty.Text = string.Empty;
tbDanga.Text = string.Empty;
tbMoney.Text = string.Empty;
tbAddName.Focus();
}
else
{
sql = "update tb_purchase_toll " +
"set putch_date = '" + sPutchDate + "', cust_id = '" + sCust + "', request_date = '" + sRequestDate + "', prod_id = '" + sProd + "', add_name = '" + sAddName + "', add_size = '" + sSize + "', putch_qty = " + sQty + ", danga = " + sDanga + ", rorder_id = '" + sROrderNo + "', rorder_seq = " + sROrderSeq + ", process_id = " + sProcessID +
" where purch_id = '" + sNo + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sNo + " " + sPutchDate + " " + tbCust.Text + " " + tbProd.Text);
parentWin.ListSearch();
for (int i = 0; i < parentWin.dataGridView1.Rows.Count - 1; i++)
{
if (parentWin.dataGridView1.Rows[i].Cells[0].Value.ToString() == sNo)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
this.DialogResult = DialogResult.OK;
}
}
