private Guid OpenDocumentID(string documentID)
{
var unitOfWork = new DocumentsUnitOfWork();
var documentItem = unitOfWork.ItemRepository.GetByID(long.Parse(documentID));
var documentItemInfo = new DocumentItemInfo(documentItem);
var editorType = documentItemInfo.DocumentProcessorType;
OfficeWorkSessionControl editor = null;
if (editorType == OfficeDocumentProcessorType.Spreadsheet)
{
var spreadsheetControl = new ASPxSpreadsheet();
spreadsheetControl.Open(
documentItemInfo.Id,
(DevExpress.Spreadsheet.DocumentFormat)DocumentFormatUtils.GetDocumentFormat(documentItemInfo.NameExtension),
() => documentItem.Content.Data);
editor = spreadsheetControl;
}
if (editorType == OfficeDocumentProcessorType.RichEdit)
{
var richEditControl = new ASPxRichEdit();
richEditControl.Open(
documentItemInfo.Id,
(DevExpress.XtraRichEdit.DocumentFormat)DocumentFormatUtils.GetDocumentFormat(documentItemInfo.NameExtension),
() => documentItem.Content.Data);
editor = richEditControl;
}
return(editor.GetWorkSessionID());
}
private void OpenExcelFile(string fileFullPath)
{
ASPxSpreadsheet spreadsheet = new ASPxSpreadsheet();
spreadsheet.ID = "spreadsheet";
ASPxPopupControl1.Controls.Add(spreadsheet);
spreadsheet.Open(fileFullPath);
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
_spreadsheet = null;
}
base.Dispose(disposing);
}
protected override WebControl CreateEditModeControlCore()
{
this._spreadsheet = new ASPxSpreadsheet();
_spreadsheet.SettingsDocumentSelector.UploadSettings.Enabled = true;
_spreadsheet.SettingsDocumentSelector.UploadSettings.UseAdvancedUploadMode = true;
_spreadsheet.SettingsDocumentSelector.UploadSettings.AdvancedModeSettings.EnableFileList = true;
_spreadsheet.SettingsDocumentSelector.UploadSettings.AdvancedModeSettings.EnableMultiSelect = true;
_spreadsheet.SettingsDocumentSelector.UploadSettings.AutoStartUpload = true;
//初始目录：当前登陆用户+当天日期
var dir = "~/ExcelFiles/" + SecuritySystem.CurrentUserName + "/" + DateTime.Now.ToString("yyyyMMdd");
_spreadsheet.WorkDirectory = dir;
_spreadsheet.ShowConfirmOnLosingChanges = false;
_spreadsheet.ClientSideEvents.Init = "function(s, e){ s.SetFullscreenMode(true); }";
_spreadsheet.Height = 800;
_spreadsheet.CreateDefaultRibbonTabs(true);
_spreadsheet.ActiveTabIndex = 0;//默认标签行这个可以打开的时候默认第一个导入的标签
//_spreadsheet.ClientSideEvents.CustomCommandExecuted
if (IsNewStyle)
{
_spreadsheet.ClientSideEvents.Init = "function(s, e){ s.SetFullscreenMode(false); }";
_spreadsheet.Theme = "Aqua";
}
_spreadsheet.Load += (s, e) =>
{
var handlerid = _spreadsheet.UniqueID + "StartImport";
var page = _spreadsheet.Page as ICallbackManagerHolder;
page.CallbackManager.RegisterHandler(handlerid, this);
var doAction = page.CallbackManager.GetScript(handlerid, "null");
_spreadsheet.ClientSideEvents.CustomCommandExecuted = "function(s,e) { " + doAction + " }";
};
var t = _spreadsheet.RibbonTabs[0];
var g = t.Groups.Add("导入");
//_spreadsheet.Document
var temp = new RibbonButtonItem("ImportData", "导入数据", RibbonItemSize.Large);
temp.LargeImage.Url = "~/Images/ImportData_32x32.png";
//new RibbonTemplateItem();
g.Items.Add(temp);
//StartImport = new StartImportTemplate(_spreadsheet, this._objectSpace, this._application);
//temp.Template = StartImport;
importer.InitializeExcelSheet(_spreadsheet.Document, this.option);
//_spreadsheet.d
return(_spreadsheet);
}
public static void HideFileTab(ASPxSpreadsheet spreadsheet)
{
spreadsheet.CreateDefaultRibbonTabs(true);
spreadsheet.RibbonTabs.RemoveAt(0);
SRFileCommonGroup gr = new SRFileCommonGroup();
gr.Items.Add(new SRFileSaveCommand());
gr.Items.Add(new SRFilePrintCommand());
spreadsheet.RibbonTabs[0].Groups.Insert(0, gr);
spreadsheet.ActiveTabIndex = 0;
}
protected void ASPxSpreadsheet1_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e)
{
ASPxSpreadsheet spreadSheet = (ASPxSpreadsheet)sender;
Margins margins = spreadSheet.Document.Worksheets[0].ActiveView.Margins;
spreadSheet.Document.Unit = DocumentUnit.Inch;
margins.Top = (float)speTop.Number;
margins.Bottom = (float)speBottom.Number;
margins.Left = (float)speLeft.Number;
margins.Right = (float)speRight.Number;
}
protected void ASPxSpreadsheet1_Saving(object source, DocumentSavingEventArgs e)
{
ASPxSpreadsheet sh = source as ASPxSpreadsheet;
try {
// SqlDataSource1.Update(); // uncomment to update the data source
sh.JSProperties["cpSavingResult"] = "OK";
}
catch (Exception ex) {
sh.JSProperties["cpSavingResult"] = "ERROR";
}
e.Handled = true;
}
protected void ASPxSpreadsheet1_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e)
{
ASPxSpreadsheet spreadSheet = sender as ASPxSpreadsheet;
IWorkbook workbook = spreadSheet.Document;
Worksheet worksheet = workbook.Worksheets[0];
switch (e.Parameter)
{
case "applyFormatting":
CellRange priceRange = worksheet.Range["C2:C15"];
Formatting rangeFormatting = priceRange.BeginUpdateFormatting();
rangeFormatting.Font.Color = Color.SandyBrown;
rangeFormatting.Font.FontStyle = SpreadsheetFontStyle.Bold;
rangeFormatting.Fill.BackgroundColor = Color.PaleGoldenrod;
rangeFormatting.NumberFormat = "$0.0#";
rangeFormatting.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
rangeFormatting.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
priceRange.EndUpdateFormatting(rangeFormatting);
break;
case "insertLink":
worksheet.Columns["G"].WidthInPixels = 180;
CellRange cell1 = worksheet.Cells["G4"];
cell1.Fill.BackgroundColor = Color.WhiteSmoke;
worksheet.Hyperlinks.Add(cell1, "https://documentation.devexpress.com/OfficeFileAPI/14912/Spreadsheet-Document-API", true, "Spreadsheet Document API");
break;
case "drawBorders":
CellRange tableRange = worksheet.Range["A2:E16"];
tableRange.Borders.SetAllBorders(Color.RosyBrown, BorderLineStyle.Hair);
break;
case "showTotal":
CellRange cell2 = worksheet.Cells["E16"];
cell2.Formula = "=SUBTOTAL(9,E2:E15)";
CellRange cell3 = worksheet.Cells["A16"];
cell3.Formula = "SUBTOTAL(103,A2:A15)";
CellRange cell4 = worksheet.Cells["D16"];
cell4.Value = "Total amount";
break;
}
}
public static void HideFileTab(ASPxSpreadsheet spreadsheet)
{
spreadsheet.CreateDefaultRibbonTabs(true);
RemoveRibbonTab(spreadsheet.RibbonTabs, typeof(SRFileTab));
spreadsheet.ActiveTabIndex = 0;
}
protected void btnDownloadExistingFile_Command(object sender, CommandEventArgs e)
{
ASPxSpreadsheet.Visible = false;
if (e.CommandName == "DownloadExistingFile")
{
string filename = e.CommandArgument.ToString();
if (File.Exists(HttpContext.Current.Server.MapPath("~/App_Data/DataDownloads/" + filename)))
{
LogDownload(filename);
DownloadFile(filename);
}
else
{
string result = "Sorry, the file [" + filename + "] was not found.";
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + result + "');", true);
}
}
else if (e.CommandName == "LoadXLSX")
{
string filename = e.CommandArgument.ToString();
if (File.Exists(HttpContext.Current.Server.MapPath("~/App_Data/DataDownloads/" + filename)))
{
ASPxSpreadsheet.Open(HttpContext.Current.Server.MapPath("~/App_Data/DataDownloads/" + filename));
ASPxSpreadsheet.Visible = true;
}
else
{
string result = "Sorry, the file [" + filename + "] was not found.";
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + result + "');", true);
}
}
else if (e.CommandName == "DownloadExistingFile_xls")
{
string filename = e.CommandArgument.ToString().Replace(".xlsx", ".xls");
if (File.Exists(HttpContext.Current.Server.MapPath("~/App_Data/DataDownloads/" + filename)))
{
LogDownload(filename);
DownloadFile(filename);
}
else
{
if (File.Exists(HttpContext.Current.Server.MapPath("~/App_Data/DataDownloads/" + e.CommandArgument.ToString())))
{
//convert to .xls here
try
{
SpreadsheetGearUtils.Save_xls_from_xlsx(e.CommandArgument.ToString());
LogDownload(filename);
DownloadFile(filename);
}
catch (Exception ex)
{
string x = ex.Message;
string result = "Sorry, the file [" + filename + "] was not found. We have tried to create it but an error occurred.";
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + result + "');", true);
}
}
else
{
string result = "Sorry, the file [" + filename + "] was not found.";
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + result + "');", true);
}
}
}
else if (e.CommandName == "ViewSummary")
{
string filename = e.CommandArgument.ToString();
string pageurl = "DataProjectStats.aspx";
pageurl += "?filename=" + e.CommandArgument.ToString() + "&pk=" + Request.QueryString["pk"];
Response.Redirect(pageurl);
}
}
public StartImportTemplate(ASPxSpreadsheet spreadSheet)
{
_spreadSheet = spreadSheet;
}
public StartImportTemplate(ASPxSpreadsheet spreadSheet, IObjectSpace os, XafApplication xaf)
{
_spreadSheet = spreadSheet;
this._application = xaf;
objectSpace = os;
}
