public void GetUrl()
{
Assert.AreEqual("[[wikiuk:Хронологія історії України]]", ExcelManager.GetUrl("Вікіпедія.Хронологія історії України"));
Assert.AreEqual(
"[[wikiru:Генуэзские колонии в Северном Причерноморье]]",
ExcelManager.GetUrl("Википедия.Генуэзские колонии в Северном Причерноморье"));
}
public void Read()
{
var man = new ExcelManager(Path.Combine("Mw/Excel/Tests", "Крым реконструкция.xls"));
man.Read();
Assert.AreEqual(377, man.Sheet.PhysicalNumberOfRows);
}
/// <summary>
/// 作用：下载项目洽谈表格
/// 作者：汪建龙
/// 编写时间：2017年1月16日19:53:26
/// </summary>
/// <param name="name"></param>
/// <param name="otherside"></param>
/// <param name="minmoney"></param>
/// <param name="maxmoney"></param>
/// <param name="number"></param>
/// <param name="year"></param>
/// <param name="city"></param>
/// <param name="town"></param>
/// <param name="projecttype"></param>
/// <param name="state"></param>
/// <param name="payCompany"></param>
/// <returns></returns>
public ActionResult DownloadArticle(
string name = null, string otherside = null, double?minmoney = null, double?maxmoney = null,
string number = null, string year = null, string city = null, string town = null,
string projecttype = null, string state = null, string payCompany = null)
{
var parameter = new ArticleParameter
{
Name = name,
OtherSide = otherside,
MinMoney = minmoney,
MaxMoney = maxmoney,
Number = number,
Year = year,
City = city,
Town = town,
ProjectType = projecttype,
PayCompany = payCompany
};
if (!string.IsNullOrEmpty(state))
{
parameter.State = EnumHelper.GetEnum <ArticleState>(state);
}
var list = Core.ArticleManager.Search2(parameter);
var workbook = ExcelManager.DownloadArticleWorkbook(list);
if (workbook != null)
{
byte[] fileContents = ExcelManager.Translate(workbook);
return(File(fileContents, "application/ms-excel", string.Format("项目洽谈统计表-{0}.xls", DateTime.Now.ToLongDateString())));
}
return(Content("内部服务器错误！"));
}
private void btnWriteHierarchyToExcel_Click(object sender, EventArgs e)
{
try
{
ExcelManager excelManager = new ExcelManager();
//method to read energy plus error message from files and generate excel file for the error messages
Func <Files, bool> exclusionFilter = (Files f) => (f.hasChildren && (f.name.ToLower() == "bin" ||
f.name.ToLower() == "obj" ||
f.name.ToLower() == "properties" ||
f.name.ToLower() == ".vs" ||
f.name.ToLower() == "mymodules" ||
f.name.ToLower() == "prebuild_keepthisfirstinbuildorder" ||
f.name.ToLower() == "samplecode" ||
f.name.ToLower() == "thirdpartylibraries" ||
f.name.ToLower() == "packages" ||
f.name.ToLower() == "tests" ||
f.name.ToLower() == "templates" ||
f.name.ToLower() == "help" ||
f.name.ToLower() == "images" ||
f.name.ToLower() == "geomlibtests"
));
excelManager.ExportDirectoryHierarchy(txtDirectoryPath.Text, txtExportPath.Text, exclusionFilter);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public ActionResult importUser(HttpPostedFileBase file1)
{
if (file1 == null)
{
return(Content("0"));
}
try
{
var path = Server.MapPath("~/Files/") + file1.FileName;
file1.SaveAs(path);
ExcelManager ex = new ExcelManager();
DataSet ds = ex.Excel(path, "Sheet1");
var dt = ds.Tables[0];
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("State", typeof(int));
dt.Columns["ID"].SetOrdinal(0);
DataBase db = new DataBase();
db.Bulk("ConstructionPersonnelTable", dt);
}
catch (Exception)
{
return(Content("-1"));
}
return(Content("1"));
}
protected override Graphes GroupEventsByYear(ExcelManager man, Dictionary <string, string> legends = null, bool twoAndMoreEventtypes = false)
{
var result = new Graphes(legends, twoAndMoreEventtypes);
foreach (HSSFRow row in man.Records)
{
for (int colGroup = 0; colGroup < 12; colGroup++)
{
var i = colGroup * 2;
if (row.RowNum >= 3058 && colGroup >= 11 ||
row.RowNum >= 6663 && colGroup >= 10 ||
row.RowNum >= 8563 && colGroup >= 9 ||
row.RowNum >= 19683 && colGroup >= 8 ||
row.RowNum >= 25229 && colGroup >= 7 ||
row.RowNum >= 37180 && colGroup >= 6 ||
row.RowNum >= 45344 && colGroup >= 5 ||
row.RowNum >= 54304 && colGroup >= 4
)
{
}
else
{
var year = (int)row.Cells[i].NumericCellValue;
var index = row.Cells[i + 1].ToString();
result.Add(year, index);
}
}
}
return(result);
}
public override void ExecuteCommand(CancellationToken token)
{
Action <string> ok = new Action <string>(result =>
{
int numRows = 0;
if (!int.TryParse(result, out numRows))
{
ShellManager.ShowMessageBox("Please input a valid number");
return;
}
numRows = Math.Max(numRows, 0);
var selectedQuery = ShellManager.GetSelectedText();
QueryManager.Run(ConnectionManager.GetConnectionStringForCurrentWindow(), token, (queryManager) =>
{
var ds = new DataSet();
FileInfo file = DialogManager.ShowExcelSaveFileDialog();
if (file == null)
{
return;
}
queryManager.Fill(selectedQuery, ds);
ExcelManager.TableToExcel(ds, file);
});
});
DialogManager.GetDialogInputFromUser("How many rows to select? (0=max)", "0", ok, cancelCallback);
}
private int ImportExcelFileAndCreateTags(Languages excelSelectedLanguage, int categoryIndex, int tagNameIndex, int contentIndex)
{
LanguageFile newFile = new LanguageFile(m_englishFile, excelSelectedLanguage);
List <LanguageFileEntry> excelEntries = ExcelManager.ImportExcelFileEntries(excelPath, categoryIndex, tagNameIndex, contentIndex);
if (excelIgnoreHeaderLine)
{
excelEntries.RemoveAt(0);
}
//neue keys hinzufügen
foreach (LanguageFileEntry entry in excelEntries)
{
if (!m_newTagList.Contains(entry.textTag))
{
m_newTagList.Add(entry.textTag);
}
//Im EnglishFile nur Key hinzufügen, wenn noch nicht da
m_englishFile.SetEntry(entry.textTag);
newFile.SetEntry(entry.textTag, entry);
}
//neues file schreiben
LocalizationManager.WriteNewLanguageFile(excelSelectedLanguage, newFile);
//neues File reloaden, wenn ausgewählt
if (m_loadedLanguage == excelSelectedLanguage)
{
m_secondLanguageFile = LocalizationManager.GetLanguageDataFromFile(excelSelectedLanguage);
}
return(excelEntries.Count);
}
public async Task <IEnumerable <Dictionary <string, object> > > ExecuteSourceOperation(ActiveOperation ops)
{
// TODO
// 1) Read file content from blob storage
// 2> Return List from excel data
var intermediateJson = JsonConvert.DeserializeObject <string>(ops.Content);
var content = JsonConvert.DeserializeObject <ExcelDocument>(intermediateJson);
using (var da = new DocumentDataAccess(_conStr))
{
var doc = await da.Get(Convert.ToInt32(content.DocumentId));
if (doc != null)
{
var bs = new BlobStorageService(blobContainer);
var blobContent = await bs.GetBlob(doc.WebUrl);
var excelData = new ExcelManager().ExtractData(blobContent);
return(excelData);
}
}
return(null);
}
public ActionResult Projects()
{
var stringKey = Identity.UserID + ParameterManager.ParameterKey;
var parameter = SessionHelper.GetSession(stringKey) as ProjectParameter;
if (parameter == null)
{
return(Content("未获取当前查询条件！"));
}
parameter.Page = null;
var list = Core.ProjectManager.Search(parameter);
if (list == null)
{
return(Content("查询项目信息失败！"));
}
IWorkbook workbook = ExcelManager.WriteCoProjects(list);
if (workbook == null)
{
return(Content("生成表格失败！"));
}
var ms = new MemoryStream();
workbook.Write(ms);
ms.Flush();
byte[] fileContents = ms.ToArray();
return(File(fileContents, ParameterManager.ExcelContentType, string.Format("项目清单-{0}.xls", DateTime.Now.ToString(ParameterManager.TimeContentType))));
}
public static void WriteOnly(string outFileName, List <string> content, WriteType type = WriteType.TEXT)
{
if (string.IsNullOrEmpty(CDNResourceMoveConfig.Instance().logOutPath) || !Directory.Exists(CDNResourceMoveConfig.Instance().logOutPath))
{
Debug.LogError("write error !:" + CDNResourceMoveConfig.Instance().logOutPath);
return;
}
string outputPath = CDNResourceMoveConfig.Instance().logOutPath + "/" + outFileName;
string dir = Path.GetDirectoryName(outputPath);
if (!Directory.Exists(dir))
{
Directory.CreateDirectory(dir);
}
if (type == WriteType.EXCEL)
{
ExcelIns ei = ExcelManager.GetExcel(outputPath + ".xls");
ei.WriteSimpleList(content);
//ei.GetWorkSheet();
}
else
{
outputPath = outputPath + ".txt";
if (!File.Exists(outputPath))
{
FileStream fs1 = new FileStream(outputPath, FileMode.Create, FileAccess.Write);//创建写入文件
fs1.Close();
}
System.IO.File.WriteAllLines(outputPath, content.ToArray());
}
}
protected virtual Graphes GroupEventsByYear(
ExcelManager man,
Dictionary <string, string> legends = null,
bool twoAndMoreEventtypes = false)
{
var result = new Graphes(legends, twoAndMoreEventtypes);
foreach (HSSFRow row in man.Records)
{
var indices = man.GetValue(row, "Индекс");
if (!string.IsNullOrEmpty(indices) &&
(!twoAndMoreEventtypes ||
indices.Split(IndicesSeparator).Count(i => !string.IsNullOrEmpty(i)) >= 2))
{
if (legends != null)
{
var indicesFromLegend = new List <string>();
foreach (var index in indices.Split(IndicesSeparator))
{
indicesFromLegend.Add(legends.ContainsKey(index) ? legends[index] : index);
}
indices = indicesFromLegend.Aggregate((a, b) => a + IndicesSeparator + b);
}
var eventOrYear = twoAndMoreEventtypes ? row.RowNum : int.Parse(man.GetValue(row, "-99000"));
result.Add(eventOrYear, indices);
}
}
return(result);
}
public ActionResult FileLoadDraft(HttpPostedFileBase fileLoad)
{
if (fileLoad != null)
{
FileManager file = new FileManager(Server.MapPath("~/App_Data"), AreaName, ControllerName, fileLoad);
file.Save();
ExcelManager excel = new ExcelManager(file.FullPath, 1);
excel.ReadAll();
List <string> vs = new List <string>();
foreach (var row in excel.Rows)
{
if (row.Cell(1).Value.ToString().All(char.IsDigit))
{
vs.Add(row.Cell(1).Value.ToString());
}
}
excel.Dispose();
MarkingCollection.IncomingPinsFile = vs.ToArray();
}
IEnumerable <CleanPins> result = MarkingCollection.WithoutDraft;
return(View("WriteDraft", result));
}
private static void Test1()
{
string storeLocation = @"C:\Users\ergis\Desktop\Test1.xls";
List <Customer> data = new List <Customer>()
{
new Customer {
Id = 1, Name = "Test", Salary = 750d, BirthDate = DateTime.Now.AddYears(-18), IsActive = true
},
new Customer {
Id = 2, Name = "Test", Salary = 800f, BirthDate = DateTime.Now.AddYears(-20), IsActive = false
}
};
byte[] content = ExcelManager.GenerateExcel(data, new ExcelOptions
{
HeaderStyle = new HeaderStyle {
IsBold = false
},
BodyStyle = new BodyStyle {
IsBordered = true
}
});
using (var fileStream = File.Create(storeLocation))
{
fileStream.Write(content, 0, content.Length);
}
}
public static void Test_Read()
{
string location = @"C:\Users\ergis\Desktop\Test_read.xls";
string sheetName = "Sheet1";
var data = ExcelManager.ReadFromExcel <Customer>(location, sheetName, 1);
}
// GET: Reservation/ExportOrders
public ActionResult ExportOrders()
{
IViewerFactory <OrderView> factory = new OrderViewFactory();
var list = factory.Query(new Criteria(new
{
MenuDate = DateTime.Today,
MenuType = (int)MenuDto.GetMenuLunchOrSupper(0, false)
}));
if (list != null && list.Count > 0)
{
var mapper = OrderDto.ConfigMapper().CreateMapper();
var orders = mapper.Map <IEnumerable <OrderDto> >(list.AsEnumerable()).ToList();
var book = ExcelManager.BuildOrderWorkbook(orders);
byte[] file;
using (var ms = new MemoryStream())
{
book.Write(ms);
file = ms.GetBuffer();
}
return(File(file, "application/vnd.ms-excel", $@"今日订餐记录表-{DateTime.Today.ToString("yyyyMMdd")}.xls"));
//return File(file, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
// $"今日订餐记录表-{DateTime.Today.ToString("yyyyMMdd")}.xlsx");
}
return(RedirectToAction("TodayOrders", "Reservation"));
}
public Testing()
{
//DBConnHelper dwHelper = new DBConnHelper(Constants.dwConnString);
//DataSet dwDS = dwHelper.ExecQuery(Constants.stgQuery, 60);
//System.Data.DataTable dwDT = dwDS.Tables[0];
//dwDT.TableName = "FactTable";
//dwDT.ConvertDBNull();
DBConnHelper uatHelper = new DBConnHelper("Constants.uatConnString");
DataSet uatDS = uatHelper.ExecQuery("Constants.uatQuery", 600);
System.Data.DataTable uatDT = uatDS.Tables[0];
uatDT.TableName = "RRRTable";
uatDT.ConvertDBNull();
//System.Data.DataTable unionDT = dwDT.AsEnumerable().Union(uatDT.AsEnumerable(), DataRowComparer.Default).CopyToDataTable();
//unionDT.TableName = "UnionTable";
//System.Data.DataTable expDT = dwDT.AsEnumerable().Except(uatDT.AsEnumerable(), DataRowComparer.Default).CopyToDataTable();
//expDT.TableName = "EXPTable";
ExcelController.PivotTableConfig ptconfi = new ExcelController.PivotTableConfig();
ptconfi.PivotName = "Pivot_Testing";
ptconfi.PivotColumns = new System.Collections.ObjectModel.ObservableCollection<string>();
ptconfi.PivotColumns.Add("Scenario");
ptconfi.PivotRows = new System.Collections.ObjectModel.ObservableCollection<string>();
ptconfi.PivotRows.Add("Desk");
ptconfi.PivotRows.Add("Account");
ptconfi.PivotValues = new System.Collections.ObjectModel.ObservableCollection<string>();
ptconfi.PivotValues.Add("EffectiveDV01");
ptconfi.PivotValues.Add("Convexity");
ptconfi.PivotValues.Add("Duration");
IExcelManager em = new ExcelManager();
em.CreatePivot(uatDT, ptconfi);
}
public ActionResult Import(string FileTable)
{
string Editor = Method.GetLogonUserId(Session, this, User.Identity.Name.ToUpper());
int i = 0;
foreach (string file in Request.Files)
{
HttpPostedFileBase hpf = Request.Files[i] as HttpPostedFileBase;
if (hpf.ContentLength == 0)
{
continue;
}
DataTable workTable = ExcelManager.getExcelSheetData(hpf);
attachFileTable attachfiletable = db.attachFileTables.Where(x => x.FileTable == FileTable).FirstOrDefault();
string insert_Table = attachfiletable.TempTable;
int ColumnsCount = attachfiletable.ColumnsCount;
if (workTable.Columns.Count > ColumnsCount)
{
for (int c = ColumnsCount; c < workTable.Columns.Count; c++)
{
DataColumn removedc = workTable.Columns[c];
if (workTable.Columns.Count > ColumnsCount)
{
workTable.Columns.Remove(removedc);
c--;
}
}
}
DAO.DatatableToSQL(Constant.ConnDBContext, workTable, insert_Table);
workTable.Clear();
}
return(View());
}
/// <summary>
/// 导出数据到Excel表 导出的excel表为 .xls 格式
/// </summary>
/// <returns></returns>
public FileResult ExportData()
{
ExcelManager em = new ExcelManager(_memberBLL, _informationBLL, _followBLL, _followRecordBLL);
MemoryStream ms = em.DataToExcel(System.Web.HttpContext.Current.Session["InformationList"] as List <InformationModel>);
return(File(ms, "application/vnd.ms-excel", Guid.NewGuid().ToString() + ".xls"));
}
public ActionResult ExportCheckLists(DateTime date)
{
using (IRepository repo = new Repository())
{
var list = repo.Query <CheckList>(x => x.OperateDate >= date.AddDays(-2) && x.OperateDate <= date.AddDays(2))
.FindAll(x => x.OperateDate.Date == date.Date && x.IsActive);
if (list.Count > 0)
{
var mapper = CheckListDto.ConfigMapper().CreateMapper();
var checklists = mapper.Map <IEnumerable <CheckListDto> >(list.AsEnumerable()).ToList();
var book = ExcelManager.BuildCheckListWorkbook(checklists, date);
byte[] file;
using (var ms = new MemoryStream())
{
book.Write(ms);
file = ms.GetBuffer();
}
return(File(file, "application/vnd.ms-excel", $@"今日安全检查表-{date:yyyyMMdd}.xls"));
}
}
return(RedirectToAction("CheckListManagement", "SecureNode", new { date }));
}
// GET: Console/ExportReports
public ActionResult ExportReports()
{
IViewerFactory <ReportView> factory = new ReportViewFactory();
var list = factory.Query(new Criteria(new
{
MenuDate = DateTime.Today,
MenuType = (int)MenuDto.GetMenuLunchOrSupper(0, false)
}));
if (list != null && list.Count > 0)
{
var mapper = ReportDto.ConfigMapper().CreateMapper();
var reports = mapper.Map <IEnumerable <ReportDto> >(list.AsEnumerable()).ToList();
var book = ExcelManager.BuildReportWorkbook(reports);
byte[] file;
using (var ms = new MemoryStream())
{
book.Write(ms);
file = ms.GetBuffer();
}
return(File(file, "application/vnd.ms-excel", $@"今日订餐统计表-{DateTime.Today:yyyyMMdd}.xls"));
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult AnalyzeFile()
{
if (Request.Files.Count == 0)
{
throw new ArgumentException("请选择上传文件");
}
var file = HttpContext.Request.Files[0];
var fileName = file.FileName;
if (string.IsNullOrEmpty(fileName))
{
throw new ArgumentException("请选择上传文件");
}
var filePath = FileManager.Upload(file);
var list = ExcelManager.AnalyzeLand(filePath);
Core.LandManager.AddRange(list, Identity.UserID);
try
{
}
catch
{
}
return(RedirectToAction("Index"));
}
public ActionResult Verify(DownloadEnum download)
{
var stringKey = Identity.UserID + ParameterManager.ParameterKey;
var parameter = SessionHelper.GetSession(stringKey) as SheetVerifyParameter;
//var parameter = RedisManager.Get<SheetVerifyParameter>(, RedisManager.Client);
if (parameter == null)
{
return(Content("未获取查询条件！"));
}
var list = Core.VerifyViewManager.Search(parameter, true);
if (list == null)
{
return(Content("未读取到报销单信息"));
}
IWorkbook workbook = ExcelManager.WriteVerify(list, download);
if (workbook == null)
{
return(Content("创建表格失败!"));
}
var ms = new MemoryStream();
workbook.Write(ms);
ms.Flush();
byte[] fileContents = ms.ToArray();
return(File(fileContents, ParameterManager.ExcelContentType, string.Format("{0} {1}.xls", download.GetDescription(), DateTime.Now.ToString(ParameterManager.TimeContentType))));
}
//汇总的表格要有项目编号、负责人、项目名称、研究周期、批复金额、余额
//批量导出，单个导出
#region 导出到Excel
protected void Exp2Excel_Click(object sender, EventArgs e)
{
//str_sql = "exec Q_Lxjg ";
str_sql = "select content from t_dict where flm= 14 and bm = 1";
str_sql = DBFun.ExecuteScalar(str_sql).ToString();
ExcelManager.Exp2Excel(this.Page, str_sql);
}
// Загрузка файла недокомплекта Excel
void btnLoadFromExcel_Click(object sender, RoutedEventArgs e)
{
try
{
var dlg = new OpenFileDialog {
Filter = "Файлы Excel|*.xls"
};
if (dlg.ShowDialog(this) != true)
{
return;
}
var rTemp = ExcelManager.LoadRequests(type, dlg.FileName);
foreach (var r in rTemp)
{
var item = requests.SingleOrDefault(x => x.Name == r.Name && x.Article == r.Article && x.Type == type);
if (item == null)
{
requests.Add(r);
}
else // если такой уже есть добавляем количество
{
item.TotalCount += r.TotalCount;
}
}
}
catch (Exception ex)
{
var msg = string.Format("Ошибка загрузки файла Excel: {0}", ex.Message);
MessageBox.Show(msg, "Внимание", MessageBoxButton.OK, MessageBoxImage.Error);
LogManager.LogError(unit, msg, ex);
}
}
private void OnStart()
{
ExcelManager.InitLoader(name =>
{
Stream stream = null;
var refSet = ResourcesManager.GetUnmanagedRefSet("configuration");
{
var asset = ResourcesManager.LoadAsset <TextAsset>(name, refSet);
stream = new System.IO.MemoryStream(asset.bytes);
}
refSet.Release();
return(stream);
});
ExcelManager.LoadAll();
this.world = GBox.Make <IWorld>();
this.observer = this.world.AddSystem <MessageSystem>();
this.windowManager = this.world.AddSystem <WindowSystem>();
this.world.AddSystem <RenderSystem>();
this.world.AddSystem <CameraSystem>();
var room = this.world.AddSystem <RoomSystem>();
this.world.AddSystem <AudioSystem>();
this.game = this.world.CreateEntity();
var ctx = this.game.AddTrait <Context>();
ctx.World = this.world;
ctx.Room = room;
var machine = this.game.AddControl <StateMachine>();
machine.ChangeState(new LoginState());
}
public static void ExportEnfantToExcel(string FileName, int plaine)
{
ExcelManager ExcelManager = new ExcelManager();
string Query = $"SELECT Nom,Prenom,Tranche_age,Age,Date_Naissance,Email,N_National,Adresse,Fiche_Sante,MC,BIM,Prix,Nbr_jour,Lundi,Mardi,Mercredi,Jeudi,Vendredi FROM Enfant Where PlaineID ={plaine} ";
ExcelManager.DataToExcel(DbToDataSet(Query), FileName);
}
public static void ExportALLToExcel(string FileName, int plaine)
{
ExcelManager ExcelManager = new ExcelManager();
string Query = $"Select * from Enfant Where PlaineID ={plaine}";
ExcelManager.DataToExcel(DbToDataSet(Query), FileName);
}
private void buttonOpenExcel_Click(object sender, EventArgs e)
{
buttonOpenExcel.Enabled = false;
ExcelManager.Create();
ExcelManager.Fill(Tables, Titles, comboBoxQuarter.Text, comboBoxSubsidiary.Text);
buttonOpenExcel.Enabled = true;
ExcelManager.Open();
}
protected void Add_OK_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string path = "~/UploadFiles/ExcelData/";
string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + FileUpload1.FileName;
path += filename;
if (Path.GetExtension(filename) == ".xls")
{
try
{
FileUpload1.PostedFile.SaveAs(Server.MapPath(path));
string excelResult = ExcelManager.CheckExcelData(Server.MapPath(path));
if (excelResult == "NullData")
{
string myscript = @"alert('数据导入失败！');window.location.href='EQState.aspx';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true);
}
else
{
string splitflag = ".";
string[] resultinfo = excelResult.Split(splitflag.ToCharArray(), System.StringSplitOptions.RemoveEmptyEntries);
string insertsql = "Insert Into [EQ State] ([shortdate],[filepath]) values ('" + resultinfo[1] + "','" + path + "')";
if (resultinfo[0] == "ExistData")
{
insertsql = "Update [EQ State] Set [filepath]='" + path + "' where [shortdate]='" + resultinfo[1] + "'";
}
try
{
DbManager.ExecuteNonQuery(insertsql);
string myscript = @"alert('数据导入成功！');window.location.href='EQState.aspx';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true);
}
catch
{
string myscript = @"alert('数据库操作失败！');window.location.href='EQState.aspx';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true);
}
}
}
catch
{
string myscript = @"alert('文件上传失败！');window.location.href='EQState.aspx';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true);
}
}
else
{
ToolTips.Text = "文档格式必须为'.xls'！";
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script> ShowDialog('Add_Dialog');</script>");
}
}
else
{
ToolTips.Text = "请选择数据文件！";
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script> ShowDialog('Add_Dialog');</script>");
}
}
public void ExportToExcel(SIMREG_NEWFORMSearchViewModel model)
{
//BOUser boUser = new BOUser();
BOSIMREG_NEWFORM boSim = new BOSIMREG_NEWFORM();
ExcelManager ex = new ExcelManager("SimRegisterReport.csv", false);
System.Data.DataSet ds = new System.Data.DataSet();
//boSim.GetSIMREG_NEWFORMs(ds);
boSim.GetSIMREG_NEWFORMs(model.MSISDNTITLE, model.REQUESTEDBYID, model.REQUESTEDBYID, model.DELIVEREDBYID,
model.REQUESTEDDATE.ToString(), model.DELIVEREDBYDATE.ToString(), ds);
ex.ExportData(ds.Tables[0], Response);
}
protected void ExportCSVButton_Click(object sender, EventArgs e)
{
string strReportHtml = string.Empty;
try
{
ExcelManager objExcelManager = new ExcelManager();
//string strParametersPath = this.Page.Server.MapPath("../Reports/Templates/");
// Pass the data and get the path for generated temporary file.
// DataTable vdtData, string vstrfilePath, string vstrExportCaption, string vstrDBColumn, string vstrExcelColumn)
if (null != ViewState["DataId"])
{
string strRand = ViewState["DataId"].ToString();
if (null != this.Page.Session[strRand])
{
DataTable dt = this.Page.Session[strRand] as DataTable;
if ((null != dt) & (string.IsNullOrEmpty(ExportTemplatePath) == false) && (string.IsNullOrEmpty(ExportTemplate) == false) && (string.IsNullOrEmpty(DBColumn) == false) & (string.IsNullOrEmpty(ExcelColumn) == false))
{
/*string strFilePath = objExcelManager.GenerateExcelDataFileFromGrid(dt, this.Page.Server.MapPath(ExportTemplatePath), ExportTemplate, ExportCaption, DBColumn, ExcelColumn,
ExcelHeaderRow, StartRow, StartColumn, MaxLevel, SheetNumber, CurrentDateRow, CurrentDateCol, StartDateRow, StartDateCol, EndDateRow, EndDateCol, ReportStartDate, ReportEndDate);*/
string strFilePath = objExcelManager.GenerateCSVFileFromGrid(dt, this.Page.Server.MapPath(ExportTemplatePath), ExportTemplate, ExportCaption, DBColumn, ExcelColumn,
ExcelHeaderRow, StartRow, StartColumn, MaxLevel, SheetNumber, CurrentDateRow, CurrentDateCol, StartDateRow, StartDateCol, EndDateRow, EndDateCol, ReportStartDate, ReportEndDate);
System.IO.FileInfo objfInfo = new System.IO.FileInfo(strFilePath);
if (objfInfo.Exists)
{
this.Page.Response.Clear();
string attachment = "attachment; filename=" + objfInfo.Name;
this.Page.Response.AddHeader("content-disposition", attachment);
//if (vExportType == Constants.ExportType.Excel)
//{
this.Page.Response.ContentType = "text/csv";
//}
//else
//{
// Response.ContentType = "text/csv";
//}
this.Page.Response.BinaryWrite(System.IO.File.ReadAllBytes(strFilePath));
objfInfo.Delete(); // Once the file content is written to response stream delete it.
//Response.End();
}
}
}
}
}
catch (Exception ex)
{
//throw;
SendMail.MailMessage("ExcelPackage > Error > ExportCSVButton_Click(object sender, EventArgs e)", ex.ToString());
}
finally
{
this.Page.Response.End();
}
}
private void AddNewInputParametersLine(ExcelManager.CExcelManager.Parameter a_parameters)
{
Label label = new Label();
label.Width = inputWidth;
label.Height = inputHeight;
label.Padding = new Thickness(2);
WrapPanel labelPanel = new WrapPanel();
labelPanel.Orientation = Orientation.Horizontal;
labelPanel.Width = inputWidth;
labelPanel.Height = inputHeight;
AutoSuggestControl.AutoSuggestBox parameterKeyBox = new AutoSuggestControl.AutoSuggestBox();
parameterKeyBox.ListItemSelected += new RoutedPropertyChangedEventHandler<object>(parameterKeyBox_ListItemSelected);
parameterKeyBox.InitOptionAutoSuggest();
parameterKeyBox.Width = textboxParameterKeyWidth;
parameterKeyBox.Height = textboxHeight;
Label labelSeparator = new Label();
labelSeparator.Width = labelParameterSaparatorWidth;
labelSeparator.Height = textboxHeight;
labelSeparator.Content = ":";
AutoSuggestControl.AutoSuggestBox parameterValueBox = new AutoSuggestControl.AutoSuggestBox();
parameterValueBox.ListItemSelected += new RoutedPropertyChangedEventHandler<object>(parameterValueBox_ListItemSelected);
parameterValueBox.Width = textboxParameterValueWidth;
parameterValueBox.Height = textboxHeight;
Label labelDescription = new Label();
//labelDescription.Width = labelParameterDescriptionWidth;
labelDescription.Height = textboxHeight;
labelDescription.FontSize = 13;
labelDescription.FontFamily = new System.Windows.Media.FontFamily("Calibri");
labelDescription.Foreground = new SolidColorBrush(Color.FromArgb(0xff, 0x40, 0x3e, 0x3c));
Label space = new Label();
space.Width = 10;
space.Height = textboxHeight;
Button removeButton = new Button();
removeButton.Content = "-";
removeButton.Width = removeButtonWidth;
removeButton.Height = removeButtonHeight;
removeButton.Background = Brushes.White;
removeButton.BorderBrush = new SolidColorBrush(Color.FromArgb(0xff, 0xff, 0xcb, 0x8b));
removeButton.Foreground = new SolidColorBrush(Color.FromArgb(0xff, 0xff, 0x52, 0x00));
labelPanel.Children.Add(removeButton);
labelPanel.Children.Add(space);
labelPanel.Children.Add(parameterKeyBox);
label.Content = labelPanel;
label.Tag = m_noOfParameters;
labelPanel.Tag = m_noOfInstruments;
parameterKeyBox.Tag = m_noOfParameters;
labelSeparator.Tag = m_noOfParameters;
parameterValueBox.Tag = m_noOfParameters;
labelDescription.Tag = m_noOfParameters;
removeButton.Tag = m_noOfParameters;
removeButton.PreviewMouseDown += new MouseButtonEventHandler(removeButton_Parameters_MouseDownEvent);
//parameterKeyBox.PreviewKeyUp += new KeyEventHandler(keyTextbox_Parameters_KeyInput);
parameterLabel.Add(label);
parameterWrapPanel.Add(labelPanel);
parameterKeyTextBox.Add(parameterKeyBox);
parameterSeparatorLabel.Add(labelSeparator);
parameterValueTextBox.Add(parameterValueBox);
parameterDescriptionLabel.Add(labelDescription);
parameterRemoveButton.Add(removeButton);
Grid.SetColumn(label, 0);
Grid.SetRow(label, m_noOfParameters);
if (a_parameters != null)
{
parameterKeyBox.Text = a_parameters.Name;
labelPanel.Children.Add(labelSeparator);
parameterValueBox.Text = a_parameters.Value;
labelPanel.Children.Add(parameterValueBox);
//string description = FindParameterDescription()
}
Parameterslb.Items.Add(label);
++m_noOfParameters;
}
/*
* Exports the selected query data to excel; use random file name by timestamp
*/
private void ExportDataTableToExcel(DataTable sInputTable, DataTable objNodeTable)
{
// export to Excel
// create random timestamp
TimeSpan sTime = DateTime.Now - new DateTime(1970, 1, 1, 0, 0, 0);
string timeStamp = ((long)sTime.TotalMilliseconds).ToString();
ExcelManager em = new ExcelManager();
if (em.ExcelExport(sInputTable, objNodeTable, "MiningReport_" + timeStamp + ".xls"))
LabelStatus.Text = "Success!";
else
LabelStatus.Text = "Failed!";
}
