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;
}
private void suacongluong(string ma, string ten)
{
List <Cong_DTO> dscong = Cong_DAL.Instance.LoadId(ma);
List <TienLuongDTO> dsluong = TienLuongDAL.Instance.Load(ma);
for (int i = 0; i < dscong.Count; i++)
{
Cong_DTO cong = new Cong_DTO(ma, ten, dscong[i].NgayCong, dscong[i].MaHSPC, dscong[i].Thang, dscong[i].Nam);
Cong_DAL.Instance.Update(cong);
}
for (int i = 0; i < dsluong.Count; i++)
{
TienLuongDTO luong = new TienLuongDTO(ma, ten, dsluong[i].MaHSLuong, dsluong[i].TienLuong, dsluong[i].Thang, dsluong[i].Nam, dsluong[i].GhiChu);
TienLuongDAL.Instance.Update(luong);
}
}
public List <TienLuongDTO> LoadListTG(int thang, int nam)
{
List <TienLuongDTO> TienLuong = new List <TienLuongDTO>();
string query = "SELECT * FROM dbo.TienLuong WHERE THANG = N'" + thang + "' AND NAM = N'" + nam + "' ";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
TienLuongDTO tienluong = new TienLuongDTO(item);
TienLuong.Add(tienluong);
}
return(TienLuong);
}
public List <TienLuongDTO> Load(string Ma)
{
List <TienLuongDTO> TienLuong = new List <TienLuongDTO>();
string query = "SELECT * FROM dbo.TienLuong WHERE MaNhanVien = N'" + Ma + "' ";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
TienLuongDTO tienluong = new TienLuongDTO(item);
TienLuong.Add(tienluong);
}
return(TienLuong);
}
public void add(TienLuongDTO tienluong)
{
string query = "INSERT INTO dbo.TienLuong(MaNhanVien,TenNhanVien,MaHSLuong,TienLuong,Thang,Nam,GhiChu) " +
"VALUES(N'" + tienluong.MaNhanVien + "',N'" + tienluong.TenNhanVien + "',N'" + tienluong.MaHSLuong + "',N'" + tienluong.TienLuong + "',N'" + tienluong.Thang + "',N'" + tienluong.Nam + "',N'" + tienluong.GhiChu + "') ";
DataTable result = DataProvider.Instance.ExecuteQuery(query);
}
public void Update(TienLuongDTO tienluong)
{
string query = string.Format("UPDATE dbo.TienLuong SET TenNhanVien = N'{0}', MaHSLuong = N'{1}', TienLuong = N'{2}' , Thang = N'{3}' , Nam = N'{4}' , GhiChu = N'{5}' WHERE MaNhanVien = N'{6}' ", tienluong.TenNhanVien, tienluong.MaHSLuong, tienluong.TienLuong, tienluong.Thang, tienluong.Nam, tienluong.GhiChu, tienluong.MaNhanVien);
DataProvider.Instance.ExecuteNonQuery(query);
}
