private void btnNop_Click(object sender, EventArgs e)
{
try
{
int dem = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
DataRowView row = gridView1.GetRow(i) as DataRowView;
if (row != null)
{
if (row.Row["TrangThai"].ToString() == "1")
{
ChiTietBanKeLuongDTO chiTietBanKeLuongDTO = new ChiTietBanKeLuongDTO();
chiTietBanKeLuongDTO.ChiTietBanKeLuongID = int.Parse(row.Row["ChiTietBanKeLuongID"].ToString());
ChiTietBanKeLuongBUS.Instance.UpdateStatusChiTietBanKeLuong(chiTietBanKeLuongDTO);
ChiTietBanKeLuongBUS.Instance.UpdateStatusChiTietBanKeLuongWithNhanVienAndTamUng(int.Parse(row.Row["NhanVienID"].ToString()), int.Parse(row.Row["ThangTamUng"].ToString()));
dem++;
}
}
}
//btnNop_Click(null, null);
if (dem == 0)
{
MessageBox.Show("Không có bản kê lương nào được nộp!");
}
else
{
MessageBox.Show("Nộp " + dem.ToString() + " bản kê lương thành công!");
}
}
catch (Exception ex)
{
MessageBox.Show("Lỗi khi nộp chấm công!");
}
}
public string UpdateChiTietBanKeLuong(ChiTietBanKeLuongDTO chiTietBanKeLuongDTO)
{
string sql = @"UPDATE ChiTietBanKeLuong
SET
[TienLuongCung] = '" + chiTietBanKeLuongDTO.TienLuongCung + @"'
,[HieuSuat] = '" + chiTietBanKeLuongDTO.HieuSuat + @"'
,[PhuCap] = '" + chiTietBanKeLuongDTO.PhuCap + @"'
,[TamUng] = '" + chiTietBanKeLuongDTO.TamUng + @"'
,[TongLuong] = '" + chiTietBanKeLuongDTO.TongLuong + @"'
,[ThueThuNhapCaNhan] = '" + chiTietBanKeLuongDTO.ThueThuNhapCaNhan + @"'
,[ThucLinh] = '" + chiTietBanKeLuongDTO.ThucLinh + @"'
WHERE ChiTietBanKeLuongID = '" + chiTietBanKeLuongDTO.ChiTietBanKeLuongID + "'";
return(sql);
}
public void UpdateChiTietBanKeLuong(ChiTietBanKeLuongDTO chiTietBanKeLuongDTO)
{
Core.RunSql(ChiTietBanKeLuongDAO.Instance.UpdateChiTietBanKeLuong(chiTietBanKeLuongDTO));
}
public string UpdateStatusChiTietBanKeLuong(ChiTietBanKeLuongDTO chiTietBanKeLuongDTO)
{
string sql = @"Update ChiTietBanKeLuong Set TrangThai = 2 where ChiTietBanKeLuongID = '" + chiTietBanKeLuongDTO.ChiTietBanKeLuongID + "'";
return(sql);
}
