protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; var d = DateTime.Now; var cuoiThangTruoc = new DateTime(d.Year, d.Month, 1).AddDays(-1); var dauThangSau = d.AddMonths(6); using (var con = DAL.con()) { if (string.IsNullOrEmpty(id)) { View.Item = new HangHoa();; } else { Item = HangHoaDal.SelectById(new Guid(id)); View.Item = Item; } var list = SuKienDal.SelectPhieuDichVuForVay(con, cuoiThangTruoc, dauThangSau, id); View.List = list; var phieuBaoHongList = PhieuBaoHongDal.SelectTopByHhId(con, 10, id); var choThueVayList = ChoThueVayDal.SelectTopByHhId(con, 10, id); var phieuGiatVayList = PhieuGiatVayDal.SelectTopByHhId(con, 10, id); var phieuXuatNhapSanPhamList = PhieuXuatNhapSanPhamDal.SelectTopByHhId(con, 10, id); View.PhieuBaoHongList = phieuBaoHongList; View.ChoThueVayList = choThueVayList; View.PhieuGiatVayList = phieuGiatVayList; View.PhieuXuatNhapSanPhamList = phieuXuatNhapSanPhamList; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; var pdvId = Request["PDV_ID"]; var list = new List <PhieuXuatNhapSanPhamChiTiet>(); using (var con = DAL.con()) { if (string.IsNullOrEmpty(id)) { Item = PhieuXuatNhapSanPhamDal.SelectDraff(con); Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1; Item.ID = Guid.NewGuid(); if (!string.IsNullOrEmpty(pdvId)) { var pdv = PhieuDichVuDal.SelectById(con, new Guid(pdvId)); Item.PDV_ID = pdv.ID; Item.PDV_Ma = pdv.Ma; } } else { Item = PhieuXuatNhapSanPhamDal.SelectById(con, new Guid(id)); list = PhieuXuatNhapSanPhamChiTietDal.SelectByPxnSpId(con, id); } Add.List = list; Add.Item = Item;; } }
protected void Page_Load(object sender, EventArgs e) { var id = Request["ID"]; using (var con = DAL.con()) { Item = PhieuXuatNhapSanPhamDal.SelectById(con, new Guid(id)); var phieuDichVuItem = PhieuDichVuDal.SelectById(con, Item.PDV_ID); var khachHangItem = KhachHangDal.SelectById(phieuDichVuItem.KH_ID, con); Print.Item = Item; Print.Khach = khachHangItem; var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description; Print.LogoStr = logoStr; } }
protected void Page_Load(object sender, EventArgs e) { var q = Request["q"]; var size = Request["size"]; if (string.IsNullOrEmpty(size)) { size = "10"; } var trangThai = Request["TrangThai"]; var nhanVien = Request["NhanVien"]; var url = string.Format("?q={0}&size={1}&TrangThai={2}&NhanVien={3}&", q, size, trangThai, nhanVien) + "{1}={0}"; using (var con = DAL.con()) { var pg = PhieuXuatNhapSanPhamDal.pagerNormal(con, url, false, "PXNSP_Ma desc", q, Convert.ToInt32(size), trangThai, nhanVien); List1.List = pg.List; paging = pg.Paging; } }
protected void Page_Load(object sender, EventArgs e) { var d = DateTime.Now; var cuoiThangTruoc = new DateTime(d.Year, d.Month, 1).AddDays(-1); var dauThangSau = d.AddMonths(6); const int size = 10; using (var con = DAL.con()) { var pgChoThueVay = ChoThueVayDal.pagerNormal(con, null, false, "CTV_Ma desc", null, size, null, null); var pgGiatLa = PhieuGiatVayDal.pagerNormal(con, null, false, "PGV_Ma desc", null, size, null, null, null); var pgXuatNhap = PhieuXuatNhapSanPhamDal.pagerNormal(con, null, false, "PXNSP_Ma desc", null, size, null, null); ListChoThueVay.List = pgChoThueVay.List; ListGiatLa.List = pgGiatLa.List; ListXuatNhap.List = pgXuatNhap.List; } }
protected void Page_Load(object sender, EventArgs e) { var logged = Security.IsAuthenticated(); var Id = Request["Id"]; var IdNull = string.IsNullOrEmpty(Id); var Ma = Request["Ma"]; var PDV_ID = Request["PDV_ID"]; var PXNSP_ID = Request["PXNSP_ID"]; var HH_ID = Request["HH_ID"]; var PXNSPCT_ID = Request["PXNSPCT_ID"]; var NgayLap = Request["NgayLap"]; var TrangThai = Request["TrangThai"]; var NgayXuat = Request["NgayXuat"]; var NgayNhapDuKien = Request["NgayNhapDuKien"]; var NguoiXuat = Request["NguoiXuat"]; var NgayNhap = Request["NgayNhap"]; var NguoiNhap = Request["NguoiNhap"]; var ThuKho = Request["ThuKho"]; var q = Request["q"]; var refUrl = Request["refUrl"]; if (!string.IsNullOrEmpty(refUrl)) { refUrl = Server.UrlDecode(refUrl); } switch (subAct) { case "save": #region Thêm khách hàng if (logged) { var item = PhieuXuatNhapSanPhamDal.SelectById(DAL.con(), new Guid(Id)); IdNull = item.ID == Guid.Empty; if (!string.IsNullOrEmpty(NguoiXuat)) { item.NguoiXuat = Convert.ToInt32(NguoiXuat); } if (!string.IsNullOrEmpty(NguoiNhap)) { item.NguoiNhap = Convert.ToInt32(NguoiNhap); } if (!string.IsNullOrEmpty(ThuKho)) { item.ThuKho = Convert.ToInt32(ThuKho); } if (!string.IsNullOrEmpty(Ma)) { item.Ma = Convert.ToInt32(Ma); } if (!string.IsNullOrEmpty(TrangThai)) { item.TrangThai = Convert.ToInt32(TrangThai); } if (!string.IsNullOrEmpty(PDV_ID)) { item.PDV_ID = new Guid(PDV_ID); } if (!string.IsNullOrEmpty(NgayLap)) { item.NgayLap = Convert.ToDateTime(NgayLap, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(NgayXuat)) { item.NgayXuat = Convert.ToDateTime(NgayXuat, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(NgayNhapDuKien)) { item.NgayNhapDuKien = Convert.ToDateTime(NgayNhapDuKien, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(NgayNhap)) { item.NgayNhap = Convert.ToDateTime(NgayNhap, new CultureInfo("vi-vn")); } item.NgayCapNhat = DateTime.Now; if (IdNull) { item.ID = new Guid(Id); item.NgayTao = DateTime.Now; item.NguoiTao = Security.UserId; } item.NgayCapNhat = DateTime.Now; if (IdNull) { item = PhieuXuatNhapSanPhamDal.Insert(item); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} thêm mới phiếu xuất sản phẩm/ phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 1 , Ten = "Thêm" }); #endregion } else { item = PhieuXuatNhapSanPhamDal.Update(item); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} sửa phiếu xuất sản phẩm/ phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 2 , Ten = "Sửa" }); #endregion } TimKiemDal.Add(item, item.ID); rendertext(item.ID.ToString()); } break; #endregion case "saveCt": #region save Goi dich vu chi tiet if (!string.IsNullOrEmpty(PXNSP_ID) && !string.IsNullOrEmpty(HH_ID)) { var hh = HangHoaDal.SelectById(new Guid(HH_ID)); var item = new PhieuXuatNhapSanPhamChiTiet(); item.ID = Guid.NewGuid(); item.HH_ID = hh.ID; item.PXNSP_ID = new Guid(PXNSP_ID); item.SoLuong = 1; item.NgayCapNhat = DateTime.Now; item.NgayTao = DateTime.Now; item.NguoiTao = Security.UserId; item = PhieuXuatNhapSanPhamChiTietDal.Insert(item); ItemEdit.Item = item; ItemEdit.Visible = true; } break; #endregion case "updateCt": #region update Goi dich vu chi tiet if (!string.IsNullOrEmpty(PXNSPCT_ID)) { var SoLuong = Request["SoLuong"]; var DaXuat = Request["DaXuat"]; var DaNhap = Request["DaNhap"]; DaXuat = !string.IsNullOrEmpty(DaXuat) ? "true" : "false"; DaNhap = !string.IsNullOrEmpty(DaNhap) ? "true" : "false"; var item = PhieuXuatNhapSanPhamChiTietDal.SelectById(new Guid(PXNSPCT_ID)); if (!string.IsNullOrEmpty(SoLuong)) { item.SoLuong = Convert.ToInt32(SoLuong); } item.DaXuat = Convert.ToBoolean(DaXuat); item.DaNhap = Convert.ToBoolean(DaNhap); item.NgayCapNhat = DateTime.Now; item = PhieuXuatNhapSanPhamChiTietDal.Update(item); rendertext(item.ID.ToString()); } break; #endregion case "remove": #region Xóa phiếu xuất nhập/ phiếu dịch vụ if (logged && !IdNull) { var item = PhieuXuatNhapSanPhamDal.SelectById(DAL.con(), new Guid(Id)); if (item.NguoiTao == Security.UserId) { PhieuXuatNhapSanPhamDal.DeleteById(new Guid(Id)); TimKiemDal.DeleteByPRowId(DAL.con(), item.ID); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} xóa phiếu xuất sản phẩm/ phiếu dịch vụ: {0}", item.MaStr, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.MaStr , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 3 , Ten = "Xóa" }); #endregion rendertext("1"); } else { rendertext("0"); } } break; #endregion case "removeCt": #region Xóa Goi dich vu chi tiet if (logged && !string.IsNullOrEmpty(Id)) { var item = PhieuXuatNhapSanPhamChiTietDal.SelectById(new Guid(Id)); if (item.NguoiTao == Security.UserId) { PhieuXuatNhapSanPhamChiTietDal.DeleteById(new Guid(Id)); TimKiemDal.DeleteByPRowId(DAL.con(), item.ID); #region log LogDal.log(item, new Log() { Checked = false , Info = string.Format("{1} xóa sản phẩm xuất nhập chi tiết {0}", item.HH_Ten, Security.Username) , NgayTao = DateTime.Now , Username = Security.Username , PRowId = item.ID , PTen = item.HH_Ten , RequestIp = Request.UserHostAddress , RawUrl = refUrl , LLOG_ID = 3 , Ten = "Xóa" }); #endregion rendertext("1"); } else { rendertext("0"); } } break; #endregion case "search": #region search var list = PhieuXuatNhapSanPhamDal.SelectAll(); rendertext(JavaScriptConvert.SerializeObject(list), "text/javascript"); break; #endregion default: break; } }