public int insertSchedule(Schedule schedule)
{
if (schedule == null)
return 0;
SQLiteParameter[] parameters = new SQLiteParameter[11];
string sql = "insert into ORDERS(ORDERNUMBER,COURSE_ID,USER_ID,ADDTIME,STATUS,DEV_ID) VALUES(@mORDERNUMBER,@mCOURSE_ID,@mUSER_ID,@mADDTIME,@mSTATUS,DEV_ID)";
//parameters[0]=(new SQLiteParameter("m_id", student.id));
parameters[0] = (new SQLiteParameter("@mORDERNUMBER", schedule.ORDERNUMBER));
parameters[1] = (new SQLiteParameter("@mORDERNUMBER", schedule.ORDERNUMBER));
parameters[2] = (new SQLiteParameter("@mUSER_ID", schedule.USER_ID));
parameters[4] = (new SQLiteParameter("@mADDTIME", schedule.ADDTIME));
parameters[4] = (new SQLiteParameter("@mSTATUS", schedule.STATUS));
parameters[4] = (new SQLiteParameter("@mDEV_ID", schedule.DEV_ID));
return this.ExecuteNonQuery(sql, parameters);
}
/**
*添加订单状态修改的功能
*/
public int updateORDER(Schedule Schedule)
{
if (Schedule == null)
return 0;
SQLiteParameter[] parameters = new SQLiteParameter[2];
string sql = "UPDATE ORDERS SET REMARK = @mREMARK WHERE _id = @m_id";
parameters[0] = (new SQLiteParameter("m_id", Schedule._id));
parameters[1] = (new SQLiteParameter("@mREMARK", Schedule.REMARK));
return this.ExecuteNonQuery(sql, parameters);
}
//课表操作
public Schedule getScheduleById(int id)
{
Schedule schedule = new Schedule();
SQLiteCommand cmd = this.connection.CreateCommand();
//SELECT ORDERS.ORDERNUMBER as 订单号, COURSE.NAME as 课程名, COURSE.COURSENUMBER as 课程编号, USER.NAME as 学生姓名, USER._id as 学生编号 from ORDERS inner join USER on ORDERS.[USER_ID] = USER.[_id] inner join COURSE on ORDERS.COURSE_ID = COURSE._id
cmd.CommandText = "SELECT * FROM ORDERS WHERE STATUS = 0 AND _id = " + id;
System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
schedule._id = reader.GetInt16(0);
schedule.ORDERNUMBER = reader.GetString(1);
schedule.COURSE_ID = reader.GetInt16(2);
schedule.USER_ID = reader.GetInt16(3);
schedule.ADDTIME = reader.GetInt64(4);
schedule.time = this.GetTime(schedule.ADDTIME + "").ToString();
schedule.userName = this.getStudentById(schedule.USER_ID).NAME;
schedule.courseName = this.getCourseById(schedule.COURSE_ID).NAME;
schedule.REMARK = reader.GetString(8);
//schedule.time =
//course.PHOTO = reader.GetString(9);
}
reader.Close();
return schedule;
}
