public async Task <IActionResult> GetSysInfo() { CommonResult result = new CommonResult(); try { SysSetting sysSetting = XmlConverter.Deserialize <SysSetting>("xmlconfig/sys.config"); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); yuebonCacheHelper.Add("SysSetting", sysSetting); DashboardOutModel dashboardOutModel = new DashboardOutModel(); dashboardOutModel.CertificatedCompany = sysSetting.CompanyName; dashboardOutModel.WebUrl = sysSetting.WebUrl; dashboardOutModel.Title = sysSetting.SoftName; dashboardOutModel.MachineName = Environment.MachineName; dashboardOutModel.ProcessorCount = Environment.ProcessorCount; dashboardOutModel.SystemPageSize = Environment.SystemPageSize; dashboardOutModel.WorkingSet = Environment.WorkingSet; dashboardOutModel.TickCount = Environment.TickCount; dashboardOutModel.RunTimeLength = (Environment.TickCount / 1000).ToBrowseTime(); dashboardOutModel.FrameworkDescription = RuntimeInformation.FrameworkDescription; dashboardOutModel.OSName = RuntimeInformation.IsOSPlatform(OSPlatform.Linux) ? "Linux" : RuntimeInformation.IsOSPlatform(OSPlatform.OSX) ? "OSX" : "Windows"; dashboardOutModel.OSDescription = RuntimeInformation.OSDescription + " " + RuntimeInformation.OSArchitecture; dashboardOutModel.OSArchitecture = RuntimeInformation.OSArchitecture.ToString(); dashboardOutModel.ProcessArchitecture = RuntimeInformation.ProcessArchitecture.ToString(); dashboardOutModel.Directory = AppContext.BaseDirectory; Version version = Environment.Version; dashboardOutModel.SystemVersion = version.Major + "." + version.Minor + "." + version.Build; dashboardOutModel.Version = AppVersionHelper.Version; dashboardOutModel.Manufacturer = AppVersionHelper.Manufacturer; dashboardOutModel.WebSite = AppVersionHelper.WebSite; dashboardOutModel.UpdateUrl = AppVersionHelper.UpdateUrl; dashboardOutModel.IPAdress = Request.HttpContext.Connection.LocalIpAddress.ToString(); dashboardOutModel.Port = Request.HttpContext.Connection.LocalPort.ToString(); dashboardOutModel.TotalUser = await userService.GetCountByWhereAsync("1=1"); dashboardOutModel.TotalModule = await menuService.GetCountByWhereAsync("1=1"); dashboardOutModel.TotalRole = await roleService.GetCountByWhereAsync("1=1"); dashboardOutModel.TotalTask = await taskManagerService.GetCountByWhereAsync("1=1"); result.ResData = dashboardOutModel; result.ErrCode = ErrCode.successCode; } catch (Exception ex) { Log4NetHelper.Error("获取系统信息异常", ex); result.ErrMsg = ErrCode.err60001; result.ErrCode = "60001"; } return(ToJsonContent(result)); }
public IActionResult Save(SysSetting info) { CommonResult result = new CommonResult(); info.LocalPath = _hostingEnvironment.WebRootPath; SysSetting sysSetting = XmlConverter.Deserialize <SysSetting>("xmlconfig/sys.config"); sysSetting = info; //对关键信息加密 if (!string.IsNullOrEmpty(info.Email)) { sysSetting.Email = DEncrypt.Encrypt(info.Email); } if (!string.IsNullOrEmpty(info.Emailsmtp)) { sysSetting.Emailsmtp = DEncrypt.Encrypt(info.Emailsmtp); } if (!string.IsNullOrEmpty(info.Emailpassword)) { sysSetting.Emailpassword = DEncrypt.Encrypt(info.Emailpassword); } if (!string.IsNullOrEmpty(info.Smspassword)) { sysSetting.Smspassword = DEncrypt.Encrypt(info.Smspassword); } if (!string.IsNullOrEmpty(info.Smsusername)) { sysSetting.Smsusername = DEncrypt.Encrypt(info.Smsusername); } string uploadPath = _hostingEnvironment.WebRootPath + "/" + sysSetting.Filepath; if (!Directory.Exists(uploadPath)) { Directory.CreateDirectory(uploadPath); } YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); if (yuebonCacheHelper.Exists("SysSetting")) { yuebonCacheHelper.Replace("SysSetting", sysSetting); } else { //写入缓存 yuebonCacheHelper.Add("SysSetting", sysSetting); } XmlConverter.Serialize <SysSetting>(sysSetting, "xmlconfig/sys.config"); result.ErrCode = ErrCode.successCode; return(ToJsonContent(result)); }
public SysSetting ToEntity() { var sysSetting = new SysSetting { ID = ID, KeyName = KeyName, ValueType = ValueType, Value = Value, Description = Description, KeyGroup = KeyGroup }; return sysSetting; }
public override async Task <IActionResult> DeleteBatchAsync(DeletesInputDto info) { CommonResult result = new CommonResult(); string where = string.Empty; where = "id in ('" + info.Ids.Join(",").Trim(',').Replace(",", "','") + "')"; if (!string.IsNullOrEmpty(where)) { dynamic[] jobsId = info.Ids; foreach (var item in jobsId) { if (string.IsNullOrEmpty(item.ToString())) { continue; } UploadFile uploadFile = new UploadFileApp().Get(item.ToString()); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = yuebonCacheHelper.Get("SysSetting").ToJson().ToObject <SysSetting>(); if (uploadFile != null) { if (System.IO.File.Exists(sysSetting.LocalPath + "/" + uploadFile.FilePath)) { System.IO.File.Delete(sysSetting.LocalPath + "/" + uploadFile.FilePath); } if (!string.IsNullOrEmpty(uploadFile.Thumbnail)) { if (System.IO.File.Exists(sysSetting.LocalPath + "/" + uploadFile.Thumbnail)) { System.IO.File.Delete(sysSetting.LocalPath + "/" + uploadFile.Thumbnail); } } } } bool bl = await iService.DeleteBatchWhereAsync(where).ConfigureAwait(false); if (bl) { result.ErrCode = ErrCode.successCode; result.ErrMsg = ErrCode.err0; } else { result.ErrMsg = ErrCode.err43003; result.ErrCode = "43003"; } } return(ToJsonContent(result)); }
public async Task <IActionResult> Save(SysSetting model, string columns = "") { var errMsg = GetModelErrMsg(); if (!string.IsNullOrEmpty(errMsg)) { return(ErrRes(errMsg)); } model.Status = model.Status ?? 2; if (string.IsNullOrEmpty(model.SysSettingId) || !_unitOfWork.SysSettingRepository.Any(o => o.SysSettingId == model.SysSettingId)) { //model.SysSettingId = GuidKey; model.CreateTime = DateTime.Now; model.CreateUser = Id; result = await _unitOfWork.SysSettingRepository.InsertAsync(model); if (result) { _logger.LogInformation($"添加{_entityName}{model.SysSettingName}"); } } else { //定义可以修改的列 var lstColumn = new List <string>() { nameof(SysSetting.SysSettingName), nameof(SysSetting.SysSettingGroup), nameof(SysSetting.Sort), nameof(SysSetting.Remark), nameof(SysSetting.Status), nameof(SysSetting.SetValue), nameof(SysSetting.SysSettingType), }; if (!string.IsNullOrEmpty(columns))//固定过滤只修改某字段 { if (lstColumn.Count == 0) { lstColumn = columns.Split(',').ToList(); } else { lstColumn = lstColumn.Where(o => columns.Split(',').Contains(o)).ToList(); } } result = await _unitOfWork.SysSettingRepository.UpdateAsync(model, true, lstColumn); if (result) { _logger.LogInformation($"修改{_entityName}{model.SysSettingName}"); } } return(result ? SuccessRes() : ErrRes()); }
public IActionResult GetAllInfo() { CommonResult result = new CommonResult(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = yuebonCacheHelper.Get("SysSetting").ToJson().ToObject <SysSetting>(); SysSettingOutputDto sysSettingOutputDto = new SysSettingOutputDto(); if (sysSetting == null) { sysSetting = XmlConverter.Deserialize <SysSetting>("xmlconfig/sys.config"); } //对关键信息解密 if (!string.IsNullOrEmpty(sysSetting.Email)) { sysSetting.Email = DEncrypt.Decrypt(sysSetting.Email); } if (!string.IsNullOrEmpty(sysSetting.Emailsmtp)) { sysSetting.Emailsmtp = DEncrypt.Decrypt(sysSetting.Emailsmtp); } if (!string.IsNullOrEmpty(sysSetting.Emailpassword)) { sysSetting.Emailpassword = DEncrypt.Decrypt(sysSetting.Emailpassword); } if (!string.IsNullOrEmpty(sysSetting.Smspassword)) { sysSetting.Smspassword = DEncrypt.Decrypt(sysSetting.Smspassword); } if (!string.IsNullOrEmpty(sysSetting.Smsusername)) { sysSetting.Smsusername = DEncrypt.Decrypt(sysSetting.Smsusername); } sysSettingOutputDto = sysSetting.MapTo <SysSettingOutputDto>(); if (sysSettingOutputDto != null) { sysSettingOutputDto.CopyRight = UIConstants.CopyRight; result.ResData = sysSettingOutputDto; result.Success = true; result.ErrCode = ErrCode.successCode; } else { result.ErrMsg = ErrCode.err60001; result.ErrCode = "60001"; } return(ToJsonContent(result)); }
private void InitSubForm() { panel1.Controls.Clear(); MainForm mForm = new MainForm(); mForm.TopLevel = false; mForm.Dock = DockStyle.Fill; mForm.Parent = this.panel1; panel1.Controls.Add(mForm); //mForm.Show(); //mssa.ControlInitSize(this); //比例最大化的初始化 //curForm = mForm; SysSetting sysSetForm = new SysSetting(); sysSetForm.TopLevel = false; //mForm.FormBorderStyle = FormBorderStyle.None; sysSetForm.Dock = DockStyle.Fill; sysSetForm.Parent = this.panel1; }
public IActionResult DeleteFile(string id) { CommonResult result = new CommonResult(); try { UploadFile uploadFile = new UploadFileApp().Get(id); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = yuebonCacheHelper.Get("SysSetting").ToJson().ToObject <SysSetting>(); string localpath = _hostingEnvironment.WebRootPath; if (uploadFile != null) { string filepath = (localpath + "/" + uploadFile.FilePath).ToFilePath(); if (System.IO.File.Exists(filepath)) { System.IO.File.Delete(filepath); } string filepathThu = (localpath + "/" + uploadFile.Thumbnail).ToFilePath(); if (System.IO.File.Exists(filepathThu)) { System.IO.File.Delete(filepathThu); } result.ErrCode = ErrCode.successCode; result.Success = true; } else { result.ErrCode = ErrCode.failCode; result.Success = false; } } catch (Exception ex) { Log4NetHelper.Error("", ex); result.ErrCode = "500"; result.ErrMsg = ex.Message; } return(ToJsonContent(result)); }
public SysSetting GetSysSetting(Guid id) { SysSetting sysSetting = null; try { using (SqlConnection con = _databaseFactory.GetDBConnection()) { using (SqlCommand cmd = new SqlCommand()) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Connection = con; cmd.CommandText = "[PSA].[GetSysSetting]"; cmd.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = id; cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { if (sdr.Read()) { sysSetting = new SysSetting(); sysSetting.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : sysSetting.ID); sysSetting.Name = (sdr["Name"].ToString() != "" ? sdr["Name"].ToString() : sysSetting.Name); sysSetting.Value = (sdr["Value"].ToString() != "" ? sdr["Value"].ToString() : sysSetting.Value); } } } } } } catch (Exception ex) { throw ex; } return(sysSetting); }
public int Edit(SysSetting model) { if (model.Id == 0) { model.Id = Common.PrimaryKey.GetHashCodeID; DB.Set <SysSetting>().Add(model); } else { var line = DB.SysSetting.Where(c => c.Id == model.Id).Update(b => new SysSetting { TimeStamp = DateTime.Now, SystemName = model.SystemName, Contact = model.Contact, Feeback = model.Feeback, IsEnable = model.IsEnable }); if (!string.IsNullOrEmpty(model.LoginLogo)) { line = DB.SysSetting.Where(c => c.Id == model.Id).Update(b => new SysSetting { LoginLogo = model.LoginLogo }); } if (!string.IsNullOrEmpty(model.FootLogo)) { line = DB.SysSetting.Where(c => c.Id == model.Id).Update(b => new SysSetting { FootLogo = model.FootLogo }); } if (!string.IsNullOrEmpty(model.HomeLogo)) { line = DB.SysSetting.Where(c => c.Id == model.Id).Update(b => new SysSetting { HomeLogo = model.HomeLogo }); } return(line); } return(DB.SaveChanges()); }
private void ToolSysSetting_Click(object sender, EventArgs e) { try { Form frm = new SysSetting(); frm.ShowDialog(); var sysConfig = new SysConfigService().Get(); SysConfig.PrintType = sysConfig.PrintType; SysConfig.IP = sysConfig.IP; SysConfig.Port = sysConfig.Port; SysConfig.DomainName = sysConfig.DomainName; SysConfig.ScanPortName = sysConfig.ScanPortName; if (serialPort_Scan.IsOpen) { serialPort_Scan.Close(); } serialPort_Scan.PortName = SysConfig.ScanPortName ?? ""; serialPort_Scan.Open(); }catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void sysBtn_Click(object sender, EventArgs e) { if (lastSender == sender) { return; } if (curForm != null) { curForm.Close(); } SysSetting form = new SysSetting(); panel1.Controls.Clear(); form.TopLevel = false; form.Dock = DockStyle.Fill; form.Parent = this.panel1; panel1.Controls.Add(form); form.Show(); mssa.ControlInitSize(this); //比例最大化的初始化 curForm = form; lastSender = sender; }
public IActionResult GetInfo() { CommonResult result = new CommonResult(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = yuebonCacheHelper.Get("SysSetting").ToJson().ToObject <SysSetting>(); SysSettingOutputDto sysSettingOutputDto = new SysSettingOutputDto(); if (sysSetting == null) { sysSetting = XmlConverter.Deserialize <SysSetting>("xmlconfig/sys.config"); } sysSetting.Email = ""; sysSetting.Emailsmtp = ""; sysSetting.Emailpassword = ""; sysSetting.Smspassword = ""; sysSetting.SmsSignName = ""; sysSetting.Smsusername = ""; sysSettingOutputDto = sysSetting.MapTo <SysSettingOutputDto>(); if (sysSettingOutputDto != null) { sysSettingOutputDto.CopyRight = UIConstants.CopyRight; result.ResData = sysSettingOutputDto; result.Success = true; result.ErrCode = ErrCode.successCode; } else { result.ErrMsg = ErrCode.err60001; result.ErrCode = "60001"; } IEnumerable <APP> appList = aPPService.GetAllByIsNotDeleteAndEnabledMark(); yuebonCacheHelper.Add("AllowAppId", appList); return(ToJsonContent(result)); }
protected void logOut_Click(object sender, EventArgs e) { if (Session["account"] != null || Session["player"] != null) { string userName = string.Empty; if (Session["account"] == null) { userName = ((Lib.Player)(Session["player"])).ID; SysSetting.AddLog("登入", userName, "一般受測人員登出成功", DateTime.Now); } else { userName = ((Lib.Account)(Session["account"])).ID; SysSetting.AddLog("登入", userName, "進階使用者登出成功", DateTime.Now); } Session.Clear(); Response.Redirect("~/Login.aspx"); } else { Response.Redirect("~/Login.aspx"); } }
/// <summary> /// 设置系统参数序列化 /// </summary> /// <param name="set"></param> public static void SetSetting(SysSetting set) { Voodoo.IO.XML.SaveSerialize(set, settingPath); }
protected void btn_Save_Click(object sender, EventArgs e) { DataEntities ent = new DataEntities(); User u = UserAction.opuser; UserGroup g = //UserGroupView.GetModelByID(u.Group.ToS()); (from l in ent.UserGroup where l.ID == u.Group select l).FirstOrDefault(); if (FileUpload1.FileName.IsNullOrEmpty()) { Js.AlertAndGoback("为提高您文章的排名,请选择一张标题图片"); return; } #region 图片 SysSetting ss = BasePage.SystemSetting; HttpPostedFile file = Request.Files["FileUpload1"]; string FileName = file.FileName.GetFileNameFromPath(); //文件名 string ExtName = file.FileName.GetFileExtNameFromPath(); //扩展名 string NewName = @string.GetGuid() + ExtName; //新文件名 if (!ExtName.Replace(".", "").IsInArray(ss.FileExtNameFilter.Split(','))) { Js.AlertAndGoback("不允许上传此类文件"); return; } if (file.ContentLength > ss.MaxPostFileSize) { Js.AlertAndGoback("文件太大"); return; } string Folder = ss.FileDir + "/" + DateTime.Now.ToString("yyyy-MM-dd") + "/"; //文件目录 string FolderShotCut = Folder + "ShortCut/"; //缩略图目录 string FilePath = Folder + NewName; //文件路径 string FilePath_ShortCut = FolderShotCut + NewName; //缩略图路径 file.SaveAs(Server.MapPath(FilePath), true); ImageHelper.MakeThumbnail(Server.MapPath(FilePath), Server.MapPath(FilePath_ShortCut), 105, 118, "Cut"); FileInfo savedFile = new FileInfo(Server.MapPath(FilePath)); Voodoo.Basement.File f = new Voodoo.Basement.File(); f.FileDirectory = ss.FileDir; f.FileExtName = ExtName; f.FilePath = FilePath; f.FileSize = (savedFile.Length / 1024).ToInt32(); //f.FileType= f.SmallPath = FilePath_ShortCut; f.UpTime = DateTime.Now; ent.AddToFile(f); ent.SaveChanges(); #endregion News n = new News(); n.Author = txt_Author.Text.TrimDbDangerousChar(); n.AutorID = UserAction.opuser.ID; n.ClassID = ddl_Class.SelectedValue.ToInt32(); n.ClickCount = 0; n.Content = txt_Content.Text.TrimDbDangerousChar(); n.Description = txt_Description.Text.TrimDbDangerousChar(); n.DownCount = 0; n.EnableReply = false; n.FTitle = txtFtitle.Text.TrimDbDangerousChar(); n.KeyWords = txt_Keyword.Text.TrimDbDangerousChar(); n.ModelID = 0; n.NavUrl = ""; n.NewsTime = DateTime.Now; n.SetTop = false; n.Source = txt_Source.Text.TrimDbDangerousChar(); n.Title = txt_Title.Text.TrimDbDangerousChar(); n.TitleColor = "000"; n.TitleImage = FilePath;//上传图片 n.ZtID = 0; n.Audit = g.PostAotuAudit; n.FileForder = DateTime.Now.ToString("yyyy-MM-dd"); n.ID = WS.RequestInt("id"); Result r = NewsAction.UserPost(n, UserAction.opuser); if (r.Success) { Js.AlertAndChangUrl(r.Text, "PostList.aspx"); } else { Js.AlertAndGoback(r.Text); } ent.Dispose(); }
protected void btnSave_Click(object sender, EventArgs e) { ISysSettingService sysSettingService = IoC.Resolve <ISysSettingService>(); List <SysSetting> sysSettingList = new List <SysSetting>(); //平台名称 SysSetting sysSetting = new SysSetting(); sysSetting.Key = "PTMC"; sysSetting.Value = this.txtTitle.Text; sysSettingList.Add(sysSetting); //网站开关 SysSetting sysSetting1 = new SysSetting(); sysSetting1.Key = "WZKG"; sysSetting1.Value = drpIsShowDialog.SelectedValue; sysSettingList.Add(sysSetting1); //网站公告开关 SysSetting sysSetting2 = new SysSetting(); sysSetting2.Key = "WZGGKG"; sysSetting2.Value = this.txtContent.Text; sysSettingList.Add(sysSetting2); //中奖排行开关 SysSetting sysSetting3 = new SysSetting(); sysSetting3.Key = "ZJPHKG"; sysSetting3.Value = drpShangBanOpen.SelectedValue; sysSettingList.Add(sysSetting3); //会员上榜最低中奖金额 SysSetting sysSetting4 = new SysSetting(); sysSetting4.Key = "HYSPZDZJJE"; sysSetting4.Value = this.txtMinMonery.Text; sysSettingList.Add(sysSetting4); //虚拟上榜会员昵称 CreateSettingItem("XNSPHYNC", this.txtXuNiInContennt.Text, sysSettingList); //充值限制 SysSetting sysSetting5 = new SysSetting(); sysSetting5.Key = "CZXZ"; sysSetting5.Value = (string.IsNullOrEmpty(this.txtInMinMonery.Text.Trim()) ? "10" : this.txtInMinMonery.Text.Trim()) + "," + (string.IsNullOrEmpty(this.txtInMaxMonery.Text.Trim()) ? "50000" : this.txtInMaxMonery.Text.Trim()); sysSettingList.Add(sysSetting5); //提现限制 SysSetting sysSetting6 = new SysSetting(); sysSetting6.Key = "TXXZ"; sysSetting6.Value = (string.IsNullOrEmpty(this.txtOutMinMonery.Text.Trim()) ? "100" : this.txtOutMinMonery.Text.Trim()) + "," + (string.IsNullOrEmpty(this.txtOutMaxMonery.Text.Trim()) ? "50000" : this.txtOutMaxMonery.Text.Trim()); sysSettingList.Add(sysSetting6); //注册赠送活动 SettingDTO settingDto = new SettingDTO() { p1 = this.chkopenZengSong.Checked ? "0" : "1", p2 = txtNewUserZenSong.Text.Trim(), p3 = txtNewUserBeiShu.Text.Trim(), }; var des = Newtonsoft.Json.JsonConvert.SerializeObject(settingDto); SysSetting sysSetting7 = new SysSetting(); sysSetting7.Key = "ZCZSHD"; sysSetting7.Value = des; sysSettingList.Add(sysSetting7); double outBili = 5; if (double.TryParse(this.txtRechangeMinBili.Text.Trim(), out outBili)) { SysSetting sysSetting8 = new SysSetting(); sysSetting8.Key = "chongzhiBili"; sysSetting8.Value = outBili.ToString(); sysSettingList.Add(sysSetting8); } //登录失败时跳转 SysSetting sysSetting9 = new SysSetting(); sysSetting9.Key = "ZXLTPATH"; sysSetting9.Value = this.txtUrl.Text.Trim(); sysSettingList.Add(sysSetting9); //客服地址 SysSetting sysSetting10 = new SysSetting(); sysSetting10.Key = "KHLJ"; sysSetting10.Value = this.txtKfAddress.Text.Trim(); sysSettingList.Add(sysSetting10); //提现审核 SysSetting sysSetting11 = new SysSetting(); sysSetting11.Key = "QLZHGZ"; sysSetting11.Value = this.txtShMonery.Text.Trim(); sysSettingList.Add(sysSetting11); ////摩宝 SysSetting sysSetting12 = new SysSetting(); sysSetting12.Key = "mobao_pay"; sysSetting12.Value = this.drpMb.SelectedValue; sysSettingList.Add(sysSetting12); ////智付 SysSetting sysSetting13 = new SysSetting(); sysSetting13.Key = "zhifu_pay"; sysSetting13.Value = this.drpzhifu.SelectedValue; sysSettingList.Add(sysSetting13); ////my18 SysSetting sysSetting14 = new SysSetting(); sysSetting14.Key = "my18_pay"; sysSetting14.Value = this.drpMy18.SelectedValue; sysSettingList.Add(sysSetting14); ////是否开启提现 SysSetting sysSetting15 = new SysSetting(); sysSetting15.Key = "ti_xian_isopen"; sysSetting15.Value = this.drptx.SelectedValue; sysSettingList.Add(sysSetting15); ////关闭提现功能原因 SysSetting sysSetting16 = new SysSetting(); sysSetting16.Key = "ti_xian_shi_bai_info"; sysSetting16.Value = this.txtTxErrorMsg.Text; sysSettingList.Add(sysSetting16); ////支付宝充值 string zfbpath = SaveZfbImage(); if (!string.IsNullOrEmpty(zfbpath)) { SysSetting sysSetting17 = new SysSetting(); sysSetting17.Key = "zhb_rect_url"; sysSetting17.Value = zfbpath; sysSettingList.Add(sysSetting17); } ////微信充值 string wxstr = SaveWxImage(); if (!string.IsNullOrEmpty(wxstr)) { SysSetting sysSetting18 = new SysSetting(); sysSetting18.Key = "wx_rect_url"; sysSetting18.Value = wxstr; sysSettingList.Add(sysSetting18); } if (sysSettingService.Update(sysSettingList)) { JsAlert("保存成功!"); } else { JsAlert("保存失败!"); } }
protected void Page_Load(object sender, EventArgs e) { Image1.ImageUrl = "~/images/106_Seal_Sample.JPG"; Acc = Request.QueryString["Acc"].ToString(); if (Page.IsPostBack == false) { hf_StartTime.Value = Label8.Text; hf_EndTime.Value = Label9.Text; //hf_start.Value = "2015/01/01"; Dictionary <string, object> d = new Dictionary <string, object>(); Lib.DataUtility du = new Lib.DataUtility(); d.Add("sid", Request.QueryString["sid"].ToString()); d.Add("center_code", Request.QueryString["centercode"].ToString()); //DataTable dt = du.getDataTableByText("SELECT P.PrevSID,P.start1_date,P.end1_date,T.ThisSID,T.start2_date,T.end2_date, N.NextSID,N.start3_date,N.end3_date FROM ( SELECT MAX(A.sid) PrevSID, (select start_date FROM Center_Seal where sid = MAX(A.sid)) start1_date,(select end_date FROM Center_Seal where sid = MAX(A.sid)) end1_date from Center_Seal A where A.sid < @sid and A.center_code = @center_code and A.rank_code=(select rank_code from Center_Seal where sid=@sid)) P CROSS JOIN ( SELECT MAX(A.sid) ThisSID, (select start_date FROM Center_Seal where sid = MAX(A.sid)) start2_date,(select end_date FROM Center_Seal where sid = MAX(A.sid)) end2_date from Center_Seal A where A.sid = @sid and A.center_code = @center_code and A.rank_code=(select rank_code from Center_Seal where sid=@sid)) T CROSS JOIN( SELECT MIN(A.sid) NextSID, (select start_date FROM Center_Seal where sid = MIN(A.sid)) start3_date,(select end_date FROM Center_Seal where sid = MAX(A.sid)) end3_date from Center_Seal A where A.sid > @sid and A.center_code = @center_code and A.rank_code=(select rank_code from Center_Seal where sid=@sid)) N ",d); //2016-8-16改用sp DataTable dt = du.getDataTableBysp("Ex106_Update_Seal", d); //前一筆:PrevSID、start1_date、end1_date //當筆:ThisSID、start2_date、end2_date //後一筆:NextSID、start3_date、end3_date //d.Add("start_date", dt.Rows[0]["start_date"]); //沒前面一筆,有當筆,沒有後一筆(010)(最前面一筆,只有一筆) if (string.IsNullOrEmpty(dt.Rows[0]["PrevSID"].ToString()) & !string.IsNullOrEmpty(dt.Rows[0]["ThisSID"].ToString()) & string.IsNullOrEmpty(dt.Rows[0]["NextSID"].ToString())) { //設定時間 PrevSID = dt.Rows[0]["PrevSID"].ToString(); ThisSID = dt.Rows[0]["ThisSID"].ToString(); NextSID = dt.Rows[0]["NextSID"].ToString(); DateTime Now_startTime = (DateTime)dt.Rows[0]["start2_date"]; Label6.Text = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); TextBox1.Text = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); TextBox2.Text = dt.Rows[0]["sing_unit"].ToString(); TextBox3.Text = dt.Rows[0]["sing_rank"].ToString(); TextBox4.Text = dt.Rows[0]["sing_name"].ToString(); old_time = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); old_unit = dt.Rows[0]["sing_unit"].ToString(); old_rank = dt.Rows[0]["sing_rank"].ToString(); old_name = dt.Rows[0]["sing_name"].ToString(); DateTime Today = DateTime.Now; Label8.Text = "106/01/01"; Label9.Text = Lib.SysSetting.ToRocDateFormat(Today.ToString("yyyy/MM/dd")); } //沒前面一筆,有當筆,也有後一筆(011)(最前面一筆,有多筆) else if (string.IsNullOrEmpty(dt.Rows[0]["PrevSID"].ToString()) & !string.IsNullOrEmpty(dt.Rows[0]["ThisSID"].ToString()) & !string.IsNullOrEmpty(dt.Rows[0]["NextSID"].ToString())) { //設定時間 PrevSID = dt.Rows[0]["PrevSID"].ToString(); ThisSID = dt.Rows[0]["ThisSID"].ToString(); NextSID = dt.Rows[0]["NextSID"].ToString(); DateTime Now_startTime = (DateTime)dt.Rows[0]["start2_date"]; DateTime Next_start_date = (DateTime)dt.Rows[0]["start3_date"]; DateTime Next2_start_date = Next_start_date.AddDays(-2); Label6.Text = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); TextBox1.Text = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); TextBox2.Text = dt.Rows[0]["sing_unit"].ToString(); TextBox3.Text = dt.Rows[0]["sing_rank"].ToString(); TextBox4.Text = dt.Rows[0]["sing_name"].ToString(); old_time = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); old_unit = dt.Rows[0]["sing_unit"].ToString(); old_rank = dt.Rows[0]["sing_rank"].ToString(); old_name = dt.Rows[0]["sing_name"].ToString(); Label8.Text = "106/01/01"; Label9.Text = Lib.SysSetting.ToRocDateFormat(Next2_start_date.ToString("yyyy/MM/dd")); } //有前面一筆,有當筆,沒後面一筆(110)(最後一筆) else if (!string.IsNullOrEmpty(dt.Rows[0]["PrevSID"].ToString()) & !string.IsNullOrEmpty(dt.Rows[0]["ThisSID"].ToString()) & string.IsNullOrEmpty(dt.Rows[0]["NextSID"].ToString())) { //設定時間 PrevSID = dt.Rows[0]["PrevSID"].ToString(); ThisSID = dt.Rows[0]["ThisSID"].ToString(); NextSID = dt.Rows[0]["NextSID"].ToString(); DateTime Now_startTime = (DateTime)dt.Rows[0]["start2_date"]; DateTime Prev_start_date = (DateTime)dt.Rows[0]["start1_date"]; DateTime Prev2_start_date = Prev_start_date.AddDays(+2); DateTime Today = DateTime.Now; Label6.Text = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); TextBox1.Text = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); TextBox2.Text = dt.Rows[0]["sing_unit"].ToString(); TextBox3.Text = dt.Rows[0]["sing_rank"].ToString(); TextBox4.Text = dt.Rows[0]["sing_name"].ToString(); old_time = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); old_unit = dt.Rows[0]["sing_unit"].ToString(); old_rank = dt.Rows[0]["sing_rank"].ToString(); old_name = dt.Rows[0]["sing_name"].ToString(); Label8.Text = Lib.SysSetting.ToRocDateFormat(Prev2_start_date.ToString("yyyy/MM/dd")); //Label9.Text = Lib.SysSetting.ToRocDateFormat(Today.ToString("yyyy/MM/dd")); Label9.Text = ""; } //有三筆,前中後都要改(111)(多筆,剛好在中間) else if (!string.IsNullOrEmpty(dt.Rows[0]["PrevSID"].ToString()) & !string.IsNullOrEmpty(dt.Rows[0]["ThisSID"].ToString()) & !string.IsNullOrEmpty(dt.Rows[0]["NextSID"].ToString()))//有三筆,前中後都要改 { //設定時間 PrevSID = dt.Rows[0]["PrevSID"].ToString(); ThisSID = dt.Rows[0]["ThisSID"].ToString(); NextSID = dt.Rows[0]["NextSID"].ToString(); DateTime Now_startTime = (DateTime)dt.Rows[0]["start2_date"]; DateTime Prev_start_date = (DateTime)dt.Rows[0]["start1_date"]; DateTime Next_start_date = (DateTime)dt.Rows[0]["start3_date"]; DateTime Prev2_start_date = Prev_start_date.AddDays(+2); DateTime Next2_start_date = Next_start_date.AddDays(-2); Label6.Text = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); TextBox1.Text = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); TextBox2.Text = dt.Rows[0]["sing_unit"].ToString(); TextBox3.Text = dt.Rows[0]["sing_rank"].ToString(); TextBox4.Text = dt.Rows[0]["sing_name"].ToString(); old_time = Lib.SysSetting.ToRocDateFormat(Now_startTime.ToString("yyyy/MM/dd")); old_unit = dt.Rows[0]["sing_unit"].ToString(); old_rank = dt.Rows[0]["sing_rank"].ToString(); old_name = dt.Rows[0]["sing_name"].ToString(); Label8.Text = Lib.SysSetting.ToRocDateFormat(Prev2_start_date.ToString("yyyy/MM/dd")); Label9.Text = Lib.SysSetting.ToRocDateFormat(Next2_start_date.ToString("yyyy/MM/dd")); } else { //查無資料 } } if (Page.IsPostBack == true) { string new_time = string.Empty; if (CheckDateTimeType(TextBox1.Text) == true & !string.IsNullOrEmpty(TextBox1.Text) & !string.IsNullOrEmpty(TextBox2.Text) & !string.IsNullOrEmpty(TextBox3.Text) & !string.IsNullOrEmpty(TextBox4.Text)) { Label3.Text = null; DateTime EndTime;//結束時間 //2.判斷日期是否在合理範圍 //轉回西元年 try { DateTime ChangeTime = Lib.SysSetting.ToWorldDate(TextBox1.Text); //更改的時間 DateTime StartTime = Lib.SysSetting.ToWorldDate(Label8.Text); //起始時間 new_time = Lib.SysSetting.ToRocDateFormat(ChangeTime.ToString("yyyy/MM/dd")); //更改的時間轉為民國作比較 if (Label9.Text == "") { EndTime = Lib.SysSetting.ToWorldDate("999/12/31");//結束時間 } else { EndTime = Lib.SysSetting.ToWorldDate(Label9.Text);//結束時間 } //EndTime = Lib.SysSetting.ToWorldDate(Label9.Text);//結束時間 //2016-8-16新增更新簽章單位、級職、姓名 string sing_unit = TextBox2.Text; string sing_rank = TextBox3.Text; string sing_name = TextBox4.Text; if (ChangeTime >= StartTime & ChangeTime <= EndTime) { Dictionary <string, object> dd = new Dictionary <string, object>(); Lib.DataUtility duu = new Lib.DataUtility(); dd.Add("PrevSID", PrevSID); dd.Add("ThisSID", ThisSID); dd.Add("NextSID", NextSID); dd.Add("start_date", ChangeTime); //當筆啟始時間 dd.Add("prev_date", (ChangeTime.AddDays(-1))); //上一筆結束時間 dd.Add("next_date", (ChangeTime.AddDays(+1))); //下一筆啟始時間 //2016-8-16新增更新簽章單位、級職、姓名 dd.Add("sing_unit", sing_unit); dd.Add("sing_rank", sing_rank); dd.Add("sing_name", sing_name); //更新圖檔 //2016-8-16開始畫印章 string sing1_unit = string.Empty; string sing1_rank = string.Empty; string sing1_name = string.Empty; //string jpg_Name = string.Empty; sing1_unit = sing_unit; sing1_rank = sing_rank; sing1_name = sing_name; Font s1_unit = null; //鑑測官-單位 Font s1_rank = null; //鑑測官-級職 Font seal_font_name = new Font("標楷體", 48, FontStyle.Bold); //姓名 if (sing1_unit.Length <= 6) { s1_unit = new Font("標楷體", 34, FontStyle.Bold);//6個字 } else if (sing1_unit.Length == 7) { s1_unit = new Font("標楷體", 30, FontStyle.Bold);//7個字 } else if (sing1_unit.Length == 8) { s1_unit = new Font("標楷體", 26, FontStyle.Bold);//8個字 } else if (sing1_unit.Length == 9) { s1_unit = new Font("標楷體", 24, FontStyle.Bold);//9個字 } else if (sing1_unit.Length == 10) { s1_unit = new Font("標楷體", 22, FontStyle.Bold);//10個字 } else if (sing1_unit.Length == 11) { s1_unit = new Font("標楷體", 20, FontStyle.Bold);//11個字 } else if (sing1_unit.Length == 12) { s1_unit = new Font("標楷體", 18, FontStyle.Bold);//12個字 } else { s1_unit = new Font("標楷體", 16, FontStyle.Bold);//超過12個字 } //判斷鑑測官-級職 字長度 if (sing1_rank.Length <= 6) { s1_rank = new Font("標楷體", 34, FontStyle.Bold);//6個字 } else if (sing1_rank.Length == 7) { s1_rank = new Font("標楷體", 30, FontStyle.Bold);//7個字 } else if (sing1_rank.Length == 8) { s1_rank = new Font("標楷體", 26, FontStyle.Bold);//8個字 } else if (sing1_rank.Length == 9) { s1_rank = new Font("標楷體", 24, FontStyle.Bold);//9個字 } else if (sing1_rank.Length == 10) { s1_rank = new Font("標楷體", 22, FontStyle.Bold);//10個字 } else if (sing1_rank.Length == 11) { s1_rank = new Font("標楷體", 20, FontStyle.Bold);//11個字 } else if (sing1_rank.Length == 12) { s1_rank = new Font("標楷體", 18, FontStyle.Bold);//12個字 } else { s1_rank = new Font("標楷體", 16, FontStyle.Bold);//超過12個字 } int height = 180; int width = 480; Bitmap bmp = new Bitmap(width, height, PixelFormat.Format24bppRgb); Graphics g = Graphics.FromImage(bmp); g.SmoothingMode = SmoothingMode.AntiAlias; g.Clear(Color.White); StringFormat stringFormat = new StringFormat(); stringFormat.Alignment = StringAlignment.Center; stringFormat.LineAlignment = StringAlignment.Center; Pen seal_pen = new Pen(Color.Red, 15); g.DrawRectangle(seal_pen, 0, 0, 480, 180); //鑑測官外框 //鑑測章內容 SolidBrush redSB = new SolidBrush(Color.Red); //字設成紅色 Pen seal_pen2 = new Pen(Color.Red, 5); StringFormat sealFormat = new StringFormat(); sealFormat.Alignment = StringAlignment.Center; sealFormat.LineAlignment = StringAlignment.Center; DrawSpacedText(g, s1_unit, redSB, new Point(3, 30), sing1_unit, 260); DrawSpacedText(g, s1_rank, redSB, new Point(3, 100), sing1_rank, 260); DrawSpacedText(g, seal_font_name, redSB, new Point(245, 60), sing1_name, 240); byte[] bytedata = (byte[])ImageToByte(bmp); dd.Add("img_byte", bytedata);//加入圖檔索引 //開始更新,判斷要更新的欄位 //只有當筆(010) if (string.IsNullOrEmpty(PrevSID) & !string.IsNullOrEmpty(ThisSID) & string.IsNullOrEmpty(NextSID)) { duu.executeNonQueryByText("update Center_Seal set start_date=@start_date,sing_unit=@sing_unit,sing_rank=@sing_rank,sing_name=@sing_name,img_byte=@img_byte where sid=@ThisSID", dd);//更新當筆 //2016-9-7更新資料寫入log if (old_time == new_time & old_unit == sing1_unit & old_rank == sing1_rank & old_name == sing1_name) { //都一樣沒更改,不產生log } else { //資料有異動,產生log string event_log = string.Empty; event_log += "[SID:" + ThisSID + "] "; if (old_time != new_time) { event_log += "啟用時間:" + old_time + "->" + new_time + "。"; } if (old_unit != sing1_unit) { event_log += "單位:" + old_unit + "->" + sing1_unit + "。"; } if (old_rank != sing1_rank) { event_log += "級職:" + old_rank + "->" + sing1_rank + "。"; } if (old_name != sing1_name) { event_log += "姓名:" + old_name + "->" + sing1_name + "。"; } SysSetting.AddLog("簽章維護", Acc, event_log, DateTime.Now); } Label3.Text = "簽章更新成功!!"; PrevSID = string.Empty; ThisSID = string.Empty; NextSID = string.Empty; //ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.close();window.opener.location.reload()", true); //2016-9-12測試成功,先把方法傳回母視窗(刷新列表),再關掉子視窗 ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.opener.outside();window.close()", true); } //沒前面一筆,有當筆,也有後一筆(011)(最前面一筆,有多筆) else if (string.IsNullOrEmpty(PrevSID) & !string.IsNullOrEmpty(ThisSID) & !string.IsNullOrEmpty(NextSID)) { duu.executeNonQueryByText("update Center_Seal set start_date=@start_date,sing_unit=@sing_unit,sing_rank=@sing_rank,sing_name=@sing_name,img_byte=@img_byte where sid=@ThisSID", dd);//更新當筆 //duu.executeNonQueryByText("update Center_Seal set start_date=@next_date where sid=@NextSID", dd);//更新下一筆啟始時間 //Response.Redirect(Request.Url.ToString()); //2016-9-7更新資料寫入log if (old_time == new_time & old_unit == sing1_unit & old_rank == sing1_rank & old_name == sing1_name) { //都一樣沒更改,不產生log } else { //資料有異動,產生log string event_log = string.Empty; event_log += "[SID:" + ThisSID + "] "; if (old_time != new_time) { event_log += "啟用時間:" + old_time + "->" + new_time + "。"; } if (old_unit != sing1_unit) { event_log += "單位:" + old_unit + "->" + sing1_unit + "。"; } if (old_rank != sing1_rank) { event_log += "級職:" + old_rank + "->" + sing1_rank + "。"; } if (old_name != sing1_name) { event_log += "姓名:" + old_name + "->" + sing1_name + "。"; } SysSetting.AddLog("簽章維護", Acc, event_log, DateTime.Now); } Label3.Text = "簽章更新成功!!"; PrevSID = string.Empty; ThisSID = string.Empty; NextSID = string.Empty; //ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.close();window.opener.location.reload()", true); ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.opener.outside();window.close()", true); } ////有前面一筆,有當筆,沒後面一筆(110)(最後一筆)//TEST else if (!string.IsNullOrEmpty(PrevSID) & !string.IsNullOrEmpty(ThisSID) & string.IsNullOrEmpty(NextSID)) { duu.executeNonQueryByText("update Center_Seal set start_date=@start_date,sing_unit=@sing_unit,sing_rank=@sing_rank,sing_name=@sing_name,img_byte=@img_byte where sid=@ThisSID", dd); //更新當筆 duu.executeNonQueryByText("update Center_Seal set end_date=@prev_date where sid=@PrevSID", dd); //更新上一筆結束時間 //Response.Redirect(Request.Url.ToString()); //2016-9-7更新資料寫入log if (old_time == new_time & old_unit == sing1_unit & old_rank == sing1_rank & old_name == sing1_name) { //都一樣沒更改,不產生log } else { //資料有異動,產生log string event_log = string.Empty; event_log += "[SID:" + ThisSID + "] "; if (old_time != new_time) { event_log += "啟用時間:" + old_time + "->" + new_time + "。"; } if (old_unit != sing1_unit) { event_log += "單位:" + old_unit + "->" + sing1_unit + "。"; } if (old_rank != sing1_rank) { event_log += "級職:" + old_rank + "->" + sing1_rank + "。"; } if (old_name != sing1_name) { event_log += "姓名:" + old_name + "->" + sing1_name + "。"; } SysSetting.AddLog("簽章維護", Acc, event_log, DateTime.Now); } Label3.Text = "簽章更新成功!!"; PrevSID = string.Empty; ThisSID = string.Empty; NextSID = string.Empty; //ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.close();window.opener.location.reload()", true); ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.opener.outside();window.close()", true); } //有三筆,前中後都要改(111)(多筆,剛好在中間) else if (!string.IsNullOrEmpty(PrevSID) & !string.IsNullOrEmpty(ThisSID) & !string.IsNullOrEmpty(NextSID)) { duu.executeNonQueryByText("update Center_Seal set start_date=@start_date,sing_unit=@sing_unit,sing_rank=@sing_rank,sing_name=@sing_name,img_byte=@img_byte where sid=@ThisSID", dd); //更新當筆 //duu.executeNonQueryByText("update Center_Seal set start_date=@next_date where sid=@NextSID", dd);//更新下一筆啟始時間 duu.executeNonQueryByText("update Center_Seal set end_date=@prev_date where sid=@PrevSID", dd); //更新上一筆結束時間 //Response.Redirect(Request.Url.ToString()); //2016-9-7更新資料寫入log if (old_time == new_time & old_unit == sing1_unit & old_rank == sing1_rank & old_name == sing1_name) { //都一樣沒更改,不產生log } else { //資料有異動,產生log string event_log = string.Empty; event_log += "[SID:" + ThisSID + "] "; if (old_time != new_time) { event_log += "啟用時間:" + old_time + "->" + new_time + "。"; } if (old_unit != sing1_unit) { event_log += "單位:" + old_unit + "->" + sing1_unit + "。"; } if (old_rank != sing1_rank) { event_log += "級職:" + old_rank + "->" + sing1_rank + "。"; } if (old_name != sing1_name) { event_log += "姓名:" + old_name + "->" + sing1_name + "。"; } SysSetting.AddLog("簽章維護", Acc, event_log, DateTime.Now); } Label3.Text = "簽章更新成功!!"; PrevSID = string.Empty; ThisSID = string.Empty; NextSID = string.Empty; //ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.close();window.opener.location.reload()", true); ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.opener.outside();window.close()", true); } else { } } else { Label3.Text = "日期輸入範圍值錯誤,請查新檢查!!"; } } catch (Exception ex) { Label3.Text = "日期格式錯誤"; } } else { Label3.Text = "日期格式錯誤或欄位空白"; } } }
protected void btn_InqResult_Simple_Click(object sender, EventArgs e) { string year = ddl_year.SelectedItem.Text.ToString() + "-"; string start_date = string.Empty; string end_date = string.Empty; switch (ddl_season.SelectedValue) { case "1": start_date = year + "01-01"; end_date = year + "03-31"; break; case "2": start_date = year + "04-01"; end_date = year + "06-30"; break; case "3": start_date = year + "07-01"; end_date = year + "09-30"; break; case "4": start_date = year + "10-01"; end_date = year + "12-31"; break; default: start_date = year + "01-01"; end_date = year + "03-31"; break; } Dictionary <string, object> d = new Dictionary <string, object>(); Lib.DataUtility du = new Lib.DataUtility(); try { d.Add("start_date", start_date); d.Add("end_date", end_date); DataTable dt = new DataTable(); //2017-11-23使用新的函式,加長timeout為120秒 dt = du.getDataTableBysp_BigData(@"Ex108_GetResultByDate_Simple", d); if (dt.Rows.Count > 0) { string svPath = "Result(" + start_date + "_" + end_date + ")-exl.csv"; Save_csv_toClient(dt, svPath, true); } else { ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('" + "查無資料!!" + "')", true); } } catch (Exception ex) { //記錄錯誤訊息 SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, this.ToString()); ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('" + ex.Message + "')", true); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["account"] != null) { Account a = (Account)Session["account"]; if (a.Role != ((int)SysSetting.Role.admin_hq).ToString()) { Response.Redirect("~/index.aspx"); } else { Check_memo = false; Sid = Request.QueryString["sid"].ToString(); if (Page.IsPostBack == false)//剛開始載入頁面 { Dictionary <string, object> d = new Dictionary <string, object>(); Lib.DataUtility du = new Lib.DataUtility(); d.Add("sid", Sid); DataTable dt = du.getDataTableBysp("Ex108_GetResultDataBySid", d); if (dt.Rows.Count > 0) { //個人基本資料 if (!string.IsNullOrEmpty(dt.Rows[0]["id"].ToString())) { Id = dt.Rows[0]["id"].ToString(); } if (!string.IsNullOrEmpty(dt.Rows[0]["name"].ToString())) { Name = dt.Rows[0]["name"].ToString(); txb_Name.Text = Name; Old_Name = Name; lab_OldName.Text = "(" + Old_Name + ")"; } if (!string.IsNullOrEmpty(dt.Rows[0]["birth"].ToString())) { Birth = dt.Rows[0]["birth"].ToString(); txb_Birth.Text = Birth; Old_Birth = Birth; lab_OldBirth.Text = "(" + Old_Birth + ")"; } if (!string.IsNullOrEmpty(dt.Rows[0]["age"].ToString())) { Age = dt.Rows[0]["age"].ToString(); txb_Age.Text = Age; Old_Age = Age; lab_OldAge.Text = "(" + Age + ")"; } //檢查項次欄位 if (!string.IsNullOrEmpty(dt.Rows[0]["memo"].ToString())) { Check_memo = true; Memo = dt.Rows[0]["memo"].ToString(); } //項次名稱 //項次1 if (!string.IsNullOrEmpty(dt.Rows[0]["sit_ups_name"].ToString())) { ItemName1 = dt.Rows[0]["sit_ups_name"].ToString(); lab_ItemScore1.Text = "(5)" + ItemName1 + "(成績)"; if (Check_memo == true) { if (Memo.Substring(0, 1) == "F" || Memo.Substring(0, 1) == "G" || Memo.Substring(0, 1) == "J") { lab_Item1.Text = "(4)" + ItemName1 + Sec; } else { lab_Item1.Text = "(4)" + ItemName1 + Count; } } else { lab_Item1.Text = "(4)" + ItemName1 + "(次/秒數)"; } } //項次2 if (!string.IsNullOrEmpty(dt.Rows[0]["push_ups_name"].ToString())) { ItemName2 = dt.Rows[0]["push_ups_name"].ToString(); lab_ItemScore2.Text = "(7)" + ItemName2 + "(成績)"; if (Check_memo == true) { if (Memo.Substring(1, 1) == "F" || Memo.Substring(1, 1) == "G" || Memo.Substring(1, 1) == "J") { lab_Item2.Text = "(6)" + ItemName2 + Sec; } else { lab_Item2.Text = "(6)" + ItemName2 + Count; } } else { lab_Item2.Text = "(6)" + ItemName2 + "(次/秒數)"; } } //項次3 if (!string.IsNullOrEmpty(dt.Rows[0]["run_name"].ToString())) { ItemName3 = dt.Rows[0]["run_name"].ToString(); lab_ItemScore3.Text = "(9)" + ItemName3 + "(成績)"; if (Check_memo == true) { if (Memo.Substring(2, 1) == "0" || Memo.Substring(2, 1) == "F" || Memo.Substring(2, 1) == "G" || Memo.Substring(2, 1) == "J") { lab_Item3.Text = "(8)" + ItemName3 + Sec; } else { lab_Item3.Text = "(8)" + ItemName3 + Count; } } else { lab_Item3.Text = "(8)" + ItemName3 + "(次/秒數)"; } } //項次次數及成績 //項次1 if (!string.IsNullOrEmpty(dt.Rows[0]["sit_ups_score"].ToString())) { ItemScore1 = dt.Rows[0]["sit_ups_score"].ToString(); Old_ItemScore1 = ItemScore1; if (ItemScore1 == "999") { lab_OldItem1.Text = "(未完測)"; lab_OldItemScore1.Text = "(未完測)"; } else { Old_ItemScore1 = ItemScore1; txb_ItemScore1.Text = ItemScore1; lab_OldItemScore1.Text = "(" + Old_ItemScore1 + ")"; } //項次1次/秒數 if (!string.IsNullOrEmpty(dt.Rows[0]["sit_ups"].ToString())) { Item1 = dt.Rows[0]["sit_ups"].ToString(); Old_Item1 = Item1; txb_Item1.Text = Item1; lab_OldItem1.Text = "(" + Old_Item1 + ")"; } else { Item1 = string.Empty; Old_Item1 = string.Empty; } } else { ItemScore1 = string.Empty; Old_ItemScore1 = string.Empty; Item1 = string.Empty; Old_Item1 = string.Empty; lab_OldItem1.Text = "(未測驗)"; lab_OldItemScore1.Text = "(未測驗)"; } //項次2 if (!string.IsNullOrEmpty(dt.Rows[0]["push_ups_score"].ToString())) { ItemScore2 = dt.Rows[0]["push_ups_score"].ToString(); Old_ItemScore2 = ItemScore2; if (ItemScore2 == "999") { lab_OldItem2.Text = "(未完測)"; lab_OldItemScore2.Text = "(未完測)"; } else { Old_ItemScore2 = ItemScore2; txb_ItemScore2.Text = ItemScore2; lab_OldItemScore2.Text = "(" + Old_ItemScore2 + ")"; } //項次2次/秒數 if (!string.IsNullOrEmpty(dt.Rows[0]["push_ups"].ToString())) { Item2 = dt.Rows[0]["push_ups"].ToString(); Old_Item2 = Item2; txb_Item2.Text = Item2; lab_OldItem2.Text = "(" + Old_Item2 + ")"; } else { Item2 = string.Empty; Old_Item2 = string.Empty; } } else { ItemScore2 = string.Empty; Old_ItemScore2 = string.Empty; Item2 = string.Empty; Old_Item2 = string.Empty; lab_OldItem2.Text = "(未測驗)"; lab_OldItemScore2.Text = "(未測驗)"; } //項次3 if (!string.IsNullOrEmpty(dt.Rows[0]["run_score"].ToString())) { ItemScore3 = dt.Rows[0]["run_score"].ToString(); Old_ItemScore3 = ItemScore3; if (ItemScore3 == "9999") { lab_OldItem3.Text = "(未完測)"; lab_OldItemScore3.Text = "(未完測)"; } else { Old_ItemScore3 = ItemScore3; txb_ItemScore3.Text = ItemScore3; lab_OldItemScore3.Text = "(" + Old_ItemScore3 + ")"; } //項次3次/秒數 if (!string.IsNullOrEmpty(dt.Rows[0]["run"].ToString())) { Item3 = dt.Rows[0]["run"].ToString(); Old_Item3 = Item3; txb_Item3.Text = Item3; lab_OldItem3.Text = "(" + Old_Item3 + ")"; } else { Item3 = string.Empty; Old_Item3 = string.Empty; } } else { ItemScore3 = string.Empty; Old_ItemScore3 = string.Empty; Item3 = string.Empty; Old_Item3 = string.Empty; lab_OldItem3.Text = "(未測驗)"; lab_OldItemScore3.Text = "(未測驗)"; } //總評 if (!string.IsNullOrEmpty(dt.Rows[0]["status"].ToString())) { Status = dt.Rows[0]["status"].ToString(); if (Status == "202") { ddl_Status.SelectedIndex = 0; } else { ddl_Status.SelectedIndex = 1; } Old_Status = Status; lab_OldStatus.Text = (Status == "202") ? "(合格)" : "(不合格)"; } } } else//提交資料後回傳 { Dictionary <string, object> d = new Dictionary <string, object>(); Lib.DataUtility du = new Lib.DataUtility(); Name = txb_Name.Text.Trim(); Birth = txb_Birth.Text.Trim(); Age = txb_Age.Text.Trim(); d.Add("sid", Sid); d.Add("name", Name); d.Add("birth", Birth); d.Add("age", Age); //項次1次/秒數 if (!string.IsNullOrEmpty(txb_Item1.Text)) { Item1 = txb_Item1.Text.Trim(); d.Add("sit_ups", Item1); } else { Item1 = string.Empty; d.Add("sit_ups", DBNull.Value); } //項次1成績 if (!string.IsNullOrEmpty(txb_ItemScore1.Text)) { ItemScore1 = txb_ItemScore1.Text.Trim(); d.Add("sit_ups_score", ItemScore1); } else { if (!string.IsNullOrEmpty(Old_ItemScore1) && Old_ItemScore3 == "999") { ItemScore1 = Old_ItemScore1; d.Add("sit_ups_score", ItemScore1); } else { ItemScore1 = string.Empty; d.Add("sit_ups_score", DBNull.Value); } } //項次2次/秒數 if (!string.IsNullOrEmpty(txb_Item2.Text)) { Item2 = txb_Item2.Text.Trim(); d.Add("push_ups", Item2); } else { Item2 = string.Empty; d.Add("push_ups", DBNull.Value); } //項次2成績 if (!string.IsNullOrEmpty(txb_ItemScore2.Text)) { ItemScore2 = txb_ItemScore2.Text.Trim(); d.Add("push_ups_score", ItemScore2); } else { if (!string.IsNullOrEmpty(Old_ItemScore2) && Old_ItemScore2 == "999") { ItemScore2 = Old_ItemScore2; d.Add("push_ups_score", ItemScore2); } else { ItemScore2 = string.Empty; d.Add("push_ups_score", DBNull.Value); } } //項次3次/秒數 if (!string.IsNullOrEmpty(txb_Item3.Text)) { Item3 = txb_Item3.Text.Trim(); d.Add("run", Item3); } else { Item3 = string.Empty; d.Add("run", DBNull.Value); } //項次3成績 if (!string.IsNullOrEmpty(txb_ItemScore3.Text)) { ItemScore3 = txb_ItemScore3.Text.Trim(); d.Add("run_score", ItemScore3); } else { if (!string.IsNullOrEmpty(Old_ItemScore3) && Old_ItemScore3 == "9999") { ItemScore3 = Old_ItemScore3; d.Add("run_score", ItemScore3); } else { ItemScore3 = string.Empty; d.Add("run_score", DBNull.Value); } } //總評 if (ddl_Status.SelectedIndex == 0) { Status = "202"; } else if (ddl_Status.SelectedIndex == 1) { Status = "203"; } else { Status = Old_Status; } d.Add("status", Status); try { //更新資料 du.executeNonQueryBysp("Ex108_UpdateResultData", d); //寫入log UpdateLog = string.Empty; if (!string.IsNullOrEmpty(Sid)) { UpdateLog += "sid-" + Sid + ','; } if (!string.IsNullOrEmpty(Id)) { UpdateLog += "id-" + Id + ','; } if (Old_Name != Name) { UpdateLog += "名[" + Old_Name + "," + Name + "]"; } if (Old_Birth != Birth) { UpdateLog += "生[" + Old_Birth + "," + Birth + "]"; } if (Old_Age != Age) { UpdateLog += "歲[" + Old_Age + "," + Age + "]"; } UpdateLog += "項1[" + Old_ItemScore1 + "," + ItemScore1 + "]項2[" + Old_ItemScore2 + "," + ItemScore2 + "]項3[" + Old_ItemScore3 + "," + ItemScore3 + "]總[" + ((Old_Status == "202") ? "合格" : "不合格") + "," + ((Status == "202") ? "合格" : "不合格") + "]"; SysSetting.AddLog("成績補正", a.AccountName, UpdateLog, DateTime.Now); //回傳成功 ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.opener.outside_r('ok');window.close()", true); } catch (Exception ex) { //記錄錯誤訊息 SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, this.ToString()); //回傳失敗 ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.opener.outside_r('Err');window.close()", true); } } } } if (Session["account"] == null && Session["player"] == null) { Response.Redirect("~/Login.aspx"); } }
/// <summary> /// 实现文件上传到服务器保存,并生成缩略图 /// </summary> /// <param name="fileName">文件名称</param> /// <param name="fileBuffers">文件字节流</param> private void UploadFile(string fileName, byte[] fileBuffers) { //判断文件是否为空 if (string.IsNullOrEmpty(fileName)) { Log4NetHelper.Info("文件名不能为空"); throw new Exception("文件名不能为空"); } //判断文件是否为空 if (fileBuffers.Length < 1) { Log4NetHelper.Info("文件不能为空"); throw new Exception("文件不能为空"); } YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = yuebonCacheHelper.Get("SysSetting").ToJson().ToObject <SysSetting>(); string folder = DateTime.Now.ToString("yyyyMMdd"); _filePath = _hostingEnvironment.WebRootPath; var _tempfilepath = sysSetting.Filepath; if (!string.IsNullOrEmpty(_belongApp)) { _tempfilepath += "/" + _belongApp; } if (!string.IsNullOrEmpty(_belongAppId)) { _tempfilepath += "/" + _belongAppId; } if (sysSetting.Filesave == "1") { _tempfilepath = _tempfilepath + "/" + folder + "/"; } if (sysSetting.Filesave == "2") { DateTime date = DateTime.Now; _tempfilepath = _tempfilepath + "/" + date.Year + "/" + date.Month + "/" + date.Day + "/"; } var uploadPath = _filePath + "/" + _tempfilepath; if (sysSetting.Fileserver == "localhost") { if (!Directory.Exists(uploadPath)) { Directory.CreateDirectory(uploadPath); } } string ext = Path.GetExtension(fileName).ToLower(); string newName = GuidUtils.CreateNo(); string newfileName = newName + ext; using (var fs = new FileStream(uploadPath + newfileName, FileMode.Create)) { fs.Write(fileBuffers, 0, fileBuffers.Length); fs.Close(); //生成缩略图 if (ext.Contains(".jpg") || ext.Contains(".jpeg") || ext.Contains(".png") || ext.Contains(".bmp") || ext.Contains(".gif")) { string thumbnailName = newName + "_" + sysSetting.Thumbnailwidth + "x" + sysSetting.Thumbnailheight + ext; ImgHelper.MakeThumbnail(uploadPath + newfileName, uploadPath + thumbnailName, sysSetting.Thumbnailwidth.ToInt(), sysSetting.Thumbnailheight.ToInt()); _dbThumbnail = _tempfilepath + thumbnailName; } _dbFilePath = _tempfilepath + newfileName; } }
public async Task <IHttpActionResult> PutSysSetting(int id, SysSetting sysSetting) { #region Проверяем Логин и Пароль + Изменяем строку соединения + Права + Разные Функции //Получаем Куку System.Web.HttpCookie authCookie = System.Web.HttpContext.Current.Request.Cookies["CookieIPOL"]; int iLanguage = Convert.ToInt32(authCookie["CookieL"]) - 1; // Проверяем Логин и Пароль Classes.Account.Login.Field field = await Task.Run(() => login.Return(authCookie, true)); if (!field.Access) { return(Ok(returnServer.Return(false, Classes.Language.Sklad.Language.msg10))); } //Изменяем строку соединения db = new DbConnectionSklad(connectionString.Return(field.DirCustomersID, null, true)); //Права (1 - Write, 2 - Read, 3 - No Access) int iRight = await Task.Run(() => accessRight.Access(connectionString.Return(field.DirCustomersID, null, true), field.DirEmployeeID, "RightSysSettings")); if (iRight != 1) { return(Ok(returnServer.Return(false, Classes.Language.Sklad.Language.msg57(0)))); } //Разные Функции function.NumberDecimalSeparator(); #endregion #region Проверки if (!ModelState.IsValid) { return(Ok(returnServer.Return(false, Classes.Language.Sklad.Language.msg91))); } //Подстановки - некоторые поля надо заполнить, если они не заполены (Юридические реквизиты) sysSetting.Substitute(); #endregion #region Сохранение try { db.Entry(sysSetting).State = EntityState.Modified; await db.SaveChangesAsync(); #region 6. JourDisp *** *** *** *** *** *** *** *** *** * sysJourDisp.DirDispOperationID = 7; //Изменение настроек sysJourDisp.DirEmployeeID = field.DirEmployeeID; sysJourDisp.ListObjectID = ListObjectID; sysJourDisp.TableFieldID = 1; sysJourDisp.Description = ""; try { sysJourDispsController.mPutPostSysJourDisps(db, sysJourDisp, EntityState.Added); } catch (Exception ex) { } #endregion dynamic collectionWrapper = new { ID = sysSetting.SysSettingsID }; return(Ok(returnServer.Return(true, collectionWrapper))); } catch (Exception ex) { return(Ok(returnServer.Return(false, exceptionEntry.Return(ex)))); } #endregion }
protected void Page_Load(object sender, EventArgs e) { if (Session["account"] != null) { Account a = (Account)Session["account"]; if (a.Role != ((int)SysSetting.Role.admin_hq).ToString()) { Response.Redirect("~/index.aspx"); } else { Sid = Request.QueryString["sid"].ToString(); if (Page.IsPostBack == false)//剛開始載入頁面 { Dictionary <string, object> d = new Dictionary <string, object>(); Lib.DataUtility du = new Lib.DataUtility(); d.Add("value", Sid); d.Add("type", "sid"); DataTable dt = du.getDataTableBysp("Ex108_GetPlayerData", d); if (dt.Rows.Count > 0) { if (!string.IsNullOrEmpty(dt.Rows[0]["name"].ToString())) { Name = dt.Rows[0]["name"].ToString(); txb_Name.Text = Name; Old_Name = Name; lab_OldName.Text = "(" + Old_Name + ")"; } if (!string.IsNullOrEmpty(dt.Rows[0]["id"].ToString())) { Id = dt.Rows[0]["id"].ToString(); txb_Id.Text = Id; Old_Id = Id; lab_OldId.Text = "(" + Old_Id + ")"; } if (!string.IsNullOrEmpty(dt.Rows[0]["birth"].ToString())) { Birth = dt.Rows[0]["birth"].ToString(); txb_Birth.Text = Birth; Old_Birth = Birth; lab_OldBirth.Text = "(" + Old_Birth + ")"; } if (!string.IsNullOrEmpty(dt.Rows[0]["mail"].ToString())) { Mail = dt.Rows[0]["mail"].ToString(); txb_Mail.Text = Mail; Old_Mail = Mail; lab_OldMail.Text = "(" + Old_Mail + ")"; } if (!string.IsNullOrEmpty(dt.Rows[0]["password"].ToString())) { Password = dt.Rows[0]["password"].ToString(); txb_Password.Text = Password; Old_Password = Password; lab_OldPassword.Text = "(" + Old_Password + ")"; } } } else//提交資料後回傳 { Dictionary <string, object> d = new Dictionary <string, object>(); Lib.DataUtility du = new Lib.DataUtility(); Name = txb_Name.Text; Id = txb_Id.Text.Trim(); Birth = txb_Birth.Text.Trim(); Mail = txb_Mail.Text.Trim(); d.Add("sid", Sid); d.Add("name", Name); d.Add("id", Id); d.Add("birth", Birth); d.Add("mail", Mail); d.Add("password", Password); try { //更新資料 du.executeNonQueryBysp("Ex108_UpdatePlayerData", d); //寫入log UpdateLog = string.Empty; if (!string.IsNullOrEmpty(Sid)) { UpdateLog += "sid-" + Sid + ","; } if (Old_Name != Name) { UpdateLog += "名[" + Old_Name + "," + Name + "]"; } if (Old_Id != Id) { UpdateLog += "證[" + Old_Id + "," + Id + "]"; } if (Old_Birth != Birth) { UpdateLog += "生[" + Old_Birth + "," + Birth + "]"; } if (Old_Mail != Mail) { UpdateLog += "郵[" + Old_Mail + "," + Mail + "]"; } if (Old_Password != Password) { UpdateLog += "密[" + Old_Password + "," + Password + "]"; } if (!string.IsNullOrEmpty(UpdateLog)) { SysSetting.AddLog("基本資料異動", a.AccountName, UpdateLog, DateTime.Now); } //回傳成功 ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.opener.outside('" + Id + "');window.close()", true); } catch (Exception ex) { //記錄錯誤訊息 SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, this.ToString()); //回傳失敗 ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "window.opener.outside('Err');window.close()", true); } } } } if (Session["account"] == null && Session["player"] == null) { Response.Redirect("~/Login.aspx"); } }
public object InsertUpdateSysSetting(SysSetting sysSetting) { return(_sysSettingRepository.InsertUpdateSysSetting(sysSetting)); }
public void UpdateUserSystemSettings(SysSetting userSystemSettings) { _command.ActiveUser = ActiveUser; _command.UpdateUserSystemSettings(userSystemSettings); }
public static void UpdateUserSystemSettings(SysSetting userSystemSettings) { _commands.UpdateUserSystemSettings(ActiveUser, userSystemSettings); }
public Task Execute(IJobExecutionContext context) { DateTime dateTime = DateTime.Now; YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = yuebonCacheHelper.Get("SysSetting").ToJson().ToObject <SysSetting>(); Stopwatch stopwatch = new Stopwatch(); stopwatch.Start(); AbstractTrigger trigger = (context as JobExecutionContextImpl).Trigger as AbstractTrigger; string sqlWhere = string.Format("Id='{0}' and GroupName='{1}'", trigger.Name, trigger.Group); TaskManager taskManager = iService.GetWhere(sqlWhere); if (taskManager == null) { FileQuartz.WriteErrorLog($"任务不存在"); return(Task.Delay(1)); } try { string msg = $"开始时间:{dateTime.ToString("yyyy-MM-dd HH:mm:ss ffff")}"; //记录任务执行记录 iService.RecordRun(taskManager.Id, JobAction.开始, true, msg); //初始化任务日志 FileQuartz.InitTaskJobLogPath(taskManager.Id); var jobId = context.MergedJobDataMap.GetString("OpenJob"); //todo:这里可以加入自己的自动任务逻辑 Log4NetHelper.Info(DateTime.Now.ToString() + "执行任务"); stopwatch.Stop(); string content = $"结束时间:{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ffff")} 共耗时{stopwatch.ElapsedMilliseconds} 毫秒\r\n"; iService.RecordRun(taskManager.Id, JobAction.结束, true, content); if ((MsgType)taskManager.SendMail == MsgType.All) { string emailAddress = sysSetting.Email; if (!string.IsNullOrEmpty(taskManager.EmailAddress)) { emailAddress = taskManager.EmailAddress; } List <string> recipients = new List <string>(); recipients = emailAddress.Split(",").ToList(); var mailBodyEntity = new MailBodyEntity() { Body = msg + content + ",请勿回复本邮件", Recipients = recipients, Subject = taskManager.TaskName }; SendMailHelper.SendMail(mailBodyEntity); } } catch (Exception ex) { stopwatch.Stop(); string content = $"结束时间:{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ffff")} 共耗时{stopwatch.ElapsedMilliseconds} 毫秒\r\n"; iService.RecordRun(taskManager.Id, JobAction.结束, false, content + ex.Message); FileQuartz.WriteErrorLog(ex.Message); if ((MsgType)taskManager.SendMail == MsgType.Error || (MsgType)taskManager.SendMail == MsgType.All) { string emailAddress = sysSetting.Email; if (!string.IsNullOrEmpty(taskManager.EmailAddress)) { emailAddress = taskManager.EmailAddress; } List <string> recipients = new List <string>(); recipients = emailAddress.Split(",").ToList(); var mailBodyEntity = new MailBodyEntity() { Body = "处理失败," + ex.Message + ",请勿回复本邮件", Recipients = recipients, Subject = taskManager.TaskName }; SendMailHelper.SendMail(mailBodyEntity); } } return(Task.Delay(1)); }
/// <summary> /// 执行远程接口url的定时任务 /// </summary> /// <param name="context"></param> /// <returns></returns> public Task Execute(IJobExecutionContext context) { YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); SysSetting sysSetting = yuebonCacheHelper.Get("SysSetting").ToJson().ToObject <SysSetting>(); Stopwatch stopwatch = new Stopwatch(); stopwatch.Start(); AbstractTrigger trigger = (context as JobExecutionContextImpl).Trigger as AbstractTrigger; string sqlWhere = string.Format("Id='{0}' and GroupName='{1}'", trigger.Name, trigger.Group); TaskManager taskManager = iService.GetWhere(sqlWhere); string httpMessage = ""; if (taskManager == null) { FileQuartz.WriteErrorLog($"任务不存在"); return(Task.Delay(1)); } FileQuartz.InitTaskJobLogPath(taskManager.Id); string msg = $"开始时间:{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ffff")}"; //记录任务执行记录 iService.RecordRun(taskManager.Id, JobAction.开始, true, msg); if (string.IsNullOrEmpty(taskManager.JobCallAddress) || taskManager.JobCallAddress == "/") { FileQuartz.WriteErrorLog($"{ DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ffff")}未配置任务地址,"); iService.RecordRun(taskManager.Id, JobAction.结束, false, "未配置任务地址"); return(Task.Delay(1)); } try { Dictionary <string, string> header = new Dictionary <string, string>(); if (!string.IsNullOrEmpty(taskManager.JobCallParams)) { httpMessage = HttpRequestHelper.HttpPost(taskManager.JobCallAddress, taskManager.JobCallParams, null, header); } else { httpMessage = HttpRequestHelper.HttpGet(taskManager.JobCallAddress); } stopwatch.Stop(); string content = $"结束时间:{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ffff")} 共耗时{stopwatch.ElapsedMilliseconds} 毫秒,消息:{httpMessage??"OK"}\r\n"; iService.RecordRun(taskManager.Id, JobAction.结束, true, content); if ((MsgType)taskManager.SendMail == MsgType.All) { string emailAddress = sysSetting.Email; if (!string.IsNullOrEmpty(taskManager.EmailAddress)) { emailAddress = taskManager.EmailAddress; } List <string> recipients = new List <string>(); recipients = taskManager.EmailAddress.Split(",").ToList(); //recipients.Add(taskManager.EmailAddress); var mailBodyEntity = new MailBodyEntity() { Body = content + "\n\r请勿直接回复本邮件!", Recipients = recipients, Subject = taskManager.TaskName, }; SendMailHelper.SendMail(mailBodyEntity); } } catch (Exception ex) { stopwatch.Stop(); string content = $"结束时间:{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ffff")} 共耗时{stopwatch.ElapsedMilliseconds} 毫秒\r\n"; iService.RecordRun(taskManager.Id, JobAction.结束, false, content + ex.Message); FileQuartz.WriteErrorLog(ex.Message); if ((MsgType)taskManager.SendMail == MsgType.Error || (MsgType)taskManager.SendMail == MsgType.All) { string emailAddress = sysSetting.Email; if (!string.IsNullOrEmpty(taskManager.EmailAddress)) { emailAddress = taskManager.EmailAddress; } List <string> recipients = new List <string>(); recipients = emailAddress.Split(",").ToList(); var mailBodyEntity = new MailBodyEntity() { Body = ex.Message + "\n\r请勿直接回复本邮件!", Recipients = recipients, Subject = taskManager.TaskName, }; SendMailHelper.SendMail(mailBodyEntity); } } return(Task.Delay(1)); }
public object InsertUpdateSysSetting(SysSetting sysSetting) { SqlParameter outputStatus, outputID = null; try { using (SqlConnection con = _databaseFactory.GetDBConnection()) { using (SqlCommand cmd = new SqlCommand()) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Connection = con; cmd.CommandText = "[PSA].[InsertUpdateSysSetting]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IsUpdate", SqlDbType.Bit).Value = sysSetting.IsUpdate; if (sysSetting.ID == Guid.Empty) { cmd.Parameters.AddWithValue("@ID", DBNull.Value); } else { cmd.Parameters.Add("@ID", SqlDbType.UniqueIdentifier).Value = sysSetting.ID; } cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = sysSetting.Name.Replace("-", "_ "); cmd.Parameters.Add("@Value", SqlDbType.VarChar).Value = sysSetting.Value; cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar, 250).Value = sysSetting.PSASysCommon.CreatedBy; cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = sysSetting.PSASysCommon.CreatedDate; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar, 250).Value = sysSetting.PSASysCommon.UpdatedBy; cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = sysSetting.PSASysCommon.UpdatedDate; outputStatus = cmd.Parameters.Add("@Status", SqlDbType.SmallInt); outputStatus.Direction = ParameterDirection.Output; outputID = cmd.Parameters.Add("@IDOut", SqlDbType.UniqueIdentifier); outputID.Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); } } switch (outputStatus.Value.ToString()) { case "0": throw new Exception(sysSetting.IsUpdate ? _appConstant.UpdateFailure : _appConstant.InsertFailure); case "1": sysSetting.ID = Guid.Parse(outputID.Value.ToString()); return(new { Code = outputID.Value.ToString(), Status = outputStatus.Value.ToString(), Message = sysSetting.IsUpdate ? _appConstant.UpdateSuccess : _appConstant.InsertSuccess }); default: break; } } catch (Exception ex) { throw ex; } return(new { ID = sysSetting.ID, Status = outputStatus.Value.ToString(), Message = sysSetting.IsUpdate ? _appConstant.UpdateSuccess : _appConstant.InsertSuccess }); }
protected void submit_Click(object sender, EventArgs e) { try { if (loginType.SelectedValue == "advance") { Account a = new Account(txtName.Text.Trim(), txtPwd.Text.Trim(), Request.UserHostAddress.ToString()); // 2010/01/19 edit by angus if (a.IsValid) { if (a.IsIPLock) { Session["account"] = a; SysSetting.AddLog("登入", a.AccountName, "進階使用者登入成功,登入IP : " + Request.UserHostAddress.ToString(), DateTime.Now); Response.Redirect("~/Index.aspx", false); } else { SysSetting.AddLog("登入", txtName.Text, "進階使用者登入IP錯誤,登入IP : " + Request.UserHostAddress.ToString(), DateTime.Now); ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('登入之電腦IP錯誤 !!!')", true); } } else { txtPwd.Text = ""; SysSetting.AddLog("登入", txtName.Text, "進階使用者登入密碼驗證失敗,登入IP : " + Request.UserHostAddress.ToString(), DateTime.Now); ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('帳號密碼驗證失敗 !!!')", true); } } else if (loginType.SelectedValue == "user") { Lib.Player player = new Player(txtName.Text.Trim(), txtPwd.Text.Trim(), "password"); if (player.IsExist) { if (player.IsValid) { Session["player"] = player; Lib.SysSetting.AddLog("登入", player.ID, "一般受測人員登入成功,登入IP : " + Request.UserHostAddress.ToString(), DateTime.Now); //Response.Redirect("~/Index.aspx",false); if (player.IsMustReSetPassword == false) { Response.Redirect("~/Index.aspx", false); } else { Response.Redirect("~/NewPassword.aspx", false); } } if (!player.IsValid) { txtPwd.Text = ""; Lib.SysSetting.AddLog("登入", txtName.Text, "一般受測人員登入失敗,帳號密碼錯誤,登入IP : " + Request.UserHostAddress.ToString(), DateTime.Now); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('身分證字號或生日錯誤');", true); } } if (!player.IsExist) { txtName.Text = ""; txtPwd.Text = ""; Lib.SysSetting.AddLog("登入", txtName.Text, "一般受測人員登入失敗,帳號不存在,登入IP : " + Request.UserHostAddress.ToString(), DateTime.Now); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('您輸入的帳號不存在');", true); } } } catch (Exception ex) { Lib.SysSetting.ExceptionLog(ex.GetType().ToString(), ex.Message, this.ToString()); Lib.SysSetting.AddLog("登入", "system", ex.Message + "登入IP : " + Request.UserHostAddress.ToString(), DateTime.Now); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('資料輸入錯誤');", true); } }
public async Task <IHttpActionResult> PostSysSetting(SysSetting sysSetting) { return(Ok(returnServer.Return(false, Classes.Language.Sklad.Language.msg57(0)))); }
static SysSetting() { ServiceItems = new SysSetting() { Name = "服务条款", Code = "ServiceItems" }; Hotline = new SysSetting() { Name = "服务热线", Code = "Hotline" }; VoiceMailBox = new SysSetting() { Name = "语音热线", Code = "VoiceMailBox" }; Address = new SysSetting() { Name = "联系地址", Code = "Address" }; Post = new SysSetting() { Name = "邮政编码", Code = "Post" }; Email = new SysSetting() { Name = "邮箱", Code = "Email" }; }