public List<CellName> Ho_Nrel_Get(IEnumerable<小区切换查询> cdd_nrel)
{
var nrelation = cdd_nrel.ToLookup(e => e.小区名);
List<CellName> nrel = new List<CellName>();
int thr = 0;
foreach (var n in nrelation)
{
var nreltop = n.OrderByDescending(e => e.切换次数);
foreach (var nn in nreltop)
{
thr++;
if (thr > 5) continue;
CellName cn = new CellName();
cn.Cell_name = n.Key;
cn.N_cell_name = nn.邻小区名;
cn.Handover = nn.切换次数;
nrel.Add(cn);
}
thr = 0;
}
foreach (var n in nrelation)
{
CellName cn = new CellName();
cn.Cell_name = n.Key;
cn.N_cell_name = n.Key;
nrel.Add(cn);
}
return nrel;
}
public List<CellName> Cdd_Nrel_Get(IEnumerable<现网cdd_Nrel> cdd_nrel)
{
List<CellName> nrel = new List<CellName>();
var nrelation = from p in cdd_nrel
select new { p.cell_name, p.n_cell_name };
var nnative = cdd_nrel.Select(e => e.cell_name).Distinct();
foreach (var n in nrelation)
{
CellName cn = new CellName();
cn.Cell_name = n.cell_name;
cn.N_cell_name = n.n_cell_name;
if (cn.Cell_name.Length > 2 && cn.N_cell_name.Length > 2)
{
if (cn.Cell_name.IndexOf(cn.N_cell_name.Substring(0, cn.N_cell_name.Length - 2)) != -1)
if (cn.Cell_name.Length == cn.N_cell_name.Length) //比较长度即可
nrel.Add(cn);
}
}
foreach (string n in nnative)
{
CellName cn = new CellName();
cn.Cell_name = n;
cn.N_cell_name = n;
nrel.Add(cn);
}
return nrel;
}
public List <CellName> Cdd_Nrel_Get(IEnumerable <现网cdd_Nrel> cdd_nrel)
{
List <CellName> nrel = new List <CellName>();
var nrelation = from p in cdd_nrel
select new { p.cell_name, p.n_cell_name };
var nnative = cdd_nrel.Select(e => e.cell_name).Distinct();
foreach (var n in nrelation)
{
CellName cn = new CellName();
cn.Cell_name = n.cell_name;
cn.N_cell_name = n.n_cell_name;
if (cn.Cell_name.Length > 2 && cn.N_cell_name.Length > 2)
{
if (cn.Cell_name.IndexOf(cn.N_cell_name.Substring(0, cn.N_cell_name.Length - 2)) != -1)
{
if (cn.Cell_name.Length == cn.N_cell_name.Length) //比较长度即可
{
nrel.Add(cn);
}
}
}
}
foreach (string n in nnative)
{
CellName cn = new CellName();
cn.Cell_name = n;
cn.N_cell_name = n;
nrel.Add(cn);
}
return(nrel);
}
public List <CellName> Ho_Nrel_Get(IEnumerable <小区切换查询> cdd_nrel)
{
var nrelation = cdd_nrel.ToLookup(e => e.小区名);
List <CellName> nrel = new List <CellName>();
int thr = 0;
foreach (var n in nrelation)
{
var nreltop = n.OrderByDescending(e => e.切换次数);
foreach (var nn in nreltop)
{
thr++;
if (thr > 5)
{
continue;
}
CellName cn = new CellName();
cn.Cell_name = n.Key;
cn.N_cell_name = nn.邻小区名;
cn.Handover = nn.切换次数;
nrel.Add(cn);
}
thr = 0;
}
foreach (var n in nrelation)
{
CellName cn = new CellName();
cn.Cell_name = n.Key;
cn.N_cell_name = n.Key;
nrel.Add(cn);
}
return(nrel);
}
public override int GetHashCode()
{
unchecked
{
int result = CellName.GetHashCode();
result = (result * 397) ^ Assemblies.GetHashCode();
result = (result * 397) ^ EntryPointTypeName.GetHashCode();
result = (result * 397) ^ SettingsXml.GetHashCode();
return(result);
}
}
/// <summary>
/// 对cell索引表达式进行计算
/// </summary>
/// <param name="data">数据</param>
/// <returns></returns>
public string CalculateCellName(object data)
{
var matches = Regex.Matches(CellName, @"\{\+([\w\s+.]+)\}");
if (matches.Count == 0)
{
return(CellName);
}
var length = CellName.Length;
int rowGrow = 0;
int colGrow = 0;
// 从cell表达式中获取原始cell坐标
foreach (Match item in matches)
{
CellName = CellName.Replace(item.Value, string.Empty);
}
var location = ExcelHandler.CellNameToLocation(CellName);
if (matches.Count == 1)
{
var match = matches[0];
var grow = RazorTemplateHelper.RunRazorSnippet <int>(match.Groups[1].Value, data);
if (matches[0].Length + matches[0].Index == length)
{
rowGrow = grow;
}
else
{
colGrow = grow;
}
}
else
{
if (matches.Count == 2)
{
colGrow = RazorTemplateHelper.RunRazorSnippet <int>(matches[0].Groups[1].Value, data);
rowGrow = RazorTemplateHelper.RunRazorSnippet <int>(matches[1].Groups[1].Value, data);
}
}
location.RowIndex += rowGrow;
location.ColumnIndex += colGrow;
return(ExcelHandler.LocationToCellName(location.ColumnIndex, location.RowIndex));
}
protected override IAsyncResult BeginExecute(AsyncCodeActivityContext context, AsyncCallback callback, object state)
{
PropertyDescriptor property = context.DataContext.GetProperties()[ExcelCreate.GetExcelAppTag];
Excel::Application excelApp = property.GetValue(context.DataContext) as Excel::Application;
try
{
Int32 cellColumn = CellColumn.Get(context);
Int32 cellRow = CellRow.Get(context);
string cellName = CellName.Get(context);
string sheetName = SheetName.Get(context);
Excel::_Worksheet sheet;
if (sheetName == null)
{
sheet = excelApp.ActiveSheet;
}
else
{
sheet = excelApp.ActiveWorkbook.Sheets[sheetName];
}
object cellContent = null;
if (cellName == null)
{
cellContent = sheet.Cells[cellRow, cellColumn].Value2;
}
else
{
cellContent = sheet.Range[cellName].Value2;
}
CellContent.Set(context, cellContent);
System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet);
sheet = null;
GC.Collect();
}
catch (Exception e)
{
SharedObject.Instance.Output(SharedObject.enOutputType.Error, "EXCEL获取单元格内容出错", e.Message);
new CommonVariable().realaseProcessExit(excelApp);
}
m_Delegate = new runDelegate(Run);
return(m_Delegate.BeginInvoke(callback, state));
}
async void LoadTableFuctionality()
{
DidInitiliseSource = false;
try
{
loadingOverlay = new LoadingOverlay(UIScreen.MainScreen.Bounds);
View.Add(loadingOverlay);
ParseQuery <ParseObject> query = ParseObject.GetQuery("Coffees");
query.Include("Title").Include("Price").Include("ImageName");
var iEnumerableColl = await query.FindAsync();
foreach (ParseObject coffeeElements in iEnumerableColl)
{
string coffeeName = coffeeElements.Get <string>("Title");
string imageName = coffeeElements.Get <string>("ImageName");
double price = coffeeElements.Get <double>("Price");
coffeeItems.Add(new Coffee(coffeeName, imageName, "" + price));
}
loadingOverlay.Hide();
}
catch (ParseException)
{
loadingOverlay.Hide();
AlertPopUp("Error", "Connection error", "OK");
}
Source = new TableSourceOrdering(coffeeItems);
Source.Voucher = VouchersLabel.Text;
Source.Launched = true;
Source.Ordered = false;
Source.GetInitialVoucher = VouchersLabel.Text;
ordersTable.Source = Source;
ordersTable.ReloadData();
DidInitiliseSource = true;
Source.onCellForOrderName += (sender, e) =>
{
CellName = e;
};
Source.onCellSelectedForVouchers += (sender, e) =>
{
VoucherCount.Voucher = e;
VoucherCount.IsSelected = true;
VoucherCount.IsDeselected = false;
VoucherCount.VoucherChange();
VouchersLabel.Text = "" + VoucherCount.GetVoucher() + " Vouchers";
Source.Voucher = VouchersLabel.Text;
if (!VoucherCount.IsVoucherDepleted)
{ // tag all the orders purchased by vouchers
taggedOrders.Add(new TagOrder(CellName));
taggedOrderNamesForPrice.Add(CellName);
}
};
Source.onCellDeselectedForVouchers += (sender, e) =>
{
//increments voucher if its a tagged order
VoucherCount.HasTag = false;
foreach (TagOrder order in taggedOrders)
{
//if (!NamesOfTaggedOrders.Contains(order.OrderName)) NamesOfTaggedOrders += order.OrderName + "*";
if (order.OrderName.Equals(CellName))
{
Debug.WriteLine(order.OrderName);
NamesOfTaggedOrders = order.OrderName;
taggedOrders.Remove(order);
VoucherCount.HasTag = true;
break;
}
}
if (PriceCount.Depleted)
{
VoucherCount.IsDeselected = true;
VoucherCount.IsSelected = false;
VoucherCount.VoucherChange();
VouchersLabel.Text = "" + VoucherCount.GetVoucher() + " Vouchers";
Source.Voucher = VouchersLabel.Text;
}
else if (CellName.Equals(NamesOfTaggedOrders))
{
VoucherCount.IsDeselected = true;
VoucherCount.IsSelected = false;
VoucherCount.VoucherChange();
VouchersLabel.Text = "" + VoucherCount.GetVoucher() + " Vouchers";
Source.Voucher = VouchersLabel.Text;
}
NamesOfTaggedOrders = string.Empty;
};
Source.onCellSelectedForPrice += (sender, e) =>
{
if (VoucherCount.IsVoucherDepleted)
{
PriceCount.Price = e;
PriceCount.Selected = true;
PriceCount.Deselected = false;
PriceCount.PriceChange();
costText.Text = PriceCount.GetPrice().ToString("R 0.00");
}
};
Source.onCellDeselectedForPrice += (sender, e) =>
{
const int VOUCHER_BEFORE_EXECUTION_TO_ZERO = 1;
if (VoucherCount.IsVoucherDepleted && VoucherCount.Voucher != VOUCHER_BEFORE_EXECUTION_TO_ZERO)
{
PriceCount.Price = e;
PriceCount.Selected = false;
PriceCount.Deselected = true;
PriceCount.PriceChange();
costText.Text = PriceCount.GetPrice().ToString("R 0.00");
}
else if (VoucherCount.GetVoucher() != 0 && !VoucherCount.HasTag)
{
PriceCount.Price = e;
PriceCount.Selected = false;
PriceCount.Deselected = true;
PriceCount.PriceChange();
costText.Text = PriceCount.GetPrice().ToString("R 0.00");
}
};
}
private string GetStringCellData(CellName myCellName, ICell myCell)
{
return(GetStringCellDataCore(myCellName.ToString(), myCell));
}
