/// <summary>
/// 分页查询数据
/// </summary>
/// <param name="page">当前页数</param>
/// <param name="row">每页数目</param>
/// <param name="where">查询条件</param>
/// <param name="allrow">第一张表一共有多少列</param>
/// <returns></returns>
public static List <UserChangeMoney.UserMoney> GetUserMoney(int page, int row, string where, out int allrow)
{
DataSet ds = UserInfDal.GetUserMoneyChange(page, row, where.ToString());
allrow = 0;
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
allrow = int.Parse(ds.Tables[0].Rows[0][0].ToString());
}
List <UserChangeMoney.UserMoney> list = new List <UserChangeMoney.UserMoney>();
if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
UserChangeMoney.UserMoney usermoney_new = new UserChangeMoney.UserMoney();
usermoney_new.UserID = Int32.Parse(dr["UserID"].ToString());
usermoney_new.UserName = dr["UserName"].ToString();
usermoney_new.StartMoney = decimal.Parse(dr["StartMoney"].ToString());
usermoney_new.ChangeMoney = decimal.Parse(dr["ChangeMoney"].ToString());
usermoney_new.ChangeType = Int32.Parse(dr["ChangeType"].ToString());
usermoney_new.DateTime = DateTime.Parse(dr["DateTime"].ToString());
usermoney_new.Remark = dr["Remark"].ToString();
usermoney_new.RoomID = Int32.Parse(dr["RoomID"].ToString());
usermoney_new.QunNum = Int32.Parse(dr["QunNum"].ToString());
usermoney_new.RoomCardNum = Int32.Parse(dr["RoomCardNum"].ToString());
usermoney_new.Riqi = Int32.Parse(dr["Riqi"].ToString());
list.Add(usermoney_new);
}
}
return(list);
}
/// <summary>
/// 分页查数据
/// </summary>
/// <param name="page">当前页</param>
/// <param name="row">每页数</param>
/// <param name="where">查询条件</param>
/// <returns></returns>
public static List <UserInfoModel.userModel> GetProductByStr(int page, int row, string where, out int allrow)
{
DataSet ds = UserInfDal.GetProductByStr(page, row, where.ToString());
allrow = 0;
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
allrow = int.Parse(ds.Tables[0].Rows[0][0].ToString());
}
List <UserInfoModel.userModel> list = new List <UserInfoModel.userModel>();
if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
UserInfoModel.userModel userModel = new UserInfoModel.userModel();
userModel.UserID = dr["UserID"].ToString().ToInt();
userModel.NickName = dr["NickName"].ToString();
userModel.userName = dr["userName"].ToString();
userModel.VipeTime = dr["VipeTime"].ToString().ToDateTime();
userModel.VipLevel = dr["VipLevel"].ToString().ToInt();
userModel.WalletMoney = dr["WalletMoney"].ToString().ToInt();
list.Add(userModel);
}
}
return(list);
}
