public CreditClass SelectById(CreditClass model) { //修改 string sql = "select * from credit_class where id=@id"; SQLiteParameter[] ps = { new SQLiteParameter("id", model.id) }; DataTable table = SqliteHelper.Select(sql, ps); //修改 List <CreditClass> list = new List <CreditClass>(); foreach (DataRow row in table.Rows) { //修改 list.Add(new CreditClass() { id = Convert.ToInt32(row["id"]), student_class = row["student_class"].ToString(), credit_limit = Convert.ToDouble(row["credit_limit"]), add_time = Convert.ToDateTime(row["add_time"]), update_time = Convert.ToDateTime(row["update_time"]), deleted = Convert.ToInt32(row["deleted"]) }); } //修改 CreditClass model2 = list[0]; return(model2); }
static void Main() { CreditClass creditclass = new CreditClass(); Publisher publisher = new Publisher(); Subscriber subscriber = new Subscriber(); publisher.myevent += subscriber.Task; CreditCardInfo creditcardinfo = new CreditCardInfo(); Console.WriteLine("Enter Credit Card Number:"); creditclass.CreditCardNo = Convert.ToDouble(Console.ReadLine()); Console.WriteLine("Enter Credit Card Name:"); creditclass.CreditCardName = Console.ReadLine(); Console.WriteLine("ENter amount:"); double amount = Convert.ToDouble(Console.ReadLine()); if (creditcardinfo.MakePayment(amount)) { publisher.FireEvent(); } Console.WriteLine("BalanceAmount:" + creditcardinfo.BalanceAmount); Console.ReadLine(); }
public int Update(CreditClass model) { if (SelectById(model).deleted == 1) { return(-2); } List <Object> obj = updateSQL(model); string sql = obj[0].ToString(); List <SQLiteParameter> ps = (List <SQLiteParameter>)obj[1]; return(SqliteHelper.update(sql, ps.ToArray())); }
public int Delete(CreditClass model) { if (SelectById(model).deleted == 1) { //如果deleted==1,已经删除,返回-2 return(-2); } //修改 string sql = "update credit_class set deleted=1 where id=@id"; SQLiteParameter[] ps = { new SQLiteParameter("@id", model.id), }; return(SqliteHelper.Delete(sql, ps)); }
public int Add(CreditClass model) { //修改 string sql = "insert into credit_class(student_class,credit_limit,add_time) values (@student_class,@credit_limit,@add_time)"; //数组的初始化器 SQLiteParameter[] ps = { //修改 new SQLiteParameter("@student_class", model.student_class), new SQLiteParameter("@credit_limit", model.credit_limit), new SQLiteParameter("@add_time", DateTime.Now) }; //执行 return(SqliteHelper.Add(sql, ps)); }
private void GridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { DataRow row = gridView1.GetDataRow(0); GridView view = sender as GridView; DataRow dataRow = view.GetDataRow(e.FocusedRowHandle); if (dataRow == null) { return; } int idClass = int.Parse(dataRow.ItemArray[4].ToString()); CreditClass creditClass = Program.dbContext.CreditClass.Find(idClass); Program.dbContext.Entry(creditClass).Collection(x => x.Students).Load(); List <Student> listStu = creditClass.Students.ToList(); gridControl2.DataSource = new BindingList <Student>(listStu); }
private List <Object> updateSQL(CreditClass model) { List <SQLiteParameter> ps = new List <SQLiteParameter>(); string sql = "update course_score set "; bool flag = false; if (model.student_class != null) { if (flag) { sql += ","; } sql += "student_class=@student_class"; ps.Add(new SQLiteParameter("@student_class", model.student_class)); flag = true; } if (model.credit_limit != 0) { if (flag) { sql += ","; } sql += "credit_limit=@credit_limit"; ps.Add(new SQLiteParameter("@credit_limit", model.credit_limit)); flag = true; } if (flag) { sql += ","; } sql += "update_time=@update_time"; ps.Add(new SQLiteParameter("@update_time", DateTime.Now)); sql += " where id=@id"; ps.Add(new SQLiteParameter("@id", model.id)); List <Object> obj = new List <object>(); obj.Add(sql); obj.Add(ps); return(obj); }