/// <summary>
/// 根据查询寻,将查到的数据导出为Excel
/// </summary>
/// <param name="sqlText">查询语句</param>
/// <param name="savePath">保存路径</param>
/// <returns>成功返回文件相对路径信息,失败返回空字符串</returns>
public static string GetExcel(string sqlText, string savePath)
{
File.Delete(savePath);
string strSql = string.Format(
"EXEC master..xp_cmdshell 'bcp \"{0}\" queryout {1} -c -S{2} -U{3} -P{4}'",
sqlText,
savePath,
Manager.servername,
Manager.dbuser,
Manager.dbpassword
);
string strError = "";
if (CommonDB.SqlExecInt(strSql.ToString(), ref strError) != 0)
{
return savePath ;
}
return "";
}