private void Build() { //tlDmCbNv.KeyFieldName = "MA_CBNV"; //tlDmCbNv.ParentFieldName = "MA_BP"; //tlDmCbNv.Dock = DockStyle.Fill; //tlDmCbNv.strZone = "EMPLOYEE"; //tlDmCbNv.BuildTreeList(this.isLookup); //dtEmployee = HRMCommon.GetCustomerTable("MA_KV"); tlDmCbNv = HRMCommon.GetTreeViewCust(this.isLookup); this.splControl1.Visible = false; this.pageEmployee.Controls.Add(tlDmCbNv); dgvBHXH.strZone = "BHXH"; dgvBHXH.BuildGridView(); dgvBHYT.strZone = "BHYT"; dgvBHYT.BuildGridView(); dgvTroCap.strZone = "TROCAP"; dgvTroCap.BuildGridView(); dgvTyLe.strZone = "TYLE"; dgvTyLe.BuildGridView(); }
private void FillData(string strKey) { //dtEmployee = SQLExec.ExecuteReturnDt("EXEC Sp_GetDmCbNv"); dtEmployee = HRMCommon.GetCustomerTable("MA_KV", this.cboFill.Text); bdsEmployee.DataSource = dtEmployee; tlDmCbNv.DataSource = bdsEmployee; //bdsEmployee.Position = 0; //HOPDONG //dtHopDong = DataTool.SQLGetDataTable("HRHOPDONG", null, strKey, "Ngay_Begin, Ngay_End"); dtHopDong = SQLExec.ExecuteReturnDt("SELECT * FROM HRHOPDONG"); bdsHopDong.DataSource = dtHopDong; dgvHopDong.DataSource = bdsHopDong; //HOPDONGPL //dtHopDongPL = DataTool.SQLGetDataTable("HRHOPDONGPL", null, strKey, "Ngay_Begin, Ngay_End"); dtHopDongPL = SQLExec.ExecuteReturnDt("SELECT * FROM HRHOPDONGPL"); bdsHopDongPL.DataSource = dtHopDongPL; dgvHopDongPL.DataSource = bdsHopDongPL; //Tham số các khoản thu nhập string strSQLExec = "SELECT T1.*, T2.Ten_Tn, T2.Dvt FROM HRPARAVALUE0 T1 LEFT JOIN HRPARALIST T2 ON T1.Ma_Tn = T2.Ma_Tn " + " ORDER BY Ngay_Ap"; //Uy quyen cho lop co so tim kiem bdsSearch = bdsEmployee; ExportControl = tlDmCbNv; tlDmCbNv.Expand = (bool)SQLExec.ExecuteReturnValue("SELECT Expand FROM SYSZONE WHERE ZONE = '" + tlDmCbNv.strZone + "'"); }
private void Build() { // tlDmCbNv = HRMCommon.GetTreeViewCust(this.isLookup); this.splControl1.Visible = false; this.pageEmployee.Controls.Add(tlDmCbNv); dgvThue.strZone = "THUE_NV"; dgvThue.BuildGridView(); }
private void Build() { //dtEmployee = HRMCommon.GetCustomerTable("MA_KV"); tlDmCbNv = HRMCommon.GetTreeViewCust(this.isLookup); this.splControl1.Visible = false; this.pageEmployee.Controls.Add(tlDmCbNv); dgvHopDong.strZone = "HOPDONGLD"; dgvHopDong.BuildGridView(); dgvHopDongPL.strZone = "HOPDONGLD_PL"; dgvHopDongPL.BuildGridView(); }
private void Build() { // tlDmCbNv = HRMCommon.GetTreeViewCust(this.isLookup); this.splControl1.Visible = false; this.pageEmployee.Controls.Add(tlDmCbNv); dgvNghiPhep.strZone = "NGHIPHEP"; dgvNghiPhep.BuildGridView(); dgvPhepNam.strZone = "PHEPNAM"; dgvPhepNam.BuildGridView(); }
private void Build() { //tlDmCbNv.KeyFieldName = "MA_CBNV"; //tlDmCbNv.ParentFieldName = "MA_TH"; //tlDmCbNv.Dock = DockStyle.Fill; tlDmCbNv.strZone = "EMPLOYEE"; //tlDmCbNv.BuildTreeList(this.isLookup); tlDmCbNv = HRMCommon.GetTreeViewCust(this.isLookup); this.splControl1.Visible = false; this.pageEmployee.Controls.Add(tlDmCbNv); dgvGiaDinh.strZone = "GIADINH"; dgvGiaDinh.BuildGridView(); dgvCongTac.strZone = "CONGTAC"; dgvCongTac.BuildGridView(); dgvBangCap.strZone = "DAOTAO"; dgvBangCap.BuildGridView(); dgvKhenThuong.strZone = "KHENTHUONG"; dgvKhenThuong.BuildGridView(); dgvNghiPhep.strZone = "NGHIPHEP"; dgvNghiPhep.BuildGridView(); dgvPhucLoi.strZone = "PHUCLOI"; dgvPhucLoi.BuildGridView(); dgvDanhGia.strZone = "DANHGIA"; dgvDanhGia.BuildGridView(); dgvKinhNghiem.strZone = "KINHNGHIEM"; dgvKinhNghiem.BuildGridView(); dgvKyNang.strZone = "KYNANG"; dgvKyNang.BuildGridView(); dgvLamViec.strZone = "LAMVIEC"; dgvLamViec.BuildGridView(); dgvQUALIFY.strZone = "HRQUALIFY"; dgvQUALIFY.BuildGridView(); }
void EditEmployee(enuEdit enuNew_Edit) { if (bdsEmployee.Position < 0 && enuNew_Edit == enuEdit.Edit) { return; } //Copy hang hien tai if (bdsEmployee.Position >= 0) { Common.CopyDataRow(((DataRowView)bdsEmployee.Current).Row, ref drCurrent); } else { drCurrent = dtEmployee.NewRow(); } frmEmployee_Edit frmEdit = new frmEmployee_Edit(); frmEdit.Load(enuNew_Edit, drCurrent); //Accept if (frmEdit.isAccept) { if (enuNew_Edit == enuEdit.New) { if (bdsEmployee.Position >= 0) { dtEmployee.ImportRow(drCurrent); } else { dtEmployee.Rows.Add(drCurrent); } dtEmployee = HRMCommon.GetCustomerTable("MA_KV"); bdsEmployee.DataSource = dtEmployee; tlDmCbNv.DataSource = bdsEmployee; bdsEmployee.Position = bdsEmployee.Find("MA_CBNV", drCurrent["MA_CBNV"]); } else { Common.CopyDataRow(drCurrent, ((DataRowView)bdsEmployee.Current).Row); } dtEmployee.AcceptChanges(); } }
private void FillData(string strKey) { //dtEmployee = SQLExec.ExecuteReturnDt("EXEC Sp_GetDmCbNv"); dtEmployee = HRMCommon.GetCustomerTable("MA_KV", this.cboFill.Text); bdsEmployee.DataSource = dtEmployee; tlDmCbNv.DataSource = bdsEmployee; //bdsEmployee.Position = 0; //BHXH dtBHXH = DataTool.SQLGetDataTable("HRBHXH", null, strKey, "Ngay_Begin, Ngay_Tang_BH"); bdsBHXH.DataSource = dtBHXH; dgvBHXH.DataSource = bdsBHXH; //BHYT dtBHYT = DataTool.SQLGetDataTable("HRBHYT", null, strKey, "Ngay_Begin, Ngay_End"); bdsBHYT.DataSource = dtBHYT; dgvBHYT.DataSource = bdsBHYT; //TyLe string strSQLExec1 = "SELECT T1.*, T2.Ten_Tn, T2.Dvt FROM HRPARAVALUE0 T1 LEFT JOIN HRPARALIST T2 ON T1.Ma_Tn = T2.Ma_Tn " + " WHERE T1.Ma_Tn LIKE 'BH%' OR T1.Ma_Tn LIKE 'KP%' ORDER BY Ngay_Ap"; dtTyLe = SQLExec.ExecuteReturnDt(strSQLExec1); bdsTyLe.DataSource = dtTyLe; dgvTyLe.DataSource = bdsTyLe; //TroCap string strSQLExec2 = "SELECT T1.*, T2.Ten_Tn, T2.Dvt FROM HRPARAVALUE0 T1 LEFT JOIN HRPARALIST T2 ON T1.Ma_Tn = T2.Ma_Tn " + " WHERE T1.Ma_Tn LIKE 'PHUCAP%' ORDER BY Ngay_Ap"; dtTroCap = SQLExec.ExecuteReturnDt(strSQLExec2); bdsTroCap.DataSource = dtTroCap; dgvTroCap.DataSource = bdsTroCap; //Uy quyen cho lop co so tim kiem bdsSearch = bdsEmployee; ExportControl = tlDmCbNv; tlDmCbNv.Expand = (bool)SQLExec.ExecuteReturnValue("SELECT Expand FROM SYSZONE WHERE ZONE = '" + tlDmCbNv.strZone + "'"); }
private void FillData(string strKey) { //dtEmployee = SQLExec.ExecuteReturnDt("EXEC Sp_GetDmCbNv"); dtEmployee = HRMCommon.GetCustomerTable("MA_KV", cboFill.Text); bdsEmployee.DataSource = dtEmployee; tlDmCbNv.DataSource = bdsEmployee; //Tham số các khoản thu nhập string strSQLExec = "SELECT T1.*, T2.Ten_Tn, T2.Dvt FROM HRPARAVALUE0 T1 LEFT JOIN HRPARALIST T2 ON T1.Ma_Tn = T2.Ma_Tn " + " ORDER BY Ngay_Ap"; dtTsTn0 = SQLExec.ExecuteReturnDt(strSQLExec); bdsTsTn0.DataSource = dtTsTn0; dgvTsTn0.DataSource = bdsTsTn0; //Uy quyen cho lop co so tim kiem bdsSearch = bdsEmployee; ExportControl = tlDmCbNv; tlDmCbNv.Expand = (bool)SQLExec.ExecuteReturnValue("SELECT Expand FROM SYSZONE WHERE ZONE = '" + tlDmCbNv.strZone + "'"); }
private void FillData(string strKey) { dtEmployee = HRMCommon.GetCustomerTable("MA_KV"); bdsEmployee.DataSource = dtEmployee; tlDmCbNv.DataSource = bdsEmployee; //bdsEmployee.Position = 0; //THUE dtThue = DataTool.SQLGetDataTable("HRTHUE", null, strKey, "Nam, Thang"); bdsThue.DataSource = dtThue; dgvThue.DataSource = bdsThue; //Tham số các khoản thu nhập string strSQLExec = "SELECT T1.*, T2.Ten_Tn, T2.Dvt FROM HRPARAVALUE0 T1 LEFT JOIN HRPARALIST T2 ON T1.Ma_Tn = T2.Ma_Tn " + " ORDER BY Ngay_Ap"; //Uy quyen cho lop co so tim kiem bdsSearch = bdsEmployee; ExportControl = tlDmCbNv; tlDmCbNv.Expand = (bool)SQLExec.ExecuteReturnValue("SELECT Expand FROM SYSZONE WHERE ZONE = '" + tlDmCbNv.strZone + "'"); }
private void FillData(string strKey) { dtEmployee = HRMCommon.GetCustomerTable("MA_KV"); bdsEmployee.DataSource = dtEmployee; tlDmCbNv.DataSource = bdsEmployee; //bdsEmployee.Position = 0; //NGHIPHEP dtNghiPhep = DataTool.SQLGetDataTable("HRNGHIPHEP", null, strKey, "Ngay_Begin, Ngay_End"); bdsNghiPhep.DataSource = dtNghiPhep; dgvNghiPhep.DataSource = bdsNghiPhep; //PHEPNAM dtPhepNam = DataTool.SQLGetDataTable("HRPHEPNAM", null, strKey, "Ma_CbNv"); bdsPhepNam.DataSource = dtPhepNam; dgvPhepNam.DataSource = bdsPhepNam; //Uy quyen cho lop co so tim kiem bdsSearch = bdsEmployee; ExportControl = tlDmCbNv; tlDmCbNv.Expand = (bool)SQLExec.ExecuteReturnValue("SELECT Expand FROM SYSZONE WHERE ZONE = '" + tlDmCbNv.strZone + "'"); }
void btViewContract_Click(object sender, EventArgs e) { try { string HDLD = Parameters.GetParaValue("HDLD").ToString(); // "HDLD20180824"; string HDLD2 = Parameters.GetParaValue("HDLD2").ToString(); // "HDLD20180824";-- Hợp đồng không thời hạn string HDLD_PL = Parameters.GetParaValue("HDLDPL").ToString(); //"HDLD20180824_PL"; string HDLD_HL = Parameters.GetParaValue("HDLDHL").ToString(); //"HDLD20180824_PL";-- -- Hợp đồng huấn luyện if (tabDetail.SelectedTab == pageHopDong || dgvHopDong.Focused) // View hop dong { if (bdsHopDong.Position < 0) { return; } DataRow drCurrentHD = ((DataRowView)bdsHopDong.Current).Row; string strSQLProc = "sp_GetHDLDInfo"; Hashtable htParameter = new Hashtable(); htParameter.Add("MA_CBNV", drCurrentHD["Ma_Cbnv"].ToString()); htParameter.Add("SO_HD", drCurrentHD["So_Hd"].ToString()); htParameter.Add("SO_PL", string.Empty); DataTable dtResult = SQLExec.ExecuteReturnDt(strSQLProc, htParameter, CommandType.StoredProcedure); string fileName = DataTool.SQLGetNameByCode("SYSRESOURCES", "FILE_ID", "FILE_ID", HDLD); object objFileContent = Resource.LoadResource(HDLD); if (drCurrentHD["Loai_Hd"].ToString() == "5") { fileName = DataTool.SQLGetNameByCode("SYSRESOURCES", "FILE_ID", "FILE_ID", HDLD_HL); objFileContent = Resource.LoadResource(HDLD_HL); } if (drCurrentHD["Loai_Hd"].ToString() == "2") { fileName = DataTool.SQLGetNameByCode("SYSRESOURCES", "FILE_ID", "FILE_ID", HDLD2); objFileContent = Resource.LoadResource(HDLD2); } string strFileTemplate = Application.StartupPath + @"\Template\" + fileName; if (objFileContent != null) { FileStream stream = new FileStream(strFileTemplate, FileMode.Create, FileAccess.ReadWrite); stream.Write((byte[])objFileContent, 0, ((byte[])objFileContent).Length); stream.Close(); } else { EpointMessage.MsgOk("Tập tin rỗng"); } HRMCommon.WriteToWordQTTC04(dtResult, strFileTemplate, fileName); } else if (tabDetail.SelectedTab == pageHopDongPL || dgvHopDongPL.Focused)//View phụ lục hợp đồng { if (bdsHopDongPL.Position < 0) { return; } DataRow drCurrentPL = ((DataRowView)bdsHopDongPL.Current).Row; if (drCurrentPL["File_Id"].ToString() != string.Empty) { HDLD_PL = drCurrentPL["File_Id"].ToString(); } string fileName = DataTool.SQLGetNameByCode("SYSRESOURCES", "FILE_ID", "FILE_ID", HDLD_PL); string strFileTemplate = Application.StartupPath + @"\Template\" + fileName; object objFileContent = Resource.LoadResource(HDLD_PL); if (objFileContent != null) { FileStream stream = new FileStream(strFileTemplate, FileMode.Create, FileAccess.ReadWrite); stream.Write((byte[])objFileContent, 0, ((byte[])objFileContent).Length); stream.Close(); } else { EpointMessage.MsgOk("Tập tin rỗng"); } string strSQLProc = "sp_GetHDLDInfo"; Hashtable htParameter = new Hashtable(); htParameter.Add("MA_CBNV", drCurrentPL["Ma_Cbnv"].ToString()); htParameter.Add("SO_HD", string.Empty); htParameter.Add("SO_PL", drCurrentPL["So_Pl"].ToString()); DataTable dtResult = SQLExec.ExecuteReturnDt(strSQLProc, htParameter, CommandType.StoredProcedure); if (dtResult != null && dtResult.Rows.Count > 0) { HRMCommon.WriteToWordQTTC04(dtResult, strFileTemplate, fileName); } else { EpointMessage.MsgOk("Không xuất được báo cáo!"); } } } catch (Exception ex) { EpointMessage.MsgOk(ex.Message); } }
private void FillData(string strKey) { //Hashtable htPara = new Hashtable(); //htPara.Add("USERID", Element.sysUser_Id); //htPara.Add("PARENTFIELDNAME", "MA_KV"); dtEmployee = HRMCommon.GetCustomerTable("MA_KV", cboFill.Text); bdsEmployee.DataSource = dtEmployee; tlDmCbNv.DataSource = bdsEmployee; //bdsEmployee.Position = 0; //GIADINH dtGiaDinh = DataTool.SQLGetDataTable("HRGIADINH", null, strKey, "Nam_Sinh, Loai_QHGD"); bdsGiaDinh.DataSource = dtGiaDinh; dgvGiaDinh.DataSource = bdsGiaDinh; //CONGTAC //dtCongTac = DataTool.SQLGetDataTable("HRCONGTAC", null, strKey, "Ngay_Begin, Ngay_End"); dtCongTac = SQLExec.ExecuteReturnDt("SELECT * FROM HRCONGTAC ORDER BY Ngay_Begin, Ngay_End"); bdsCongTac.DataSource = dtCongTac; dgvCongTac.DataSource = bdsCongTac; //DAOTAO //dtDaoTao = DataTool.SQLGetDataTable("HRDAOTAO", null, strKey, "Ngay_Begin, Ngay_End"); dtDaoTao = SQLExec.ExecuteReturnDt("SELECT * FROM HRDAOTAO ORDER BY Ngay_Begin, Ngay_End"); bdsDaoTao.DataSource = dtDaoTao; dgvBangCap.DataSource = bdsDaoTao; //KHENTHUONG //dtKhenThuong = DataTool.SQLGetDataTable("HRKHENTHUONG", null, strKey, "Ngay_QD, Ngay_HL"); dtKhenThuong = SQLExec.ExecuteReturnDt("SELECT * FROM HRKHENTHUONG ORDER BY Ngay_QD, Ngay_HL"); bdsKhenThuong.DataSource = dtKhenThuong; dgvKhenThuong.DataSource = bdsKhenThuong; //NGHIPHEP //dtNghiPhep = DataTool.SQLGetDataTable("HRNGHIPHEP", null, strKey, "Ngay_Begin, Ngay_End"); dtNghiPhep = SQLExec.ExecuteReturnDt("SELECT * FROM HRNGHIPHEP ORDER BY Ngay_Begin, Ngay_End"); bdsNghiPhep.DataSource = dtNghiPhep; dgvNghiPhep.DataSource = bdsNghiPhep; //PHUCLOI //dtPhucLoi = DataTool.SQLGetDataTable("HRPHUCLOI", null, strKey, "Ngay_Begin, Ngay_End"); dtPhucLoi = SQLExec.ExecuteReturnDt("SELECT * FROM HRPHUCLOI ORDER BY Ngay_Begin, Ngay_End"); bdsPhucLoi.DataSource = dtPhucLoi; dgvPhucLoi.DataSource = bdsPhucLoi; //DANHGIA //dtDanhGia = DataTool.SQLGetDataTable("HRDANHGIA", null, strKey, "Ngay_DG"); dtDanhGia = SQLExec.ExecuteReturnDt("SELECT * FROM HRDANHGIA ORDER BY Ngay_DG"); bdsDanhGia.DataSource = dtDanhGia; dgvDanhGia.DataSource = bdsDanhGia; //KINHNGHIEM //dtKinhNghiem = DataTool.SQLGetDataTable("HRKINHNGHIEM", null, strKey, "Ngay_Begin, Ngay_End"); dtKinhNghiem = SQLExec.ExecuteReturnDt("SELECT * FROM HRKINHNGHIEM ORDER BY Ngay_Begin, Ngay_End"); bdsKinhNghiem.DataSource = dtKinhNghiem; dgvKinhNghiem.DataSource = bdsKinhNghiem; //KYNANG //dtKyNang = DataTool.SQLGetDataTable("HRKYNANG", null, strKey, "Ky_Nang"); dtKyNang = SQLExec.ExecuteReturnDt("SELECT * FROM HRKYNANG ORDER BY Ky_Nang"); bdsKyNang.DataSource = dtKyNang; dgvKyNang.DataSource = bdsKyNang; //TUYENDUNG //dtTuyenDung = DataTool.SQLGetDataTable("HRTUYENDUNG", null, strKey, "Ngay_Pv"); dtTuyenDung = SQLExec.ExecuteReturnDt("SELECT * FROM HRTUYENDUNG ORDER BY Ngay_Pv"); bdsTuyenDung.DataSource = dtTuyenDung; //DAOTAO dtLamViec = DataTool.SQLGetDataTable("HRLAMVIEC", null, strKey, "Ngay_Begin, Ngay_End"); bdsLamViec.DataSource = dtLamViec; dgvLamViec.DataSource = bdsLamViec; //DAOTAO dtQUALIFY = DataTool.SQLGetDataTable("HRQUALIFY", null, strKey, "Ngay_Dat"); bdsQUALIFY.DataSource = dtQUALIFY; dgvQUALIFY.DataSource = bdsQUALIFY; //Tham số các khoản thu nhập string strSQLExec = "SELECT T1.*, T2.Ten_Tn, T2.Dvt FROM HRPARAVALUE0 T1 LEFT JOIN HRPARALIST T2 ON T1.Ma_Tn = T2.Ma_Tn " + " ORDER BY Ngay_Ap"; //Uy quyen cho lop co so tim kiem bdsSearch = bdsEmployee; ExportControl = tlDmCbNv; tlDmCbNv.Expand = (bool)SQLExec.ExecuteReturnValue("SELECT Expand FROM SYSZONE WHERE ZONE = '" + tlDmCbNv.strZone + "'"); }