/// <summary>
/// 데이터 그리드 바인딩
/// </summary>
private void DataGridViewBinding1()
{
dgv1.DataSource = null;
ReorderService service = new ReorderService();
dgv1.DataSource = service.GetCOM();
}
private void DataGridViewBinding2()
{
dgv2.DataSource = null;
ReorderService service = new ReorderService();
dgv2.DataSource = service.GetWarehousingWait();
}
private void DataGridViewBinding2()
{
dgv2.DataSource = null;
ReorderService service = new ReorderService();
dt = service.GetReorderItem();
dgv2.DataSource = dt;
}
private void button1_Click(object sender, EventArgs e)
{
int a = 0;
dgv2.EndEdit();
ReorderService service = new ReorderService();
foreach (DataGridViewRow item in dgv2.Rows)
{
if (Convert.ToBoolean(item.Cells[1].Value) == true)
{
a++;
if (item.Cells[10].Value == null)
{
MessageBox.Show("발주할 품목의 수량을 입력해주세요");
return;
}
}
}
if (a == 0)
{
MessageBox.Show("발주할 품목을 선택해주세요");
return;
}
REORDER_VO vo = new REORDER_VO();
vo.REORDER_DATE = DateTime.Now;
vo.REORDER_STATE = "발주";
vo.MANAGER_ID = LoginInfo.UserInfo.LI_ID;
int su = 0;
foreach (DataGridViewRow item in dgv2.Rows)
{
if (Convert.ToBoolean(item.Cells[1].Value) == true)
{
vo.REORDER_DATE_IN = DateTime.Now.AddDays(Convert.ToInt32(item.Cells[15].Value));
vo.REORDER_COM_DLVR = item.Cells[3].Value.ToString();
vo.REORDER_TYP = (item.Cells[4].Value.ToString().Length < 1) ?"정량" : item.Cells[4].Value.ToString();
vo.REORDER_QTY = Convert.ToInt32(item.Cells[11].Value);
vo.ITEM_CODE = item.Cells[5].Value.ToString();
vo.COM_CODE = item.Cells[2].Value.ToString();
vo.SALES_Work_Order_ID = item.Cells[14].Value.ToString();
if (service.insertREORDER(vo))
{
;
}
{
su++;
}
}
}
if (su > 0)
{
MessageBox.Show("발주가 완료 되었습니다.");
this.Close();
}
}
private void button2_Click(object sender, EventArgs e)
{
int a = 0;
dgv2.EndEdit();
ReorderService service = new ReorderService();
foreach (DataGridViewRow item in dgv2.Rows)
{
if (Convert.ToBoolean(item.Cells[1].Value) == true)
{
a++;
if (item.Cells[9].Value == null)
{
MessageBox.Show("입고할 품목의 수량을 입력해주세요");
return;
}
}
}
if (a == 0)
{
MessageBox.Show("입고할 품목을 선택해주세요");
return;
}
REORDERDETATILS_VO vo = new REORDERDETATILS_VO();
ITEM_VO vo2 = new ITEM_VO();
int su = 0;
foreach (DataGridViewRow item in dgv2.Rows)
{
if (Convert.ToBoolean(item.Cells[1].Value) == true)
{
vo2.ITEM_QTY_UNIT = Convert.ToInt32(item.Cells[8].Value);
vo2.ITEM_CODE = item.Cells[3].Value.ToString();
vo2.ITEM_INCOME_YN = item.Cells[13].Value.ToString();
vo2.ITEM_WRHS_IN = (item.Cells[14].Value == null) ? "R-01" : item.Cells[14].Value.ToString();
vo.REORDER_DETAIL_QTY_GOOD = Convert.ToInt32(item.Cells[9].Value);
vo.REORDER = Convert.ToInt32(item.Cells[2].Value);
string id = item.Cells[15].Value.ToString();
if (service.insertREORDERDETATILS(vo, vo2, id))
{
;
}
{
su++;
}
}
}
if (su > 0)
{
DataGridViewBinding2();
MessageBox.Show("입고대기가 완료 되었습니다.");
}
}
private void DataGridViewBinding2()
{
try
{
COMPANY.DataSource = null;
ReorderService service = new ReorderService();
COMPANY.DataSource = service.Inspection2();
}
catch (Exception err)
{
this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
}
}
public void Search(object sender, EventArgs e)
{
if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this)
{
string day1 = sday.Value.ToShortDateString();
string day2 = eday.Value.ToShortDateString();
string code1 = COM_CODE_OUT.Text;
string name = textBox1.Text;
string reorder = REORDER_CODE.Text;
string cod2 = COM_CODE_IN.Text;
ReorderService service = new ReorderService();
dgv1.DataSource = service.SPGetWarehousingWait(day1, day2, code1, name, reorder, cod2);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
int a = 0;
int bqty = 0;
int gqty = 0;
int reorder = 0;
int reorderD = 0;
string code = "";
string id = "";
COMPANY.EndEdit();
ReorderService service = new ReorderService();
foreach (DataGridViewRow item in COMPANY.Rows)
{
if (Convert.ToBoolean(item.Cells[1].Value) == true)
{
if (item.Cells[11].Value == null)
{
bqty = 0;
}
else
{
bqty = Convert.ToInt32(item.Cells[11].Value);
}
gqty = Convert.ToInt32(item.Cells[10].Value);
bqty = Convert.ToInt32(item.Cells[11].Value);
reorder = Convert.ToInt32(item.Cells[2].Value);
reorderD = Convert.ToInt32(item.Cells[3].Value);
code = item.Cells[7].Value.ToString();
id = item.Cells[12].Value.ToString();
service.insertInspection(gqty, bqty, reorder, reorderD, code, id);
a++;
}
}
if (a == 0)
{
MessageBox.Show("검사할 발주를 선택해주세요");
return;
}
DataGridViewBinding2();
MessageBox.Show("검사가 완료 되었습니다.");
Reset(null, null);
}
catch (Exception err)
{
this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
}
}
/// <summary>
/// 조회 버튼 이벤드
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void Search(object sender, EventArgs e)
{
if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this)
{
ReorderService service = new ReorderService();
dgvReorder.DataSource = null;
dgvReorder.DataSource = service.GetSearchREORDER(
sday.Value.ToShortDateString()
, eday.Value.ToShortDateString()
, (COM_CODE_OUT.Text.Length < 1) ? "" : COM_CODE_OUT.Text
, (ITEM_CODE.Text.Length < 1) ? "" : ITEM_CODE.SelectedValue.ToString()
, REORDER_STATE.Text
, REORDER_CODE.Text
, (COM_CODE_IN.Text.Length < 1) ? "": COM_CODE_IN.Text);;
}
}
private void dgv1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
dgv1.EndEdit();
StringBuilder sb = new StringBuilder();
foreach (DataGridViewRow item in dgv1.Rows)
{
if (Convert.ToBoolean(item.Cells[1].Value) == true)
{
sb.Append("'" + item.Cells[2].Value.ToString() + "',");
}
}
if (sb.ToString().Length < 1)
{
return;
}
ReorderService service = new ReorderService();
dgv2.DataSource = service.GetReorderItem2(sb.ToString().TrimEnd(','));
}
private void button1_Click(object sender, EventArgs e)
{
dgvReorder.EndEdit();
StringBuilder sb = new StringBuilder();
int cnt = 0;
//품목 선택후 List를 전달
foreach (DataGridViewRow item in dgvReorder.Rows)
{
if (Convert.ToBoolean(item.Cells[1].Value))
{
if (item.Cells[5].Value.ToString() != "발주")
{
MessageBox.Show("발주 상태만 취소 가능합니다.");
return;
}
sb.Append(item.Cells[2].Value.ToString() + "@");
cnt++;
}
}
if (sb.Length < 1)
{
MessageBox.Show("취소할 항목을 선택하여 주십시오.");
return;
}
sb.Remove(sb.Length - 1, 1);
if (MessageBox.Show($"총 {cnt}개의 항목의 삭제 하시겠습니까?", "삭제", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
ReorderService item = new ReorderService();
if (item.DeleteREORDER(sb.ToString()))
{
;
}
{
MessageBox.Show($"총 {cnt}개 발주가 삭제되었습니다.");
DataGridViewBinding();
}
}
}
public void Search(object sender, EventArgs e)
{
if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this)
{
try
{
string day1 = sday.Value.ToShortDateString();
string day2 = eday.Value.ToShortDateString();
string com = REORDER_COM.Text;
string name = ITEMNAME.Text;
string inspect = INSPECT.Text;
string code = REORDER_CODE.Text;
ReorderService service = new ReorderService();
dgv1.DataSource = null;
dgv1.DataSource = service.SP_Inspection(day1, day2, com, name, inspect, code);
}
catch (Exception err)
{
this.Log.WriteError($"[[RECV {this.Name}]]:{err.Message}");
}
}
}
private void button2_Click(object sender, EventArgs e)
{
dgvReorder.EndEdit();
StringBuilder sb = new StringBuilder();
int cnt = 0;
//품목 선택후 List를 전달
foreach (DataGridViewRow item in dgvReorder.Rows)
{
if (Convert.ToBoolean(item.Cells[1].Value))
{
sb.Append(item.Cells[2].Value.ToString() + "@");
cnt++;
}
}
if (sb.Length < 1)
{
MessageBox.Show("납기일을 변경할 항목을 선택하여 주십시오.");
return;
}
sb.Remove(sb.Length - 1, 1);
if (MessageBox.Show($"총 {cnt}개의 항목의 납기일을 변경 하시겠습니까?", "변경", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
FrmReorderSearchPopUp frm = new FrmReorderSearchPopUp();
if (frm.ShowDialog() == DialogResult.OK)
{
ReorderService item = new ReorderService();
if (item.UpDateREORDER(frm.day, LoginInfo.UserInfo.LI_ID, sb.ToString()))
{
;
}
{
MessageBox.Show($"총 {cnt}개 의 납기일이 변경되었습니다.");
DataGridViewBinding();
}
}
}
}
/// <summary>
/// 데이터 그리드 바인딩
/// </summary>
private void DataGridViewBinding()
{
ReorderService item = new ReorderService();
dgvReorder.DataSource = item.SelectREORDER();
}
private void button2_Click(object sender, EventArgs e)
{
ReorderService service = new ReorderService();
dgv2.DataSource = service.GetSearchReorder2(ITEM_COM_REORDER.Text, ITEM_NAEM.Text);
}
