public static string ExportData(string CpicIds, string ColNames, string NodeId, string type, string FileType) { try { SearchInterface.ClsSearch search = new SearchInterface.ClsSearch(); CpicIds = CpicIds.Replace(",undefined,", ","); List<int> listNo = CpicIds.Trim(',').Split(',').ToList<string>().ConvertAll<int>(x => Convert.ToInt32(x)); List<xmlDataInfo> listXml = search.GetResult(listNo, type.ToUpper()); string name = GlobalUtility.TimeRandomName() + "." + FileType; string strFileName = "/Images/Export/Patent" + name; string fullpath = System.Web.HttpContext.Current.Server.MapPath(strFileName); if (!Directory.Exists(Path.GetDirectoryName(fullpath))) { Directory.CreateDirectory(Path.GetDirectoryName(fullpath)); } ExcelLib.NPOIHelper eh = new ExcelLib.NPOIHelper(); fullpath = eh.DataTable2File(List2DataTable(listXml, ColNames, type, NodeId), fullpath, FileType); return name; } catch (Exception ex) { logger.Error(ex.ToString()); return ""; } }
public static string ExportData2(string type, string db, string id, string ColNames, string beginNum, string endNum, string strSort, string FileType) { try { int userid = Convert.ToInt32(System.Web.HttpContext.Current.Session["UserID"]); int bnum = Convert.ToInt32(beginNum) - 1; if (bnum < 0) bnum = 0; int endnum = Convert.ToInt32(endNum); int length = endnum - bnum; SearchInterface.ClsSearch search = new SearchInterface.ClsSearch(); List<string> strcolnames = ColNames.Split('|').ToList<string>(); List<int> listNo; List<int> fResult = new List<int>(); switch (type.ToUpper()) { case "FI": case "CN": case "EN": SearchPattern sp = new SearchPattern(); sp.SearchNo = id; sp.Pattern = ""; if (db.ToUpper() == "CN") { sp.DbType = SearchDbType.Cn; } else { sp.DbType = SearchDbType.DocDB; } sp.UserId = userid; ResultServices res = new ResultServices(); fResult = res.GetResultList(sp, ""); break; case "ZT": case "QY": fResult = ztHelper.GetResultList(id, db); break; case "CO": fResult = UserCollectsHelper.GetResultList(db, Convert.ToInt32(id)); break; case "YJ0": case "YJ1": fResult = ProYJDLL.YJDB.getYJItemByWID(Convert.ToInt32(id), Convert.ToInt16(type.Substring(2).ToString())); break; } listNo = fResult.Skip(bnum).Take(length).ToList<int>(); List<xmlDataInfo> listXml = search.GetResult(listNo, db.ToUpper()); string name = GlobalUtility.TimeRandomName() + "." + FileType; string strFileName = "/Images/Export/Patent" + name; string fullpath = System.Web.HttpContext.Current.Server.MapPath(strFileName); if (!Directory.Exists(Path.GetDirectoryName(fullpath))) { Directory.CreateDirectory(Path.GetDirectoryName(fullpath)); } ExcelLib.NPOIHelper eh = new ExcelLib.NPOIHelper(); fullpath = eh.DataTable2File(List2DataTable(listXml, ColNames, type, ""), fullpath, FileType); return name; } catch (Exception ex) { logger.Error(ex.ToString()); return ""; } }