private void all_chk_logic(conDataGridView dgv, string condition, TextBox txt_item_cd)
{
try
{
if (txt_item_cd.Text.ToString().Equals("") || txt_item_cd.Text == null)
{
MessageBox.Show("제품정보가 없습니다. ");
return;
}
if (dgv.Rows.Count > 0)
{
MessageBox.Show("항목 데이터가 존재합니다. ");
return;
}
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
sb.AppendLine("where 1=1 ");
sb.AppendLine(condition); //"and A.CHK_GUBUN = '1'"
dt = wDm.fn_Chk_List(sb.ToString());
if (dt != null && dt.Rows.Count > 0)
{
dgv.RowCount = dt.Rows.Count;
for (int i = 0; i < dt.Rows.Count; i++)
{
dgv.Rows[i].Cells[1].Value = (i + 1).ToString();
dgv.Rows[i].Cells[13].Value = dt.Rows[i]["CHK_CD"].ToString();
dgv.Rows[i].Cells[17].Value = dt.Rows[i]["CHK_ORD"].ToString();
dgv.Rows[i].Cells[2].Value = dt.Rows[i]["CHK_NM"].ToString();
//dgv.Rows[i].Cells[4].Value = dt.Rows[i]["CHK_LOC"].ToString();
//dgv.Rows[i].Cells[5].Value = dt.Rows[i]["RULE_SIZE"].ToString();
//dgv.Rows[i].Cells[6].Value = dt.Rows[i]["RULE_LIMIT"].ToString();
//dgv.Rows[i].Cells[7].Value = dt.Rows[i]["MEASURE_APP"].ToString();
//dgv.Rows[i].Cells[8].Value = dt.Rows[i]["CHK_INTEVAL"].ToString();
dgv.Rows[i].Cells[9].Value = "0";
dgv.Rows[i].Cells[10].Value = "0";
dgv.Rows[i].Cells[11].Value = "0";
dgv.Rows[i].Cells[12].Value = "0";
}
}
else
{
MessageBox.Show("검사 기준 정보가없습니다.");
}
}
catch (Exception ex)
{
MessageBox.Show("시스템 에러: " + ex.Message.ToString());
Popup.pop오류리포트 msg = new Popup.pop오류리포트(ex.Message + " - " + ex.ToString());
msg.ShowDialog();
}
}
private void grid_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
if (e.ColumnIndex < 0)
{
return;
}
conDataGridView grd = (conDataGridView)sender;
// 수량, 금액 = 0 자료 구분
grd.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.Gray;
grd.Rows[e.RowIndex].DefaultCellStyle.SelectionForeColor = Color.Gray;
//// 수량, 금액 != 0 자료 구분
//if (grd.Rows[e.RowIndex].Cells[7].Value != null && grd.Rows[e.RowIndex].Cells[9].Value != null)
//{
// if (decimal.Parse("" + (string)grd.Rows[e.RowIndex].Cells[7].Value) > 0 && decimal.Parse("" + (string)grd.Rows[e.RowIndex].Cells[9].Value) > 0)
// {
// grd.Rows[e.RowIndex].DefaultCellStyle.ForeColor = Color.Black;
// grd.Rows[e.RowIndex].DefaultCellStyle.SelectionForeColor = Color.Black;
// }
//}
}
private void grid_KeyDown(object sender, KeyEventArgs e)
{
// Edit 모드가 아닐때, 작동함.
conDataGridView grd = (conDataGridView)sender;
DataGridViewCell cell = grd[grd.CurrentCell.ColumnIndex, grd.CurrentCell.RowIndex];
if (grd.CurrentCell == null)
{
return;
}
if (grd.CurrentCell.RowIndex < 0)
{
return;
}
if (grd.CurrentCell.ColumnIndex < 0)
{
return;
}
if (e.KeyCode == Keys.Enter)
{
SendKeys.Send("{TAB}");
e.Handled = true;
}
}
private void grid_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
// 헤더 첫 컬럼 클릭시
if (e.ColumnIndex != 0)
{
return;
}
if (bHeadCheck == false)
{
grd.Columns[0].HeaderText = "[v]";
bHeadCheck = true;
select_Check(grd, bHeadCheck);
}
else
{
grd.Columns[0].HeaderText = "[ ]";
bHeadCheck = false;
select_Check(grd, bHeadCheck);
}
grd.RefreshEdit();
grd.Refresh();
}
private void grid_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
grd.Rows[e.RowIndex].Cells[0].Value = false;
// No.
grd.Rows[e.RowIndex].Cells[1].Style.BackColor = Color.WhiteSmoke;
grd.Rows[e.RowIndex].Cells[1].Style.SelectionBackColor = Color.Khaki;
// 코드
grd.Rows[e.RowIndex].Cells[4].Style.BackColor = Color.WhiteSmoke;
grd.Rows[e.RowIndex].Cells[4].Style.SelectionBackColor = Color.Khaki;
// 규격
grd.Rows[e.RowIndex].Cells[6].Style.BackColor = Color.WhiteSmoke;
grd.Rows[e.RowIndex].Cells[6].Style.SelectionBackColor = Color.Khaki;
// 금액
grd.Rows[e.RowIndex].Cells[9].Style.BackColor = Color.WhiteSmoke;
grd.Rows[e.RowIndex].Cells[9].Style.SelectionBackColor = Color.Khaki;
// 계약율
grd.Rows[e.RowIndex].Cells[12].Style.BackColor = Color.WhiteSmoke;
grd.Rows[e.RowIndex].Cells[12].Style.SelectionBackColor = Color.Khaki;
wConst.init_RowText(grd, e.RowIndex);
for (int kk = 0; kk < grd.Rows.Count; kk++)
{
grd.Rows[kk].Cells[1].Value = (kk + 1).ToString();
}
}
private void grid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
DataGridViewCell cell = grd[e.ColumnIndex, e.RowIndex];
cell.Style.BackColor = Color.White;
#region 공통 그리드 체크
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("명칭") >= 0 && grd._KeyInput == "enter")
{
string chk_nm = (string)grd.Rows[e.RowIndex].Cells["CHK_NM"].Value;
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
sb.AppendLine("where 1=1 ");
if (chk_nm != null)
{
sb.AppendLine(" and CHK_NM like '%" + chk_nm + "%' ");
}
int chk = 0;
if (grd.Name.ToString().Equals("FlowChkGrid"))
{
chk = 1;
sb.AppendLine(" and CHK_GUBUN = '1' ");
}
else
{
chk = 2;
sb.AppendLine(" and CHK_GUBUN = '2' ");
}
dt = wDm.fn_Chk_List(sb.ToString());
if (dt.Rows.Count > 1)
{
wConst.call_pop_chk(grd, dt, e.RowIndex, chk_nm, chk);
}
else if (dt.Rows.Count == 1) //row가 1일 경우 해당 row에 값을 자동 입력한다.
{
grd.Rows[e.RowIndex].Cells[1].Value = (e.RowIndex + 1).ToString();
grd.Rows[e.RowIndex].Cells["CHK_CD"].Value = dt.Rows[0]["CHK_CD"].ToString();
grd.Rows[e.RowIndex].Cells["CHK_ORD"].Value = dt.Rows[0]["CHK_ORD"].ToString();
grd.Rows[e.RowIndex].Cells["CHK_NM"].Value = dt.Rows[0]["CHK_NM"].ToString();
grd.Rows[e.RowIndex].Cells["OLD_CHK_NM"].Value = dt.Rows[0]["CHK_NM"].ToString();
grd.Rows[e.RowIndex].Cells["OLD_CHK_CD"].Value = dt.Rows[0]["CHK_CD"].ToString();
}
else
{
//row가 없는 경우
MessageBox.Show("데이터가 없습니다.");
}
}
#endregion 공통 그리드 체크
//string sSearchTxt = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
}
private void chkGridAdd(conDataGridView dgv)
{
dgv.Rows.Add();
dgv.Rows[dgv.Rows.Count - 1].Cells[9].Value = "0";
dgv.Rows[dgv.Rows.Count - 1].Cells[10].Value = "0";
dgv.Rows[dgv.Rows.Count - 1].Cells[11].Value = "0";
dgv.Rows[dgv.Rows.Count - 1].Cells[12].Value = "0";
}
private void btn_item_all_chk_Click(object sender, EventArgs e)
{
conDataGridView dgv = ItemChkGrid;
StringBuilder sb = new StringBuilder();
sb.AppendLine("and A.CHK_GUBUN = '2' ");
all_chk_logic(dgv, sb.ToString(), txt_item_cd2);
}
private void grid_RowsRemoved(object sender, DataGridViewRowsRemovedEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
for (int kk = 0; kk < grd.Rows.Count; kk++)
{
grd.Rows[kk].Cells[1].Value = (kk + 1).ToString();
}
}
private void grid_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
grd.Rows[e.RowIndex].Cells[0].Value = false;
// No.
grd.Rows[e.RowIndex].Cells[1].Style.BackColor = Color.WhiteSmoke;
grd.Rows[e.RowIndex].Cells[1].Style.SelectionBackColor = Color.Khaki;
}
public static void gridHeaderSet(conDataGridView dgv)
{
dgv.AllowUserToAddRows = false;
dgv.AllowUserToDeleteRows = false;
dgv.AllowUserToOrderColumns = false;
dgv.AllowUserToResizeColumns = false;
dgv.AllowUserToResizeRows = false;
foreach (DataGridViewColumn i in dgv.Columns)
{
i.SortMode = DataGridViewColumnSortMode.NotSortable;
}
}
private void grid_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
grd.Rows[e.RowIndex].Cells[0].Value = false;
//wConst.init_RowText(grd, e.RowIndex);
for (int kk = 0; kk < grd.Rows.Count; kk++)
{
grd.Rows[kk].Cells[1].Value = (kk + 1).ToString();
}
}
private void select_Check(conDataGridView grd, bool bCheck)
{
for (int kk = 0; kk < grd.Rows.Count; kk++)
{
if (bCheck == true)
{
grd.Rows[kk].Cells[0].Value = true;
}
else
{
grd.Rows[kk].Cells[0].Value = false;
}
}
}
//숫자만 입력
private void grid_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
int idx = grd.CurrentCell.ColumnIndex;
if (idx == 3 || idx == 4 || idx == 6)
{
e.Control.KeyPress += new KeyPressEventHandler(txtCheckNumeric_KeyPress);
}
else
{
e.Control.KeyPress -= new KeyPressEventHandler(txtCheckNumeric_KeyPress);
}
}
private void minus_logic(conDataGridView dgv)
{
if (dgv.Rows.Count > 1)
{
if ((string)dgv.SelectedRows[0].Cells["SEQ"].Value != "" && dgv.SelectedRows[0].Cells["SEQ"].Value != null)
{
del_orderGrid.Rows.Add();
del_orderGrid.Rows[del_orderGrid.Rows.Count - 1].Cells["ORDER_DATE"].Value = txt_order_date.Text.ToString();
del_orderGrid.Rows[del_orderGrid.Rows.Count - 1].Cells["ORDER_CD"].Value = txt_order_cd.Text.ToString();
del_orderGrid.Rows[del_orderGrid.Rows.Count - 1].Cells["SEQ"].Value = dgv.SelectedRows[0].Cells["SEQ"].Value;
}
dgv.Rows.RemoveAt(dgv.SelectedRows[0].Index);
dgv.CurrentCell = dgv[2, dgv.Rows.Count - 1];
}
}
//버튼 출력 관련
private void grid_CellContent(object sender, DataGridViewCellEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
if (grd.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0)
{
if (((DataGridViewButtonColumn)grd.Columns["O_BTN_OUT"]).ReadOnly == true)
{
MessageBox.Show("자체 출고로 인해 출하 불가");
}
else
{
if ((string)grd.Rows[e.RowIndex].Cells["OUT_INST_YN"].Value != "Y") //출하 지시 내리지 않았을 경우
{
if ((string)grd.Rows[e.RowIndex].Cells["O_INPUT_DATE"].Value != "" && (string)grd.Rows[e.RowIndex].Cells["O_INPUT_CD"].Value != "") //출고 번호가 있을 경우에만 출하지시 등록
{
wnDm wDm = new wnDm();
int rsNum = wDm.insertItemOutInst(
txt_out_date.Text.ToString(),
txt_out_cd.Text.ToString(),
(string)itemOutGrid.Rows[e.RowIndex].Cells["SEQ"].Value);
if (rsNum == 0)
{
itemOutGrid.Rows[e.RowIndex].Cells["O_BTN_OUT"].Value = "완료";
itemOutGrid.Rows[e.RowIndex].Cells["OUT_INST_YN"].Value = "Y";
output_list(tdOutGrid, "where convert(varchar(10), A.INTIME, 120) = convert(varchar(10), getDate(), 120) ", "");
output_list(outputGrid, "where A.OUTPUT_DATE >= '" + txt_start_date.Text.ToString() + "' and A.OUTPUT_DATE <= '" + txt_end_date.Text.ToString() + "'", "");
MessageBox.Show("출하지시 완료 하였습니다.");
}
}
else
{
MessageBox.Show("출고번호가 없어 등록이 불가능합니다.");
}
}
else
{
MessageBox.Show("출고 이미 완료");
}
}
}
}
private void grid_CellEndEdit(object sender, DataGridViewCellEventArgs e) //원재료 검색
{
conDataGridView grd = (conDataGridView)sender;
DataGridViewCell cell = grd[e.ColumnIndex, e.RowIndex];
cell.Style.BackColor = Color.White;
#region 공통 그리드 체크
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("명칭") >= 0 && grd._KeyInput == "enter")
{
string rat_mat_nm = (string)grd.Rows[e.RowIndex].Cells["RAW_MAT_NM"].Value;
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
dt = wDm.fn_Raw_List("where RAW_MAT_NM like '%" + rat_mat_nm + "%' ");
if (dt.Rows.Count > 1)
{ //row가 2줄이 넘을 경우 팝업으로 넘어간다.
Console.WriteLine("popup");
wConst.call_pop_raw_mat(grd, dt, e.RowIndex, rat_mat_nm, 1);
//itemCompGridAdd();
}
else if (dt.Rows.Count == 1) //row가 1일 경우 해당 row에 값을 자동 입력한다.
{
grd.Rows[e.RowIndex].Cells["RAW_MAT_CD"].Value = dt.Rows[0]["RAW_MAT_CD"].ToString();
grd.Rows[e.RowIndex].Cells["RAW_MAT_NM"].Value = dt.Rows[0]["RAW_MAT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["OLD_RAW_MAT_NM"].Value = dt.Rows[0]["RAW_MAT_NM"].ToString(); //백업 키워드
grd.Rows[e.RowIndex].Cells["SPEC"].Value = dt.Rows[0]["SPEC"].ToString();
grd.Rows[e.RowIndex].Cells["IN_UNIT"].Value = dt.Rows[0]["INPUT_UNIT"].ToString();
grd.Rows[e.RowIndex].Cells["OUT_UNIT"].Value = dt.Rows[0]["OUTPUT_UNIT"].ToString();
grd.Rows[e.RowIndex].Cells["IN_UNIT_NM"].Value = dt.Rows[0]["INPUT_UNIT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["OUT_UNIT_NM"].Value = dt.Rows[0]["OUTPUT_UNIT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
itemCompGridAdd();
}
else
{ //row가 없는 경우
MessageBox.Show("데이터가 없습니다.");
}
}
#endregion 공통 그리드 체크
//string sSearchTxt = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
}
private void minus_logic(conDataGridView dgv)
{
if (dgv.Rows.Count > 1)
{
if (dgv.SelectedRows[0].Cells["SEQ"].Value != null && !dgv.SelectedRows[0].Cells["SEQ"].Value.ToString().Equals(""))
{
del_estiGrid.Rows.Add();
del_estiGrid.Rows[del_estiGrid.Rows.Count - 1]["ESTI_DATE"] = txt_esti_date.Text.ToString();
del_estiGrid.Rows[del_estiGrid.Rows.Count - 1]["ESTI_CD"] = txt_esti_cd.Text.ToString();
del_estiGrid.Rows[del_estiGrid.Rows.Count - 1]["SEQ"] = dgv.SelectedRows[0].Cells["SEQ"].Value;
}
dgv.Rows.RemoveAt(dgv.SelectedRows[0].Index);
dgv.CurrentCell = dgv[2, dgv.Rows.Count - 1];
}
}
private void grid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
DataGridViewCell cell = grd[e.ColumnIndex, e.RowIndex];
//cell.Style.BackColor = Color.White;
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("수량") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("단가") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("금액") >= 0)
{
string total_amt = (string)grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value;
string price = (string)grd.Rows[e.RowIndex].Cells["PRICE"].Value;
if (total_amt != null)
{
total_amt = total_amt.ToString().Replace(" ", "");
if (total_amt == "")
{
grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
}
if (price != null)
{
price = price.ToString().Replace(" ", "");
if (price == "")
{
grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
}
wConst.f_Calc_Price(grd, e.RowIndex, "TOTAL_AMT", "PRICE");
}
}
private void minus_logic(conDataGridView dgv, DataGridView del_dgv)
{
if (dgv.Rows.Count > 1)
{
if ((string)dgv.SelectedRows[0].Cells["ITEM_CD"].Value != "" && dgv.SelectedRows[0].Cells["ITEM_CD"].Value != null)
{
del_dgv.Rows.Add();
del_dgv.Rows[del_dgv.Rows.Count - 1].Cells["CHK_CD"].Value = dgv.SelectedRows[0].Cells["CHK_CD"].Value;
del_dgv.Rows[del_dgv.Rows.Count - 1].Cells["ITEM_CD"].Value = dgv.SelectedRows[0].Cells["ITEM_CD"].Value;
}
dgv.Rows.RemoveAt(dgv.SelectedRows[0].Index);
dgv.CurrentCell = dgv[2, dgv.Rows.Count - 1];
for (int i = 0; i < dgv.Rows.Count; i++)
{
dgv.Rows[i].Cells[1].Value = (i + 1).ToString();
}
}
}
private void grid_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
{
// 폼 로딩시에는, 저장 안함.
if (bSetFirst == true)
{
return;
}
conDataGridView grd = (conDataGridView)sender;
sColumnsWW = "";
for (int kk = 0; kk < grd.Columns.Count; kk++)
{
if (kk > 0)
{
sColumnsWW += ",";
}
sColumnsWW += grd.Columns[kk].Width.ToString();
}
Save_Layout();
}
private void all_chk_logic(conDataGridView dgv, string condition, TextBox txt_raw_mat_cd)
{
if (txt_raw_mat_cd.Text.ToString().Equals(""))
{
MessageBox.Show("원자재 정보가 없습니다. ");
return;
}
if (dgv.Rows.Count > 0)
{
MessageBox.Show("항목 데이터가 존재합니다. ");
return;
}
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
sb.AppendLine("where 1=1 ");
sb.AppendLine(condition);//"and A.CHK_GUBUN = '3'"
dt = wDm.fn_Chk_List(sb.ToString());
if (dt != null && dt.Rows.Count > 0)
{
dgv.RowCount = dt.Rows.Count;
for (int i = 0; i < dt.Rows.Count; i++)
{
dgv.Rows[i].Cells["NO"].Value = (i + 1).ToString();
dgv.Rows[i].Cells["CHK_CD"].Value = dt.Rows[i]["CHK_CD"].ToString();
dgv.Rows[i].Cells["CHK_ORD"].Value = dt.Rows[i]["CHK_ORD"].ToString();
dgv.Rows[i].Cells["CHK_NM"].Value = dt.Rows[i]["CHK_NM"].ToString();
}
}
else
{
MessageBox.Show("데이터 일시 오류");
}
}
private void grid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
DataGridViewCell cell = grd[e.ColumnIndex, e.RowIndex];
cell.Style.BackColor = Color.White;
#region 공통 그리드 체크 ###################################################################
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("수량") >= 0)
{
try
{
cell.Value = (Math.Floor(decimal.Parse("" + (string)cell.Value) * 100) / 100).ToString("#,0.##");
}
catch
{
cell.Value = "0";
}
}
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("단가") >= 0)
{
try
{
cell.Value = (Math.Floor(decimal.Parse("" + (string)cell.Value) * 10000000) / 10000000).ToString("#,0.#######");
}
catch
{
cell.Value = "0";
}
}
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("금액") >= 0)
{
try
{
cell.Value = (Math.Floor(decimal.Parse("" + (string)cell.Value) * 1) / 1).ToString("#,0");
}
catch
{
cell.Value = "0";
}
}
#endregion 공통 그리드 체크 ###################################################################
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("명칭") >= 0 && grd._KeyInput == "enter")
{
if (txt거래처코드.Text == "")
{
MessageBox.Show("[ 거래처 ]를 입력하세요.");
tmCellBack.Enabled = true;
return;
}
string sSearchTxt = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
if (sSearchTxt == "")
{
grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 3].Value = "";
grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 2].Value = "";
grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 1].Value = "";
}
string sOldCode = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 3].Value;
string sOldName = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 2].Value;
if (sOldCode == "" || sOldName != sSearchTxt)
{
wConst.call_pop_Prod(grd, e.RowIndex, sSearchTxt, txt거래처코드.Text, e.ColumnIndex - 1, e.ColumnIndex, "0");
string sFindCode = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 1].Value;
// 상품 중복입력 체크 ================================================
if (sFindCode != "")
{
for (int kk = 0; kk < grd.Rows.Count; kk++)
{
if (kk != e.RowIndex)
{
if ("" + (string)grd.Rows[kk].Cells[e.ColumnIndex - 1].Value == sFindCode)
{
MessageBox.Show("이미 입력한 제품입니다.");
sFindCode = "";
break;
}
}
}
}
// 상품 중복입력 체크 ================================================ end
if (sOldCode != sFindCode)
{
//wConst.get_Prod_Info(grd, e.RowIndex, sFindCode, txt거래처코드.Text, txt특매처.Text, txt거래형태.Text, txt주사제퍼센트.Text, txt도매퍼센트.Text);
//wConst.Calc_Price(grd, e.RowIndex);
grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 3].Value = grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 1].Value;
grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 2].Value = grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 0].Value;
}
else
{
grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 0].Value = sOldName;
}
if (sFindCode == "")
{
wConst.init_RowText(grd, e.RowIndex);
}
}
}
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("명칭") >= 0 && grd._KeyInput != "enter")
{
string sCurrCode = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex - 1].Value;
string sSearchTxt = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
if (sSearchTxt == "")
{
wConst.init_RowText(grd, e.RowIndex);
}
else
{
//wConst.get_Prod_Info_Code(grd, e.RowIndex, sCurrCode);
if ("" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex].Value == "")
{
wConst.init_RowText(grd, e.RowIndex);
}
}
}
}
private void grid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
DataGridViewCell cell = grd[e.ColumnIndex, e.RowIndex];
cell.Style.BackColor = Color.White;
#region 공통 그리드 체크
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("명칭") >= 0 && grd._KeyInput == "enter")
{
string rat_mat_nm = (string)grd.Rows[e.RowIndex].Cells["RAW_MAT_NM"].Value;
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
dt = wDm.fn_Raw_List("where RAW_MAT_NM like '%" + rat_mat_nm + "%' ");
if (dt.Rows.Count > 1)
{ //row가 2줄이 넘을 경우 팝업으로 넘어간다.
wConst.call_pop_raw_mat(grd, dt, e.RowIndex, rat_mat_nm, 2);
//orderGridAdd();
}
else if (dt.Rows.Count == 1) //row가 1일 경우 해당 row에 값을 자동 입력한다.
{
grd.Rows[e.RowIndex].Cells["RAW_MAT_CD"].Value = dt.Rows[0]["RAW_MAT_CD"].ToString();
grd.Rows[e.RowIndex].Cells["RAW_MAT_NM"].Value = dt.Rows[0]["RAW_MAT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["OLD_RAW_MAT_NM"].Value = dt.Rows[0]["RAW_MAT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["SPEC"].Value = dt.Rows[0]["SPEC"].ToString();
grd.Rows[e.RowIndex].Cells["UNIT_CD"].Value = dt.Rows[0]["INPUT_UNIT"].ToString();
grd.Rows[e.RowIndex].Cells["UNIT_NM"].Value = dt.Rows[0]["INPUT_UNIT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["PRICE"].Value = dt.Rows[0]["INPUT_PRICE"].ToString();
grd.Rows[e.RowIndex].Cells["BOX_AMT"].Value = dt.Rows[0]["BOX_AMT"].ToString();
orderGridAdd();
}
else
{ //row가 없는 경우
MessageBox.Show("데이터가 없습니다.");
}
//wConst.f_Calc_Price(grd, e.RowIndex, "TOTAL_AMT", "PRICE");
wConst.f_Calc_PriceAndBox(grd, e.RowIndex, "TOTAL_AMT", "PRICE", "BOX_AMT");
//wConst.f_Calc_Box(grd, e.RowIndex, "TOTAL_AMT", "BOX_AMT");
}
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("수량") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("단가") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("금액") >= 0)
{
string total_amt = (string)grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value;
string input_price = (string)grd.Rows[e.RowIndex].Cells["PRICE"].Value;
string box_amt = (string)grd.Rows[e.RowIndex].Cells["BOX_AMT"].Value;
if (total_amt != null)
{
total_amt = total_amt.ToString().Replace(" ", "");
if (total_amt == "")
{
grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
}
if (input_price != null)
{
input_price = input_price.ToString().Replace(" ", "");
if (input_price == "")
{
grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
}
if (box_amt != null)
{
box_amt = box_amt.ToString().Replace(" ", "");
if (box_amt == "")
{
grd.Rows[e.RowIndex].Cells["BOX_AMT"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["BOX_AMT"].Value = "0";
}
//wConst.f_Calc_Price(grd, e.RowIndex, "TOTAL_AMT", "PRICE");
wConst.f_Calc_PriceAndBox(grd, e.RowIndex, "TOTAL_AMT", "PRICE", "BOX_AMT");
}
#endregion 공통 그리드 체크
//string sSearchTxt = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
}
private void saveLogic()
{
if (txt_raw_mat_cd.Text.ToString().Equals(""))
{
MessageBox.Show("원자재 정보가 없습니다. ");
return;
}
conDataGridView dgv = rawChkGrid;
if (dgv.Rows.Count == 0)
{
MessageBox.Show("항목 데이터를 입력하셔야 합니다. ");
return;
}
if (lbl_raw_chk_gbn.Text != "1") //신규
{
wnDm wDm = new wnDm();
int rsNum = wDm.insertRawChk(txt_raw_mat_cd.Text.ToString()
, txt_control_no.Text.ToString()
, dgv);
if (rsNum == 0)
{
chk_logic();
lbl_raw_chk_gbn.Text = "1";
MessageBox.Show("성공적으로 등록하였습니다.");
}
else if (rsNum == 1)
{
MessageBox.Show("저장에 실패하였습니다");
}
else if (rsNum == 2)
{
MessageBox.Show("SQL COMMAND 에러");
}
else if (rsNum == 3)
{
MessageBox.Show("기존 코드가 있으니 \n 다른 코드로 입력 바랍니다.");
}
else
{
MessageBox.Show("Exception 에러");
}
}
else
{
wnDm wDm = new wnDm();
int rsNum = wDm.updateRawChk(txt_raw_mat_cd.Text.ToString()
, txt_control_no.Text.ToString()
, dgv
, del_rawGrid);
if (rsNum == 0)
{
chk_logic();
MessageBox.Show("성공적으로 수정하였습니다.");
}
else if (rsNum == 1)
{
MessageBox.Show("저장에 실패하였습니다");
}
else if (rsNum == 2)
{
MessageBox.Show("SQL COMMAND 에러");
}
else if (rsNum == 3)
{
MessageBox.Show("기존 코드가 있으니 \n 다른 코드로 입력 바랍니다.");
}
else
{
MessageBox.Show("Exception 에러");
}
}
}
private void grid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
DataGridViewCell cell = grd[e.ColumnIndex, e.RowIndex];
cell.Style.BackColor = Color.White;
#region 공통 그리드 체크
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("명칭") >= 0 && grd._KeyInput == "enter")
{
string item_nm = (string)grd.Rows[e.RowIndex].Cells["ITEM_NM"].Value;
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
//dt = wDm.fn_Raw_Item_List("where A.RAW_MAT_NM like '%" + item_nm + "%' ","where B.ITEM_NM like '%" + item_nm + "%' ");
if (dt != null && dt.Rows.Count > 0)
{ //row가 2줄이 넘을 경우 팝업으로 넘어간다.
Popup.pop_sf_제품검색 frm = new Popup.pop_sf_제품검색();
//frm.sUsedYN = sUsedYN;
frm.dt = dt;
frm.txtSrch.Text = item_nm;
frm.ShowDialog();
string sCode = frm.sCode;
if (frm.sCode != "")
{
itemEstimateGrid.Rows[e.RowIndex].Cells["ITEM_CD"].Value = frm.sCode;
itemEstimateGrid.Rows[e.RowIndex].Cells["ITEM_NM"].Value = frm.sName;
itemEstimateGrid.Rows[e.RowIndex].Cells["UNIT_CD"].Value = frm.sUnitCd;
itemEstimateGrid.Rows[e.RowIndex].Cells["UNIT_NM"].Value = frm.sUnitNm;
itemEstimateGrid.Rows[e.RowIndex].Cells["VAT_CD"].Value = frm.sVatCd;
/* itemEstimateGrid.Rows[e.RowIndex].Cells["LABEL_NM"].Value = frm.sLabelNM;
* itemEstimateGrid.Rows[e.RowIndex].Cells["CHUGJONG_NM"].Value = frm.sChugjong_NM;
* itemEstimateGrid.Rows[e.RowIndex].Cells["CLASS_NM"].Value = frm.sClass_nm;
* itemEstimateGrid.Rows[e.RowIndex].Cells["COUNTRY_NM"].Value = frm.sCountry_nm;
* itemEstimateGrid.Rows[e.RowIndex].Cells["RAW_ITEM_GUBUN"].Value = frm.sGubun;
* itemEstimateGrid.Rows[e.RowIndex].Cells["TYPE_NM"].Value = frm.sType_nm;
* * */
}
}
else
{
Popup.pop_sf_제품검색 frm = new Popup.pop_sf_제품검색();
//dt = wDm.fn_Raw_Item_List("where 1=1 ", "where 1=1 ");
//frm.sUsedYN = sUsedYN;
frm.dt = dt;
frm.txtSrch.Text = item_nm;
frm.ShowDialog();
string sCode = frm.sCode;
if (frm.sCode != "")
{
itemEstimateGrid.Rows[e.RowIndex].Cells["ITEM_CD"].Value = frm.sCode;
itemEstimateGrid.Rows[e.RowIndex].Cells["ITEM_NM"].Value = frm.sName;
itemEstimateGrid.Rows[e.RowIndex].Cells["UNIT_CD"].Value = frm.sUnitCd;
itemEstimateGrid.Rows[e.RowIndex].Cells["UNIT_NM"].Value = frm.sUnitNm;
itemEstimateGrid.Rows[e.RowIndex].Cells["VAT_CD"].Value = frm.sVatCd;
/*
* itemEstimateGrid.Rows[e.RowIndex].Cells["LABEL_NM"].Value = frm.sLabelNM;
* itemEstimateGrid.Rows[e.RowIndex].Cells["CHUGJONG_NM"].Value = frm.sChugjong_NM;
* itemEstimateGrid.Rows[e.RowIndex].Cells["CLASS_NM"].Value = frm.sClass_nm;
* itemEstimateGrid.Rows[e.RowIndex].Cells["COUNTRY_NM"].Value = frm.sCountry_nm;
* itemEstimateGrid.Rows[e.RowIndex].Cells["RAW_ITEM_GUBUN"].Value = frm.sGubun;
* itemEstimateGrid.Rows[e.RowIndex].Cells["TYPE_NM"].Value = frm.sType_nm;
*
* */
}
}
}
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("수량") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("단가") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("금액") >= 0)
{
string total_amt = (string)grd.Rows[e.RowIndex].Cells["OUT_AMT"].Value;
string price = (string)grd.Rows[e.RowIndex].Cells["OUT_PRICE"].Value;
if (total_amt != null)
{
total_amt = total_amt.ToString().Replace(" ", "");
if (total_amt == "")
{
grd.Rows[e.RowIndex].Cells["OUT_AMT"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["OUT_AMT"].Value = "0";
}
if (price != null)
{
price = price.ToString().Replace(" ", "");
if (price == "")
{
grd.Rows[e.RowIndex].Cells["OUT_PRICE"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["OUT_PRICE"].Value = "0";
}
//if (total_amt == "" || total_amt == null)
//{
// grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
//}
//if (price == "" || price == null)
//{
// grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
//}
cal_tax(e.RowIndex);
string item_cd_chk = (string)grd.Rows[e.RowIndex].Cells["ITEM_CD"].Value;
}
#endregion 공통 그리드 체크
//string sSearchTxt = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
}
private void grid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
DataGridViewCell cell = grd[e.ColumnIndex, e.RowIndex];
cell.Style.BackColor = Color.White;
#region 공통 그리드 체크
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("명칭") >= 0 && grd._KeyInput == "enter")
{
string item_nm = (string)grd.Rows[e.RowIndex].Cells["ITEM_NM"].Value;
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
dt = wDm.fn_Raw_Item_List("where A.RAW_MAT_NM like '%" + item_nm + "%' ", "where B.ITEM_NM like '%" + item_nm + "%' ");
if (dt.Rows.Count > 0)
{ //row가 2줄이 넘을 경우 팝업으로 넘어간다.
string sResult = wConst.CZM_call_pop_raw_and_item(grd, dt, e.RowIndex, item_nm);
}
else
{ //row가 없는 경우
string sResult = wConst.CZM_call_pop_raw_and_item(grd, dt, e.RowIndex, item_nm);
}
wConst.f_Calc_Price(grd, e.RowIndex, "TOTAL_AMT", "PRICE");
}
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("수량") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("단가") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("금액") >= 0)
{
string total_amt = (string)grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value;
string price = (string)grd.Rows[e.RowIndex].Cells["PRICE"].Value;
if (total_amt != null)
{
total_amt = total_amt.ToString().Replace(" ", "");
if (total_amt == "")
{
grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
}
if (price != null)
{
price = price.ToString().Replace(" ", "");
if (price == "")
{
grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
}
//if (total_amt == "" || total_amt == null)
//{
// grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
//}
//if (price == "" || price == null)
//{
// grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
//}
wConst.f_Calc_Price(grd, e.RowIndex, "TOTAL_AMT", "PRICE");
string item_cd_chk = (string)grd.Rows[e.RowIndex].Cells["ITEM_CD"].Value;
}
#endregion 공통 그리드 체크
//string sSearchTxt = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
}
private void popupLogic(object sender, DataGridViewCellEventArgs e)
{
conDataGridView grd = (conDataGridView)sender;
DataGridViewCell cell = grd[e.ColumnIndex, e.RowIndex];
cell.Style.BackColor = Color.White;
#region 공통 그리드 체크
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("명칭") >= 0 && grd._KeyInput == "enter")
{
string rat_mat_nm = (string)grd.Rows[e.RowIndex].Cells["RAW_MAT_NM"].Value;
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
sb.AppendLine("where RAW_MAT_NM like '%" + rat_mat_nm + "%' ");
if (chk구매처.Checked == true)
{
sb.AppendLine(" and cust_cd = '" + txt_cust_cd.Text + "' ");
}
dt = wDm.fn_Raw_List(sb.ToString(), "1");
if (dt.Rows.Count > 1)
{ //row가 2줄이 넘을 경우 팝업으로 넘어간다.
wConst.call_pop_raw_mat(grd, dt, e.RowIndex, rat_mat_nm, 2, txt_cust_cd.Text);
//orderGridAdd();
}
else if (dt.Rows.Count == 1) //row가 1일 경우 해당 row에 값을 자동 입력한다.
{
grd.Rows[e.RowIndex].Cells["RAW_MAT_CD"].Value = dt.Rows[0]["RAW_MAT_CD"].ToString();
grd.Rows[e.RowIndex].Cells["RAW_MAT_NM"].Value = dt.Rows[0]["RAW_MAT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["OLD_RAW_MAT_NM"].Value = dt.Rows[0]["RAW_MAT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["SPEC"].Value = dt.Rows[0]["SPEC"].ToString();
grd.Rows[e.RowIndex].Cells["UNIT_CD"].Value = dt.Rows[0]["INPUT_UNIT"].ToString();
grd.Rows[e.RowIndex].Cells["UNIT_NM"].Value = dt.Rows[0]["INPUT_UNIT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["PRICE"].Value = dt.Rows[0]["INPUT_PRICE"].ToString();
if (rmOrderGrid.Rows[rmOrderGrid.Rows.Count - 1].Cells[2].Value != null)
{
orderGridAdd();
}
}
else
{ //row가 없는 경우
MessageBox.Show("데이터가 없습니다.");
rmOrderGrid.Rows.RemoveAt(rmOrderGrid.SelectedRows[0].Index);
rmOrderGrid.CurrentCell = rmOrderGrid[2, rmOrderGrid.Rows.Count];
//minus_logic(rmOrderGrid);
}
wConst.f_Calc_Price(grd, e.RowIndex, "TOTAL_AMT", "PRICE");
}
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("수량") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("단가") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("금액") >= 0)
{
string total_amt = (string)grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value;
string input_price = (string)grd.Rows[e.RowIndex].Cells["PRICE"].Value;
if (total_amt != null)
{
total_amt = total_amt.ToString().Replace(" ", "");
if (total_amt == "")
{
grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
}
if (input_price != null)
{
input_price = input_price.ToString().Replace(" ", "");
if (input_price == "")
{
grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
}
wConst.f_Calc_Price(grd, e.RowIndex, "TOTAL_AMT", "PRICE");
}
#endregion 공통 그리드 체크
//string sSearchTxt = "" + (string)grd.Rows[e.RowIndex].Cells[e.ColumnIndex].Value;
}
private void rmOrderGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
conDataGridView grd = (conDataGridView)sender;
DataGridViewCell cell = grd[e.ColumnIndex, e.RowIndex];
var senderGrid = (DataGridView)sender;
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn &&
e.RowIndex >= 0 && senderGrid.Columns[e.ColumnIndex].Name.Equals("SRCH_BTN"))
{
string rat_mat_nm = (string)grd.Rows[e.RowIndex].Cells["RAW_MAT_NM"].Value;
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
sb.AppendLine("where RAW_MAT_NM like '%" + rat_mat_nm + "%' ");
if (chk구매처.Checked == true)
{
sb.AppendLine(" and cust_cd = '" + txt_cust_cd.Text + "' ");
}
dt = wDm.fn_Raw_List(sb.ToString(), "1");
if (dt.Rows.Count > 1)
{ //row가 2줄이 넘을 경우 팝업으로 넘어간다.
wConst.call_pop_raw_mat(grd, dt, e.RowIndex, rat_mat_nm, 2, txt_cust_cd.Text);
//orderGridAdd();
}
else if (dt.Rows.Count == 1) //row가 1일 경우 해당 row에 값을 자동 입력한다.
{
grd.Rows[e.RowIndex].Cells["RAW_MAT_CD"].Value = dt.Rows[0]["RAW_MAT_CD"].ToString();
grd.Rows[e.RowIndex].Cells["RAW_MAT_NM"].Value = dt.Rows[0]["RAW_MAT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["OLD_RAW_MAT_NM"].Value = dt.Rows[0]["RAW_MAT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["SPEC"].Value = dt.Rows[0]["SPEC"].ToString();
grd.Rows[e.RowIndex].Cells["UNIT_CD"].Value = dt.Rows[0]["INPUT_UNIT"].ToString();
grd.Rows[e.RowIndex].Cells["UNIT_NM"].Value = dt.Rows[0]["INPUT_UNIT_NM"].ToString();
grd.Rows[e.RowIndex].Cells["PRICE"].Value = dt.Rows[0]["INPUT_PRICE"].ToString();
if (grd.Rows[grd.Rows.Count - 1].Cells[2].Value != null)
{
orderGridAdd();
}
}
else
{ //row가 없는 경우
MessageBox.Show("데이터가 없습니다.");
rmOrderGrid.Rows.RemoveAt(rmOrderGrid.SelectedRows[0].Index);
//rmOrderGrid.CurrentCell = rmOrderGrid[2, rmOrderGrid.Rows.Count];
//minus_logic(rmOrderGrid);
return;
}
wConst.f_Calc_Price(grd, e.RowIndex, "TOTAL_AMT", "PRICE");
}
if (grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("수량") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("단가") >= 0 ||
grd.Columns[e.ColumnIndex].ToolTipText.IndexOf("금액") >= 0)
{
string total_amt = (string)grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value;
string input_price = (string)grd.Rows[e.RowIndex].Cells["PRICE"].Value;
if (total_amt != null)
{
total_amt = total_amt.ToString().Replace(" ", "");
if (total_amt == "")
{
grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["TOTAL_AMT"].Value = "0";
}
if (input_price != null)
{
input_price = input_price.ToString().Replace(" ", "");
if (input_price == "")
{
grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
}
}
else
{
grd.Rows[e.RowIndex].Cells["PRICE"].Value = "0";
}
wConst.f_Calc_Price(grd, e.RowIndex, "TOTAL_AMT", "PRICE");
}
}
}
private void gridSetting(conDataGridView dgv, string met_cd, string met_nm, DataGridView del_dgv)
{
DataGridViewComboBoxColumn cmbColumn = new DataGridViewComboBoxColumn();
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
dt = wDm.fn_query_com_code("620");
// ((DataGridViewComboBoxColumn)main_dgv.Columns["GRADE"]).DataSource = dt2;
cmbColumn.ValueMember = "코드";
cmbColumn.DisplayMember = "명칭";
cmbColumn.DataSource = dt;
cmbColumn.HeaderText = "구분";
cmbColumn.Name = "EVA_GUBUN";
dgv.Columns.Add(cmbColumn);
dgv.Columns.Add("CHK_LOC", "검사위치");
dgv.Columns.Add("RULE_SIZE", "규정치");
dgv.Columns.Add("RULE_LIMIT", "채용한계");
dgv.Columns.Add("MEASURE_APP", "측정기구");
dgv.Columns.Add(met_cd, met_nm);
dgv.Columns.Add("LOWER_SIZE", "하한치수");
dgv.Columns.Add("UPPER_SIZE", "상한치수");
dgv.Columns.Add("LOWER_SELF", "자체하한");
dgv.Columns.Add("UPPER_SELF", "자체상한");
dgv.Columns.Add("CHK_CD", "항목코드");
dgv.Columns.Add("ITEM_CD", "ITEM_CD");
dgv.Columns.Add("OLD_CHK_CD", "OLD_CHK_CD");
dgv.Columns.Add("OLD_CHK_NM", "OLD_CHK_NM");
dgv.Columns.Add("CHK_ORD", "CHK_ORD");
dgv.Columns[1].Name = "NO";
dgv.Columns[2].Name = "CHK_NM";
dgv.Columns[3].Frozen = true;
dgv.Columns[4].Frozen = true;
dgv.Columns[5].Frozen = true;
dgv.Columns[6].Frozen = true;
dgv.Columns[7].Frozen = true;
dgv.Columns[8].Frozen = true;
dgv.Columns[3].Width = 50;
dgv.Columns[4].Width = 75;
dgv.Columns[5].Width = 110;
dgv.Columns[6].Width = 80;
dgv.Columns[7].Width = 100;
dgv.Columns[8].Width = 55;
dgv.Columns[9].Width = 55;
dgv.Columns[10].Width = 55;
dgv.Columns[11].Width = 55;
dgv.Columns[12].Width = 55;
dgv.Columns[14].Width = 80;
dgv.Columns[17].Width = 55;
dgv.Columns[9].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv.Columns[10].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv.Columns[11].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv.Columns[12].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgv.Columns[13].Visible = false;
dgv.Columns[14].Visible = false;
dgv.Columns[15].Visible = false;
dgv.Columns[16].Visible = false;
dgv.Columns[17].Visible = false;
del_dgv.AllowUserToAddRows = false;
del_dgv.Columns.Add("CHK_CD", "CHK_CD");
del_dgv.Columns.Add("ITEM_CD", "ITEM_CD");
}
