public ActionResult CRM011Copy(string classId)
{
var srcRow = CrDataService.Instance.CrClass_getById(classId).FirstRow;
//if (srcRow == null)
//{
// var qm = new CrRegistrationQryModel();
// qm.ClientMessage = "找不到來源資料";
//}
CR_ClassRow row = null;
if (srcRow != null)
{
row = CrDataService.Instance.CrClass_create().FirstRow;
row.CRCL_CourseId = srcRow.CRCL_CourseId;
row.CRCL_CourseCode_XX = srcRow.CRCL_CourseCode_XX;
row.CRCL_CourseName_XX = srcRow.CRCL_CourseName_XX;
row.CRCL_CourseDesc_XX = srcRow.CRCL_CourseDesc_XX;
row.CRCL_CourseEnable_XX = srcRow.CRCL_CourseEnable_XX;
row.CRCL_CourseEnableName_XX = srcRow.CRCL_CourseEnableName_XX;
row.CRCL_StartDate_XX = srcRow.CRCL_StartDate_XX;
row.CRCL_EndDate_XX = srcRow.CRCL_EndDate_XX;
//row.CRCL_Code = srcRow.CRCL_Code;
row.CRCL_ClassDate = srcRow.CRCL_ClassDate;
row.CRCL_ClassTime = srcRow.CRCL_ClassTime;
row.CRCL_LimitQty = srcRow.CRCL_LimitQty;
row.CRCL_Place = srcRow.CRCL_Place;
row.CRCL_Address = srcRow.CRCL_Address;
row.CRCL_RegisterQty_XX = srcRow.CRCL_RegisterQty_XX;
}
ViewBag.ViewMode = "create";
return(View("CRM011Edit", row));
}
//public ActionResult CRM011()
//{
// var qm = new CrRegistrationQryModel();
// return View(qm);
//}
public ActionResult CRM011Edit(string id, string courseId)
{
var viewMode = "update";
CR_ClassRow row = null;
if (id.isNullOrEmpty())
{
row = CrDataService.Instance.CrClass_createWithCourseId(courseId).FirstRow;
viewMode = "create";
}
else
{
row = CrDataService.Instance.CrClass_getById(id).FirstRow;
viewMode = "update";
}
ViewBag.ViewMode = viewMode;
return(View(row));
}
public ActionResult Edit(FormCollection collection)
{
var token = collection["__RequestVerificationToken"];
var mode = collection["ViewMode"];
var id = collection[AppDataName.CRCL_ClassId];
var msgOK = "OK";
CR_ClassDataTable dt = null;
CR_ClassRow row = null;
try
{
if (mode.equalIgnoreCase("create"))
{
dt = CrDataService.Instance.CrClass_create();
msgOK = FtdStatus.InsertSuccess.ToString();
}
else
{
//找出該筆資料
dt = CrDataService.Instance.CrClass_getById(id);
if (dt == null || dt.Count == 0)
{
return(Json(new { Result = jTable_ERROR_CODE, Message = "資料不存在" }));
}
msgOK = FtdStatus.UpdateSuccess.ToString();
}
//將Form sumit的資料更新至DataRow
row = dt.FirstRow;
var isOK = this.TryUpdateModel(row);
//若驗證失敗-->回傳錯誤訊息
if (!ModelState.IsValid)
{
return(Json(new { Result = jTable_ERROR_CODE, Message = string.Join("<br/>", ModelState.Values) }));
}
#region //驗證欄位
List <string> lstError = new List <string>();
if (row.CRCL_ClassId.isNullOrEmpty())
{
lstError.Add("班別ID不能為空");
}
if (row.CRCL_CourseId.isNullOrEmpty())
{
lstError.Add("課程ID不能為空");
}
if (row.CRCL_Code.isNullOrEmpty())
{
lstError.Add("班別代號不能為空");
}
if (!row.CRCL_LimitQty.HasValue)
{
lstError.Add("人數限制不能為空");
}
if (row.CRCL_ClassDate.isNullOrEmpty())
{
lstError.Add("上課日期不能為空");
}
if (row.CRCL_ClassTime.isNullOrEmpty())
{
lstError.Add("上課時間不能為空");
}
if (row.CRCL_Place.isNullOrEmpty())
{
lstError.Add("上課地點不能為空");
}
if (row.CRCL_Address.isNullOrEmpty())
{
lstError.Add("地址不能為空");
}
//回傳錯誤訊息
if (lstError.Count > 0)
{
return(Json(new { Result = jTable_ERROR_CODE, Message = string.Join("<br/>", lstError.ToArray()) }));
}
//檢查鍵值是否重覆
if (CrDataService.Instance.CrClass_cehckDuplicate(row.CRCL_ClassId, row.CRCL_CourseId, row.CRCL_Code))
{
return(Json(new { Result = jTable_ERROR_CODE, Message = "相同鍵值的資料已存在" }));
}
#endregion
dt.ns_update();
dt.AcceptChanges();
return(Json(new { Result = msgOK }));
}
catch (Exception ex)
{
return(Json(new { Result = jTable_ERROR_CODE, Message = ex.Message }));
}
}
