public static string UpdateKho(string id, string maKho, string tenKho, string diaChi, string sodienthoai, string nguoiphutrach, string kichHoat, string ghiChu, string thuocTongKho, string loaiKho) { try { int thuoctongkho_temp = 0; Guid currentUserID = Guid.NewGuid(); string currentUser = ""; #region Get current User MembershipUser membershipUser = Membership.GetUser(HttpContext.Current.User.Identity.Name); if (membershipUser != null) { currentUser = membershipUser.UserName; currentUserID = (Guid)membershipUser.ProviderUserKey; } #endregion get current User xRPDataContext dataContext = new xRPDataContext(); Qlvt_KhoVatTu qlvt = new Qlvt_KhoVatTu(); int? idd = int.Parse(id) == 0 || int.Parse(id) == -1 ? (int?)null : int.Parse(id); if (int.Parse(id) == -1) { dataContext.Sp_Qlvt_KhoVatTu_Add_Edit_Deli("ADD", 0, maKho, tenKho, thuoctongkho_temp, bool.Parse(loaiKho), diaChi, sodienthoai, nguoiphutrach, ghiChu, int.Parse(kichHoat), currentUserID, currentUserID, ref idd, Util.GetIP(), Util.GetPCName()); } if (int.Parse(id) > 0) { dataContext.Sp_Qlvt_KhoVatTu_Add_Edit_Deli("EDIT", int.Parse(id), maKho, tenKho, thuoctongkho_temp, bool.Parse(loaiKho), diaChi, sodienthoai, nguoiphutrach, ghiChu, int.Parse(kichHoat), currentUserID, currentUserID, ref idd, Util.GetIP(), Util.GetPCName()); } } catch (Exception) { return("ERROR"); } return("SUCCESS"); }
protected void Page_Load(object sender, EventArgs e) { xRPDataContext getalldmkho2 = new xRPDataContext(); //List<Qlvt_KhoVatTu> lst = (from ds in getalldmkho2.Qlvt_KhoVatTu_GetAll() // select new Qlvt_KhoVatTu // { // ID = ds.ID, // MaHieuKho = ds.MaHieuKho, // TenKhoVatTu = ds.TenKhoVatTu // }).ToList(); //dropThuocTongKho.DataSource = lst; //dropThuocTongKho.DataTextField = "TenKhoVatTu"; //dropThuocTongKho.DataValueField = "ID"; //dropThuocTongKho.DataBind(); //dropThuocTongKho.Items.Insert(0, new ListItem("Tất cả", "0")); if (Attributes["param"] != null) { string URL = Attributes["param"]; ID_Kho = Util.GetParam(URL, "id"); trang = Util.GetParam(URL, "trang"); if (ID_Kho != "" && ID_Kho != "-1") { int id = int.Parse(ID_Kho); Qlvt_KhoVatTu qlkho = (from c2 in getalldmkho2.Qlvt_KhoVatTus where c2.ID == id select c2).FirstOrDefault(); txtMaKho.Text = qlkho.MaHieuKho; txtTenKho.Text = qlkho.TenKhoVatTu; dropThuocTongKho.SelectedValue = qlkho.MaKhoCapTren.Value.ToString(); txtDiaChi.Text = qlkho.DiaChi; txtSoDienThoai.Text = qlkho.SoDienThoai; txtNguoiPhuTrach.Text = qlkho.NguoiPhuTrach; if (qlkho.KichHoat.Value == true) { ckKichHoat.Checked = true; } else { ckKichHoat.Checked = false; } if (qlkho.LoaiKho.Value == true) { rdlLoaiKho.SelectedValue = "1"; } else { rdlLoaiKho.SelectedValue = "0"; } txtGhiChu.Text = qlkho.GhiChu; } } }
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>"; } } } }