/// <summary>
/// 获取本地存储地址
/// </summary>
/// <param name="dt"></param>
/// <param name="prefix">前缀类别</param>
/// <returns></returns>
public string GetDwonLoadlPath(DataTable dt, string prefix)
{
string filename = System.Configuration.ConfigurationManager.AppSettings[prefix].ToString() + Guid.NewGuid() + ".xlsx";
string filePath = System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath + "\\File\\Download\\" + filename;
string returnpath = System.Web.Hosting.HostingEnvironment.ApplicationVirtualPath + "/File/Download/" + filename;
ExcelHelper.DataTableToExcel(dt, filePath);
return System.Configuration.ConfigurationManager.AppSettings["DomainName"] + returnpath;
}
public class DrugParamsHelper
{
private static volatile DrugParamsHelper drugParamsHelper = null;
private static object syncRoot = new Object();
public DrugParamsHelper()
{ }
/// <summary>
/// 初始化注册
/// </summary>
public static DrugParamsHelper Instance
{
get
{
if (drugParamsHelper == null)
{
lock (syncRoot)
{
if (drugParamsHelper == null)
{
if (true)
{
}
drugParamsHelper = new DrugParamsHelper();
}
}
}
return drugParamsHelper;
}
}
/// <summary>
/// 获取本地存储地址
/// </summary>
/// <param name="dt"></param>
/// <param name="prefix">前缀类别</param>
/// <returns></returns>
public string GetDwonLoadlPath(DataTable dt, string prefix)
{
string filename = System.Configuration.ConfigurationManager.AppSettings[prefix].ToString() + Guid.NewGuid() + ".xlsx";
string filePath = System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath + "\\File\\Download\\" + filename;
string returnpath = System.Web.Hosting.HostingEnvironment.ApplicationVirtualPath + "/File/Download/" + filename;
ExcelHelper.DataTableToExcel(dt, filePath);
return System.Configuration.ConfigurationManager.AppSettings["DomainName"] + returnpath;
}}
调用示例
//转换列名称成中文名
Dictionary<string, string> RenameColumDic = new Dictionary<string, string>();
queryParams.colCollection.ForEach(f =>
{
RenameColumDic.Add(f.FieldName, f.DisplayName);
});
//将对象转成datatble
DataTable dataTable = ListTranDataTableHelper.ToDataTable<ClinicalRegistrationCach>(list, RenameColumDic, queryParams.colCollection.Select(c => c.FieldName).ToArray());
return new Response<string>(DrugParamsHelper.Instance.GetDwonLoadlPath(dataTable, "CDEExclsName"));