private void btnTim_Click(object sender, EventArgs e) { var db = new MyDBContextDataContext(); txttungay.DateTime = Convert.ToDateTime(txttungay.DateTime.ToString("yyyy/MM/dd") + " 01:00:00"); txtdenngay.DateTime = Convert.ToDateTime(txtdenngay.DateTime.ToString("yyyy/MM/dd") + " 23:59:59"); var lst = (from s in db.procTonKhoBTP_TP_View(txttungay.DateTime, txtdenngay.DateTime) select s).ToList(); procTonKhoBTP_TP_ViewGridControl.DataSource = lst; }
private void frmKhoBTP_TPTonKho_Load(object sender, EventArgs e) { //Thread.CurrentThread.CurrentCulture = new Globalization.CultureInfo("vi"); //Thread.CurrentThread.CurrentUICulture = new Globalization.CultureInfo("vi"); txttungay.DateTime = Convert.ToDateTime(GetFirstDayOfMonth(DateTime.Now).ToString("yyyy/MM/dd") + " 01: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.procTonKhoBTP_TP_View(txttungay.DateTime, txtdenngay.DateTime) select s).ToList(); procTonKhoBTP_TP_ViewGridControl.DataSource = lst; }