public int Insert(WebMenuModle modle) { String sql = "INSERT INTO WebMenu VALUES(@Title,@Link,@ParentId)"; 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 = "@ParentId", SqlDbType = SqlDbType.Int, Value = modle.ParentId }, })); }
public int UpdateById(WebMenuModle modle) { String sql = "UPDATE WebMenu 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(WebMenuModle modle) { return(dal.Insert(modle)); }
public int UpdateById(WebMenuModle modle) { return(dal.UpdateById(modle)); }