public int Insert(FriendLinkModle modle) { String sql = "INSERT INTO FriendLink VALUES(@Title,@Link,@IsShow)"; return(dbo.NoQuery(sql, new SqlParameter[] { new SqlParameter() { ParameterName = "@Title", SqlDbType = SqlDbType.NVarChar, Value = modle.Title }, new SqlParameter() { ParameterName = "@Link", SqlDbType = SqlDbType.NVarChar, Value = modle.Link }, new SqlParameter() { ParameterName = "@IsShow", SqlDbType = SqlDbType.Bit, Value = modle.IsShow }, })); }
public int UpdateById(FriendLinkModle modle) { String sql = "UPDATE FriendLink 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(FriendLinkModle modle) { return(dal.Insert(modle)); }
public int UpdateById(FriendLinkModle modle) { return(dal.UpdateById(modle)); }