protected void Page_Load(object sender, EventArgs e) { string IDHH = Request.QueryString["IDHH"]; string IDNH = Request.QueryString["IDNH"]; string strNhomHang = "Tất cả nhóm hàng"; string strHangHoa = "Tất cả hàng hóa"; dataNhomHang dt3 = new dataNhomHang(); if (Int32.Parse(IDNH) != -1) { strNhomHang = dt3.LayTenNhomHang_ID(IDNH); } dataHangHoa dt4 = new dataHangHoa(); if (Int32.Parse(IDHH) != -1) { strHangHoa = dt4.LayTenHangHoa(IDHH); } rpBaoCaoTonKho rp = new rpBaoCaoTonKho(); rp.Parameters["IDHH"].Value = IDHH; rp.Parameters["IDHH"].Visible = false; rp.Parameters["IDNH"].Value = IDNH; rp.Parameters["IDNH"].Visible = false; rp.Parameters["strNhomHang"].Value = strNhomHang; rp.Parameters["strNhomHang"].Visible = false; rp.Parameters["strHangHoa"].Value = strHangHoa; rp.Parameters["strHangHoa"].Visible = false; viewerReport.Report = rp; }
protected void gridHangHoa_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { string ID = e.Keys[0].ToString(); string MaHang = e.NewValues["MaHang"].ToString(); string IDNhomHang = e.NewValues["IDNhomHang"].ToString(); string TenHangHoa = e.NewValues["TenHangHoa"].ToString(); string IDDonViTinhLe = e.NewValues["IDDonViTinhLe"].ToString(); string IDDonViTinhSi = e.NewValues["IDDonViTinhSi"].ToString(); double GiaMua = Double.Parse(e.NewValues["GiaMua"].ToString()); double GiaBan = Double.Parse(e.NewValues["GiaBan"].ToString()); double DoDay = Double.Parse(e.NewValues["DoDay"].ToString()); double ChieuDai = Double.Parse(e.NewValues["ChieuDai"].ToString()); string GhiChu = e.NewValues["GhiChu"] != null ? e.NewValues["GhiChu"].ToString() : ""; data = new dataHangHoa(); double GiaCu = data.LaySoTienCu(ID); if (GiaCu != GiaBan) { dtThayDoiGia.ThemLichSu(MaHang, ID, IDDonViTinhLe, GiaCu.ToString(), GiaBan.ToString(), Session["IDNhanVien"].ToString(), "Thay đổi giá"); dtBangGia bg = new dtBangGia(); bg.CapNhatGiaCuTrongChiTietBangGia(ID, GiaBan.ToString()); } data.SuaThongTinHangHoaNew(ID, IDNhomHang, MaHang, TenHangHoa, IDDonViTinhLe, IDDonViTinhSi, GiaMua, GiaBan, GhiChu, DoDay.ToString(), ChieuDai.ToString()); e.Cancel = true; gridHangHoa.CancelEdit(); LoadGrid(cmbSoLuongXem.Value.ToString()); }
protected void cmbNhomHang_SelectedIndexChanged1(object sender, EventArgs e) { if (Int32.Parse(cmbNhomHang.Value + "") == -1) { dataHangHoa dtHH = new dataHangHoa(); DataTable daHH = dtHH.LayDanhSachHangHoa_Ten(); daHH.Rows.Add(-1, "Tất cả hàng hóa"); cmbHangHoa.DataSource = daHH; cmbHangHoa.TextField = "TenHangHoa"; cmbHangHoa.ValueField = "ID"; cmbHangHoa.DataBind(); cmbHangHoa.SelectedIndex = daHH.Rows.Count; } else { dataHangHoa dtHH = new dataHangHoa(); DataTable daHH = dtHH.LayDanhSachHangHoa_IDNhom(cmbNhomHang.Value + ""); daHH.Rows.Add(-1, "Tất cả hàng hóa"); cmbHangHoa.DataSource = daHH; cmbHangHoa.TextField = "TenHangHoa"; cmbHangHoa.ValueField = "ID"; cmbHangHoa.DataBind(); cmbHangHoa.SelectedIndex = daHH.Rows.Count; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { dataNhomHang dtNhomH = new dataNhomHang(); DataTable daNhomH = dtNhomH.getDanhSachNhomHang2(); daNhomH.Rows.Add(-1, "Tất cả nhóm hàng"); cmbNhomHang.DataSource = daNhomH; cmbNhomHang.TextField = "TenNhomHang"; cmbNhomHang.ValueField = "ID"; cmbNhomHang.DataBind(); cmbNhomHang.SelectedIndex = daNhomH.Rows.Count; dataHangHoa dtHH = new dataHangHoa(); DataTable daHH = dtHH.LayDanhSachHangHoa_Ten(); daHH.Rows.Add(-1, "Tất cả hàng hóa"); cmbHangHoa.DataSource = daHH; cmbHangHoa.TextField = "TenHangHoa"; cmbHangHoa.ValueField = "ID"; cmbHangHoa.DataBind(); cmbHangHoa.SelectedIndex = daHH.Rows.Count; } }
protected void gridHangHoa_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { data = new dataHangHoa(); List <string> ListBarCode = GetListBarCode(); string MaHang = e.NewValues["MaHang"].ToString(); DataTable dd = data.KiemTraHangHoa(MaHang); if (dd.Rows.Count == 0) { string IDNhomHang = e.NewValues["IDNhomHang"].ToString(); string TenHangHoa = e.NewValues["TenHangHoa"].ToString(); string IDDonViTinh = e.NewValues["IDDonViTinh"].ToString(); float GiaMua = float.Parse(e.NewValues["GiaMua"].ToString()); float GiaBan = float.Parse(e.NewValues["GiaBan"].ToString()); string GhiChu = e.NewValues["GhiChu"] != null ? e.NewValues["GhiChu"].ToString() : ""; e.NewValues["HinhAnh"] = Session["UploadImages"]; string HinhAnh = e.NewValues["HinhAnh"] != null ? e.NewValues["HinhAnh"].ToString() : ""; int KT = 0; if (ListBarCode.Count == 0) { KT = 1; throw new Exception("Lỗi:Vui lòng nhập Barcode cho hàng hóa !!"); return; } foreach (string barCode in ListBarCode) { if (dataHangHoa.KiemTraBarcode(barCode) == false) { KT = 1; throw new Exception("Lỗi:Barcode đã tồn tại !!"); return; } } if (KT == 0) { object IDHangHoa = data.ThemHangHoa(IDNhomHang, MaHang, TenHangHoa, IDDonViTinh, GiaMua, GiaBan, GhiChu, HinhAnh); if (IDHangHoa != null) { Session["UploadImages"] = ""; data.ThemDanhSachBarCode(IDHangHoa, ListBarCode); DataTable dta = data.LayDanhSachCuaHang(); for (int i = 0; i < dta.Rows.Count; i++) { DataRow dr = dta.Rows[i]; int IDKho = Int32.Parse(dr["ID"].ToString()); data.ThemHangVaoTonKho(IDKho, (int)IDHangHoa, 0); } } e.Cancel = true; gridHangHoa.CancelEdit(); LoadGrid(cmbSoLuongXem.Value.ToString()); } } else { Response.Write("<script language='JavaScript'> alert('Mã hàng đã tồn tại.'); </script>"); } }
protected void gridBarCode_Init(object sender, EventArgs e) { data = new dataHangHoa(); ASPxGridView gridBarCode = sender as ASPxGridView; object IDHangHoa = gridBarCode.GetMasterRowKeyValue(); gridBarCode.DataSource = data.GetListBarCode(IDHangHoa); gridBarCode.DataBind(); }
protected void gridHangHoa_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { string ID = e.Keys[0].ToString(); data = new dataHangHoa(); data.XoaHangHoa(ID); e.Cancel = true; gridHangHoa.CancelEdit(); LoadGrid(cmbSoLuongXem.Value.ToString()); }
protected void gridBarCode_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { data = new dataHangHoa(); int ID = Int32.Parse(e.Keys["ID"].ToString()); data.XoaBarCode(ID); e.Cancel = true; ASPxGridView gridBarCode = sender as ASPxGridView; object IDHangHoa = gridBarCode.GetMasterRowKeyValue(); gridBarCode.DataSource = data.GetListBarCode(IDHangHoa); gridBarCode.DataBind(); }
protected void gridBarCode_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { data = new dataHangHoa(); ASPxGridView gridBarCode = sender as ASPxGridView; int ID = Int32.Parse(e.Keys["ID"].ToString()); object IDHangHoa = gridBarCode.GetMasterRowKeyValue(); string BarCode = e.NewValues["Barcode"] != null ? e.NewValues["Barcode"].ToString() : ""; data.CapNhatBarCode(ID, IDHangHoa, BarCode); e.Cancel = true; gridBarCode.CancelEdit(); gridBarCode.DataSource = data.GetListBarCode(IDHangHoa); gridBarCode.DataBind(); }
protected void gridHangHoa_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { data = new dataHangHoa(); string MaHang = e.NewValues["MaHang"].ToString(); DataTable dd = data.KiemTraHangHoa(MaHang); if (dd.Rows.Count == 0) { string IDNhomHang = e.NewValues["IDNhomHang"].ToString(); string TenHangHoa = e.NewValues["TenHangHoa"].ToString(); string IDDonViTinhLe = e.NewValues["IDDonViTinhLe"].ToString(); string IDDonViTinhSi = e.NewValues["IDDonViTinhSi"].ToString(); double GiaMua = Double.Parse(e.NewValues["GiaMua"].ToString()); double GiaBan = Double.Parse(e.NewValues["GiaBan"].ToString()); double DoDay = Double.Parse(e.NewValues["DoDay"].ToString()); double ChieuDai = Double.Parse(e.NewValues["ChieuDai"].ToString()); string GhiChu = e.NewValues["GhiChu"] != null ? e.NewValues["GhiChu"].ToString() : ""; object IDHangHoa = data.ThemHangHoa(IDNhomHang, MaHang, TenHangHoa, IDDonViTinhLe, IDDonViTinhSi, GiaMua, GiaBan, GhiChu, DoDay.ToString(), ChieuDai.ToString()); if (IDHangHoa != null) { //thêm vào tồn kho DataTable dta = data.LayDanhSachCuaHang(); for (int i = 0; i < dta.Rows.Count; i++) { DataRow dr = dta.Rows[i]; int IDKho = Int32.Parse(dr["ID"].ToString()); data.ThemHangVaoTonKho(IDKho, (int)IDHangHoa, 0); } //thêm vào all bảng giá dtBangGia bg = new dtBangGia(); DataTable dbt = bg.DanhSach(); foreach (DataRow dr in dbt.Rows) { string IDBangGia = dr["ID"].ToString(); bg.ThemIDHangHoaVaoChiTietGia(IDHangHoa, IDBangGia, GiaBan.ToString()); } } e.Cancel = true; gridHangHoa.CancelEdit(); LoadGrid(cmbSoLuongXem.Value.ToString()); } else { Response.Write("<script language='JavaScript'> alert('Mã hàng đã tồn tại.'); </script>"); } }
protected void gridBarCode_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { data = new dataHangHoa(); ASPxGridView gridBarCode = sender as ASPxGridView; object IDHangHoa = gridBarCode.GetMasterRowKeyValue(); string BarCode = e.NewValues["Barcode"].ToString(); if (dataHangHoa.KiemTraBarcode(BarCode) == true) { data.ThemBarCode(IDHangHoa, BarCode); } else { throw new Exception("Lỗi:Barcode đã tồn tại"); } e.Cancel = true; gridBarCode.CancelEdit(); gridBarCode.DataSource = data.GetListBarCode(IDHangHoa); gridBarCode.DataBind(); }
protected void gridHangHoa_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { data = new dataHangHoa(); List <string> ListBarCode = GetListBarCode(); string MaHang = e.NewValues["MaNguyenLieu"].ToString(); string TenHangHoa = e.NewValues["TenNguyenLieu"].ToString(); string IDDonViTinh = e.NewValues["IDDonViTinh"].ToString(); float GiaMua = float.Parse(e.NewValues["GiaMua"].ToString()); float GiaBan = float.Parse(e.NewValues["GiaBan"].ToString()); string GhiChu = e.NewValues["GhiChu"] != null ? e.NewValues["GhiChu"].ToString() : ""; e.NewValues["NhaCungCap"] = Session["UploadImages"]; string HinhAnh = e.NewValues["NhaCungCap"] != null ? e.NewValues["NhaCungCap"].ToString() : ""; string ID = e.Keys[0].ToString(); int KT = 0; if (ListBarCode.Count == 0) { KT = 1; throw new Exception("Lỗi:Vui lòng nhập Barcode cho hàng hóa !!"); return; } if (KT == 0) { if (HinhAnh != "") { Session["UploadImages"] = ""; data.SuaThongTinHangHoa(ID, MaHang, TenHangHoa, IDDonViTinh, GiaMua, GiaBan, GhiChu, HinhAnh); } else { data.SuaThongTinHangHoaKHinh(ID, MaHang, TenHangHoa, IDDonViTinh, GiaMua, GiaBan, GhiChu); } data.SuaDanhSachBarCode(e.Keys["ID"] as object, ListBarCode); e.Cancel = true; gridHangHoa.CancelEdit(); LoadGrid(cmbSoLuongXem.Value.ToString()); } }
private void LoadGrid(string HienThi) { data = new dataHangHoa(); gridHangHoa.DataSource = data.LayDanhSachHangHoa(HienThi); gridHangHoa.DataBind(); }