private void LoadData(int date) { bll = new BLLuong(); ds = bll.LoadData(date); dsluong = new List <LUONG>(); ds = bll.LoadData(date); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow row = ds.Tables[0].Rows[i]; var x = row.ItemArray.ToList(); LUONG salar = new LUONG(); salar.MaNV = int.Parse(x[0].ToString()); salar.NgayTL = int.Parse(dtp_cal.Value.ToString("yyyyMM")); salar.Luong1 = int.Parse(x[2].ToString()); dsluong.Add(salar); } dgvLuong.Rows.Clear(); for (int i = 0; i < dsluong.Count; i++) { dgvLuong.Rows.Add(dsluong[i].MaNV, dsluong[i].NgayTL, dsluong[i].Luong1); } dtp_cal.Format = DateTimePickerFormat.Custom; dtp_print.Format = DateTimePickerFormat.Custom; dtp_cal.CustomFormat = "MM/yyyy"; dtp_print.CustomFormat = "MM/yyyy"; dgvLuong.AutoResizeColumns(); }
private void dateTimePicker2_ValueChanged(object sender, EventArgs e) { int a = int.Parse(dtp_print.Value.ToString("yyyyMM")); dgvLuong.Rows.Clear(); bll = new BLLuong(); ds = bll.LoadData(a); this.LoadData(a); //MessageBox.Show(a); }
private void LoadData(int date) { bll = new BLLuong(); ds = bll.LoadData(date); dsluong = new List <Luong>(); ds = bll.LoadData(date); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow row = ds.Tables[0].Rows[i]; var x = row.ItemArray.ToList(); Luong salar = new Luong() { MaNV = int.Parse(x[0].ToString()), NgayTraLuong = int.Parse(dtp_cal.Value.ToString("yyyyMM")), TienLuong = int.Parse(x[2].ToString()) }; //salar.NgayTraLuong.ToString("yyyyMM"); // dsnv.Clear(); dsluong.Add(salar); // dsnv.Add(salar.MaNV); } dgvLuong.Rows.Clear(); // cbb_empIDs.Items.Clear(); for (int i = 0; i < dsluong.Count; i++) { dgvLuong.Rows.Add(dsluong[i].MaNV, dsluong[i].NgayTraLuong, dsluong[i].TienLuong); // cbb_empIDs.Items.Add(dsluong[i].MaNV); } dtp_cal.Format = DateTimePickerFormat.Custom; dtp_print.Format = DateTimePickerFormat.Custom; dtp_cal.CustomFormat = "MM/yyyy"; dtp_print.CustomFormat = "MM/yyyy"; dgvLuong.AutoResizeColumns(); }