private void BindInit() { myCommon = new ACMS.Utils.Common(); DataTable dt; dt = myCommon.ExecuteQuery("Select strBranchCode,strBranchName from tblBranch Where strBranchCode In (Select strBranchCode from tblemployeebranchrights Where nEmployeeId = " + EmployeeId + ")"); new ManagerBranchCodeLookupEditBuilder(dt, this.lkBranch.Properties); dt = myCommon.ExecuteQuery("Select nEmployeeID, strEmployeeName from tblEmployee"); new ManagerEmployeeIDLookupEditBuilder(dt, this.lkEmployee.Properties); string strSQL = "Select distinct datepart(year,dtDate) as nYearID from tblTimeCard order by datepart(year,dtDate) desc"; comboBind(Year, strSQL, "nYearID", "nYearID", true); Year.SelectedIndex = 0; comboBind(ToYear, strSQL, "nYearID", "nYearID", true); ToYear.SelectedIndex = 0; }
private void frmManager_Load(object sender, System.EventArgs e) { barstaticCurrentLogin.Caption = string.Format(barstaticCurrentLogin.Caption, employee.StrEmployeeName, DateTime.Now.ToString("dd MMMM yyyy")); connectionString = (string)ConfigurationSettings.AppSettings["Main.ConnectionString"]; connection = new SqlConnection(connectionString); TabManager_init(); FontStyle FontStyle001; FontStyle001 = FontStyle.Bold; FontStyle001 = (System.Drawing.FontStyle) System.Convert.ToInt32(FontStyle001)+System.Convert.ToInt32(FontStyle.Underline); Font001 = new Font("Microsoft Sans Serif", 10, FontStyle001); Font002 = new Font("Microsoft Sans Serif", 10, FontStyle.Bold); Font003 = new Font("Microsoft Sans Serif", (float)8.25, FontStyle001); Font004 = new Font("Microsoft Sans Serif", (float)8.25, FontStyle.Bold); myCommon = new ACMS.Utils.Common(); frmRoster = new ACMS.ACMSManager.Human_Resource.frmRosterMain(); frmTimeSheet = new ACMS.ACMSManager.Human_Resource.frmTimeSheetMain(); frmOvertime = new ACMS.ACMSManager.Human_Resource.frmOvertimeMain(); frmHRLeave = new ACMS.ACMSManager.Human_Resource.frmLeave(); frmHRAppointment = new ACMS.ACMSManager.Human_Resource.frmAppointment(); //IPP InitIPP(); LoadIPP(); //Payroll Init_Payroll_cmbJob(); //Master Data mdInit(); Init_Master_lookUp(); }
private void ClassHallInit() { string strSQL; myCommon = new ACMS.Utils.Common(); strSQL = "select nHallNo, strHallName from tblHall"; DataTable dt2 = myCommon.ExecuteQuery(strSQL); new ManagerHallCodeLookupEditBuilder(dt2, comboBoxHall.Properties); if (dt2.Rows.Count > 0) comboBoxHall.EditValue = dt2.Rows[0]["nHallNo"]; }