public void ChangeTableType(DataRowView rowView,int type) { systemDataSetTableAdapters.tablesTableAdapter tables = new systemDataSetTableAdapters.tablesTableAdapter(); DataRow row = rowView.Row; row["type_id"] = type; tables.Update(row); }
public void TurnTable(DataRowView firstTable, DataRowView secTable) { systemDataSetTableAdapters.tablesTableAdapter tables = new systemDataSetTableAdapters.tablesTableAdapter(); firstTable["type_id"] = 1; secTable["type_id"] = 2; tables.Update(firstTable.Row); tables.Update(secTable.Row); systemDataSetTableAdapters.ordersTableAdapter orders = new systemDataSetTableAdapters.ordersTableAdapter(); int FirTable_id = (int)firstTable["id"]; int SecTable_id = (int)secTable["id"]; systemDataSet.ordersDataTable ordersDt = orders.GetDataByTable(FirTable_id); DataRow OrderRow = ordersDt.Select().First(); OrderRow["table_id"] = SecTable_id; orders.Update(OrderRow); }
public void UpdateRow(DataRow row) { systemDataSetTableAdapters.tablesTableAdapter tableAp = new systemDataSetTableAdapters.tablesTableAdapter(); tableAp.Update(row); }
/// <summary> /// 查询所有桌台表信息 /// </summary> /// <returns></returns> public DataTable SelectAll() { systemDataSetTableAdapters.tablesTableAdapter tables = new systemDataSetTableAdapters.tablesTableAdapter(); DataTable dt = tables.GetData(); return dt; }
public DataTable GetFreeTable() { systemDataSetTableAdapters.tablesTableAdapter tables = new systemDataSetTableAdapters.tablesTableAdapter(); DataTable dt = tables.GetDataByFree(); return dt; }
public void AddTable(DataTable dt) { systemDataSetTableAdapters.tablesTableAdapter tableAp = new systemDataSetTableAdapters.tablesTableAdapter(); tableAp.Update((systemDataSet.tablesDataTable)dt); }