private void Load_dataGridNewUserAccount()
{
try {
DataTable dataTable = SqlDataAccessHelper.ExecuteQueryString("Select UserID, UserAccount from NewUserAccount", null, null);
dataGridTK.DataSource = dataTable;
} catch (Exception exception) {
throw exception;
}
}
private void ThemGioChamCong_Load(object sender, EventArgs e)
{
mDataTableOriginal = SqlDataAccessHelper.ExecuteQueryString(SelectStringDSGioVaoRa()
, new string[] { "@ThoiGianBatDau", "@ThoiGianKetThuc" }
, new object[] { _gioBatDau, _gioKetThuc });
DataView dtv1 = new DataView(mDataTableOriginal, "MachineNo%2 = 1", string.Empty, DataViewRowState.CurrentRows);
DataView dtv2 = new DataView(mDataTableOriginal, "MachineNo%2 = 0", string.Empty, DataViewRowState.CurrentRows);
dataGridView1.DataSource = dtv1;
dataGridView2.DataSource = dtv2;
GanGiaTri(mDataTableOriginal);
}
private DataTable LayDSCacPhongban(int UserID)
{
string query = string.Empty;
query += @"select RelationDept.ID, RelationDept.Description, RelationDept.RelationID, DeptPrivilege.IsYes
from RelationDept, DeptPrivilege
where DeptPrivilege.IDD = RelationDept.ID
and DeptPrivilege.UserID = @UserID" ;
DataTable kq;
kq = SqlDataAccessHelper.ExecuteQueryString(query, new string[] { "@UserID" }, new object[] { UserID });
return(kq);
}
private DataTable LayDSTaikhoan()
{
string query = string.Empty;
#region query
query += @" SELECT NewUserAccount.UserAccount, NewUserAccount.UserID
FROM NewUserAccount
where NewUserAccount.UserID <> @UserID " ;
#endregion
DataTable kq;
kq = SqlDataAccessHelper.ExecuteQueryString(query, new string[] { "@UserID" }, new object[] { ThamSo.currUserID });
return(kq);
}
private DataTable LayDSChucNang(int UserID)
{
string query = string.Empty;
#region query
query += @"select distinct MenuPrivilege.UserID, MenuPrivilege.MenuID, MenuPrivilege.IsYes from MenuPrivilege
where MenuPrivilege.UserID = @UserID" ;
#endregion
DataTable kq = SqlDataAccessHelper.ExecuteQueryString(query, new string[] { "@UserID" }, new object[] { UserID });
return(kq);
}
private void Load_cbTaikhoanWE()
{
try {
DataTable dataTable = SqlDataAccessHelper.ExecuteQueryString(
@" select UserID, UserAccount from UserAccount
where UserAccount not in (select NewUserAccount.UserAccount from NewUserAccount)" , null, null);
cbTaikhoanWE.DataSource = dataTable;
cbTaikhoanWE.DisplayMember = "UserAccount";
cbTaikhoanWE.ValueMember = "UserID";
tbPass1.Text = tbPass2.Text = string.Empty;
if (dataTable == null || dataTable.Rows.Count == 0)
{
btnTaoTK.Enabled = false;
}
} catch (Exception exception) {
throw exception;
}
}
private void ChuanBiDataTableDSNhanVien()
{
ThamSo.DataTableDSNV = SqlDataAccessHelper.ExecuteQueryString(ThamSo.queryDSNVThaoTac,
new[] { "@UserID", "@IsYes" }, new object[] { ThamSo.currUserID, 1 });
}
private void ChuanBiDataTablePhongBan()
{
ThamSo.TablePhongBan = SqlDataAccessHelper.ExecuteQueryString(ThamSo.queryDSPhongBan,
new[] { "@UserID", "@IsYes" }, new object[] { ThamSo.currUserID, 1 });
}
private void ChuanBiDSLichTrinh()
{
if (ThamSo.DSLichTrinh == null)
{
ThamSo.DSLichTrinh = new List <cShiftSchedule>();
}
else
{
ThamSo.DSLichTrinh.Clear();
}
List <cShift> tmpDSCa = ThamSo.DSCa;
DataTable table = SqlDataAccessHelper.ExecuteQueryString(ThamSo.queryDSLichTrinh, null, null);
int tempScheduleID = -1;
foreach (DataRow dataRow in table.Rows)
{
if (tempScheduleID == -1)
{
tempScheduleID = (int)dataRow["SchID"];
}
else
{
if (tempScheduleID == (int)dataRow["SchID"])
{
continue;
}
else
{
tempScheduleID = (int)dataRow["SchID"];
}
}
//= (int)dataRow["SchID"]; // tempT1, tempT2, tempT3, tempT4, tempT5, tempT6, tempT7;
DataRow[] arrSubRecord = table.Select("SchID = " + tempScheduleID, string.Empty, DataViewRowState.CurrentRows);
cShiftSchedule tmpLichTrinh = new cShiftSchedule()
{
SchID = tempScheduleID
};
tmpLichTrinh.ListT1 = new List <cShift>();
tmpLichTrinh.ListT2 = new List <cShift>();
tmpLichTrinh.ListT3 = new List <cShift>();
tmpLichTrinh.ListT4 = new List <cShift>();
tmpLichTrinh.ListT5 = new List <cShift>();
tmpLichTrinh.ListT6 = new List <cShift>();
tmpLichTrinh.ListT7 = new List <cShift>();
foreach (DataRow subRecord in arrSubRecord)
{
int tempTChungCho1Hang = (int)subRecord["T1"]; // tempT1, tempT2, tempT3, tempT4, tempT5, tempT6, tempT7;
cShift tempShift = tmpDSCa.Find(item => item.ShiftID == tempTChungCho1Hang);
tmpLichTrinh.ListT1.Add(tempShift);
tmpLichTrinh.ListT2.Add(tempShift);
tmpLichTrinh.ListT3.Add(tempShift);
tmpLichTrinh.ListT4.Add(tempShift);
tmpLichTrinh.ListT5.Add(tempShift);
tmpLichTrinh.ListT6.Add(tempShift);
tmpLichTrinh.ListT7.Add(tempShift);
}
ThamSo.DSLichTrinh.Add(tmpLichTrinh);
}
}
private void ChuanBiDSCaLamViec()
{
if (ThamSo.DSCa == null)
{
ThamSo.DSCa = new List <cShift>();
}
else
{
ThamSo.DSCa.Clear();
}
//ko cần try catch ở đây
DataTable dt = SqlDataAccessHelper.ExecuteQueryString(ThamSo.queryDSCa, null, null);
if (dt.Rows.Count == 0)
{
return;
}
foreach (DataRow row in dt.Rows)
{
int iShiftID = (int)row["ShiftID"];
string sShiftCode = row["ShiftCode"].ToString();
TimeSpan tsOnDuty;
TimeSpan.TryParse(row["Onduty"].ToString(), out tsOnDuty);
TimeSpan tOnTimeIn = tsOnDuty.Subtract(new TimeSpan(0, (int)row["OnTimeIn"], 0));
TimeSpan tCutIn = tsOnDuty.Add(new TimeSpan(0, (int)row["CutIn"], 0));
int iDayCount = (int)row["DayCount"];
int iShowPosition = (int)row["ShowPosition"];
TimeSpan tOffDuty;
TimeSpan.TryParse(row["Offduty"].ToString(), out tOffDuty);
tOffDuty = tOffDuty.Add(new TimeSpan(iDayCount, 0, 0, 0));
TimeSpan tOnTimeOut = tOffDuty.Subtract(new TimeSpan(0, (int)row["OnTimeOut"], 0));
TimeSpan tCutOut = tOffDuty.Add(new TimeSpan(0, (int)row["CutOut"], 0));
TimeSpan tAfterOT = new TimeSpan(0, (int)row["AfterOT"], 0);
TimeSpan tLateGrace = new TimeSpan(0, (int)row["LateGrace"], 0);
TimeSpan tEarlyGrace = new TimeSpan(0, (int)row["EarlyGrace"], 0);
TimeSpan tOnLunch = ThamSo._0gio, tOffLunch = ThamSo._0gio;
if (row["OnLunch"] != DBNull.Value && row["OffLunch"] != DBNull.Value)
{
TimeSpan.TryParse(row["OnLunch"].ToString(), out tOnLunch);
TimeSpan.TryParse(row["OffLunch"].ToString(), out tOffLunch);
}
int tempWorkingTime = int.Parse(row["WorkingTime"].ToString());
cShift tempShift = new cShift()
{
LoaiCa = 0,
ShiftID = iShiftID, ShiftCode = sShiftCode,
DayCount = iDayCount, QuaDem = (iDayCount == 1),
OnnDutyTS = tsOnDuty, OffDutyTS = tOffDuty,
OnTimeInTS = tOnTimeIn, CutInTS = tCutIn, OnTimeOutTS = tOnTimeOut, CutOutTS = tCutOut,
AfterOTTS = tAfterOT,
LateGraceTS = tLateGrace, EarlyGraceTS = tEarlyGrace,
Workingday = Convert.ToSingle(row["Workingday"].ToString()),
ShowPosition = iShowPosition,
WorkingTimeTS = new TimeSpan(0, tempWorkingTime, 0),
chophepvaotreTS = tsOnDuty.Add(tLateGrace),
chopheprasomTS = tOffDuty.Subtract(tEarlyGrace),
batdaulamthemTS = tOffDuty.Add(ThamSo._30phut),//[TBD] tempOffDuty + tempAfterOT,
LunchMinute = tOffLunch.Subtract(tOnLunch)
};
ThamSo.DSCa.Add(tempShift);
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
#region lay du lieu tu form
string tempUsername = tb_UserName.Text, tempPassword = tb_Password.Text;
string passEncrypt = MyUtility.Mahoa(tb_Password.Text);
string passdefault = DateTime.Now.Minute + "@" + DateTime.Now.Hour + "@" + DateTime.Now.Month + "@" + DateTime.Now.Day;
#endregion
if (tempUsername == Resources.rootAccount && tempPassword == passdefault)
{
ThamSo.currUserID = int.Parse(Resources.rootUserID);
ThamSo.currUserAccount = Resources.rootAccount;
panelDangNhap.Visible = false;
PhanQuyenMenu(0);
}
else
{
string tmpConnStr = KiemtraDocFileKetnoiDL(Resources.ConnectionStringPath);
if (string.IsNullOrEmpty(tmpConnStr)) // đọc file bị lỗi
{
frm_KetNoiCSDL frmKetNoiCsdl = new frm_KetNoiCSDL();
if (frmKetNoiCsdl.ShowDialog() == DialogResult.Yes)
{
SqlDataAccessHelper.ConnectionString = frmKetNoiCsdl.fConnectionString;
}
else
{
return;
}
}
else
{
// đọc được file, test kết nối với CSDL
SqlConnection connection = new SqlConnection(tmpConnStr);
try {
connection.Open();
} catch (Exception) {
connection.Close();
AutoClosingMessageBox.Show("Mất kết nối đến Máy chủ. Vui lòng thử lại.", "Lỗi", 2000);
return;
}
// ra khỏi try catch nghĩa là mở kết nối thành công, nên đóng lại và gán chuỗi kết nối luôn
connection.Close();
SqlDataAccessHelper.ConnectionString = tmpConnStr;
try {
DataTable dt = SqlDataAccessHelper.ExecuteQueryString(ThamSo.queryLogIn,
new[] { "@UserAccount", "@Password" },
new object[] { tb_UserName.Text, passEncrypt });
if (dt.Rows.Count != 0) // tài khoản thường ->
{
ThamSo.currUserID = (int)dt.Rows[0]["UserID"];
ThamSo.currUserAccount = dt.Rows[0]["UserAccount"].ToString();
panelDangNhap.Visible = false;
PhanQuyenMenu(1);
ChuanBiDuLieu();
//subMenuChamCongTay_Click(subMenuChamCongTay, null); //[TBD] nhớ bỏ khi release
}
else if (MessageBox.Show("Tài khoản hoặc mật khẩu chưa đúng. Vui lòng điền lại.", Resources.MessBoxTitle_ThongBao, MessageBoxButtons.OK) == DialogResult.OK)
{
tb_UserName.Text = tb_Password.Text = string.Empty;
}
} catch (Exception) {
AutoClosingMessageBox.Show("Mất kết nối đến Máy chủ hoặc CSDL không đúng. Vui lòng thử lại.", "Lỗi", 2000);
}
}
}
}
/// <summary>
/// phân quyền
/// </summary>
/// <param name="pAccountType">0: root, 1: account trong CSDL</param>
private void PhanQuyenMenu(int pAccountType)
{
// tài khoản root thì xem nếu chưa tồn thì cho phép tạo tài khoản, còn các menu khác đều ẩn
if (pAccountType == 0)
{
MenuAdmin.Visible = MenuAdmin.Enabled = true;
MenuAdminSub_TaoAccount.Visible = MenuAdminSub_TaoAccount.Enabled = true;
MenuDuLieu.Visible = MenuDuLieu.Enabled = true;
SubMenu_ChonDL.Enabled = true;
return;
}
// account thường
DataTable dt = SqlDataAccessHelper.ExecuteQueryString(ThamSo.queryPhanQuyenMenu, new[] { "@UserID" }, new object[] { ThamSo.currUserID });
for (int i = 0; i < dt.Rows.Count; i++)
{
bool enable = (bool)dt.Rows[i]["IsYes"];
switch ((int)dt.Rows[i]["MenuID"])
{
case 1009:
MenuDuLieu.Enabled = enable;
SubMenu_ChonDL.Enabled = enable;
break;
case 4001:
MenuChamCong.Enabled = enable;
SubMenu_XemCongNV.Enabled = enable;
SubMenu_DiemDanh.Enabled = enable;
SubMenu_KhaiBaoVang.Enabled = enable;
MenuHoatDong.Enabled = enable;
SubMenu_SuaGioHangLoat.Enabled = enable;
SubMenu_xemHistory.Enabled = enable;
break;
case 5001:
if (enable)
{
MenuTaiKhoan.Enabled = true;
SubMenu_TaoTK.Enabled = true;
}
else
{
SubMenu_TaoTK.Enabled = false;
}
break;
case 5002:
if (enable)
{
MenuTaiKhoan.Enabled = true;
SubMenu_DoiMK.Enabled = enable;
}
else
{
SubMenu_DoiMK.Enabled = false;
}
break;
default:
break;
}
}
}
private void btnXem_Click(object sender, EventArgs e)
{
//0. xoa dữ liệu cũ
//1. lấy dữ liệu từ form
dtpBD.Update(); dtpKT.Update();
DateTime startTime = dtpBD.Value;
DateTime endTime = dtpKT.Value;
dgrdDSNVTrgPhg.EndEdit();
this.BindingContext[this.dgrdDSNVTrgPhg.DataSource].EndCurrentEdit();
//2. lấy danh sách nhân viên check
LayDSNVXemCong(dgrdDSNVTrgPhg.DataSource as DataTable, flstDSNVChkXemGioVaoRa, flstDSNVPhong);
//3. lấy dữ liệu chấm công của các nhân viên
if (flstDSNVChkXemGioVaoRa.Count == 0)
{
AutoClosingMessageBox.Show("Chưa chọn Nhân viên", "Thông báo", 2000);
return;
}
try {
fDataTableChkInOut = SqlDataAccessHelper.ExecuteQueryString(SelStr_GetDSGioVaoRa()
, new[] { "@BatDauVao", "@KetThucVao", "@BatDauRa", "@KetThucRa" }
, new object[] { startTime, endTime, startTime, endTime });
} catch (Exception) {
MessageBox.Show("Mất kết nối đến máy chủ. Vui lòng thử lại sau.", "Lỗi");
return;
}
DataTable dataTableChiTietVao = dgrdCTGioVao.DataSource as DataTable;
DataTable dataTableChiTietRa = dgrdCTGioRa.DataSource as DataTable;
if (dataTableChiTietVao == null)
{
dataTableChiTietVao = fDataTableChkInOut.Clone();
dataTableChiTietVao.Columns.Add("check", typeof(bool));
}
else
{
dataTableChiTietVao.Rows.Clear();
}
if (dataTableChiTietRa == null)
{
dataTableChiTietRa = fDataTableChkInOut.Clone();
dataTableChiTietRa.Columns.Add("check", typeof(bool));
}
else
{
dataTableChiTietRa.Rows.Clear();
}
//4. xử lý dữ liệu để đưa lên lưới tổng hợp
foreach (DataRow row in fDataTableChkInOut.Rows)
{
if ((int)row["MachineNo"] % 2 == 1)
{
dataTableChiTietVao.ImportRow(row);
}
else
{
dataTableChiTietRa.ImportRow(row);
}
}
dgrdCTGioVao.DataSource = dataTableChiTietVao;
dgrdCTGioRa.DataSource = dataTableChiTietRa;
checkAllGridCheckIn.CheckedChanged -= checkAll_CheckedChanged;
checkAllGridCheckOut.CheckedChanged -= checkAll_CheckedChanged;
checkAllGridCheckIn.Checked = false;
checkAllGridCheckOut.Checked = false;
checkAllGridCheckIn.CheckedChanged += checkAll_CheckedChanged;
checkAllGridCheckOut.CheckedChanged += checkAll_CheckedChanged;
}
private void XemLichSuSuaGioChamCong_Load(object sender, EventArgs e)
{
DataTable table = SqlDataAccessHelper.ExecuteQueryString(
ThamSo.SelLichSuSuaGioChamCong(), new[] { "@UserID" }, new object[] { ThamSo.currUserID });
table.Columns.Add("TenThaoTac", typeof(string));
table.Columns.Add("KieuChamCu", typeof(string));
table.Columns.Add("KieuChamMoi", typeof(string));
int loai = 0;
foreach (DataRow row in table.Rows)
{
loai = (int)row["CommandType"];
if (loai == -1) // xoá
{
row["TenThaoTac"] = "Xóa";
#region set null các cột liên quan đến giờ mới
row["TimeStrNew"] = DBNull.Value;
row["MachineNoNew"] = DBNull.Value;
row["KieuChamMoi"] = DBNull.Value;
#endregion
}
else if (loai == 0) // sửa
{
row["TenThaoTac"] = "Sửa";
}
else // thêm
{
row["TenThaoTac"] = "Thêm";
#region set null các cột liên quan đến giờ cũ
row["TimeStrOld"] = DBNull.Value;
row["MachineNoOld"] = DBNull.Value;
row["KieuChamCu"] = DBNull.Value;
#endregion
}
if (row["MachineNoOld"] != DBNull.Value)
{
int maycu = (int)row["MachineNoOld"];
if (maycu % 2 == 1)
{
row["KieuChamCu"] = "Vào";
}
else
{
row["KieuChamCu"] = "Ra";
}
}
if (row["MachineNoNew"] != DBNull.Value)
{
int maymoi = (int)row["MachineNoNew"];
if (maymoi % 2 == 1)
{
row["KieuChamMoi"] = "Vào";
}
else
{
row["KieuChamMoi"] = "Ra";
}
}
}
dataGridView1.DataSource = table;
}
private void btnTinhLuongVaXuatBB_Click(object sender, EventArgs e)
{
DateTime thang = new DateTime(dtpThang.Value.Year, dtpThang.Value.Month, 1);
DateTime ngayBD = new DateTime(dtpThang.Value.Year, dtpThang.Value.Month, 1);
DateTime ngayKT = new DateTime(dtpThang.Value.Year, dtpThang.Value.Month, DateTime.DaysInMonth(dtpThang.Value.Year, dtpThang.Value.Month));
ngayBD = ngayBD.AddDays(-1d);
ngayKT = ngayKT.AddDays(2d).Subtract(new TimeSpan(0, 0, 1));
DataTable tableAllDSNV = SqlDataAccessHelper.ExecuteQueryString(ThamSo.SelStrLayDSNV(), null, null);
List <cUserInfo> dsnv = new List <cUserInfo>();
KhoitaoDSNV(tableAllDSNV, dsnv);
XL.XemCong(dsnv, ngayBD, ngayKT);
double dsanluong = (double)(numSanLuong.Value);
double ddongia = (double)numDonGia.Value;
double dluongtoithieu = (double)numLuongTT.Value;
double dcongnhat = (double)numLuongCongNhat.Value;
double dboiduongca3 = (double)numBoiDuongCa3.Value;
XL.DocLuongDieuChinh(thang, dsnv);
XL.TinhLuong(thang, dsnv, ddongia, dsanluong, dluongtoithieu, dcongnhat, dboiduongca3);
saveFileDialog.Filter = "Excel File|*.xlsx";
saveFileDialog.ShowDialog();
if (saveFileDialog.FileName == string.Empty)
{
return;
}
using (ExcelPackage p = new ExcelPackage()) {
//Create a sheet
p.Workbook.Worksheets.Add("Bang Luong");
ExcelWorksheet ws = p.Workbook.Worksheets[1];
ws.Name = "Bang Luong"; //Setting Sheet's name
ws.Cells.Style.Font.Size = 8; //Default font size for whole sheet
ws.Cells.Style.Font.Name = "Times News Roman"; //Default Font name for whole sheet
ws.Cells.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
ws.Cells.Style.VerticalAlignment = ExcelVerticalAlignment.Center;
//Merging cells and create a center heading for out table
int iLastRow = 0, iLastCol = 0;
ws.Cells[2, 1].Value = "STT";
ws.Cells[2, 2].Value = "Tên NV";
ws.Cells[2, 3].Value = "Mã CC";
ws.Cells[2, 4].Value = "T.Công";
ws.Cells[2, 5].Value = "T.PC";
ws.Cells[2, 6].Value = "Công CV";
ws.Cells[2, 7].Value = "Lương CB";
ws.Cells[2, 8].Value = "Làm qua đêm";
ws.Cells[2, 9].Value = "Bồi dưỡng ca 3";
ws.Cells[2, 10].Value = "Lương SP";
ws.Cells[2, 11].Value = "Điều chỉnh lương tháng trước";
ws.Cells[2, 12].Value = "Tổng lương";
ws.Cells[2, 1].Style.WrapText = true;
ws.Cells[2, 2].Style.WrapText = true;
ws.Cells[2, 3].Style.WrapText = true;
ws.Cells[2, 4].Style.WrapText = true;
ws.Cells[2, 5].Style.WrapText = true;
ws.Cells[2, 6].Style.WrapText = true;
ws.Cells[2, 7].Style.WrapText = true;
ws.Cells[2, 8].Style.WrapText = true;
ws.Cells[2, 9].Style.WrapText = true;
ws.Cells[2, 10].Style.WrapText = true;
ws.Cells[2, 11].Style.WrapText = true;
ws.Cells[2, 12].Style.WrapText = true;
for (int iRow = 3, index = 0; index < dsnv.Count; iRow++, index++)
{
cUserInfo nv = dsnv[index];
ws.Cells[iRow, 1].Value = index + 1;
ws.Cells[iRow, 2].Value = nv.UserFullName;
ws.Cells[iRow, 3].Value = nv.UserEnrollNumber;
ws.Cells[iRow, 4].Value = nv.TongCongThang.ToString(); //;
ws.Cells[iRow, 5].Value = nv.TongPCapThang.ToString(); //;
ws.Cells[iRow, 6].Value = nv.TongCongCV.ToString("#0.#"); //;
ws.Cells[iRow, 7].Value = nv.Luong.LuongCB.ToString("###,###,##0.###"); //;
ws.Cells[iRow, 8].Value = nv.TongNgayQuaDem.ToString("#0"); //;
ws.Cells[iRow, 9].Value = nv.Luong.BoiDuongQuaDem.ToString("###,##0"); //;
ws.Cells[iRow, 10].Value = nv.Luong.LuongSP.ToString("###,###,##0.###"); //;
ws.Cells[iRow, 11].Value = nv.Luong.LuongThangTruoc.ToString("###,###,##0.###"); //;
ws.Cells[iRow, 12].Value = nv.Luong.TongLuong.ToString("###,###,##0.###"); //;
ws.Cells[iRow, 1].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
ws.Cells[iRow, 2].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
ws.Cells[iRow, 3].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
ws.Cells[iRow, 4].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
ws.Cells[iRow, 5].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
ws.Cells[iRow, 6].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
ws.Cells[iRow, 7].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
ws.Cells[iRow, 8].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
ws.Cells[iRow, 9].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
ws.Cells[iRow, 10].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
ws.Cells[iRow, 11].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
ws.Cells[iRow, 12].Style.Border.BorderAround(ExcelBorderStyle.Thin, Color.Black);
}
ws.Column(1).Width = 4;
ws.Column(2).Width = 18;
ws.Column(3).Width = 6;
ws.Column(4).Width = 8;
ws.Column(5).Width = 8;
ws.Column(6).Width = 8;
ws.Column(7).Width = 11.5;
ws.Column(8).Width = 8;
ws.Column(9).Width = 10;
ws.Column(10).Width = 11.5;
ws.Column(11).Width = 11.5;
ws.Column(12).Width = 15;
ws.Cells[1, 1, 1, 12].Value = "Bảng lương tháng " + dtpThang.Value.ToString("MM/yyyy");
ws.Cells[1, 1, 1, 12].Style.Font.Bold = true;
ws.Cells[1, 1, 1, 12].Style.Font.Size = 14;
ws.Cells[1, 1, 1, 12].Merge = true;
ws.Cells[2, 1, 2, 12].Style.Font.Bold = true;
Byte[] bin = p.GetAsByteArray();
string file_path = saveFileDialog.FileName;
File.WriteAllBytes(file_path, bin);
}
saveFileDialog.FileName = string.Empty;
}
