/// <summary> /// 更新一条数据 /// </summary> public bool Update(entity_LikeList model, string sid) { StringBuilder strSql = new StringBuilder(); strSql.Append("update LikeList set "); strSql.Append("sid=@sid,"); strSql.Append("likeName=@likeName,"); strSql.Append("url=@url,"); strSql.Append("type=@type"); strSql.Append(" where sid='" + sid + "'"); SqlParameter[] parameters = { new SqlParameter("@likeName", SqlDbType.NVarChar, 200), new SqlParameter("@url", SqlDbType.NVarChar, 200), new SqlParameter("@type", SqlDbType.NVarChar, 50), new SqlParameter("@sid", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.likeName; parameters[1].Value = model.url; parameters[2].Value = model.type; parameters[3].Value = model.sid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(entity_LikeList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LikeList("); strSql.Append("sid,likeName,url,type)"); strSql.Append(" values ("); strSql.Append("@sid,@likeName,@url,@type)"); SqlParameter[] parameters = { new SqlParameter("@sid", SqlDbType.NVarChar, 50), new SqlParameter("@likeName", SqlDbType.NVarChar, 200), new SqlParameter("@url", SqlDbType.NVarChar, 200), new SqlParameter("@type", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.sid; parameters[1].Value = model.likeName; parameters[2].Value = model.url; parameters[3].Value = model.type; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public entity_LikeList DataRowToModel(DataRow row) { entity_LikeList model = new entity_LikeList(); if (row != null) { if (row["sid"] != null) { model.sid = row["sid"].ToString(); } if (row["likeName"] != null) { model.likeName = row["likeName"].ToString(); } if (row["url"] != null) { model.url = row["url"].ToString(); } if (row["type"] != null) { model.type = row["type"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public entity_LikeList GetModel(string sid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 sid,likeName,url,type from LikeList "); strSql.Append(" where sid=@sid "); SqlParameter[] parameters = { new SqlParameter("@sid", SqlDbType.NVarChar, 50) }; parameters[0].Value = sid; entity_LikeList model = new entity_LikeList(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(entity_LikeList model, string sid) { return(dal.Update(model, sid)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(entity_LikeList model) { return(dal.Add(model)); }