protected void BindData(int id) { var donhang = dataContext.Sp_Qldh_DonHang_Select(1, id, null, null, null, null, null, null, null).FirstOrDefault(); if (donhang != null) { //Config value var sysconfig = dataContext.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; lblMaDonHang.Text = donhang.MaHieuDonHang; lblKhachHang.Text = donhang.TENKHACHHANG; lblNgayDat.Text = donhang.NgayDatHang != null?donhang.NgayDatHang.Value.ToString("dd/MM/yyyy") : ""; lblDiaChi.Text = donhang.DiaChi; lblDienThoai.Text = donhang.DienThoaiLienHe; lblNgayGiaohang.Text = donhang.NgayGiaoHang != null?donhang.NgayGiaoHang.Value.ToString("dd/MM/yyyy") : ""; lblGhiChu.Text = donhang.GhiChu; lblPhuongThucThanhToan.Text = "CK"; objectDataSource1.DataSource = dataContext.sp_Baocao_DonHang(id); } }
private void BindGridDonHang() { var listDonh = dts.Sp_Qldh_DonHang_Select(0, null, null, null, null, null, null, "", null).OrderByDescending(p => p.NgayTao).Take(10).ToList(); colPageDonHang.DataSource = listDonh; colPageDonHang.BindToControl = rptDonHang; rptDonHang.DataSource = colPageDonHang.DataSourcePaged; }
private void BindGrid() { if (txtTimKiem.Text.Trim() == "") { DateTime dt1 = DateTime.MinValue, dt2 = DateTime.Now; if (!DateTime.TryParseExact(datepicker.Value, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt1)) { datepicker.Value = DateTime.Now.AddMonths(-1).ToString("dd/MM/yyyy"); } if (!DateTime.TryParseExact(datepicker1.Value, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt2)) { dt2 = DateTime.Now; } var x = dts.Sp_Qldh_DonHang_Select(0, (int?)null, null, (int?)null, 0, dt1, dt2, null, " NgayDatHang DESC").ToList(); //List<Sp_Qldh_DonHang_SelectResult> listDonHang = new List<Sp_Qldh_DonHang_SelectResult>(); //var x = dts.Sp_Qldh_DonHang_Select(0, (int?)null, (int?)null, (int?)null, 0).OrderByDescending(t=>t.NgayTao).ToList(); CollectionPager1.DataSource = x; CollectionPager1.BindToControl = rptDonHang; rptDonHang.DataSource = CollectionPager1.DataSourcePaged; } else { DateTime dt1 = DateTime.MinValue, dt2 = DateTime.Now; if (!DateTime.TryParseExact(datepicker.Value, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt1)) { datepicker.Value = DateTime.Now.AddMonths(-1).ToString("dd/MM/yyyy"); } if (!DateTime.TryParseExact(datepicker1.Value, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt2)) { dt2 = DateTime.Now; } var x = dts.Sp_Qldh_DonHang_Select(-1, (int?)null, null, (int?)null, 0, dt1, dt2, txtTimKiem.Text, " NgayDatHang DESC").ToList(); CollectionPager1.DataSource = x; CollectionPager1.BindToControl = rptDonHang; rptDonHang.DataSource = CollectionPager1.DataSourcePaged; } }