public ActionResult LoadColumns(CodeMapVM vm)
{
// 限定同網站的Ajax專用
if (!Request.IsAjaxRequest())
{
return(Content("Fail"));
}
var options = new StringBuilder();
options.AppendFormat("<option value='{0}'>{1}</option>", "", "-Please Select-");
string SQLName = string.Empty;
if (vm.ModeType.Equals("EXPORT", StringComparison.OrdinalIgnoreCase))
{
if (vm.Format.Equals("XML"))
{
using (tblXMLMappingRepository rep = new tblXMLMappingRepository())
{
IEnumerable <tblXMLMapping> mapping = rep.get(vm.SettingName);
foreach (var m in mapping)
{
options.AppendFormat("<option value='{0}'>{0}</option>", m.TagName);
}
}
}
else if (vm.Format.Equals("EXCEL"))
{
using (tblExcelMappingRepository rep = new tblExcelMappingRepository())
{
IEnumerable <tblExcelMapping> mapping = rep.get(vm.SettingName);
foreach (var m in mapping)
{
options.AppendFormat("<option value='{0}'>{0}</option>", m.ColumnName);
}
}
}
}
var jsonData = new
{
status = "ok",
Options = options.ToString(),
};
return(Json(jsonData));
}
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));
}
public ActionResult Save(CodeMapVM vm)
{
if (string.IsNullOrEmpty(vm.CustomerName))
{
vm.SaveResult += "請輸入 Customer Name!\r\n";
}
if (string.IsNullOrEmpty(vm.ModeType))
{
vm.SaveResult += "請選擇 Mode Type!\r\n";
}
if (string.IsNullOrEmpty(vm.Format))
{
vm.SaveResult += "請選擇 Format!\r\n";
}
if (string.IsNullOrEmpty(vm.SettingName))
{
vm.SaveResult += "請選擇 XML/EXCEL Name!\r\n";
}
if (string.IsNullOrEmpty(vm.FieldName))
{
vm.SaveResult += "請選擇 Tag/Column Name!\r\n";
}
if (!string.IsNullOrEmpty(vm.SaveResult))
{
if (vm.ViewStatus == "E")
{
return(View("Edit", vm));
}
else
{
return(View("New", vm));
}
}
using (tblCodeMappingRepository rep = new tblCodeMappingRepository())
{
if (vm.ViewStatus == "E") // 更新
{
vm.SaveResult = rep.UpadteMapping(vm.SettingName, vm.Format, vm.ModeType, vm.FieldName, vm.BeforeValue, vm.NewBeforeValue, vm.AfterValue, userInfo.Account);
}
else
{
vm.SaveResult = rep.InsertMapping(vm.SettingName, vm.Format, vm.ModeType, vm.FieldName, vm.NewBeforeValue, vm.AfterValue, userInfo.Account);
}
if (vm.SaveResult.Equals("ok"))
{
return(RedirectToAction("Index"));
}
else
{
if (vm.ViewStatus == "E")
{
return(View("Edit", vm));
}
else
{
return(View("New", vm));
}
}
}
}
