public DataTable NewActivityList(string activity_type, string emp_id)
{
//1.列出登入者可報名的活動(不限族群or我在這個族群)
//2.報名開始日~報名截止日
//3-1.若是個人活動可以一直報名，第一次是自己第二次之後是幫別人報名
//3-2.若是團隊活動並且報過名就不顯示了，只會顯示在"已報名活動查詢"然後使用編輯模式
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return(mySelectorDAO.NewActivityList(activity_type, emp_id));
}
public List <VO.EmployeeVO> GetEmployeeSelector(string DEPT_ID, string WORK_ID, string NATIVE_NAME, Boolean UnderDept, string COMPANY_CODE)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
List <VO.EmployeeVO> myEmployeeVOList = new List <ACMS.VO.EmployeeVO>();
myEmployeeVOList = mySelectorDAO.GetEmployeeSelector(DEPT_ID, WORK_ID, NATIVE_NAME, UnderDept, COMPANY_CODE);
return(myEmployeeVOList);
}
public DataTable RegistedActivityQuery(string activity_name, string activity_startdate, string activity_enddate, string activity_enddate_finish, string emp_id, string activity_type)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return(mySelectorDAO.RegistedActivityQuery(activity_name, activity_startdate, activity_enddate, activity_enddate_finish, emp_id, activity_type));
//DataTable dt1 = mySelectorDAO.RegistedActivityQuery(activity_name, activity_startdate, activity_enddate, activity_enddate_finish, emp_id, "1");
//DataTable dt2 = mySelectorDAO.RegistedActivityQuery(activity_name, activity_startdate, activity_enddate, activity_enddate_finish, emp_id, "2");
//dt1.Merge(dt2);
//return dt1;
}
public DataTable ActivityCheckQuery(string activity_id, string DEPT_ID, string emp_id, string emp_name,Boolean UnderDept ,string COMPANY_CODE )
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
DataTable DT = mySelectorDAO.ActivityCheckQuery(activity_id, DEPT_ID, emp_id, emp_name,UnderDept,COMPANY_CODE );
try
{
return DT;
}
finally
{
if (DT != null) DT.Dispose();
}
}
public DataTable ActivityEditQuery(string activity_name, string activity_startdate, string activity_enddate)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
DataTable DT = mySelectorDAO.ActivityEditQuery(activity_name, activity_startdate, activity_enddate);
try
{
return DT;
}
finally
{
if (DT != null) DT.Dispose();
}
}
public DataTable ActivityProcessQuery(string activity_id)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
DataTable DT = mySelectorDAO.ActivityProcessQuery(activity_id);
try
{
return DT;
}
finally
{
if (DT != null) DT.Dispose();
}
}
public List <VO.DDLVO> CNAMESelector()
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
List <VO.DDLVO> myDDLVOList = new List <VO.DDLVO>();
VO.DDLVO myDDLVO = new VO.DDLVO();
myDDLVOList = mySelectorDAO.CNAMESelector();
myDDLVO.Value = "";
myDDLVO.Text = "請選擇";
// myDDLVOList.Insert(0, myDDLVO);
return(myDDLVOList);
}
public List <VO.DDLVO> DeptSelectorByCompanyCode(string COMPANYCODE)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
List <VO.DDLVO> myDDLVOList = new List <VO.DDLVO>();
VO.DDLVO myDDLVO = new VO.DDLVO();
myDDLVOList = mySelectorDAO.DeptSelectorByCompanyCode(COMPANYCODE);
myDDLVO.Value = "";
myDDLVO.Text = "請選擇";
myDDLVOList.Insert(0, myDDLVO);
return(myDDLVOList);
}
public List <VO.RoleListVO> SelectRoleList()
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
List <VO.RoleListVO> myRoleListVOList = new List <ACMS.VO.RoleListVO>();
myRoleListVOList = mySelectorDAO.SelectRoleList();
VO.RoleListVO myRoleListVO = new ACMS.VO.RoleListVO();
myRoleListVO.id = null;
myRoleListVO.role_name = "請選擇";
myRoleListVOList.Insert(0, myRoleListVO);
return(myRoleListVOList);
}
public DataTable GetAllActivity()
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
DataTable DT = mySelectorDAO.GetAllActivity();
try
{
return(DT);
}
finally
{
if (DT != null)
{
DT.Dispose();
}
}
}
public DataTable RegistActivity_Query(string activity_name, string activity_startdate, string activity_enddate, string activity_type, string emp_id)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
DataTable DT = mySelectorDAO.RegistActivity_Query(activity_name, activity_startdate, activity_enddate, activity_type, emp_id);
try
{
return(DT);
}
finally
{
if (DT != null)
{
DT.Dispose();
}
}
}
public DataTable ActivityQuery(string activity_startdate, string activity_enddate, string org_id, string querytype, string activity_type)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
DataTable DT = mySelectorDAO.ActivityQuery(activity_startdate, activity_enddate, org_id, querytype, activity_type);
try
{
return(DT);
}
finally
{
if (DT != null)
{
DT.Dispose();
}
}
}
public DataTable ActivityProcessQuery(string activity_id)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
DataTable DT = mySelectorDAO.ActivityProcessQuery(activity_id);
try
{
return(DT);
}
finally
{
if (DT != null)
{
DT.Dispose();
}
}
}
public DataTable ActivityCheckQuery(string activity_id, string DEPT_ID, string emp_id, string emp_name, Boolean UnderDept, string COMPANY_CODE)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
DataTable DT = mySelectorDAO.ActivityCheckQuery(activity_id, DEPT_ID, emp_id, emp_name, UnderDept, COMPANY_CODE);
try
{
return(DT);
}
finally
{
if (DT != null)
{
DT.Dispose();
}
}
}
//4.2該活動與我同團隊的人員選單
/// <summary>
/// 該活動與我同團隊的人員選單
/// </summary>
/// <param name="activity_id">活動代號</param>
/// <param name="emp_id">員工</param>
/// <returns>該活動與我同團隊的人員選單</returns>
public DataTable RegistedMyTeamMemberSelector(Guid activity_id, string emp_id)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return(mySelectorDAO.RegistedMyTeamMemberSelector(activity_id, emp_id));
}
public List<VO.EmployeeVO> GetEmployeeSelector(string DEPT_ID, string WORK_ID, string NATIVE_NAME ,Boolean UnderDept,string COMPANY_CODE)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
List<VO.EmployeeVO> myEmployeeVOList = new List<ACMS.VO.EmployeeVO>();
myEmployeeVOList = mySelectorDAO.GetEmployeeSelector(DEPT_ID, WORK_ID, NATIVE_NAME, UnderDept, COMPANY_CODE);
return myEmployeeVOList;
}
//4.2該活動由管理者的選單
/// <summary>
/// 該活動由管理者的選單
/// </summary>
/// <param name="activity_id">活動代號</param>
/// <param name="DEPT_ID">部門名稱</param>
/// <param name="JOB_GRADE_GROUP">級職</param>
/// <param name="WINDOWS_ID">工號</param>
/// <param name="NATIVE_NAME">中英文名字</param>
/// <param name="SEX">姓名</param>
/// <param name="EXPERIENCE_START_DATE">年資起算日</param>
/// <param name="C_NAME">公司別代號</param>
/// <param name="UnderDept">包含所屬單位</param>
/// <returns>該活動由管理者的選單</returns>
public DataTable RegistedMyTeamMemberSelectorByManage(Guid activity_id, string DEPT_ID, int JOB_GRADE_GROUP, string WINDOWS_ID, string NATIVE_NAME, string SEX, DateTime EXPERIENCE_START_DATE, string C_NAME, Boolean UnderDept)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return(mySelectorDAO.RegistedMyTeamMemberSelectorByManage(activity_id, DEPT_ID, JOB_GRADE_GROUP, WINDOWS_ID, NATIVE_NAME, SEX, EXPERIENCE_START_DATE, C_NAME, UnderDept));
}
public DataTable RegistedByMeEmpSelector(Guid activity_id, string regist_by)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return(mySelectorDAO.RegistedByMeEmpSelector(activity_id, regist_by));
}
public DataTable RegistedActivityQuery(string activity_name, string activity_startdate, string activity_enddate, string activity_enddate_finish, string emp_id , string activity_type )
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return mySelectorDAO.RegistedActivityQuery(activity_name, activity_startdate, activity_enddate, activity_enddate_finish, emp_id,activity_type);
//DataTable dt1 = mySelectorDAO.RegistedActivityQuery(activity_name, activity_startdate, activity_enddate, activity_enddate_finish, emp_id, "1");
//DataTable dt2 = mySelectorDAO.RegistedActivityQuery(activity_name, activity_startdate, activity_enddate, activity_enddate_finish, emp_id, "2");
//dt1.Merge(dt2);
//return dt1;
}
//4.2該活動由管理者的選單
/// <summary>
/// 該活動由管理者的選單
/// </summary>
/// <param name="activity_id">活動代號</param>
/// <param name="DEPT_ID">部門名稱</param>
/// <param name="JOB_GRADE_GROUP">級職</param>
/// <param name="WINDOWS_ID">工號</param>
/// <param name="NATIVE_NAME">中英文名字</param>
/// <param name="SEX">姓名</param>
/// <param name="EXPERIENCE_START_DATE">年資起算日</param>
/// <param name="C_NAME">公司別代號</param>
/// <param name="UnderDept">包含所屬單位</param>
/// <returns>該活動由管理者的選單</returns>
public DataTable RegistedMyTeamMemberSelectorByManage(Guid activity_id, string DEPT_ID, int JOB_GRADE_GROUP, string WINDOWS_ID, string NATIVE_NAME, string SEX, DateTime EXPERIENCE_START_DATE, string C_NAME,Boolean UnderDept)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return mySelectorDAO.RegistedMyTeamMemberSelectorByManage(activity_id, DEPT_ID, JOB_GRADE_GROUP, WINDOWS_ID, NATIVE_NAME, SEX, EXPERIENCE_START_DATE, C_NAME,UnderDept );
}
public DataTable RegistedList(Guid activity_id, string DEPT_ID, int JOB_GRADE_GROUP, string WORK_ID, string NATIVE_NAME, string SEX, DateTime EXPERIENCE_START_DATE, string C_NAME, string RegistedType, Boolean UnderDept)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return(mySelectorDAO.RegistedList(activity_id, DEPT_ID, JOB_GRADE_GROUP, WORK_ID, NATIVE_NAME, SEX, EXPERIENCE_START_DATE, C_NAME, RegistedType, UnderDept));
}
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.RoleListVO> SelectRoleList()
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
List<VO.RoleListVO> myRoleListVOList = new List<ACMS.VO.RoleListVO>();
myRoleListVOList = mySelectorDAO.SelectRoleList();
VO.RoleListVO myRoleListVO = new ACMS.VO.RoleListVO();
myRoleListVO.id = null;
myRoleListVO.role_name = "請選擇";
myRoleListVOList.Insert(0, myRoleListVO);
return myRoleListVOList;
}
public DataTable RegisterPersonInfo(string emp_id)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return mySelectorDAO.RegisterPersonInfo(emp_id);
}
public List<VO.EmployeeVO> RegistableMember(string DEPT_ID, string WORK_ID, string NATIVE_NAME, string activity_id, string activity_type,bool UnderDept,string Company_ID)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return mySelectorDAO.RegistableMember(DEPT_ID, WORK_ID, NATIVE_NAME, activity_id, activity_type, UnderDept,Company_ID );
}
public DataTable RegisterPeopleInfo(string activity_id, string emp_id)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return mySelectorDAO.RegisterPeopleInfo(activity_id, emp_id);
}
public DataTable RegistedList(Guid activity_id, string DEPT_ID, int JOB_GRADE_GROUP, string WORK_ID, string NATIVE_NAME, string SEX, DateTime EXPERIENCE_START_DATE, string C_NAME,string RegistedType,Boolean UnderDept)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return mySelectorDAO.RegistedList(activity_id, DEPT_ID, JOB_GRADE_GROUP, WORK_ID, NATIVE_NAME, SEX, EXPERIENCE_START_DATE, C_NAME, RegistedType,UnderDept );
}
public List <VO.EmployeeVO> EmployeeSelector(string DEPT_ID, string JOB_GRADE_GROUP, string WORK_ID, string NATIVE_NAME, string SEX, string BIRTHDAY_S, string BIRTHDAY_E, string EXPERIENCE_START_DATE, string C_NAME, Guid activity_id, Boolean UnderDept, string COMPANY_CODE)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return(mySelectorDAO.EmployeeSelector(DEPT_ID, JOB_GRADE_GROUP, WORK_ID, NATIVE_NAME, SEX, BIRTHDAY_S, BIRTHDAY_E, EXPERIENCE_START_DATE, C_NAME, activity_id, UnderDept, COMPANY_CODE));
}
public DataTable RegistedByMeEmpSelector(Guid activity_id, string regist_by)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return mySelectorDAO.RegistedByMeEmpSelector(activity_id, regist_by);
}
public DataTable RegisterPeopleInfo(string activity_id, string emp_id)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return(mySelectorDAO.RegisterPeopleInfo(activity_id, emp_id));
}
//4.2該活動與我同團隊的人員選單
/// <summary>
/// 該活動與我同團隊的人員選單
/// </summary>
/// <param name="activity_id">活動代號</param>
/// <param name="emp_id">員工</param>
/// <returns>該活動與我同團隊的人員選單</returns>
public DataTable RegistedMyTeamMemberSelector(Guid activity_id, string emp_id)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return mySelectorDAO.RegistedMyTeamMemberSelector(activity_id, emp_id);
}
public List<VO.EmployeeVO> EmployeeSelector(string DEPT_ID, string JOB_GRADE_GROUP, string WORK_ID, string NATIVE_NAME, string SEX, string BIRTHDAY_S, string BIRTHDAY_E, string EXPERIENCE_START_DATE, string C_NAME, Guid activity_id,Boolean UnderDept,string COMPANY_CODE)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return mySelectorDAO.EmployeeSelector(DEPT_ID, JOB_GRADE_GROUP, WORK_ID, NATIVE_NAME, SEX, BIRTHDAY_S, BIRTHDAY_E, EXPERIENCE_START_DATE, C_NAME, activity_id, UnderDept, COMPANY_CODE);
}
protected void btnExport_Click(object sender, EventArgs e)
{
if (ViewState["activity_id"] == null)
{
return;
}
DataTable table = new DataTable();
DataTable dt = new DataTable();
DataRow dtDr;
try
{
ACMS.DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
//table = mySelectorDAO.ActivityCheckQuery(ViewState["activity_id"].ToString(), ViewState["DEPT_ID"].ToString(), txtemp_id.Text, txtemp_name.Text,cbUnderDept.Checked,ddlC_NAME.SelectedValue );
table = mySelectorDAO.ActivityCheckQuery(ViewState["activity_id"].ToString(), "", "", "", true, "");
if (table.Rows.Count == 0)
{
clsMyObj.ShowMessage("沒有報名資料");
return;
}
//‧進度excel匯出( 依報名編號、部門、工號、姓名、分機、E-MAIL、進度狀態 )
dt.Columns.Add("報名編號", System.Type.GetType("System.String"));
dt.Columns.Add("部門代號", System.Type.GetType("System.String"));
dt.Columns.Add("部門", System.Type.GetType("System.String"));
dt.Columns.Add("工號", System.Type.GetType("System.String"));
dt.Columns.Add("姓名", System.Type.GetType("System.String"));
dt.Columns.Add("分機", System.Type.GetType("System.String"));
dt.Columns.Add("EMAIL", System.Type.GetType("System.String"));
dt.Columns.Add("進度狀態", System.Type.GetType("System.String"));
string teamName = "";
int seqno = 0;
int seqno1 = 0;
foreach (DataRow dr in table.Rows)
{
dtDr = dt.NewRow();
if (dr["activity_type"].ToString() == "2")
{
if (teamName != dr["boss_id"].ToString().Trim())
{
seqno++;
}
if (seqno > int.Parse(dr["team_max"].ToString()))
{
if (teamName != dr["boss_id"].ToString().Trim())
{
seqno1++;
}
}
teamName = dr["boss_id"].ToString().Trim();
}
else
{
seqno++;
if (seqno > int.Parse(dr["team_max"].ToString()))
{
seqno1++;
}
}
if (seqno1 > 0)
{
dtDr["報名編號"] = "備取:" + seqno1.ToString();
}
else
{
dtDr["報名編號"] = "正取:" + seqno.ToString();
}
dtDr["部門代號"] = dr["DEPT_ID"].ToString();
dtDr["部門"] = dr["C_DEPT_NAME"].ToString();
dtDr["工號"] = dr["WORK_ID"].ToString();
dtDr["姓名"] = dr["NATIVE_NAME"].ToString();
dtDr["分機"] = dr["OFFICE_PHONE"].ToString();
dtDr["EMAIL"] = dr["OFFICE_MAIL"].ToString();
dtDr["進度狀態"] = dr["check_status"].ToString();
dt.Rows.Add(dtDr);
}
if (table != null && table.Rows.Count > 0)
{
table.Columns[0].ColumnName = "員工編號";
table.Columns[1].ColumnName = "員工姓名";
table.Columns[2].ColumnName = "員工部門";
table.Columns[3].ColumnName = "登錄狀態";
// 產生 Excel 資料流。
//MemoryStream ms = DataTableRenderToExcel.RenderDataTableToExcel(table) as MemoryStream;
MemoryStream ms = DataTableRenderToExcel.RenderDataTableToExcel(dt) as MemoryStream;
// 設定強制下載標頭。
//Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", Server.UrlEncode("報名登錄狀態")));
Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}.xls", Server.UrlEncode("RegistedStatus")));
// 輸出檔案。
Response.BinaryWrite(ms.ToArray());
ms.Close();
ms.Dispose();
}
else
{
clsMyObj.ShowMessage("沒有資料!");
}
}
catch (Exception ex)
{
WriteErrorLog("ExportDoc", ex.Message, "0");
}
finally
{
if (table != null)
{
table.Dispose();
}
if (dt != null)
{
dt.Dispose();
}
}
}
public DataTable GetAllMyActivity(string emp_id)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
DataTable DT = mySelectorDAO.GetAllMyActivity(emp_id);
try
{
return DT;
}
finally
{
if (DT != null) DT.Dispose();
}
}
public DataTable NewActivityList(string activity_type, string emp_id)
{
//1.列出登入者可報名的活動(不限族群or我在這個族群)
//2.報名開始日~報名截止日
//3-1.若是個人活動可以一直報名，第一次是自己第二次之後是幫別人報名
//3-2.若是團隊活動並且報過名就不顯示了，只會顯示在"已報名活動查詢"然後使用編輯模式
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return mySelectorDAO.NewActivityList(activity_type, emp_id);
}
public List<VO.DDLVO> UnitSelector()
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
List<VO.DDLVO> myDDLVOList = new List<VO.DDLVO>();
VO.DDLVO myDDLVO = new VO.DDLVO();
myDDLVOList = mySelectorDAO.UnitSelector();
myDDLVO.Value = "";
myDDLVO.Text = "請選擇";
myDDLVOList.Insert(0, myDDLVO);
return myDDLVOList;
}
public DataTable RegistActivity_Query(string activity_name, string activity_startdate, string activity_enddate, string activity_type, string emp_id)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
DataTable DT = mySelectorDAO.RegistActivity_Query(activity_name, activity_startdate, activity_enddate, activity_type, emp_id);
try
{
return DT;
}
finally
{
if (DT != null) DT.Dispose();
}
}
public DataTable RegisterPersonInfo(string emp_id)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return(mySelectorDAO.RegisterPersonInfo(emp_id));
}
public DataTable ActivityQuery(string activity_startdate, string activity_enddate, string org_id, string querytype ,string activity_type )
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
DataTable DT = mySelectorDAO.ActivityQuery(activity_startdate, activity_enddate, org_id, querytype, activity_type);
try
{
return DT;
}
finally
{
if (DT != null) DT.Dispose();
}
}
public List <VO.EmployeeVO> RegistableMember(string DEPT_ID, string WORK_ID, string NATIVE_NAME, string activity_id, string activity_type, bool UnderDept, string Company_ID)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
return(mySelectorDAO.RegistableMember(DEPT_ID, WORK_ID, NATIVE_NAME, activity_id, activity_type, UnderDept, Company_ID));
}
public List<VO.DDLVO> DeptSelectorByCompanyCode(string COMPANYCODE)
{
DAO.SelectorDAO mySelectorDAO = new ACMS.DAO.SelectorDAO();
List<VO.DDLVO> myDDLVOList = new List<VO.DDLVO>();
VO.DDLVO myDDLVO = new VO.DDLVO();
myDDLVOList = mySelectorDAO.DeptSelectorByCompanyCode(COMPANYCODE );
myDDLVO.Value = "";
myDDLVO.Text = "請選擇";
myDDLVOList.Insert(0, myDDLVO);
return myDDLVOList;
}