public BKeHoachXuatBanDetail addDataXuatBanDetail(string id, dynamic time, int number, int status) { BKeHoachXuatBanDetail data = new BKeHoachXuatBanDetail(); data.ThongTinBaoId = id; data.Nam = Convert.ToInt32(time.year); data.Thang = Convert.ToInt32(time.month); data.Ngay = Convert.ToInt32(time.day); data.Quy = Convert.ToInt32(time.quy); data.Thu = Convert.ToInt32(time.thu); data.SoBao = number.ToString(); data.Number = number; data.status = status; return data; }
/// <summary> /// Điều chỉnh số ra riêng /// </summary> /// <param name="_dieuchinhDetail"></param> /// <param name="_dieuchinh"></param> /// <param name="_config"></param> /// <modify> /// Author Date Comment /// Anhhn 3/8/15 Tách từ CreateDieuChinhKHXBDetail /// </modify> private void DCSoRaRieng(BDieuChinhKHXBDetail _dieuchinhDetail, BDieuChinhKHXB _dieuchinh) { //Đọc dữ liệu thiếp lập điều chỉnh dynamic _config = JsonConvert.DeserializeObject<ExpandoObject>(_dieuchinhDetail.Config); BKeHoachXuatBanDetail _detailNew = new BKeHoachXuatBanDetail(); _detailNew.ThongTinBaoId = _dieuchinh.ThongTinBaoId; _detailNew.Nam = _dieuchinh.Nam; _detailNew.Quy = _dieuchinh.Quy; _detailNew.GiaBao = _dieuchinhDetail.GiaBao; _detailNew.TrongLuong = _dieuchinhDetail.TrongLuong; _detailNew.SoTrang = _dieuchinhDetail.SoTrang; _detailNew.KichThuoc = _dieuchinhDetail.KichThuoc; _detailNew.GhiChu = _dieuchinhDetail.GhiChu; _detailNew.Details = _dieuchinhDetail.NoiDung; _detailNew.status = (int)Enums.KeHoachXuatBan.add; int[] _dateS = ((string)_config.content.data.time).Split('/').Select(d => Convert.ToInt32(d)).ToArray(); DateTime _time = new DateTime(_dateS[2], _dateS[1], _dateS[0]); _detailNew.Number = -1; _detailNew.SoXuatBan = _config.content.data.data; _detailNew.Thang = _dateS[1]; _detailNew.Ngay = _dateS[0]; _detailNew.Thu = ((int)_time.DayOfWeek) == 0 ? 8 : ((int)_time.DayOfWeek) + 1; _detailNew.SoBao = Guid.NewGuid().ToString().Trim(); _dieuchinhDetail.SoBao = "[\"" + _detailNew.SoBao + "\"]"; db.BDieuChinhKHXBDetails.Add(_dieuchinhDetail); db.BKeHoachXuatBanDetails.Add(_detailNew); db.SaveChanges(); }
/// <summary> /// Điểu chỉnh dồn số /// </summary> /// <param name="_dieuchinhDetail"></param> /// <param name="_dieuchinh"></param> /// <param name="_config"></param> /// <modify> /// Author Date Comment /// Anhhn 3/8/15 Tách từ CreateDieuChinhKHXBDetail /// </modify> private void DCDonSo(BDieuChinhKHXBDetail _dieuchinhDetail, BDieuChinhKHXB _dieuchinh) { //Đọc dữ liệu thiếp lập điều chỉnh dynamic _config = JsonConvert.DeserializeObject<ExpandoObject>(_dieuchinhDetail.Config); if (_config.config.type == 1) { int[] numberConfig = ((List<dynamic>)_config.config.data).Select(d => d).ToList().ConvertAll(d => (int)Convert.ToInt32(d.ToString())).ToArray(); _dieuchinhDetail.NgayOrThu = JsonConvert.SerializeObject(numberConfig); } List<BKeHoachXuatBanDetail> _kehoach = getKeHoachXuatBanDetail(_dieuchinh.ThongTinBaoId, _dieuchinh.Nam, _dieuchinh.Quy).ToList(); List<BKeHoachXuatBanDetail> khxbdetailAdd = new List<BKeHoachXuatBanDetail>(); List<string> numberSoBao = new List<string>(); foreach (var item in _config.content.data) { string[] arNum = ((List<object>)item.data).Select(d => d.ToString()).ToArray(); numberSoBao.AddRange(arNum); BKeHoachXuatBanDetail _detailNew = new BKeHoachXuatBanDetail(); foreach (var itemNumber in _kehoach.Where(d => arNum.Contains(d.SoBao))) { itemNumber.DonSo = item.id; itemNumber.GiaBao = _dieuchinhDetail.GiaBao; itemNumber.TrongLuong = _dieuchinhDetail.TrongLuong; itemNumber.SoTrang = _dieuchinhDetail.SoTrang; itemNumber.KichThuoc = _dieuchinhDetail.KichThuoc; itemNumber.GhiChu = _dieuchinhDetail.GhiChu; itemNumber.Details = _dieuchinhDetail.NoiDung; itemNumber.status = (int)Enums.KeHoachXuatBan.group; _detailNew.ThongTinBaoId = itemNumber.ThongTinBaoId; _detailNew.Nam = itemNumber.Nam; _detailNew.Quy = itemNumber.Quy; _detailNew.DonSo = item.id; _detailNew.GiaBao = _dieuchinhDetail.GiaBao; _detailNew.TrongLuong = _dieuchinhDetail.TrongLuong; _detailNew.SoTrang = _dieuchinhDetail.SoTrang; _detailNew.KichThuoc = _dieuchinhDetail.KichThuoc; _detailNew.GhiChu = _dieuchinhDetail.GhiChu; _detailNew.Details = _dieuchinhDetail.NoiDung; _detailNew.status = (int)Enums.KeHoachXuatBan.group; _detailNew.SoBao = item.id; } int[] _dateS = ((string)item.time).Split('/').Select(d => Convert.ToInt32(d)).ToArray(); DateTime _time = new DateTime(_dateS[2], _dateS[1], _dateS[0]); _detailNew.Number = -1; _detailNew.SoXuatBan = string.Join(",", arNum); _detailNew.Thang = _dateS[1]; _detailNew.Ngay = _dateS[0]; _detailNew.Thu = ((int)_time.DayOfWeek) == 0 ? 8 : ((int)_time.DayOfWeek) + 1; khxbdetailAdd.Add(_detailNew); } _dieuchinhDetail.SoBao = JsonConvert.SerializeObject(numberSoBao); db.BDieuChinhKHXBDetails.Add(_dieuchinhDetail); db.BKeHoachXuatBanDetails.AddRange(khxbdetailAdd); db.SaveChanges(); }
public void updateOldChiTiet(BKeHoachXuatBanDetail item, BDieuChinhKHXBDetail dieuChinhOld) { BDieuChinhKHXBDetail _dieuchinhDetail = db.BDieuChinhKHXBDetails.Where(d => !d.Id.Equals(dieuChinhOld.Id) && !d.DieuChinhKHXBId.Equals(dieuChinhOld.DieuChinhKHXBId) && d.SoBao.IndexOf("\"" + item.SoBao + "\"") > -1 && (d.LoaiDieuChinh == (int)Enums.KeHoachXuatBan.changed || d.LoaiDieuChinh == (int)Enums.KeHoachXuatBan.add || d.LoaiDieuChinh == (int)Enums.KeHoachXuatBan.group)).OrderByDescending(d => d.ModifyDate).FirstOrDefault(); if (_dieuchinhDetail == null) { item.GiaBao = null; item.TrongLuong = null; item.SoTrang = null; item.KichThuoc = null; item.GhiChu = null; item.Details = null; } else { item.GiaBao = _dieuchinhDetail.GiaBao; item.TrongLuong = _dieuchinhDetail.TrongLuong; item.SoTrang = _dieuchinhDetail.SoTrang; item.KichThuoc = _dieuchinhDetail.KichThuoc; item.GhiChu = _dieuchinhDetail.GhiChu; item.Details = _dieuchinhDetail.NoiDung; } }