protected void Initialize()
{
this.Title = "Vici Cool Storage";
// performance timing
System.Diagnostics.Stopwatch stopwatch = new System.Diagnostics.Stopwatch();
stopwatch.Start();
string dbName = "db_viciCoolStorage.db3";
// check the database, if it doesn't exist, create it
this.CheckAndCreateDatabase(dbName);
// performance timing
Console.WriteLine("database creation: " + stopwatch.ElapsedMilliseconds.ToString());
// query a list of people from the db
people = Person.List();
// performance timing
Console.WriteLine("database query: " + stopwatch.ElapsedMilliseconds.ToString());
// create a new table source from our people collection
tableSource = new BasicOperations.TableSource(people);
// initialize the table view and set the source
this.TableView = new UITableView()
{
Source = tableSource
};
}
public void Serialization()
{
DeleteData();
SetupTestData();
Customer customer = Customer.New();
customer.Name = "Test";
customer.Save();
CSList <Customer> customers = new CSList <Customer>();
int nCustomers = customers.Count;
Customer refCustomer = customers[nCustomers - 1];
using (Stream stream = new MemoryStream())
{
BinaryFormatter formatter = new BinaryFormatter();
formatter.Serialize(stream, customer);
formatter.Serialize(stream, customers);
stream.Seek(0, SeekOrigin.Begin);
customer = (Customer)formatter.Deserialize(stream);
customers = (CSList <Customer>)formatter.Deserialize(stream);
}
Assert.AreEqual("Test", customer.Name);
Assert.AreEqual(nCustomers, customers.Count);
Assert.AreEqual(refCustomer, customers[nCustomers - 1]);
}
public void ListPredicates()
{
DeleteData();
Customer customer = Customer.New();
customer.Name = "Philippe";
customer.Save();
customer = Customer.New();
customer.Name = "Dirk";
customer.Save();
customer = Customer.New();
customer.Name = "Paul";
customer.Save();
CSList <Customer> customers = Customer.List().FilteredBy(delegate(Customer c) { return(c.Name.StartsWith("P")); });
Assert.AreEqual(2, customers.Count);
customers = customers.FilteredBy(delegate(Customer c) { return(c.Name.EndsWith("e")); });
Assert.AreEqual(1, customers.Count);
}
public void Paging()
{
DeleteData();
for (int i = 1; i <= 70; i++)
{
Customer customer = Customer.New();
Order order = Order.New();
customer.Name = "Customer" + i.ToString("0000");
customer.Save();
order.Customer = customer;
order.OrderItems.Add(OrderItem.New("test", 4, 10));
order.Save();
}
CSList <Order> orders;
CSList <Customer> customers = Customer.OrderedList("Name").Range(11, 10);
Assert.AreEqual(10, customers.Count);
Assert.AreEqual("Customer0011", customers[0].Name);
Assert.AreEqual("Customer0020", customers[9].Name);
orders = Order.OrderedList("Customer.Name , OrderID").Range(51, 10);
Assert.AreEqual(10, orders.Count);
Assert.AreEqual("Customer0051", orders[0].Customer.Name);
Assert.AreEqual("Customer0060", orders[9].Customer.Name);
}
public LocalRegistScoreViewModel()
{
try
{
_tourService = Resolver.Resolve <ITourService>();
_commonFun = Resolver.Resolve <ICommonFun>();
_commonHelper = Resolver.Resolve <CommonHelper>();
_localScoreService = Resolver.Resolve <ILocalScoreService>();
_remoteService = Resolver.Resolve <IRemoteService>();
_tapCommand = new Command(ImageTaped);
MessagingCenter.Subscribe <LocalRegistScorePage>(this, "CheckBoxChanged", (obj) =>
{
if (CSList.Any(p => p.IsCheck == true))
{
CurrentScore = "0";
CurrentSystem.Score = 0;
}
else
{
CurrentScore = "1";
CurrentSystem.Score = 1;
}
});
MessagingCenter.Subscribe <StandardPic>(this, "DeleteLossImage", (obj) =>
{
//删除失分照片
DeleteImage(obj);
});
MessagingCenter.Subscribe <PictureStandard>(this, "RegistScoreItemTapped", (obj) =>
{
UploadStandPic(obj.StandardPicId);
});
MessagingCenter.Subscribe <PictureStandard>(this, "PreviewPlanAttechment", (obj) =>
{
if (!string.IsNullOrEmpty(obj.Url))
{
PreviewStanderImage(obj.Url);
}
});
MessagingCenter.Subscribe <PictureStandard>(this, "DeletePlanAttechment", (obj) =>
{
if (!string.IsNullOrEmpty(obj.Url))
{
DeleteStanderImage(obj);
}
});
}
catch (Exception)
{
_commonFun.AlertLongText("操作异常,请重试。-->CustImproveViewModel");
return;
}
}
public void RandomCreation()
{
DeleteData();
Random rnd = new Random();
Customer cust = Customer.New();
cust.Name = "Blabla";
double total = 0.0;
for (int i = 0; i < 5; i++)
{
Order order = Order.New();
order.Customer = cust;
for (int j = 0; j < 20; j++)
{
int qty = rnd.Next(1, 10);
double price = rnd.NextDouble() * 500.0;
order.OrderItems.Add(OrderItem.New("test", (short)qty, price));
total += qty * price;
}
order.Save();
}
CSList <Order> orders = new CSList <Order>();
Assert.AreEqual(5, orders.Count);
double total2 = Convert.ToDouble(OrderItem.GetScalar("Qty*Price", CSAggregate.Sum));
Assert.AreEqual(total, total2, 0.000001);
foreach (Order order in orders)
{
Assert.AreEqual(cust, order.Customer);
Assert.AreEqual(20, order.OrderItems.Count);
Assert.AreEqual(cust.Name, order.Customer.Name);
order.OrderItems[rnd.Next(0, 19)].Delete();
Assert.AreEqual(19, order.OrderItems.Count);
}
total2 = Convert.ToDouble(OrderItem.GetScalar("Qty*Price", CSAggregate.Sum));
if (total <= total2)
{
Assert.Fail();
}
Assert.AreEqual(95, new CSList <OrderItem>().Count);
}
private void Open()
{
var mdlg = new OpenFileDialog();
mdlg.CheckFileExists = true;
mdlg.Multiselect = false;
mdlg.Filter = "Tvtest channel file(*.ch2)|*.ch2|All file(*.*)|*.*";
if (mdlg.ShowDialog() == true)
{
foreach (var item in Ch2.ReadChe2File(mdlg.FileName))
{
switch (item.Type)
{
case CHType.GR:
if (!GRList.Any(x => x.ServiceID == item.ServiceID))
{
GRList.Add(new ChannelViewModel(item));
}
break;
case CHType.BS:
if (!BSList.Any(x => x.ServiceID == item.ServiceID))
{
BSList.Add(new ChannelViewModel(item));
}
break;
case CHType.CS:
if (!CSList.Any(x => x.ServiceID == item.ServiceID))
{
CSList.Add(new ChannelViewModel(item));
}
break;
default:
if (!SKList.Any(x => x.ServiceID == item.ServiceID))
{
SKList.Add(new ChannelViewModel(item));
}
break;
}
}
GRList.Sort((x, y) => x.Channel == y.Channel ? x.ServiceID.CompareTo(y.ServiceID) : x.Channel.CompareTo(y.Channel));
BSList.Sort((x, y) => x.Channel == y.Channel ? x.ServiceID.CompareTo(y.ServiceID) : x.Channel.CompareTo(y.Channel));
CSList.Sort((x, y) => x.Channel == y.Channel ? x.ServiceID.CompareTo(y.ServiceID) : x.Channel.CompareTo(y.Channel));
SKList.Sort((x, y) => x.Channel == y.Channel ? x.ServiceID.CompareTo(y.ServiceID) : x.Channel.CompareTo(y.Channel));
ChannelList = new ObservableCollection <ChannelViewModel>(GRList.Concat(BSList).Concat(CSList).Concat(SKList));
this.isSaved = false;
this.NotifyPropertyChanged(nameof(this.Caption));
}
else
{
return;
}
}
static void Main(string[] args)
{
CSList <Contact> contacts = new CSList <Contact>();
//add contacts to the list
var x = from c in contacts
select new {
c.Id,
c.Name
ContactTypeName = c.ContactType.Name
};
}
}
public void OrderBy()
{
Order.List().DeleteAll();
Order order;
order = Order.New();
order.Customer = Customer.New();
order.Customer.Name = "Alain";
order.OrderDate = new DateTime(2005, 1, 10);
order.Save();
order = Order.New();
order.Customer = Customer.New();
order.Customer.Name = "Luc";
order.OrderDate = new DateTime(2005, 1, 6);
order.Save();
order = Order.New();
order.Customer = Customer.New();
order.Customer.Name = "Gerard";
order.OrderDate = new DateTime(2005, 1, 8);
order.Save();
CSList <Order> orders = Order.List();
orders.OrderBy = "OrderDate";
Assert.AreEqual(new DateTime(2005, 1, 6), orders[0].OrderDate);
Assert.AreEqual(new DateTime(2005, 1, 10), orders[2].OrderDate);
orders = new OrderCollection();
orders.OrderBy = "Customer.Name";
Assert.AreEqual(orders[0].Customer.Name, "Alain");
Assert.AreEqual(orders[2].Customer.Name, "Luc");
CSList <OrderItem> orderItems = new CSList <OrderItem>("Order.Customer.Name=''").OrderedBy("Order.Customer.Name");
Assert.AreEqual(0, orderItems.Count);
Assert.AreEqual("Luc", Order.GetScalar("Customer.Name", CSAggregate.Max, "Customer.Name<>'Alain'"));
Assert.AreEqual("Alain", Order.GetScalar("Customer.Name", CSAggregate.Min));
#if !SQLITE
Assert.AreEqual(new DateTime(2005, 1, 10), Order.GetScalar <DateTime>("OrderDate", CSAggregate.Max));
Assert.AreEqual(new DateTime(2005, 1, 6), Order.GetScalar <DateTime>("OrderDate", CSAggregate.Min));
#endif
}
// This method checks to see if the database exists, and if it doesn't, it creates
// it and inserts some data. It also sets our database to be the default database
// connection.
protected void CheckAndCreateDatabase(string dbName)
{
// determine whether or not the database exists
bool dbExists = File.Exists(GetDBPath(dbName));
// configure the current database, create if it doesn't exist, and then run the anonymous
// delegate method after it's created
CSConfig.SetDB(GetDBPath(dbName), SqliteOption.CreateIfNotExists, () => {
CSDatabase.ExecuteNonQuery("CREATE TABLE People (PersonID INTEGER PRIMARY KEY AUTOINCREMENT, FirstName text, LastName text)");
// if the database had to be created, let's populate with initial data
if (!dbExists)
{
// declare vars
CSList <Person> people = new CSList <Person> ();
Person person;
// create a list of people that we're going to insert
person = new Person()
{
FirstName = "Peter", LastName = "Gabriel"
};
people.Add(person);
person = new Person()
{
FirstName = "Thom", LastName = "Yorke"
};
people.Add(person);
person = new Person()
{
FirstName = "J", LastName = "Spaceman"
};
people.Add(person);
person = new Person()
{
FirstName = "Benjamin", LastName = "Gibbard"
};
people.Add(person);
// save the people collection to the database
people.Save();
}
});
}
public void Paging2()
{
Customer customer = Customer.New();
customer.Name = "Customer";
customer.Save();
for (int i = 1; i <= 5; i++)
{
Order order = Order.New();
order.Customer = customer;
order.OrderItems.Add(OrderItem.New("test", 4, 10));
order.Save();
}
CSList <Order> orders = Order.List("has(OrderItems where Qty > 1)").OrderedBy("OrderID").Range(2, 2);
Assert.AreEqual(2, orders.Count);
}
public void ManyToOne()
{
SetupTestData();
Customer customer = new CSList <Customer>()[0];
SalesPerson salesPerson = SalesPerson.New();
salesPerson.Name = "Test";
salesPerson.Save();
Order order = Order.New();
order.SalesPerson = null;
order.Customer = customer;
order.Save();
int id = order.OrderID;
order = Order.Read(id);
Assert.AreEqual(order.Customer, customer);
order.SalesPerson = salesPerson;
order.Save();
order = Order.Read(id);
Assert.AreEqual(salesPerson, order.SalesPerson);
order.SalesPerson = null;
order.Save();
order = Order.Read(id);
Assert.IsNull(order.SalesPerson);
Assert.IsNull(order.SalesPersonID);
}
public TableSource(CSList <Person> items) : base()
{
this.items = items;
}
public void DeleteFromCollections()
{
Order order = Order.New();
order.Customer = Customer.New();
order.Customer.Name = "me";
for (int i = 0; i < 100; i++)
{
OrderItem item = order.OrderItems.AddNew();
item.Description = "test" + (i + 1);
item.Price = i;
item.Qty = (short)i;
}
order.Save();
order = Order.Read(order.OrderID);
Assert.AreEqual(order.OrderItems.Count, 100);
foreach (OrderItem item in order.OrderItems)
{
if ((item.Qty % 5) == 0)
{
item.MarkForDelete();
}
}
order.Save();
Assert.AreEqual(order.OrderItems.Count, 80);
order = Order.Read(order.OrderID);
Assert.AreEqual(order.OrderItems.Count, 80);
CSList <OrderItem> items = new CSList <OrderItem>(order.OrderItems);
items.AddFilter("Qty < 50");
Assert.AreEqual(40, items.Count);
items.DeleteAll();
order = Order.Read(order.OrderID);
Assert.AreEqual(40, order.OrderItems.Count);
order.OrderItems.AddFilter("Qty >= 80");
Assert.AreEqual(16, order.OrderItems.Count);
order.OrderItems.DeleteAll();
Assert.AreEqual(0, order.OrderItems.Count);
order = Order.Read(order.OrderID);
Assert.AreEqual(24, order.OrderItems.Count);
}
public TableSource(UIViewController ctrl, CSList <AmazonProductInfo> items)
{
mTableItems = items;
mParentViewController = ctrl;
}
