private void pbDel_Click(object sender, EventArgs e)
{
if (G.Authority == "D")
{
return;
}
if (!cbNo.Checked)
{
lblMsg.Text = "삭제할 전표번호를 체크해 주세요.";
return;
}
string sNo = tbNo.Text;
if (string.IsNullOrEmpty(sNo))
{
lblMsg.Text = "저장된 전표번호만 삭제할 수 있습니다.";
return;
}
DialogResult dr = MessageBox.Show("전표번호 : " + sNo + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "delete from tb_delivery_main where deli_id = '" + sNo + "'";
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show("전표번호 : '" + sNo + "'\r\r이미 타 업무에서 사용중인 전표번호이므로,\r삭제할 수 없습니다.");
return;
}
string sROrderNo = tbROderNo.Text;
if (!string.IsNullOrEmpty(sROrderNo))
{
sql = "update tb_rorder_sub set deli_flag = 0 where rorder_id = '" + sROrderNo + "'";
m.dbCUD(sql, ref msg);
}
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sNo + " " + tbProject.Text);
ListSearch1();
ListInit();
}
private void FacilityImageSave(string _fid)
{
MariaCRUD m = new MariaCRUD();
string sql = string.Empty;
string msg = string.Empty;
if (!string.IsNullOrEmpty(txtPath.Text) && pbFacilityImage.Image != null)
{
UInt32 FileSize;
byte[] rawData;
FileStream fs;
MySqlConnection con = new MySqlConnection(G.conStr);
MySqlCommand cmd = new MySqlCommand();
try
{
fs = new FileStream(@txtPath.Text, FileMode.Open, FileAccess.Read);
FileSize = (UInt32)fs.Length;
rawData = new byte[FileSize];
fs.Read(rawData, 0, (int)FileSize);
fs.Close();
con.Open();
sql = "UPDATE tb_machinecard SET machine_image = @File, image_size = @FileSize WHERE machine_id = " + _fid;
cmd.Connection = con;
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@File", rawData);
cmd.Parameters.AddWithValue("@FileSize", FileSize);
cmd.ExecuteNonQuery();
}
catch (MySqlException ex)
{
MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
finally
{
con.Close();
}
}
else if (string.IsNullOrEmpty(txtPath.Text) && pbFacilityImage.Image == null)
{
sql = "UPDATE tb_machinecard SET machine_image = NULL, image_size = 0 WHERE machine_id = " + _fid;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
}
}
private void Save(string flag)
{
lblMsg.Text = "";
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 = "update tb_prod_order " +
"set rorder_date = '" + sDate + "', order_qty = " + sQty + ", prod_flag = " + flag +
" where job_no = '" + jobNo + "' and proc_no = " + procNo;
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
if (flag == "1")
{
sql = "insert into tb_prod_done (job_no, pos, done_date, prod_id, add_name, add_size, rorder_id, rorder_seq, proc_std, done_qty, contents, depot, enter_man) " +
"select p.job_no, '" + G.Pos + "','" + sDate + "', p.prod_id, p.add_name, p.add_size, p.rorder_id, p.rorder_seq, p.proc_std, " + sQty + ", p.ment, '" + sDepot + "','" + G.UserID + "' " +
"from tb_prod_order p where p.job_no = '" + jobNo + "' and p.proc_no = " + procNo;
}
else
{
sql = "delete from tb_prod_done where job_no = '" + jobNo + "'";
}
m = new MariaCRUD();
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
parentWin.ListSearch();
parentWin.dataGridViewY.CurrentCell = parentWin.dataGridViewY[0, rowIndex];
parentWin.dataGridViewY.CurrentCell.Selected = true;
this.DialogResult = DialogResult.OK;
}
private void pbDel_Click(object sender, EventArgs e)
{
int index = 0;
string sNo = string.Empty;
string sSeq = string.Empty;
string sName = string.Empty;
string sGroup = string.Empty;
string sDate = string.Empty;
string sKind = string.Empty;
try
{
index = dataGridView1.CurrentRow.Index;
sNo = dataGridView1.Rows[index].Cells[0].Value.ToString();
sSeq = dataGridView1.Rows[index].Cells[4].Value.ToString();
sName = dataGridView1.Rows[index].Cells[2].Value.ToString();
sGroup = dataGridView1.Rows[index].Cells[3].Value.ToString();
sDate = dataGridView1.Rows[index].Cells[5].Value.ToString();
sKind = dataGridView1.Rows[index].Cells[6].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(sName + "(" + sGroup + ")\r" + sDate + " " + sKind + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "delete from tb_machine_repair where machine_id = '" + sNo + "' and seq = " + sSeq;
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sName + "(" + sGroup + ") " + sDate + " " + sKind);
ListSearch();
}
private void pbSave_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
string sName = tbName.Text.Trim();
string sCeo = tbCeo.Text.Trim();
string sHomePage = tbHomePage.Text.Trim();
string sBusiNo = tbBusiNo.Text.Trim();
string sBubinNo = tbBubinNo.Text.Trim();
string sUpTae = tbUpTae.Text.Trim();
string sJongMong = tbJongMong.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 sStartTime = mtbJobStartTime.Text.Trim();
if (string.IsNullOrEmpty(sName))
{
lblMsg.Text = "회사공식명을 입력해 주세요.";
tbName.Focus();
return;
}
if (sStartTime == ":")
{
sStartTime = "00:00";
}
if (sStartTime.Length != 5)
{
lblMsg.Text = "작업시작시간을 확인해 주세요.";
mtbJobStartTime.Focus();
return;
}
sStartTime = sStartTime + ":00";
string sql = "update tb_sys_pos " +
"set pos_name = '" + sName + "', ceo = '" + sCeo + "', homepage = '" + sHomePage + "', busi_no = '" + sBusiNo + "', bubin_no = '" + sBubinNo + "', uptae = '" + sUpTae + "', jongmog = '" + sJongMong + "', post_no = '" + sPostNo + "', address1 = '" + sAddr1 + "', address2 = '" + sAddr2 + "', tel = '" + sTel + "', fax = '" + sFax + "', job_starttime = TIME_TO_SEC('" + sStartTime + "'), enter_dt = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', enter_man = '" + G.UserID + "' " +
"where pos = 'A'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
lblMsg.Text = "저장되었습니다.";
}
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 sKind = cbKind.SelectedValue.ToString();
string sContents = tbContents.Text.Trim();
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
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;
}
parentWin.ListSearch();
for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++)
{
if (parentWin.dataGridView1.Rows[i].Cells[2].Value.ToString() == sProd)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
this.DialogResult = DialogResult.OK;
}
private void pbSave_Click(object sender, EventArgs e)
{
lblMsg.Text = "잠시 기다려 주세요.";
int rowCnt = dataGridView2.RowCount;
string id = lblID.Text;
if (rowCnt < 1)
{
return;
}
if (string.IsNullOrEmpty(id))
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "delete from tb_sys_authority where user_id = '" + id + "'";
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
string menuID;
for (int i = 0; i < rowCnt; i++)
{
if (dataGridView2.Rows[i].Cells[0].Value.ToString() == "O")
{
menuID = dataGridView2.Rows[i].Cells[1].Value.ToString();
sql = "insert into tb_sys_authority values ('" + id + "','KO','" + menuID + "')";
m.dbCUD(sql, ref msg);
}
}
lblMsg.Text = "저장되었습니다.";
}
private void pbDel_Click(object sender, EventArgs e)
{
if (G.Authority == "D")
{
return;
}
if (!cbNo.Checked)
{
lblMsg.Text = "삭제할 수주번호를 체크해 주세요.";
return;
}
string sNo = tbNo.Text;
if (string.IsNullOrEmpty(sNo))
{
lblMsg.Text = "저장된 수주번호만 삭제할 수 있습니다.";
return;
}
DialogResult dr = MessageBox.Show("수주번호 : " + sNo + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "delete from tb_rorder_main where rorder_id = '" + sNo + "'";
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
//string sEstimateNo = tbEstimateNo.Text;
//if (!string.IsNullOrEmpty(sEstimateNo))
//{
// sql = "update tb_estimate_main set rorder_flag = 0 where estimate_id = '" + sEstimateNo + "'";
// m.dbCUD(sql, ref msg);
// sql = "update tb_estimate_sub set rorder_flag = 0 where estimate_id = '" + sEstimateNo + "'";
// m.dbCUD(sql, ref msg);
//}
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sNo + " " + tbCust.Text);
ListSearch1();
ListInit();
}
private void pbDel_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
int index = 0;
string sID = string.Empty;
string sName = string.Empty;
string sModel = string.Empty;
try
{
index = dataGridView1.CurrentRow.Index;
sID = dataGridView1.Rows[index].Cells[0].Value.ToString();
sName = dataGridView1.Rows[index].Cells[2].Value.ToString();
sModel = dataGridView1.Rows[index].Cells[3].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(sName + "\r" + sModel + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "delete from tb_machinecard where machine_id = " + sID;
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sName + " " + sModel);
ListSearch();
MachineInit();
}
private void pbDel_Click(object sender, EventArgs e)
{
int index = 0;
string sDate = string.Empty;
string sDepot = string.Empty;
string sProd = string.Empty;
string sProdName = string.Empty;
try
{
index = dataGridView1.CurrentRow.Index;
sDate = udY.Value.ToString() + "-12-31";
sDepot = cbDepot.SelectedValue.ToString();
sProd = dataGridView1.Rows[index].Cells[1].Value.ToString();
sProdName = dataGridView1.Rows[index].Cells[3].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(sProdName + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "delete from tb_gi_pdclose where pos = '" + G.Pos + "' and close_date = '" + sDate + "' and depot = '" + sDepot + "' and prod_id = '" + sProd + "'";
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, udY.Value.ToString() + " " + sProdName);
ListSearch();
}
private void pbDel_Click(object sender, EventArgs e)
{
int index = 0;
string sID = string.Empty;
string sDate = string.Empty;
string sCustName = string.Empty;
try
{
index = dataGridView1.CurrentRow.Index;
sID = dataGridView1.Rows[index].Cells[0].Value.ToString();
sDate = DateTime.Parse(dataGridView1.Rows[index].Cells[5].Value.ToString()).ToString("yyyy-MM-dd");
sCustName = dataGridView1.Rows[index].Cells[2].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(sID + "\r" + sDate + "\r" + sCustName + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "delete from tb_qc_claim where claim_id = " + sID;
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sID + " " + sDate + " " + sCustName);
ListSearch();
}
private void pbSave_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
if (G.Authority == "D")
{
return;
}
if (dataGridView2.Rows.Count < 1)
{
lblMsg.Text = "구성품 리스트가 존재하지 않습니다.";
return;
}
dataGridView2.CurrentCell = dataGridView2[0, 0];
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
string sProdID = string.Empty;
string sMaterialID = string.Empty;
string sQty = string.Empty;
int iCnt = 0;
for (int i = 0; i < dataGridView2.RowCount; i++)
{
sProdID = dataGridView2.Rows[i].Cells[1].Value.ToString();
sMaterialID = dataGridView2.Rows[i].Cells[2].Value.ToString();
sQty = dataGridView2.Rows[i].Cells[6].Value.ToString();
if (string.IsNullOrEmpty(sQty))
{
sQty = "0";
}
sql = "update tb_gi_bom set config_qty = " + sQty +
" where prod_id = '" + sProdID + "' and material_id = '" + sMaterialID + "'";
m.dbCUD(sql, ref msg);
iCnt++;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sProdID + " " + iCnt.ToString() + "건");
lblMsg.Text = "저장되었습니다.";
}
private void pbDel_Click(object sender, EventArgs e)
{
if (G.Authority == "D")
{
return;
}
if (dataGridView1.RowCount <= 0)
{
lblMsg.Text = "삭제할 검사 건이 선택되지 않았습니다.";
return;
}
if (dataGridView1[8, 0].Value == null ||
string.IsNullOrEmpty(dataGridView1[8, 0].Value.ToString()))
{
lblMsg.Text = "저장되지 않은 검사 건입니다.";
return;
}
string sNo = dataGridView1[8, 0].Value.ToString();
string sCust = dataGridViewList.Rows[dataGridViewList.CurrentRow.Index].Cells[3].Value.ToString();
DialogResult dr = MessageBox.Show("거래처명 : " + sCust + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "delete from tb_qc_final where rorder_id = '" + sNo + "'";
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
dataGridViewList[7, dataGridViewList.CurrentRow.Index].Value = 0;
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sNo + " " + sCust);
ListInit();
lblMsg.Text = "삭제되었습니다.";
}
private void lblDel_Click(object sender, EventArgs e)
{
try
{
string sNo = tbNo.Text;
DialogResult dr = MessageBox.Show("입고번호 : " + sNo + "\r\r해당 정보를 삭제하시겠습니까?", this.lblTitle.Text + "[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string sql = "update tb_purchase_mat " +
"set putch_flag = 0, in_date = null, in_qty = 0, amount = 0, vat = 0, depot = null, contents = null, enter_dt2 = null, enter_man2 = null" +
" where purch_id = '" + sNo + "'";
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
m.TransLogCreate(G.Authority, G.UserID, "D", this.Name, lblTitle.Text, sNo + " 입고정보");
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;
}
catch (InvalidOperationException)
{
return;
}
}
private void Save()
{
lblMsg.Text = "";
if (string.IsNullOrEmpty(cbUser.Text))
{
lblMsg.Text = "운전자가 선택되지 않았습니다.";
cbUser.Focus();
return;
}
string sDate = dtpDate2.Value.ToString("yyyy-MM-dd");
string sUser = cbUser.SelectedValue.ToString();
string sQty = tbGdQty.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sQty))
{
sQty = "0";
}
string sDT1 = dtpDate1.Value.ToString("yyyy-MM-dd HH:mm:ss");
string sDT2 = dtpDate2.Value.ToString("yyyy-MM-dd HH:mm:ss");
string sql = "update tb_prod_result " +
"set prod_date = '" + sDate + "', user_id = '" + sUser + "', gd_qty = " + sQty + ", jobtime_start = '" + sDT1 + "', jobtime_finish = '" + sDT2 + "'" +
" where job_no = '" + tbJobNo.Text + "' and proc_no = " + lblProc.Tag.ToString() + " and machine_id = " + tbMachine.Tag.ToString();
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, tbJobNo.Text + " " + lblProc.Text + " " + tbMachine.Text);
parentWin.ListSearch();
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[2, rowIndex];
parentWin.dataGridView1.Rows[rowIndex].Selected = true;
this.DialogResult = DialogResult.OK;
}
private void btnDel_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("해당 첨부파일은 영구 삭제됩니다.\r\r삭제 작업을 진행 하시겠습니까?", "첨부파일[삭제]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
MySqlConnection con = new MySqlConnection(G.conStr);
try
{
con.Open();
string sql = "UPDATE tb_rorder_sub SET doc1 = NULL, doc1_size = 0, doc1_name = null WHERE rorder_id = '" + sNo + "' and rorder_seq = " + sSeq;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
parentWin.dataGridView1.Rows[rowIdx].Cells[23].Value = Properties.Resources.clipB;
parentWin.dataGridView1.Rows[rowIdx].Cells[22].Value = "";
this.Close();
}
catch (MySqlException ex)
{
MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
finally
{
con.Close();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (lbNgList.SelectedValue == null ||
string.IsNullOrEmpty(lbNgList.SelectedValue.ToString()))
{
lblMsg.Text = "불량항목이 선택되지 않았습니다.";
lbNgList.Focus();
return;
}
string sItem = lbNgList.SelectedValue.ToString();
string sQty = tbQty.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sQty))
{
sQty = "0";
}
if (sQty == "0")
{
lblMsg.Text = "불량수량을 확인해 주세요.";
tbQty.Focus();
return;
}
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
string sql = "update tb_prod_result set ng_qty = " + sQty + ", ng_item = '" + sItem + "' where job_no = '" + jobNo + "' and proc_no = " + procNo + " and machine_id = " + facID;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
parentWin.tbNgQty.Tag = lbNgList.SelectedValue.ToString();
parentWin.tbNgQty.Text = tbQty.Text;
parentWin.lblMsg.Text = "불량보고 되었습니다.";
this.DialogResult = DialogResult.OK;
}
private void Save()
{
lblMsg.Text = "";
string sProd = tbCode.Text;
string sDanga = tbDanga.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sDanga))
{
sDanga = "0";
}
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
string sql = "update tb_gi_product set stock_money = " + sDanga + " where prod_id = '" + sProd + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
parentWin.ListSearch();
for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++)
{
if (parentWin.dataGridView1.Rows[i].Cells[2].Value.ToString() == sProd)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
this.DialogResult = DialogResult.OK;
}
private void Save(string flag)
{
lblMsg.Text = "";
string sQty = tbQty.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sQty))
{
lblMsg.Text = "수량을 입력해 주세요.";
tbQty.Focus();
return;
}
string sDate = dtpDate.Value.ToString("yyyy-MM-dd");
string sMent = tbMent.Text.Trim();
string sql = "update tb_prod_order " +
"set rorder_date = '" + sDate + "', order_qty = " + sQty + ", ment = '" + sMent + "', prod_flag = " + flag +
" where job_no = '" + jobNo + "' and proc_no = " + procNo;
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
parentWin.ListSearch();
parentWin.dataGridViewX.CurrentCell = parentWin.dataGridViewX[0, rowIndex];
parentWin.dataGridViewX.CurrentCell.Selected = true;
this.DialogResult = DialogResult.OK;
}
//
private void dataGridView2_DragDrop(object sender, DragEventArgs e)
{
if (dragTag != 3)
{
return;
}
if (dataGridView1.CurrentCell == null ||
dataGridView1.CurrentCell.RowIndex < 0)
{
return;
}
if (e.Effect == DragDropEffects.Copy)
{
int index = dataGridView1.CurrentCell.RowIndex;
string sPCode = dataGridView1.Rows[index].Cells[1].Value.ToString();
string sMCode = (string)e.Data.GetData(DataFormats.StringFormat);
string sql = "insert into tb_gi_bom (prod_id, material_id, config_qty) " +
"values('" + sPCode + "', '" + sMCode + "', 1)";
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
return;
}
ListSearch2(sPCode);
ListSearch3(sPCode);
}
}
private void Save()
{
lblMsg.Text = "";
if (string.IsNullOrEmpty(machineID))
{
lblMsg.Text = "설비정보를 확인해 주세요.";
lblSelect.Focus();
return;
}
string sDate = dtpDate.Value.ToString("yyyy-MM-dd");
string sKind = cbKind.Text.Substring(0, 1);
string sGoal = tbGoal.Text.Trim();
string sResult = tbResult.Text.Trim();
string sMan = tbMan.Text.Trim();
string sMoeny = tbMoney.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sMoeny))
{
sMoeny = "NULL";
}
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) == "[추가]")
{
seq = getSeq(machineID);
sql = "insert into tb_machine_repair (machine_id, seq, repair_date, repair_kind, repair_goal, repair_result, repair_man, repair_money, contents, enter_man) " +
"values(" + machineID + "," + seq + ",'" + sDate + "'," + sKind + ",'" + sGoal + "','" + sResult + "','" + sMan + "'," + sMoeny + ",'" + sContents + "','" + 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() == machineID &&
DateTime.Parse(parentWin.dataGridView1.Rows[i].Cells[5].Value.ToString()).ToString("yyyy-MM-dd") == sDate &&
parentWin.dataGridView1.Rows[i].Cells[6].Value.ToString().Substring(0, 1) == sKind)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[1, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
machineID = string.Empty;
seq = string.Empty;
tbHo.Text = string.Empty;
tbName.Text = string.Empty;
tbModel.Text = string.Empty;
tbModel.Tag = string.Empty;
tbGoal.Text = string.Empty;
tbResult.Text = string.Empty;
tbMan.Text = string.Empty;
tbMoney.Text = string.Empty;
tbContents.Text = string.Empty;
tbGoal.Focus();
}
else
{
sql = "update tb_machine_repair " +
"set repair_date = '" + sDate + "', repair_kind = '" + sKind + "', repair_goal = '" + sGoal + "', repair_result = '" + sResult + "', repair_man = '" + sMan + "', repair_money = " + sMoeny + ", contents = '" + sContents + "'" +
" where machine_id = " + machineID + " and seq = " + seq;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, machineID + "-" + seq + " " + tbName.Text + " " + tbModel.Text);
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 sProdName = tbProdName.Text.Trim();
if (String.IsNullOrEmpty(sProdName))
{
lblMsg.Text = "품목명을 입력해 주세요.";
tbProdName.Focus();
return;
}
string sGubun = cbGubun.Text.Substring(0, 1);
string sKind = cbKind.SelectedValue.ToString();
string sSize = tbSize.Text.Trim();
string sUnit = tbUnit.Text.Trim();
string sUnitSub = tbUnitSub.Text.Trim();
string sStockFlag = "1";
if (ckbStockFlag.Checked)
{
sStockFlag = "0";
}
string sUseFlag = "O";
if (ckbUseFlag.Checked)
{
sUseFlag = "X";
}
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
if (lblTitle.Text.Substring(lblTitle.Text.Length - 4, 4) == "[추가]")
{
//입력한 품목명이 중복인지 확인..
if (isProdName(sGubun, sProdName))
{
lblMsg.Text = "이미 존재하는 품목명입니다.";
tbProdName.Focus();
return;
}
prodCode = getProdCode(sGubun);
sql = "insert into tb_gi_product (gubun, prod_id, prod_kind, prod_name, prod_size, unit, unit_sub, stock_flag, use_flag, enter_man) " +
"values('" + sGubun + "','" + prodCode + "','" + sKind + "','" + sProdName + "','" + sSize + "','" + sUnit + "','" + sUnitSub + "'," + sStockFlag + ",'" + sUseFlag + "','" + G.UserID + "')";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
lblMsg.Text = "저장되었습니다.";
parentWin.tbSearch.Text = "";
if (sGubun == "A")
{
parentWin.rbA.Checked = true;
}
else if (sGubun == "B")
{
parentWin.rbB.Checked = true;
}
else if (sGubun == "C")
{
parentWin.rbC.Checked = true;
}
else if (sGubun == "D")
{
parentWin.rbD.Checked = true;
}
else
{
parentWin.rbZ.Checked = true;
}
parentWin.ListSearch();
for (int i = 0; i < parentWin.dataGridView1.Rows.Count; i++)
{
if (parentWin.dataGridView1.Rows[i].Cells[1].Value.ToString() == prodCode)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
tbProdName.Text = string.Empty;
tbSize.Text = string.Empty;
tbProdName.Focus();
}
else
{
sql = "update tb_gi_product " +
"set prod_kind = '" + sKind + "', prod_name = '" + sProdName + "', prod_size = '" + sSize + "', unit = '" + sUnit + "', unit_sub = '" + sUnitSub + "', stock_flag = " + sStockFlag + ", use_flag = '" + sUseFlag + "'" +
" where prod_id = '" + prodCode + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, prodCode + " " + sProdName);
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 (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 dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
if (dataGridView1.Rows.GetLastRow(DataGridViewElementStates.Visible) == e.RowIndex)
{
return;
}
if (e.ColumnIndex == 0)
{
P1Z02_USER_SUB sub = new P1Z02_USER_SUB();
sub.lblTitle.Text = sub.lblTitle.Text + "[수정]";
sub.parentWin = this;
sub.ShowDialog();
}
else if (e.ColumnIndex == 6)
{
int index = 0;
string userID = string.Empty;
string userName = string.Empty;
try
{
index = dataGridView1.CurrentRow.Index;
userID = dataGridView1.Rows[index].Cells[0].Value.ToString();
userName = dataGridView1.Rows[index].Cells[1].Value.ToString();
if (dataGridView1.Rows[index].Selected != true)
{
return;
}
}
catch (NullReferenceException)
{
return;
}
if (string.IsNullOrEmpty(userID))
{
return;
}
DialogResult dr = MessageBox.Show(userName + "\r\r선택된 사용자의 암호를 초기화(1234) 하시겠습니까?", this.lblTitle.Text + "[암호초기화]", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.No)
{
return;
}
string InitPwd = new MyClass().EncryptSHA512("1234");
string sql = "update tb_sys_user set pwd = '" + InitPwd + "' where user_id = '" + userID + "'";
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
MessageBox.Show(msg);
}
}
else
{
return;
}
}
private void pbSave_Click(object sender, EventArgs e)
{
lblMsg.Text = "";
if (G.Authority == "D")
{
return;
}
if (dataGridView2.RowCount == 0)
{
return;
}
try
{
dataGridView2.CurrentCell = dataGridView2[1, 0];
}
catch (InvalidOperationException)
{
return;
}
int iCnt1 = 0, iCnt2 = 0;
DateTime result;
for (int i = 0; i < dataGridView2.RowCount; i++)
{
if (dataGridView2.Rows[i].Cells[5].Value == null ||
string.IsNullOrEmpty(dataGridView2.Rows[i].Cells[5].Value.ToString()) ||
!DateTime.TryParse(dataGridView2.Rows[i].Cells[5].Value.ToString(), out result))
{
iCnt1++;
}
if (dataGridView2.Rows[i].Cells[7].Value == null ||
string.IsNullOrEmpty(dataGridView2.Rows[i].Cells[7].Value.ToString()))
{
iCnt2++;
}
}
if (iCnt1 > 0)
{
lblMsg.Text = "생산일자를 확인해 주세요.";
return;
}
if (iCnt2 > 0)
{
lblMsg.Text = "지시수량을 확인해 주세요.";
return;
}
//
string sLogNo = dataGridView2.Rows[0].Cells[0].Value.ToString();
string sProcNo = string.Empty;
string sDate = string.Empty;
string sJobPart = string.Empty;
string sOrderQty = string.Empty;
string sMent = string.Empty;
string sql = string.Empty;
string msg = string.Empty;
MariaCRUD m = new MariaCRUD();
for (int i = 0; i < dataGridView2.RowCount; i++)
{
sProcNo = dataGridView2.Rows[i].Cells[1].Value.ToString();
sDate = DateTime.Parse(dataGridView2.Rows[i].Cells[5].Value.ToString().Trim()).ToString("yyyy-MM-dd");
sJobPart = dataGridView2.Rows[i].Cells[6].Value.ToString().Substring(0, 1);
sOrderQty = dataGridView2.Rows[i].Cells[7].Value.ToString().Trim();
sMent = dataGridView2.Rows[i].Cells[8].Value.ToString().Trim();
sql = "update tb_prod_order set rorder_date = '" + sDate + "', job_part = '" + sJobPart + "', order_qty = " + sOrderQty + ", ment = '" + sMent +
"' where job_no = '" + sLogNo + "' and proc_no = " + sProcNo;
m.dbCUD(sql, ref msg);
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, sLogNo);
lblMsg.Text = "저장되었습니다.";
}
private void btnSave_Click(object sender, EventArgs e)
{
if (lbNgList.SelectedValue == null ||
string.IsNullOrEmpty(lbNgList.SelectedValue.ToString()))
{
lblMsg.Text = "불량항목이 선택되지 않았습니다.";
lbNgList.Focus();
return;
}
string sItem = lbNgList.SelectedValue.ToString();
string sQty = tbQty.Text.Replace(",", "").Trim();
if (string.IsNullOrEmpty(sQty))
{
sQty = "0";
}
if (sQty == "0")
{
lblMsg.Text = "불량수량을 확인해 주세요.";
tbQty.Focus();
return;
}
MariaCRUD m = new MariaCRUD();
string msg = string.Empty;
string sql = "update tb_prod_result set ng_qty = " + sQty + ", ng_item = '" + sItem + "' where job_no = '" + jobNo + "' and proc_no = " + procNo + " and machine_id = " + facID;
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
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 parentMsg = 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);
parentMsg.Text = "불량보고 되었습니다.";
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_mat " +
"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 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 Save()
{
lblMsg.Text = "";
string sItem = tbItem.Text.Trim();
if (String.IsNullOrEmpty(sItem))
{
lblMsg.Text = "항목명을 입력해 주세요.";
tbKind.Focus();
return;
}
string sCode = tbCode.Text;
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) == "[추가]")
{
//입력한 거래처명이 중복인지 확인..
if (isCommonItem(kind, sItem))
{
lblMsg.Text = "이미 존재하는 항목명입니다.";
tbItem.Focus();
return;
}
sql = "insert into tb_gi_common (co_kind, co_code, co_item, contents) " +
"values('" + kind + "','" + sCode + "','" + sItem + "','" + sContents + "')";
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[3].Value.ToString() == sCode)
{
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, i];
parentWin.dataGridView1.CurrentCell.Selected = true;
break;
}
}
tbCode.Text = getCommonCode(kind);
tbItem.Text = string.Empty;
tbContents.Text = string.Empty;
tbItem.Focus();
}
else
{
sql = "update tb_gi_common " +
"set co_item = '" + sItem + "', contents = '" + sContents + "'" +
" where co_kind = '" + kind + "' and co_code = '" + sCode + "'";
m.dbCUD(sql, ref msg);
if (msg != "OK")
{
lblMsg.Text = msg;
return;
}
m.TransLogCreate(G.Authority, G.UserID, "M", this.Name, lblTitle.Text, tbKind.Text + " " + sCode);
parentWin.ListSearch();
parentWin.dataGridView1.CurrentCell = parentWin.dataGridView1[0, 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();
}
