public bool Write(Dictionary<Guid,string> source, Adam.Core.Application app) { Record r = new Record(app); Excel.Application EApp; Excel.Workbook EWorkbook; Excel.Worksheet EWorksheet; Excel.Range Rng; EApp = new Excel.Application(); object misValue = System.Reflection.Missing.Value; EWorkbook = EApp.Workbooks.Add(misValue); EWorksheet = (Excel.Worksheet)EWorkbook.Worksheets.Item[1]; EWorksheet.get_Range("A1", misValue).Formula = "UPC code"; EWorksheet.get_Range("B1", misValue).Formula = "Link"; Rng = EWorksheet.get_Range("A2", misValue).get_Resize(source.Count,misValue); Rng.NumberFormat = "00000000000000"; int row = 2; foreach(KeyValuePair<Guid,string> pair in source) { EWorksheet.Cells[row,1] = pair.Value; r.Load(pair.Key); Rng = EWorksheet.get_Range("B"+row, misValue); EWorksheet.Hyperlinks.Add(Rng, r.Fields.GetField<TextField>("Content Url").Value); //myExcelWorksheet.Cells[row, 2] = r.Fields.GetField<TextField>("Content Url").Value; row++; } ((Excel.Range)EWorksheet.Cells[2, 1]).EntireColumn.AutoFit(); ((Excel.Range)EWorksheet.Cells[2, 2]).EntireColumn.AutoFit(); EWorkbook.SaveAs(_fileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); EWorkbook.Close(true, misValue, misValue); EApp.Quit(); return true; }
static void Main(string[] args) { Application app = new Application(); LogOnStatus status = app.LogOn("TRAINING", "Demidov", "123456"); Console.WriteLine(status); if (status != LogOnStatus.LoggedOn) { throw new UnauthorizedAccessException(); } Record rec = new Record(app); Guid recId; Guid.TryParse("46e678e9-24af-4364-8926-a54600dcf188", out recId); rec.Load(recId); string s = rec.Files.LatestMaster.Path; Console.WriteLine(s); Console.ReadLine(); }
public void Load(string rootpath) { string dir = ProgressContainer.ProgressDirectory(rootpath); Directory.CreateDirectory(dir); string fullpath = ProgressContainer.FullPath(rootpath, m_Id); if (File.Exists(fullpath)) { using (BinaryReader file = new BinaryReader(File.Open(fullpath, FileMode.Open))) { int version = file.ReadInt32(); if (version >= 1) { int booknum = file.ReadInt32(); for (int i = 0; i < booknum; i++) { string book = file.ReadString(); if (!m_books.Exists(x => x == book)) { m_books.Add(book); } } } int count = file.ReadInt32(); for (int i = 0; i < count; i++) { Record record = new Record(); record.Load(file, version); record.ProcessRecord(new Record.ProcessRecordEntry(CountOneEntry)); m_wordSet.Add(record.m_word, record); } } } foreach (string book in m_books) { BookDict dict = new BookDict(rootpath, book); dict.ReadBook(this); dict.SaveBook(); } ReOrganize(); }
public bool Write(Dictionary <Guid, string> source, Adam.Core.Application app) { Record r = new Record(app); Excel.Application EApp; Excel.Workbook EWorkbook; Excel.Worksheet EWorksheet; Excel.Range Rng; EApp = new Excel.Application(); object misValue = System.Reflection.Missing.Value; EWorkbook = EApp.Workbooks.Add(misValue); EWorksheet = (Excel.Worksheet)EWorkbook.Worksheets.Item[1]; EWorksheet.get_Range("A1", misValue).Formula = "UPC code"; EWorksheet.get_Range("B1", misValue).Formula = "Link"; Rng = EWorksheet.get_Range("A2", misValue).get_Resize(source.Count, misValue); Rng.NumberFormat = "00000000000000"; int row = 2; foreach (KeyValuePair <Guid, string> pair in source) { EWorksheet.Cells[row, 1] = pair.Value; r.Load(pair.Key); Rng = EWorksheet.get_Range("B" + row, misValue); EWorksheet.Hyperlinks.Add(Rng, r.Fields.GetField <TextField>("Content Url").Value); //myExcelWorksheet.Cells[row, 2] = r.Fields.GetField<TextField>("Content Url").Value; row++; } ((Excel.Range)EWorksheet.Cells[2, 1]).EntireColumn.AutoFit(); ((Excel.Range)EWorksheet.Cells[2, 2]).EntireColumn.AutoFit(); EWorkbook.SaveAs(_fileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); EWorkbook.Close(true, misValue, misValue); EApp.Quit(); return(true); }
private string GetByte64Image() { Record rec = new Record((Application) Session["AdamApp"]); Guid recId; Guid.TryParse("7819340e-b66c-4225-a604-a54500a909b2", out recId); rec.Load(recId); IReadOnlyImage prev = rec.Files.Master.GetPreview(); byte[] imagData = prev.GetBytes(); string imageDataString = Convert.ToBase64String(imagData); return imageDataString; }
public FileContentResult GetFile() { Record rec = new Record((Application) Session["AdamApp"]); Guid recId; Guid.TryParse("7819340e-b66c-4225-a604-a54500a909b2", out recId); rec.Load(recId); IReadOnlyImage prev = rec.Files.Master.GetPreview(); return new FileContentResult(prev.GetBytes(), "image/jpeg"); }
void Start() { record = new Record(); record.Load(); currentState = State.Initial; }