private void LoadLegacyElement(ChordSheet sheet)
{
for (int i = 0, count = sheet.Chords.Count; i < count; ++i)
{
AddNewChord(sheet.Chords[i]);
}
}
public void ExportChordFileConstructorTest()
{
ExportChordFile target = new ExportChordFile();
target.ExportFilePath = @"C:\Users\wangji\Desktop\手簿 Data for Test\chord_result.xls";
target.TemplateFilePath = @"C:\Users\wangji\Desktop\手簿 Data for Test\Chord_Template.xls";
string path = @"C:\Users\wangji\Desktop\手簿 Data for Test\收敛手簿 2013-10-10.txt";
ChordSheet sheet =new ChordSheet();
ChordSheet.PrjName = "test for chord sheet report";
sheet.Lines.Add(new ReadChordFile().ReadTxt(path));
sheet.Lines.Add(new ReadChordFile().ReadTxt(path));
target.Export(sheet);
}
public static string ReadChord(string[] files, string prjName, int RecNo)
{
ReadChordFile read = new ReadChordFile();
ChordSheet sheet = new ChordSheet();
ChordSheet.PrjName = prjName;
ChordSheet.RecordNo = RecNo;
sheet.Lines = read.ReadTxtList(files);
string exportname = string.Format("{0}工程全站仪收敛观测记录{1}次", prjName, RecNo);
string templateUrl = HttpContext.Current.Request.ApplicationPath + "/Template/Chord_Template.xls";
string exportUrl = HttpContext.Current.Request.ApplicationPath + "/Export/" + exportname + ".xls";
string templetepath = HttpContext.Current.Server.MapPath(templateUrl);
string exportpath = HttpContext.Current.Server.MapPath(exportUrl);
ExportChordFile ex = new ExportChordFile();
ex.TemplateFilePath = templetepath;
ex.ExportFilePath = exportpath;
ex.Export(sheet);
return exportname + ".xls";
}
private void LoadElements(ChordSheet sheet)
{
ClearChords();
ClearMelodies();
if ((sheet.ElementTypes == null || sheet.ElementTypes.Count == 0) && sheet.Chords.Count > 0)
{
LoadLegacyElement(sheet);
LoadPanel.CloseWindow();
return;
}
int chordIndex = 0;
int melodyIndex = 0;
int labelIndex = 0;
for (int i = 0, count = sheet.ElementTypes.Count; i < count; ++i)
{
switch (sheet.ElementTypes[i])
{
case ElementType.Chord:
AddNewChord(sheet.Chords[chordIndex]);
chordIndex++;
break;
case ElementType.Melody:
AddNewMelody(sheet.MelodyDiagrams[melodyIndex]);
melodyIndex++;
break;
case ElementType.Label:
AddNewLabel(sheet.Labels[labelIndex]);
labelIndex++;
break;
}
}
LoadPanel.CloseWindow();
}
private void OnSheetsRetrievedForSave(ChordSheetCollection sheetCollection)
{
ChordSheet newSheet = new ChordSheet();
newSheet.Chords = new List <Chord>();
newSheet.MelodyDiagrams = new List <MelodyDiagramModel>();
newSheet.Labels = new List <string>();
newSheet.ElementTypesInt = new List <int>();
for (int i = 0, count = chords.Count; i < count; ++i)
{
newSheet.Chords.Add(chords[i].CurrentChord);
}
for (int i = 0, count = melodies.Count; i < count; ++i)
{
newSheet.MelodyDiagrams.Add(melodies[i].GetModel());
}
for (int i = 0, count = labels.Count; i < count; ++i)
{
newSheet.Labels.Add(labels[i].LabelField.text);
}
int numChildren = ScrollContainer.childCount;
for (int i = 0; i < numChildren; ++i)
{
Transform child = ScrollContainer.GetChild(i);
if (child.GetComponent <ChordDiagram>() != null)
{
newSheet.ElementTypesInt.Add((int)ElementType.Chord);
}
else if (child.GetComponent <MelodyDiagram>() != null)
{
newSheet.ElementTypesInt.Add((int)ElementType.Melody);
}
else if (child.GetComponent <LabelElement>() != null)
{
newSheet.ElementTypesInt.Add((int)ElementType.Label);
}
}
if (sheetCollection == null)
{
sheetCollection = ChordSheetCollection.Create();
}
int sheetIndex = sheetCollection.SheetNames.IndexOf(currentSheetName);
if (sheetIndex < 0)
{
sheetCollection.SheetNames.Add(currentSheetName);
sheetCollection.Sheets.Add(newSheet);
}
else
{
sheetCollection.Sheets[sheetIndex] = newSheet;
}
string sheetJson = JsonUtility.ToJson(sheetCollection);
WebRequestManager.PostData(sheetJson, OnSaveComplete);
}
