public void LoadData()
{
DB db = new DB();
//dt = db.ExecuteDataTable("SELECT * FROM COURSE", null);
string sql = "select course.*, ifnull (b.usedTime,'0') as USEDTIME from course left join (select course_ID,count(*) as usedTime from orders group by course_id) as b on course._id = b.course_id";
dt = db.ExecuteDataTable(sql, null);
this.dataGrid1.ItemsSource = dt.DefaultView;
}
public void LoadData()
{
DB db = new DB();
dt = db.ExecuteDataTable("SELECT * FROM TEACHER", null);
this.dataGrid1.ItemsSource = dt.DefaultView;
}
public void LoadData()
{
DB db = new DB();
dt = db.ExecuteDataTable("SELECT ORDERS._id as _id, ORDERS.ORDERNUMBER as 订单号, COURSE.NAME as 课程名, COURSE.COURSENUMBER as 课程编号, COURSE.TIME as 课时, COURSE.PRICE as 价格,USER.NAME as 联系人, USER._id as 客户,USER.NAME as 联系人,USER.PHONE as 联系人电话,USER.EMAIL as 邮箱,USER.ADDRESS as 地址,ADDTIME,ORDERS.EXPECTED_TIME as 期望上课时间,ORDERS.REMARK as 备注 from ORDERS inner join USER on ORDERS.[USER_ID] = USER.[_id] inner join COURSE on ORDERS.COURSE_ID = COURSE._id WHERE ORDERS.[STATUS] = 0", null);
dt.Columns.Add("GMT_time", typeof(string));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i][dt.Columns[15].ColumnName] = this.db.GetTime(dt.Rows[i][dt.Columns[12].ColumnName].ToString());
}
this.dataGrid1.ItemsSource = dt.DefaultView;
this.dataGrid1.CanUserAddRows = false;
}
