/// <summary>
/// Program
/// </summary>
/// <returns></returns>
public static List <SSoft.MVC.DisplayValue> DDDW_Program()
{
List <SSoft.MVC.DisplayValue> returnList = new List <SSoft.MVC.DisplayValue>();
DataTable dt = SSoft.Data.SqlHelper.SelectTable(@"select 0 as ProgramId,'Login' as ProgramNo,'登入' as ProgramName
union
select ProgramId,ProgramNo,ProgramName
from (SELECT WebUserTab.WUTab_Id as SystemId, WebUserTab.WUTab_Name as SystemName, WebUserPage.WUPage_Id as ProgramId, WebUserPage.WUPage_No as ProgramNo,
WebUserPage.WUPage_Name as ProgramName, WebUserPage.WUPage_Type as ProgramType, WebUserPage.WUPage_Path as ProgramPath,
isnull(WebUserPage.WUPage_Order,0) as ProgarmOrder, WebUserTab.Note, WebUserPage.Note AS Expr1
FROM WebUserTab INNER JOIN
WebUserPage ON WebUserTab.WUTab_Id = WebUserPage.WUPage_TabId) as ProgramList
" );
for (int i = 0; i < dt.Rows.Count; i++)
{
SSoft.MVC.DisplayValue displayValue = new SSoft.MVC.DisplayValue()
{
Int01 = Convert.ToInt32(dt.Rows[i]["ProgramId"]), Value = Convert.ToString(dt.Rows[i]["ProgramId"]), Display = Convert.ToString(dt.Rows[i]["ProgramName"])
};
returnList.Add(displayValue);
}
return(returnList);
}
/// <summary>
/// UserInfo
/// </summary>
/// <returns></returns>
public static List <SSoft.MVC.DisplayValue> DDDW_UserInfo()
{
List <SSoft.MVC.DisplayValue> returnList = new List <SSoft.MVC.DisplayValue>();
DataTable dt = SSoft.Data.SqlHelper.SelectTable(@"SELECT UserInfo_NO, UserInfo_Id, UserInfo_AD, UserInfo_Name, UserInfo_Email, UserInfo_Phone
FROM UserInfo ORDER BY UserInfo_AD ");
for (int i = 0; i < dt.Rows.Count; i++)
{
SSoft.MVC.DisplayValue displayValue = new SSoft.MVC.DisplayValue()
{
Value = Convert.ToString(dt.Rows[i]["UserInfo_Id"]), Display = Convert.ToString(dt.Rows[i]["UserInfo_AD"]) + "[" + Convert.ToString(dt.Rows[i]["UserInfo_Name"]) + "]",
Display1 = Convert.ToString(dt.Rows[i]["UserInfo_Name"]),
Display2 = Convert.ToString(dt.Rows[i]["UserInfo_Email"]),
Display3 = Convert.ToString(dt.Rows[i]["UserInfo_Phone"]),
Int01 = Convert.ToInt32(dt.Rows[i]["UserInfo_NO"])
};
returnList.Add(displayValue);
}
return(returnList);
}