private void btnTim_Click(object sender, EventArgs e) { var db = new MyDBContextDataContext(); txttungay.DateTime = Convert.ToDateTime(txttungay.DateTime.ToString("yyyy/MM/dd") + " 00:00:00"); txtdenngay.DateTime = Convert.ToDateTime(txtdenngay.DateTime.ToString("yyyy/MM/dd") + " 23:59:59"); var lst = (from s in db.LoadData_TonKhoNVL_View(txttungay.DateTime, txtdenngay.DateTime) select s).ToList(); procTonKhoNVL_ViewGridControl.DataSource = lst; }
private void frmKhoNVLTonKho_Load(object sender, EventArgs e) { txttungay.DateTime = Convert.ToDateTime(GetFirstDayOfMonth(DateTime.Now).ToString("yyyy/MM/dd") + " 00:00:00"); txtdenngay.DateTime = Convert.ToDateTime(GetLastDayOfMonth(DateTime.Now).ToString("yyyy/MM/dd") + " 23:59:59"); var db = new MyDBContextDataContext(); var lst = (from s in db.LoadData_TonKhoNVL_View(txttungay.DateTime, txtdenngay.DateTime) select s).ToList(); procTonKhoNVL_ViewGridControl.DataSource = lst; Gridview1.Columns["HanSuDung"].Visible = false; Gridview1.Columns["Lo"].Visible = false; if (nvObj.Bophan == "KHONVL") { btnXuatExcel.Enabled = true; } }