/// <summary> /// 更新一条数据 /// </summary> public bool Update(HeqiaoDaoshiCore.Model.searchl model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update searchl set "); strSql.Append("text=@text,"); strSql.Append("url=@url"); strSql.Append(" where guid=@guid "); SqlParameter[] parameters = { new SqlParameter("@text", SqlDbType.VarChar, 255), new SqlParameter("@url", SqlDbType.VarChar, 255), new SqlParameter("@guid", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = model.text; parameters[1].Value = model.url; parameters[2].Value = model.guid; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(HeqiaoDaoshiCore.Model.searchl model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into searchl("); strSql.Append("guid,text,url)"); strSql.Append(" values ("); strSql.Append("@guid,@text,@url)"); SqlParameter[] parameters = { new SqlParameter("@guid", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@text", SqlDbType.VarChar, 255), new SqlParameter("@url", SqlDbType.VarChar, 255) }; parameters[0].Value = Guid.NewGuid(); parameters[1].Value = model.text; parameters[2].Value = model.url; int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public HeqiaoDaoshiCore.Model.searchl DataRowToModel(DataRow row) { HeqiaoDaoshiCore.Model.searchl model = new HeqiaoDaoshiCore.Model.searchl(); if (row != null) { if (row["guid"] != null && row["guid"].ToString() != "") { model.guid = new Guid(row["guid"].ToString()); } if (row["text"] != null) { model.text = row["text"].ToString(); } if (row["url"] != null) { model.url = row["url"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public HeqiaoDaoshiCore.Model.searchl GetModel(Guid guid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 guid,text,url from searchl "); strSql.Append(" where guid=@guid "); SqlParameter[] parameters = { new SqlParameter("@guid", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = guid; HeqiaoDaoshiCore.Model.searchl model = new HeqiaoDaoshiCore.Model.searchl(); DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }