public string SetPoint(string id, int rate) { double Rate = double.Parse(db.GetPoint(id)); int count = db.GetCount(id); double currentRate = (Rate * (db.GetCount(id) - 1) + rate) / db.GetCount(id); db.PointSet(currentRate, id); db.UpdateCount(id, count); return(currentRate.ToString()); }
public void InsertOrder(ListView listview1, ListView listview2, int num, string UID) { time = Gettime(); foreach (ListViewItem var in listview1.Items) { int count = 0; order = new ListViewItem(); if (var.Selected) { if (listview2.Items.Count > 0) { foreach (ListViewItem item in listview2.Items) { if (item.SubItems[1].Text == var.SubItems[1].Text) { int temp = int.Parse(item.SubItems[3].Text); temp += num; item.SubItems[3].Text = temp.ToString(); int fnum = db.GetCount(int.Parse(var.SubItems[0].Text.ToString())); db.UpdateCount(int.Parse(var.SubItems[0].Text), (fnum + num)); count = 1; } } if (count == 0) { db.InsertOrder(UID, var.SubItems[1].Text, num, var.SubItems[2].Text, time); listview2.Items.Clear(); db.GetOrder(UID, listview2); } } else { db.InsertOrder(UID, var.SubItems[1].Text, num, var.SubItems[2].Text, time); db.UpdateCount(int.Parse(var.SubItems[0].Text), db.GetCount(int.Parse(var.SubItems[0].Text)) + num); listview2.Items.Clear(); db.GetOrder(UID, listview2); } } } }