public IgnoreAccNumUserControl() { InitializeComponent(); var ignoretxt = INIHelper.ReadString(IgnoreVIP, DirectoryManage.GetINIFullPath()); textBox1.Text = ignoretxt; }
public ResposeMessage Excute(InputArgs request) { var data = request.Data.ToString(); var jobject = Json.ToJObject(data); var template = jobject.TEMPLATE.ToString(); var printMode = (FPrintMode)int.Parse(jobject.PRINTMODE.ToString()); //指定打印模板目录 var sysType = request.SysType.ToString(); using (Report report = new Report()) { string reportfileName = DirectoryManage.GetFrxFullPath(template, sysType); if (File.Exists(reportfileName)) { report.Load(reportfileName); } else { //模板不存在时,自动设置为设计模式 printMode = FPrintMode.Design; //模板文件不存在,则重新设置文件名 report.FileName = reportfileName; } var ds = BuildDS(jobject); if (printMode != FPrintMode.BatchPrint) { report.RegisterData(ds); //设置报表显示数据源选项 foreach (DataTable dt in ds.Tables) { report.GetDataSource(dt.TableName).Enabled = true; } } switch (printMode) { case FPrintMode.Preview: case FPrintMode.Design: case FPrintMode.ExportPDF: var mainform = TechSvrApplication.Instance.MainFrm; mainform.Invoke(new MethodInvoker(() => { mainform.TopMost = true; if (mainform.WindowState == FormWindowState.Minimized) { mainform.WindowState = FormWindowState.Normal; } var originSize = mainform.Size; mainform.Width = 2; mainform.Height = 2; mainform.BringToFront(); mainform.TopMost = false; if (printMode == FPrintMode.Preview) { report.Show(); } else if (printMode == FPrintMode.Design) { report.Design(); } else if (printMode == FPrintMode.ExportPDF) { try { //导出PDF文件 report.Prepare(); using (SaveFileDialog sfd = new SaveFileDialog()) { sfd.Filter = @"PDF文件|*.pdf"; sfd.ShowDialog(); var pdfFileName = sfd.FileName; report.Export(new FastReport.Export.Pdf.PDFExport(), pdfFileName); //System.Diagnostics.Process.Start("Explorer.exe", pdfFileName); } } catch (Exception) { mainform.Size = originSize; mainform.WindowState = FormWindowState.Minimized; throw; } } mainform.Size = originSize; mainform.WindowState = FormWindowState.Minimized; })); break; case FPrintMode.Print: //不弹打印窗口 直接打印 report.PrintSettings.ShowDialog = false; report.Print(); break; case FPrintMode.BatchPrint: //批量打印 //查找打印模板 var ReportFileArr = ((DataTable)ds.Tables[0]).AsEnumerable() .Select(p => new { TEMPLATE = p.Field <string>(TEMPLATE_STR), SYSTYPE = p.Field <string>(SYSTYPE_STR), }).Distinct().ToList(); //遍历打印模板 foreach (var ReportFile in ReportFileArr) { DataSet dsDataSource = new DataSet(); var dt1 = (DataTable)ds.Tables[0]; //获取打印模板对应的数据 var mainDataRows = dt1.AsEnumerable().Where(p => p.Field <string>(TEMPLATE_STR) == ReportFile.TEMPLATE && p.Field <string>(SYSTYPE_STR) == ReportFile.SYSTYPE); var mainDataTable = dt1.Clone(); mainDataTable.TableName = dt1.TableName; var dt2 = (DataTable)ds.Tables[1]; var detailDataTable = dt2.Clone(); detailDataTable.TableName = dt2.TableName; foreach (var dataRow in mainDataRows) { mainDataTable.Rows.Add(dataRow.ItemArray); //获取主表对应的子表数据行 var detailDataRows = dt2.AsEnumerable().Where(p => p.Field <Int64>(APPLYNO_STR) == Int64.Parse(dataRow[APPLYNO_STR].ToString())).ToList(); foreach (var detailDataRow in detailDataRows) { detailDataTable.Rows.Add(detailDataRow.ItemArray); } } dsDataSource.Tables.Add(mainDataTable); dsDataSource.Tables.Add(detailDataTable); report.RegisterData(dsDataSource); string templatefileName = DirectoryManage.GetFrxFullPath(ReportFile.TEMPLATE, ReportFile.SYSTYPE); report.Load(templatefileName); report.PrintSettings.ShowDialog = false; report.Print(); } break; default: break; } } return(new ResposeMessage { type = ResultType.SUCCESS.ToString(), messageCode = MessageCode.information.ToString(), message = "打印成功", data = "" }); }
private void btnSave_Click(object sender, EventArgs e) { INIHelper.WriteInteger(Constants.INI_MAXRecordCount, int.Parse(txtMaxRecordcount.Text.Trim()), DirectoryManage.GetINIFullPath()); MessageBox.Show("保存成功"); }
private void btnSave_Click(object sender, EventArgs e) { INIHelper.WriteString(Constants.INI_ServicePort, txtPort.Text.Trim(), DirectoryManage.GetINIFullPath()); MessageBox.Show("端口已保存成功"); }
public void Alert() { try { if (!isRunning) { isRunning = true; var AlertTimes = int.Parse(System.Configuration.ConfigurationManager.AppSettings["AlertTimes"]); using (var db = new Model1()) { SqlParameter[] sqlParms = new SqlParameter[1]; sqlParms[0] = new SqlParameter("@alerttimes", AlertTimes); alertData = db.Database.SqlQuery <SaleRecord>("exec QuerySaleRecrod @alerttimes", sqlParms).ToList(); var vipInfos = db.t_rm_vip_info.ToList(); var ignoretxt = INIHelper.ReadString("IgnoreVIP", DirectoryManage.GetINIFullPath()); var ignoreList = ignoretxt.Split(','); var mode = System.Configuration.ConfigurationManager.AppSettings["Mode"] == "debug"; if (mode) { MessageBox.Show("vip数量:" + vipInfos.Count.ToString()); } foreach (var vipinfo in vipInfos) { try { //if (vipinfo.vip_start_date.HasValue && vipinfo.vip_start_date.Value.Month == DateTime.Now.Month) //{//当月不反积分 // if (mode) // { // MessageBox.Show("当月不反积分"); // } // continue; //} if (db.t_rm_vip_acclist.Where(o => o.oper_des == "活动##送积分" && o.memo == "活动##送积分" && o.card_no == vipinfo.card_no).Count() > 15) { if (mode) { MessageBox.Show("已经超过送积分次数 则跳过"); } continue; } var accnum = int.Parse(System.Configuration.ConfigurationManager.AppSettings["VipAccnum"]); var acclist = db.t_rm_vip_acclist.Where(o => o.oper_des == "活动##送积分" && o.memo == "活动##送积分" && o.card_no == vipinfo.card_no).ToList(); if (acclist.Count > 0) { var date1 = acclist.OrderByDescending(o => o.ope_date).FirstOrDefault().ope_date.Value.AddDays(30); if (date1 >= DateTime.Now) { if (mode) { MessageBox.Show("距离上次送积分还不到30天 则跳过"); } continue; } } if (ignoreList.Contains(vipinfo.card_no)) { if (mode) { MessageBox.Show("如果会员忽略列表里存在这个会员卡号,择跳过"); } //如果会员忽略列表里存在这个会员卡号,择跳过 continue; } if (mode) { MessageBox.Show("vip数量:" + vipInfos.Count.ToString()); } vipinfo.acc_num = vipinfo.acc_num + accnum; vipinfo.now_acc_num = vipinfo.now_acc_num + accnum; db.t_rm_vip_acclist.Add(new t_rm_vip_acclist { card_no = vipinfo.card_no, card_id = vipinfo.card_id, card_type = vipinfo.card_type, branch_no = "000", oper_type = "2", oper_id = "1001", ope_date = DateTime.Now, flow_no = "", consum_amt = 0, acc_num = accnum, oper_des = "活动##送积分", memo = "活动##送积分" }); } catch (Exception ex) { MessageBox.Show("错误:" + ex.ToString()); } } db.SaveChanges(); if (alertData.Count > 0) { MaintainenceAlertForm form = new MaintainenceAlertForm(alertData); form.ShowDialog(); } isRunning = false; } } } catch (Exception ex) { MessageBox.Show("错误:" + ex.ToString()); } }
private void button1_Click(object sender, EventArgs e) { INIHelper.WriteString(IgnoreVIP, textBox1.Text.Trim(), DirectoryManage.GetINIFullPath()); MessageBox.Show("保存成功"); }