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