public void FindDataFromUserName(string userName)
{
Datas.Clear();
List <DeviceUserSqliteObject> datas = new List <DeviceUserSqliteObject>();
SQLiteCommand cmdInsert = new SQLiteCommand(conn);
cmdInsert.CommandText = string.Format("SELECT * FROM {0} ", TableName);
cmdInsert.ExecuteNonQuery();
SQLiteDataReader dataReader = cmdInsert.ExecuteReader();
while (dataReader.Read())
{
var userFindStr = dataReader["UserName"].ToString();
if (userFindStr == userName)
{
datas.Add(new DeviceUserSqliteObject()
{
UserName = dataReader["UserName"].ToString(),
MaterialName = dataReader["MaterialName"].ToString(),
TypeName = dataReader["TypeName"].ToString(),
QualityFlow = dataReader["QualityFlow"].ToString(),
Density = dataReader["Density"].ToString(),
Temperature = dataReader["Temperature"].ToString(),
TotalAmount = dataReader["TotalAmount"].ToString(),
Goal = dataReader["Goal"].ToString(),
Real = dataReader["Real"].ToString(),
Date = dataReader["Date"].ToString(),
StartTime = dataReader["StartTime"].ToString(),
EndTime = dataReader["EndTime"].ToString(),
});
}
}
Datas = datas;
}
public SalesOrderViewModel(PenjualanAndOrderModel order)
{
_orderParameter = order;
LoadItemsCommand = new Command(async() => await ExecuteLoadItemsCommand());
SaveCommand = new Command(SaveAction, CanSaved);
ClearCommand = new Command(() => {
Datas.Clear();
SelectedIndex = -1;
Title = "Create Order";
Order = new OrderPenjualan {
OrderDate = DateTime.Now
};
Order.DeadLine = 12;
RefreshProductStock();
});
QRCommand = new Command(async() => {
var vm = new InputBarcodeViewModel();
vm.OnResultScanHandler += Vm_OnResultScanHandler;
var form = new InputBarcodeView()
{
BindingContext = vm
};
await Shell.Current.Navigation.PushModalAsync(form);
});
AddCommand = new Command(async() => await ExecuteLoadItemsCommand());
Datas.CollectionChanged += Datas_CollectionChanged;
DeleteCommand = new Command(DeleteAction);
this.PropertyChanged += SalesOrderViewModel_PropertyChanged;
InitAsync(order);
}
public void Initialization()
{
List <CostModel> costs = DbWorker.Current.GetCosts();
AllCosts = costs.Sum(c => c.Cost);
Datas.Clear();
foreach (var category in MainViewModel.Current.Categories)
{
var costsByCategory = costs.Where(c => c.CategoryId == category.Id);
if (costsByCategory.Count() > 0)
{
double sumInCategory = costsByCategory.Sum(c => c.Cost);
Datas.Add(
new DataDiagramViewModel
{
Value = (sumInCategory / AllCosts) * 100,
Color = category.Color,
Title = category.Title
});
}
}
}
public async void Navigated(string fromEndpoint, object data)
{
//DataFile file = new DataFile("subjects.xml");
//classList = await file.LoadClassInfoAsync();
string datapath = System.IO.Path.Combine(".", "Data");
if (!System.IO.Directory.Exists(datapath))
{
System.IO.Directory.CreateDirectory(datapath);
}
manager = new DataManager(datapath);
isContinuable.IsEnabled = false;
Datas.Clear();
foreach (var i in manager.GetFiles())
{
if (!i.IsValid)
{
continue;
}
ClassInfoList infos = await i.LoadClassInfoAsync();
//lst_databases.Items.Add(String.Format("{1} {2} ({0})", i.Info.Name, i.School, i.When));
Datas.Add(i);
}
}
private async Task ExecuteLoadItemsCommand()
{
try
{
await Task.Delay(50);
Datas.Clear();
foreach (var item in Order.Items)
{
var newData = new ItemPenjualanModel()
{
Amount = item.Amount,
Units = new ObservableCollection <Unit>(item.Product.Units),
Product = item.Product,
ProductId = item.ProductId,
Unit = item.Unit,
UnitId = item.UnitId,
Real = 0
};
Datas.Add(newData);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
finally
{
IsBusy = false;
}
}
/// <summary>
/// Button_2_Click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button_2_Click(object sender, RoutedEventArgs e)
{
Debug.WriteLine("Button_2_Click");
// Clear the list
Datas.Clear();
}
/******************************/
/* Menu Events */
/******************************/
#region Menu Events
#endregion
/******************************/
/* Other Events */
/******************************/
#region Other Events
#endregion
/******************************/
/* Other Functions */
/******************************/
#region Other Functions
/// <summary>
/// ReFillList
/// </summary>
/// <param name="ls"></param>
private void ReFillList(ObservableCollection <Data> ls)
{
Datas.Clear();
foreach (var i in ls)
{
Datas.Add(i);
}
}
public void Init(RpcContext context)
{
Datas.Clear();
Error = null;
ReturnType = null;
ReturnValue = null;
RpcContext = context;
}
private void Snoop(object obj)
{
Datas.Clear();
Task.Factory.StartNew(() =>
{
Collector.Stream(Datas, obj);
}, System.Threading.CancellationToken.None, TaskCreationOptions.None, TaskScheduler.FromCurrentSynchronizationContext());
}
//--------------------------------------------------------------------------
public GraphNode(GraphNodeItem nodeItem)
{
m_nodeItem = nodeItem;
nodeItem.PropertyChanged += (e, args) =>
{
if (args.PropertyName == "IsFilterMatched")
{
Opacity = nodeItem.IsFilterMatched ? 1.0 : 0.2;
IsEnabled = nodeItem.IsFilterMatched ? true : false;
RaisePropertyChangedEvent("Opacity");
}
else if (args.PropertyName == "X" || args.PropertyName == "Y")
{
RaisePropertyChangedEvent("X");
RaisePropertyChangedEvent("Y");
RaisePropertyChangedEvent("CanvasX");
RaisePropertyChangedEvent("CanvasY");
RaisePropertyChangedEvent("Position");
}
else if (args.PropertyName == "GraphData")
{
Datas.Clear();
UpdateGraphData();
RaisePropertyChangedEvent("Datas");
}
};
AllowDrop = true;
DataContext = this;
PropertyChangedEventHandler func = (e, args) => { RaisePropertyChangedEvent("Child " + args.PropertyName); };
Datas.CollectionChanged += (e, args) =>
{
foreach (GraphNodeData item in m_dataCache)
{
item.PropertyChanged -= func;
item.Node = null;
}
foreach (GraphNodeData item in Datas)
{
item.Node = this;
item.PropertyChanged += func;
}
m_dataCache.Clear();
m_dataCache.AddRange(Datas);
};
Application.Current.Dispatcher.BeginInvoke(System.Windows.Threading.DispatcherPriority.Normal, new Action(() => { UpdateGraphData(); }));
}
public void PageChanged()
{
//加载标本数据
var list = PbSamplinglesion.Search(_currentPageIndex, _pageSize, out long PageCount);
Datas.Clear();
foreach (var item in list)
{
Datas.Add(item);
}
}
public void NowDataWriteToBuff()
{
writeIdx = 0;
Datas.Clear();
WriteVec(CameraPos);
WriteVec(CameraParams);
WriteColor(Ambient);
WriteVec(LightPos);
WriteColor(LightColor);
WriteVec(LightItensity);
WriteVec(LightParams1);
}
private IEnumerator StartAnimationImpl(List <FloatAnimationData> datas)
{
if (isWaitingForStart)
{
yield break;
}
if (IsStarted)
{
isWaitingForStart = true;
}
yield return(new WaitUntil(() => false == IsStarted));
isWaitingForStart = false;
if (!IsStarted)
{
Datas.Clear();
foreach (var data in datas)
{
Datas.Add(new BosFloatAnimationInfo {
Data = data,
Direction = BosAnimationDirection.Forward
});
}
timer = 0f;
easeFuncs.Clear();
events.Clear();
for (int i = 0; i < Datas.Count; i++)
{
easeFuncs.Add(AnimUtils.GetEaseFunc(Datas[i].Data.EaseType));
List <AnimationEventInfo <float> > dataEvents = new List <AnimationEventInfo <float> >();
if (Datas[i].Data.Events != null)
{
foreach (AnimationEvent <float> evt in Datas[i].Data.Events)
{
dataEvents.Add(new AnimationEventInfo <float> {
Event = evt,
IsCompleted = false
});
}
}
events.Add(dataEvents);
}
isStartedStatus.Clear();
for (int i = 0; i < Datas.Count; i++)
{
isStartedStatus.Add(true);
}
Datas.ForEach(d => d.Data.OnStart?.Invoke(d.Data.StartValue, d.Data.Target));
}
}
public virtual bool RemoveAll()
{
foreach (var item in Datas.Values)
{
item.Dispose();
}
Datas.Clear();
Event.Notify(EventCall, new ModelEventArgs <T>()
{
Status = ModelStatus.RemoveAll
});
return(true);
}
//private BosAnimationDirection direction = BosAnimationDirection.Forward;
public void Stop()
{
foreach (var data in Datas)
{
data.Data.OnEnd?.Invoke(data.Data.EndValue, data.Data.Target);
}
Datas.Clear();
for (int i = 0; i < isStartedStatus.Count; i++)
{
isStartedStatus[i] = false;
}
isStartedStatus.Clear();
}
public void LoadClick()
{
var x = ViewModelDesignEditor.Get(file, _vmlayout, view);
if (x.Any())
{
Datas.Clear();
x.ForEach(z => Datas.Add(z));
OnPropertyChanged("Datas");
ClearClick();
}
}
public void FindDataFromTime(DateTime startTime, DateTime endTime)
{
Datas.Clear();
List <DeviceUserSqliteObject> datas = new List <DeviceUserSqliteObject>();
SQLiteCommand cmdInsert = new SQLiteCommand(conn);
cmdInsert.CommandText = string.Format("SELECT * FROM {0} ", TableName);
cmdInsert.ExecuteNonQuery();
SQLiteDataReader dataReader = cmdInsert.ExecuteReader();
while (dataReader.Read())
{
var timeFindStr = dataReader["StartTime"].ToString();
DateTime time;
if (DateTime.TryParseExact(timeFindStr, "yyyy/MM/dd HH:mm:ss",
System.Globalization.CultureInfo.CurrentCulture,
System.Globalization.DateTimeStyles.NoCurrentDateDefault, out time) == false)
{
continue;
}
if (time >= startTime && time <= endTime)
{
datas.Add(new DeviceUserSqliteObject()
{
UserName = dataReader["UserName"].ToString(),
MaterialName = dataReader["MaterialName"].ToString(),
TypeName = dataReader["TypeName"].ToString(),
QualityFlow = dataReader["QualityFlow"].ToString(),
Density = dataReader["Density"].ToString(),
Temperature = dataReader["Temperature"].ToString(),
TotalAmount = dataReader["TotalAmount"].ToString(),
Goal = dataReader["Goal"].ToString(),
Real = dataReader["Real"].ToString(),
Date = dataReader["Date"].ToString(),
StartTime = dataReader["StartTime"].ToString(),
EndTime = dataReader["EndTime"].ToString(),
});
}
}
Datas = datas;
}
public void ApplyFilter(DateTime startDate, DateTime endDate)
{
var costs = DbWorker.Current.GetCosts().Where(c => DateUtility.GetLocalTimeFromUTCMilliseconds(c.Date) > startDate && DateUtility.GetLocalTimeFromUTCMilliseconds(c.Date) < endDate);
Datas.Clear();
foreach (var category in MainViewModel.Current.Categories)
{
var tempCosts = costs.Where(c => c.CategoryId == category.Id);
if (tempCosts.Count() > 0)
{
double sumInCategory = tempCosts.Sum(c => c.Cost);
Datas.Add(
new DataDiagramViewModel
{
Value = (sumInCategory / AllCosts) * 100,
Color = category.Color,
Title = category.Title
});
}
}
}
public void Clear()
{
Datas.Clear();
CallUpdate();
}
public void Clear()
{
Datas.Clear();
}
