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