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