private void MetalGridList(string condition)
{
try
{
wnDm wDm = new wnDm();
DataTable dt = null;
dt = wDm.Metal_List(condition);
this.dgv_MetalList.RowCount = dt.Rows.Count;
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dgv_MetalList.Rows[i].Cells["METAL_CD"].Value = dt.Rows[i]["METAL_CD"].ToString();
dgv_MetalList.Rows[i].Cells["METAL_MODEL"].Value = dt.Rows[i]["METAL_MODEL"].ToString();
dgv_MetalList.Rows[i].Cells["METAL_SPEC"].Value = dt.Rows[i]["METAL_SPEC"].ToString();
dgv_MetalList.Rows[i].Cells["METAL_MAKECUST"].Value = dt.Rows[i]["METAL_MAKECUST"].ToString();
dgv_MetalList.Rows[i].Cells["METAL_INPUT_DATE"].Value = dt.Rows[i]["METAL_INPUT_DATE"].ToString();
dgv_MetalList.Rows[i].Cells["METAL_ORDERCUST"].Value = dt.Rows[i]["METAL_ORDERCUST"].ToString();
dgv_MetalList.Rows[i].Cells["METAL_MAKE_DATE"].Value = dt.Rows[i]["METAL_MAKE_DATE"].ToString();
dgv_MetalList.Rows[i].Cells["METAL_COMMENT"].Value = dt.Rows[i]["COMMENT"].ToString();
}
}
else
{
dgv_MetalList.Rows.Clear();
}
}
catch (Exception ex)
{
}
}
private void MetalLoad()
{
if (Common.p_strUserNo == "696-87-00592")
{
}
btnDelete.Enabled = false;
try
{
wnDm wDm = new wnDm();
DataTable dt = null;
dt = wDm.Metal_List();
this.dgvMetalList.RowCount = dt.Rows.Count;
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dgvMetalList.Rows[i].Cells["METAL_CD"].Value = dt.Rows[i]["METAL_CD"].ToString();
dgvMetalList.Rows[i].Cells["METAL_MODEL"].Value = dt.Rows[i]["METAL_MODEL"].ToString();
dgvMetalList.Rows[i].Cells["METAL_SPEC"].Value = dt.Rows[i]["METAL_SPEC"].ToString();
dgvMetalList.Rows[i].Cells["METAL_MAKECUST"].Value = dt.Rows[i]["METAL_MAKECUST"].ToString();
dgvMetalList.Rows[i].Cells["METAL_INPUT_DATE"].Value = dt.Rows[i]["METAL_INPUT_DATE"].ToString();
dgvMetalList.Rows[i].Cells["METAL_ORDERCUST"].Value = dt.Rows[i]["METAL_ORDERCUST"].ToString();
dgvMetalList.Rows[i].Cells["METAL_MAKE_DATE"].Value = dt.Rows[i]["METAL_MAKE_DATE"].ToString();
dgvMetalList.Rows[i].Cells["COMMENT"].Value = dt.Rows[i]["COMMENT"].ToString();
}
}
else
{
dgvMetalList.Rows.Clear();
}
}
catch (Exception ex)
{
}
}
public void bindData()
{
Application.DoEvents();
try
{
wnDm wDm = new wnDm();
DataTable dt = null;
dt = wDm.Metal_List("");
adoPrt = new DataTable();
adoPrt = dt.Copy();
int j = 0;
int k = 0;
for (int i = 0; i < this.dgv_MetalList.Rows.Count; i++)
{
if ((bool)dgv_MetalList.Rows[i].Cells[9].Value == true) //--- 11= 확인 체크필드
{
k = 1;
string sDate = "" + this.dgv_MetalList.Rows[i].Cells["METAL_MODEL"].Value.ToString(); //모델명
string sNUm = "" + this.dgv_MetalList.Rows[i].Cells["METAL_SPEC"].Value.ToString(); //규격
string sName = "" + this.dgv_MetalList.Rows[i].Cells["METAL_MAKECUST"].Value.ToString(); //제조업체
string sSpec = "" + this.dgv_MetalList.Rows[i].Cells["METAL_MAKE_DATE"].Value.ToString(); //제조일자
string sUnit = "" + this.dgv_MetalList.Rows[i].Cells["METAL_ORDERCUST"].Value.ToString(); //발주업체
string nCost = "" + this.dgv_MetalList.Rows[i].Cells["METAL_INPUT_DATE"].Value.ToString(); //입고일자
string nAmt = "" + this.dgv_MetalList.Rows[i].Cells["METAL_LOTNO"].Value.ToString(); //바코드
dt.Rows[j]["METAL_CD"] = j;
dt.Rows[j]["METAL_MODEL"] = sDate;
dt.Rows[j]["METAL_SPEC"] = sNUm;
dt.Rows[j]["METAL_MAKECUST"] = sName;
dt.Rows[j]["METAL_MAKE_DATE"] = sSpec;
dt.Rows[j]["METAL_ORDERCUST"] = sUnit;
dt.Rows[j]["METAL_INPUT_DATE"] = nCost;
dt.Rows[j]["METAL_LOTNO"] = nAmt;
dt.Rows[j]["COMMENT"] = "";
j = j + 1;
adoPrt = dt.Copy();
}
}
//데이타 끝나고 다시 copy를 써준 이유는 for중에 no에 값을 엏었기 때문에 출력물 데이타테이블(dt)를 다시 복사함
adoPrt = dt.Copy();
for (int i = j; i < this.dgv_MetalList.Rows.Count; i++)
{
adoPrt.Rows[i].Delete();
}
adoPrt.AcceptChanges(); //--삭제확정
if (k == 0)
{
strCondition = "No";
}
}
catch (Exception ex)
{
strCondition = "ERROR";
MessageBox.Show("검색중에 오류가 발생했습니다.");
wnLog.writeLog(wnLog.LOG_ERROR, ex.Message + " - " + ex.ToString());
}
}
