//导出表格
public ActionResult Export(int? projectid, string itemid, FormCollection collection)
{
int IsStandard = new ProjectDao().Find(projectid.Value).IsStandard;
Hashtable ht = new Hashtable();
ht["pid"] = projectid.Value;
ht["itemid"] = itemid;
IDictionary medicineinfo = (IsStandard == 1) ? StandardDataMapper.Get().QueryForObject<IDictionary>("CompareData.ListSingleName", itemid) : EmedEvaluationProjectMapper.Get().QueryForObject<IDictionary>("CompareDataProject.ListSingleName", ht);
if (collection.Count != 0 && collection["excel"] == "1")
{
ExcelExport mx = new ExcelExport();
mx.InitTh();
mx._fileName = medicineinfo["ChineseProductName"].ToString() + DateTime.Now.ToShortDateString() + ".xls";
//项目名称
TableItemStyle tiName = new TableItemStyle();
tiName.Font.Size = 14;
tiName.ForeColor = System.Drawing.Color.Red;
tiName.HorizontalAlign = HorizontalAlign.Center;
mx.HeadExtrInfo.Add("评价药品：" + medicineinfo["ChineseProductName"] + medicineinfo["Formulation"] + medicineinfo["ChineseSpecification"] + medicineinfo["ChineseManufactureName"], tiName);
//得到第二行表头名称
TableItemStyle tiSecondName = new TableItemStyle();
tiSecondName.Font.Size = 14;
tiSecondName.ForeColor = System.Drawing.Color.Black;
tiSecondName.HorizontalAlign = HorizontalAlign.Center;
mx.SecondExtrInfo.Add(collection["secondhead"], tiSecondName);
string[] spanlist = collection["spanlist"].Split(',');
string[] header = collection["header"].Split(',');
string[] bodycontent = collection["content"].Split('|');
List<Dictionary<string, string>> list = new List<Dictionary<string, string>>();
foreach (string bc in bodycontent)
{
string[] each = bc.Split('^');
Dictionary<string, string> contentdict = new Dictionary<string, string>();
int count = 0;
foreach (string e in each)
{
contentdict.Add(header[count], e);
count++;
}
list.Add(contentdict);
}
DataTable data = new DataTable();
data = ConvertTo(header, list);
mx.DataTableToExcelForSimulate(data, spanlist);
}
return View();
}
