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