/// <summary>
/// Sinh dữ liệu thanh toán tiền phép
/// </summary>
private void SinhBangThanhToanTienPhep()
{
frmStatusMessage frmMessagePri = new frmStatusMessage();
frmMessagePri.Show("Đang sinh dữ liệu bảng thanh toán tiền phép, xin chờ trong giây lát...");
this.Cursor = Cursors.WaitCursor;
employeeDO = new EmployeeDO();
restsheetDO = new RestSheetDO();
//Tổng hợp thông tin nghỉ phép của nhân viên
TongHopThongTinNghiPhep(frmMessagePri);
if (tblRestSheet.Rows.Count > 0)
{
SqlConnection con = WorkingContext.GetConnection();
SqlTransaction trans = null;
try
{
con.Open();
trans = con.BeginTransaction();
LuuThongTinTienPhep(trans);
frmMessagePri.Close();
this.Cursor = Cursors.Default;
trans.Commit();
trans.Dispose();
MessageBox.Show(this, WorkingContext.LangManager.GetString("frmRestSheet_Sinh_Messa"),
WorkingContext.LangManager.GetString("frmRestSheet_Sinh_Title"),
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
trans.Rollback();
trans.Dispose();
frmMessagePri.Close();
this.Cursor = Cursors.Default;
MessageBox.Show(ex.ToString());
}
finally
{
con.Close();
con.Dispose();
}
}
else
{
frmMessagePri.Close();
this.Cursor = Cursors.Default;
}
}
private void frmRestSheet_Load_1(object sender, System.EventArgs e)
{
Refresh();
restsheetDO = new RestSheetDO();
CurrentYear = DateTime.Now.Year;
CurrentMonth = DateTime.Now.Month;
cboYear.SelectedText = CurrentYear.ToString();
PopulateDepartmentCombo();
PopulateRestSheetData();
}
/// <summary>
/// Hiển thị dữ liệu bảng chấm công lên form
/// </summary>
private void PopulateRestSheetData()
{
restsheetDO = new RestSheetDO();
dsRestSheet = restsheetDO.GetDepartmentRestSheet(CurrentYear, DepartmentID);
dataRows = dsRestSheet.Tables[0].Select(dataFilter, dataSort);
// Load TimeSheet data to table
lvwRestSheet.BeginUpdate();
lvwRestSheet.TableModel.Rows.Clear();
int STT = 0;
foreach (DataRow dr in dataRows)
{
string CardID = dr["CardID"].ToString();
string EmployeeName = dr["EmployeeName"].ToString();
string DepartmentName = dr["DepartmentName"].ToString();
Cell[] RestSheet = new Cell[24];
RestSheet[0] = new Cell((STT + 1).ToString());
RestSheet[1] = new Cell(DepartmentName);
RestSheet[2] = new Cell(CardID);
RestSheet[3] = new Cell(EmployeeName);
for (int i = 1; i <= 12; i++)
{
string monthname = "month" + i;
RestSheet[i + 3] = new Cell(dr[monthname].ToString());
}
string tong = dr["TotalRest"].ToString();
RestSheet[16] = new Cell(tong);
RestSheet[17] = new Cell();
if (dr["StartDate"] != DBNull.Value)
{
RestSheet[17] = new Cell(DateTime.Parse(dr["StartDate"].ToString()).ToString("dd/MM/yyyy"));
}
string RestAllow = dr["TotalRestAllow"].ToString();
RestSheet[18] = new Cell(RestAllow);
string RestRemain = dr["TotalRestRemain"].ToString();
RestSheet[19] = new Cell(RestRemain);
double BasicSalary = 0;
if (dr["BasicSalary"] != DBNull.Value)
{
BasicSalary = double.Parse(dr["BasicSalary"].ToString());
}
RestSheet[20] = new Cell(BasicSalary);
double HarmfulAllowance = 0;
double ResponsibleAllowance = 0;
double DangerousAllowance = 0;
if (dr["HarmfulAllowance"] != DBNull.Value)
{
HarmfulAllowance = double.Parse(dr["HarmfulAllowance"].ToString());
}
if (dr["ResponsibleAllowance"] != DBNull.Value)
{
ResponsibleAllowance = double.Parse(dr["ResponsibleAllowance"].ToString());
}
if (dr["DangerousAllowance"] != DBNull.Value)
{
DangerousAllowance = double.Parse(dr["DangerousAllowance"].ToString());
}
RestSheet[21] = new Cell((HarmfulAllowance + ResponsibleAllowance + DangerousAllowance));
double toMoney = 0;
if (dr["toMoney"] != DBNull.Value)
{
toMoney = double.Parse(dr["toMoney"].ToString());
}
RestSheet[22] = new Cell(toMoney);
RestSheet[23] = new Cell();
Row row = new Row(RestSheet);
row.Tag = STT;
lvwRestSheet.TableModel.Rows.Add(row);
STT++;
}
lvwRestSheet.EndUpdate();
string str1 = WorkingContext.LangManager.GetString("frmRestSheet_lblTotalE");
//lblTotalEmployee.Text = "Tổng số nhân viên: " + dataRows.Length ;
SoNV = dataRows.Length;
lblTotalEmployee.Text = str1 + dataRows.Length;
}
