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