public override void ActionCancel() { CPViewPage.CPRedirectHome(); }
/// <summary> /// Chốt kỳ kinh doanh /// </summary> /// <param name="model"></param> public void ActionChotKy(ModDT_KyModel model) { CPViewPage.Message.MessageType = Message.MessageTypeEnum.Error; DbDataContext db = DbExecute.Create(true); Mod_DT_Ky objMod_DT_Ky = db.Mod_DT_Kies.Where(o => o.ID == model.RecordID).SingleOrDefault(); if (objMod_DT_Ky == null) { CPViewPage.Message.ListMessage.Add("Không tìm thấy kỳ kinh doanh hiện tại."); return; } // Cập nhật trạng thái cho Kỳ objMod_DT_Ky.Activity = false; // Đóng kỳ // Tổng hợp lại các giá trị hoa hồng cho từng đại lý if (objMod_DT_Ky.Mod_DT_Ky_DaiLies == null || objMod_DT_Ky.Mod_DT_Ky_DaiLies.Count <= 0) { db.SubmitChanges(); return; } List <Mod_DT_Ky_DaiLy> lstMod_DT_Ky_DaiLy = objMod_DT_Ky.Mod_DT_Ky_DaiLies.ToList(); lstMod_DT_Ky_DaiLy = lstMod_DT_Ky_DaiLy.OrderBy(o => o.ModProductAgentParentId).ToList(); // Tính tổng tiền lấy hàng foreach (var itemKyDaiLy in lstMod_DT_Ky_DaiLy) { List <Mod_DT_Ky_DaiLy_DonHang> lstMod_DT_Ky_DaiLy_DonHang = itemKyDaiLy.Mod_DT_Ky_DaiLy_DonHangs.ToList(); double doubTongTienLayHang = 0; foreach (var itemDaiLy_DonHang in lstMod_DT_Ky_DaiLy_DonHang) { doubTongTienLayHang += getValueDouble(itemDaiLy_DonHang.TongSauGiam); } // Cập nhật tổng tiền itemKyDaiLy.TongTienLayHang = doubTongTienLayHang; } // Lấy cấp tỷ lệ ăn chia hoa hồng List <Mod_DT_CapDaiLy_TyLe> lstMod_DT_CapDaiLy_TyLe = db.Mod_DT_CapDaiLy_TyLes.OrderBy(o => o.ID).ToList(); // Lấy các cấp cha để duyệt List <Mod_DT_Ky_DaiLy> lstMod_DT_Ky_DaiLy_Parent = lstMod_DT_Ky_DaiLy .Where(o => o.ModProductAgentParentId == null || o.ModProductAgentParentId == 0).ToList(); // TÍnh tổng hoa hồng trong kỳ double doubTongHoaHong = 0; foreach (var itemParent in lstMod_DT_Ky_DaiLy) { int iCapHoaHong = 0; double doubTongTienHoaHong = 0; // Cộng giá trị đầu kỳ nếu có double doubTotalLast = getValueDouble(itemParent.TotalFirst); // Lấy các đại lý con: Tính hoa hồng List <Mod_DT_Ky_DaiLy> lstMod_DT_Ky_DaiLy_Child = lstMod_DT_Ky_DaiLy .Where(o => o.ModProductAgentParentId != null && o.ModProductAgentParentId == itemParent.ModProductAgentId) .ToList(); if (lstMod_DT_Ky_DaiLy_Child != null && lstMod_DT_Ky_DaiLy_Child.Count > 0) { // Tính hoa hồng cho đại lý cấp đầu trước (Nếu tồn tại ít nhất một con) doubTongTienHoaHong = (getValueDouble(itemParent.TongTienLayHang) * getValueDouble(lstMod_DT_CapDaiLy_TyLe[iCapHoaHong].Value)) / 100; } // Duyệt các đại lý con foreach (var itemChild in lstMod_DT_Ky_DaiLy_Child) { doubTongTienHoaHong += getTienHoaHong(ref lstMod_DT_Ky_DaiLy, itemChild, lstMod_DT_CapDaiLy_TyLe, iCapHoaHong + 1); } // Lưu lại tổng tiền hoa hồng itemParent.TongTienHoaHong = doubTongTienHoaHong; // Tổng tiền thu nhập cuối kỳ itemParent.TotalLast = doubTotalLast + doubTongTienHoaHong; // Tổng hoa hồng trong kỳ doubTongHoaHong += doubTongTienHoaHong; } // Tính tổng hoa hồng trong kỳ doubTongHoaHong += getValueDouble(objMod_DT_Ky.TotalFirst); // Tổng hoa hồng trong kỳ objMod_DT_Ky.TotalLast = doubTongHoaHong; // Cập nhật vào DB db.SubmitChanges(); // Hiển thị thông báo CPViewPage.SetMessage("Đã chốt kỳ doanh thu thành công."); CPViewPage.Response.Redirect(CPViewPage.Request.RawUrl.Replace("Add.aspx", "Index.aspx")); }
public void ActionLogout() { CPViewPage.SetLog("Thoát khỏi hệ thống."); CPLogin.Logout(); CPViewPage.CPRedirect("Login.aspx"); }
public void ActionUpload(SysConfigModel model) { CPViewPage.Script("Redirect", "REDDEVILRedirect('Import')"); }
public void ActionSendMailExcute(EmailEntity emailEntity) { ViewBag.Data = emailEntity; CPViewPage.Message.MessageType = Message.MessageTypeEnum.Error; if (string.IsNullOrEmpty(emailEntity.To)) { CPViewPage.Message.ListMessage.Add("Bạn chưa nhập Email tiếp nhận."); } else { var toArr = emailEntity.To.Split(','); foreach (var i in toArr) { if (Utils.GetEmailAddress(i) == string.Empty) { CPViewPage.Message.ListMessage.Add("Định dạng Email tiếp nhận không đúng."); } } } if (!string.IsNullOrEmpty(emailEntity.Cc)) { var ccArr = emailEntity.Cc.Split(','); foreach (var i in ccArr) { if (Utils.GetEmailAddress(i) == string.Empty) { CPViewPage.Message.ListMessage.Add("Định dạng Email Cc không đúng."); } } } if (string.IsNullOrEmpty(emailEntity.Subject)) { CPViewPage.Message.ListMessage.Add("Bạn chưa nhập Tiêu đề."); } if (string.IsNullOrEmpty(emailEntity.Body)) { CPViewPage.Message.ListMessage.Add("Bạn chưa nhập Nội dung."); } if (CPViewPage.Message.ListMessage.Count == 0) { // Goi ham send mail string sendResult = Mail.SendMailUseSMTP(emailEntity.To, emailEntity.Cc, emailEntity.Subject, emailEntity.Body, emailEntity.Attach); if (!string.IsNullOrEmpty(sendResult)) { CPViewPage.Message.ListMessage.Add("Gửi mail lỗi. Hãy kiểm tra lại việc cấu hình email của bạn."); } else { CPViewPage.SetMessage("Gửi mail thành công."); // Thuc hien tang so lan gui mail them 1 var incident = ModIncidentService.Instance.CreateQuery().Where(o => o.ID == emailEntity.RecordID).ToSingle(); incident.EmailNo++; ModIncidentService.Instance.Save(incident); } } }
public void ActionExport2(ModIncidentModel model) { RenderView(model.Menu); //lấy danh sách // sap xep tu dong string orderBy = AutoSort(model.Sort); string orderAdd = string.Empty; if (model.Menu == "Phishing" && (model.PhishingState == 1 || model.PhishingState == 3) || model.Menu == "Malware" && (model.MalwareState == 1 || model.MalwareState == 3)) { orderAdd += "ChildNum DESC"; } else if (model.Menu == "Phishing" && (model.PhishingState == 2 || model.PhishingState == 4) || model.Menu == "Malware" && (model.MalwareState == 2 || model.MalwareState == 4)) { orderAdd += "ChildNum ASC"; } DateTime?f = HL.Core.Global.Convert.ToDateTime(model.From, DateTime.MinValue); DateTime?t = HL.Core.Global.Convert.ToDateTime(model.To, DateTime.MaxValue); DateTime?from = f != DateTime.MinValue ? f : null; DateTime?to = t != DateTime.MaxValue ? t : null; var all = ModIncidentService.Instance.CreateQuery() .Where(model.State > 0, o => (o.State & model.State) == model.State) .Where(from != null, o => o.AttackOn >= from) .Where(to != null, o => o.AttackOn <= to) .WhereIn(o => o.MenuID, WebMenuService.Instance.GetChildIDForCP("Incident", model.MenuID, model.LangID)) .ToList(); // Tao danh sach cha DBQuery <ModIncidentEntity> dbQuery = null; if (model.PhishingState == 1 || model.PhishingState == 2 || model.MalwareState == 1 || model.MalwareState == 2) { if (model.Menu == "Phishing") { dbQuery = ModIncidentService.Instance.CreateQuery() .WhereIn(o => o.MenuID, WebMenuService.Instance.GetChildIDForCP("Incident", model.MenuID, model.LangID)) .Select(o => o.Path) .Distinct(); } if (model.Menu == "Malware") { dbQuery = ModIncidentService.Instance.CreateQuery() .WhereIn(o => o.MenuID, WebMenuService.Instance.GetChildIDForCP("Incident", model.MenuID, model.LangID)) .Select(o => o.MalwareName) .Distinct(); } } else { dbQuery = ModIncidentService.Instance.CreateQuery() .WhereIn(o => o.MenuID, WebMenuService.Instance.GetChildIDForCP("Incident", model.MenuID, model.LangID)) .Select(o => o.ISP) .Distinct(); } var lst = dbQuery.ToList(); if (lst == null || all == null) { CPViewPage.SetMessage("Không có dữ liệu."); return; } var listEntity = new List <ModIncidentEntity>(); if (model.Menu == "Phishing") { if (model.PhishingState == 1) { listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity { Path = o.Path, ISP = "", AttackOn = null, ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ParentID == o.ID).ToList().Count }) .OrderByDescending(o => o.ChildNum) .Take(model.PageSize) .Skip(model.PageIndex * model.PageSize) .ToList(); } else if (model.PhishingState == 2) { listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity { Path = o.Path, ISP = "", AttackOn = null, ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ParentID == o.ID).ToList().Count }) .OrderBy(o => o.ChildNum) .Take(model.PageSize) .Skip(model.PageIndex * model.PageSize) .ToList(); } else if (model.PhishingState == 3) { listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity { Path = "", ISP = o.ISP, AttackOn = null, ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ISP == o.ISP).ToList().Count }) .OrderByDescending(o => o.ChildNum) .Take(model.PageSize) .Skip(model.PageIndex * model.PageSize) .ToList(); } else if (model.PhishingState == 4) { listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity { Path = "", ISP = o.ISP, AttackOn = null, ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ISP == o.ISP).ToList().Count }) .OrderBy(o => o.ChildNum) .Take(model.PageSize) .Skip(model.PageIndex * model.PageSize) .ToList(); } else { listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity { Path = o.Path, ISP = "", AttackOn = null, ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ParentID == o.ID).ToList().Count }) .OrderBy(o => o.Path) .Take(model.PageSize) .Skip(model.PageIndex * model.PageSize) .ToList(); } } if (model.Menu == "Malware") { if (model.MalwareState == 1) { listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity { MalwareName = o.MalwareName, ISP = "", AttackOn = null, ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.MalwareName == o.MalwareName).ToList().Count }) .OrderByDescending(o => o.ChildNum) .Take(model.PageSize) .Skip(model.PageIndex * model.PageSize) .ToList(); } else if (model.MalwareState == 2) { listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity { MalwareName = o.MalwareName, ISP = "", AttackOn = null, ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.MalwareName == o.MalwareName).ToList().Count }) .OrderBy(o => o.ChildNum) .Take(model.PageSize) .Skip(model.PageIndex * model.PageSize) .ToList(); } else if (model.MalwareState == 3) { listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity { MalwareName = "", ISP = o.ISP, AttackOn = null, ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ISP == o.ISP).ToList().Count }) .OrderByDescending(o => o.ChildNum) .Take(model.PageSize) .Skip(model.PageIndex * model.PageSize) .ToList(); } else if (model.MalwareState == 4) { listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity { MalwareName = "", ISP = o.ISP, AttackOn = null, ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ISP == o.ISP).ToList().Count }) .OrderBy(o => o.ChildNum) .Take(model.PageSize) .Skip(model.PageIndex * model.PageSize) .ToList(); } else { listEntity = dbQuery.ToList().Select(o => new ModIncidentEntity { MalwareName = o.MalwareName, ISP = "", AttackOn = null, ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.MalwareName == o.MalwareName).ToList().Count }) .OrderBy(o => o.Path) .Take(model.PageSize) .Skip(model.PageIndex * model.PageSize) .ToList(); } } //khai báo tập hợp bản ghi excel List <List <object> > list = new List <List <object> >(); //khai báo 1 dòng excel List <object> _list = null; for (int i = 0; listEntity != null && listEntity.Count > 0 && i < listEntity.Count; i++) { _list = new List <object>(); // _list.Add(i + 1); if (model.PhishingState == 1) { _list.Add(listEntity[i].Path); var ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ParentID == listEntity[i].ID).ToList().Count; _list.Add(ChildNum); } else if (model.MalwareState == 1) { _list.Add(listEntity[i].MalwareName); var ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.MalwareName == listEntity[i].MalwareName).ToList().Count; _list.Add(ChildNum); } else { _list.Add(listEntity[i].ISP); var ChildNum = ModIncidentService.Instance.CreateQuery().Where(a => a.ISP == listEntity[i].ISP).ToList().Count; _list.Add(ChildNum); } list.Add(_list); } //ghi exel string temp_file = CPViewPage.Server.MapPath("~/Data/upload/files/Excel/BaoCaoSuCo_" + model.Menu + "_" + string.Format("{0:yyyy_MM_dd}", DateTime.Now) + ".xlsx"); string filePath = CPViewPage.Server.MapPath("~/TTPortal/Templates/Export_Deface.xlsx"); Excel.Export(list, 1, filePath, temp_file); CPViewPage.Response.Clear(); CPViewPage.Response.ContentType = "application/excel"; CPViewPage.Response.AppendHeader("Content-Disposition", "attachment; filename=" + System.IO.Path.GetFileName(temp_file)); CPViewPage.Response.WriteFile(temp_file); CPViewPage.Response.End(); }
public override void ActionCancel() { CPViewPage.Script("Cancel", "Cancel()"); }
public void ActionApply(SysResourceModel model) { if (model.Type > 0) { if (model.Type == 1 && !string.IsNullOrEmpty(model.Value1)) { string[] Arr = model.Value1.Split('\n'); for (int i = 0; i < Arr.Length; i++) { string s = Arr[i].Trim(); if (string.IsNullOrEmpty(s)) { continue; } if (s.StartsWith("//")) { continue; } int index = s.IndexOf('='); if (index == -1) { continue; } string key = s.Substring(0, index).Trim(); string value = s.Substring(index + 1).Trim(); if (WebResourceService.Instance.CP_HasExists(key, model.LangID1)) { if (model.Overwrite1) { var rs = WebResourceService.Instance.CreateQuery() .Where(o => o.LangID == model.LangID1 && o.Code == key) .ToSingle(); rs.Value = value; WebResourceService.Instance.Save(rs, o => o.Value); } } else { WebResourceService.Instance.Save(new WebResourceEntity { LangID = model.LangID1, Code = key, Value = value }); } } } else if (model.Type == 2) { if (model.FLangID2 != model.TLangID2) { var listRS = WebResourceService.Instance.CreateQuery() .Where(o => o.LangID == model.FLangID2) .ToList(); for (int i = 0; listRS != null && i < listRS.Count; i++) { string key = listRS[i].Code; string value = listRS[i].Value; if (WebResourceService.Instance.CP_HasExists(key, model.TLangID2)) { if (model.Overwrite2) { var rs = WebResourceService.Instance.CreateQuery() .Where(o => o.LangID == model.TLangID2 && o.Code == key) .ToSingle(); rs.Value = value; WebResourceService.Instance.Save(rs, o => o.Value); } } else { WebResourceService.Instance.Save(new WebResourceEntity { LangID = model.TLangID2, Code = key, Value = value }); } } } } else if (model.Type == 3) { //var listRS = WebResourceService.Instance.CreateQuery() // .Where(o => o.LangID == model.LangID3) // .ToList(); //for (int i = 0; listRS != null && i < listRS.Count; i++) //{ // string key = listRS[i].Code; // string value = GetTranslate(listRS[i].Value, model.FLangID3, model.TLangID3); // if (value != string.Empty) // { // listRS[i].Value = value; // WebResourceService.Instance.Save(listRS[i], o => o.Value); // } //} } if ((model.Type == 1 && !string.IsNullOrEmpty(model.Value1)) || model.Type == 2 || model.Type == 3) { CPViewPage.SetMessage("Thông tin đã cập nhật."); return; } } if (ValidSave(model)) { ApplyRedirect(model.RecordID, item.ID); } }
public void ActionUpload(SysResourceModel model) { CPViewPage.Script("Redirect", "VSWRedirect('Import')"); }
public void ActionExport(ModNhanLucUCSCModel model) { //lấy danh sách // sap xep tu dong string orderBy = AutoSort(model.Sort); var lstDonDk = ModDonDangKyUCSCService.Instance.CreateQuery() .Where(o => o.UserID == model.ThanhVienID && o.Activity == true) .ToSingle(); var lstHSThanhVien = ModHSThanhVienUCSCService.Instance.CreateQuery() .Where(o => o.UserID == model.ThanhVienID && o.Activity == true) .ToSingle(); int donDk = 0, hsThanhVien = 0; if (lstDonDk != null) { donDk = lstDonDk.ID; } if (lstHSThanhVien != null) { hsThanhVien = lstHSThanhVien.ID; } // tao danh sach var dbQuery = ModNhanLucUCSCService.Instance.CreateQuery() .Where(!string.IsNullOrEmpty(model.SearchText), o => o.Name.Contains(model.SearchText)) .Where(model.MenuIDs_TrinhDoDT > 0, o => o.MenuIDs_TrinhDoDT.Contains(model.MenuIDs_TrinhDoDT.ToString())) .Where(model.MenuIDs_ChungChi > 0, o => o.MenuIDs_ChungChi.Contains(model.MenuIDs_ChungChi.ToString())) .Where(donDk > 0, o => o.DonDangKyUCSCID == donDk) .Where(hsThanhVien > 0, o => o.HSThanhVienUCSCID == hsThanhVien) .OrderBy(orderBy); var listEntity = dbQuery.ToList(); if (listEntity == null) { CPViewPage.SetMessage("Không có dữ liệu."); return; } //khai báo tập hợp bản ghi excel List <List <object> > list = new List <List <object> >(); //khai báo 1 dòng excel List <object> _list = null; for (int i = 0; listEntity != null && listEntity.Count > 0 && i < listEntity.Count; i++) { _list = new List <object>(); var lstTd = listEntity[i].getMenuTrinhDo().Select(o => o.Name).ToArray(); var lstCc = listEntity[i].getMenuChungChi().Select(o => o.Name).ToArray(); string td = "", cc = ""; if (lstTd.Length > 0) { td = string.Join(",", lstTd); } if (lstCc.Length > 0) { cc = string.Join(",", lstCc); } var donDangky = ModDonDangKyUCSCService.Instance.CreateQuery() .Where(o => o.ID == listEntity[i].DonDangKyUCSCID && o.Activity == true) .ToSingle(); var hSThanhVien = ModHSThanhVienUCSCService.Instance.CreateQuery() .Where(o => o.ID == listEntity[i].HSThanhVienUCSCID && o.Activity == true) .ToSingle(); int tvId = donDangky != null ? donDangky.UserID : hSThanhVien.UserID; var user = CPUserService.Instance.GetByID(tvId); string loginName = ""; if (user != null) { loginName = user.LoginName; } _list.Add(loginName); _list.Add(td); _list.Add(cc); _list.Add(listEntity[i].Name); _list.Add(listEntity[i].School); _list.Add(listEntity[i].NamTotNghiep); list.Add(_list); } //ghi exel string temp_file = CPViewPage.Server.MapPath("~/Data/upload/files/Excel/NhanLuc_" + string.Format("{0:yyyy_MM_dd}", DateTime.Now) + ".xlsx"); string filePath = CPViewPage.Server.MapPath("~/TTPortal/Templates/Export_NhanLuc.xlsx"); Excel.Export(list, 1, filePath, temp_file); //CPViewPage.Response.Write("Here!6"); CPViewPage.Response.Clear(); CPViewPage.Response.ContentType = "application/excel"; CPViewPage.Response.AppendHeader("Content-Disposition", "attachment; filename=" + System.IO.Path.GetFileName(temp_file)); CPViewPage.Response.WriteFile(temp_file); CPViewPage.Response.End(); //CPViewPage.Response.Write("Here!"); }
public void ActionChangeLang(string langCode) { Cookies.SetValue("CP.Lang", langCode, true); CPViewPage.RefreshPage(); }