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