/// <summary>
/// 通过ID查找用户等级对象
/// </summary>
/// <param name="ID">需要查找的ID</param>
/// <returns>用户等级对象</returns>
public static CustDegree FindCustDegreeByID(int ID)
{
CustDegree node = new CustDegree();
node.DegreeID = -1;
string str = "select DegreeID,DegreeName,RoomDiscount,PledgeCashDisCount,TotalMoneyLimit,RoomCheck,FreeBreakfast from CustDegree where DegreeID = @index";
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@index", SqlDbType.Int)
};
para[0].Value = ID;
SqlDataReader reader = SqlHelper.ExecuteReader(str, para);
while (reader.Read())
{
node.DegreeID = Convert.ToInt32(reader[0]);
node.DegreeName = Convert.ToString(reader[1]);
node.RoomDiscount = Convert.ToDouble(reader[2]);
node.PledgeCashDisCount = Convert.ToInt32(reader[3]);
node.TotalMoneyLimit = Convert.ToInt32(reader[4]);
node.RoomCheck = Convert.ToString(reader[5]) == "True" ? true : false;
node.FreeBreakfast = Convert.ToString(reader[6]) == "True" ? true : false;
}
reader.Close();
return(node);
}
/// <summary>
/// 通过关键词查找用户等级，支持模糊搜索
/// </summary>
/// <param name="keyword">需要查找的关键词</param>
/// <param name="FuzzyMode">模糊搜索模式，true为开启，false为关闭</param>
/// <returns>返回列表对象</returns>
public static List <CustDegree> FindCustDegreeByKeyword(string keyword, bool FuzzyMode)
{
List <CustDegree> list = new List <CustDegree>();
string FindStr = "";
if (FuzzyMode == true)
{
FindStr = " like ";
}
else
{
FindStr = " = ";
}
string sqlstr = "select DegreeID,DegreeName,RoomDiscount,PledgeCashDisCount,TotalMoneyLimit,RoomCheck,FreeBreakfast from CustDegree where DegreeName" + FindStr + "@searchname";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@searchname", SqlDbType.VarChar)
};
if (FuzzyMode == true)
{
para[0].Value = "%" + keyword + "%";
}
else
{
para[0].Value = keyword;
}
SqlDataReader reader = SqlHelper.ExecuteReader(sqlstr, para);
while (reader.Read())
{
CustDegree node = new CustDegree();
node.DegreeID = Convert.ToInt32(reader[0]);
node.DegreeName = Convert.ToString(reader[1]);
node.RoomDiscount = Convert.ToDouble(reader[2]);
node.PledgeCashDisCount = Convert.ToInt32(reader[3]);
node.TotalMoneyLimit = Convert.ToInt32(reader[4]);
node.RoomCheck = Convert.ToString(reader[5]) == "True" ? true : false;
node.FreeBreakfast = Convert.ToString(reader[6]) == "True" ? true : false;
list.Add(node);
}
reader.Close();
return(list);
}
/// <summary>
/// 获取所有用户等级对象
/// </summary>
/// <returns>返回列表对象</returns>
public static List <CustDegree> GetAllDegreeStatus()
{
List <CustDegree> list = new List <CustDegree>();
string sqlstr = "select DegreeID,DegreeName,RoomDiscount,PledgeCashDisCount,TotalMoneyLimit,RoomCheck,FreeBreakfast from CustDegree";
SqlDataReader reader = SqlHelper.ExecuteReader(sqlstr);
while (reader.Read())
{
CustDegree node = new CustDegree();
node.DegreeID = Convert.ToInt32(reader[0]);
node.DegreeName = Convert.ToString(reader[1]);
node.RoomDiscount = Convert.ToDouble(reader[2]);
node.PledgeCashDisCount = Convert.ToInt32(reader[3]);
node.TotalMoneyLimit = Convert.ToInt32(reader[4]);
node.RoomCheck = Convert.ToString(reader[5]) == "True" ? true : false;
node.FreeBreakfast = Convert.ToString(reader[6]) == "True" ? true : false;
list.Add(node);
}
reader.Close();
return(list);
}
