private void btnSuaHangHoa_Click(object sender, EventArgs e)
{
HangHoaDTO hhTam = new HangHoaDTO();
hhTam.Mahh = Convert.ToInt32(dtgvHangHoa.SelectedCells[0].OwningRow.Cells["colMaHH"].Value.ToString());
if (txtTenHangHoa.Text == string.Empty || txtDonViTinh.Text == string.Empty || txtSoLuongTon.Text == string.Empty)
{
MessageBox.Show("Bạn chưa nhập đầy đủ thông tin!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
hhTam.Tenhh = txtTenHangHoa.Text;
hhTam.Dvt = txtDonViTinh.Text;
hhTam.Slton = Convert.ToInt32(txtSoLuongTon.Text);
}
if (hangBUS.SuaHH(hhTam))
{
MessageBox.Show("Sửa thành công!", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDsHangHoa();
AutoCompleteHH();
}
else
{
MessageBox.Show("Sửa thất bại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
if (!dataGridView1.Focused)
{
dataGridView1.ClearSelection();
tabNoHeader1.Visible = false;
return;
}
if (tabNoHeader1.Visible && tabNoHeader1.SelectedIndex == 1)
{
return;
}
foreach (Control c in tabThem.Controls)
{
errorProvider1.SetError(c, string.Empty);
}
tabNoHeader1.SelectedIndex = 0;
tabNoHeader1.Visible = true;
btnThem.Text = @"Sửa";
using (HangHoaBUS bus = new HangHoaBUS())
{
string tennhanghoa = dataGridView1.CurrentRow?.Cells[0].Value.ToString();
HangHoaDTO info = bus.LoadHangHoa(tennhanghoa);
txtTenHangHoa.Text = info.TenHangHoa;
txtGiaBan.Text = info.GiaBan.ToString();
txtDonViTinh.Text = info.DonViTinh;
txtSoLuongTon.Text = info.SoLuongTon.ToString();
txtGhiChu.Text = info.GhiChu;
}
}
public int ThemHangHoa(HangHoaDTO hh)
{
string sql = string.Format("insert into HangHoa(MaHH, MaDV, TenHH, MaNH, MaLHH, MaKho, Anh, TonKhoToiThieu, TonKhoHienTai, GiaMua, GiaBanLe, GiaBanSi, IsDelete) " +
"values('{0}', '{1}', N'{2}', '{3}', '{4}', '{5}', '{6}', {7}, {8}, {9}, {10}, {11}, {12})", hh.MaHH, hh.MaDV, hh.TenHH, hh.MaNH, hh.MaLHH, hh.MaKho, hh.Anh, hh.TonKhoToiThieu, hh.TonKhoHienTai, hh.GiaMua, hh.GiaBanLe, hh.GiaBanSi, 0);
return(db.ExcuteSql(sql));
}
private void btnSaveHangHoa_Click(object sender, EventArgs e)
{
HangHoaDTO dto = new HangHoaDTO();
addData(dto);
if (txtTenHH.Text.Length <= 0)
{
lblThongBao.Text = "Chưa nhập Tên Hàng Hóa !";
}
else if (txtDVT.Text.Length <= 0)
{
lblThongBao.Text = "Chưa nhập Đơn Vị Tính !";
}
else if (Convert.ToDecimal(txtGiaBan.Text.Length) <= 0)
{
lblThongBao.Text = "Chưa nhập Giá Bán !";
}
else if (Convert.ToDecimal(txtGiaMua.Text.Length) <= 0)
{
lblThongBao.Text = "Chưa nhập Giá Mua !";
}
else
{
if (hanghoaBUS.AddData(dto))
{
MessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("Thêm Lại đê bạn ơi,wrong rùi :>", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public bool UpDateData(HangHoaDTO hh)
{
string query = string.Format("update HangHoa set TenHH =N'{0}' , DonViTinh =N'{1}', GiaBan = {2}, GiaMua = {3}, SoLuong = {4}, GhiChu = N'{5}', TinhTrang ='True' where MaHH ={6}", hh.TeHH, hh.DonViTinh, hh.GiaBan, hh.GiaMua, hh.Sl, hh.GhiChu, hh.MaHH);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
public static HangHoaDTO LayThongTinHangHoaCanMuaTheoMa(int MaHangHoa)
{
HangHoaDTO hh = new HangHoaDTO();
DataProvider p = new DataProvider();
p.Connect();
SqlParameter p1 = new SqlParameter("@MaHangHoa", SqlDbType.Int)
{
Value = MaHangHoa
};
SqlDataReader r = p.GetReader("sp_LayThongTinHangHoaCanMuaTheoMa", CommandType.StoredProcedure, p1);
while ((r.Read()))
{
hh.MaHangHoa = Convert.ToInt32(r[0]);
hh.TenHangHoa = r[1].ToString();
hh.DonVi = Convert.ToInt32(r[2]);
hh.GiaMua = float.Parse(r[3].ToString());
}
p.Disconnect();
return(hh);
}
public bool AddData(HangHoaDTO hh)
{
string query = string.Format("insert into HangHoa(TenHH,DonViTinh,GiaBan,GiaMua,SoLuong,GhiChu,TinhTrang) values(N'{1}',{2},{3}, {4},N'{5}',{6}, 'True')", hh.TeHH, hh.DonViTinh, hh.GiaBan, hh.GiaMua, hh.Sl, hh.GhiChu, hh.MaHH);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
private void btnTimKiemHangHoa_Click(object sender, EventArgs e)
{
HangHoaDTO hhTam = new HangHoaDTO();
string tenHH = txtTimKiemHangHoa.Text;
hhTam = hangBUS.TimKiemHH(tenHH);
if (hhTam != null)
{
foreach (DataGridViewRow row in dtgvHangHoa.Rows)
{
if (Convert.ToInt32(row.Cells["colMaHH"].Value.ToString()) == hhTam.Mahh)
{
row.Selected = true;
dtgvHangHoa.CurrentCell = dtgvHangHoa.Rows[row.Index].Cells[0];
txtTenHangHoa.Text = hhTam.Tenhh;
txtDonViTinh.Text = hhTam.Dvt;
txtSoLuongTon.Text = hhTam.Slton.ToString();
}
}
}
else
{
MessageBox.Show("Không tìm thấy!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public static List <HangHoaDTO> _LayTatCaHangHoa()
{
List <HangHoaDTO> lst = new List <HangHoaDTO>();
DataProvider p = new DataProvider();
p.Connect();
SqlDataReader r = p.GetReader("LayTatCaHangHoa", CommandType.StoredProcedure);
HangHoaDTO hh = null;
while ((r.Read()))
{
hh = new HangHoaDTO();
hh.MaHangHoa = Convert.ToInt32(r[0]);
hh.TenHangHoa = r[1].ToString();
hh.LoaiHangHoa = Convert.ToInt32(r[2]);
hh.KhoMacDinh = Convert.ToInt32(r[3]);
hh.PhanLoai = Convert.ToInt32(r[4]);
hh.DonVi = Convert.ToInt32(r[5]);
hh.XuatXu = r[6].ToString();
hh.TonKhoToiThieu = Convert.ToInt32(r[7]);
hh.TonKho = Convert.ToInt32(r[8]);
hh.NhaCungCap = Convert.ToInt32(r[9]);
hh.GiaMua = Convert.ToDouble(r[10]);
hh.GiaBan = Convert.ToDouble(r[11]);
hh.ConQuanLy = Convert.ToBoolean(r[12]);
lst.Add(hh);
}
p.Disconnect();
return(lst);
}
private void btnThemHangHoa_Click(object sender, EventArgs e)
{
HangHoaDTO hhTam = new HangHoaDTO();
if (txtTenHangHoa.Text == string.Empty || txtDonViTinh.Text == string.Empty || txtSoLuongTon.Text == string.Empty)
{
MessageBox.Show("Bạn chưa nhập đầy đủ thông tin!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
hhTam.Tenhh = txtTenHangHoa.Text;
hhTam.Dvt = txtDonViTinh.Text;
hhTam.Slton = Convert.ToInt32(txtSoLuongTon.Text);
}
if (hangBUS.ThemHH(hhTam))
{
MessageBox.Show("Thêm thành công!", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDsHangHoa();
AutoCompleteHH();
}
else
{
MessageBox.Show("Thêm thất bại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public int CapNhatHangHoaBTN(HangHoaDTO hh)
{
string sql = string.Format("update HangHoa set TenHH = N'{0}', MaDV = '{1}', MaNH = '{2}', MaLHH = '{3}', MaKho = '{4}', MaVachNSX = '{5}', XuatXu = N'{6}', TonKhoToiThieu = {7}, TonKhoHienTai = {8}, Anh = '{9}', MaNCC = '{10}', GiaMua = {11}, GiaBanSi = {12}, GiaBanLe = {13}, ConQuanLy = '{14}', IsDelete = {15} where MaHH like '{16}'",
hh.TenHH, hh.MaDV, hh.MaNH, hh.MaLHH, hh.MaKho, hh.MaVachNSX, hh.XuatXu, hh.TonKhoToiThieu, hh.TonKhoHienTai, hh.Anh, hh.MaNCC, hh.GiaMua, hh.GiaBanSi, hh.GiaBanLe, hh.ConQuanLy, 0, hh.MaHH);
return(db.ExcuteSql(sql));
}
public void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int[] l = GridView1.GetSelectedRows();
var index = l[0];
switch (MessageBox.Show("Bạn có chắc chắn muốn xóa hàng hóa này không?", "Hỏi Xóa", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
case DialogResult.Yes:
HangHoaDTO hh = default(HangHoaDTO);
hh = ((List <HangHoaDTO>)gridHangHoa.DataSource)[index];
bool test = HangHoaBUS.XoaKhoHang(hh);
if (test == true)
{
LoadGridHangHoa();
Log_BUS.ThemNhatKy("Hàng hóa", "Xóa hàng hoá");
MessageBox.Show("Xóa thành công");
}
else
{
MessageBox.Show("Xóa không thành công");
}
break;
case DialogResult.No:
return;
}
}
public int ThemtHangHoaBTN(HangHoaDTO hh)
{
string sql = string.Format("insert into HangHoa(MaHH, TenHH, MaDV, MaNH, MaLHH, MaKho, MaVachNSX, XuatXu, TonKhoToiThieu, TonKhoHienTai, Anh, MaNCC, GiaMua, GiaBanSi, GiaBanLe, ConQuanLy, IsDelete)" +
"values('{0}', N'{1}', '{2}', '{3}', '{4}', '{5}', '{6}', N'{7}', {8}, {9}, '{10}', '{11}', {12}, {13}, {14}, '{15}', {16})",
hh.MaHH, hh.TenHH, hh.MaDV, hh.MaNH, hh.MaLHH, hh.MaKho, hh.MaVachNSX, hh.XuatXu, hh.TonKhoToiThieu, hh.TonKhoHienTai, hh.Anh, hh.MaNCC, hh.GiaMua, hh.GiaBanSi, hh.GiaBanLe, hh.ConQuanLy, 0);
return(db.ExcuteSql(sql));
}
//thêm hàng hoá
private void navBarItem4_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
{
HangHoaDTO HangHoaDTO = new HangHoaDTO()
{
ConQuanLy = true
};
ThemHangHoa frm = new ThemHangHoa(true, HangHoaDTO);
frm.ShowDialog();
}
private void BtnEdit_Click(object sender, EventArgs e)
{
HangHoaDTO hangHoa = getInfo();
int id = Convert.ToInt32(txtIDMatHang.Text);
if (HangHoaBUS.Instance.EditCategory(hangHoa, id) > 0)
{
LoadData();
RefreshFlowLayoutPannel();
}
}
public static void UpSLHang(HangHoaDTO hs)
{
SqlCommand command = new SqlCommand("sp_UpSLHang", Conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@MaHang", hs.MaHang1);
command.Parameters.AddWithValue("@SoLuong", hs.SoLuong1);
Conn.Open();
command.ExecuteNonQuery();
Conn.Close();
}
public static HangHoa MappingHangHoa(this HangHoaDTO hangHoaDTO)
{
return(new HangHoa
{
Id = hangHoaDTO.Id,
Ten = hangHoaDTO.Ten,
LoaiHangHoaId = hangHoaDTO.LoaiHangHoaId,
DonGia = hangHoaDTO.DonGia,
SoLuong = hangHoaDTO.SoLuong,
TinhTrang = hangHoaDTO.TinhTrang,
});
}
private void btnThem_Click(object sender, EventArgs e)
{
HangHoaDTO HangHoaDTO = new HangHoaDTO()
{
ConQuanLy = true
};
ThemHangHoa frm = new ThemHangHoa(true, HangHoaDTO);
frm.ShowDialog();
hienThi();
}
private void addData(HangHoaDTO hh)
{
hh.TeHH = txtTenHH.Text.Trim();
hh.DonViTinh = txtDVT.Text.Trim();
try
{
hh.GiaBan = Convert.ToDecimal(txtGiaBan.Text.Trim());
hh.GiaMua = Convert.ToDecimal(txtGiaMua.Text.Trim());
}
catch { }
hh.Sl = 0;
hh.GhiChu = txtGhiChu.Text.Trim();
}
private void btnThem_Click(object sender, EventArgs e)
{
foreach (var c in from MaterialSingleLineTextField c in tabThem.Controls.OfType <MaterialSingleLineTextField>() where c != txtGhiChu select c)
{
errorProvider1.SetError(c, string.IsNullOrWhiteSpace(c.Text) ? "Bạn không được để trống thông tin này" : string.Empty);
}
if (tabThem.Controls.OfType <MaterialSingleLineTextField>().Any(c => errorProvider1.GetError(c) != string.Empty))
{
return;
}
try
{
using (HangHoaBUS bus = new HangHoaBUS())
{
HangHoaDTO info = new HangHoaDTO
{
TenHangHoa = txtTenHangHoa.Text,
GiaBan = Convert.ToInt32(txtGiaBan.Text),
DonViTinh = txtDonViTinh.Text,
SoLuongTon = Convert.ToInt32(txtSoLuongTon.Text),
GhiChu = txtGhiChu.Text
};
if (dataGridView1.SelectedRows.Count == 0)
{
bus.InsertHangHoa(info);
}
else
{
string tenhanghoa = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
bus.EditHangHoa(info, tenhanghoa);
}
}
}
catch (SqlException ex)
{
if (ex.Number == DbConnection.MssqlEng002627)
{
errorProvider1.SetError(txtTenHangHoa, "Hàng hóa đã tồn tại");
}
else
{
throw;
}
}
RefreshHangHoa();
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
HangHoaDTO hang = new HangHoaDTO();
DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex];
hang.MAHANGHOA = row.Cells[0].Value.ToString();
hang.TEN = row.Cells[1].Value.ToString();
hang.SOLUONG = row.Cells[2].Value.ToString();
hang.GIA = row.Cells[3].Value.ToString();
/* hang.Mota = row.Cells[4].Value.ToString();*/
Pbhtt.Sender(hang);
this.Hide();
Pbhtt.Show();
}
private HangHoaDTO getInfo()
{
String name = txtName.Text;
int idCongTy = Convert.ToInt32(txtIDCongTy.Text);
int idLoaiHang = Convert.ToInt32(txtIDLoaiHang.Text);
int soLuong = Convert.ToInt32(nudSoLuong.Text);
String donViTinh = cbDonViTinh.Text;
double gia = Convert.ToDouble(txtGiaBan.Text);
String imagePath = txtImagePath.Text;
String ghiChu = rtbGhiChu.Text;
HangHoaDTO hangHoa = new HangHoaDTO(name, idCongTy, idLoaiHang, soLuong, donViTinh, gia, imagePath, ghiChu);
return(hangHoa);
}
public BindingList <HangHoaDTO> LayDanhSach()
{
BindingList <HangHoaDTO> danhSach = new BindingList <HangHoaDTO>();
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Select * From DanhMucHangHoa";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
HangHoaDTO itemDTO = new HangHoaDTO();
itemDTO.Id = (int)dr["Id"];
itemDTO.MaHangHoa = (string)dr["MaHangHoa"];
itemDTO.TenHangHoa = (string)dr["TenHangHoa"];
itemDTO.IdHoatChatChinh = (int)dr["IdHoatChatChinh"];
itemDTO.IdNhomHangHoa = (int)dr["IdNhomHangHoa"];
itemDTO.IdLoaiHangHoa = (int)dr["IdLoaiHangHoa"];
itemDTO.IdHangSanXuat = (int)dr["IdHangSanXuat"];
itemDTO.IdNoiSanXuat = (int)dr["IdNoiSanXuat"];
itemDTO.IdViTri = (int)dr["IdViTri"];
itemDTO.SoDangKy = (string)dr["SoDangKy"];
itemDTO.IdDonViTinh = (int)dr["IdDonViTinh"];
itemDTO.GiaNhap = (double)dr["GiaNhap"];
itemDTO.TyLeChietKhau = (double)dr["TyLeChietKhau"];
itemDTO.VAT = (double)dr["VAT"];
itemDTO.IdDonViQuyDoi1 = (int)dr["IdDonViQuyDoi1"];
itemDTO.TyLeQuyDoi1 = (int)dr["TyLeQuyDoi1"];
itemDTO.GiaQuyDoi1 = (double)dr["GiaQuyDoi1"];
itemDTO.GiaDeXuat1 = (double)dr["GiaDeXuat1"];
itemDTO.IdDonViQuyDoi2 = (int)dr["IdDonViQuyDoi2"];
itemDTO.TyLeQuyDoi2 = (int)dr["TyLeQuyDoi2"];
itemDTO.GiaQuyDoi2 = (double)dr["GiaQuyDoi2"];
itemDTO.GiaDeXuat2 = (double)dr["GiaDeXuat2"];
itemDTO.NhietDoBaoQuan = (string)dr["NhietDoBaoQuan"];
itemDTO.AnhSangBaoQuan = (string)dr["AnhSangBaoQuan"];
itemDTO.DoAmBaoQuan = (string)dr["DoAmBaoQuan"];
itemDTO.QuanLyKho = (bool)dr["QuanLyKho"];
danhSach.Add(itemDTO);
}
return(danhSach);
}
public IHttpActionResult Create(HangHoaDTO hanghoaDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var hanghoa = Mapper.Map <HangHoaDTO, HangHoa>(hanghoaDTO);
_db.HangHoa.Add(hanghoa);
_db.SaveChanges();
hanghoaDTO.Id = hanghoa.Id;
return(Created(new Uri(Request.RequestUri + "/" + hanghoaDTO.Id), hanghoaDTO));
}
public void LayData(DataGridView r1, HangHoaDTO sp)
{
// sp = new HangHoaDTO();
// sp = sp_can_lay;
// MessageBox.Show(sp_can_lay.MaHangHoa.ToString());
sp.MaHangHoa = sp_can_lay.MaHangHoa;
sp.TenHangHoa = sp_can_lay.TenHangHoa;
sp.LoaiHangHoa = sp_can_lay.LoaiHangHoa;
sp.PhanLoai = sp_can_lay.PhanLoai;
sp.DonVi = sp_can_lay.DonVi;
sp.TonKhoToiThieu = sp_can_lay.TonKhoToiThieu;
sp.TonKho = sp_can_lay.TonKho;
sp.GiaMua = sp_can_lay.GiaMua;
sp.GiaBan = sp_can_lay.GiaBan;
sp.ConQuanLy = sp_can_lay.ConQuanLy;
}
public bool SuaHH(HangHoaDTO hh)
{
try
{
HANG_HOA hhDB = db.HANG_HOA.SingleOrDefault(p => p.MAHH == hh.Mahh && p.TRANGTHAIXOA == false);
hhDB.TENHH = hh.Tenhh;
hhDB.DVT = hh.Dvt;
hhDB.SLTON = hh.Slton;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public static void saveHang(HangHoaDTO hs, string method)
{
SqlParameter[] sqlP = new SqlParameter[13];
sqlP[0] = new SqlParameter("@MaHang", hs.MaHang1);
sqlP[1] = new SqlParameter("@TenHangHoa", hs.TenHangHoa1);
sqlP[2] = new SqlParameter("@MaNhom", hs.MaNhom1);
sqlP[3] = new SqlParameter("@SoLuong", hs.SoLuong1);
//sqlP[4] = new SqlParameter("@DonGiaNhap", hs.DonGiaNhap1);
if (hs.DonGiaNhap1 == 0)
{
sqlP[4] = new SqlParameter("@DonGiaNhap", SqlDbType.Int);
sqlP[4].Value = DBNull.Value;
}
else
{
sqlP[4] = new SqlParameter("@DonGiaNhap", hs.DonGiaNhap1);
}
sqlP[5] = new SqlParameter("@MaLoai", hs.MaLoai1);
sqlP[6] = new SqlParameter("@NhapKhau", hs.NhapKhau1);
sqlP[7] = new SqlParameter("@MaDonVi", hs.MaDonVi1);
sqlP[8] = new SqlParameter("@MaChatLieu", hs.MaChatLieu1);
sqlP[9] = new SqlParameter("@MaCongDung", hs.MaCongDung1);
sqlP[10] = new SqlParameter("@MaNoiSX", hs.MaNoiSX1);
//sqlP[11] = new SqlParameter("@Anh", hs.Anh1);
if (hs.Anh1 == null)
{
sqlP[11] = new SqlParameter("@Anh", SqlDbType.Image);
sqlP[11].Value = DBNull.Value;
}
else
{
sqlP[11] = new SqlParameter("@Anh", hs.Anh1);
}
sqlP[12] = new SqlParameter("@GhiChu", hs.GhiChu1);
if (method == sys.INSERT)
{
GenericDAL.execNonQuery("sp_InsertHangHoa", sqlP, Conn);
}
else if (method == sys.UPDATE)
{
GenericDAL.execNonQuery("sp_UpdateHangHoa", sqlP, Conn);
}
}
public BindingList<HangHoaDTO> LayDanhSach()
{
BindingList<HangHoaDTO> danhSach = new BindingList<HangHoaDTO>();
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Select * From DanhMucHangHoa";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
HangHoaDTO itemDTO = new HangHoaDTO();
itemDTO.Id = (int)dr["Id"];
itemDTO.MaHangHoa = (string)dr["MaHangHoa"];
itemDTO.TenHangHoa = (string)dr["TenHangHoa"];
itemDTO.IdHoatChatChinh = (int)dr["IdHoatChatChinh"];
itemDTO.IdNhomHangHoa = (int)dr["IdNhomHangHoa"];
itemDTO.IdLoaiHangHoa = (int)dr["IdLoaiHangHoa"];
itemDTO.IdHangSanXuat = (int)dr["IdHangSanXuat"];
itemDTO.IdNoiSanXuat = (int)dr["IdNoiSanXuat"];
itemDTO.IdViTri = (int)dr["IdViTri"];
itemDTO.SoDangKy = (string)dr["SoDangKy"];
itemDTO.IdDonViTinh = (int)dr["IdDonViTinh"];
itemDTO.GiaNhap = (double)dr["GiaNhap"];
itemDTO.TyLeChietKhau = (double)dr["TyLeChietKhau"];
itemDTO.VAT = (double)dr["VAT"];
itemDTO.IdDonViQuyDoi1 = (int)dr["IdDonViQuyDoi1"];
itemDTO.TyLeQuyDoi1 = (int)dr["TyLeQuyDoi1"];
itemDTO.GiaQuyDoi1 = (double)dr["GiaQuyDoi1"];
itemDTO.GiaDeXuat1 = (double)dr["GiaDeXuat1"];
itemDTO.IdDonViQuyDoi2 = (int)dr["IdDonViQuyDoi2"];
itemDTO.TyLeQuyDoi2 = (int)dr["TyLeQuyDoi2"];
itemDTO.GiaQuyDoi2 = (double)dr["GiaQuyDoi2"];
itemDTO.GiaDeXuat2 = (double)dr["GiaDeXuat2"];
itemDTO.NhietDoBaoQuan = (string)dr["NhietDoBaoQuan"];
itemDTO.AnhSangBaoQuan = (string)dr["AnhSangBaoQuan"];
itemDTO.DoAmBaoQuan = (string)dr["DoAmBaoQuan"];
itemDTO.QuanLyKho = (bool)dr["QuanLyKho"];
danhSach.Add(itemDTO);
}
return danhSach;
}
public static bool XoaHangHoa(HangHoaDTO hh)
{
DataProvider p = new DataProvider();
p.Connect();
SqlParameter p0 = new SqlParameter("@MaHangHoa", SqlDbType.Int)
{
Value = hh.MaHangHoa
};
int n = p.ExecuteNonQuery("sp_XoaHangHoa", CommandType.StoredProcedure, p0);
p.Disconnect();
if (n == 0)
{
return(false);
}
return(true);
}
private void BtnAdd_Click(object sender, EventArgs e)
{
if (IsNullValue())
{
MessageBox.Show("Không thể thêm hàng hóa với tên rỗng!", "Thông Báo", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning);
}
else
{
HangHoaDTO hangHoa = getInfo();
if (HangHoaBUS.Instance.AddCategory(hangHoa) > 0)
{
LoadData();
RefreshFlowLayoutPannel();
}
}
}
public ThemHangHoa(bool _isAddNew1, HangHoaDTO HangHoaDTO)
{
InitializeComponent();
_isAddNew = _isAddNew1;
gluNhomHang.Text = HangHoaDTO.NhomHang;
txtMaHang.Text = HangHoaDTO.MaHang;
txtTenHang.Text = HangHoaDTO.TenHang;
gluDonVi.EditValue = HangHoaDTO.DonVi;
gluKho.EditValue = HangHoaDTO.TenKho;
gluNCC.EditValue = HangHoaDTO.NCC;
txtGiaMua.Text = HangHoaDTO.GiaMua.ToString();
txtGiaBan.Text = HangHoaDTO.GiaBan.ToString();
ckbConQuanLy.Checked = HangHoaDTO.ConQuanLy;
if (!_isAddNew)
{
txtMaHang.Enabled = false;
}
}
public void Sua(HangHoaDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Update DanhMucHangHoa Set MaHangHoa = ?, TenHangHoa = ?, IdHoatChatChinh = ?, IdNhomHangHoa = ?, IdLoaiHangHoa = ?, IdHangSanXuat = ?, IdNoiSanXuat = ?, IdViTri = ?, SoDangKy = ?, IdDonViTinh = ?, GiaNhap = ?, TyLeChietKhau = ?, VAT = ?, IdDonViQuyDoi1 = ?, TyLeQuyDoi1 = ?, GiaQuyDoi1 = ?, GiaDeXuat1 = ?, IdDonViQuyDoi2 = ?, TyLeQuyDoi2 = ?, GiaQuyDoi2 = ?, GiaDeXuat2 = ?, NhietDoBaoQuan = ?, AnhSangBaoQuan = ?, DoAmBaoQuan = ?, QuanLyKho = ? Where Id = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaHangHoa", OleDbType.WChar).Value = itemDTO.MaHangHoa;
cmd.Parameters.Add("@TenHangHoa", OleDbType.WChar).Value = itemDTO.TenHangHoa;
cmd.Parameters.Add("@IdHoatChatChinh", OleDbType.Integer).Value = itemDTO.IdHoatChatChinh;
cmd.Parameters.Add("@IdNhomHangHoa", OleDbType.Integer).Value = itemDTO.IdNhomHangHoa;
cmd.Parameters.Add("@IdLoaiHangHoa", OleDbType.Integer).Value = itemDTO.IdLoaiHangHoa;
cmd.Parameters.Add("@IdHangSanXuat", OleDbType.Integer).Value = itemDTO.IdHangSanXuat;
cmd.Parameters.Add("@IdNoiSanXuat", OleDbType.Integer).Value = itemDTO.IdNoiSanXuat;
cmd.Parameters.Add("@IdViTri", OleDbType.Integer).Value = itemDTO.IdViTri;
cmd.Parameters.Add("@SoDangKy", OleDbType.WChar).Value = itemDTO.SoDangKy;
cmd.Parameters.Add("@IdDonViTinh", OleDbType.Integer).Value = itemDTO.IdDonViTinh;
cmd.Parameters.Add("@GiaNhap", OleDbType.Double).Value = itemDTO.GiaNhap;
cmd.Parameters.Add("@TyLeChietKhau", OleDbType.Integer).Value = itemDTO.TyLeChietKhau;
cmd.Parameters.Add("@VAT", OleDbType.Double).Value = itemDTO.VAT;
cmd.Parameters.Add("@IdDonViQuyDoi1", OleDbType.Integer).Value = itemDTO.IdDonViQuyDoi1;
cmd.Parameters.Add("@TyLeQuyDoi1", OleDbType.Integer).Value = itemDTO.TyLeQuyDoi1;
cmd.Parameters.Add("@GiaQuyDoi1", OleDbType.Double).Value = itemDTO.GiaQuyDoi1;
cmd.Parameters.Add("@GiaDeXuat1", OleDbType.Double).Value = itemDTO.GiaDeXuat1;
cmd.Parameters.Add("@IdDonViQuyDoi2", OleDbType.Integer).Value = itemDTO.IdDonViQuyDoi2;
cmd.Parameters.Add("@TyLeQuyDoi2", OleDbType.Integer).Value = itemDTO.TyLeQuyDoi2;
cmd.Parameters.Add("@GiaQuyDoi2", OleDbType.Double).Value = itemDTO.GiaQuyDoi2;
cmd.Parameters.Add("@GiaDeXuat2", OleDbType.Double).Value = itemDTO.GiaDeXuat2;
cmd.Parameters.Add("@NhietDoBaoQuan", OleDbType.WChar).Value = itemDTO.NhietDoBaoQuan;
cmd.Parameters.Add("@AnhSangBaoQuan", OleDbType.WChar).Value = itemDTO.AnhSangBaoQuan;
cmd.Parameters.Add("@DoAmBaoQuan", OleDbType.WChar).Value = itemDTO.DoAmBaoQuan;
cmd.Parameters.Add("@QuanLyKho", OleDbType.Boolean).Value = itemDTO.QuanLyKho;
cmd.Parameters.Add("@Id", OleDbType.Numeric).Value = itemDTO.Id;
cmd.ExecuteNonQuery();
cn.Close();
}
public void Them(HangHoaDTO itemDTO)
{
HangHoaDAO itemDAO = new HangHoaDAO();
itemDAO.Them(itemDTO);
}
public void Sua(HangHoaDTO itemDTO)
{
HangHoaDAO itemDAO = new HangHoaDAO();
itemDAO.Sua(itemDTO);
}
private void gvDanhMucHangHoa_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
if (gvDanhMucHangHoa.FocusedRowHandle > -1)
{
try
{
HangHoaDTO itemDTO = new HangHoaDTO();
HangHoaBUS itemBUS = new HangHoaBUS();
itemDTO.MaHangHoa = gvDanhMucHangHoa.GetFocusedRowCellValue("MaHangHoa").ToString();
itemDTO.TenHangHoa = gvDanhMucHangHoa.GetFocusedRowCellValue("TenHangHoa").ToString();
itemDTO.IdHoatChatChinh = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("IdHoatChatChinh").ToString());
itemDTO.IdNhomHangHoa = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("IdNhomHangHoa").ToString());
itemDTO.IdLoaiHangHoa = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("IdLoaiHangHoa").ToString());
itemDTO.IdHangSanXuat = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("IdHangSanXuat").ToString());
itemDTO.IdNoiSanXuat = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("IdNoiSanXuat").ToString());
itemDTO.IdViTri = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("IdViTri").ToString());
itemDTO.SoDangKy = gvDanhMucHangHoa.GetFocusedRowCellValue("SoDangKy").ToString();
itemDTO.IdDonViTinh = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("IdDonViTinh").ToString());
itemDTO.GiaNhap = double.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("GiaNhap").ToString());
itemDTO.TyLeChietKhau = double.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("TyLeChietKhau").ToString());
itemDTO.VAT = double.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("VAT").ToString());
itemDTO.IdDonViQuyDoi1 = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("IdDonViQuyDoi1").ToString());
itemDTO.TyLeQuyDoi1 = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("TyLeQuyDoi1").ToString());
itemDTO.GiaQuyDoi1 = double.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("GiaQuyDoi1").ToString());
itemDTO.GiaDeXuat1 = double.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("GiaDeXuat1").ToString());
itemDTO.IdDonViQuyDoi2 = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("IdDonViQuyDoi2").ToString());
itemDTO.TyLeQuyDoi2 = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("TyLeQuyDoi2").ToString());
itemDTO.GiaQuyDoi2 = double.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("GiaQuyDoi2").ToString());
itemDTO.GiaDeXuat2 = double.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("GiaDeXuat2").ToString());
itemDTO.NhietDoBaoQuan = gvDanhMucHangHoa.GetFocusedRowCellValue("NhietDoBaoQuan").ToString();
itemDTO.AnhSangBaoQuan = gvDanhMucHangHoa.GetFocusedRowCellValue("AnhSangBaoQuan").ToString();
itemDTO.DoAmBaoQuan = gvDanhMucHangHoa.GetFocusedRowCellValue("DoAmBaoQuan").ToString();
itemDTO.QuanLyKho = bool.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("QuanLyKho").ToString());
itemDTO.Id = int.Parse(gvDanhMucHangHoa.GetFocusedRowCellValue("Id").ToString());
if (this.flagThem && gvDanhMucHangHoa.FocusedRowHandle == gvDanhMucHangHoa.RowCount - 2)
{
if (itemDTO.MaHangHoa.Length > 0)
{
DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn thêm mới?", "Thêm mới", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (hopThoai == DialogResult.Yes)
{
itemBUS.Them(itemDTO);
this.flagThem = false;
}
}
else
{
MessageBox.Show("Bạn chưa nhập mã!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn cập nhật?", "Cập nhật", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (hopThoai == DialogResult.Yes)
{
itemBUS.Sua(itemDTO);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.LayDanhSachHangHoa();
}
}
public void Them(HangHoaDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Insert into DanhMucHangHoa (MaHangHoa, TenHangHoa, IdHoatChatChinh, IdNhomHangHoa, IdLoaiHangHoa, IdHangSanXuat, IdNoiSanXuat, IdViTri, SoDangKy, IdDonViTinh, GiaNhap, TyLeChietKhau, VAT, IdDonViQuyDoi1, TyLeQuyDoi1, GiaQuyDoi1, GiaDeXuat1, IdDonViQuyDoi2, TyLeQuyDoi2, GiaQuyDoi2, GiaDeXuat2, NhietDoBaoQuan, AnhSangBaoQuan, DoAmBaoQuan, QuanLyKho) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaHangHoa", OleDbType.WChar).Value = itemDTO.MaHangHoa;
cmd.Parameters.Add("@TenHangHoa", OleDbType.WChar).Value = itemDTO.TenHangHoa;
cmd.Parameters.Add("@IdHoatChatChinh", OleDbType.Integer).Value = itemDTO.IdHoatChatChinh;
cmd.Parameters.Add("@IdNhomHangHoa", OleDbType.Integer).Value = itemDTO.IdNhomHangHoa;
cmd.Parameters.Add("@IdLoaiHangHoa", OleDbType.Integer).Value = itemDTO.IdLoaiHangHoa;
cmd.Parameters.Add("@IdHangSanXuat", OleDbType.Integer).Value = itemDTO.IdHangSanXuat;
cmd.Parameters.Add("@IdNoiSanXuat", OleDbType.Integer).Value = itemDTO.IdNoiSanXuat;
cmd.Parameters.Add("@IdViTri", OleDbType.Integer).Value = itemDTO.IdViTri;
cmd.Parameters.Add("@SoDangKy", OleDbType.WChar).Value = itemDTO.SoDangKy;
cmd.Parameters.Add("@IdDonViTinh", OleDbType.Integer).Value = itemDTO.IdDonViTinh;
cmd.Parameters.Add("@GiaNhap", OleDbType.Double).Value = itemDTO.GiaNhap;
cmd.Parameters.Add("@TyLeChietKhau", OleDbType.Double).Value = itemDTO.TyLeChietKhau;
cmd.Parameters.Add("@VAT", OleDbType.Double).Value = itemDTO.VAT;
cmd.Parameters.Add("@IdDonViQuyDoi1", OleDbType.Integer).Value = itemDTO.IdDonViQuyDoi1;
cmd.Parameters.Add("@TyLeQuyDoi1", OleDbType.Integer).Value = itemDTO.TyLeQuyDoi1;
cmd.Parameters.Add("@GiaQuyDoi1", OleDbType.Double).Value = itemDTO.GiaQuyDoi1;
cmd.Parameters.Add("@GiaDeXuat1", OleDbType.Double).Value = itemDTO.GiaDeXuat1;
cmd.Parameters.Add("@IdDonViQuyDoi2", OleDbType.Integer).Value = itemDTO.IdDonViQuyDoi2;
cmd.Parameters.Add("@TyLeQuyDoi2", OleDbType.Integer).Value = itemDTO.TyLeQuyDoi2;
cmd.Parameters.Add("@GiaQuyDoi2", OleDbType.Double).Value = itemDTO.GiaQuyDoi2;
cmd.Parameters.Add("@GiaDeXuat2", OleDbType.Double).Value = itemDTO.GiaDeXuat2;
cmd.Parameters.Add("@NhietDoBaoQuan", OleDbType.WChar).Value = itemDTO.NhietDoBaoQuan;
cmd.Parameters.Add("@AnhSangBaoQuan", OleDbType.WChar).Value = itemDTO.AnhSangBaoQuan;
cmd.Parameters.Add("@DoAmBaoQuan", OleDbType.WChar).Value = itemDTO.DoAmBaoQuan;
cmd.Parameters.Add("@QuanLyKho", OleDbType.Boolean).Value = itemDTO.QuanLyKho;
cmd.ExecuteNonQuery();
cn.Close();
}
