public KichBanXa GetInfoByKichBanCode(int kichBanCode) { KichBanXa result = null; try { result = new KichBanXa(); thiet_lap_kich_ban_tb tmpThietLapKichBan = _database._databaseContext.thiet_lap_kich_ban_tb.FirstOrDefault( x => x.deleted_status == 0 && x.thiet_lap_kich_ban_code == kichBanCode); if (tmpThietLapKichBan != null) { result.KichBan = tmpThietLapKichBan; List <thiet_lap_kich_ban_detail_tb> tmpLapKichBanDetail = _database._databaseContext.thiet_lap_kich_ban_detail_tb.Where( x => x.deleted_status == 0 && x.thiet_lap_kich_ban_ref == tmpThietLapKichBan.thiet_lap_kich_ban_code).ToList(); result.KichBanChiTiet = tmpLapKichBanDetail; } } catch (Exception ex) { result = null; } return(result); }
public ActionResult LuuKichBanXa(int kichbancode, int vitricode, double mucnuoc, double luuluong, DateTime time, string jsondata) { List <thiet_lap_kich_ban_detail_tb> listKichBanChiTiet = serializer.Deserialize <List <thiet_lap_kich_ban_detail_tb> >(jsondata); listKichBanChiTiet = listKichBanChiTiet.OrderBy(x => x.thoi_gian).ToList(); KichBanXa kichBanXa = new KichBanXa() { KichBan = new thiet_lap_kich_ban_tb { thiet_lap_kich_ban_code = kichbancode, thoi_gian = time, vi_tri_ref = vitricode, muc_nuoc_ho = mucnuoc, luu_luong_ve_ho = luuluong }, KichBanChiTiet = listKichBanChiTiet }; bool result = _thietlapxa.UpdateKichBan(kichBanXa); if (result) { return(Json(new { listKichBan = _thietlapxa.GetListKichBanByUserTLVN(Convert.ToInt32(Security.CurrentUserId)), codeKichBan = kichbancode })); } return(Json(result)); }
public KichBanXa TinhToanXa(KichBanXa kichbanxa) { KichBanXa result = null; if (kichbanxa != null & kichbanxa.KichBanChiTiet.Count > 0) { try { thiet_lap_kich_ban_tb kichBan = kichbanxa.KichBan; var kichBanChiTiet = kichbanxa.KichBanChiTiet; // Tính toán cho bản ghi đầu double hHienTai = _common.TimDungTich(kichBan.vi_tri_ref, kichBan.muc_nuoc_ho); TimeSpan tmpTimeSpan = kichBanChiTiet[0].thoi_gian.Value - kichBan.thoi_gian.Value; double totalSecond = tmpTimeSpan.TotalSeconds; double totalQden = kichBanChiTiet[0].luu_luong_du_bao; double totalQXa = kichBanChiTiet[0].tong_tran + kichBanChiTiet[0].luu_luong_phat_dien + kichBanChiTiet[0].luu_luong_xa; double?tmpDungTich = TinhDungTichDuBao(hHienTai, totalQden, totalQXa, totalSecond); //kichBanChiTiet[0].dung_tich_ho = Math.Round(tmpDungTich == null ? 0 : tmpDungTich.Value,3); kichBanChiTiet[0].dung_tich_ho = tmpDungTich == null ? 0 : Math.Round(tmpDungTich.Value, 3); kichBanChiTiet[0].muc_nuoc_ho = Math.Round(_common.TimMucNuoc(kichBan.vi_tri_ref, kichBanChiTiet[0].dung_tich_ho), 3); // Tính cho các bản ghi tiếp theo for (int i = 1; i < kichBanChiTiet.Count; i++) { thiet_lap_kich_ban_detail_tb kb1 = kichBanChiTiet[i - 1]; thiet_lap_kich_ban_detail_tb kb2 = kichBanChiTiet[i]; tmpTimeSpan = kb2.thoi_gian.Value - kb1.thoi_gian.Value; totalSecond = tmpTimeSpan.TotalSeconds; totalQden = kb2.luu_luong_du_bao; totalQXa = kb2.tong_tran + kb2.luu_luong_phat_dien + kb2.luu_luong_xa; tmpDungTich = TinhDungTichDuBao(hHienTai, totalQden, totalQXa, totalSecond); //kb2.dung_tich_ho = Math.Round(tmpDungTich == null ? 0 : tmpDungTich.Value, 3); kb2.dung_tich_ho = tmpDungTich == null ? 0 : Math.Round(tmpDungTich.Value, 3); kb2.muc_nuoc_ho = Math.Round(_common.TimMucNuoc(kichBan.vi_tri_ref, kb2.dung_tich_ho), 3); } result = kichbanxa; } catch (Exception ex) { } } return(result); }
// GET: ThietLapXa public ActionResult Index() { KichBanXa kbx = new KichBanXa(); DateTime tmp = DateTime.Today; tmp = tmp.AddHours(DateTime.Now.Hour + 1); ViewBag.MucNuoc = _common.GetDataLakeEVN(1, 1); ViewBag.LuuLuong = _common.GetDataLakeEVN(1, 5); var tmpListThietLap = _thietlapxa.GetListKichBanByUserTLVN(Convert.ToInt32(Security.CurrentUserId)); tmpListThietLap.Insert(0, new thiet_lap_kich_ban_tb { thiet_lap_kich_ban_code = -1, thiet_lap_kich_ban_name = "--Không chọn--" }); ViewBag.ListThietLap = new SelectList(tmpListThietLap, "thiet_lap_kich_ban_code", "thiet_lap_kich_ban_name", -1); kbx.KichBanChiTiet = new List <thiet_lap_kich_ban_detail_tb>() { new thiet_lap_kich_ban_detail_tb() { thoi_gian = tmp, luu_luong_du_bao = 2500, luu_luong_xa = 500, luu_luong_phat_dien = 100, tong_tran = 100 }, new thiet_lap_kich_ban_detail_tb() { thoi_gian = tmp.AddHours(1), luu_luong_du_bao = 2500, luu_luong_xa = 500, luu_luong_phat_dien = 100, tong_tran = 100 }, new thiet_lap_kich_ban_detail_tb() { thoi_gian = tmp.AddHours(2), luu_luong_du_bao = 2500, luu_luong_xa = 500, luu_luong_phat_dien = 100, tong_tran = 100 }, new thiet_lap_kich_ban_detail_tb() { thoi_gian = tmp.AddHours(3), luu_luong_du_bao = 2500, luu_luong_xa = 500, luu_luong_phat_dien = 100, tong_tran = 100 }, new thiet_lap_kich_ban_detail_tb() { thoi_gian = tmp.AddHours(4), luu_luong_du_bao = 2500, luu_luong_xa = 500, luu_luong_phat_dien = 100, tong_tran = 100 } }; return(View(kbx)); }
public ActionResult TaoKichBanXa(int vitricode, double mucnuoc, double luuluong, DateTime time, string jsondata) { List <thiet_lap_kich_ban_detail_tb> listKichBanChiTiet = serializer.Deserialize <List <thiet_lap_kich_ban_detail_tb> >(jsondata); listKichBanChiTiet = listKichBanChiTiet.OrderBy(x => x.thoi_gian).ToList(); KichBanXa kichBanXa = new KichBanXa() { KichBan = new thiet_lap_kich_ban_tb { thoi_gian = time, vi_tri_ref = vitricode, muc_nuoc_ho = mucnuoc, luu_luong_ve_ho = luuluong }, KichBanChiTiet = listKichBanChiTiet }; kichBanXa = _handl.TinhToanXa(kichBanXa); return(Json(kichBanXa.KichBanChiTiet)); }
public bool UpdateKichBan(KichBanXa kichBanXa) { bool result = false; if (kichBanXa != null & !String.IsNullOrEmpty(Security.CurrentUserGuid)) { try { thiet_lap_kich_ban_tb tmpThietLapKichBan = kichBanXa.KichBan; List <thiet_lap_kich_ban_detail_tb> tmpLapKichBanDetail = kichBanXa.KichBanChiTiet; if (tmpThietLapKichBan.thiet_lap_kich_ban_code == -1) { #region Insert moi var vitri = _database._databaseContext.vi_tri_tb.FirstOrDefault(x => x.vi_tri_code == tmpThietLapKichBan.vi_tri_ref); // Them moi thiet_lap_kich_ban_tb tmpThietLapKichBan.created_at = DateTime.Now; tmpThietLapKichBan.last_modified_at = DateTime.Now; tmpThietLapKichBan.created_by = Security.CurrentUserName; tmpThietLapKichBan.last_modified_by = Security.CurrentUserName; tmpThietLapKichBan.deleted_status = 0; tmpThietLapKichBan.user_ref = Convert.ToInt32(Security.CurrentUserId); if (vitri != null) { tmpThietLapKichBan.thiet_lap_kich_ban_name = String.Format("Hồ {0}: Kịch bản {1}", vitri.vi_tri_name, DateTime.Now.ToString("dd/MM/yyyy HH:mm")); } _database._databaseContext.thiet_lap_kich_ban_tb.Add(tmpThietLapKichBan); _database._databaseContext.SaveChanges(); // Them moi thiet_lap_kich_ban_detail_tb foreach (thiet_lap_kich_ban_detail_tb item in tmpLapKichBanDetail) { item.created_at = DateTime.Now; item.last_modified_at = DateTime.Now; item.created_by = Security.CurrentUserName; item.last_modified_by = Security.CurrentUserName; item.deleted_status = 0; item.thiet_lap_kich_ban_ref = tmpThietLapKichBan.thiet_lap_kich_ban_code; _database._databaseContext.thiet_lap_kich_ban_detail_tb.Add(item); } _database._databaseContext.SaveChanges(); result = true; #endregion } else { #region update // Cap nhat thiet_lap_kich_ban_tb thiet_lap_kich_ban_tb tmpGoc = _database._databaseContext.thiet_lap_kich_ban_tb.FirstOrDefault( x => x.thiet_lap_kich_ban_code == tmpThietLapKichBan.thiet_lap_kich_ban_code); if (tmpGoc != null) { tmpGoc.muc_nuoc_ho = tmpThietLapKichBan.muc_nuoc_ho; tmpGoc.luu_luong_ve_ho = tmpThietLapKichBan.luu_luong_ve_ho; tmpGoc.last_modified_at = DateTime.Now; tmpGoc.last_modified_by = Security.CurrentUserName; tmpGoc.deleted_status = 0; _database._databaseContext.thiet_lap_kich_ban_tb.Attach(tmpGoc); _database._databaseContext.Entry(tmpGoc).State = EntityState.Modified; _database._databaseContext.SaveChanges(); // Them moi thiet_lap_kich_ban_detail_tb string sqlDelete = String.Format(@"update thiet_lap_kich_ban_detail_tb set deleted_status = 1 where thiet_lap_kich_ban_ref = {0}", tmpGoc.thiet_lap_kich_ban_code); _database._databaseContext.Database.ExecuteSqlCommand(sqlDelete); foreach (thiet_lap_kich_ban_detail_tb item in tmpLapKichBanDetail) { item.created_at = DateTime.Now; item.last_modified_at = DateTime.Now; item.created_by = Security.CurrentUserName; item.last_modified_by = Security.CurrentUserName; item.deleted_status = 0; item.thiet_lap_kich_ban_ref = tmpThietLapKichBan.thiet_lap_kich_ban_code; _database._databaseContext.thiet_lap_kich_ban_detail_tb.Add(item); } _database._databaseContext.SaveChanges(); result = true; } #endregion } } catch (Exception ex) { } } return(result); }
public JsonResult GetInfoKichBan(int kichbancode) { KichBanXa tmp = _thietlapxa.GetInfoByKichBanCode(kichbancode); return(Json(tmp)); }