/// <summary>
/// Setting 選單
/// </summary>
/// <returns></returns>
public static IEnumerable <SelectListItem> SettingOption(string UserID, string CustomerName = "", string Format = "", string selected = "")
{
var items = new List <SelectListItem>();
items.Add(new SelectListItem {
Text = "-Please Select-", Value = ""
});
if (string.IsNullOrEmpty(CustomerName) || string.IsNullOrEmpty(Format))
{
return(items);
}
if (Format.Equals("XML"))
{
using (tblXMLSettingRepository rep = new tblXMLSettingRepository())
{
List <tblXMLSetting> setting = rep.getByCustomer(UserID, CustomerName).ToList();
foreach (var s in setting)
{
items.Add(item: new SelectListItem()
{
Value = s.XMLName,
Text = s.XMLName,
Selected = (string.IsNullOrEmpty(selected)) ? false : selected.Equals(s.XMLName, StringComparison.OrdinalIgnoreCase)
});
}
}
}
else if (Format.Equals("EXCEL"))
{
using (tblExcelSettingRepository rep = new tblExcelSettingRepository())
{
List <tblExcelSetting> setting = rep.getByCustomer(UserID, CustomerName).ToList();
foreach (var s in setting)
{
items.Add(item: new SelectListItem()
{
Value = s.ExcelName,
Text = s.ExcelName,
Selected = (string.IsNullOrEmpty(selected)) ? false : selected.Equals(s.ExcelName, StringComparison.OrdinalIgnoreCase)
});
}
}
}
return(items);
}
public ActionResult LoadFormat(CodeMapVM vm)
{
// 限定同網站的Ajax專用
if (!Request.IsAjaxRequest())
{
return(Content("Fail"));
}
var options = new StringBuilder();
options.AppendFormat("<option value='{0}'>{1}</option>", "", "-Please Select-");
if (vm.ModeType.Equals("EXPORT", StringComparison.OrdinalIgnoreCase))
{
if (vm.Format.Equals("XML"))
{
using (tblXMLSettingRepository rep = new tblXMLSettingRepository())
{
List <tblXMLSetting> setting = rep.getByCustomer(userInfo.Account, vm.CustomerName).ToList();
foreach (var s in setting)
{
options.AppendFormat("<option value='{0}'>{1}</option>", s.XMLName, s.XMLName);
}
}
}
else if (vm.Format.Equals("EXCEL"))
{
using (tblExcelSettingRepository rep = new tblExcelSettingRepository())
{
List <tblExcelSetting> setting = rep.getByCustomer(userInfo.Account, vm.CustomerName).ToList();
foreach (var s in setting)
{
options.AppendFormat("<option value='{0}'>{1}</option>", s.ExcelName, s.ExcelName);
}
}
}
}
var jsonData = new
{
status = "ok",
Options = options.ToString(),
};
return(Json(jsonData));
}