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