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