/// <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); //} }
void doQuery() { AjQuery ajResult = null; switch (tablename) { case "sys_uuid": ajResult = Mydb.Query <sys_uuid>("", "", pageIndex, pageSize, AjQueryType.QueryAll, null); break; case "sysdept": ajResult = Mydb.Query <SysDept>("", "", pageIndex, pageSize, AjQueryType.QueryAll, null); break; } dgv_int.Columns.Clear(); dgv_int.AutoGenerateColumns = true; dgv_int.DataSource = ajResult.DataTable; pageCount = ajResult.PageCount; txt_PageTip.Text = "共:" + ajResult.RecordCount + "条记录,当前第:" + ajResult.PageIndex + "页,共:" + ajResult.PageCount + ",每页显示:" + ajResult.PageSize + "条记录"; }
private void btn_MultiQuery_Click(object sender, EventArgs e) { Mydb.Query <sysuser>("", ""); }