//Giúp refresh dữ liệu
private static void Cheats(ref Table mytbl)
{
mytbl.BeginUpdate();
mytbl.ColumnModel.Columns.Add(new TextColumn());
mytbl.EndUpdate();
mytbl.BeginUpdate();
mytbl.ColumnModel.Columns.RemoveAt(mytbl.ColumnModel.Columns.Count-1);
mytbl.EndUpdate();
}
/// <summary>
/// Lấy thông tin nhân viên vừa quẹt thẻ hiển thị lên danh sách
/// </summary>
private void PopulateEmployee(int stt, string EmployeeName, string DepartmentName, string CardID, DateTime workingDay, DateTime checkIn, string PicPath)
{
xptMessage.BeginUpdate();
string WorkingDay = workingDay.ToString("dd/MM/yyyy");
string CheckIn = checkIn.ToString("HH:mm");
Row row = new Row();
// Row row = new Row(new string[]{stt.ToString(),DepartmentName,CardID,EmployeeName,WorkingDay,CheckIn});
row.Cells.Add(new Cell(stt.ToString()));
row.Cells.Add(new Cell(DepartmentName));
row.Cells.Add(new Cell(CardID));
row.Cells.Add(new Cell(EmployeeName));
row.Cells.Add(new Cell(WorkingDay));
row.Cells.Add(new Cell(CheckIn));
if (System.IO.File.Exists(PicPath))
{
row.Cells.Add(new Cell("", Image.FromFile(PicPath)));
}
xptMessage.TableModel.Rows.Add(row);
xptMessage.EndUpdate();
// pictureBox1.Image = Image.FromFile(PicPath);
}
/// <summary>
///
/// </summary>
private void PopulatePositionListView()
{
dsPosition = departmentDO.GetAllPositions();
lvwPosition.BeginUpdate();
lvwPosition.TableModel.Rows.Clear();
dtPosition = dsPosition.Tables[0];
if (dtPosition.Rows.Count > 0)
{
// selectedRowIndex = 0;
int STT = 0;
foreach (DataRow dr in dtPosition.Rows)
{
STT++;
string PositionName = dr["PositionName"].ToString();
string PositionShortName = dr["PositionShortName"].ToString();
string Description = dr["Description"].ToString();
Row row = new Row(new string[] { STT.ToString(), PositionName, PositionShortName, Description });
row.Tag = STT - 1;
lvwPosition.TableModel.Rows.Add(row);
}
}
lvwPosition.EndUpdate();
}
/// <summary>
/// Tự động size cột dữ liệu (Không sử dụng khi đã dùng even SizeChanged)
/// void modify nên để sau cùng áu khi toàn bộ dữ liệu đã load đầy đủ
/// </summary>
/// <param name="mytbl"></param>
public static void XPTableModifier(ref Table mytbl)
{
RowColor(ref mytbl);
SizeModifier(ref mytbl);
mytbl.BeginUpdate();
mytbl.Resize += new EventHandler(SizeChanged);
mytbl.EnableHeaderContextMenu=false;
mytbl.EndUpdate();
}
/// <summary>
/// Hiển thị danh sách nhân viên trong công ty/phòng ban
/// </summary>
private void PopulateEmployeeListView()
{
dsEmployee = employeeDO.GetEmployeeByDepartment(1);
lvwEmployee.BeginUpdate();
foreach (DataRow dr in dsEmployee.Tables[0].Rows)
{
string CardID = dr["CardID"].ToString();
string EmployeeName = dr["EmployeeName"].ToString();
string DepartmentName = dr["DepartmentName"].ToString();
Row xpRow = new Row(new string[] { DepartmentName, CardID, EmployeeName });
lvwEmployee.TableModel.Rows.Add(xpRow);
}
lvwEmployee.EndUpdate();
}
// private void frmListContractType_Load(object sender, EventArgs e)
// {
// PopulateContractType();
// }
/// <summary>
/// Hiển thị các kiểu hợp đồng được định nghĩa
/// </summary>
private void PopulateContractType()
{
dsContractType = ContractType.GetContractType();
dtContractType = dsContractType.Tables[0];
lvwContractTable.BeginUpdate();
lvwContractTable.TableModel.Rows.Clear();
int STT = 0;
foreach (DataRow dr in dtContractType.Rows)
{
STT++;
//string ContractID = dr["ContractID"].ToString();
string ContractName = dr["ContractName"].ToString();
string Note = dr["Note"].ToString();
Row row = new Row(new string[] { STT.ToString(), ContractName, Note });
row.Tag = STT - 1;
lvwContractTable.TableModel.Rows.Add(row);
}
lvwContractTable.EndUpdate();
}
/// <summary>
/// Điền danh sách thời gian vào ra của từng nhân viên lên listview
/// </summary>
private void FillListTimeInOut()
{
int emplID = int.Parse(((MTGCComboBoxItem)cboEmployee.SelectedItem).Col1);
dsTimeInOut = timeInOutDO.GetTimeInOut(emplID, fromDate, toDate);
lvwTimeInOut.BeginUpdate();
lvwTimeInOut.TableModel.Rows.Clear();
int STT = 0;
foreach (DataRow dr in dsTimeInOut.Tables[0].Rows)
{
//Điền các dữ liệu ngày làm việc, thời gian vào ra vào list view.
string WorkingDay = DateTime.Parse(dr["WorkingDay"].ToString()).ToString("dd/MM/yyyy");
string TimeIn = "";
if (dr["TimeIn"] != DBNull.Value)
{
TimeIn = DateTime.Parse(dr["TimeIn"].ToString()).ToString("HH:mm");
}
string TimeOut = "";
if (dr["TimeOut"] != DBNull.Value)
{
TimeOut = DateTime.Parse(dr["TimeOut"].ToString()).ToString("HH:mm");
}
Cell[] listTimeInOut = new Cell[4];
listTimeInOut[0] = new Cell(STT + 1);
listTimeInOut[1] = new Cell(WorkingDay);
listTimeInOut[2] = new Cell(TimeIn);
listTimeInOut[3] = new Cell(TimeOut);
Row row = new Row(listTimeInOut);
row.Tag = STT;
//if (dr["ManuallyEdited"].ToString() == "1")
//{
// row.BackColor = System.Drawing.Color.MistyRose; //doi mau nen cua row bi sua du lieu bang tay
//}
lvwTimeInOut.TableModel.Rows.Add(row);
STT++;
}
lvwTimeInOut.EndUpdate();
}
/// <summary>
/// Hiển thị các kiểu ngày đã định nghĩa
/// </summary>
private void PopulateDayType()
{
dsDayType = daytypeDO.GetDayType();
dtDayType = dsDayType.Tables[0];
lvwDayType.BeginUpdate();
lvwDayType.TableModel.Rows.Clear();
int STT = 0;
foreach (DataRow dr in dtDayType.Rows)
{
STT++;
string DayName = dr["DayName"].ToString();
string DayShortName = dr["DayShortName"].ToString();
string DayFactor = dr["DayFactor"].ToString();
// string Quantity = dr["Quantity"].ToString();
Row row = new Row(new string[] { STT.ToString(), DayName, DayShortName, DayFactor });
row.Tag = STT - 1;
lvwDayType.TableModel.Rows.Add(row);
}
lvwDayType.EndUpdate();
}
/// <summary>
///
/// </summary>
private void PopulatePunishCardView()
{
dsPunishCard = punishCarDO.GetPunishCard();
lvwPunishCard.BeginUpdate();
lvwPunishCard.TableModel.Rows.Clear();
dtPunishCard = dsPunishCard.Tables[0];
int STT = 0;
foreach (DataRow dr in dtPunishCard.Rows)
{
string CardName = dr["CardName"].ToString();
string PunishFactor = dr["PunishFactor"].ToString() + " %";
string Note = dr["Note"].ToString();
Row row = new Row(new string[] { (STT + 1).ToString(), CardName, PunishFactor, Note });
row.Tag = STT;
lvwPunishCard.TableModel.Rows.Add(row);
STT++;
}
lvwPunishCard.EndUpdate();
}
private void PopulateListInsuranInYear()
{
dsInsurance = insuranceDO.GetListInsuranceInYear(int.Parse(cboYear.Text));
lvwListInsurance.BeginUpdate();
lvwListInsurance.TableModel.Rows.Clear();
int STT = 0;
foreach (DataRow dr in dsInsurance.Tables[0].Rows)
{
String StartDate = DateTime.Parse(dr["StartPointDate"].ToString()).ToString("dd/MM/yyyy");
String EndDate = DateTime.Parse(dr["EndPointDate"].ToString()).ToString("dd/MM/yyyy");
Cell[] listInusurance = new Cell[3];
listInusurance[0] = new Cell((STT + 1).ToString());
listInusurance[1] = new Cell(StartDate);
listInusurance[2] = new Cell(EndDate);
Row row = new Row(listInusurance);
row.Tag = STT;
lvwListInsurance.TableModel.Rows.Add(row);
STT++;
}
lvwListInsurance.EndUpdate();
}
//Kiểm tra và thay đổi
private static void SizeModifier(ref Table mytbl)
{
//Lấy thông tin bảng hiển tại
int TblWsize = mytbl.Size.Width;
int TotalColnum = mytbl.ColumnModel.Columns.Count;
int TotalColsize = mytbl.ColumnModel.VisibleColumnsWidth;
if(mytbl.ColumnModel.VisibleColumnCount==0)return;
//Kiểm tra khoảng trống
if(TblWsize<=TotalColsize+30)return;
//Nếu bảng chỉ có một cột thì hiển thị trực tiếp
if(mytbl.ColumnModel.VisibleColumnCount==1)
{
mytbl.BeginUpdate();
for (int i=0;i<TotalColnum;i++)
{
mytbl.ColumnModel.Columns[i].Width =TblWsize-30;
}
mytbl.EndUpdate();
}
else
{
int Remainning = (TblWsize-TotalColsize-30)/mytbl.ColumnModel.VisibleColumnCount;
//Tăng kích thước
mytbl.BeginUpdate();
for (int i=0;i<TotalColnum;i++)
{
mytbl.ColumnModel.Columns[i].Width =mytbl.ColumnModel.Columns[i].Width+Remainning;
}
mytbl.EndUpdate();
}
Cheats(ref mytbl);
}
//Thay đổi màu sắc
private static void RowColor(ref Table mytbl)
{
mytbl.BeginUpdate();
mytbl.AlternatingRowColor = Color.FromArgb(((Byte)(235)), ((Byte)(243)), ((Byte)(255)));
mytbl.BackColor = Color.FromArgb(((Byte)(241)), ((Byte)(244)), ((Byte)(255)));
mytbl.SortedColumnBackColor = Color.Transparent;
mytbl.EndUpdate();
}
/// <summary>
/// Hiển thị danh sách nhân viên trong công ty/phòng ban
/// </summary>
private void PopulateEmployeeListView()
{
lvwEmployee.BeginUpdate();
lvwEmployee.TableModel.Rows.Clear();
int STT = 0;
//if (dsEmployee.Tables.Count>0)
// if (dsEmployee.Tables[0].Rows.Count > 0)
foreach (DataRow dr in dsEmployee.Tables[0].Rows)
{
Cell DepartmentName = new Cell();
//if (this.lblDepartment.Text.Equals("Danh sách các đơn vị"))
//{
DepartmentName = new Cell(dr["DepartmentName"].ToString());
//}
//else
//{
// DepartmentName = new Cell(dr["DepartmentNameJP"].ToString());
//}
Cell CardID = new Cell(dr["CardID"].ToString());
Cell EmployeeName = new Cell(dr["EmployeeName"].ToString());
Cell Gender = new Cell(Int32.Parse(dr["Gender"].ToString()) == 0 ? "Nam" : "Nữ");
Cell DateOfBirth = new Cell(DateTime.Parse(dr["DateOfBirth"].ToString()).ToString("dd/MM/yyyy"));
Cell IdentityCard = new Cell(dr["IdentityCard"].ToString());
Cell InsuranceID = new Cell(dr["InsuranceID"].ToString());
Cell Address = new Cell(dr["Address"].ToString());
Cell Phone = new Cell(dr["Phone"].ToString());
string professionalLevel = ConvertProfessionalLevel2String(int.Parse(dr["ProfessionalLevel"].ToString()));
Cell ProfessionalLevel = new Cell(professionalLevel);
Cell Commune = new Cell(dr["Commune"].ToString());
Cell District = new Cell(dr["District"].ToString());
Cell Province = new Cell(dr["Province"].ToString());
Cell Position = new Cell(dr["PositionName"].ToString());
Cell StartTrial = new Cell("");
if (dr["StartTrial"] != DBNull.Value)
{
StartTrial = new Cell(DateTime.Parse(dr["StartTrial"].ToString()).ToString("dd/MM/yyyy"));
}
int Start_month = 0;
int Start_year = 0;
Cell StartDate = new Cell("");
if (dr["StartDate"] != DBNull.Value)
{
StartDate = new Cell(DateTime.Parse(dr["StartDate"].ToString()).ToString("dd/MM/yyyy"));
Start_month = DateTime.Parse(dr["StartDate"].ToString()).Month;
Start_year = DateTime.Parse(dr["StartDate"].ToString()).Year;
}
Cell BasicSalary = new Cell(double.Parse(dr["BasicSalary"].ToString()));
Row row = new Row(new Cell[] { new Cell(STT + 1), DepartmentName, CardID, EmployeeName, Gender, DateOfBirth, IdentityCard, InsuranceID, Phone, ProfessionalLevel, Address, Commune, District, Province, Position, StartTrial, StartDate, BasicSalary });
row.Tag = STT;
lvwEmployee.TableModel.Rows.Add(row);
STT++;
}
lvwEmployee.EndUpdate();
string str = WorkingContext.LangManager.GetString("frmliste_text1");
lblEmployee.Text = "Tổng số nhân viên trong danh sách: " + dsEmployee.Tables[0].Rows.Count;
lblEmployee.Text = str + dsEmployee.Tables[0].Rows.Count;
t = dsEmployee.Tables[0].Rows.Count;
if (checkEmployeeDeleted == false)
{
btnRestore.Visible = false;
//btnAdd.Visible = true;
//btnDelete.Visible = true;
btnPermanentDelete.Visible = true;
}
else
{
btnRestore.Visible = true;
//btnAdd.Visible = false;
//btnDelete.Visible = false;
btnPermanentDelete.Visible = false;
}
}
