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);
}
