C# (CSharp) ModelBase.ExecuteActionQuery示例

示例#1

文件： ModelBaseTests.cs 项目： mw-5/CRM-ASP.Net

        public void ExecuteActionQueryTest()
        {
            string sqlLastId = "SELECT Max(cid) AS last_id FROM customers";

            long cid = 0;

            long.TryParse(mb.ExecuteScalar(sqlLastId).ToString(), out cid);
            cid++;

            mb.ExecuteActionQuery("INSERT INTO customers(cid) VALUES(" + cid.ToString("0") + ")");
            Assert.IsTrue(cid == long.Parse(mb.ExecuteScalar(sqlLastId).ToString()));

            mb.ExecuteActionQuery("DELETE FROM customers WHERE cid = " + cid.ToString("0"));
            cid--;
            Assert.IsTrue(cid == long.Parse(mb.ExecuteScalar(sqlLastId).ToString()));
        }