public ActionResult CommitInvoiceNoIntervalGroup(InvoiceNoViewModel viewModel) { ViewBag.ViewModel = viewModel; var profile = HttpContext.GetUser(); if (viewModel.BookletBranchID == null || viewModel.BookletBranchID.Length < 3 || viewModel.BookletBranchID.Any(c => !c.HasValue)) { ModelState.AddModelError("BookletBranchID", "請選擇分店!!"); } viewModel.TrackCode = viewModel.TrackCode.GetEfficientString(); if (viewModel.TrackCode == null || !Regex.IsMatch(viewModel.TrackCode, "[A-Z]{2}")) { ModelState.AddModelError("TrackCode", "字軌錯誤!!"); } if (!viewModel.Year.HasValue) { ModelState.AddModelError("Year", "請選擇年份!!"); } if (!viewModel.PeriodNo.HasValue) { ModelState.AddModelError("PeriodNo", "請選擇期別!!"); } var trackCode = models.GetTable <InvoiceTrackCode>() .Where(t => t.TrackCode == viewModel.TrackCode && t.Year == viewModel.Year && t.PeriodNo == viewModel.PeriodNo).FirstOrDefault(); var table = models.GetTable <InvoiceNoInterval>() .Where(n => n.EndNo > n.StartNo); var item = table.Where(i => i.IntervalID == viewModel.IntervalID).FirstOrDefault(); int?range; if (!viewModel.StartNo.HasValue || !(viewModel.StartNo >= 0 && viewModel.StartNo < 100000000)) { ModelState.AddModelError("StartNo", "起號非8位整數!!"); } else if (!viewModel.EndNo.HasValue || !(viewModel.EndNo >= 0 && viewModel.EndNo < 100000000)) { ModelState.AddModelError("EndNo", "迄號非8位整數!!"); } else if (viewModel.EndNo <= viewModel.StartNo || (((range = viewModel.EndNo - viewModel.StartNo + 1)) % 50 != 0)) { ModelState.AddModelError("StartNo", "不符號碼大小順序與差距為50之倍數原則!!"); } else if (viewModel.BookletCount == null || viewModel.BookletCount.Length < 3 || viewModel.BookletCount.Any(c => !c.HasValue || c < 0)) { ModelState.AddModelError("BookletCount", "請輸入有效本數!!"); } else if (viewModel.BookletCount.Sum(c => c) > (range / 50)) { ModelState.AddModelError("BookletCount", "輸入總本數超過配號區間!!"); } else { if (item != null) { if (item.InvoiceNoAssignment.Count > 0) { ModelState.AddModelError("StartNo", "該區間之號碼已經被使用,不可修改!!!!"); } else if (table.Any(t => t.IntervalID != item.IntervalID && t.TrackID == item.TrackID && t.StartNo >= viewModel.EndNo && t.InvoiceNoAssignment.Count > 0 && t.SellerID == item.SellerID)) { ModelState.AddModelError("StartNo", "違反序時序號原則該區段無法修改!!"); } else if (table.Any(t => t.IntervalID != item.IntervalID && t.TrackID == item.TrackID && ((t.EndNo <= viewModel.EndNo && t.EndNo >= viewModel.StartNo) || (t.StartNo <= viewModel.EndNo && t.StartNo >= viewModel.StartNo) || (t.StartNo <= viewModel.StartNo && t.EndNo >= viewModel.StartNo) || (t.StartNo <= viewModel.EndNo && t.EndNo >= viewModel.EndNo)))) { ModelState.AddModelError("StartNo", "系統中已存在重疊的區段!!"); } } else { if (trackCode != null) { if (table.Any(t => t.TrackID == trackCode.TrackID && t.StartNo >= viewModel.EndNo && t.InvoiceNoAssignment.Count > 0)) { ModelState.AddModelError("StartNo", "違反序時序號原則該區段無法新增!!"); } else if (table.Any(t => t.TrackID == trackCode.TrackID && ((t.EndNo <= viewModel.EndNo && t.EndNo >= viewModel.StartNo) || (t.StartNo <= viewModel.EndNo && t.StartNo >= viewModel.StartNo) || (t.StartNo <= viewModel.StartNo && t.EndNo >= viewModel.StartNo) || (t.StartNo <= viewModel.EndNo && t.EndNo >= viewModel.EndNo)))) { ModelState.AddModelError("StartNo", "系統中已存在重疊的區段!!"); } } } } if (!ModelState.IsValid) { ViewBag.ModelState = ModelState; return(View("~/Views/Shared/ReportInputError.ascx")); } if (item != null) { models.DeleteAllOnSubmit <InvoiceNoInterval>(i => i.GroupID == item.IntervalID); } if (trackCode == null) { trackCode = new InvoiceTrackCode { TrackCode = viewModel.TrackCode, PeriodNo = viewModel.PeriodNo.Value, Year = viewModel.Year.Value }; models.GetTable <InvoiceTrackCode>().InsertOnSubmit(trackCode); } InvoiceNoInterval prevItem = null; for (int i = 0; i < viewModel.BookletBranchID.Length; i++) { var branchID = viewModel.BookletBranchID[i]; var bookletCount = viewModel.BookletCount[i]; var codeAssignment = trackCode.InvoiceTrackCodeAssignment.Where(t => t.SellerID == branchID.Value).FirstOrDefault(); if (codeAssignment == null) { codeAssignment = new InvoiceTrackCodeAssignment { SellerID = branchID.Value, InvoiceTrackCode = trackCode }; trackCode.InvoiceTrackCodeAssignment.Add(codeAssignment); } item = new InvoiceNoInterval { }; if (i == 0) { item.StartNo = viewModel.StartNo.Value; item.EndNo = item.StartNo + (bookletCount.Value * 50) - 1; item.InvoiceNoIntervalGroup = new InvoiceNoIntervalGroup { }; } else { item.StartNo = prevItem.EndNo + 1; item.EndNo = item.StartNo + (bookletCount.Value * 50) - 1; item.InvoiceNoIntervalGroup = prevItem.InvoiceNoIntervalGroup; } codeAssignment.InvoiceNoInterval.Add(item); prevItem = item; } try { models.SubmitChanges(); return(Json(new { result = true, item.GroupID })); } catch (Exception ex) { Logger.Error(ex); return(Json(new { result = false, message = ex.Message })); } }
public ActionResult CommitInvoiceNoInterval(InvoiceNoViewModel viewModel) { ViewBag.ViewModel = viewModel; var profile = HttpContext.GetUser(); if (!viewModel.BranchID.HasValue) { ModelState.AddModelError("BranchID", "請選擇分店!!"); } viewModel.TrackCode = viewModel.TrackCode.GetEfficientString(); if (viewModel.TrackCode == null || !Regex.IsMatch(viewModel.TrackCode, "[A-Z]{2}")) { ModelState.AddModelError("TrackCode", "字軌錯誤!!"); } if (!viewModel.Year.HasValue) { ModelState.AddModelError("Year", "請選擇年份!!"); } if (!viewModel.PeriodNo.HasValue) { ModelState.AddModelError("PeriodNo", "請選擇期別!!"); } var trackCode = models.GetTable <InvoiceTrackCode>() .Where(t => t.TrackCode == viewModel.TrackCode && t.Year == viewModel.Year && t.PeriodNo == viewModel.PeriodNo).FirstOrDefault(); var table = models.GetTable <InvoiceNoInterval>(); var item = table.Where(i => i.IntervalID == viewModel.IntervalID).FirstOrDefault(); if (!viewModel.StartNo.HasValue || !(viewModel.StartNo >= 0 && viewModel.StartNo < 100000000)) { ModelState.AddModelError("StartNo", "起號非8位整數!!"); } else if (!viewModel.EndNo.HasValue || !(viewModel.EndNo >= 0 && viewModel.EndNo < 100000000)) { ModelState.AddModelError("EndNo", "迄號非8位整數!!"); } else if (viewModel.EndNo <= viewModel.StartNo || ((viewModel.EndNo - viewModel.StartNo + 1) % 50 != 0)) { ModelState.AddModelError("StartNo", "不符號碼大小順序與差距為50之倍數原則!!"); } else { if (item != null) { if (item.InvoiceNoAssignment.Count > 0) { ModelState.AddModelError("StartNo", "該區間之號碼已經被使用,不可修改!!!!"); } else if (table.Any(t => t.IntervalID != item.IntervalID && t.TrackID == item.TrackID && t.StartNo >= viewModel.EndNo && t.InvoiceNoAssignment.Count > 0 && t.SellerID == item.SellerID)) { ModelState.AddModelError("StartNo", "違反序時序號原則該區段無法修改!!"); } else if (table.Any(t => t.IntervalID != item.IntervalID && t.TrackID == item.TrackID && ((t.EndNo <= viewModel.EndNo && t.EndNo >= viewModel.StartNo) || (t.StartNo <= viewModel.EndNo && t.StartNo >= viewModel.StartNo) || (t.StartNo <= viewModel.StartNo && t.EndNo >= viewModel.StartNo) || (t.StartNo <= viewModel.EndNo && t.EndNo >= viewModel.EndNo)))) { ModelState.AddModelError("StartNo", "系統中已存在重疊的區段!!"); } } else { if (trackCode != null) { if (table.Any(t => t.TrackID == trackCode.TrackID && t.StartNo >= viewModel.EndNo && t.InvoiceNoAssignment.Count > 0 && t.SellerID == viewModel.BranchID)) { ModelState.AddModelError("StartNo", "違反序時序號原則該區段無法新增!!"); } else if (table.Any(t => t.TrackID == trackCode.TrackID && ((t.EndNo <= viewModel.EndNo && t.EndNo >= viewModel.StartNo) || (t.StartNo <= viewModel.EndNo && t.StartNo >= viewModel.StartNo) || (t.StartNo <= viewModel.StartNo && t.EndNo >= viewModel.StartNo) || (t.StartNo <= viewModel.EndNo && t.EndNo >= viewModel.EndNo)))) { ModelState.AddModelError("StartNo", "系統中已存在重疊的區段!!"); } } } } if (!ModelState.IsValid) { ViewBag.ModelState = ModelState; return(View("~/Views/Shared/ReportInputError.ascx")); } if (item == null) { if (trackCode == null) { trackCode = new InvoiceTrackCode { TrackCode = viewModel.TrackCode, PeriodNo = viewModel.PeriodNo.Value, Year = viewModel.Year.Value }; models.GetTable <InvoiceTrackCode>().InsertOnSubmit(trackCode); } var codeAssignment = trackCode.InvoiceTrackCodeAssignment.Where(t => t.SellerID == viewModel.BranchID).FirstOrDefault(); if (codeAssignment == null) { codeAssignment = new InvoiceTrackCodeAssignment { SellerID = viewModel.BranchID.Value, InvoiceTrackCode = trackCode }; trackCode.InvoiceTrackCodeAssignment.Add(codeAssignment); } item = new InvoiceNoInterval { }; codeAssignment.InvoiceNoInterval.Add(item); } item.StartNo = viewModel.StartNo.Value; item.EndNo = viewModel.EndNo.Value; try { models.SubmitChanges(); return(Json(new { result = true, item.IntervalID })); } catch (Exception ex) { Logger.Error(ex); return(Json(new { result = false, message = ex.Message })); } }