private void btnSave_Click(object sender, EventArgs e) { try { lp.CronExpression1 = this.tbcron1.Text.Trim(); lp.CronExpression2 = this.tbcron2.Text.Trim(); lp.SqlConnStr = this.tbsqlconnstr.Text.Trim(); if (!SQLbll.IsConn(lp.SqlConnStr)) { MessageBox.Show("数据库连接失败:" + lp.SqlConnStr); return; } lp.CronExpressionTaocan = this.tbcronTaocan.Text.Trim(); lp.CronExpressionTaocanClose = this.tbcronTaocanClose.Text.Trim(); lp.EprIdBnetAccount = this.tbEpridBnetaccount.Text.Trim(); lp.UID = this.tbUid.Text.Trim(); lp.PWD = this.tbPwd.Text.Trim(); lp.Save(); lp.Reload(); MessageBox.Show("成功!"); } catch (Exception ex) { MessageBox.Show("失败" + ex); } }
//启动 private void toolStripBtnStart_Click(object sender, EventArgs e) { lp = new LocalParams(); if (lp == null) { MessageBox.Show("LocalParams为空。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (string.IsNullOrEmpty(lp.CronExpression1) || string.IsNullOrEmpty(lp.CronExpression2)) { MessageBox.Show("请设置QZ运行表达示。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (string.IsNullOrEmpty(lp.SqlConnStr)) { MessageBox.Show("请设置数据库连接字符串。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (!SQLbll.IsConn(lp.SqlConnStr)) { MessageBox.Show("数据库连接字符串无效。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } CreateJob cjob = new CreateJob(); if (!cjob.CheckCronExpression(lp.CronExpression1)) { MessageBox.Show(string.Format("表达试[{0}]无效", lp.CronExpression1), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (!cjob.CheckCronExpression(lp.CronExpression2)) { MessageBox.Show(string.Format("表达试[{0}]无效", lp.CronExpression2), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } /* * if (!cjob.CheckCronExpression(lp.CronExpressionTaocan)) * { * MessageBox.Show(string.Format("表达试[{0}]无效", lp.CronExpressionTaocan), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); * return; * } * * if (!cjob.CheckCronExpression(lp.CronExpressionTaocanClose)) * { * MessageBox.Show(string.Format("表达试[{0}]无效", lp.CronExpressionTaocanClose), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); * return; * } * */ // [秒] [分] [小时] [日] [月] [周] [年],日和周必须互斥,不能都指明特定的数字或*,必须有一个是?; *号就是每的意思;?代表不确定; - 表示区间; ,表示多个值 // 0 58 9 23 * ?,每年每月23号9点58分0秒执行 // 0 0/1 * * * ?,第分钟执行一次 // 0 0 * * * ?,每小时一次 // 0 15 10 15 * ? 每月15日上午10:15触发 // 0 15 10 L * ? 每月最后一天的10点15分触发 string cron = "0 28 15 * * ?"; IScheduler sched = cjob.CreateSched(lp.CronExpression1, "trigger1", "group1", typeof(CreateBillJob)); if (sched != null) { schList.Add(sched); sched.Start(); } else { MessageBox.Show(string.Format("表达试[{0}] CreateBillJob初始化失败!", lp.CronExpression1), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } IScheduler sched2 = cjob.CreateSched(lp.CronExpression2, "trigger2", "group2", typeof(CreateEmptyBillJob)); if (sched2 != null) { schList.Add(sched2); sched2.Start(); } else { MessageBox.Show("提示", string.Format("表达试[{0}] CreateBillJob初始化失败!", lp.CronExpression2), MessageBoxButtons.OK, MessageBoxIcon.Error); return; } /* * IScheduler sched3 = cjob.CreateSched(lp.CronExpressionTaocan, "trigger3", "group3", typeof(CreateTaoCanBillJob)); * if (sched3 != null) * { * schList.Add(sched3); * sched3.Start(); * } * else * { * MessageBox.Show("提示", string.Format("表达试[{0}] CreateTaoCanBillJob初始化失败!", lp.CronExpressionTaocan), MessageBoxButtons.OK, MessageBoxIcon.Error); * return; * } */ /* * IScheduler sched4 = cjob.CreateSched(lp.CronExpressionTaocanClose, "trigger4", "group4", typeof(CreateTaoCanCloseBillJob)); * if (sched4 != null) * { * schList.Add(sched4); * sched4.Start(); * } * else * { * MessageBox.Show("提示", string.Format("表达试[{0}] CreateTaoCanCloseBillJob初始化失败!", lp.CronExpressionTaocanClose), MessageBoxButtons.OK, MessageBoxIcon.Error); * return; * } */ this.toolStripBtnStart.Enabled = false; this.toolStripStatusLabel2.Text = DateTime.Now.ToString("yyyy/MM/dd H:mm:ss", System.Globalization.DateTimeFormatInfo.InvariantInfo);// string.Format("{0:yyyy\\/MM\\/dd HH:mm:ss}", DateTime.Now);//2005/11/5 14:23:20 这种格式更适合老外的格式; }