public string Get_FTP_fileContent_inStr()
{
Sheet sheet = new Sheet();
Line l1 = new Line();
l1.Add(" ");
if (this.ftpServerTP == FTPserverType.Production)
{
l1.Add('P');
}
else if (this.ftpServerTP == FTPserverType.Testing)
{
l1.Add('T');
}
l1.Add("PASSWD");
l1.Add("01");
l1.Add("02");
l1.Add(new string(' ', 6));
l1.Add(new string(' ', 8));
l1.Add(this.ftp_UID.Substring(0, 5), 5);
l1.Add('-');
l1.Add(this.ftp_UID.Substring(5), 3);
l1.Add(this.data_pwd, 8, leftJustified: true);
l1.Add(this.DTCfunc, 6);
l1.Add(++DTC_request_file.transNum % 10000, 4);
Cell recordLen_cell = l1.Add(120, 5);//need change in the future
Line l2 = new Line();
l2.Add("TD");//request type
l2.Add(this.DTCfunc, 6);
l2.Add("01");
l2.Add(this.headerTP, 3);
if (this.GU_selCir == GroupUserSelCirteria.ALL)
{
l2.Add("All", 3);
}
else if (this.GU_selCir == GroupUserSelCirteria.Single)
{
l2.Add("001", 3);
l2.Add(this.GroupUserParticipantNum, 5);
}
sheet.Add(l1);
sheet.Add(l2);
recordLen_cell.SetOriVal(sheet.Length);
return(sheet.GetContent());
}
public void DropElement(SymbolBaseViewModel symbolBaseViewModel)
{
if (symbolBaseViewModel is BlockViewModel)
{
var blockViewModel = (BlockViewModel)symbolBaseViewModel;
var blockSymbol = _sheet.CreateBlockSymbol();
blockSymbol.PositionX = blockViewModel.X;
blockSymbol.PositionY = blockViewModel.Y;
SymbolVms.Remove(_ghost);
_ghost = null;
_sheet.Add(blockSymbol, _client);
}
else if (symbolBaseViewModel is ConnectorViewModel)
{
var connectorViewModel = (ConnectorViewModel)symbolBaseViewModel;
var connector = _sheet.CreateConnector();
connector.PositionX = connectorViewModel.X;
connector.PositionY = connectorViewModel.Y;
SymbolVms.Remove(_ghost);
_ghost = null;
_sheet.AddConnector(connector, _client);
}
}
/// <summary>
/// Import the data from the Spreadsheet
/// </summary>
/// <returns>Returns a list of JObjects</returns>
public virtual List <ExcelCell> Import(bool ignoreRowWithEmptyCells = false)
{
if (Workbook == null)
{
throw new MissingMemberException("Missing Workbook");
}
var sheet = Workbook.Worksheets.FirstOrDefault();
if (sheet == null)
{
throw new MissingMemberException("No sheet found");
}
for (int i = sheet.Dimension.Start.Row; i <= sheet.Dimension.End.Row; i++)
{
for (int j = sheet.Dimension.Start.Column; j <= sheet.Dimension.End.Column; j++)
{
ExcelCell cell = null;
if (ignoreRowWithEmptyCells)
{
if (sheet.Cells[i, j].Value != null && !string.IsNullOrEmpty(sheet.Cells[i, j].Value.ToString()))
{
continue;
}
else
{
cell = new ExcelCell {
CellName = sheet.Cells[i, j].Address, CellValue = sheet.Cells[i, j].Value
};
}
}
else
{
cell = new ExcelCell {
CellName = sheet.Cells[i, j].Address, CellValue = sheet.Cells[i, j].Value
};
}
try
{
Sheet.Add(cell);
}
catch (Exception ex)
{
ErrorList.AddError(new ValidationErrorItem
{
Location = sheet.Cells[i, j].Address,
Row = i,
Exception = ex
});
}
}
rowCount++;
}
return(Sheet);
}
private void AddDay(object sender, EventArgs e)
{
Sheet s = this.BindingContext as Sheet;
Day d = new Day();
d.Muscle = "Muscle";
d.DayFrequency = 1;
s.Add(d);
}
/// <summary>
/// Creates an empty GBA.TileSheet with the given dimensions
/// </summary>
public TileSheet(int width, int height) : base(width * height)
{
Width = width;
Height = height;
for (int i = 0; i < width * height; i++)
{
Sheet.Add(null);
}
}
public static Sheet Load(Texture2D texture, string data)
{
Sheet sheet = new Sheet(texture);
using (StringReader reader = new StringReader(data))
{
string line;
while ((line = reader.ReadLine()) != null)
{
if (line.StartsWith("#", true, CultureInfo.InvariantCulture) || string.IsNullOrEmpty(line.Trim()))
{
continue;
}
string[] s = line.Split(';');
string name = s[0];
Rectangle source = new Rectangle(int.Parse(s[2], CultureInfo.InvariantCulture), int.Parse(s[3], CultureInfo.InvariantCulture), int.Parse(s[4], CultureInfo.InvariantCulture), int.Parse(s[5], CultureInfo.InvariantCulture));
Origin origin = new Origin(float.Parse(s[8], CultureInfo.InvariantCulture), float.Parse(s[9], CultureInfo.InvariantCulture));
bool isRotated = (int.Parse(s[1], CultureInfo.InvariantCulture) == 1);
sheet.Add(name, new Sprite(sheet, source, origin, isRotated));
}
}
return(sheet);
}
