protected void Page_Load(object sender, EventArgs e) { if (Session["KTDangNhap"] != "GPM") { Response.Redirect("DangNhap.aspx"); } else { if (!IsPostBack) { string IDNhanVien = "1"; // Session["IDThuNgan"].ToString(); if (Session["IDThuNgan"] != null) { IDNhanVien = Session["IDThuNgan"].ToString(); } if (Session["IDNhanVien"] != null) { IDNhanVien = Session["IDNhanVien"].ToString(); } dtKho dt = new dtKho(); DataTable da = dt.LayDanhSachKho(); //da.Rows.Add(-1, "", "Tất cả cửa hàng", null, null, null, null, null, null, null, null, null); cmbKho.DataSource = da; cmbKho.TextField = "TenCuaHang"; cmbKho.ValueField = "ID"; cmbKho.DataBind(); cmbKho.SelectedIndex = 0; } } }
protected void gridThongTinCuaHangKho_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { string ID = e.Keys[0].ToString(); string MaKho = e.NewValues["MaKho"].ToString(); string TenCuaHang = e.NewValues["TenCuaHang"].ToString(); string SoSerial = e.NewValues["SoSerial"] == null ? "" : e.NewValues["SoSerial"].ToString(); string DiaChi = e.NewValues["DiaChi"] == null ? "" : e.NewValues["DiaChi"].ToString(); string DienThoai = e.NewValues["DienThoai"] == null ? "" : e.NewValues["DienThoai"].ToString(); DateTime NgayMo = DateTime.Parse(e.NewValues["NgayMo"].ToString()); string IDVung = e.NewValues["IDVung"].ToString(); string TrangThaiBanHang = e.NewValues["TrangThaiBanHang"] == null ? "0" : e.NewValues["TrangThaiBanHang"].ToString(); string GiaApDung = e.NewValues["GiaApDung"].ToString(); if (dtSetting.IsNumber(MaKho) == true) { dtKho data = new dtKho(); data.CapNhatKho(ID, MaKho, TenCuaHang, SoSerial, DiaChi, DienThoai, NgayMo, IDVung, TrangThaiBanHang, GiaApDung); e.Cancel = true; gridThongTinCuaHangKho.CancelEdit(); LoadGrid(); dtLichSuTruyCap.ThemLichSu(Session["IDNhanVien"].ToString(), Session["IDNhom"].ToString(), "Thông tin kho", Session["IDKho"].ToString(), "Hệ Thống", "Cập nhật"); } else { throw new Exception("Lỗi: Mã kho phải là số"); } }
private void LoadGrid() { dtKho data = new dtKho(); gridThongTinCuaHangKho.DataSource = data.LayDanhSachKho(); gridThongTinCuaHangKho.DataBind(); }
protected void gridThongTinCuaHangKho_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { int ID = Int32.Parse(e.Keys[0].ToString()); dtKho data = new dtKho(); data.Xoakho(ID); e.Cancel = true; gridThongTinCuaHangKho.CancelEdit(); LoadGrid(); dtLichSuTruyCap.ThemLichSu(Session["IDNhanVien"].ToString(), Session["IDNhom"].ToString(), "Thông tin kho:" + ID, Session["IDKho"].ToString(), "Hệ Thống", "Xóa"); }
protected void gridThongTinCuaHangKho_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { string MaKho = e.NewValues["MaKho"].ToString(); string TenCuaHang = e.NewValues["TenCuaHang"].ToString(); string SoSerial = e.NewValues["SoSerial"] == null ? "" : e.NewValues["SoSerial"].ToString(); string DiaChi = e.NewValues["DiaChi"] == null ? "" : e.NewValues["DiaChi"].ToString(); string DienThoai = e.NewValues["DienThoai"] == null ? "" : e.NewValues["DienThoai"].ToString(); DateTime NgayMo = DateTime.Parse(e.NewValues["NgayMo"].ToString()); string IDVung = e.NewValues["IDVung"].ToString(); string TrangThaiBanHang = e.NewValues["TrangThaiBanHang"] == null ? "0" : e.NewValues["TrangThaiBanHang"].ToString(); string GiaApDung = e.NewValues["GiaApDung"].ToString(); if (dtSetting.IsNumber(MaKho) == true) { dtKho data = new dtKho(); object ID = data.ThemKho(MaKho, TenCuaHang, SoSerial, DiaChi, DienThoai, NgayMo, IDVung, TrangThaiBanHang, GiaApDung); if (ID != null) { data = new dtKho(); DataTable dt = data.DanhSachHangHoaTonKhoTong(); foreach (DataRow dr in dt.Rows) { string IDHangHoa = dr["IDHangHoa"].ToString(); double GiaBan = double.Parse(dr["GiaBan"].ToString()); double GiaBaN2 = double.Parse(dr["GiaBaN2"].ToString()); double GiaBan2 = double.Parse(dr["GiaBan2"].ToString()); double GiaBan3 = double.Parse(dr["GiaBan3"].ToString()); double GiaBan4 = double.Parse(dr["GiaBan4"].ToString()); double GiaBan5 = double.Parse(dr["GiaBan5"].ToString()); data = new dtKho(); data.ThemHangHoaTonKho(IDHangHoa, GiaBan, GiaBaN2, GiaBan2, GiaBan3, GiaBan4, GiaBan5, ID.ToString()); } } e.Cancel = true; gridThongTinCuaHangKho.CancelEdit(); LoadGrid(); dtLichSuTruyCap.ThemLichSu(Session["IDNhanVien"].ToString(), Session["IDNhom"].ToString(), "Thông tin kho", Session["IDKho"].ToString(), "Hệ Thống", "Thêm"); } else { throw new Exception("Lỗi: Mã kho phải là số"); } }
protected void Page_Load(object sender, EventArgs e) { string NgayBD = Request.QueryString["ngayBD"]; string NgayKT = Request.QueryString["NgayKT"]; string MaHang = Request.QueryString["MaHang"]; string IDKhoNhap = Request.QueryString["IDKhoNhap"]; string strKhoNhap = "Tất cả các kho"; dtKho dt1 = new dtKho(); if (Int32.Parse(IDKhoNhap) != -1) { strKhoNhap = dt1.LayTenKho_ID(IDKhoNhap); } string strNgay = DateTime.Parse(NgayBD).ToString("dd-MM-yyyy") + " - " + DateTime.Parse(NgayKT).ToString("dd-MM-yyyy"); rpTheKho rp = new rpTheKho(); rp.Parameters["strNgay"].Value = strNgay; rp.Parameters["strNgay"].Visible = false; rp.Parameters["strKho"].Value = strKhoNhap; rp.Parameters["strKho"].Visible = false; rp.Parameters["NgayBD"].Value = NgayBD; rp.Parameters["NgayBD"].Visible = false; rp.Parameters["NgayKT"].Value = NgayKT; rp.Parameters["NgayKT"].Visible = false; rp.Parameters["MaHang"].Value = MaHang; rp.Parameters["MaHang"].Visible = false; rp.Parameters["IDKho"].Value = IDKhoNhap; rp.Parameters["IDKho"].Visible = false; viewerReport.Report = rp; }