コード例 #1
0
        /// <summary>
        /// Form_Demo_Load
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Form_Demo_Load(object sender, EventArgs e)
        {
            // -----------------demo----------------------
            // 1、init 操作
            // -------------------------------------------
            Mydb.Init(DbType.Mysql, "127.0.0.1", 3306, "root", "jlkj111111", "guangjuqili");

            sys_test.dbWhere dbwhere = new sys_test.dbWhere();

            sys_test.dbOrderBy dborderby = new sys_test.dbOrderBy();

            Mydb.Query <sys_test>(dbwhere, dborderby, 1, 100);

            //SysDept dept = new SysDept();
            //dept.Name = "aaa" + Guid.NewGuid().ToString();

            //// -----------------demo----------------------
            //// 2、insert 操作
            //// -------------------------------------------
            //SaveResult saveResult = Ajdb.Insert(dept);

            //if(saveResult.OK) {
            //    MessageBox.Show("OK");

            //    // -----------------demo----------------------
            //    // 3、select 单行操作
            //    // -------------------------------------------
            //    SysDept getDept = Ajdb.GetItem<SysDept>(saveResult.PK_Int);


            //    getDept.Name += DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            //    getDept.modifytime = DateTime.Now;

            //    // -----------------demo----------------------
            //    // 4、update 操作
            //    // -------------------------------------------
            //    saveResult = Ajdb.Update(getDept);


            //    // -----------------demo----------------------
            //    // select 多行操作
            //    // -------------------------------------------
            //    List<SysDept> getList = Ajdb.GetList<SysDept>("","");
            //    foreach(SysDept getItem in getList) {
            //        Console.WriteLine(getItem.Name);
            //    }

            //    getList = Ajdb.GetList<SysDept>("","",1,100);

            //    MessageBox.Show(getDept.Name);
            //}
        }