/// <summary> /// 級職資料 /// </summary> /// <returns>級職資料</returns> public List<VO.DDLVO> JOB_GRADE_GROUPSelector() { StringBuilder sb = new StringBuilder(); sb.AppendLine("SELECT * "); sb.AppendLine("FROM JOB_GRADE_GROUP "); SqlConnection aconn = MyConn(); SqlDataReader MyDataReader = SqlHelper.ExecuteReader(aconn, CommandType.Text, sb.ToString(), null); List<VO.DDLVO> myDDLVOList = new List<ACMS.VO.DDLVO>(); while (MyDataReader.Read()) { VO.DDLVO myDDLVO = new ACMS.VO.DDLVO(); myDDLVO.Value = MyDataReader["GROUP_CODE"].ToString(); myDDLVO.Text = MyDataReader["GROUP_DESCRIPTION"].ToString(); myDDLVOList.Add(myDDLVO); } MyDataReader.Close(); aconn.Close(); if (MyDataReader != null) MyDataReader.Dispose(); if (aconn != null) aconn.Dispose(); return myDDLVOList; }
/// <summary> /// 部門別資料 /// </summary> /// <returns>部門別資料</returns> public List<VO.DDLVO> DeptSelector() { StringBuilder sb = new StringBuilder(); sb.AppendLine("SELECT distinct [DEPT_ID],C_DEPT_NAME,[C_DEPT_ABBR] "); sb.AppendLine("FROM V_ACSM_USER2 "); SqlConnection aconn = MyConn(); SqlDataReader MyDataReader = SqlHelper.ExecuteReader(aconn, CommandType.Text, sb.ToString(), null); List<VO.DDLVO> myDDLVOList = new List<ACMS.VO.DDLVO>(); while (MyDataReader.Read()) { VO.DDLVO myDDLVO = new ACMS.VO.DDLVO(); myDDLVO.Value = (string)MyDataReader["DEPT_ID"]; myDDLVO.Text = (string)MyDataReader["C_DEPT_NAME"]; myDDLVOList.Add(myDDLVO); } MyDataReader.Close(); aconn.Close(); if (MyDataReader != null) MyDataReader.Dispose(); if (aconn != null) aconn.Dispose(); return myDDLVOList; }
/// <summary> /// 部門別資料 /// </summary> /// <param name="COMPANYCODE">公司別代號</param> /// <returns>部門別資料</returns> public List<VO.DDLVO> DeptSelectorByCompanyCode(string COMPANYCODE) { SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@COMPANYCODE", SqlDbType.NVarChar,300); sqlParams[0].Value = COMPANYCODE; StringBuilder sb = new StringBuilder(); sb.AppendLine("SELECT distinct [DEPT_ID],C_DEPT_NAME,[C_DEPT_ABBR] "); sb.AppendLine("FROM V_ACSM_USER2 WHERE COMPANY_CODE=@COMPANYCODE"); SqlConnection aconn = MyConn(); SqlDataReader MyDataReader = SqlHelper.ExecuteReader(aconn, CommandType.Text, sb.ToString(), sqlParams); List<VO.DDLVO> myDDLVOList = new List<ACMS.VO.DDLVO>(); while (MyDataReader.Read()) { VO.DDLVO myDDLVO = new ACMS.VO.DDLVO(); myDDLVO.Value = (string)MyDataReader["DEPT_ID"]; myDDLVO.Text = (string)MyDataReader["C_DEPT_NAME"]; myDDLVOList.Add(myDDLVO); } MyDataReader.Close(); aconn.Close(); if (MyDataReader != null) MyDataReader.Dispose(); if (aconn != null) aconn.Dispose(); return myDDLVOList; }
/// <summary> /// 主辦單位資料 /// </summary> /// <returns> 主辦單位資料</returns> public List<VO.DDLVO> UnitSelector() { StringBuilder sb = new StringBuilder(); sb.AppendLine("SELECT [id],[name] "); sb.AppendLine("FROM Unit "); SqlConnection aconn = MyConn(); SqlDataReader MyDataReader = SqlHelper.ExecuteReader(aconn, CommandType.Text, sb.ToString(), null); List<VO.DDLVO> myDDLVOList = new List<ACMS.VO.DDLVO>(); while (MyDataReader.Read()) { VO.DDLVO myDDLVO = new ACMS.VO.DDLVO(); myDDLVO.Value = MyDataReader["id"].ToString(); myDDLVO.Text = MyDataReader["name"].ToString(); myDDLVOList.Add(myDDLVO); } MyDataReader.Close(); aconn.Close(); if (MyDataReader != null) MyDataReader.Dispose(); if (aconn != null) aconn.Dispose(); return myDDLVOList; }