/// <summary> /// 导出TXT /// </summary> private void Export() { if (dgvProxyList.Rows.Count > 0) { var list = (IList <ProxyServer>)dgvProxyList.DataSource; if (list.Count > 0) { var objSave = new SaveFileDialog { Filter = @"(*.txt)|*.txt|" + @"(*.*)|*.*", FileName = DateTime.Now.ToString("yyyyMMddhhmmss") + ".txt" }; if (objSave.ShowDialog() == DialogResult.OK) { string[] result = TxtHelper.WriteProxyTxt(list, objSave.FileName, Encoding.UTF8); if (result[1] != "") { MsgBox.ShowErrorMessage(result[1]); } } } else { MsgBox.ShowMessage("No Data!"); } } }
public static void Calculate(string[] ids, DataSetLoader offlineLoader, DataSetLoader onlineLoader) { var offlineSigners = offlineLoader.EnumerateSigners(signer => ids.Contains(signer.ID)).ToList(); var onlineSigners = onlineLoader.EnumerateSigners(signer => ids.Contains(signer.ID)).ToList(); var offlinePipeline = FusionPipelines.GetOfflinePipeline(); var onlinePipeline = FusionPipelines.GetOnlinePipeline(); var fusionPipeline = FusionPipelines.GetFusionPipeline(onlineSigners, false, 0); foreach (var offSigner in offlineSigners) { Console.WriteLine(offSigner.ID + " started at " + DateTime.Now.ToString("h:mm:ss tt")); var onSigner = onlineSigners.Find(signer => signer.ID == offSigner.ID); Parallel.ForEach(offSigner.Signatures, offSig => { offlinePipeline.Transform(offSig); var onSig = onSigner.Signatures.Find(sig => sig.ID == offSig.ID); var onToOnPipeline = FusionPipelines.GetHackedOnToOnPipeline(offSig.GetFeature(FusionFeatures.Bounds)); onToOnPipeline.Transform(onSig); onlinePipeline.Transform(onSig); } ); Parallel.ForEach(offSigner.Signatures, offSig => { fusionPipeline.Transform(offSig); onlinePipeline.Transform(offSig); } ); var distViewer = FusionPipelines.GetDistanceMatrixViewer(onSigner.Signatures, offSigner.Signatures); TxtHelper.Save(TxtHelper.ArrayToLines(distViewer.Calculate()), "distancematrix" + offSigner.ID); } }
public void Save() { string file = LogConfig.LogFileName; string path = Path.Combine(directory, file); TxtHelper.Append(path, content); }
public DataTable BindGrid() { string fileName = this.selectDialog.Text; DataTable dt = new DataTable(); if (!string.IsNullOrEmpty(fileName)) { string ext = Path.GetExtension(fileName).ToLower(); FileType fileType = FileHelper.GetFileType(ext); bool isFirstColumn = true; string[] columns = new string[] { "联系人", "号码", "号码类型" }; this.grid1.AutoGenerateColumns = true; this.grid1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; this.grid1.ReadOnly = true; this.grid1.DataSource = null; if (fileType == FileType.Txt) { dt = TxtHelper.ParseDataTable(fileName, columns, isFirstColumn); } else if (fileType == FileType.Excel) { ITransferData t = TransferDataFactory.GetTransferData(fileName); dt = t.GetData(fileName, columns, isFirstColumn); } else { dt = TxtHelper.ToDataTable(AddressBook.Parse(fileName), columns, isFirstColumn); } this.grid1.DataSource = dt; } return(dt); }
private static void ResultsToTxt(FusionBenchmarkResults fusionResults, string fileName) { TxtHelper.Save(TxtHelper.BenchmarkResToLines(fusionResults.OffOffResults), fileName + "offoff"); TxtHelper.Save(TxtHelper.BenchmarkResToLines(fusionResults.OffOnResults), fileName + "offon"); TxtHelper.Save(TxtHelper.BenchmarkResToLines(fusionResults.OnOffResults), fileName + "onoff"); TxtHelper.Save(TxtHelper.BenchmarkResToLines(fusionResults.OnOnResults), fileName + "onon"); }
public static void Calculate(string[] ids, DataSetLoader offlineLoader, DataSetLoader onlineLoader) { var offlineSigners = offlineLoader.EnumerateSigners(signer => ids.Contains(signer.ID)).ToList(); var onlineSigners = onlineLoader.EnumerateSigners(signer => ids.Contains(signer.ID)).ToList(); var offlinePipeline = FusionPipelines.GetOfflinePipeline(); foreach (var offSigner in offlineSigners) { Console.WriteLine(offSigner.ID + " started at " + DateTime.Now.ToString("h:mm:ss tt")); var onSigner = onlineSigners.Find(signer => signer.ID == offSigner.ID); Parallel.ForEach(offSigner.Signatures, offSig => { Console.WriteLine("Preprocess - " + offSig.Signer.ID + "_" + offSig.ID + "started at " + DateTime.Now.ToString("h:mm:ss tt")); offlinePipeline.Transform(offSig); var onSig = onSigner.Signatures.Find(sig => sig.ID == offSig.ID); var onToOnPipeline = FusionPipelines.GetHackedOnToOnPipeline(offSig.GetFeature(FusionFeatures.Bounds)); onToOnPipeline.Transform(onSig); } ); int numOfRef = 10; int numOfGen = 20; var references = onSigner.Signatures.FindAll(sig => sig.Origin == Origin.Genuine).Take(numOfRef).ToList(); var genuines = offSigner.Signatures.FindAll(sig => sig.Origin == Origin.Genuine).Take(numOfGen).ToList(); double[,] results = new double[references.Count, genuines.Count]; for (int i = 0; i < references.Count; i++) { var fusionPipeline = FusionPipelines.GetFusionPipeline(onlineSigners, false, i); Parallel.For(0, genuines.Count, j => { Console.WriteLine("ref: {0}, sig: {1}", i, j); fusionPipeline.Transform(genuines[j]); } ); var pairingDists = new StrokePairingDistances { InputOfflineTrajectory = FusionFeatures.Trajectory, InputOnlineTrajectory = FusionFeatures.Trajectory, OnlineSignatures = onSigner.Signatures, OfflineSignatures = genuines }; var newDists = pairingDists.Calculate(); if (newDists.Count != results.GetLength(1)) { throw new Exception(); } for (int j = 0; j < newDists.Count; j++) { results[i, j] = newDists[j].Item3; Console.WriteLine(results[i, j]); } } TxtHelper.Save(TxtHelper.ArrayToLines(results), "pairingmatrix" + offSigner.ID); } }
public System.Data.DataTable GetData(System.IO.Stream stream, string[] columnNames = null, bool isFirstColumn = false) { byte[] bytes = new byte[stream.Length]; stream.Read(bytes, 0, (int)stream.Length); string txt = Encoding.Default.GetString(bytes); return(TxtHelper.ToDataTable(txt, columnNames, isFirstColumn)); }
/// <summary> /// 解析通讯录文件 /// </summary> /// <param name="fileName"></param> /// <returns></returns> public static string Parse(string fileName) { if (!string.IsNullOrEmpty(fileName)) { string ext = Path.GetExtension(fileName).ToLower(); StringBuilder sb = new StringBuilder(); try { string text = FileHelper.GetFileContent(fileName, Encoding.UTF8); FileType fileType = FileHelper.GetFileType(ext); if (!string.IsNullOrEmpty(text)) { bool isFirstColumn = false; string[] columns = new string[] { "联系人", "号码", "号码类型" }; string templ = "{0}\t{1}\t{2}"; if (ext == ".vcf") { sb.AppendLine(string.Format(templ, columns[0], columns[1], columns[2])); string regexName = @"^(?:FN:)(.*)(?:/*.*)$"; MatchCollection matchName = Regex.Matches(text, regexName, RegexOptions.IgnoreCase | RegexOptions.Multiline); string regexTel = @"^(?:TEL;TYPE=CELL(?:;TYPE=PREF)?:)((\+86)?\d{11,12})"; MatchCollection matchTel = Regex.Matches(text, regexTel, RegexOptions.IgnoreCase | RegexOptions.Multiline); if (matchName.Count > 0 && matchTel.Count > 0) { for (int i = 0; i < matchName.Count; i++) { string name = Regex.Replace(matchName[i].Groups[1].Value, "/+.*$", ""); string value = matchTel[i].Groups[1].Value; string type = Regex.IsMatch(value, @"^(\+86){1}\d{11}$") ? "联通" : "移动"; string tel = Regex.Replace(value, @"^(\+86){1}", ""); if (tel.StartsWith("0")) { type = "座机"; } sb.AppendLine(string.Format(templ, name, tel, type)); } } } else if (fileType == FileType.Txt) { sb.Append(text); } else if (fileType == FileType.Excel) { ITransferData transfer = TransferDataFactory.GetTransferData(fileName); DataTable dt = transfer.GetData(fileName, columns, isFirstColumn); sb.Append(TxtHelper.ToTextContent(dt)); } } } catch (Exception ex) { sb.Append(ex.Message); } return(sb.ToString()); } return(string.Empty); }
protected void Page_Load(object sender, EventArgs e) { name = QueryString[Constants.MYQUERY_NAME]; if (!Page.IsPostBack) { WebHelper.SetControlAttributes(btnSubmit, new TextBoxVal[] { txtTitle, HtmlUrl, AspxUrl }); if (CurrentUser.IsAdmin())//仅管理员才能操作 { HtmlUrl.Enabled = true; DepId.Enabled = true; divUp.Visible = true; btnUp.Visible = true; WebHelper.SetAttributesOfFile(fileHtml); WebHelper.SetAttributesOfFile(fileXml); } else { HtmlUrl.Enabled = false; DepId.Enabled = false; divUp.Visible = false; btnUp.Visible = false; } try { DataFrom dataFrom = new DataFrom(); dataFrom.BindListCtrl(String.Format("select id,case when parentid='0' then '' else ' ' end+name from f_city where iflag=1 and (parentid='{0}' or id='{0}') order by parentid,id", CurrentUser.DepID), DepId, CurrentUser.IsAdmin()); if (!String.IsNullOrEmpty(name)) { HtmlUrl.Text = name; DataTable dt = dataFrom.GetDataTable("select Title,AspxUrl,depid from HtmlTemplate where HtmlUrl='" + name + "'"); if (dt != null && dt.Rows.Count > 0) { txtTitle.Text = dt.Rows[0]["Title"].ToString(); AspxUrl.Text = dt.Rows[0]["AspxUrl"].ToString(); WebHelper.SetSelCtrl(dt.Rows[0]["depid"].ToString(), DepId); } Content.Text = TxtHelper.GetString(WebHelper.GetMyXmlPath() + "\\tpl\\" + name + Constants.HTML_SUFFIX); XmlDocument doc = FromXml.GetXml(name); if (doc == null) { txtXml.Text = XmlHelper.GetXmlDocument(true).DocumentElement.OuterXml; } else { txtXml.Text = XmlHelper.GetFormatXml(doc); } } } catch (Exception ex) { Logger.Error("初始化失败", ex); RedirectError("初始化失败,请稍候再试。原因:" + ex.Message); return; } } }
private string ReadAndLoadFile(string fname) { string FilePath = TxtHelper.PrepareFilePath(fname, "ReadingFiles"); string selectedFileContent = TxtHelper.ExtractTextFromTxt(FilePath); LblFlag.Text = "Okunan dosya : " + fname; LblFlag.Text = fname + "dosyası üzerinde kelime analizi başlatılmıştır"; return(selectedFileContent); }
/// <summary> /// 自动数据加密连接字符串,该功能暂时屏蔽 /// </summary> /// <param name="EncryptString"></param> protected virtual void OutputDecryptString(string EncryptString) { string filename = this.GetType().Assembly.GetAssemblyPath(); if (filename == null) { filename = "c:\\"; } filename = filename + "\\ProteinEncrypt.txt"; string erContent = EncryptString.CipherEncryptDES(); TxtHelper.Write(filename, erContent); }
private void MainWindow_Closed(object sender, EventArgs e) { ComDevice.Write("tozero,"); CompositionTarget.Rendering -= CompositionTarget_Rendering; TxtHelper.Write(txtpath, LastVal.ToString()); ComDevice.Close(); ComDevice.Dispose(); Thread.Sleep(2000); //time.Stop(); }
/// <summary> /// 粘贴 /// </summary> public void PasteThis() { var iData = Clipboard.GetDataObject(); if (iData == null || !iData.GetDataPresent(DataFormats.Text)) { return; } var text = (String)iData.GetData(DataFormats.Text); //text = TxtHelper.Format(text); TxtHelper.ReadProxyTxt(text); BindData(); }
public static Tuple <List <double>, List <List <double> > > Calculate(DataSetLoader loader) { var signers = loader.EnumerateSigners().ToList(); var resampler = new ReSamplingFeatureExtraction() { InputButton = FusionFeatures.Button, InputX = FusionFeatures.X, InputY = FusionFeatures.Y }; var results = resampler.Calculate(signers); TxtHelper.Save(TxtHelper.ReSamplingResultsToLines(results), "resamplingdataset"); return(results); }
// Сохранить чек в txt private void button2_Click(object sender, EventArgs e) { TxtHelper txtHelper = new TxtHelper(); try { txtHelper.SaveRecieptToTxt("W:\\reciept.txt", dataGridView1); System.Windows.Forms.MessageBox.Show("Чек в txt сохранен!", "Информация", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch { System.Windows.Forms.MessageBox.Show("Ошибка!", "Информация", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void Handle(string postStr, WeiXinBasic basic) { try { //封装请求类 XmlDocument doc = new XmlDocument(); doc.LoadXml(postStr); XmlElement rootElement = doc.DocumentElement; XmlNode MsgType = rootElement.SelectSingleNode("MsgType"); RequestXML requestXML = new RequestXML(); requestXML.PostStr = postStr; requestXML.ToUserName = rootElement.SelectSingleNode("ToUserName").InnerText; requestXML.FromUserName = rootElement.SelectSingleNode("FromUserName").InnerText; requestXML.CreateTime = rootElement.SelectSingleNode("CreateTime").InnerText; requestXML.MsgType = MsgType.InnerText; if (requestXML.MsgType == "event" || requestXML.MsgType == "text") { if (requestXML.MsgType == "event") { requestXML.Eevent = rootElement.SelectSingleNode("Event").InnerText; requestXML.EventKey = rootElement.SelectSingleNode("EventKey") == null ? "" : rootElement.SelectSingleNode("EventKey").InnerText; } ResponseMsg(requestXML, basic); } } catch (Exception ex) { string emptystr = ""; System.Web.HttpContext.Current.Response.Write(emptystr); //加txt文档记录 TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\weixinerrLog.txt", ex.Message); } }
static void TestExcelRead(string file) { try { using (ExcelHelper excelHelper = new ExcelHelper(file)) { DataTable dt = excelHelper.ExcelToDataTable("SQL Results", true); TxtHelper.ExportTxt(dt); } } catch (Exception ex) { Debug.Print("Exception: " + ex.Message); } }
public void PasteThis() { IsPasting = true; IDataObject iData = Clipboard.GetDataObject(); if (iData.GetDataPresent(DataFormats.Text)) { var text = (String)iData.GetData(DataFormats.Text); //text = TxtHelper.Format(text); string result = TxtHelper.ReadProxyTxt(text)[1]; Config.ConsoleEx.Debug(result); Config.MainForm.ProxyPage.BindData(); Config.MainForm.ProxyPage.Activate(); } IsPasting = false; }
public MainWindow() { InitializeComponent(); slider1.Maximum = Valmax; string[] ports = SerialPort.GetPortNames(); //ComDevice.PortName = ports[0]; ComDevice.PortName = comport; ComDevice.BaudRate = 115200; ComDevice.Parity = Parity.None; ComDevice.DataBits = 8; ComDevice.StopBits = StopBits.One; ComDevice.DataReceived += new SerialDataReceivedEventHandler(Com_DataReceived);//绑定事件 ComDevice.Open(); isCanSend1 = true; string tempval = TxtHelper.ReadAll(txtpath); if (!string.IsNullOrEmpty(tempval)) { double lastSaveValue = double.Parse(tempval); slider1.Value = lastSaveValue; _val = lastSaveValue; LastVal = lastSaveValue; txt.Text = _val.ToString(); ComDevice.Write(lastSaveValue + ","); Thread.Sleep(200); ComDevice.Write(lastSaveValue + ","); ComDevice.Write(lastSaveValue + ","); } else { ComDevice.Write("21,"); Thread.Sleep(200); } Loaded += MainWindow_Loaded; Closed += MainWindow_Closed; }
public void readFile() { loadedNotes.Clear(); if (Settings.FilePath == "") { List <string> emptyList = new List <string>(); currentNode = new SplitNotes(emptyList, Settings); return; } List <string> lines = TxtHelper.readFile(Settings.FilePath); List <String> curSplitSection = new List <string>(); int?curSplitStart = null; int?curSplitEnd = null; int index = 0; foreach (string curLine in lines) { if (curLine.Contains("----------")) { if (curSplitStart == null && curSplitEnd == null) { curSplitStart = index + 1; } else if (curSplitStart != null && curSplitEnd == null) { curSplitEnd = index; curSplitSection = lines.GetRange(curSplitStart.Value, curSplitEnd.Value - curSplitStart.Value); loadedNotes.Add(new SplitNotes(curSplitSection, Settings)); curSplitStart = null; curSplitEnd = null; } } index++; } currentNode = loadedNotes.First(); Settings.FilePathChanged = false; }
public static BenchmarkResults BenchMarkingWithAllSigners(bool isoptimal, DataSetLoader offlineLoader, DataSetLoader onlineLoader) { var offlineSigners = offlineLoader.EnumerateSigners().ToList(); var onlineSigners = onlineLoader.EnumerateSigners().ToList(); var benchmark = FusionPipelines.GetBenchmark(offlineSigners, isoptimal); var offlinePipeline = FusionPipelines.GetOfflinePipeline(); var onlinePipeline = FusionPipelines.GetOnlinePipeline(); var fusionPipeline = FusionPipelines.GetFusionPipeline(onlineSigners, false, 0); foreach (var offSigner in offlineSigners) { Console.WriteLine(offSigner.ID + " started at " + DateTime.Now.ToString("h:mm:ss tt")); var onSigner = onlineSigners.Find(signer => signer.ID == offSigner.ID); Parallel.ForEach(offSigner.Signatures, offSig => { offlinePipeline.Transform(offSig); var onSig = onSigner.Signatures.Find(sig => sig.ID == offSig.ID); var onToOnPipeline = FusionPipelines.GetHackedOnToOnPipeline(offSig.GetFeature(FusionFeatures.Bounds)); onToOnPipeline.Transform(onSig); onlinePipeline.Transform(onSig); } ); Parallel.ForEach(offSigner.Signatures, offSig => { fusionPipeline.Transform(offSig); onlinePipeline.Transform(offSig); } ); var listWithOnlySigner = new List <Signer>() { offSigner }; var onlySigBenchmark = FusionPipelines.GetBenchmark(listWithOnlySigner, true); var onlyRes = onlySigBenchmark.Execute(); TxtHelper.Save(TxtHelper.BenchmarkResToLines(onlyRes), "offoff" + offSigner.ID); } return(benchmark.Execute()); }
public Tuple <List <double>, List <List <double> > > Calculate(Signer signer) { var resList = new List <double>(); var dataLists = new List <List <double> >(); Parallel.ForEach(signer.Signatures, sig => { if (sig.Origin == Origin.Genuine) { var newRes = Calculate(sig); List <double> newResList = newRes.Item1; List <List <double> > newDataLists = newRes.Item2; lock (o) { resList.AddRange(newResList); if (dataLists.Count == 0) { for (int i = 0; i < newDataLists.Count; i++) { dataLists.Add(new List <double>()); } } if (dataLists.Count != newDataLists.Count) { throw new Exception(); } for (int i = 0; i < dataLists.Count; i++) { dataLists[i].AddRange(newDataLists[i]); } } } } ); Check(resList, dataLists); var res = new Tuple <List <double>, List <List <double> > >(resList, dataLists); TxtHelper.Save(TxtHelper.ReSamplingResultsToLines(res), "resamplingdata" + signer.ID); return(res); }
/// <summary> /// 给常规任务相关人发邮件 /// </summary> /// <param name="mailContent">内容</param> /// <param name="userids">多个用,分割</param> /// <param name="userid">不空时 则通知其部门领导</param> public void SendMailTask(string mailContent, string userids, string userid) { DataTable dt = null; if (String.IsNullOrEmpty(userids)) { dt = dao.GetDataTable(@"select ProjectMilestone.*,s_user.Name as createrName,TechnicManager.Name as TechnicManagerName from ProjectMilestone inner join s_user on ProjectMilestone.UserId=s_user.id left join s_user TechnicManager on ProjectMilestone.TechnicManager=TechnicManager.id where ProjectMilestone.id=" + mailContent); userid = dt.Rows[0]["TechnicManager"].ToString(); userids = dt.Rows[0]["UserId"].ToString() + "," + userid; mailContent = TxtHelper.GetString(WebHelper.GetRootServerPath() + "Project\\Mail\\MilestoneTask" + Constants.HTML_SUFFIX); string flagDes = ""; switch (Convert.ToInt32(dt.Rows[0]["iflag"])) { case 0: flagDes = "关闭"; break; case 1: flagDes = "进行中"; break; } mailContent = String.Format(mailContent, dt.Rows[0]["Name"], currentUser.Name, dt.Rows[0]["createrName"], dt.Rows[0]["TechnicManagerName"], dt.Rows[0]["StartDate"], dt.Rows[0]["EndDate"], flagDes); } if (!String.IsNullOrEmpty(mailContent) && !String.IsNullOrEmpty(userids)) { string sql = "select email from S_User where id " + SqlHelper.GetSqlInWhere(userids); if (!String.IsNullOrEmpty(userid)) { sql += " or id in (select s_dep.Manager from s_dep inner join s_user on s_dep.id=s_user.depid where s_user.id='" + userid + "')"; } dt = dao.GetDataTable(sql); MailHelper.SendMail(DataHelper.GetString(dt.Rows, null), "任务处理提醒邮件", mailContent, null); } }
/// <summary> /// 导入TXT /// </summary> private void Import() { if (Config.MainForm.StatusContains(Config.LocalLanguage.Messages.Testing)) { return; } var objOpen = new OpenFileDialog { Filter = @"(*.txt)|*.txt|" + @"(*.*)|*.*" }; if (objOpen.ShowDialog() == DialogResult.OK) { string[] result = TxtHelper.ReadProxyTxt(objOpen.FileName, Encoding.UTF8); if (result[1] != "") { MsgBox.ShowErrorMessage(result[1]); } else { BindDgv(ProxyData.ProxyList); } } }
/// <summary> /// 执行任务 /// </summary> public void Run() { string msg = "任务开始时间:" + DateTime.Now.ToString(); try { //查找超时未填报任务 string sql = @"select S_User.Name,S_User.EMail ,(select max(workday) as workday from WorkWeek where datediff(day,WorkDay,getdate())>" + _days + @" and Iflag=1) as workday" + (_toHeader ? ",manager.EMail as HeaderEmail" : "") + @" from S_User"; if (_toHeader) { sql += @" left join s_dep on s_dep.id=s_user.depid left join s_user manager on s_dep.Manager=manager.id"; } sql += @" where S_User.Iflag='1' and S_User.IsEffort=1 and s_user.id in (select distinct s_user.id from S_User inner join WorkWeek d on d.WorkDay>s_user.startdate left join ProjectWorkLog l on l.WorkDay=d.WorkDay and s_user.id=l.worker and l.EffortState=1 where d.Iflag=1 and d.workday<=(select max(workday) as workday from WorkWeek where datediff(day,WorkDay,getdate())>" + _days + @" and Iflag=1) group by s_user.id,d.workday having isnull(sum(l.Effort),0)<8)"; DataTable dt = new Dao().GetDataTable(sql); if (dt == null || dt.Rows.Count == 0) { msg += ",没有超时未填报的人员"; } else { msg += ",超时未填报共" + dt.Rows.Count + "人"; string mailContent = TxtHelper.GetString(WebHelper.GetRootServerPath() + "Log\\Mail\\UnWrite" + Constants.HTML_SUFFIX); string mailHeader = null; if (_toHeader) { mailHeader = TxtHelper.GetString(WebHelper.GetRootServerPath() + "Log\\Mail\\UnWriteHeader" + Constants.HTML_SUFFIX); } foreach (DataRow dr in dt.Rows) { msg += "\r\n给" + dr["EMail"].ToString() + "发邮件"; try { MailHelper.SendMail(dr["EMail"].ToString(), "日志未填写提醒", String.Format(mailContent, dr["workday"]), null); if (_toHeader && !String.IsNullOrEmpty(mailHeader)) { msg += ",同时给领导" + dr["HeaderEmail"].ToString() + "发邮件"; MailHelper.SendMail(dr["HeaderEmail"].ToString(), "督促日志按时填写提醒", String.Format(mailHeader, dr["Name"], dr["workday"]), null); } } catch (Exception ex) { msg += ",处理异常:" + ex.Message + "已放弃"; } } } msg += "。完成"; } catch (Exception ex) { msg += ",处理异常:" + ex.Message + "已放弃"; } msg += "时间:" + DateTime.Now.ToString(); LogHelper.WriteToFile("UnWrite", msg); }
/// <summary> /// 打开Csv订单文件 /// </summary> /// <param name="filePath"></param> /// <returns></returns> public static DataSet OpenCsvbyTxt(string filePath) { int n = 0; DataTable dt = new DataTable("Datas"); string str = TxtHelper.Read(filePath); string[] strArr = str.Split('\n'); for (int i = 0; i < strArr.Length; i++) { if (strArr[i].Length > 0 && strArr[i].Last() == '\r') { strArr[i] = strArr[i].Substring(0, strArr[i].Length - 1); } } for (int j = 0; j < strArr.Length; j++) { string[] split = strArr[j].Split(','); if (split[0] == "") { break; } List <string> list = new List <string>(); string ss = ""; for (int i = 0; i < split.Length; i++) { if (split[i] == "") { list.Add(split[i]); continue; } if (split[i][0] == '"' && split[i].Last() != '"') { ss = split[i]; } else if (split[i][0] != '"' && split[i].Last() == '"') { ss = ss + "," + split[i]; list.Add(ss); } else { list.Add(split[i]); } } if (n == 0) { for (int i = 0; i < list.Count; i++) { dt.Columns.Add(list[i].Replace("\"", ""), typeof(string)); } n++; } else { DataRow dr = dt.NewRow(); for (int i = 0; i < list.Count; i++) { dr[i] = list[i].ToString().Replace("\"", ""); } dt.Rows.Add(dr); n++; } } DataSet ds = new DataSet(); ds.Tables.Add(dt); return(ds); }
protected void Page_Load(object sender, EventArgs e) { var inputStream = Request.InputStream; var strLen = Convert.ToInt32(inputStream.Length); var strArr = new byte[strLen]; inputStream.Read(strArr, 0, strLen); var requestMes = Encoding.UTF8.GetString(strArr); //TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\BaoxianLog.txt", requestMes); //录入和慧择网交互日志 ApiLog mapilog = new ApiLog { Id = 0, request_type = "Hzins_AsyncNotice", Serviceid = 2, Str = requestMes.Trim(), Subdate = DateTime.Now, ReturnStr = "success", ReturnSubdate = DateTime.Now, Errmsg = "", }; int ins = new ApiLogData().EditLog(mapilog); Hzins_AsyncOrderInfo mresp = (Hzins_AsyncOrderInfo)JsonConvert.DeserializeObject(requestMes, typeof(Hzins_AsyncOrderInfo)); if (mresp != null) { string insureNum = mresp.insureNum; int orderid = new Api_hzins_OrderApplyResp_OrderExtData().GetorderidbyinsureNum(mresp.insureNum); if (orderid == 0) { TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\BaoxianLog.txt", "orderid=0"); return; } B2b_order modelb2border = new B2bOrderData().GetOrderById(orderid); if (modelb2border == null) { TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\BaoxianLog.txt", "modelb2border==null"); return; } if (mresp.resultCode == 0) { if (mresp.policyList != null) { List <AsyncOrderInfo_policyList> policyList = mresp.policyList; foreach (AsyncOrderInfo_policyList policy in policyList) { int issueState = policy.issueState; string cName = policy.insurant; Api_hzins_OrderApplyResp_OrderInfo m1 = new Api_hzins_OrderApplyResp_OrderInfo { id = 0, orderid = modelb2border.Id, insureNum = insureNum, policyNum = "", cName = cName, cardCode = "", issueState = issueState }; int ins1 = new Api_hzins_OrderApplyResp_OrderInfoData().EditOrderApplyResp_OrderInfo(m1); } modelb2border.Order_state = (int)OrderStatus.HasSendCode; modelb2border.Order_remark = "异步出单成功"; new B2bOrderData().InsertOrUpdate(modelb2border); try { //如果保险订单(b单)是原始订单(a单)的绑定订单,则修改原始订单(a单)的状态 int aorderid = new B2bOrderData().Getinitorderid(orderid); if (aorderid > 0) { new B2bOrderData().Uporderstate(aorderid, (int)OrderStatus.HasSendCode); } } catch (Exception ex) { TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\BaoxianLog.txt", "aorderid error"); return; } } } else { modelb2border.Order_remark = "异步出单通知错误(" + requestMes + ")"; new B2bOrderData().InsertOrUpdate(modelb2border); TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\BaoxianLog.txt", "mresp.resultCode != 0"); return; } } Response.Write("success"); Response.End(); }
delegate void AsyncsendEventHandler(string updateurl, string pno, int confirmnum, string confirmtime, int agentcomid, int comid, int validateticketlogid, int aorderid);//发送验证同步发送请求委托 protected void Page_Load(object sender, EventArgs e) { try { string xml = Request["xml"].ToString(); //string xml = "rzChHB2sU9ld7U8YJm+ehw3aukqIGDM4BtqU0aUKqsh0Wlv7lE7QY0h+6TyATqOKSH7pPIBOo4pIfuk8gE6jikh+6TyATqOK88GTsYxHp+jxFjUWFoOLabGkQCK4I/78+O3AIZim06QMwlqxUloGSwUMhENjECcrzbztXnARK88eCV0nzDbYTSXGBvHHQSpCtYsGXg/lwRreR77JNU04PrnA/lhi3vGqrkNT1h37aYFq1/tYQ1Xz/ZZH12+3kc7eN5HVgtJCsazTnwU3IXzBtgTaJ2ESK0/X0ncZdJ1sFl4cdnO/KompxrjYGhqFw7FIjsFUOFy3n1dNbNhZIFe8Y78Lir83nuy1W7A/bsAjwDoqCCTzSMhu4i1fpj0wiwQw2BdtiUN3SUQvOPw+mKMgINlGNcH6G0/KSglfJdF6P3DNfmxtL8FfbNt6uk7GCtoKHZD21Lc7H95at7dJ0msz8Y+YwVrIaCGc"; //string xml = "<?xml version='1.0' encoding='UTF-8'?><Body><type>use_info</type><orderId>22221</orderId><outOrderId>126079</outOrderId><credence>991553361205</credence><useCount>1</useCount><lastCount>0</lastCount><useTime>2015-10-21 17:31:42</useTime><exchangeId>16504001</exchangeId><postTime>2015-10-21 17:33:00</postTime></Body>"; if (xml == "") { TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\mjldlog.txt", "xml空"); Response.Write("fail 接收参数为空"); return; } if (xml != "") { TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\mjldlog.txt", xml); ApiService mapiservice = new ApiServiceData().GetApiservice(3); if (mapiservice == null) { TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\mjldlog.txt", "获取服务商信息失败-" + xml); Response.Write("fail 获取服务商信息失败"); return; } xml = Mjld_TCodeServiceCrypt.Decrypt3DESFromBase64(xml, mapiservice.Deskey); try { XmlDocument doc = new XmlDocument(); doc.LoadXml(xml.Trim()); XmlElement root = doc.DocumentElement; string type = root.SelectSingleNode("type").InnerText; //验证推送 if (type == "use_info") { TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\mjldlog.txt", "use_info: " + xml); //录入交互日志 ApiLog mapilog = new ApiLog { Id = 0, request_type = "use_info", Serviceid = 3, Str = xml.Trim(), Subdate = DateTime.Now, ReturnStr = "", ReturnSubdate = DateTime.Now, Errmsg = "", }; int ins = new ApiLogData().EditLog(mapilog); //平台订单号 string MjldorderId = root.SelectSingleNode("orderId").InnerText; //合作伙伴订单号 string orderid = root.SelectSingleNode("outOrderId").InnerText; //验证码 string credence = root.SelectSingleNode("credence").InnerText; //使用数量 string useCount = root.SelectSingleNode("useCount").InnerText; //剩余数量 string lastCount = root.SelectSingleNode("lastCount").InnerText; //验证使用时间 string useTime = root.SelectSingleNode("useTime").InnerText; //验证ID string exchangeId = root.SelectSingleNode("exchangeId").InnerText; //景区ID //string ScenicId = root.SelectSingleNode("ScenicId").InnerText; string ScenicId = ""; //推送时间 string postTime = root.SelectSingleNode("postTime").InnerText; //根据验证id判断是否已经成功处理过该验证推送 Api_mjld_AsyncUsenotice sucnotice = new Api_mjld_AsyncUsenoticeData().GetSucUseNoticeByExchangeId(exchangeId); if (sucnotice == null) { Api_mjld_AsyncUsenotice usenotice = new Api_mjld_AsyncUsenotice { id = 0, type = type, mjldOrderId = MjldorderId, credence = credence, useCount = useCount.ConvertTo <int>(0), lastCount = lastCount.ConvertTo <int>(0), useTime = useTime, exchangeId = exchangeId, ScenicId = ScenicId, postTime = postTime, rcontent = "", orderId = orderid.ConvertTo <int>(0), }; int insUsenotice = new Api_mjld_AsyncUsenoticeData().EditUsenotice(usenotice); usenotice.id = insUsenotice; //易城系统订单 处理 B2b_order morder = new B2bOrderData().GetOrderById(orderid.ConvertTo <int>(0)); if (morder != null) { if (lastCount.ConvertTo <int>(0) > 0) { int usecount = morder.service_usecount + usenotice.useCount; morder.service_usecount = usecount; morder.service_lastcount = usenotice.lastCount; morder.Servicepro_v_state = ((int)Product_V_State.PartValidate).ToString(); //验证部分 morder.Order_state = (int)OrderStatus.HasUsed; //已消费 new B2bOrderData().InsertOrUpdate(morder); } else { int usecount = morder.service_usecount + usenotice.useCount; morder.service_usecount = usecount; morder.service_lastcount = usenotice.lastCount; morder.Servicepro_v_state = ((int)Product_V_State.AllValidate).ToString(); //验证全部 morder.Order_state = (int)OrderStatus.HasUsed; //已消费 new B2bOrderData().InsertOrUpdate(morder); } //根据b单判断是否有a单存在 B2b_order aorder = new B2bOrderData().GetOldorderBybindingId(morder.Id); if (aorder != null) { aorder.Order_state = morder.Order_state; new B2bOrderData().InsertOrUpdate(aorder); } usenotice.rcontent = "1"; new Api_mjld_AsyncUsenoticeData().EditUsenotice(usenotice); //如果是分销订单,则需要给分销发送验证通知 //判断b订单 是否 属于某个a订单 if (aorder != null) { //得到a订单的分销信息 if (aorder.Agentid > 0) { Agent_company acompany = new AgentCompanyData().GetAgentCompany(aorder.Agentid); if (acompany != null) { //异步发送验证同步请求 AsyncsendEventHandler mydelegate = new AsyncsendEventHandler(AsyncSend); mydelegate.BeginInvoke(acompany.Agent_updateurl.Trim(), credence, int.Parse(useCount), useTime, aorder.Agentid, aorder.Comid, 0, aorder.Id, new AsyncCallback(Completed), null); } } } else { if (morder.Agentid > 0) { Agent_company acompany = new AgentCompanyData().GetAgentCompany(morder.Agentid); if (acompany != null) { //异步发送验证同步请求 AsyncsendEventHandler mydelegate = new AsyncsendEventHandler(AsyncSend); mydelegate.BeginInvoke(acompany.Agent_updateurl.Trim(), credence, int.Parse(useCount), useTime, morder.Agentid, morder.Comid, 0, morder.Id, new AsyncCallback(Completed), null); } } } Response.Write("1"); return; } else { usenotice.rcontent = "fail 获取订单失败"; new Api_mjld_AsyncUsenoticeData().EditUsenotice(usenotice); Response.Write("fail"); return; } } else { Response.Write("1"); return; } } //退票推送 if (type == "back_order") { TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\mjldlog.txt", "back_order: " + xml); //录入交互日志 ApiLog mapilog = new ApiLog { Id = 0, request_type = "back_order", Serviceid = 3, Str = xml.Trim(), Subdate = DateTime.Now, ReturnStr = "", ReturnSubdate = DateTime.Now, Errmsg = "", }; int ins = new ApiLogData().EditLog(mapilog); //2为退单成功 3为拒绝 string backStatus = root.SelectSingleNode("backStatus").InnerText; //外部退单id string outBackId = root.SelectSingleNode("outBackId").InnerText; //成功退货数量 string backCount = root.SelectSingleNode("backCount").InnerText; //本平台退单id string backId = root.SelectSingleNode("backId").InnerText; //推送时间 string postTime = root.SelectSingleNode("postTime").InnerText; //根据mjldorderid判断是否成功处理过 Api_mjld_AsyncBacknotice sucnotice = new Api_mjld_AsyncBacknoticeData().GetSucApi_mjld_AsyncBacknotice(backId); if (sucnotice == null) { Api_mjld_AsyncBacknotice backnotice = new Api_mjld_AsyncBacknotice { id = 0, mjldorderid = backId, orderid = outBackId.ConvertTo <int>(0), backCount = backCount.ConvertTo <int>(0), backStatus = backStatus.ConvertTo <int>(0), postTime = postTime, rcontent = "", type = type }; int insBacknotice = new Api_mjld_AsyncBacknoticeData().EditBacknotice(backnotice); backnotice.id = insBacknotice; //易城系统订单 B2b_order morder = new B2bOrderData().GetOrderById(outBackId.ConvertTo <int>(0)); if (morder != null) { //只有订单状态 为"退票处理中",才会进行退款操作 if (morder.Order_state == (int)OrderStatus.WaitQuitOrder) { if (backStatus == "2") { OrderJsonData.QuitOrder(0, outBackId.ConvertTo <int>(0), morder.Pro_id, backCount.ConvertTo <int>(0), ""); } //拒绝退款 则还原原来订单状态;订单备注中 提示“拒绝退款” if (backStatus == "3") { //判断是否有订单 绑定传入的订单 B2b_order d_loldorder = new B2bOrderData().GetOldorderBybindingId(outBackId.ConvertTo <int>(0)); if (d_loldorder != null) { d_loldorder.Order_state = (morder.Order_remark).ConvertTo <int>(0); d_loldorder.Order_remark = "美景联动拒绝退票"; new B2bOrderData().UpOrderStateAndRemark(d_loldorder.Id, d_loldorder.Order_state, d_loldorder.Order_remark); } morder.Order_state = (morder.Order_remark).ConvertTo <int>(0);; morder.Order_remark = "美景联动拒绝退票"; new B2bOrderData().UpOrderStateAndRemark(morder.Id, morder.Order_state, morder.Order_remark); } backnotice.rcontent = "1"; new Api_mjld_AsyncBacknoticeData().EditBacknotice(backnotice); Response.Write("1"); return; } else { backnotice.rcontent = "fail 订单状态应该为(退票处理中),可是现在为:" + EnumUtils.GetName((OrderStatus)morder.Order_state); new Api_mjld_AsyncBacknoticeData().EditBacknotice(backnotice); Response.Write("fail"); return; } } else { backnotice.rcontent = "fail 获取订单失败"; new Api_mjld_AsyncBacknoticeData().EditBacknotice(backnotice); Response.Write("fail"); return; } } else { Response.Write("1"); return; } } } catch { Response.Write("fail"); return; } } } catch { Response.Write("fail 接收参数为空"); return; } }
private void btnSearch_Click(object sender, EventArgs e) { DataTable dt = CreateDataTable(); dt.Clear(); JSKRequest request = new JSKRequest(dt); string number = this.txtNumber.Text.Trim(); int current = number == "" ? 0 : Convert.ToInt32(number); this.btnSearch.Text = "搜索主页..."; this.btnSearch.Enabled = false; this.checkBox1.Checked = false; Application.DoEvents(); string max = this.txtMaxNumber.Text.Trim(); int pageSize = max == "" ? 1 : Convert.ToInt32(max); if (current > pageSize) { pageSize = current; } bool isEnd = false; for (int i = (current > 1 ? current : 1); i <= pageSize; i++) { if (this.checkBox1.Checked) { isEnd = true; break; } this.txtNumber.Text = i.ToString(); Application.DoEvents(); Result result = request.Request(i.ToString()); if (result.IsSuccess == false || string.IsNullOrWhiteSpace(result.Msg)) { isEnd = true; break; } this.txtResultList.Text = TxtHelper.ToTextContent(dt); Application.DoEvents(); } //开始搜索子页 if (!isEnd) { this.btnSearch.Text = "搜索子页..."; Application.DoEvents(); request.RequestSubPage((send, args) => { this.txtNumber.Text = args.Value.ToString(); Application.DoEvents(); }); this.txtResultList.Text = TxtHelper.ToTextContent(dt); Application.DoEvents(); } //还原 this.btnSearch.Text = "搜索"; this.btnSearch.Enabled = true; Application.DoEvents(); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(Content.Text) || Content.Text.Length < 10) { Alert("内容不能为空并且必须10个字以上!"); return; } XmlDocument doc = null; if (txtXml.Text.Length > 0) { string msg = null; doc = new XmlDocument(); try { doc.LoadXml(txtXml.Text); if (!XmlHelper.HasChildNode(doc.DocumentElement, "myquery") || !XmlHelper.HasChildNode(doc.DocumentElement, "myquery/sql")) { msg = "XML配置文件不符合系统规范"; } } catch (Exception ex) { msg = "xml语法错误:" + ex.Message; } if (!String.IsNullOrEmpty(msg)) { Alert(msg); return; } } bool isOk = false; MySqlParameters mySql = new MySqlParameters("HtmlTemplate"); if (String.IsNullOrEmpty(name)) { mySql.EditSqlMode = SqlMode.Insert; } else { mySql.EditSqlMode = SqlMode.Update; mySql.Add("whereHtmlUrl", name, "HtmlUrl={0}"); } string htmlUrl = HtmlUrl.Text; if (!htmlUrl.EndsWith(DepId.SelectedValue)) { htmlUrl += DepId.SelectedValue; } mySql.Add("HtmlUrl", htmlUrl); string aspxUrl = AspxUrl.Text; if (String.IsNullOrEmpty(aspxUrl)) { aspxUrl = HtmlGenerate.GetAspxUrl(htmlUrl); } mySql.Add("AspxUrl", aspxUrl); mySql.Add("Title", txtTitle.Text); mySql.Add("depid", DepId.SelectedValue); mySql.Add("optime", DateTime.Now); mySql.Add("userid", CurrentUser.Id); DataFrom data = new DataFrom(); try { data.SqlExecute(mySql); TxtHelper.WriteToFile(WebHelper.GetMyXmlPath() + "\\tpl\\" + name + Constants.HTML_SUFFIX, Content.Text, true); if (doc != null) { doc.Save(WebHelper.GetMyXmlPath() + "\\query\\" + name + Constants.XML_SUFFIX); } isOk = true; } catch (Exception ex) { Logger.Error(SqlHelper.GetSql(mySql, data.Dbtype), ex); RedirectError("提交失败,请稍候再试。原因:" + ex.Message); return; } if (isOk) { Redirect("Tmp/MyQuery.aspx?" + Constants.MYQUERY_NAME + "=listHtmlTemplate&sy=1"); } }