/// <summary> /// 获得数据列表 /// </summary> public List<Maticsoft.Model.UserExp.UsersApprove> DataTableToList(DataTable dt) { List<Maticsoft.Model.UserExp.UsersApprove> modelList = new List<Maticsoft.Model.UserExp.UsersApprove>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Maticsoft.Model.UserExp.UsersApprove model; for (int n = 0; n < rowsCount; n++) { model = new Maticsoft.Model.UserExp.UsersApprove(); if (dt.Rows[n]["ID"] != null && dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } if (dt.Rows[n]["UserID"] != null && dt.Rows[n]["UserID"].ToString() != "") { model.UserID = int.Parse(dt.Rows[n]["UserID"].ToString()); } if (dt.Rows[n]["ApproveType"] != null && dt.Rows[n]["ApproveType"].ToString() != "") { model.ApproveType = int.Parse(dt.Rows[n]["ApproveType"].ToString()); } if (dt.Rows[n]["ImgURL"] != null && dt.Rows[n]["ImgURL"].ToString() != "") { model.ImgURL = dt.Rows[n]["ImgURL"].ToString(); } if (dt.Rows[n]["CreatedDate"] != null && dt.Rows[n]["CreatedDate"].ToString() != "") { model.CreatedDate = DateTime.Parse(dt.Rows[n]["CreatedDate"].ToString()); } if (dt.Rows[n]["Status"] != null && dt.Rows[n]["Status"].ToString() != "") { model.Status = int.Parse(dt.Rows[n]["Status"].ToString()); } if (dt.Rows[n]["ApprovedTime"] != null && dt.Rows[n]["ApprovedTime"].ToString() != "") { model.ApprovedTime = DateTime.Parse(dt.Rows[n]["ApprovedTime"].ToString()); } if (dt.Rows[n]["ApprovedUserID"] != null && dt.Rows[n]["ApprovedUserID"].ToString() != "") { model.ApprovedUserID = int.Parse(dt.Rows[n]["ApprovedUserID"].ToString()); } modelList.Add(model); } } return modelList; }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.UserExp.UsersApprove GetModelByUidAndType(int userId, int approveType) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,UserID,ApproveType,ImgURL,CreatedDate,Status,ApprovedTime,ApprovedUserID,IDCard from Accounts_UsersApprove "); strSql.Append(" where UserID=@UserID and ApproveType=@ApproveType"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int,4), new SqlParameter("@ApproveType", SqlDbType.Int,4) }; parameters[0].Value = userId; parameters[1].Value = approveType; Maticsoft.Model.UserExp.UsersApprove model = new Maticsoft.Model.UserExp.UsersApprove(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); } if (ds.Tables[0].Rows[0]["ApproveType"] != null && ds.Tables[0].Rows[0]["ApproveType"].ToString() != "") { model.ApproveType = int.Parse(ds.Tables[0].Rows[0]["ApproveType"].ToString()); } if (ds.Tables[0].Rows[0]["ImgURL"] != null && ds.Tables[0].Rows[0]["ImgURL"].ToString() != "") { model.ImgURL = ds.Tables[0].Rows[0]["ImgURL"].ToString(); } if (ds.Tables[0].Rows[0]["CreatedDate"] != null && ds.Tables[0].Rows[0]["CreatedDate"].ToString() != "") { model.CreatedDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreatedDate"].ToString()); } if (ds.Tables[0].Rows[0]["Status"] != null && ds.Tables[0].Rows[0]["Status"].ToString() != "") { model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString()); } if (ds.Tables[0].Rows[0]["ApprovedTime"] != null && ds.Tables[0].Rows[0]["ApprovedTime"].ToString() != "") { model.ApprovedTime = DateTime.Parse(ds.Tables[0].Rows[0]["ApprovedTime"].ToString()); } if (ds.Tables[0].Rows[0]["ApprovedUserID"] != null && ds.Tables[0].Rows[0]["ApprovedUserID"].ToString() != "") { model.ApprovedUserID = int.Parse(ds.Tables[0].Rows[0]["ApprovedUserID"].ToString()); } if (ds.Tables[0].Rows[0]["IDCard"] != null && ds.Tables[0].Rows[0]["IDCard"].ToString() != "") { model.IDCard = ds.Tables[0].Rows[0]["IDCard"].ToString(); } return model; } else { return null; } }