private void txtContCode_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select distinct ContCode,ContName From MastCont Where CompCode ='01' "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "ContCode", "ContCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtContCode.Text = obj.ElementAt(0).ToString(); } } }
private void txtEmpUnqID_KeyDown(object sender, KeyEventArgs e) { if (txtCompCode.Text.Trim() == "") { return; } if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2 || e.KeyCode == Keys.F3 || e.KeyCode == Keys.F4) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select EmpUnqID,EmpName,FatherName,WrkGrp,Active,CompCode From MastEmp Where CompCode ='" + txtCompCode.Text.Trim() + "' "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "EmpUnqID", "EmpUnqID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else if (e.KeyCode == Keys.F2) { obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else if (e.KeyCode == Keys.F3) { obj = (List <string>)hlp.Show(sql, "WrkGrp", "WrkGrp", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else if (e.KeyCode == Keys.F4) { sql = "Select EmpUnqID,EmpName,FatherName,WrkGrp,Active,CompCode From MastEmp Where CompCode ='" + txtCompCode.Text.Trim() + "' and Active = 1 "; obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtCompCode.Text = obj.ElementAt(5).ToString(); txtEmpUnqID.Text = obj.ElementAt(0).ToString(); txtEmpUnqID_Validated(sender, e); } } }
private void txtDeptCode_KeyDown(object sender, KeyEventArgs e) { if (txtWrkGrpCode.Text.Trim() == "" || txtUnitCode.Text.Trim() == "") { txtWrkGrpCode.Text = ""; txtWrkGrpDesc.Text = ""; txtUnitCode.Text = ""; txtUnitDesc.Text = ""; txtDeptCode.Text = ""; txtDeptDesc.Text = ""; txtStatCode.Text = ""; txtStatDesc.Text = ""; return; } if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select DeptCode,DeptDesc From MastDept Where CompCode ='01' " + " and WrkGrp = '" + txtWrkGrpCode.Text.Trim() + "' and UnitCode ='" + txtUnitCode.Text.Trim() + "'"; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "DeptCode", "DeptCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "DeptDesc", "DeptDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtDeptCode.Text = obj.ElementAt(0).ToString(); txtDeptDesc.Text = obj.ElementAt(1).ToString(); } } }
private void txtID_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select SubScriptionID,EmailTo,EmailCopy,BCCTo from AutoMailSubscription where 1 = 1"; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "SubScriptionID", "SubScriptionID", typeof(int), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else if (e.KeyCode == Keys.F2) { obj = (List <string>)hlp.Show(sql, "EmailTo", "EmailTo", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else if (e.KeyCode == Keys.F3) { obj = (List <string>)hlp.Show(sql, "EmailCopy", "EmailCopy", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else if (e.KeyCode == Keys.F4) { obj = (List <string>)hlp.Show(sql, "BccTo", "BccTo", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtID.Text = obj.ElementAt(0).ToString(); txtEmail.Text = obj.ElementAt(1).ToString(); txtID_EditValueChanged(sender, e); mode = "OLD"; } } }
private void txtEmpUnqID_KeyDown(object sender, KeyEventArgs e) { if (string.IsNullOrEmpty(txtPayPeriod.Text.Trim())) { return; } if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select EmpUnqID,EmpName,PayPeriod from Cont_MastEmp " + " Where PayPeriod = '" + txtPayPeriod.Text.Trim() + "'"; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "EmpUnqID", "EmpUnqID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else if (e.KeyCode == Keys.F2) { obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { txtEmpUnqID.Text = ""; txtEmpName.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "0") { txtEmpUnqID.Text = ""; txtEmpName.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "") { txtEmpUnqID.Text = ""; txtEmpName.Text = ""; return; } else { txtEmpUnqID.Text = obj.ElementAt(0).ToString(); txtEmpName.Text = obj.ElementAt(1).ToString(); } } }
private void txtUserID_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select UserID,UserName,Pass,Active From Cont_MastUser Where Active = 1 "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "UserID", "UserID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else if (e.KeyCode == Keys.F2) { obj = (List <string>)hlp.Show(sql, "UserName", "UserName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 200, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtUserID.Text = obj.ElementAt(0).ToString(); txtPersonName.Text = obj.ElementAt(1).ToString(); txtPassword.Text = obj.ElementAt(2).ToString(); if (obj.ElementAt(3).ToString().Trim() == "1") { chkActive.Checked = true; } else { chkActive.Checked = false; } mode = "OLD"; } } }
private void txtPayPeriod_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select PayPeriod,PayDesc,FromDt,ToDt from Cont_MastPayPeriod Where 1 = 1 Order by PayPeriod Desc "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "PayPeriod", "PayPeriod", typeof(int), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { txtPayPeriod.Text = ""; txtPayDesc.Text = ""; txtFromDt.EditValue = null; txtToDt.EditValue = null; return; } else if (obj.ElementAt(0).ToString() == "0") { txtPayPeriod.Text = ""; txtPayDesc.Text = ""; txtFromDt.EditValue = null; txtToDt.EditValue = null; return; } else if (obj.ElementAt(0).ToString() == "") { txtPayPeriod.Text = ""; txtPayDesc.Text = ""; txtFromDt.EditValue = null; txtToDt.EditValue = null; return; } else { txtPayPeriod.Text = obj.ElementAt(0).ToString(); txtPayDesc.Text = obj.ElementAt(1).ToString(); } } }
private void txtID_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select SrNo,UserID,WrkGrp,FormID from UserSpRight Where active = 1"; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "SrNo", "SrNo", typeof(int), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "UserID", "UserID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtID.Text = obj.ElementAt(0).ToString(); txtUserID.Text = obj.ElementAt(1).ToString(); txtWrkGrpCode.Text = obj.ElementAt(2).ToString(); txtModuleID.Text = obj.ElementAt(3).ToString(); txtID_Validated(sender, e); mode = "OLD"; } } }
private void txtPayPeriod_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; if (defSet) { sql = "Select distinct PayPeriod,'Default Settings' as PayDesc from Cont_ParaMast Where PayPeriod = 0 "; } else { sql = "Select PayPeriod,PayDesc,FromDt,ToDt from Cont_MastPayPeriod Where 1 = 1 "; } if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "PayPeriod", "PayPeriod", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { txtPayPeriod.Text = ""; txtPayDesc.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "0") { txtPayPeriod.Text = obj.ElementAt(0).ToString(); txtPayDesc.Text = obj.ElementAt(1).ToString(); return; } else if (obj.ElementAt(0).ToString() == "") { txtPayPeriod.Text = ""; txtPayDesc.Text = ""; return; } else { txtPayPeriod.Text = obj.ElementAt(0).ToString(); txtPayDesc.Text = obj.ElementAt(1).ToString(); } } }
private void txtSupervisorCode_KeyDown(object sender, KeyEventArgs e) { string sql = ""; string cnstr = "Data Source = 172.16.12.47;Initial Catalog=Attendance;User ID=attd;Password=attd123;"; sql = "Select EmpUnqID ,EmpName ,WrkGrp,EmpCode from MastEmp where Active = 1 and WrkGrp = 'Comp'"; if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "EmpUnqID", "EmpUnqID", typeof(string), cnstr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), cnstr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { txtSupervisorCode.Text = ""; txtSuperVisorName.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "") { txtSupervisorCode.Text = ""; txtSuperVisorName.Text = ""; return; } else { txtSupervisorCode.Text = obj.ElementAt(0).ToString(); txtSuperVisorName.Text = obj.ElementAt(1).ToString(); } } }
private void txtMachineIP_KeyDown(object sender, KeyEventArgs e) { if (txtCompCode.Text.Trim() == "" || txtUnitCode.Text.Trim() == "" || txtMessCode.Text.Trim() == "") { return; } if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select MachineIP,MachineDesc from ReaderConfig Where CompCode ='" + txtCompCode.Text.Trim() + "' "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "MachineIP", "MachineIP", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "MachineDesc", "MachineDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtMachineIP.Text = obj.ElementAt(0).ToString(); } } }
private void txtShiftCode_KeyDown(object sender, KeyEventArgs e) { if (ctrlEmp1.txtCompCode.Text.Trim() == "") { return; } if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select ShiftCode,ShiftDesc from MastShift Where CompCode ='" + ctrlEmp1.txtCompCode.Text.Trim() + "' "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "ShiftCode", "ShiftCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "ShiftDesc", "ShiftDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtShiftCode.Text = obj.ElementAt(0).ToString(); txtShiftDesc.Text = obj.ElementAt(1).ToString(); } } }
private void txtID_KeyDown(object sender, KeyEventArgs e) { if (ctrlEmp1.txtCompCode.Text.Trim() == "" || ctrlEmp1.txtWrkGrpCode.Text.Trim() == "" || ctrlEmp1.txtEmpUnqID.Text.Trim() == "" ) { return; } if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select ID,MisConDt,MisConDesc From MastEmpMisConduct Where EmpUnqID ='" + ctrlEmp1.txtEmpUnqID.Text.Trim() + "' and DelFlg = 0 "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "ID", "ID", typeof(int), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtID.Text = obj.ElementAt(0).ToString(); txtID_Validated(sender, e); mode = "OLD"; } } }
private void txtRuleID_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select RuleID,WrkGrp,Rules,RuleRepl from AttdRules Where 1 = 1"; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "RuleID", "RuleID", typeof(int), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "Rules", "Rules", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtRuleID.Text = obj.ElementAt(0).ToString(); txtWrkGrpCode.Text = obj.ElementAt(1).ToString(); txtRules.Text = obj.ElementAt(2).ToString(); txtRuleRepl.Text = obj.ElementAt(3).ToString(); mode = "OLD"; } } }
private void txtLeaveTyp_KeyDown(object sender, KeyEventArgs e) { if (txtCompCode.Text.Trim() == "" || txtWrkGrpCode.Text.Trim() == "") { return; } if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select LeaveTyp,LeaveDesc from MastLeave Where " + " CompCode ='" + txtCompCode.Text.Trim() + "' and " + " WrkGrp ='" + txtWrkGrpCode.Text.Trim() + "' "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "LeaveTyp", "LeaveTyp", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtLeaveTyp.Text = obj.ElementAt(0).ToString(); txtDescription.Text = obj.ElementAt(1).ToString(); mode = "OLD"; } } }
private void txtEmpUnqID_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2 || e.KeyCode == Keys.F3) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select EmpUnqID,EmpName,WrkGrp,GradeDesc From v_EmpMast Where CompCode ='01' "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "EmpUnqID", "EmpUnqID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else if (e.KeyCode == Keys.F2) { obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "GradeDesc", "GradeDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtEmpUnqID.Text = obj.ElementAt(0).ToString(); txtEmpUnqID_Validated(sender, e); } } }
private void txtSrNo_KeyDown(object sender, KeyEventArgs e) { if (string.IsNullOrEmpty(txtToolsID.Text.Trim())) { MessageBox.Show("Please Save record first, than enter inspection types", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select SrNo,InspTypeDesc,ToolsID From V_Tools_Insp_History Where ToolsID = '" + txtToolsID.Text.Trim() + "'"; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "SrNo", "SrNo", typeof(int), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "InspTypeDesc", "InspTypeDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtSrNo.Text = obj.ElementAt(0).ToString(); } } }
private void txtEmpUnqID_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select EmpUnqID,EmpName,ContCode from MastEmp Where CompCode = '01' and WrkGrp = 'Cont' and Active = 1"; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "EmpUnqID", "EmpUnqID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { txtEmpUnqID.Text = ""; txtEmpName.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "0") { txtEmpUnqID.Text = ""; txtEmpName.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "") { txtEmpUnqID.Text = ""; txtEmpName.Text = ""; return; } else { txtEmpUnqID.Text = obj.ElementAt(0).ToString(); txtEmpName.Text = obj.ElementAt(1).ToString(); } } }
private void txtDedCode_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select 'MESS' as DedCode , '*' Union Select 'MISC' as DedCode, '*' "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "DedCode", "DedCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { txtDedCode.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "0") { txtDedCode.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "") { txtDedCode.Text = ""; return; } else { txtDedCode.Text = obj.ElementAt(0).ToString(); txtDedCode_Validated(sender, e); } } }
private void txtCostCode_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select CostCode,CostDesc From MastCostCode Where 1 = 1"; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "CostCode", "CostCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "CostDesc", "CostDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtCostCode.Text = obj.ElementAt(0).ToString(); txtDescription.Text = obj.ElementAt(1).ToString(); mode = "OLD"; } } }
private void txtPshift_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2 || e.KeyCode == Keys.F3) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "select ShiftCode,'*' as t from MastShift where ShiftStart in ( " + " SELECT [ShiftStart] FROM MastShift " + " group by CompCode,ShiftStart " + " having count(*) >= 2) "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "ShiftCode", "ShiftCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { txtPshift.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "0") { txtPshift.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "") { txtPshift.Text = ""; return; } else { txtPshift.Text = obj.ElementAt(0).ToString(); } } }
private void txtGroupCode_KeyDown(object sender, KeyEventArgs e) { if (txtCompCode.Text.Trim() == "" || txtWrkGrpCode.Text.Trim() == "") { return; } if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select GroupCode,GroupDesc From PBO_GroupMaster Where WrkGrp = '" + txtWrkGrpCode.Text.Trim() + "' "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "GroupCode", "GroupCode", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtGroupCode.Text = obj.ElementAt(0).ToString(); txtGroupDesc.Text = obj.ElementAt(1).ToString(); mode = "OLD"; } } }
private void txtModID_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select FormID,FormName From Cont_MastFrm where 1 = 1 "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "FormID", "FormID", typeof(int), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else if (e.KeyCode == Keys.F2) { obj = (List <string>)hlp.Show(sql, "FormName", "FormName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 200, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtModID.Text = obj.ElementAt(0).ToString(); txtModName.Text = obj.ElementAt(1).ToString(); } } }
private void txtReasonCode_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select ReasonCode,ReasonDesc,PenaltyAmt From MastReason Where 1 =1 "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "ReasonCode", "ReasonCode", typeof(int), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "ReasonDesc", "ReasonDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtReasonCode.Text = obj.ElementAt(0).ToString(); txtReasonDesc.Text = obj.ElementAt(1).ToString(); } } }
private void txtEmailAccount_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select EmailAccount,EmailID From EmailConfig Where 1 =1 "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "EmailAccount", "EmailAccount", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "EmailID", "EmailID", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtEmailAccount.Text = obj.ElementAt(0).ToString(); txtAccountPassword.Text = obj.ElementAt(1).ToString(); } } }
private void txtWrkGrpCode_KeyDown(object sender, KeyEventArgs e) { if (txtRules.Text.Trim() == "") { return; } if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select WrkGrp,WrkGrpDesc From MastWorkGrp Where 1 = 1 "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "WrkGrp", "WrkGrp", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtWrkGrpCode.Text = obj.ElementAt(0).ToString(); txtWrkGrpDesc.Text = obj.ElementAt(1).ToString(); } } }
private void txtSrNo_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select SrNo,EmpName,WrkGrp,ContCode From MastPreJoin Where 1=1 "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "SrNo", "SrNo", typeof(int), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "EmpName", "EmpName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtSrNo.Text = obj.ElementAt(0).ToString(); txtSrNo_Validated(sender, e); } } }
private void txtTrID_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select ID,ViolationDt,ViolationDesc,DefaulterType,DefaulterCode,DefaulterName From ViolationDt Where DelFlg = 0 "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "ID", "ID", typeof(int), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "DefaulterName", "DefaulterName", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtTrID.Text = obj.ElementAt(0).ToString(); } } }
private void txtInMachine_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select MachineIP,MachineDesc From ReaderConfig Where Active = 1 and CanteenFlg = 0 and IOFLG = 'I' and LunchInOut = 1 "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "MachineIP", "MachineIP", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } else { obj = (List <string>)hlp.Show(sql, "MachineDesc", "MachineDesc", typeof(string), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { return; } else if (obj.ElementAt(0).ToString() == "0") { return; } else if (obj.ElementAt(0).ToString() == "") { return; } else { txtInMachine.Text = obj.ElementAt(0).ToString(); } } }
private void txtContCode_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F1 || e.KeyCode == Keys.F2) { List <string> obj = new List <string>(); Help_F1F2.ClsHelp hlp = new Help_F1F2.ClsHelp(); string sql = ""; sql = "Select Distinct ContCode,ContDesc from Cont_MastEmp Where PayPeriod = '" + txtPayPeriod.Text.Trim() + "' Order by ContCode Asc "; if (e.KeyCode == Keys.F1) { obj = (List <string>)hlp.Show(sql, "ContCode", "ContCode", typeof(int), Utils.Helper.constr, "System.Data.SqlClient", 100, 300, 400, 600, 100, 100); } if (obj.Count == 0) { txtContCode.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "0") { txtContCode.Text = ""; return; } else if (obj.ElementAt(0).ToString() == "") { txtContCode.Text = ""; return; } else { txtContCode.Text = obj.ElementAt(0).ToString(); } } }