public override void Run()
{
DataSet ds = db.ExecuteDataset("select * from AF_LOGIN_HIS", null);
string title = "测试标题";
string subject = @"E:\ASECode\Test\QM.git\QM.Excel\bin\Debug\1.xls";
QMExcel ex = new QMExcel(title, subject);
if (ex.Export(ds.Tables[0], title, subject, out error) == false)
{
throw new QMException(error);
}
}
/// <summary>
/// 导出excel
/// </summary>
public override void Run()
{
DataSet ds = QMDBHelper.ExecuteDataset(sql);
QMExcel ex = new QMExcel(title, filepath);
if (ex.Export(ds.Tables[0], title, filepath, out error) == false)
{
TaskLog log = new TaskLog();
log.message = error;
QMLog.Debug(log);
}
}
/// <summary>
/// 导出excel
/// </summary>
public void TryRun(string sendby = "MAIL")
{
try
{
IList <TasksN2M> m_parms = null;
m_parms = parms.Where(x => x.refname == "SQL").ToList();
header = m_parms.Where(x => x.attrname == "HEADER").FirstOrDefault().attrval;
inmail = parms.Where(x => x.refname == "MAIL" && x.attrname == "INMAIL").FirstOrDefault().attrval;
DataSet ds = db.ExecuteDataset(sql);
log.Debug(string.Format("[SqlExpJob] 导出文件{0},{1},{2},{3},{4}", title, filepath, filename + filedate, filetype, sql));
if (filetype == "TXT")
{
QMText txt = new QMText();
if (inmail == "X")
{
body = txt.Export(ds.Tables[0], header);
}
if (txt.Export(ds.Tables[0], header, filepath, out error) == false)
{
log.Fatal(string.Format("[SqlExpJob] 导出文件异常{0}", error));
//filepath = "";
}
else
{
log.Debug("[SqlExpJob] 导出成功");
}
}
else if (filetype == "CSV")
{
QMText txt = new QMText();
body = txt.Export(ds.Tables[0], header);
if (txt.ExportCSV(ds.Tables[0], header, filepath, out error) == false)
{
log.Fatal(string.Format("[SqlExpJob] 导出文件异常{0}", error));
//filepath = "";
}
else
{
log.Debug("[SqlExpJob] 导出成功");
}
}
else
{
IExcel ex = new QMExcel(title, filepath);
if (ex.Export(ds.Tables[0], title, filepath, out error) == false)
{
log.Fatal(string.Format("[SqlExpJob] 导出文件异常{0}", error));
//filepath = "";
}
else
{
log.Debug("[SqlExpJob] 导出成功");
}
}
foreach (var item in sendby.Split('+'))
{
switch (item)
{
case "MAIL":
try
{
IMail mail = new QMMail();
mail.AddAttachment(filepath);
m_parms = parms.Where(x => x.refname == "MAIL").ToList();
mail.Subject = m_parms.Where(x => x.attrname == "SUBJECT").FirstOrDefault().attrval +
DateTime.Now.ToString(m_parms.Where(x => x.attrname == "SUBDATE").FirstOrDefault().attrval);
mail.AddBody(m_parms.Where(x => x.attrname == "BODY").FirstOrDefault().attrval + body, reportid);
foreach (var parm in m_parms.Where(x => x.attrname == "TO" || x.attrname == "CC" || x.attrname == "BCC"))
{
switch (parm.attrname)
{
case "TO":
mail.AddRecipient(parm.attrval);
break;
case "CC":
mail.AddRecipientCC(parm.attrval);
break;
case "BCC":
mail.AddRecipientBCC(parm.attrval);
break;
}
}
if (mail.Send())
{
log.Debug("[MAIL] 发送成功");
}
else
{
log.Fatal("[MAIL] 发送失败");
throw new QMException("[MAIL] 发送失败");
}
}
catch (QMException ex)
{
log.Fatal(string.Format("[MAIL] 发送失败，{0}", ex.Message + ex.StackTrace));
throw ex;
}
catch (SystemException sex)
{
log.Fatal(string.Format("[MAIL] 发送失败，{0}", sex.Message + sex.StackTrace));
throw sex;
}
break;
case "FTP":
try
{
QMFtp ftp = new QMFtp();
m_parms = parms.Where(x => x.refname == "FTP").ToList();
ftp.server = m_parms.Where(x => x.attrname == "SERVER").FirstOrDefault().attrval;
ftp.user = m_parms.Where(x => x.attrname == "ACCOUNT").FirstOrDefault().attrval;
ftp.pass = m_parms.Where(x => x.attrname == "PASSWORD").FirstOrDefault().attrval;
string path = m_parms.Where(x => x.attrname == "RMOTEPATH").FirstOrDefault().attrval;
ftp.ChangeDir(path);
log.Debug("[FTP]目录切换成功");
if (ftp.OpenUpload(filepath, path + '/' + filename + filedate + '.' + filetype, false))
{
log.Debug(string.Format("[FTP]开始上传{0},{1}", filepath, path + '/' + filename + '.' + filetype));
long size = ftp.DoUpload();
log.Debug(string.Format("[FTP]文件大小:{0}", size));
}
else
{
log.Fatal("[FTP]上传失败");
}
ftp.Disconnect();
log.Debug("[FTP] 上传成功");
}
catch (QMException ex)
{
log.Fatal(string.Format("[FTP] 发送失败，{0}", ex.Message));
throw ex;
}
catch (SystemException sex)
{
log.Fatal(string.Format("[FTP] 发送失败，{0}", sex.Message + sex.StackTrace));
throw sex;
}
break;
case "SFTP":
break;
}
}
QMFile.Delete(filepath);
log.Debug("[SqlExpJob] 附件删除成功");
}
catch (QMException ex)
{
log.Fatal(string.Format("[SqlExpJob] 异常{0}", ex.Message));
throw ex;
}
catch (SystemException sex)
{
log.Fatal(string.Format("[SqlExpJob] 异常{0}", sex.Message));
throw sex;
}
finally
{
db.Disponse();
}
}