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