private void FacGridList(string condition)
{
try
{
wnDm wDm = new wnDm();
DataTable dt = null;
dt = wDm.Fac_Grid_List(condition);
this.dgv_FaclList.RowCount = dt.Rows.Count;
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dgv_FaclList.Rows[i].Cells["FAC_CD"].Value = dt.Rows[i]["FAC_CD"].ToString();
dgv_FaclList.Rows[i].Cells["FAC_NM"].Value = dt.Rows[i]["FAC_NM"].ToString();
dgv_FaclList.Rows[i].Cells["MODEL_NM"].Value = dt.Rows[i]["MODEL_NM"].ToString();
dgv_FaclList.Rows[i].Cells["SPEC"].Value = dt.Rows[i]["SPEC"].ToString();
dgv_FaclList.Rows[i].Cells["MANU_COMPANY"].Value = dt.Rows[i]["MAKE_CUST"].ToString();
dgv_FaclList.Rows[i].Cells["ACQ_PRICE"].Value = dt.Rows[i]["ACQ_PRICE"].ToString();
dgv_FaclList.Rows[i].Cells["ACQ_DATE"].Value = dt.Rows[i]["INPUT_DATE"].ToString();
dgv_FaclList.Rows[i].Cells["PRO_CAPA"].Value = dt.Rows[i]["AMOUNT"].ToString();
dgv_FaclList.Rows[i].Cells["MAINTEN_CLASS"].Value = dt.Rows[i]["BUY_DATE"].ToString();
dgv_FaclList.Rows[i].Cells["COMMENT"].Value = dt.Rows[i]["COMMENT"].ToString();
}
}
else
{
dgv_FaclList.Rows.Clear();
}
}
catch (Exception ex)
{
}
}
private void FacGridList(string condition)
{
try
{
DataTable dt = null;
dt = wnDm.Fac_Grid_List(condition);
this.dgv_FaclList.RowCount = dt.Rows.Count;
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dgv_FaclList.Rows[i].Cells["FAC_CD"].Value = dt.Rows[i]["FAC_CD"].ToString();
dgv_FaclList.Rows[i].Cells["FAC_NM"].Value = dt.Rows[i]["FAC_NM"].ToString();
dgv_FaclList.Rows[i].Cells["MODEL_NM"].Value = dt.Rows[i]["MODEL_NM"].ToString();
dgv_FaclList.Rows[i].Cells["SPEC"].Value = dt.Rows[i]["SPEC"].ToString();
dgv_FaclList.Rows[i].Cells["MANU_COMPANY"].Value = dt.Rows[i]["MANU_COMPANY"].ToString();
dgv_FaclList.Rows[i].Cells["ACQ_PRICE"].Value = dt.Rows[i]["ACQ_PRICE"].ToString();
dgv_FaclList.Rows[i].Cells["ACQ_DATE"].Value = dt.Rows[i]["ACQ_DATE"].ToString();
dgv_FaclList.Rows[i].Cells["PRO_CAPA"].Value = dt.Rows[i]["AMOUNT"].ToString();
dgv_FaclList.Rows[i].Cells["CHECK_CYCLE"].Value = dt.Rows[i]["CHECK_CYCLE"].ToString();
dgv_FaclList.Rows[i].Cells["COMMENT"].Value = dt.Rows[i]["COMMENT"].ToString();
dgv_FaclList.Rows[i].Cells["사용여부"].Value = dt.Rows[i]["USED"].ToString();
if (dt.Rows[i]["USED"].ToString() == "Y")
{
dgv_FaclList.Rows[i].Cells["사용여부"].Value = "사용중";
}
else if (dt.Rows[i]["USED"].ToString() == "N")
{
dgv_FaclList.Rows[i].Cells["사용여부"].Value = "사용안함";
}
dgv_FaclList.Rows[i].Cells["최근검사일"].Value = DateTime.Parse(dt.Rows[i]["dateInspc"].ToString());
int int점검주기 = int.Parse(dgv_FaclList.Rows[i].Cells["CHECK_CYCLE"].Value.ToString()) * 7;
dgv_FaclList.Rows[i].Cells["점검예정일"].Value = DateTime.Parse(dgv_FaclList.Rows[i].Cells["최근검사일"].Value.ToString()).AddDays(int점검주기);
}
}
else
{
dgv_FaclList.Rows.Clear();
}
}
catch (Exception ex)
{
}
}
private void MetalLoad()
{
btnDelete.Enabled = false;
try
{
wnDm wDm = new wnDm();
DataTable dt = null;
dt = wDm.Fac_Grid_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["FAC_CD"].Value = dt.Rows[i]["FAC_CD"].ToString();
dgvMetalList.Rows[i].Cells["FAC_NM"].Value = dt.Rows[i]["FAC_NM"].ToString();
dgvMetalList.Rows[i].Cells["MODEL_NM"].Value = dt.Rows[i]["MODEL_NM"].ToString();
dgvMetalList.Rows[i].Cells["SPEC"].Value = dt.Rows[i]["SPEC"].ToString();
dgvMetalList.Rows[i].Cells["MANU_COMPANY"].Value = dt.Rows[i]["MANU_COMPANY"].ToString();
dgvMetalList.Rows[i].Cells["ACQ_PRICE"].Value = dt.Rows[i]["ACQ_PRICE"].ToString();
dgvMetalList.Rows[i].Cells["ACQ_DATE"].Value = dt.Rows[i]["ACQ_DATE"].ToString();
dgvMetalList.Rows[i].Cells["PRO_CAPA"].Value = dt.Rows[i]["PRODUCE_AMT"].ToString();
dgvMetalList.Rows[i].Cells["MAINTEN_CLASS"].Value = dt.Rows[i]["MAINTEN_CLASS"].ToString();
dgvMetalList.Rows[i].Cells["COMMENT"].Value = dt.Rows[i]["COMMENT"].ToString();
dgvMetalList.Rows[i].Cells["CHECK_CYCLE"].Value = dt.Rows[i]["CHECK_CYCLE"].ToString();
dgvMetalList.Rows[i].Cells["POWER_NUMBER"].Value = dt.Rows[i]["POWER_NUMBER"].ToString();
dgvMetalList.Rows[i].Cells["AMOUNT"].Value = dt.Rows[i]["AMOUNT"].ToString();
dgvMetalList.Rows[i].Cells["PRODUCE_AMT"].Value = dt.Rows[i]["PRODUCE_AMT"].ToString();
}
}
else
{
dgvMetalList.Rows.Clear();
}
}
catch (Exception ex)
{
}
}
