/// <summary>
/// SQL导出excel初始化
/// </summary>
/// <param name="dbstr">数据库连接字符串</param>
/// <param name="sqlstr">sql语句</param>
/// <param name="titlestr">excel内容表头</param>
/// <param name="filestr">文件路径/文件名</param>
public SqlJob(string dbstr, string sqlstr, string titlestr, string filestr)
{
dbcon = dbstr;
db = new QMDBHelper(dbstr);
sql = sqlstr;
title = titlestr;
filepath = filestr;
}
/// <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>
/// SQL导出excel初始化
/// </summary>
/// <param name="dbstr">数据库连接字符串</param>
/// <param name="sqlstr">sql语句</param>
/// <param name="titlestr">excel内容表头</param>
/// <param name="filestr">文件路径/文件名</param>
public SqlExpJob(string dbstr, string sqlstr, string repid, string titlestr, IList <TasksN2M> sparms)
{
parms = sparms;
dbcon = dbstr;
db = new QMDBHelper(dbstr);
sql = sqlstr;
title = sparms.FirstOrDefault(p => p.attrname == "SUBJECT").attrval;
filename = sparms.Where(x => x.attrname == "EXPFILE").FirstOrDefault().attrval;
filetype = sparms.Where(x => x.attrname == "EXPTYPE").FirstOrDefault().attrval;
filedate = DateTime.Now.ToString(sparms.Where(x => x.attrname == "EXPDATE").FirstOrDefault().attrval);
filepath = sparms.FirstOrDefault(p => p.attrname == "EXPPATH").attrval +
filename + filedate + "." + filetype;
QMFile.CreateDir(sparms.FirstOrDefault(p => p.attrname == "EXPPATH").attrval);
reportid = repid;
}
