protected void btnHuy_Click(object sender, EventArgs e)
{
data = new dtHangCombo();
int IDHangHoaComBo = Int32.Parse(IDHangHoaComBo_Temp.Value.ToString());
data.XoaHangHoa_Temp_IDHangCombo(IDHangHoaComBo);
Response.Redirect("DanhMucCombo.aspx");
}
protected void BtnXoaHang_Click(object sender, EventArgs e)
{
string ID = (((ASPxButton)sender).CommandArgument).ToString();
string IDHangHoaComBo = IDHangHoaComBo_Temp.Value.ToString();
data = new dtHangCombo();
data.XoaHangHoa_Temp_ID(ID);
TinhTrongLuong();
TinhTongTien();
LoadGrid(Int32.Parse(IDHangHoaComBo));
}
protected void btnThem_Temp_Click(object sender, EventArgs e)
{
if (txtSoLuong.Text != "" && cmbHangHoa.Text != "")
{
int SL = Int32.Parse(txtSoLuong.Text);
int SLTonKho = Int32.Parse(txtTonKho.Text);
if (SL > 0)
{
int IDHangHoaComBo = Int32.Parse(IDHangHoaComBo_Temp.Value.ToString());
double GiaBanSauThue = double.Parse(txtGiaBanST.Text.ToString());
double GiaBanTruocThue = dtHangHoa.LayGiaBanTruocThue(cmbHangHoa.Value.ToString());
double GiaMuaSauThue = dtHangHoa.LayGiaMuaSauThue(cmbHangHoa.Value.ToString());
double GiaMuaTruocThue = dtHangHoa.LayGiaMuaTruocThue(cmbHangHoa.Value.ToString());
string MaHang = dtHangHoa.LayMaHang(cmbHangHoa.Value.ToString());
string IDDonViTinh = dtHangHoa.LayIDDonViTinh(cmbHangHoa.Value.ToString());
double TrongLuong = dtHangHoa.LayTrongLuong(cmbHangHoa.Value.ToString());
string GhiChu = txtGhiChuHangHoa.Text == null ? "" : txtGhiChuHangHoa.Text.ToString();
data = new dtHangCombo();
DataTable db = data.KTHangHoa_Temp(cmbHangHoa.Value.ToString(), IDHangHoaComBo);// kiểm tra hàng hóa
double TongTrongLuong = SL * TrongLuong;
double TongGiaMuaSauThue = SL * GiaMuaSauThue;
double TongGiaMuaTruocThue = SL * GiaMuaTruocThue;
double TongGiaBanTruocThue = SL * GiaBanTruocThue;
double TongGiaBanSauThue = SL * GiaBanSauThue;
if (db.Rows.Count == 0)
{
data = new dtHangCombo();
data.ThemHangHoa_Temp(IDHangHoaComBo, cmbHangHoa.Value.ToString(), SL, TongGiaBanTruocThue, TongGiaBanSauThue, MaHang, IDDonViTinh, TongTrongLuong.ToString(), GiaBanSauThue, TongGiaMuaTruocThue, TongGiaMuaSauThue, GhiChu);
TinhTongTien();
Clear();
}
else
{
data = new dtHangCombo();
data.UpdateHangHoa_temp(IDHangHoaComBo, cmbHangHoa.Value.ToString(), SL, TongGiaBanTruocThue, TongGiaBanSauThue, MaHang, IDDonViTinh, TongTrongLuong.ToString(), GiaBanSauThue, TongGiaMuaTruocThue, TongGiaMuaSauThue, GhiChu);
TinhTongTien();
Clear();
}
LoadGrid(IDHangHoaComBo);
}
else
{
Response.Write("<script language='JavaScript'> alert('Số lượng > 0.'); </script>"); return;
}
}
else
{
Response.Write("<script language='JavaScript'> alert('Bạn chưa chọn hàng hóa hoặc số lượng.'); </script>"); return;
}
}
public void TinhTrongLuong()
{
data = new dtHangCombo();
DataTable db = data.DanhSachHangHoaCombo_Temp(Int32.Parse(IDHangHoaComBo_Temp.Value.ToString()));
if (db.Rows.Count != 0)
{
double Tong = 0;
foreach (DataRow dr in db.Rows)
{
double TrongLuong = double.Parse(dr["TrongLuong"].ToString());
Tong = Tong + TrongLuong;
}
txtTrongLuong.Text = (Tong).ToString();
}
else
{
txtTrongLuong.Text = "0";
}
}
public void TinhTongTien()
{
data = new dtHangCombo();
DataTable db = data.DanhSachHangHoaCombo_Temp(Int32.Parse(IDHangHoaComBo_Temp.Value.ToString()));
if (db.Rows.Count != 0)
{
double GiaBanTruocThue = 0, GiaBanSauThue = 0, GiaMuaTruocThue = 0, GiaMuaSauThue = 0;
foreach (DataRow dr in db.Rows)
{
double ThanhTieN2 = double.Parse(dr["GiaMuaTruocThue"].ToString());
GiaMuaTruocThue = GiaMuaTruocThue + ThanhTieN2;
double ThanhTien2 = double.Parse(dr["GiaMuaSauThue"].ToString());
GiaMuaSauThue = GiaMuaSauThue + ThanhTien2;
double ThanhTien3 = double.Parse(dr["GiaBanTruocThue"].ToString());
GiaBanTruocThue = GiaBanTruocThue + ThanhTien3;
double ThanhTien4 = double.Parse(dr["ThanhTien"].ToString());
GiaBanSauThue = GiaBanSauThue + ThanhTien4;
}
txtGiaMuaTruocThue.Text = GiaMuaTruocThue.ToString();
txtGiaMuaSauThue.Text = GiaMuaSauThue.ToString();
txtGiaBanTruocThue.Text = GiaBanTruocThue.ToString();
txtGiaBanSauThue.Text = GiaBanSauThue.ToString();
txtGiaBanTong.Text = GiaBanSauThue.ToString();
TinhTrongLuong();
}
else
{
txtGiaMuaTruocThue.Text = "0";
txtGiaMuaSauThue.Text = "0";
txtGiaBanTruocThue.Text = "0";
txtGiaBanSauThue.Text = "0";
txtGiaBanTong.Text = "0";
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
if (txtBarcode.Text != "" && txtHanSuDung.Text != "" && txtMaHang.Text != "" && cmbDonViTinh.Text != "" && txtTenHangHoa.Text != "" && txtGiaBanTong.Text != "" && cmbNhomHang.Text != "")
{
data = new dtHangCombo();
int IDHangHoaComBo = Int32.Parse(IDHangHoaComBo_Temp.Value.ToString());
DataTable dt = data.DanhSachHangHoaCombo_Temp(IDHangHoaComBo);
if (dt.Rows.Count != 0)
{
string MaHang = txtMaHang.Text.Trim();
string txtTenHangComBo = txtTenHangHoa.Text.ToString();
if (dtSetting.kiemTraChuyenDoiDau() == 1)
{
txtTenHangComBo = dtSetting.convertDauSangKhongDau(txtTenHangComBo).ToUpper();
}
string IDDonViTinh = cmbDonViTinh.Value.ToString();
string IDNhomHang = cmbNhomHang.Value.ToString();
string TongGiaMuaTruocThue = txtGiaMuaTruocThue.Text.ToString();
string TongGiaMuaSauThue = txtGiaMuaSauThue.Text.ToString();
string TongGiaBanTruocThue = txtGiaBanTruocThue.Text.ToString();
string TongGiaBanSauThue = txtGiaBanSauThue.Text.ToString();
string GiaBanTong = txtGiaBanTong.Text.ToString();
string TongTrongLuong = txtTrongLuong.Text;
string Barcode = txtBarcode.Text.Trim();
string HanSuDung = txtHanSuDung.Text.ToString();
string GhiChu = txtGhiChu.Text == null ? "" : txtGhiChu.Text.ToString();
if ((dtHangHoa.KiemTraMaHang(MaHang)) == false)
{
if (dtHangHoa.KiemTraBarcode(Barcode) == false)
{
data = new dtHangCombo();
object ID = data.ThemIDHangHoa_Temp();
if (ID != null)
{
data.CapNhatHangHoa(ID, MaHang, txtTenHangComBo, IDNhomHang, IDDonViTinh, TongGiaMuaTruocThue, TongGiaBanTruocThue, TongGiaMuaSauThue, TongGiaBanSauThue, TongTrongLuong, GhiChu, HanSuDung);
data.ThemBarCode(ID, Barcode);
//Thêm hàng hóa vào các kho....
DataTable dta = data.LayDanhSachKho();
for (int i = 0; i < dta.Rows.Count; i++)
{
DataRow dr = dta.Rows[i];
int IDKho = Int32.Parse(dr["ID"].ToString());
data = new dtHangCombo();
data.ThemHangVaoTonKho(IDKho, (int)ID, "0", GiaBanTong, GiaBanTong, GiaBanTong, GiaBanTong, GiaBanTong, GiaBanTong);
}
foreach (DataRow dr in dt.Rows)
{
string IDHangHoa1 = dr["IDHangHoa"].ToString();
string SoLuong1 = dr["SoLuong"].ToString();
string GiaBanTruocThue1 = dr["GiaBanTruocThue"].ToString();
string ThanhTieN2 = dr["ThanhTien"].ToString();
string IDDonViTinh1 = dr["IDDonViTinh"].ToString();
string MaHang1 = dr["MaHang"].ToString();
string TrongLuong1 = dr["TrongLuong"].ToString();
string GiaBanSauThue1 = dr["GiaBanSauThue"].ToString();
string GiaMuaTruocThue1 = dr["GiaMuaTruocThue"].ToString();
string GiaMuaSauThue1 = dr["GiaMuaSauThue"].ToString();
string GhiChu1 = dr["GhiChu"].ToString();
data = new dtHangCombo();
data.ThemHangHoa(ID, IDHangHoa1, SoLuong1, GiaBanTruocThue1, ThanhTieN2, IDDonViTinh1, MaHang1, TrongLuong1, GiaBanSauThue1, GiaMuaTruocThue1, GiaMuaSauThue1, GhiChu1);
}
data.XoaHangHoa_Temp_IDHangCombo(IDHangHoaComBo);
dtLichSuTruyCap.ThemLichSu(Session["IDNhanVien"].ToString(), Session["IDNhom"].ToString(), "Hàng hóa combo", Session["IDKho"].ToString(), "Danh Mục", "Thêm");
Response.Redirect("DanhMucCombo.aspx");
}
}
else
{
Response.Write("<script language='JavaScript'> alert('Mã Barcode đã tồn tại. Vui lòng kiểm tra lại?'); </script>"); return;
}
}
else
{
Response.Write("<script language='JavaScript'> alert('Mã hàng đã tồn tại.Vui lòng kiểm tra lại'); </script>"); return;
}
}
else
{
cmbHangHoa.Focus();
Response.Write("<script language='JavaScript'> alert('Danh sách hàng hóa combo rỗng.'); </script>"); return;
}
}
else
{
Response.Write("<script language='JavaScript'> alert('Trường có dấu (*) không được bỏ trống.'); </script>"); return;
}
}
private void LoadGrid(int IDHangHoaComBo)
{
data = new dtHangCombo();
gridDanhSachHangHoa.DataSource = data.DanhSachHangHoaCombo_Temp(IDHangHoaComBo);
gridDanhSachHangHoa.DataBind();
}
