Esempio n. 1
0
        public bool Edit(ColumnImgs item)
        {
            string sqlstr = "UPDATE [tbl_ColumnImgs]  SET [CID] ='" + item.CID + "',[Title] = '" + item.Title + "',[ImgStr] = '" + item.ImgStr + "',[ImgLink] ='" + item.ImgLink + "',[Orders] ='" + item.Orders + "' WHERE id=" + item.ID;
            int    res    = DbHelperSQLite.ExecuteSql(sqlstr);

            return(res > 0);
        }
Esempio n. 2
0
        public bool Add(ColumnImgs item)
        {
            string sqlstr = "INSERT INTO [tbl_ColumnImgs] ([Id] ,[CID] ,[Title] ,[ImgStr] ,[ImgLink] ,[Orders]) VALUES (null ,'" + item.CID + "','" + item.Title + "','" + item.ImgStr + "','" + item.ImgLink + "','" + item.Orders + "')";
            int    res    = DbHelperSQLite.ExecuteSql(sqlstr);

            return(res > 0);
        }