コード例 #1
0
        public void GetPopupContrpls()
        {
            objHRInfo = new HRInfo();
            DataTable dtBranch = objHRInfo.GetAllBranchList(CommonData.CompanyCode, "BR", "").Tables[0];

            UtilityLibrary.PopulateControl(cmbBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
            objHRInfo = null;
        }
コード例 #2
0
 private void cbCompany_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (cbCompany.SelectedIndex > 0)
     {
         objHRInfo = new HRInfo();
         UtilityLibrary.PopulateControl(cbBranch, objHRInfo.GetAllBranchList(cbCompany.SelectedValue.ToString(), "BR", "").Tables[0].DefaultView, 1, 0, "-- Please Select --", 0);
         objHRInfo = null;
     }
 }
コード例 #3
0
 private void cmbCompany_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (cmbCompany.SelectedIndex > 0)
     {
         objHrInfo = new HRInfo();
         DataTable dtBranch = objHrInfo.GetAllBranchList(cmbCompany.SelectedValue.ToString(), "BR", "").Tables[0];
         UtilityLibrary.PopulateControl(cmbBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
         objHrInfo = null;
     }
 }
コード例 #4
0
 private void cbCompany_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (cbCompany.SelectedIndex > 0)
     {
         objHRInfo = new HRInfo();
         UtilityLibrary.PopulateControl(cbBranch, objHRInfo.GetAllBranchList(cbCompany.SelectedValue.ToString(), "BR", "").Tables[0].DefaultView, 1, 0, "--Please Select--", 0);
         objHRInfo = null;
         objSQLDB  = new SQLDB();
         string sqlQry = "SELECT PM_PRODUCT_ID,PM_PRODUCT_NAME from dbo.PRODUCT_MAS a inner join product_mas_company b on a.pm_product_id=b.pmc_product_id where pmc_product_company='" + cbCompany.SelectedValue.ToString() + "'";
         UtilityLibrary.PopulateControl(cmbProducts, objSQLDB.ExecuteDataSet(sqlQry).Tables[0].DefaultView, 1, 0, "-- Please Select --", 0);
         objSQLDB = null;
     }
 }
コード例 #5
0
        public void GetPopup()
        {
            string sqlQry = "SELECT LevelsDesig_mas.LDM_DESIG_ID as desig_id, LevelsDesig_mas.ldm_designations, LevelsDesig_mas.ldm_elevel_id as elevel_id " +
                            " FROM [dbo].[LevelsDesig_mas] WHERE dbo.LevelsDesig_mas.ldm_company_code = '" + CommonData.CompanyCode + "' ORDER BY ldm_designations ";

            objSQLDB  = new SQLDB();
            dsDesgLvl = objSQLDB.ExecuteDataSet(sqlQry);
            UtilityLibrary.PopulateControl(cbddlEORADesig, objSQLDB.ExecuteDataSet(sqlQry).Tables[0].DefaultView, 1, 0, "--Please Select--", 0);
            objSQLDB = null;

            objHrInfo = new HRInfo();
            DataTable dtBranch = objHrInfo.GetAllBranchList(CommonData.CompanyCode, "", "").Tables[0];

            UtilityLibrary.PopulateControl(cbddlBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
            objHrInfo = null;
        }
コード例 #6
0
        private void ActivityServiceUpdate_Load(object sender, EventArgs e)
        {
            btnUpdate.Visible = false;
            DataSet   dsFinYear = new DataSet();
            DataTable dtfinYear = new DataTable();
            DataTable dtBranch  = new DataTable();

            gvProductDetails.DefaultCellStyle.Font = new System.Drawing.Font("Microsoft Sans Serif", 9,
                                                                             System.Drawing.FontStyle.Regular);


            objHRInfo = new HRInfo();
            if (sCompany.Length > 0)
            {
                dtBranch = objHRInfo.GetAllBranchList(sCompany, "BR", "").Tables[0];
            }
            else
            {
                dtBranch = objHRInfo.GetAllBranchList(CommonData.CompanyCode, "BR", "").Tables[0];
            }
            UtilityLibrary.PopulateControl(cmbBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
            objHRInfo             = null;
            objServiceDB          = new ServiceDB();
            dsEmployee            = objServiceDB.GetInvocieInfoforService("", "", "", "", 103);
            objServiceDB          = null;
            objSQLdb              = new SQLDB();
            dsFinYear             = objSQLdb.ExecuteDataSet("SELECT DISTINCT FY_FIN_YEAR FROM FIN_YEAR");
            dtfinYear             = dsFinYear.Tables[0];
            cmbFinYear.DataSource = null;
            if (dtfinYear.Rows.Count > 0)
            {
                cmbFinYear.DataSource    = dtfinYear;
                cmbFinYear.DisplayMember = "FY_FIN_YEAR";
                cmbFinYear.ValueMember   = "FY_FIN_YEAR";

                cmbFinYear.SelectedIndex = 0;
                cmbFinYear.SelectedValue = CommonData.FinancialYear;

                if (sFinYear.Length > 0)
                {
                    cmbFinYear.SelectedValue = sFinYear;
                }
            }
            btnUpdate.Enabled             = false;
            btnClear.Enabled              = false;
            btnAddReplDetails.Visible     = false;
            btnAddCountingDetails.Visible = false;

            if (sBranCode.Length > 0)
            {
                cmbBranch.SelectedValue = sBranCode.Split('@')[0];
            }
            else
            {
                if (CommonData.BranchType == "BR")
                {
                    cmbBranch.SelectedValue = CommonData.BranchCode;
                }
                else
                {
                    cmbBranch.SelectedIndex = 0;
                }
            }

            if (strTrnNo.Length > 0)
            {
                GetAllInvoicdeData(strTrnNo, "");
                txtOrderNo_Validated(null, null);
            }
        }