/// <summary> /// 主辦單位資料 /// </summary> /// <returns>主辦單位資料</returns> public List <VO.UnitVO> SelectUnit() { StringBuilder sb = new StringBuilder(); sb.AppendLine("SELECT *"); sb.AppendLine("FROM Unit A "); SqlConnection aconn = MyConn(); IDataReader myIDataReader = SqlHelper.ExecuteReader(aconn, CommandType.Text, sb.ToString(), null); List <VO.UnitVO> myUnitVOList = new List <ACMS.VO.UnitVO>(); while (myIDataReader.Read()) { VO.UnitVO myUnitVO = new ACMS.VO.UnitVO(); myUnitVO.id = (int)myIDataReader["id"]; myUnitVO.name = (string)myIDataReader["name"]; myUnitVO.active = (string)myIDataReader["active"]; myUnitVOList.Add(myUnitVO); } myIDataReader.Close(); aconn.Close(); if (myIDataReader != null) { myIDataReader.Dispose(); } if (aconn != null) { aconn.Dispose(); } return(myUnitVOList); }
public List <VO.UnitVO> SelectUnit() { DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO(); List <VO.UnitVO> myUnitVOList = new List <ACMS.VO.UnitVO>(); myUnitVOList = mySelectorDAO.SelectUnit(); VO.UnitVO myUnitVO = new ACMS.VO.UnitVO(); myUnitVO.id = null; myUnitVO.name = "請選擇"; myUnitVOList.Insert(0, myUnitVO); return(myUnitVOList); }
public List<VO.UnitVO> SelectUnit() { DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO(); List<VO.UnitVO> myUnitVOList = new List<ACMS.VO.UnitVO>(); myUnitVOList = mySelectorDAO.SelectUnit(); VO.UnitVO myUnitVO = new ACMS.VO.UnitVO(); myUnitVO.id = null; myUnitVO.name = "請選擇"; myUnitVOList.Insert(0, myUnitVO); return myUnitVOList; }
/// <summary> /// 主辦單位資料 /// </summary> /// <returns>主辦單位資料</returns> public List<VO.UnitVO> SelectUnit() { StringBuilder sb = new StringBuilder(); sb.AppendLine("SELECT *"); sb.AppendLine("FROM Unit A "); SqlConnection aconn = MyConn(); IDataReader myIDataReader = SqlHelper.ExecuteReader(aconn, CommandType.Text, sb.ToString(), null); List<VO.UnitVO> myUnitVOList = new List<ACMS.VO.UnitVO>(); while (myIDataReader.Read()) { VO.UnitVO myUnitVO = new ACMS.VO.UnitVO(); myUnitVO.id = (int)myIDataReader["id"]; myUnitVO.name = (string)myIDataReader["name"]; myUnitVO.active = (string)myIDataReader["active"]; myUnitVOList.Add(myUnitVO); } myIDataReader.Close(); aconn.Close(); if (myIDataReader != null) myIDataReader.Dispose(); if (aconn != null) aconn.Dispose(); return myUnitVOList; }
//6-1 主辦單位設定 主辦單位 DDL DataSource /// <summary> /// 取得主辦單位資料 /// </summary> /// <returns>取得主辦單位資料</returns> public List<VO.UnitVO> SelectUnit() { StringBuilder sb = new StringBuilder(); sb.AppendLine("SELECT *"); sb.AppendLine("FROM Unit A "); sb.AppendLine("WHERE active='Y' "); sb.AppendLine("and( "); sb.AppendLine(string.Format("id in (select unit_id from RoleUserMapping where emp_id='{0}') ", clsAuth.ID)); sb.AppendLine(string.Format("or 0 in (select unit_id from RoleUserMapping where emp_id='{0}') ", clsAuth.ID)); sb.AppendLine("); "); SqlConnection aconn = MyConn(); IDataReader myIDataReader = SqlHelper.ExecuteReader(aconn, CommandType.Text, sb.ToString(), null); List<VO.UnitVO> myUnitVOList = new List<ACMS.VO.UnitVO>(); while (myIDataReader.Read()) { VO.UnitVO myUnitVO = new ACMS.VO.UnitVO(); myUnitVO.id = (int)myIDataReader["id"]; myUnitVO.name = (string)myIDataReader["name"]; myUnitVOList.Add(myUnitVO); } myIDataReader.Close(); aconn.Close(); if (myIDataReader != null) myIDataReader.Dispose(); if (aconn != null) aconn.Dispose(); return myUnitVOList; }