/// <summary>
/// 获得数据列表
/// </summary>
public List <NoName.NetShop.Model.MemberModel> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
List <NoName.NetShop.Model.MemberModel> modelList = new List <NoName.NetShop.Model.MemberModel>();
int rowsCount = ds.Tables[0].Rows.Count;
if (rowsCount > 0)
{
NoName.NetShop.Model.MemberModel model;
for (int n = 0; n < rowsCount; n++)
{
model = new NoName.NetShop.Model.MemberModel();
if (ds.Tables[0].Rows[n]["UserId"].ToString() != "")
{
model.UserId = int.Parse(ds.Tables[0].Rows[n]["UserId"].ToString());
}
model.UserEmail = ds.Tables[0].Rows[n]["UserEmail"].ToString();
model.Password = ds.Tables[0].Rows[n]["Password"].ToString();
model.NickName = ds.Tables[0].Rows[n]["NickName"].ToString();
if (ds.Tables[0].Rows[n]["AllScore"].ToString() != "")
{
model.AllScore = int.Parse(ds.Tables[0].Rows[n]["AllScore"].ToString());
}
if (ds.Tables[0].Rows[n]["CurScore"].ToString() != "")
{
model.CurScore = int.Parse(ds.Tables[0].Rows[n]["CurScore"].ToString());
}
if (ds.Tables[0].Rows[n]["LastLogin"].ToString() != "")
{
model.LastLogin = DateTime.Parse(ds.Tables[0].Rows[n]["LastLogin"].ToString());
}
model.LoginIP = ds.Tables[0].Rows[n]["LoginIP"].ToString();
if (ds.Tables[0].Rows[n]["RegisterTime"].ToString() != "")
{
model.RegisterTime = DateTime.Parse(ds.Tables[0].Rows[n]["RegisterTime"].ToString());
}
if (ds.Tables[0].Rows[n]["ModifyTime"].ToString() != "")
{
model.ModifyTime = DateTime.Parse(ds.Tables[0].Rows[n]["ModifyTime"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(NoName.NetShop.Model.MemberModel model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(NoName.NetShop.Model.MemberModel model)
{
dal.Add(model);
}
/// <summary>
/// ��������б�
/// </summary>
public List<NoName.NetShop.Model.MemberModel> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
List<NoName.NetShop.Model.MemberModel> modelList = new List<NoName.NetShop.Model.MemberModel>();
int rowsCount = ds.Tables[0].Rows.Count;
if (rowsCount > 0)
{
NoName.NetShop.Model.MemberModel model;
for (int n = 0; n < rowsCount; n++)
{
model = new NoName.NetShop.Model.MemberModel();
if(ds.Tables[0].Rows[n]["UserId"].ToString()!="")
{
model.UserId=int.Parse(ds.Tables[0].Rows[n]["UserId"].ToString());
}
model.UserEmail=ds.Tables[0].Rows[n]["UserEmail"].ToString();
model.Password=ds.Tables[0].Rows[n]["Password"].ToString();
model.NickName=ds.Tables[0].Rows[n]["NickName"].ToString();
if(ds.Tables[0].Rows[n]["AllScore"].ToString()!="")
{
model.AllScore=int.Parse(ds.Tables[0].Rows[n]["AllScore"].ToString());
}
if(ds.Tables[0].Rows[n]["CurScore"].ToString()!="")
{
model.CurScore=int.Parse(ds.Tables[0].Rows[n]["CurScore"].ToString());
}
if(ds.Tables[0].Rows[n]["LastLogin"].ToString()!="")
{
model.LastLogin=DateTime.Parse(ds.Tables[0].Rows[n]["LastLogin"].ToString());
}
model.LoginIP=ds.Tables[0].Rows[n]["LoginIP"].ToString();
if(ds.Tables[0].Rows[n]["RegisterTime"].ToString()!="")
{
model.RegisterTime=DateTime.Parse(ds.Tables[0].Rows[n]["RegisterTime"].ToString());
}
if(ds.Tables[0].Rows[n]["ModifyTime"].ToString()!="")
{
model.ModifyTime=DateTime.Parse(ds.Tables[0].Rows[n]["ModifyTime"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
