/// <summary>
/// 执行读取到的SQL
/// </summary>
public static void ExeSql()
{
//while (true)
//{
//string path = "E:\\userfile\\";//Server.MapPath("userfile");
int i = 0;
while (i < 3)//如果执行3次失败的话就发送邮件
{
i++;
if (Directory.Exists(path))
{
string[] dir = Directory.GetFiles(path);
foreach (string name in dir)
{
string sql = ReadFile();//System.IO.File.ReadAllText(name, System.Text.Encoding.UTF8);
if (sql != "")
{
bool y = false;
//string str = "server=192.168.1.3;user id=consol;password=B2e5n14-;database=USGROUP_OPERATION_TEST;pooling=true;min pool size=3;max pool size=10;packet size=3072";
using (SqlConnection con = new SqlConnection(PageHelper.ConnectionStrings))
{
con.Open();
SqlCommand com = new SqlCommand(sql, con);
int x = com.ExecuteNonQuery();
if (x > 0)
{
y = true;
}
}
if (y)
{
RemoveFile(y);
getWork = null;
break;
}
else
{
if (i == 3)
{
RemoveFile(y);
//string email = "*****@*****.**"; //FSecurityHelper.CurrentUserDataGET()[3];// //Email 地址 FSecurityHelper.CurrentUserDataGET()[3]
//List<string> addEmail = new List<string>();
//foreach (string str in email.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries))
// addEmail.Add(str);
////MailHelper.sendMail("UserInfo modify failed", "<font color='red' size='1'>The mail sent by system, please do not reply.</font>", "*****@*****.**", addEmail, "*****@*****.**", null, "*****@*****.**", "zxcvbnm1.", false);
//if (System.IO.File.Exists(NewFile))//System.IO.File.Exists("E:\\userfile\\" + fileName)
//{
// //List<string> attachFile = new List<string>();
// //attachFile.Add(NewFile);
// //EmailInfo info = new EmailInfo();
// info.MailSubjct = "UPDATE USER : User information updated to HKG was failed.";
// info.MailBody = "<font color='red' size='1'>" + sql + "</font>";
// info.MailAddress = addEmail;
// info.Filename = null;
// //EmailInfo.AddEmailInfo(info);
//}
string email = "*****@*****.**"; //Email 地址 [email protected]
//List<string> addEmail = new List<string>();
//foreach (string str in email.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries))
// addEmail.Add(str);
//string[] fileStr = filePath.Split(new string[] { "/" }, StringSplitOptions.RemoveEmptyEntries);
//string attachFile = HttpContext.Current.Server.MapPath(filePath + ".rar");
//ZipApplication.ZipClass.Zip(HttpContext.Current.Server.MapPath(filePath), attachFile, null);
//Thread.Sleep(1000);
//DirectoryInfo di = new DirectoryInfo(HttpContext.Current.Server.MapPath(fileDire));
//var fileStr = di.GetFiles().OrderBy(p => p.Name);
//if (fileStr.Count() <= 0) return;
//count = fileStr.Count();
string FileNameList = "", FileDataList = "";
//foreach (FileInfo file in fileStr)
//{
// FileNameList += file.Name + "|";
// FileDataList += ConvertFile.ToBinary(file.FullName) + "|";
//}
//HttpContext.Current.Response.Write(FileDataList);
//FileNameList = FileNameList.TrimEnd(';');
//EmailInfo info = new EmailInfo();
//info.MailSubjct = "CONSOL-OP: LotNo# " + lotno;
//info.MailBody = "<font color='red' size='1'>The mail sent by system, please do not reply.</font>";
//info.MailAddress = addEmail;
//info.Filename = attachFile;
//EmailInfo.AddEmailInfo(info);
string mailSubjct = "UPDATE USER : User information updated to HKG was failed.";
string mailBody = "<font color='red' size='1'>" + sql + "</font>";
try
{
//string cmdText = "insert into EmailInfo (MailSubjct, MailBody, MailAddress, FileName,MailTime,MailStatus) values ('" + mailSubjct + "','" + mailBody + "','" + email + "','" + FileNameList + "',GETDATE(),0)";
//SqlConnection con = new SqlConnection(PageHelper.ConnectionStrings);
//con.Open();
//SqlCommand cmd = new SqlCommand(cmdText, con);
//int num = cmd.ExecuteNonQuery();
//con.Close();
//EmailInfo e = new EmailInfo();
//int j = 0;
//string msg = "1";
//while (msg !="" && j !=3)
//{
// j++;
// Dictionary<string, string> data = new Dictionary<string, string>();
// data.Add("action", "sendmail"); //当前执行动作
// data.Add("body", mailBody); //邮件内容
// data.Add("subject", mailSubjct); //邮件主题
// data.Add("Address", email); // 邮件地址，多个地址用分隔符隔开
// data.Add("strFiles", FileDataList); //邮件附件，多个附件用分隔符隔开（此处不是文件地址，是将文件转化为二进制流并序列化为64位字符串）
// data.Add("fileName", FileNameList);//附件的文件名称，多个附件名用分隔符隔开（与附件个数一致）
// data.Add("separator", "|"); //分隔符
// data.Add("user", currentUserName); //执行发送邮件的用户
// msg = ExecRequest.call(data, "http://localhost:4880/Handler.ashx");
//}
EmailInfo e = new EmailInfo();
e.StartSendEmail(mailBody, mailSubjct, email, FileDataList, FileNameList, currentUserName);
}
catch (Exception)
{
}
}
//for (int i = 0; i < 3; i++)
//{
// ExeSql();
//}
}
}
}
//Thread.Sleep(10 * 1000);
//System.Threading.CancellationTokenSource cts = new CancellationTokenSource();
}
}
//ReloadDate();
}
