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