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()); } }