private string ExportStock()
{
try
{
var para = HttpContext.Current.Request.Params;
string EventId = FormatParamValue(para["eventId"]);
string searchSql = FormatParamValue(para["SearchOptionValue"]).Trim();
DataTable dataExport = new DataTable();
WEventUserMappingBLL wEventUserMappingBLL = new WEventUserMappingBLL(this.CurrentUserInfo);
QuesQuestionsBLL quesQuestionsBLL = new QuesQuestionsBLL(this.CurrentUserInfo);
dataExport = wEventUserMappingBLL.SearchEventUserList(EventId, searchSql).Tables[0];
//var service = new LEventSignUpBLL(loggingSessionInfo);
//GetResponseParams<LEventSignUpEntity> dataList = service.GetEventApplies(para["eventId"] ?? "", 0, 10000);
//IList<LEventSignUpEntity> data2 = new List<LEventSignUpEntity>();
int dataTotalCount = 0;
var data2 = dataExport.Rows;
dataTotalCount = dataExport.Rows.Count;
IList <List <string> > source = new List <List <string> >();
for (var i = 0; i < dataExport.Rows.Count; i++)
{
var tmpHt = new List <string>();
var dr = dataExport.Rows[i];
for (var c = 1; c < dataExport.Columns.Count; c++)
{
tmpHt.Add(dr[c] == null ? "" : dr[c].ToString());
}
source.Add(tmpHt);
}
if (source == null || source.Count == 0)
{
return(string.Empty);
}
var fileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + _random.Next(1, 100).ToString() + ".xls";
var full_path = ExportDir + fileName;
var sw = new FileStream(full_path, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite);
var Writer = new StreamWriter(sw, System.Text.Encoding.UTF8);
System.Collections.Generic.List <string> headers = new List <string>();
string[] header_nex = new string[] { };
for (var i = 1; i < dataExport.Columns.Count; i++)
{
var col = dataExport.Columns[i];
string colName = wEventUserMappingBLL.GetQuestionsDesc(EventId, col.ColumnName);
headers.Add(colName);
}
var data = source;
ExportHtmlExcel <List <string> >(Writer, headers.ToArray(), data, obj =>
{
return(obj);
}, null);
Writer.Close();
sw.Close();
return(fileName);
}
catch (Exception ex)
{
PageLog.Current.Write(ex);
return(null);
}
}
