public static List <DTO.Table> GetBanAnList(DataTable data) { List <DTO.Table> tableList = new List <DTO.Table>(); foreach (DataRow row in data.Rows) { DTO.Table table = new DTO.Table(row); tableList.Add(table); } return(tableList); }
public List <DTO.Table> LoadTableList() { List <DTO.Table> tableList = new List <DTO.Table>(); DataTable data = DAO.DataProvider.Instance.ExecuteQuery("USP_GetTableList"); foreach (DataRow item in data.Rows) { DTO.Table table = new DTO.Table(item); tableList.Add(table); } return(tableList); }
public List <DTO.Table> GetTableList() { List <DTO.Table> tableList = new List <DTO.Table>(); string query = "select * from dbo.TableFood"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { DTO.Table table = new DTO.Table(item); tableList.Add(table); } return(tableList); }
public List <DTO.Table> SearchTableByName(string name) { List <DTO.Table> tableList = new List <DTO.Table>(); string query = string.Format("SELECT * FROM dbo.TableFood WHERE dbo.fuConvertToUnsign1(name) LIKE N'%' + dbo.fuConvertToUnsign1(N'{0}') + '%'", name); DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { DTO.Table table = new DTO.Table(item); tableList.Add(table); } return(tableList); }
public Table GetTableByID(int id) { DTO.Table table = null; string query = "select * from TableFood where id = " + id; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { table = new DTO.Table(item); return(table); } return(table); }
private void Bi_Click(object sender, EventArgs e) { int id = Convert.ToInt16((sender as ButtonImage1).TextButton); DTO.Table tbshow = null; foreach (DTO.Table tb in lstTable) { if (tb.Id == id) { tbshow = tb; break; } } MessageBox.Show("Table No." + tbshow.Id + "\nFloor : " + tbshow.Floor + "\nPosition : " + tbshow.Position, "Infomation Table", MessageBoxButtons.OK, MessageBoxIcon.Information); }