/// <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;
}
