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