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