private void btnitemsearch(object sender, EventArgs e)
{
Popup.pop_sf_제품검색 frm = new Popup.pop_sf_제품검색();
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
dt = wDm.fn_Item_List("where ITEM_NM like '%" + txt_item_nm.Text.ToString() + "%' ");
//frm.sUsedYN = sUsedYN;
frm.dt = dt;
frm.txtSrch.Text = txt_item_nm.Text.ToString();
frm.ShowDialog();
if (frm.sCode != "")
{
txt_item_nm.Tag = frm.sCode.Trim();
txt_item_nm.Text = frm.sName.Trim();
old_item_nm = frm.sCode.Trim();
str현재고 = frm.sBAL_STOCK;
Debug.WriteLine(str현재고);
}
else
{
txt_item_nm.Tag = "";
txt_item_nm.Text = old_item_nm;
}
cmb_flow.ValueMember = "코드";
cmb_flow.DisplayMember = "명칭";
sqlQuery = comInfo.queryItem2Flow(txt_item_nm.Tag.ToString());
wConst.ComboBox_Read_Blank(cmb_flow, sqlQuery);
}
private void txt_srch_DropDown(object sender, EventArgs e)
{
Popup.pop_sf_제품검색 frm = new Popup.pop_sf_제품검색();
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
dt = wDm.fn_Item_List("where ITEM_NM like '%" + txt_srch.Text.ToString() + "%' and ITEM_GUBUN = '2'");
frm.dt = dt;
frm.txtSrch.Text = txt_srch.Text.ToString();
frm.ShowDialog();
if (frm.sCode != "")
{
txt_item_Cd.Text = frm.sCode.Trim();
txt_srch.Text = frm.sName.Trim();
old_item_nm = frm.sName.Trim();
}
else
{
txt_item_Cd.Text = old_item_nm;
}
}
private void btnitemSrch_Click(object sender, EventArgs e)
{
Popup.pop_sf_제품검색 frm = new Popup.pop_sf_제품검색();
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
try
{
dt = wDm.fn_Item_List("where ITEM_NM like '%" + txtitemSrch.Text.ToString() + "%' ");
frm.dt = dt;
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
frm.txtSrch.Text = txtITEM.Text.ToString();
frm.ShowDialog();
if (frm.sCode != "")
{
txtitemSrch.Text = frm.sCode.Trim();
txtITEM.Text = frm.sName.Trim();
old_item_nm = frm.sName.Trim();
}
else
{
txt_item_nm.Text = old_item_nm;
}
}
private void btn_raw_srch_Click(object sender, EventArgs e)
{
wnDm wDm = new wnDm();
Popup.pop_sf_제품검색 msg = new Popup.pop_sf_제품검색();
msg.dt = wDm.fn_Item_List("where 1=1 ");
msg.ShowDialog();
if (msg.sCode != null && !msg.sCode.Equals(""))
{
txt_item_cd.Text = "";
txt_item_nm.Text = "";
txt_Unit.Text = "";
txt_Spec.Text = "";
txt_balstock.Text = "";
txt_srch.Text = "";
txt_srch2.Text = "";
txt_grade1.Text = "";
txt_grade2.Text = "";
txt_grade3.Text = "";
txt_srch.Text = msg.sName;
txt_srch2.Text = msg.sCode;
input_item_list();
inputRmGrid.Rows.Clear();
}
}
private void btnItemSrch_Click(object sender, EventArgs e)
{
Popup.pop_sf_제품검색 frm = new Popup.pop_sf_제품검색();
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
dt = wDm.fn_Item_List("where ITEM_NM like '%" + txt_Item.Text.ToString() + "%' and ITEM_GUBUN='2'");
//frm.sUsedYN = sUsedYN;
frm.dt = dt;
frm.txtSrch.Text = txt_Item.Text.ToString();
frm.ShowDialog();
if (frm.sCode != "")
{
txt_Item.Tag = frm.sCode.Trim();
txt_Item.Text = frm.sName.Trim();
old_item_nm = frm.sCode.Trim();
}
else
{
txt_Item.Tag = old_item_nm;
}
txt_Item.Focus();
}
private void btn_item_srch_Click(object sender, EventArgs e)
{
wnDm wDm = new wnDm();
Popup.pop_sf_제품검색 msg = new Popup.pop_sf_제품검색();
msg.dt = wDm.fn_Item_List("where 1=1 ");
msg.ShowDialog();
if (msg.sCode != null && !msg.sCode.Equals(""))
{
txt_Srch_item.Text = msg.sName;
txt_Srch_item_cd.Text = msg.sCode;
}
}
private void serch()
{
Popup.pop_sf_제품검색 frm = new Popup.pop_sf_제품검색();
frm.txtSrch.Text = txt_Itemcd.Text.ToString();
frm.ShowDialog();
if (frm.sCode != "")
{
itemccc.Text = frm.sCode.Trim();
txt_Itemcd.Text = frm.sName.Trim();
old_item_nm = frm.sCode.Trim();
}
else
{
itemccc.Text = old_item_nm;
}
}
private void serch()
{
switch (cboType.SelectedIndex)
{
case 1:
Popup.pop_sf_제품검색 frm = new Popup.pop_sf_제품검색();
frm.txtSrch.Text = txtType.Text.ToString();
frm.ShowDialog();
if (frm.sCode != "")
{
txtcode.Text = frm.sCode.Trim();
txtType.Text = frm.sName.Trim();
old_item_nm = frm.sCode.Trim();
}
else
{
txtcode.Text = old_item_nm;
}
break;
case 2:
Popup.pop거래처검색 frm2 = new Popup.pop거래처검색("납품처");
frm2.sCustGbn = "1";
frm2.sCustNm = txtType.Text.ToString();
frm2.ShowDialog();
if (frm2.sCode != "")
{
txtcode.Text = frm2.sCode.Trim();
txtType.Text = frm2.sName.Trim();
old_item_nm = frm2.sCode.Trim();
}
else
{
txtcode.Text = old_item_nm;
}
break;
default:
break;
}
}
private void btnSrch_Click(object sender, EventArgs e)
{
Popup.pop_sf_제품검색 frm = new Popup.pop_sf_제품검색();
wnDm wDm = new wnDm();
DataTable dt = new DataTable();
dt = wDm.fn_Item_List("where ITEM_NM like '%" + txt_item_nm.Text.ToString() + "%' ");
//frm.sUsedYN = sUsedYN;
frm.dt = dt;
frm.txtSrch.Text = txt_item_nm.Text.ToString();
frm.ShowDialog();
if (frm.sCode != "")
{
txt_item_nm.Text = frm.sName.Trim();
}
lot_detail();
}
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 btn_work_inst_srch_Click(object sender, EventArgs e)
{
try
{
if (rBtn_s_lot.Checked)
{
SrchValue = ComInfo.TextBoxMessage("납품LOT번호", "입력");
if (!SrchValue.Equals(""))
{
string valueTemp = SrchValue;
txt_srch_value.Text = SrchValue;
txt_rBtn_value.Text = rBtn_s_lot.Text;
if (valueTemp.Length == 9) //200103001
{
string date = "";
string cd = "";
try
{
decimal.Parse(valueTemp); // 양식 체크용
date = "20" + valueTemp.Substring(0, 2) + "-" + valueTemp.Substring(2, 2) + "-" + valueTemp.Substring(4, 2);
cd = int.Parse(valueTemp.Substring(6, 3)).ToString();
ResetSetting();
SrchValue = "and S.SALES_DATE = '" + date + "' AND S.SALES_CD = '" + cd + "' ";
Srch_List();
}
catch (Exception ex)
{
MessageBox.Show("입력 양식이 올바르지 않습니다 ( 9자리 )");
return;
}
}
else
{
MessageBox.Show("입력 양식이 올바르지 않습니다 ( 9자리 )");
}
}
}
else if (rBtn_lot.Checked)
{
SrchValue = ComInfo.TextBoxMessage("공정LOT번호", "입력");
if (!SrchValue.Equals(""))
{
txt_srch_value.Text = SrchValue;
txt_rBtn_value.Text = rBtn_lot.Text;
ResetSetting();
SrchValue = "and II.LOT_NO = '" + SrchValue + "' ";
Srch_List();
}
}
else if (rBtn_a_union.Checked)
{
SrchValue = ComInfo.TextBoxMessage("묶음코드(제품)", "입력");
if (!SrchValue.Equals(""))
{
txt_srch_value.Text = SrchValue;
txt_rBtn_value.Text = rBtn_a_union.Text;
ResetSetting();
SrchValue = "and A_UNION_CD = '" + SrchValue + "' ";
Srch_List();
}
}
else if (rBtn_srch_item.Checked)
{
Popup.pop_sf_제품검색 msg = new Popup.pop_sf_제품검색();
msg.ShowDialog();
if (msg.sCode != null && !msg.sCode.Equals(""))
{
SrchValue = msg.sCode;
txt_srch_value.Text = msg.sLabelNM;
txt_rBtn_value.Text = rBtn_srch_item.Text;
ResetSetting();
SrchValue = "and ID.ITEM_CD = '" + SrchValue + "' and S.SALES_DATE >= '" + txt_start_date.Text + "' and S.SALES_DATE <= '" + txt_end_date.Text + "' ";
Srch_List();
}
}
else if (rBtn_srch_cust.Checked)
{
Popup.pop거래처검색 msg = new Popup.pop거래처검색();
msg.sCustGbn = "1";
msg.ShowDialog();
if (msg.sCode != null && !msg.sCode.Equals(""))
{
SrchValue = msg.sCode;
txt_srch_value.Text = msg.sName;
txt_rBtn_value.Text = rBtn_srch_cust.Text;
ResetSetting();
SrchValue = "and CN.CUST_CD = '" + SrchValue + "' and S.SALES_DATE >= '" + txt_start_date.Text + "' and S.SALES_DATE <= '" + txt_end_date.Text + "' ";
Srch_List();
}
}
}
catch (Exception ex)
{
MessageBox.Show("검색중 오류가 발생했습니다");
Console.WriteLine(ex);
return;
}
}
