public HeSoPhuCap_DTO Load(string ma)
{
HeSoPhuCap_DTO HSPC = new HeSoPhuCap_DTO();
string query = "SELECT * FROM dbo.HESOPHUCAP WHERE MaHSPC = N'" + ma + "' ";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
HeSoPhuCap_DTO hspc = new HeSoPhuCap_DTO(data.Rows[0]);
return(hspc);
}
private void LoadTienLuong()
{
//1
List <NhanVien_DTO> DsNhanVien = NHANVIEN_DAL.Instance.LoadListNHANVIEN();
List <TienLuongDTO> dsTienLuong = new List <TienLuongDTO>();
List <HESOLUONGNHANVIEN_DTO> dsHeSoLuong = new List <HESOLUONGNHANVIEN_DTO>();
//2
for (int i = 0; i < DsNhanVien.Count; i++)
{
//3
List <Cong_DTO> dsCong = Cong_DAL.Instance.Load(DsNhanVien[i].MaNhanVien, int.Parse(DateTime.Now.Month.ToString()), int.Parse(DateTime.Now.Year.ToString()));
string MaNhanVien = DsNhanVien[i].MaNhanVien;
string TenNhanVien = DsNhanVien[i].TenNhanVien;
string HeSoLuong = DsNhanVien[i].MaHSLuong;
if (Cong_DAL.Instance.check(int.Parse(DateTime.Now.Month.ToString()), int.Parse(DateTime.Now.Year.ToString()), MaNhanVien))
{
HeSoPhuCap_DTO dshspc = HeSoPhuCap_DAL.Instance.Load(dsCong[0].MaHSPC.ToString());
HESOLUONGNHANVIEN_DTO gettt = HESOLUONGNHANVIEN_DAL.Instance.getHS(HeSoLuong);
float TienLuong = float.Parse(gettt.HSLuong.ToString()) * 10000 * dsCong[0].NgayCong + 10000 * dshspc.TenHSPC;
int thang = int.Parse(DateTime.Now.Month.ToString());
int nam = int.Parse(DateTime.Now.Year.ToString());
TienLuongDTO tienluong = new TienLuongDTO(MaNhanVien, TenNhanVien, HeSoLuong, TienLuong, thang, nam, "");
dsTienLuong.Add(tienluong);
//4
if (!TienLuongDAL.Instance.checkIsExist(tienluong.MaNhanVien, tienluong.Thang, tienluong.Nam))
{
//5
TienLuongDAL.Instance.add(tienluong);
}
}
else
{
float TienLuong = 0;
int thang = int.Parse(DateTime.Now.Month.ToString());
int nam = int.Parse(DateTime.Now.Year.ToString());
TienLuongDTO tienluong = new TienLuongDTO(MaNhanVien, TenNhanVien, HeSoLuong, TienLuong, thang, nam, "Chưa Chấm Công");
dsTienLuong.Add(tienluong);
//4
if (!TienLuongDAL.Instance.checkIsExist(tienluong.MaNhanVien, tienluong.Thang, tienluong.Nam))
{
//5
TienLuongDAL.Instance.add(tienluong);
}
}
}
//6
dgvtienluong.DataSource = dsTienLuong;
}
public List <HeSoPhuCap_DTO> LoadList()
{
List <HeSoPhuCap_DTO> HSPC = new List <HeSoPhuCap_DTO>();
string query = "SELECT * FROM dbo.HESOPHUCAP ";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
HeSoPhuCap_DTO hspc = new HeSoPhuCap_DTO(item);
HSPC.Add(hspc);
}
return(HSPC);
}
public void add(HeSoPhuCap_DTO hspc)
{
string query = "INSERT INTO dbo.HESOPHUCAP(MaHSPC,TenHSPC) " +
"VALUES(N'" + hspc.MaHSPC + "',N'" + hspc.TenHSPC + "') ";
DataTable result = DataProvider.Instance.ExecuteQuery(query);
}
