using PetaPocoDemo.Models;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace PetaPocoDemo
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //创建一个petapoco对象
            var db = new PetaPoco.Database("connectionString");

            //遍历查询文章表
            foreach (var a in db.Query<article>("select * from article"))
            {
                MessageBox.Show(a.article_id + "-------" + a.title);
            }
            //返回一个scalar数量
            var count = db.ExecuteScalar<int>("select count(*) from article");
            MessageBox.Show("count:" + count.ToString());

            //返回一行记录
            var row = db.SingleOrDefault<article>("select * from article where article_id=‘1‘");
            MessageBox.Show(row.content);

            //插入记录
            var newArticle = new article();
            newArticle.article_id = 2;
            newArticle.title = "绿书";
            newArticle.content = "可持续发展绿色内容";
            newArticle.date_created = DateTime.UtcNow;
           
            if (Convert.ToInt32(db.Insert("article", "article_id",false, newArticle)) > 0)
            {
                MessageBox.Show("sucess");
            }
            else
            {
                MessageBox.Show("fail");
            }
        }
    }
}