protected void BindData(int id) { xRPDataContext dts = new xRPDataContext(); var sysconfig = dts.Sys_ThongSoHeThongs; string tenCongTy = (from t in sysconfig where t.ThongSo == "TenCongTy" select t.GiaTri).FirstOrDefault(); string diaChiCongTy = (from t in sysconfig where t.ThongSo == "DiaChiCongTy" select t.GiaTri).FirstOrDefault(); string dienThoaiCongTy = (from t in sysconfig where t.ThongSo == "DienThoaiLienHe" select t.GiaTri).FirstOrDefault(); lblTenCongTy.Text = tenCongTy; lblDiaChiCongTy.Text = "Địa chỉ: " + diaChiCongTy; lblDienThoaiCongTy.Text = "Số ĐT: " + dienThoaiCongTy; string ngayhomnay = new Sys_ThongSoHeThongRepository().GetThongSoHeThong("DiaPhuong", "Hà Nội") + ", ngày" + " " + DateTime.Now.Day.ToString() + " " + "tháng" + " " + DateTime.Now.Month.ToString() + " " + "năm" + " " + DateTime.Now.Year.ToString(); lblNgayIn.Text = ngayhomnay; this.currentPhieuNhap = dts.Qlvt_PhieuNhaps.Where(x => x.ID == id).FirstOrDefault(); this.currentKhoVatTu = dts.Qlvt_KhoVatTus.Where(x => x.ID == currentPhieuNhap.MaKhoVatTu).FirstOrDefault(); lblMaPhieuNhap.Text = "Mã phiếu nhập kho: " + currentPhieuNhap.MaHieuPhieuNhap; lblNhapTaiKho.Text = "Kho nhập: " + currentKhoVatTu.TenKhoVatTu; lblNgayNhapKho.Text = "Ngày nhập kho: " + currentPhieuNhap.NgayNhap.Value.ToString("dd/MM/yyyy"); lblNoiDung.Text = "Nội dung:" + currentPhieuNhap.GhiChu; lblNhaCungCap.Text = "Nhà cung cấp: " + currentPhieuNhap.Qlvt_NhaCungCap.TenNhaCungCap; objectDataSource1.DataSource = dts.sp_Baocao_PhieuNhapVatTu(id); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { ID = Request.QueryString["id"].ToString(); string type = Request.QueryString["type"]; if (string.IsNullOrWhiteSpace(type) || type != "2") { type = "1"; } xRPDataContext dts = new xRPDataContext(); DataTable dt = GetData(int.Parse(Request.QueryString["id"].ToString())); var data = dts.sp_Baocao_PhieuNhapVatTu(int.Parse(ID)); ReportDataSource rpt = new ReportDataSource("dtsPhieuNhap", data); rpViewer.LocalReport.DataSources.Clear(); rpViewer.LocalReport.DataSources.Add(rpt); rpViewer.LocalReport.ReportPath = type == "1" ? "Report/QuanLyVatTu/NhapVatTu/ReportNhapKho.rdlc" : "Report/QuanLyVatTu/NhapVatTu/ReportNhapKhoNCC.rdlc"; rpViewer.LocalReport.Refresh(); this.currentPhieuNhap = (from t in dts.Qlvt_PhieuNhaps where t.ID == int.Parse(Request.QueryString["id"].ToString()) select t).FirstOrDefault(); this.currentKhoVatTu = (from ds in dts.Qlvt_KhoVatTus where ds.ID == currentPhieuNhap.MaKhoVatTu select ds).FirstOrDefault(); string tencongty = "", diachi = "", sodienthoai = ""; var listthongsoht = (from ds in dts.Sys_ThongSoHeThongs select ds).ToList(); foreach (var item in listthongsoht) { if (item.ThongSo == "TenCongTy") { tencongty = item.GiaTri; } if (item.ThongSo == "DiaChiCongTy") { diachi = item.GiaTri; } if (item.ThongSo == "DienThoaiLienHe") { sodienthoai = item.GiaTri; } } //Lấy thông tin nhà cung cấp var nhacungcap = (from ds in dts.Qlvt_NhaCungCaps where ds.ID == currentPhieuNhap.MaNhaCungCap select ds).FirstOrDefault(); ReportParameter[] p = new ReportParameter[12]; p[0] = new ReportParameter("maphieunhap", currentPhieuNhap.MaHieuPhieuNhap); p[1] = new ReportParameter("nhaptaikho", currentKhoVatTu.TenKhoVatTu); p[2] = new ReportParameter("tencongty", tencongty); p[3] = new ReportParameter("diachi", diachi.ToUpper()); p[4] = new ReportParameter("sodienthoai", sodienthoai); p[5] = new ReportParameter("ngayin", new Sys_ThongSoHeThongRepository().GetThongSoHeThong("DiaPhuong", "Hà Nội") + ", ngày" + " " + DateTime.Now.Day.ToString() + " " + "tháng" + " " + DateTime.Now.Month.ToString() + " " + "năm" + " " + DateTime.Now.Year.ToString()); double x = 0, y = 0, z = 0, k = 0; for (int i = 0; i < dt.Rows.Count; i++) { if (!string.IsNullOrEmpty(dt.Rows[i][3].ToString())) { x = x + double.Parse(dt.Rows[i][3].ToString()); } if (!string.IsNullOrEmpty(dt.Rows[i][5].ToString())) { y = y + double.Parse(dt.Rows[i][5].ToString()); } if (!string.IsNullOrEmpty(dt.Rows[i][4].ToString())) { z = z + double.Parse(dt.Rows[i][4].ToString()); } if (!string.IsNullOrEmpty(dt.Rows[i][7].ToString())) { k = k + double.Parse(dt.Rows[i][7].ToString()); } } p[7] = new ReportParameter("tongdltt", x.ToString()); p[8] = new ReportParameter("tongtruloi", y.ToString()); p[9] = new ReportParameter("tongtruthuakho", z.ToString()); p[10] = new ReportParameter("tongthucnhap", k.ToString()); p[11] = new ReportParameter("tien", Util.ReadMoney(k.ToString())); p[6] = new ReportParameter("ngaynhapkho", currentPhieuNhap.NgayNhap.ToString()); rpViewer.LocalReport.SetParameters(p); if (currentPhieuNhap.TinhTrang != 2) { ltAccept.Text = "<li class=\"menu-item icon-only\"><a id=\"btnAccept\" class=\"menu-bar-item-button icon accept-icon\" href=\"javascript:duyetPhieuNhap('" + currentPhieuNhap.ID + "');\"></a></li>"; } } } }
private void LoadData(int id) { try { xRPDataContext dts = new xRPDataContext(); this.currentPhieuNhap = (from t in dts.Qlvt_PhieuNhaps where t.ID == id select t).FirstOrDefault(); if (this.currentPhieuNhap != null) { if (this.currentPhieuNhap.Xoa.HasValue && this.currentPhieuNhap.Xoa.Value) { Response.Redirect(Util.SERVER_NAME + "/Business/QuanLyVatTu/Default.aspx?page=pn", false); } //btnCancel.Visible = this.currentPhieuNhap.Xoa.HasValue && this.currentPhieuNhap.Xoa.Value; pnChiTietVatTu.Visible = true; this.txtMaPhieu.Value = this.currentPhieuNhap.MaHieuPhieuNhap; this.txtNgayNhap.Value = string.Format("{0:dd/MM/yyyy}", this.currentPhieuNhap.NgayNhap); if (this.currentPhieuNhap.MaNhaCungCap.HasValue) { var ncc = dts.Qlvt_NhaCungCaps.Where(t => t.ID == this.currentPhieuNhap.MaNhaCungCap.Value).FirstOrDefault(); if (ncc != null) { this.txtTenNhaCungCap.Value = ncc.MaHieuNhaCungCap.Trim() + " - " + ncc.TenNhaCungCap; } } if (this.currentPhieuNhap.MaKhoVatTu.HasValue) { var kc = dts.Qlvt_KhoVatTus.Where(t => t.ID == this.currentPhieuNhap.MaKhoVatTu.Value).FirstOrDefault(); if (kc != null) { this.txtKhoChua.Value = kc.TenKhoVatTu; } } if (this.currentPhieuNhap.MaTinhChatNhapXuat.HasValue) { var kc = dts.Qlvt_TinhChatNhapXuats.Where(t => t.ID == this.currentPhieuNhap.MaTinhChatNhapXuat.Value).FirstOrDefault(); if (kc != null) { this.txtTinhChat.Value = kc.TenTinhChatNhapXuat; } } this.txtGhiChu.Text = this.currentPhieuNhap.GhiChu; var x = (from t in dts.Qlvt_VatTuNhaps where t.MaPhieuNhap == this.currentPhieuNhap.ID select t).ToList(); var listChiTiet = new System.Collections.ArrayList(); for (int i = 0; i < x.Count; i++) { var vt = x[i]; var vttype = dts.Qlvt_VatTus.Where(t => t.ID == vt.MaVatTu).FirstOrDefault(); if (vttype != null) { listChiTiet.Add(new { ID = vt.ID, maVatTu = vttype.MaHieuVatTu, tenVatTu = vttype.TenVatTu, donViTinh = vt.IDDonViTinh, tenDonViTinh = dts.Qlvt_DonViTinhs.Where(t => t.ID == vt.IDDonViTinh).FirstOrDefault().DonViTinh, giaNhap = vt.DonGia.HasValue ? vt.DonGia.Value : 0, soLuongThucNhap = vt.SoLuongThucNhap.HasValue ? vt.SoLuongThucNhap.Value : 0, soLuongDauCuon = vt.SoLuongDauCuon.HasValue ? vt.SoLuongDauCuon.Value : 0, soLuongLamPhieuNhap = vt.SoLuongLamPhieuNhap.HasValue ? vt.SoLuongLamPhieuNhap.Value : 0, dinhLuongTieuChuan = vttype.DinhLuong, dinhLuongThucTe = vt.DinhLuongThucTe.HasValue ? vt.DinhLuongThucTe.Value : 0, kichThuocTieuChuan = vttype.KichThuocVatTu, kichThuocThucTe = vt.KichThuocThucTe.HasValue ? vt.KichThuocThucTe.Value : 0, chenhLechDinhLuong = vt.ChenhLechDinhLuong.HasValue ? vt.ChenhLechDinhLuong.Value : 0, dinhLuongTinhTru = vt.DinhLuongTinhTru.HasValue ? vt.DinhLuongTinhTru.Value : 0, truKichThuoc = vt.TruThuaKichThuoc.HasValue ? vt.TruThuaKichThuoc : 0, khoiLuongTru = vt.KhoiLuongTru.HasValue ? vt.KhoiLuongTru.Value : 0, truLoi = vt.TruLoi.HasValue ? vt.TruLoi.Value : 0, soLuongChenhLechKhongTinh = vt.SoLuongChenhLechKhongTinh.HasValue ? vt.SoLuongChenhLechKhongTinh : 0, thanhTien = vt.ThanhTien.HasValue ? vt.ThanhTien : 0, ghiChu = vt.GhiChu }); } } DataChiTiet = new JavaScriptSerializer().Serialize(listChiTiet); DataPhieuNhap = new JavaScriptSerializer().Serialize(new { itemID = this.currentPhieuNhap.ID, ID = this.currentPhieuNhap.ID, MaHieuPhieuNhap = this.currentPhieuNhap.MaHieuPhieuNhap, NgayNhap = this.currentPhieuNhap.NgayNhap.Value.ToString("dd/MM/yyyy"), MaNhaCungCap = this.currentPhieuNhap.MaNhaCungCap.Value, MaKhoVatTu = this.currentPhieuNhap.MaKhoVatTu.Value, MaTinhChatNhapXuat = this.currentPhieuNhap.MaTinhChatNhapXuat.Value, KieuVatTu = this.currentPhieuNhap.KieuVatTu.Value, TinhTrang = this.currentPhieuNhap.TinhTrang.Value, GhiChu = this.currentPhieuNhap.GhiChu }); } else { this.txtNgayNhap.Value = string.Format("{0:dd/MM/yyyy}", DateTime.Now); } } catch (Exception ex) { Response.Write(ex.StackTrace); Response.Write(ex.Message); } }
private void LoadData(int id) { try { xRPDataContext dts = new xRPDataContext(); this.currentPhieuNhap = (from t in dts.Qlvt_PhieuNhaps where t.ID == id select t).FirstOrDefault(); if (this.currentPhieuNhap != null) { ltTitle.Text = "Chỉnh sửa phiếu nhập thành phẩm: " + this.currentPhieuNhap.MaHieuPhieuNhap; if (this.currentPhieuNhap.Xoa.HasValue && this.currentPhieuNhap.Xoa.Value) { Response.Redirect(Util.SERVER_NAME + "/Business/QuanLyVatTu/Default.aspx?page=pn", false); } //btnCancel.Visible = this.currentPhieuNhap.Xoa.HasValue && this.currentPhieuNhap.Xoa.Value; pnChiTietVatTu.Visible = true; this.txtMaPhieu.Value = this.currentPhieuNhap.MaHieuPhieuNhap; this.txtNgayNhap.Value = string.Format("{0:dd/MM/yyyy}", this.currentPhieuNhap.NgayNhap); this.slcTenNhaCungCap.Value = this.currentPhieuNhap.MaNhaCungCap.HasValue ? this.currentPhieuNhap.MaNhaCungCap.Value.ToString() : ""; if (this.currentPhieuNhap.MaNhaCungCap.HasValue) { this.slcTenNhaCungCap.Value = this.currentPhieuNhap.MaNhaCungCap.Value.ToString(); var ncc = dts.Qlvt_NhaCungCaps.Where(t => t.ID == this.currentPhieuNhap.MaNhaCungCap.Value).FirstOrDefault(); if (ncc != null) { this.txtTenNhaCungCap.Value = ncc.MaHieuNhaCungCap.Trim() + " - " + ncc.TenNhaCungCap; } } if (this.currentPhieuNhap.MaKhoVatTu.HasValue) { this.slcKhoChua.Value = this.currentPhieuNhap.MaKhoVatTu.Value.ToString(); var kc = dts.Qlvt_KhoVatTus.Where(t => t.ID == this.currentPhieuNhap.MaKhoVatTu.Value).FirstOrDefault(); if (kc != null) { this.txtKhoChua.Value = kc.MaHieuKho.Trim() + " - " + kc.TenKhoVatTu; } } if (this.currentPhieuNhap.MaTinhChatNhapXuat.HasValue) { this.ddlTinhChat.SelectedValue = this.currentPhieuNhap.MaTinhChatNhapXuat.Value.ToString(); if (this.currentPhieuNhap.MaTinhChatNhapXuat.Value == 29 && this.currentPhieuNhap.MaPhieuXuat.HasValue) { this.slcPhieuXuat.Value = this.currentPhieuNhap.MaPhieuXuat.Value.ToString(); var phieuxuat = dts.Qlvt_PhieuXuats.FirstOrDefault(t => t.ID == this.currentPhieuNhap.MaPhieuXuat.Value); if (phieuxuat != null) { this.txtTheoPhieuXuat.Text = phieuxuat.MaHieuPhieuXuat; } } } this.txtGhiChu.Text = this.currentPhieuNhap.GhiChu; var x = (from t in dts.Qlvt_VatTuNhaps where t.MaPhieuNhap == this.currentPhieuNhap.ID select t).ToList(); var listChiTiet = new System.Collections.ArrayList(); this.CurrentTinhTrang = this.currentPhieuNhap.TinhTrang.HasValue ? this.currentPhieuNhap.TinhTrang.Value : 0; } else { this.txtNgayNhap.Value = string.Format("{0:dd/MM/yyyy}", DateTime.Now); } } catch (Exception ex) { Response.Write(ex.StackTrace); Response.Write(ex.Message); } }