/// <summary> /// 读取店铺类型 /// </summary> /// <returns></returns> public List <M_UserStoreTypeTable> GetStoreType() { try { string sql = @"select * from ZL_UserStoreTypeTable"; //return SqlHelper.ExecuteTable(CommandType.Text, sql, null); List <M_UserStoreTypeTable> list = new List <M_UserStoreTypeTable>(); using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, null)) { while (dr.Read()) { M_UserStoreTypeTable ustt = new M_UserStoreTypeTable(); ustt.ID = int.Parse(dr["ID"].ToString()); ustt.TypeName = dr["TypeName"].ToString(); list.Add(ustt); } dr.Close(); dr.Dispose(); } return(list); } catch { throw; } }
/// <summary> /// 根据ID读取类型 /// </summary> /// <param name="id"></param> /// <returns></returns> public M_UserStoreTypeTable GetStoreTypeByID(int id) { try { string sql = @"select * from ZL_UserStoreTypeTable where ID=@id"; SqlParameter[] parameter = { new SqlParameter("id", id) }; M_UserStoreTypeTable ustt = new M_UserStoreTypeTable(); using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, parameter)) { if (dr.Read()) { ustt.ID = int.Parse(dr["ID"].ToString()); ustt.TypeName = dr["TypeName"].ToString(); } dr.Close(); dr.Dispose(); } return(ustt); } catch { throw; } }