예제 #1
0
        public void prcDisplayDetails(string strParam)
        {
            clsConnection clsCon = new clsConnection();

            dsDetail = new System.Data.DataSet();
            try
            {
                string sqlQuery = "Exec prcGetPermission_Salary  " + Common.Classes.clsMain.intComId + "," + Int32.Parse(strParam) + "";
                clsCon.GTRFillDatasetWithSQLCommand(ref dsDetail, sqlQuery);
                dsDetail.Tables[0].TableName = "tblSalary";
                DataRow dr;

                if (dsDetail.Tables["tblSalary"].Rows.Count > 0)
                {
                    dr = dsDetail.Tables["tblSalary"].Rows[0];

                    txtMenu.Text     = dr["aID"].ToString();
                    txtId.Text       = dr["LUserID"].ToString();
                    txtUserName.Text = dr["LUserName"].ToString();
                    cboName.Text     = clsProc.GTRDecryptWord(dr["LUserName"].ToString());
                    //cboName.Text = dr["LUserName"].ToString();
                    cboComp.Text = dr["comName"].ToString();

                    //txtEmpName.Text = dr["EmpName"].ToString();
                    txtAmount.Text = dr["Amount"].ToString();


                    if (dr["isActiveSalary"].ToString() == "1")
                    {
                        chkActiveSalary.Checked = true;
                    }
                    else
                    {
                        chkActiveSalary.Checked = false;
                    }

                    if (dr["isActiveSalaryLess"].ToString() == "1")
                    {
                        chkActiveSalaryLess.Checked = true;
                    }
                    else
                    {
                        chkActiveSalaryLess.Checked = false;
                    }

                    if (dr["isActiveSalaryOver"].ToString() == "1")
                    {
                        chkActiveSalaryOver.Checked = true;
                    }
                    else
                    {
                        chkActiveSalaryOver.Checked = false;
                    }

                    this.btnSave.Text = "&Update";
                }
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            finally
            {
                clsCon = null;
            }
        }