public int Insert(SeoModle modle) { String sql = "INSERT INTO Seo VALUES(@Title,@Keyword,@Descriptions,@WebMenuId)"; return(dbo.NoQuery(sql, new SqlParameter[] { new SqlParameter() { ParameterName = "@Title", SqlDbType = SqlDbType.NVarChar, Value = modle.Title }, new SqlParameter() { ParameterName = "@Keyword", SqlDbType = SqlDbType.NVarChar, Value = modle.Keyword }, new SqlParameter() { ParameterName = "@Descriptions", SqlDbType = SqlDbType.NVarChar, Value = modle.Descriptions }, new SqlParameter() { ParameterName = "@WebMenuId", SqlDbType = SqlDbType.Int, Value = modle.WebMenuId }, })); }
public int UpdateById(SeoModle modle) { String sql = "UPDATE Seo SET TITLE=@TITLE WHERE(ID=@ID)"; return(dbo.NoQuery(sql, new SqlParameter[] { new SqlParameter() { ParameterName = "@ID", SqlDbType = SqlDbType.Int, Value = modle.Id, }, new SqlParameter() { ParameterName = "@TITLE", SqlDbType = SqlDbType.Int, Value = modle.Id, }, })); }
public int Insert(SeoModle modle) { return(dal.Insert(modle)); }
public int UpdateById(SeoModle modle) { return(dal.UpdateById(modle)); }