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