/// <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");
}
}
