public List<CCombo> get_Combos(string state_str, string order_str) { List<CCombo> combos = new List<CCombo>(); SqlConnection sqlCn = null; try { sqlCn = new SqlConnection(_con_str); sqlCn.Open(); string cmd_str = "Select * from [Combo]"; if (state_str != null && state_str != "") cmd_str += " where " + state_str; if (order_str != null && order_str != "") cmd_str += " " + order_str; SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn); using (SqlDataReader dr = cmdSelect.ExecuteReader()) { while (dr.Read()) { var combo = new CCombo(); combo.id = (int)dr["id"]; combo.originPrice = (double)dr["originPrice"]; combo.priceType = dr["priceType"].ToString(); combo.price = ToDouble(dr["price"]); combo.freePrice = ToDouble(dr["freePrice"]); combo.expenseUpTo = ToDouble(dr["expenseUpTo"]); combo.menuIds = dr["menuIds"].ToString(); combo.freeMenuIds = dr["freeMenuIds"].ToString(); combos.Add(combo); } } } catch (System.Exception e) { BathClass.printErrorMsg(e.Message); } finally { close_connection(sqlCn); } return combos; }
public CCombo get_Combo(string key, object key_val) { CCombo combo = null; SqlConnection sqlCn = null; try { sqlCn = new SqlConnection(_con_str); sqlCn.Open(); string cmd_str = "Select * from [Combo] where " + key + "='" + key_val.ToString() + "'"; SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn); using (SqlDataReader dr = cmdSelect.ExecuteReader()) { while (dr.Read()) { combo = new CCombo(); combo.id = (int)dr["id"]; combo.originPrice = (double)dr["originPrice"]; combo.priceType = dr["priceType"].ToString(); combo.price = ToDouble(dr["price"]); combo.freePrice = ToDouble(dr["freePrice"]); combo.expenseUpTo = ToDouble(dr["expenseUpTo"]); combo.menuIds = dr["menuIds"].ToString(); combo.freeMenuIds = dr["freeMenuIds"].ToString(); } } } catch (System.Exception e) { BathClass.printErrorMsg(e.Message); } finally { close_connection(sqlCn); } return combo; }