public ActionResult Add(string id, string idkehoach) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } //year = year == null ? DateTime.Now.Year : year < DateTime.Now.Year ? DateTime.Now.Year : year; BaoKyXuatBanModel baoKyXuatBanModel = db.getBaoKyXuatBanModel(id); //BKeHoachXuatBan _xuatban = db.getBKeHoachXuatBan(id, Convert.ToInt32(year)); KeHoachXuatBanModel _kehoach = new KeHoachXuatBanModel(); _kehoach.Id = baoKyXuatBanModel.Id; _kehoach.KyConfig = baoKyXuatBanModel.KyConfig; _kehoach.LoaiKy = baoKyXuatBanModel.LoaiKy; _kehoach.MaBao = baoKyXuatBanModel.MaBao; _kehoach.TenBao = baoKyXuatBanModel.TenBao; if (idkehoach == null) { _kehoach.Nam = db.getBKeHoachXuatBanYearLast(id); _kehoach.SoBatDau = -1; _kehoach.IdKeHoachXuatBan = "-1"; _kehoach.detailKHXB = new List<BKeHoachXuatBanDetail>(); } else { BKeHoachXuatBan _xuatban = db.getBKeHoachXuatBan(idkehoach); if (_xuatban == null) return RedirectToAction("add/" + id); _kehoach.IdKeHoachXuatBan = idkehoach; _kehoach.Nam = _xuatban.Nam; _kehoach.SoBatDau = 1; } _kehoach.khxb = db.getKHXBByID(id); if (_kehoach == null) { return HttpNotFound(); } if (HttpContext.Request.IsAjaxRequest()) return PartialView("_Add", _kehoach); return View(_kehoach); }
public ActionResult ChiTiet(string id, string idkehoach) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } BKeHoachXuatBan _xuatban = db.getBKeHoachXuatBan(idkehoach); if (_xuatban == null) return RedirectToAction("add/" + id); BaoKyXuatBanModel baoKyXuatBanModel = db.getBaoKyXuatBanModel(id); KeHoachXuatBanModel _kehoach = new KeHoachXuatBanModel(); _kehoach.Id = baoKyXuatBanModel.Id; _kehoach.KyConfig = baoKyXuatBanModel.KyConfig; _kehoach.LoaiKy = baoKyXuatBanModel.LoaiKy; _kehoach.MaBao = baoKyXuatBanModel.MaBao; _kehoach.TenBao = baoKyXuatBanModel.TenBao; _kehoach.IdKeHoachXuatBan = idkehoach; _kehoach.Nam = _xuatban.Nam; _kehoach.SoBatDau = _xuatban.SoBatDau; _kehoach.detailKHXB = db.getBKeHoachXuatBanDetail(id, Convert.ToInt32(_xuatban.Nam)); _kehoach.data.Add("BDieuChinhKHXB", JsonConvert.DeserializeObject<List<Dictionary<string, object>>>(JsonConvert.SerializeObject((from p in db.getBDieuChinhKHXB(id, Convert.ToInt32(_xuatban.Nam)) select new { p.Id, p.ThongTinBaoId, p.ModifyDate, p.Quy, ModifyBy = (from u in db.getDBSelect().UserInfoes where u.Id.Equals(p.ModifyBy) select u.DislayName).FirstOrDefault() })))); if (_kehoach == null) { return HttpNotFound(); } return View(_kehoach); }
public ActionResult DieuChinhKeHoachXuatBan(string id, string idkehoach) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } BKeHoachXuatBan _xuatban = db.getBKeHoachXuatBan(idkehoach); if (_xuatban == null) { return RedirectToAction("add/" + id); } BaoKyXuatBanModel baoKyXuatBanModel = db.getBaoKyXuatBanModel(id); KeHoachXuatBanModel _kehoach = new KeHoachXuatBanModel(); _kehoach.Id = baoKyXuatBanModel.Id; _kehoach.KyConfig = baoKyXuatBanModel.KyConfig; _kehoach.LoaiKy = baoKyXuatBanModel.LoaiKy; _kehoach.MaBao = baoKyXuatBanModel.MaBao; _kehoach.TenBao = baoKyXuatBanModel.TenBao; _kehoach.IdKeHoachXuatBan = idkehoach; _kehoach.Nam = _xuatban.Nam; _kehoach.SoBatDau = _xuatban.SoBatDau; if (_xuatban.Nam < DateTime.Now.Year) return Redirect(Request.UrlReferrer.ToString()); //return RedirectToAction("Index"); int[] quyCSDL = db.getBDieuChinhKHXB(id, Convert.ToInt32(_xuatban.Nam)).Select(d => d.Quy).ToArray(); int month = DateTime.Now.Year == _xuatban.Nam ? DateTime.Now.Month : 1; int quyNow = month >= 1 && month <= 3 ? 1 : month > 3 && month <= 6 ? 2 : month > 6 && month <= 9 ? 3 : 4; quyNow = quyCSDL.Length > 0 && quyCSDL[0] >= quyNow ? quyCSDL[0] : quyNow - 1; List<int> arQuy = new List<int>(); if (quyNow + 1 <= 4) arQuy.Add(quyNow + 1); //for (int i = quyNow + 1; i <= 4; i++) //{ // arQuy.Add(i); //} if (arQuy.Count <= 0) return Redirect(Request.UrlReferrer.ToString()); //return RedirectToAction("Index"); _kehoach.data.Add("arrayquy", arQuy); if (_kehoach == null) { return HttpNotFound(); } return View(_kehoach); }
public ActionResult View(string id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } BDieuChinhKHXBDetail _dieuchinhDetail = db.getDBSelect().BDieuChinhKHXBDetails.Where(d => d.Id.Equals(id)).FirstOrDefault(); if (_dieuchinhDetail == null) { return HttpNotFound(); //return Redirect(Request.UrlReferrer.ToString()); } int typeDieuCHinh = _dieuchinhDetail.LoaiDieuChinh; BDieuChinhKHXB _dieuChinh = db.getDBSelect().BDieuChinhKHXBs.Where(d => d.Id.Equals(_dieuchinhDetail.DieuChinhKHXBId)).FirstOrDefault(); BaoKyXuatBanModel baoKyXuatBanModel = db.getBaoKyXuatBanModel(_dieuChinh.ThongTinBaoId); KeHoachXuatBanModel _kehoach = new KeHoachXuatBanModel(); _kehoach.Id = baoKyXuatBanModel.Id; _kehoach.KyConfig = _dieuChinh.ChiTietKy; _kehoach.LoaiKy = Convert.ToInt32(_dieuChinh.LoaiKy); _kehoach.MaBao = baoKyXuatBanModel.MaBao; _kehoach.TenBao = baoKyXuatBanModel.TenBao; _kehoach.IdKeHoachXuatBan = id; _kehoach.Nam = _dieuChinh.Nam; _kehoach.Quy = _dieuChinh.Quy; _kehoach.data.Add("IdDieuChinh", id); _kehoach.data.Add("TypeText", Enums.KieuDieuChinhKHXB((Enums.KeHoachXuatBan)typeDieuCHinh)); _kehoach.data.Add("Type", typeDieuCHinh); dynamic dataConfig = JsonConvert.DeserializeObject<ExpandoObject>(_dieuchinhDetail.Config); _kehoach.data.Add("DataConfig", dataConfig); _kehoach.data.Add("SoBao", _dieuchinhDetail.SoBao); _kehoach.data.Add("DataNumber", db.getDBSelect().BKeHoachXuatBanDetails.Where(d => d.ThongTinBaoId.Equals(_dieuChinh.ThongTinBaoId) && d.Nam == _dieuChinh.Nam && d.Quy == d.Quy && (_dieuchinhDetail.SoBao.IndexOf("\"" + d.SoBao + "\"") > -1 || (d.Number == -1 && d.status == (int)Enums.KeHoachXuatBan.group))).ToList<BKeHoachXuatBanDetail>()); ViewBag.ThongTinBaoId = _dieuChinh.Id; if (_kehoach == null) { return HttpNotFound(); } return View(_kehoach); }
// GET: Bao/DieuChinhKHXB public ActionResult Index(string id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } BDieuChinhKHXB _dieuChinh = db.getDBSelect().BDieuChinhKHXBs.Where(d=>d.Id.Equals(id)).FirstOrDefault(); if (_dieuChinh == null) { return HttpNotFound(); //return Redirect(Request.UrlReferrer.ToString()); } //return RedirectToAction("bao/kehoachxuatban"); int sDonSo = (int)Enums.KeHoachXuatBan.group; BaoKyXuatBanModel baoKyXuatBanModel = db.getBaoKyXuatBanModel(_dieuChinh.ThongTinBaoId); KeHoachXuatBanModel _kehoach = new KeHoachXuatBanModel(); _kehoach.Id = baoKyXuatBanModel.Id; _kehoach.KyConfig = _dieuChinh.ChiTietKy; _kehoach.LoaiKy = Convert.ToInt32(_dieuChinh.LoaiKy); _kehoach.ThongTinBaoId = _dieuChinh.ThongTinBaoId; _kehoach.MaBao = baoKyXuatBanModel.MaBao; _kehoach.TenBao = baoKyXuatBanModel.TenBao; _kehoach.IdKeHoachXuatBan = id; _kehoach.Nam = _dieuChinh.Nam; _kehoach.Quy = _dieuChinh.Quy; _kehoach.detailKHXB = db.getDBSelect().BKeHoachXuatBanDetails.Where(d => d.ThongTinBaoId.Equals(_dieuChinh.ThongTinBaoId) && d.Nam == _dieuChinh.Nam && d.Quy == _dieuChinh.Quy && (d.status != sDonSo || d.Number < 0)).OrderBy(d => d.Thang).OrderBy(d => d.Ngay).ToList(); _kehoach.dieuchinhdetailKHXB = db.getBKeHoachXuatBanDetailModel(_dieuChinh.Id).ToList(); ViewBag.KyXuatBan = JsonConvert.DeserializeObject<ExpandoObject>(_dieuChinh.ChiTietKy); if (_kehoach == null) { return HttpNotFound(); } return View(_kehoach); }
// GET: Bao/DieuChinhKHXB/Create public ActionResult Create(string type, string id) { if (type == null || id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } BDieuChinhKHXB _dieuChinh = db.getDBSelect().BDieuChinhKHXBs.Where(d => d.Id.Equals(id)).FirstOrDefault(); if (_dieuChinh == null) { return HttpNotFound(); //return Redirect(Request.UrlReferrer.ToString()); } BaoKyXuatBanModel baoKyXuatBanModel = db.getBaoKyXuatBanModel(_dieuChinh.ThongTinBaoId); KeHoachXuatBanModel _kehoach = new KeHoachXuatBanModel(); _kehoach.Id = baoKyXuatBanModel.Id; _kehoach.KyConfig = _dieuChinh.ChiTietKy; _kehoach.LoaiKy = Convert.ToInt32(_dieuChinh.LoaiKy); _kehoach.MaBao = baoKyXuatBanModel.MaBao; _kehoach.TenBao = baoKyXuatBanModel.TenBao; _kehoach.IdKeHoachXuatBan = id; _kehoach.Nam = _dieuChinh.Nam; _kehoach.Quy = _dieuChinh.Quy; _kehoach.data.Add("TypeText", Enums.KieuDieuChinhKHXB(Enums.getKeHoachXuatBan(type))); int typeDieuCHinh = ((int)Enums.getKeHoachXuatBan(type)); _kehoach.data.Add("Type", typeDieuCHinh); if (_kehoach.LoaiKy >= 0 && _kehoach.LoaiKy <= 3) { List<string> listConfig = JsonConvert.DeserializeObject<List<string>>((JsonConvert.DeserializeObject<dynamic>(_kehoach.KyConfig)).data.ToString()); if (_kehoach.LoaiKy == 0) listConfig = (new string[] { "2", "3", "4", "5", "6", "7", "8" }).ToList(); List<string> ngayThuLoai = new List<string>(); foreach (string _item in db.getDBSelect().BDieuChinhKHXBDetails.Where(d => d.DieuChinhKHXBId.Equals(id) && d.LoaiDieuChinh == (int)Enums.KeHoachXuatBan.cancel && d.NgayOrThu != null).Select(d => d.NgayOrThu)) { int[] itemArr = JsonConvert.DeserializeObject<int[]>(_item); foreach (string itemC in listConfig) { if (itemArr.Contains(Convert.ToInt32(itemC)) && !ngayThuLoai.Contains(itemC)) ngayThuLoai.Add(itemC); } } if (typeDieuCHinh != (int)Enums.KeHoachXuatBan.cancel) { foreach (string _item in db.getDBSelect().BDieuChinhKHXBDetails.Where(d => d.DieuChinhKHXBId.Equals(id) && d.LoaiDieuChinh == typeDieuCHinh && d.NgayOrThu != null).Select(d => d.NgayOrThu)) { int[] itemArr = JsonConvert.DeserializeObject<int[]>(_item); foreach (string itemC in listConfig) { if (itemArr.Contains(Convert.ToInt32(itemC)) && !ngayThuLoai.Contains(itemC)) ngayThuLoai.Add(itemC); } } } else { foreach (string _item in db.getDBSelect().BDieuChinhKHXBDetails.Where(d => d.DieuChinhKHXBId.Equals(id) && d.LoaiDieuChinh == (int)Enums.KeHoachXuatBan.group && d.NgayOrThu != null).Select(d => d.NgayOrThu)) { int[] itemArr = JsonConvert.DeserializeObject<int[]>(_item); foreach (string itemC in listConfig) { if (itemArr.Contains(Convert.ToInt32(itemC)) && !ngayThuLoai.Contains(itemC)) ngayThuLoai.Add(itemC); } } } foreach (var item in ngayThuLoai) { listConfig.Remove(item); } _kehoach.data.Add("KyConfig", listConfig.ToArray()); } if (_kehoach == null) { return HttpNotFound(); } return View(_kehoach); }