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