/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Light.Model.userinfo model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Light.Model.userinfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Light.Model.userinfo> DataTableToList(DataTable dt)
{
List <Light.Model.userinfo> modelList = new List <Light.Model.userinfo>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Light.Model.userinfo model;
for (int n = 0; n < rowsCount; n++)
{
model = new Light.Model.userinfo();
if (dt.Rows[n]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[n]["id"].ToString());
}
model.phone = dt.Rows[n]["phone"].ToString();
model.email = dt.Rows[n]["email"].ToString();
model.qqid = dt.Rows[n]["qqid"].ToString();
model.weiboid = dt.Rows[n]["weiboid"].ToString();
model.password = dt.Rows[n]["password"].ToString();
model.username = dt.Rows[n]["username"].ToString();
model.sex = dt.Rows[n]["sex"].ToString();
model.gender = dt.Rows[n]["gender"].ToString();
if (dt.Rows[n]["createtime"].ToString() != "")
{
model.createtime = DateTime.Parse(dt.Rows[n]["createtime"].ToString());
}
if (dt.Rows[n]["logincount"].ToString() != "")
{
model.logincount = int.Parse(dt.Rows[n]["logincount"].ToString());
}
if (dt.Rows[n]["lastlogintime"].ToString() != "")
{
model.lastlogintime = DateTime.Parse(dt.Rows[n]["lastlogintime"].ToString());
}
model.userid = dt.Rows[n]["userid"].ToString();
if (dt.Rows[n]["birthday"].ToString() != "")
{
model.birthday = DateTime.Parse(dt.Rows[n]["birthday"].ToString());
}
if (dt.Rows[n]["cityid"].ToString() != "")
{
model.cityid = int.Parse(dt.Rows[n]["cityid"].ToString());
}
if (dt.Rows[n]["roleid"].ToString() != "")
{
model.roleid = int.Parse(dt.Rows[n]["roleid"].ToString());
}
model.loginvalidate = dt.Rows[n]["loginvalidate"].ToString();
model.faceurl = dt.Rows[n]["faceurl"].ToString();
if (dt.Rows[n]["state"].ToString() != "")
{
model.state = int.Parse(dt.Rows[n]["state"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
