private void UpdateInfo(WarehouseVO item) { code = item.Warehouse_ID; txtWarehouseName.Text = item.Warehouse_Name; maskedWarehouseNumber.Text = item.Warehouse_Number; maskedWarehouseFaxNumber.Text = item.Warehouse_Fax; division = item.Warehouse_Division; string[] str = item.Warehouse_Address.Split(' '); addrWarehouse.Address1 = str[0]; addrWarehouse.Address2 = str[1]; addrWarehouse.Zipcode = item.Warehouse_AddrNumber; }
private void btnCreate_Click(object sender, EventArgs e) { if (txtName.Text.Trim() == "") { MessageBox.Show("창고명을 입력해 주십시오."); } else if (txtAddress.Text.Trim() == "") { MessageBox.Show("창고주소를 입력해 주십시오."); } else if (cboType.Text.Trim() == "") { MessageBox.Show("창고구분을 선택해 주십시오."); } else { if (label1.Text == "창고 정보") { WarehouseVO vo = new WarehouseVO() { w_name = txtName.Text, w_address = txtAddress.Text, w_type = cboType.Text }; WarehouseService service = new WarehouseService(); if (service.InsertWH(vo) == 1) { MessageBox.Show("창고정보 입력 완료"); this.Close(); } } else { WarehouseVO vo = new WarehouseVO() { w_id = this.vo.w_id, w_name = txtName.Text, w_address = txtAddress.Text, w_type = cboType.Text }; WarehouseService service = new WarehouseService(); if (service.UpdateWH(vo) == 1) { MessageBox.Show("창고정보 수정 완료"); this.Close(); } } } }
public bool UpdateWarehouse(WarehouseVO item) { string sql = "Update Warehouse set Warehouse_Name = @Warehouse_Name, Warehouse_Address1 = @Warehouse_Address1, Warehouse_Address2 = @Warehouse_Address2, Warehouse_Number = @Warehouse_Number, Warehouse_Fax = @Warehouse_Fax, Warehouse_Division = @Warehouse_Division, Warehouse_AddrNumber = @Warehouse_AddrNumber where Warehouse_ID = @Warehouse_ID "; string[] str = item.Warehouse_Address.Split(' '); try { using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@Warehouse_Name", item.Warehouse_Name); cmd.Parameters.AddWithValue("@Warehouse_Address1", str[0]); cmd.Parameters.AddWithValue("@Warehouse_Address2", str[1]); if (item.Warehouse_Number == null) { cmd.Parameters.AddWithValue("@Warehouse_Number", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Warehouse_Number", item.Warehouse_Number); } if (item.Warehouse_Fax == null) { cmd.Parameters.AddWithValue("@Warehouse_Fax", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Warehouse_Fax", item.Warehouse_Fax); } cmd.Parameters.AddWithValue("@Warehouse_Division", item.Warehouse_Division); cmd.Parameters.AddWithValue("@Warehouse_AddrNumber", item.Warehouse_AddrNumber); cmd.Parameters.AddWithValue("@Warehouse_ID", item.Warehouse_ID); conn.Open(); var rowsAffected = cmd.ExecuteNonQuery(); return(rowsAffected > 0); } } catch { throw; } finally { conn.Close(); } }
public WarehouseInsUp(EditMode editMode, WarehouseVO item) { InitializeComponent(); if (editMode == EditMode.Update) { mode = "Update"; lblName.Text = "창고 수정"; pbxTitle.Image = Resources.Edit_32x32; UpdateInfo(item); } else { mode = "Insert"; lblName.Text = "창고 등록"; pbxTitle.Image = Resources.AddFile_32x32; } }
public int InsertWH(WarehouseVO vo) { string sql = "insert into TBL_WAREHOUSE (w_name, w_address, w_type, w_uadmin, w_udate) values (@w_name, @w_address, @w_type, @w_uadmin, replace(convert(varchar(10), getdate(), 120), '-', '-'))"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { try { cmd.Parameters.AddWithValue("@w_name", vo.w_name); cmd.Parameters.AddWithValue("@w_address", vo.w_address); cmd.Parameters.AddWithValue("@w_type", vo.w_type); cmd.Parameters.AddWithValue("@w_uadmin", LoginVO.user.Name); cmd.ExecuteNonQuery(); return(1); } catch (Exception err) { string msg = err.Message; return(0); } } }
private void UpdateWarehouse() { if (cboWarehouseDivision.SelectedIndex != 0) { WarehouseVO item = new WarehouseVO { Warehouse_ID = code, Warehouse_Division = Convert.ToInt32(cboWarehouseDivision.SelectedValue), Warehouse_Name = txtWarehouseName.Text, Warehouse_Number = maskedWarehouseNumber.Text, Warehouse_Fax = maskedWarehouseNumber.Text, Warehouse_Address = addrWarehouse.Address1 + " " + addrWarehouse.Address2, Warehouse_AddrNumber = addrWarehouse.Zipcode }; //MaskTextBox는 값이 없을 때 공백과 -만 남으므로 item 값을 null로 준다. if (item.Warehouse_Number.Replace("-", "").Trim().Length < 10) { item.Warehouse_Number = null; } if (item.Warehouse_Fax.Replace("-", "").Trim().Length < 10) { item.Warehouse_Fax = null; } try { StandardService service = new StandardService(); service.UpdateWarehouse(item); } catch (Exception err) { Log.WriteError(err.Message, err); } } }
public int UpdateWH(WarehouseVO vo) { string sql = "update TBL_WAREHOUSE set w_name = @w_name, w_address = @w_address, w_type = @w_type, w_uadmin = @w_uadmin, w_udate = replace(convert(varchar(10), getdate(), 120), '-', '-') where w_id = @w_id"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { try { cmd.Parameters.AddWithValue("@w_id", vo.w_id); cmd.Parameters.AddWithValue("@w_name", vo.w_name); cmd.Parameters.AddWithValue("@w_address", vo.w_address); cmd.Parameters.AddWithValue("@w_type", vo.w_type); cmd.Parameters.AddWithValue("@w_uadmin", LoginVO.user.Name); cmd.ExecuteNonQuery(); return(1); } catch (Exception err) { string msg = err.Message; return(0); } } }
public bool UpdateWarehouse(WarehouseVO item) { WarehouseDAC dac = new WarehouseDAC(); return(dac.UpdateWarehouse(item)); }
public bool InsertWarehouse(WarehouseVO item) { WarehouseDAC dac = new WarehouseDAC(); return(dac.InsertWarehouse(item)); }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < dgvWarehouse.Rows.Count && e.RowIndex > -1) { // 전화번호가 없을 때 if (dgvWarehouse.Rows[e.RowIndex].Cells[4].Value == null) { // 전화번호와 FAX번호 둘 다 없을 때 if (dgvWarehouse.Rows[e.RowIndex].Cells[5].Value == null) { item = new WarehouseVO { Warehouse_ID = Convert.ToInt32(dgvWarehouse.Rows[e.RowIndex].Cells[0].Value), Warehouse_Name = dgvWarehouse.Rows[e.RowIndex].Cells[1].Value.ToString(), Warehouse_AddrNumber = dgvWarehouse.Rows[e.RowIndex].Cells[2].Value.ToString(), Warehouse_Address = dgvWarehouse.Rows[e.RowIndex].Cells[3].Value.ToString(), Warehouse_Division = Convert.ToInt32(dgvWarehouse.Rows[e.RowIndex].Cells[6].Value) }; } // 전화번호는 없고 FAX번호만 있을 때 else { item = new WarehouseVO { Warehouse_ID = Convert.ToInt32(dgvWarehouse.Rows[e.RowIndex].Cells[0].Value), Warehouse_Name = dgvWarehouse.Rows[e.RowIndex].Cells[1].Value.ToString(), Warehouse_AddrNumber = dgvWarehouse.Rows[e.RowIndex].Cells[2].Value.ToString(), Warehouse_Address = dgvWarehouse.Rows[e.RowIndex].Cells[3].Value.ToString(), Warehouse_Fax = dgvWarehouse.Rows[e.RowIndex].Cells[5].Value.ToString(), Warehouse_Division = Convert.ToInt32(dgvWarehouse.Rows[e.RowIndex].Cells[6].Value) }; } } else { //전화번호는 있는데 FAX번호가 없을 떄 if (dgvWarehouse.Rows[e.RowIndex].Cells[5].Value == null) { item = new WarehouseVO { Warehouse_ID = Convert.ToInt32(dgvWarehouse.Rows[e.RowIndex].Cells[0].Value), Warehouse_Name = dgvWarehouse.Rows[e.RowIndex].Cells[1].Value.ToString(), Warehouse_AddrNumber = dgvWarehouse.Rows[e.RowIndex].Cells[2].Value.ToString(), Warehouse_Address = dgvWarehouse.Rows[e.RowIndex].Cells[3].Value.ToString(), Warehouse_Number = dgvWarehouse.Rows[e.RowIndex].Cells[4].Value.ToString(), Warehouse_Division = Convert.ToInt32(dgvWarehouse.Rows[e.RowIndex].Cells[6].Value) }; } //전화번호와 FAX번호 둘 다 있을 때 else { item = new WarehouseVO { Warehouse_ID = Convert.ToInt32(dgvWarehouse.Rows[e.RowIndex].Cells[0].Value), Warehouse_Name = dgvWarehouse.Rows[e.RowIndex].Cells[1].Value.ToString(), Warehouse_AddrNumber = dgvWarehouse.Rows[e.RowIndex].Cells[2].Value.ToString(), Warehouse_Address = dgvWarehouse.Rows[e.RowIndex].Cells[3].Value.ToString(), Warehouse_Number = dgvWarehouse.Rows[e.RowIndex].Cells[4].Value.ToString(), Warehouse_Fax = dgvWarehouse.Rows[e.RowIndex].Cells[5].Value.ToString(), Warehouse_Division = Convert.ToInt32(dgvWarehouse.Rows[e.RowIndex].Cells[6].Value) }; } } } }
public frmWarehousePopUp(WarehouseVO vo) { InitializeComponent(); this.vo = vo; }
public int UpdateWH(WarehouseVO vo) { WarehouseDAC dac = new WarehouseDAC(); return(dac.UpdateWH(vo)); }
public int InsertWH(WarehouseVO vo) { WarehouseDAC dac = new WarehouseDAC(); return(dac.InsertWH(vo)); }