private void BindGridNhapVatTu() { var listNhapVatTu = dts.Sp_Qlvt_PhieuNhap_Select(0, null, null, null, null, null, null, null, null, null, null, "", " NgayTao DESC").Take(5).ToList(); colPageNhapVatTu.DataSource = listNhapVatTu; colPageNhapVatTu.BindToControl = rptDanhMucNhapVatTu; rptDanhMucNhapVatTu.DataSource = colPageNhapVatTu.DataSourcePaged; }
private void BindGrid() { var dts = new xRPDataContext(); var status = int.Parse(ddlTinhTrang.SelectedValue); if (searchbox.Value.Trim() == "") { DateTime dateFrom = DateTime.MinValue, dateTo = DateTime.Now; if (!DateTime.TryParseExact(datepicker.Value, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateFrom)) { dateFrom = DateTime.Now.AddMonths(-1); } if (!DateTime.TryParseExact(datepicker1.Value, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTo)) { dateTo = DateTime.Now; } var x = dts.Sp_Qlvt_PhieuNhap_Select((int)EnumPhieuNhap.SelectTypes.All, (int?)null, 0, (int?)null, (int?)null, null, (int?)null, (int)(int)EnumPhieuNhap.KieuVatTu.NhapThanhPham, status < 0 || status > 2 ? (int?)null : status, dateFrom.AddDays(-1), dateTo.AddDays(1), null, " NgayTao DESC").ToList(); colPage.DataSource = x; colPage.BindToControl = rptDanhMucLoaiVatTu; rptDanhMucLoaiVatTu.DataSource = colPage.DataSourcePaged; Sp_Qlvt_PhieuNhap_SelectResult ru = new Sp_Qlvt_PhieuNhap_SelectResult(); } else { DateTime dateFrom = DateTime.MinValue, dateTo = DateTime.Now; if (!DateTime.TryParseExact(datepicker.Value, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateFrom)) { dateFrom = DateTime.Now.AddMonths(-1); } if (!DateTime.TryParseExact(datepicker1.Value, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTo)) { dateTo = DateTime.Now; } var type = string.IsNullOrEmpty(searchbox.Value) == true ? (int)EnumPhieuNhap.SelectTypes.All : (int)EnumPhieuNhap.SelectTypes.Seach; var x = dts.Sp_Qlvt_PhieuNhap_Select(type, (int?)null, 0, (int?)null, (int?)null, null, (int?)null, (int)(int)EnumPhieuNhap.KieuVatTu.NhapThanhPham, status < 0 || status > 2 ? (int?)null : status, dateFrom.AddDays(-1), dateTo.AddDays(1), searchbox.Value.Trim(), " NgayTao DESC").ToList(); colPage.DataSource = x; colPage.BindToControl = rptDanhMucLoaiVatTu; rptDanhMucLoaiVatTu.DataSource = colPage.DataSourcePaged; } }
private void BindGrid() { var dts = new xRPDataContext(); if (searchbox.Value.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; } DateTime temp1 = dt1.AddDays(-1); DateTime temp2 = dt2.AddDays(1); var x = dts.Sp_Qlvt_PhieuNhap_Select((int)EnumPhieuNhap.SelectTypes.All, (int?)null, 0, (int?)null, (int?)null, null, (int?)null, 1, status < 0 || status > 2 ? (int?)null : status, temp1, temp2, null, " NgayTao DESC").ToList(); colPage.DataSource = x; colPage.BindToControl = rptDanhMucLoaiVatTu; rptDanhMucLoaiVatTu.DataSource = colPage.DataSourcePaged; Sp_Qlvt_PhieuNhap_SelectResult ru = new Sp_Qlvt_PhieuNhap_SelectResult(); } 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; } DateTime temp1 = dt1.AddDays(-1); DateTime temp2 = dt2.AddDays(1); var x = dts.Sp_Qlvt_PhieuNhap_Select((int)EnumPhieuNhap.SelectTypes.Seach, (int?)null, 0, (int?)null, (int?)null, null, (int?)null, 1, status < 0 || status > 2 ? (int?)null : status, temp1, temp2, searchbox.Value.Trim(), " NgayTao DESC").ToList(); colPage.DataSource = x; colPage.BindToControl = rptDanhMucLoaiVatTu; rptDanhMucLoaiVatTu.DataSource = colPage.DataSourcePaged; } }