public DishTypeData GetDishTypeByID(int dishTypeID) { try { string SpName = "dbo.DishType_GetByID"; DishTypeData dishType = null; using (SqlConnection SqlConn = new SqlConnection()) { SqlConn.ConnectionString = SystemConfigurations.EateryConnectionString; SqlConn.Open(); SqlCommand SqlCmd = new SqlCommand(SpName, SqlConn); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.Add(new SqlParameter("@DishTypeID", dishTypeID)); using (SqlDataReader Reader = SqlCmd.ExecuteReader()) { if (Reader.HasRows) { Reader.Read(); dishType = new DishTypeData(); dishType.DishTypeID = Convert.ToInt32(Reader["DishTypeID"]); dishType.DishTypeName = Convert.ToString(Reader["DishTypeName"]); } } SqlConn.Close(); } return(dishType); } catch (Exception ex) { throw ex; } }
public List <DishTypeData> GetDishTypeList() { try { string SpName = "dbo.DishType_Get"; List <DishTypeData> ListDishType = new List <DishTypeData>(); using (SqlConnection SqlConn = new SqlConnection()) { SqlConn.ConnectionString = SystemConfigurations.EateryConnectionString; SqlConn.Open(); SqlCommand SqlCmd = new SqlCommand(SpName, SqlConn); SqlCmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader Reader = SqlCmd.ExecuteReader()) { if (Reader.HasRows) { while (Reader.Read()) { DishTypeData dishType = new DishTypeData(); dishType.DishTypeID = Convert.ToInt32(Reader["DishTypeID"]); dishType.DishTypeName = Convert.ToString(Reader["DishTypeName"]); ListDishType.Add(dishType); } } } SqlConn.Close(); } return(ListDishType); } catch (Exception ex) { throw ex; } }
//通过菜系ID返回菜系 public static DishTypeData GetTypeData(int DtId) { String connectStr = ConnectorInfo.connectStr; MySqlConnection conn = new MySqlConnection(connectStr); conn.Open(); String sql = "select * from dishtypeinfo where DtId="+DtId; MySqlCommand mySqlCommand = new MySqlCommand(sql, conn); MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); mySqlDataReader.Read(); DishTypeData dish = new DishTypeData(DtId, mySqlDataReader.GetString("DtTitle")); return dish; }
/* * 返回所有菜系 * */ public static List<DishTypeData> GetDishTypeDatas() { String connectStr = ConnectorInfo.connectStr; MySqlConnection conn = new MySqlConnection(connectStr); conn.Open(); List<DishTypeData> dishTypeDatas = new List<DishTypeData>(); DishTypeData dishTypeData; String sql = "select * from dishtypeinfo"; MySqlCommand mySqlCommand = new MySqlCommand(sql, conn); MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); while (mySqlDataReader.Read()) { dishTypeData = new DishTypeData(mySqlDataReader.GetInt32("DtId"), mySqlDataReader.GetString("DtTitle")); dishTypeDatas.Add(dishTypeData); } return dishTypeDatas; }