/// <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;
}
}
