private async Task <string> _ValidateRunAsync(int i)
{
var file = this.Files.ElementAtOrDefault(i);
// Write Log
string t = FormatCli.H2($"Task: { (i + 1).ToString() }");
t += FormatCli.KeyValue("File", file.File);
t += FormatCli.KeyValue("Checksum", file.Checksum);
//Checks
var path = DirFile.Combine(this.AppSettings.Path.Export, file.File);
if (!System.IO.File.Exists(path))
{
t += Environment.NewLine;
t += $"Error: Could not find file {path}";
return(t);
}
var checksum = await Task.Run(() => FilesModel.Hash(path));
if (checksum != file.Checksum)
{
t += Environment.NewLine;
t += $"Error: Checksum is not identical, backup maybe corrupted!";
return(t);
}
t += FormatCli.KeyValue("Status", "Valid!");
return(t);
}
private void MESMainForm_FormClosed(object sender, FormClosedEventArgs e)
{
//备份配置文件
var sourceFilePath = "F:\\StationConfig";
var destFilePath = "F:\\StationConfigBackUp\\";
var isAutoBackup = ConfigurationManager.AppSettings["IsStationConfigAutoBackup"].ToString();
if (isAutoBackup != "true")
{
return;
}
if (!Directory.Exists(sourceFilePath))
{
return;
}
if (Directory.Exists(destFilePath))
{
Directory.Delete(destFilePath, true);
if (!Directory.Exists(destFilePath))
{
Directory.CreateDirectory(destFilePath);
}
}
DirFile.CopyFolder(sourceFilePath, destFilePath);
}
private static void SaveContentFile(string TxtStr, string fileName, string Edcode)
{
string str = BetDetailDAL.Folder + fileName;
Encoding encoding = Encoding.Default;
switch (Edcode)
{
case "3":
encoding = Encoding.Unicode;
break;
case "2":
encoding = Encoding.UTF8;
break;
case "1":
encoding = Encoding.GetEncoding("GB2312");
break;
}
DirFile.CreateFolder(DirFile.GetFolderPath(false, str));
StreamWriter streamWriter = new StreamWriter(str, false, encoding);
streamWriter.Write(TxtStr);
streamWriter.Close();
}
private string _ImportParams(int i)
{
var file = this.Files.ElementAtOrDefault(i);
// Write Log
string t = FormatCli.H2($"Task: { (i + 1).ToString() }");
t += FormatCli.KeyValue("File", file.File);
t += FormatCli.KeyValue("Checksum", file.Checksum);
//Checks
var path = DirFile.Combine(this.AppSettings.Path.Export, file.File);
if (!System.IO.File.Exists(path))
{
t += Environment.NewLine;
t += $"Error: Could not find file {path}";
return(t);
}
this.Import.File = path;
t += FormatCli.H3("Parameter");
var connector = this.Import.Config.Format == "p" ? new Connectors.Psql(AppSettings).BinName : this.Import.BinName;
t += $"{ connector } { this.Import.GetPatameters(this.Connect) }" + Environment.NewLine;
return(t);
}
protected void SaveCacheFile(string CacheStr, string OutFile, string Edcode)
{
Encoding encoding = Encoding.Default;
switch (Edcode)
{
case "3":
encoding = Encoding.Unicode;
break;
case "2":
encoding = Encoding.UTF8;
break;
case "1":
encoding = Encoding.GetEncoding("GB2312");
break;
}
DirFile.CreateFolder(DirFile.GetFolderPath(false, OutFile));
try
{
StreamWriter streamWriter = new StreamWriter(OutFile, false, encoding);
streamWriter.Write(CacheStr);
streamWriter.Close();
}
catch (Exception ex)
{
throw ex;
}
}
protected void SaveJsFile(string TxtStr, string TxtFile, string Edcode)
{
Encoding encoding = Encoding.Default;
if (Edcode != null)
{
if (!(Edcode == "1"))
{
if (!(Edcode == "2"))
{
if (Edcode == "3")
{
encoding = Encoding.Unicode;
}
}
else
{
encoding = Encoding.UTF8;
}
}
else
{
encoding = Encoding.GetEncoding("GB2312");
}
}
DirFile.CreateFolder(DirFile.GetFolderPath(false, TxtFile));
StreamWriter streamWriter = new StreamWriter(TxtFile, false, encoding);
streamWriter.Write(TxtStr);
streamWriter.Close();
}
/// <summary>
/// 保存不确定度
/// </summary>
/// <param name="HTMLVALUE">html</param>
/// <param name="URL">不确定计算存储地址</param>
/// <returns></returns>
public ActionResult JiSuanBuQueDingDuSave(string HTMLVALUE = "", string URL = "")
{
Common.ClientResult.Result result = new Common.ClientResult.Result();
try
{
URL = GetBuQueDingDuUrl(URL);
if (DirFile.FileExists(URL))
{
DirFile.DeleteFile(URL);
}
HTMLVALUE = Server.UrlDecode(HTMLVALUE); //解码
DirFile.SaveFile(HTMLVALUE, URL);
LogClassModels.WriteServiceLog(Suggestion.InsertSucceed + Url, "不确定度计算"); //写入日志
result.Code = Common.ClientCode.Succeed;
result.Message = URL;
return(Json(result)); //提示创建成功
}
catch (Exception ex)
{
LogClassModels.WriteServiceLog(Suggestion.InsertFail + Url + ":" + ex.Message, "不确定度计算");//写入日志
result.Code = Common.ClientCode.Fail;
result.Message = Suggestion.InsertFail + ex.Message;
return(Json(result)); //提示插入失败
}
}
private void btnBackup_Click(object sender, EventArgs e)
{
try
{
DirFile.CreateDir("Backup");
//备份文件
string[] strFileName = DirFile.GetFileNames(AppDomain.CurrentDomain.BaseDirectory.ToString());
for (int i = 0; i < strFileName.Length; i++)
{
strFileName[i] = Path.GetFileName(strFileName[i].ToString());
string strTempPath = AppDomain.CurrentDomain.BaseDirectory.ToString() + "Backup" + @"\" + strFileName[i];
DirFile.CopyFile(strFileName[i].ToString(), strTempPath);
}
//备份文件夹
string[] strFolderlist = DirFile.GetFolderNames(AppDomain.CurrentDomain.BaseDirectory.ToString());
string[] strFolderName = new string[strFolderlist.Length];
for (int i = 0; i < strFolderlist.Length; i++)
{
strFolderName[i] = Path.GetFileName(strFolderlist[i]);
if (strFolderName[i] != "Backup" & strFolderName[i] != "temp")
{
DirFile.CopyFolder(strFolderlist[i], AppDomain.CurrentDomain.BaseDirectory.ToString() + "Backup" + @"\" + strFolderName[i]);
}
}
MessageBox.Show("备份完毕！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void Create(int loid)
{
string text = ConfigurationManager.AppSettings["DataUrl"].ToString();
using (DbOperHandler dbOperHandler = new ComData().Doh())
{
dbOperHandler.Reset();
dbOperHandler.SqlCmd = "SELECT top 1 [Title],[Number] FROM [Sys_LotteryData] where Type=" + loid + " order by Title desc";
DataTable dataTable = dbOperHandler.GetDataTable();
string text2 = "{\"title\": \"期号\",\"number\": \"号码\"}";
if (dataTable.Rows.Count > 0)
{
text2 = text2.Replace("期号", dataTable.Rows[0]["Title"].ToString()).Replace("号码", dataTable.Rows[0]["Number"].ToString());
}
else
{
text2 = text2.Replace("期号", "").Replace("号码", "");
}
dataTable.Clear();
dataTable.Dispose();
string text3 = string.Concat(new object[]
{
text,
"EMindexData",
loid,
".json"
});
DirFile.CreateFolder(DirFile.GetFolderPath(false, text3));
StreamWriter streamWriter = new StreamWriter(text3, false, Encoding.UTF8);
streamWriter.Write(text2);
streamWriter.Close();
}
}
public static void SetOpenListJson(int lotteryId)
{
string value = "";
string value2 = "";
new LotteryDataDAL().GetListJSON(lotteryId, ref value2, ref value);
string text = ConfigurationManager.AppSettings["DataUrl"].ToString();
string text2 = string.Concat(new object[]
{
text,
"OpenList",
lotteryId,
".xml"
});
DirFile.CreateFolder(DirFile.GetFolderPath(false, text2));
StreamWriter streamWriter = new StreamWriter(text2, false, Encoding.UTF8);
streamWriter.Write(value2);
streamWriter.Close();
string text3 = string.Concat(new object[]
{
text,
"lottery",
lotteryId,
".xml"
});
DirFile.CreateFolder(DirFile.GetFolderPath(false, text3));
StreamWriter streamWriter2 = new StreamWriter(text3, false, Encoding.UTF8);
streamWriter2.Write(value);
streamWriter2.Close();
}
/// <summary>
/// 存储彩票数据到磁盘
/// </summary>
/// <param name="lotteryId">彩票类型Id</param>
public static void SaveLotteryData2File(int lotteryId)
{
try
{
//获取json和xml字符串
string xmlData = "";
string jsonData = "";
new LotteryDataDAL().ConvertLotteryDataToStr(lotteryId, ref jsonData, ref xmlData);
//保存json字符串到文件
string path = ConfigurationManager.AppSettings["DataUrl"].ToString();
string openListFile = string.Format("{0}OpenList{1}.xml", path, lotteryId);
DirFile.CreateFolder(DirFile.GetFolderPath(false, openListFile));
StreamWriter streamWriter = new StreamWriter(openListFile, false, Encoding.UTF8);
streamWriter.Write(jsonData);
streamWriter.Close();
//保存xml字符串到文件
string lotteryFile = string.Format("{0}lottery{1}.xml", path, lotteryId);
DirFile.CreateFolder(DirFile.GetFolderPath(false, lotteryFile));
StreamWriter streamWriter2 = new StreamWriter(lotteryFile, false, Encoding.UTF8);
streamWriter2.Write(xmlData);
streamWriter2.Close();
}
catch (Exception ex)
{
Log.ErrorFormat("采集异常 {0}", ex);
}
}
public static void SetOpenListJson(int lotteryId)
{
try
{
//LogHelp.Debug("SetOpenListJson", "1[" + lotteryId + "]");
string value = "";
string value2 = "";
new LotteryDataDAL().GetListJSON(lotteryId, ref value2, ref value);
string path = ConfigurationManager.AppSettings["DataUrl"].ToString();
string openListFile = string.Format("{0}OpenList{1}.xml", path, lotteryId);
//LogHelp.Debug("SetOpenListJson", "text2[" + text2 + "]");
DirFile.CreateFolder(DirFile.GetFolderPath(false, openListFile));
StreamWriter streamWriter = new StreamWriter(openListFile, false, Encoding.UTF8);
streamWriter.Write(value2);
streamWriter.Close();
string lotteryFile = string.Format("{0}lottery{1}.xml", path, lotteryId);
//LogHelp.Debug("SetOpenListJson", "text3[" + text3 + "]");
DirFile.CreateFolder(DirFile.GetFolderPath(false, lotteryFile));
StreamWriter streamWriter2 = new StreamWriter(lotteryFile, false, Encoding.UTF8);
streamWriter2.Write(value);
streamWriter2.Close();
//LogHelp.Debug("SetOpenListJson", "完成[" + lotteryId + "]");
}
catch (Exception ex)
{
Log.ErrorFormat("采集异常 {0}", ex);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void filePhoto_FileSelected(object sender, EventArgs e)
{
if (filePhoto.HasFile)
{
var fileSuffix = filePhoto.ShortFileName.Substring(filePhoto.ShortFileName.LastIndexOf('.'));
var sequence = SequenceService.CreateSequence("LH", CurrentUser.AccountComId);
var fileName = sequence + fileSuffix;
var uploadpath = Config.GetUploadpath();
var tempPath = (string.Format(@"{0}/temp/{1}/", uploadpath, DateTime.Now.ToString("yyyy-MM-dd"))); //
if (!DirFile.XFileExists(Server.MapPath(tempPath)))
{
DirFile.XCreateDir(Server.MapPath(tempPath));
}
filePhoto.SaveAs(Server.MapPath(tempPath + fileName));
hfdImage.Text = tempPath + fileName;
// 清空文件上传组件
filePhoto.Reset();
}
}
protected void SaveCssFile(string TxtStr, string TxtFile, string Edcode)
{
Encoding encoding = Encoding.Default;
if (Edcode != null)
{
if (!(Edcode == "3"))
{
if (!(Edcode == "2"))
{
if (Edcode == "1")
{
encoding = Encoding.GetEncoding("GB2312");
}
}
else
{
encoding = Encoding.UTF8;
}
}
else
{
encoding = Encoding.Unicode;
}
}
DirFile.CreateFolder(DirFile.GetFolderPath(false, TxtFile));
StreamWriter streamWriter = new StreamWriter(TxtFile, false, encoding);
streamWriter.Write("/*本文件由系统于 " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " 自动生成,请勿手动修改*/\r\n" + TxtStr);
streamWriter.Close();
}
private static void SaveContentFile(string TxtStr, string fileName, string Edcode)
{
string text = BetDetailDAL.Folder + fileName;
Encoding encoding = Encoding.Default;
if (Edcode != null)
{
if (!(Edcode == "3"))
{
if (!(Edcode == "2"))
{
if (Edcode == "1")
{
encoding = Encoding.GetEncoding("GB2312");
}
}
else
{
encoding = Encoding.UTF8;
}
}
else
{
encoding = Encoding.Unicode;
}
}
DirFile.CreateFolder(DirFile.GetFolderPath(false, text));
StreamWriter streamWriter = new StreamWriter(text, false, encoding);
streamWriter.Write(TxtStr);
streamWriter.Close();
}
//ask for file
//encrypt and decrypt
//load de/encrypted files
//Break each sentence and restruct
static void Main(string[] args)
{
DirFile dirFile = new DirFile();
Cipher cipher = new Cipher(dirFile.MainFile);
cipher.ShowMenu();
}
public ActionResult UpdateWebSiteSub(WebSiteModel model)
{
WebSiteOperation uo = new WebSiteOperation();
uo.Update(model);
DirFile.CreateDirectory(model.Path);
return(JavaScript("pagesub();"));
}
public int save(keJian objkeJian)
{
objkeJian.cont = DirFile.WriteInFileStream(objkeJian.cont, objkeJian.curl);
int result = new BLL.root.keJianBLL().save(objkeJian);
//if (result != 0 && objkeJian.curl != "0")
// DirFile.DeleteFile(objkeJian.curl);
return(result);
}
private static readonly Regex TABLE_REGEX = new Regex("[\\n,\\r, ,\\t]from[ ]+(?<tableName>[^ ,\\n,;]+)"); //TODO: Fix to accept after comma
public ProcedureParseReport Parse(DirFile file)
{
string name = GetName(file.Content);
if (name != null)
{
return(new ProcedureParseReport(name, GetProcedures(file.Content), GetTables(file.Content)));
}
return(null);
}
/// <summary>
/// List all job JSON files in Env.Path.jobs
/// </summary>
/// <param name="path">Path</param>
/// <returns>List of jobs</returns>
public static IEnumerable <string> JobsList(string path)
{
var res = DirFile.ListFiles(path, "*.json");
if (res == null)
{
return(new string[] { });
}
return(res);
}
public static void SetOpenListJson(int lotteryId, string expect, string opencode, string opentime, string realget)
{
string str1 = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" + "<xml rows=\"1\" code=\"ssc\" remain=\"1hrs\">" + "<row expect=\"" + expect + "\" opencode=\"" + opencode + "\" opentime=\"" + opentime + "\" realget=\"" + realget + "\"/>" + "</xml>";
string str2 = ConfigurationManager.AppSettings["DataUrl"].ToString() + "lottery" + (object)lotteryId + ".xml";
DirFile.CreateFolder(DirFile.GetFolderPath(false, str2));
StreamWriter streamWriter = new StreamWriter(str2, false, Encoding.UTF8);
streamWriter.Write(str1);
streamWriter.Close();
}
public JsonResult getentity(int id)
{
keJian objkeJian = new BLL.root.keJianBLL().getEntity(id);
if (objkeJian.curl.Length > 0)
{
objkeJian.curl = objkeJian.cont;
objkeJian.cont = DirFile.ReaderInFileStream(objkeJian.cont);
}
return(Json(objkeJian, JsonRequestBehavior.AllowGet));
}
public DatabaseParseReport Parse(DirFile file)
{
DatabaseParseReport databaseReport = null;
if (file.Extension == "cs")
{
databaseReport = new DatabaseParseReport(GetTables(file.Content));
}
return(databaseReport);
}
public void DirFileTest()
{
DirFile model = new DirFile()
{
docid = "docid",
name = "name",
rev = "rev",
editor = "editor",
creator = "creator",
size = 1,
duedate = 1,
attr = 1,
client_mtime = 1,
create_time = 1,
csflevel = 1,
modified = 1
};
var docid = model.docid;
var name = model.name;
var rev = model.rev;
var editor = model.editor;
var creator = model.creator;
var size = model.size;
var duedate = model.duedate;
var attr = model.attr;
var client_mtime = model.client_mtime;
var create_time = model.create_time;
var csflevel = model.csflevel;
var modified = model.modified;
Assert.IsTrue(docid == "docid");
Assert.IsTrue(name == "name");
Assert.IsTrue(rev == "rev");
Assert.IsTrue(editor == "editor");
Assert.IsTrue(creator == "creator");
Assert.IsTrue(size == 1);
Assert.IsTrue(duedate == 1);
Assert.IsTrue(attr == 1);
Assert.IsTrue(client_mtime == 1);
Assert.IsTrue(create_time == 1);
Assert.IsTrue(csflevel == 1);
Assert.IsTrue(modified == 1);
DocLibModel docLibModel = new DocLibModel()
{
dirs = new DirFile[] { model },
files = new DirFile[] { model }
};
var dirs = docLibModel.dirs;
var files = docLibModel.files;
Assert.IsTrue(dirs.Length == 1);
Assert.IsTrue(files.Length == 1);
}
public int Del(string curl, int id)
{
int result = new BLL.root.keJianBLL().Del(id);
if (result != 0 && curl.Length != 0)
{
DirFile.DeleteFile(curl);
DirFile.DeleteFiles(curl);
}
return(result);
}
public static void SetUserJson(string UserId, string title, string content)
{
string str1 = "[{\"userid\":\"" + UserId + "\",\"title\":\"" + title + "\",\"content\":\"" + content + "\"}]";
string str2 = ConfigurationManager.AppSettings["DataUrl"].ToString() + "User\\User" + UserId + ".xml";
DirFile.CreateFolder(DirFile.GetFolderPath(false, str2));
StreamWriter streamWriter = new StreamWriter(str2, false, Encoding.UTF8);
streamWriter.Write(str1);
streamWriter.Close();
}
private void btnUpload_Click(object sender, EventArgs e)
{
string[] strfilename = DirFile.GetFileNames(txtFolderPath.Text);
string[] strfoldername = DirFile.GetFolderNames(txtFolderPath.Text);
FTPHelper ftp = new FTPHelper(txtFTPPath.Text, "", txtFTPUser.Text, txtFTPPassword.Text);
ftp.Uploadfolder(txtFTPPath.Text, txtFolderPath.Text);
for (int i = 0; i < strfilename.Length; i++)
{
ftp.Upload(txtFTPPath.Text, strfilename[i]);
}
}
public ActionResult InsertWebSiteSub(WebSiteModel u)
{
WebSiteOperation uo = new WebSiteOperation();
u.CreateTime = DateTime.Now;
uo.Insert(u);
DirFile.CreateDirectory(u.Path);
return(JavaScript("pagesub();"));
}
public ActionResult GetFiles(string path)
{
string[] str = DirFile.GetFileNames(path);
StringBuilder sb = new StringBuilder();
foreach (string s in str)
{
sb.Append(s + "<br></br>");
}
return(Content(sb.ToString()));
}
protected void fileUpload1_FileSelected(object sender, EventArgs e)
{
if (fileUpload1.HasFile)
{
var fileSuffix = fileUpload1.ShortFileName.Substring(fileUpload1.ShortFileName.LastIndexOf('.'));
var sequence = SequenceService.CreateSequence("LH", CurrentUser.AccountComId);
var fileName = sequence + fileSuffix;
var uploadpath = Config.GetUploadpath();
//该目录设定死，最好不要修改
var fileTemp = (string.Format(@"{0}/temp/{1}/", uploadpath, DateTime.Now.ToString("yyyy-MM-dd"))); //
if (!DirFile.XFileExists(Server.MapPath(fileTemp)))
{
DirFile.XCreateDir(Server.MapPath(fileTemp));
}
var address = fileTemp + fileName;
fileUpload1.SaveAs(Server.MapPath(address));
//导入
var connStr = string.Empty;//数据连接字符串
if (fileSuffix == ".xls")
{
connStr = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + Server.MapPath(address) + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
}
else if (fileSuffix == ".xlsx")
{
connStr = "Provider=Microsoft.ACE.OleDb.12.0;" + "data source=" + Server.MapPath(address) + ";Extended Properties='Excel 12.0; HDR=YES; IMEX=1'";
}
var conn = new OleDbConnection(connStr);
conn.Open();
var data = new DataTable();
const string cmdSql = "select * from [Sheet1$]";
var da = new OleDbDataAdapter(cmdSql, conn);
da.Fill(data);
ViewState["dtData"] = data;
Grid1.DataSource = data;
Grid1.DataBind();
Grid1.Visible = true;
fileUpload1.Reset();
}
}
/// Return a list of files & Directories from the file system.
public void GetDirList(DirList dl)
{
Socket cSocket;
int bytes;
char seperator = Convert.ToChar("\n");
string[] mess;
m_sMes = "";
/// Check to see if you are logged on to the FTP server.
if (!m_bLoggedIn)
{
Login();
}
cSocket = CreateDataSocket();
/// Send an FTP command.
SendCommand("LIST -AL");
if (!(m_iRetValue == 150 || m_iRetValue == 125))
{
MessageString = m_sReply;
throw new IOException(m_sReply.Substring(4));
}
m_sMes = "";
while (true)
{
Array.Clear(m_aBuffer, 0, m_aBuffer.Length);
bytes = cSocket.Receive(m_aBuffer, m_aBuffer.Length, 0);
m_sMes += ASCII.GetString(m_aBuffer, 0, bytes);
if (bytes < m_aBuffer.Length)
{
break;
}
System.Threading.Thread.Sleep(10);
}
mess = m_sMes.Split(seperator);
cSocket.Close();
ReadReply();
if (m_iRetValue != 226)
{
MessageString = m_sReply;
throw new IOException(m_sReply.Substring(4));
}
if (mess.Length > 0)
{
foreach (string tmpstr in mess)
{
if (tmpstr != "")
{
DirFile lf;
SplitLine sl = ParseLine(tmpstr);
if (sl.Valid)
{
if (sl.Dir)
{
lf = new DirFile(sl.FileName, sl.FileDate, sl.FileTime, true, 0);
}
else
{
lf = new DirFile(sl.FileName, sl.FileDate, sl.FileTime, false, sl.FileSize);
}
dl.Add(lf);
}
}
}
}
}
// Method to Remove a specific DirFile object from our collection.
public void Remove(DirFile value)
{
this.InnerList.Remove(value);
}
// Method to add a single DirFile object to our collection.
public int Add(DirFile value)
{
return this.InnerList.Add(value);
}
// Method to check if a DirFile object already exists in the collection.
public bool Contains(DirFile value)
{
return this.Contains(value);
}
