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