static void DataQuery() { ZeroDbs.ILog log = ZeroDbs.Logs.Factory.GetLogger("sql", 7); dbService = new ZeroDbs.Common.DbService( new ZeroDbs.Common.DbExecuteSqlEvent((sender, e) => { #if DEBUG log.Writer("DbKey={0}&ExecuteType={1}&ExecuteSql=\r\n{2}\r\n&ExecuteResult={3}", e.DbKey, e.ExecuteType, e.ExecuteSql != null && e.ExecuteSql.Count > 0 ? string.Join("\r\n", e.ExecuteSql.ToArray()) : "no sql", e.Message); #endif }), new ZeroDbs.Common.LocalMemCache(null)); /*long page = 1; * long pageSize = 1000; * var pageData = dbService.Page<MyDbs.TestDb.tArticleCategory>(page, pageSize, "ID>0"); * if (pageData.Total > 0) * { * foreach (MyDbs.TestDb.tArticleCategory m in pageData.Items) * { * Console.WriteLine("{0}\t{1}\t{2}\n", m.ID, m.Name, m.IsDel); * } * Console.WriteLine("total={0}&page={1}&pageSize={2}¤tPageListCount={3}", pageData.Total, page, pageSize, pageData.Items.Count); * } * else * { * Console.WriteLine("no data"); * }*/ using (var cmd = dbService.GetDbCommand <MyDbs.TestDb.tArticleCategory>()) { cmd.CommandText = "SELECT * FROM T_ArticleCategory"; cmd.ExecuteReader <MyDbs.TestDb.tArticleCategory>((result) => { Console.WriteLine("[{3}]{0}\t{1}\t{2}\n", result.RowData.ID, result.RowData.Name, result.RowData.IsDel, result.RowNum); //result.Next = false; }, true); } Console.WriteLine("读取结束!"); }
static void DataQuery2() { ZeroDbs.ILog log = ZeroDbs.Logs.Factory.GetLogger("sql", 7); dbService = new ZeroDbs.Common.DbService( new ZeroDbs.Common.DbExecuteSqlEvent((sender, e) => { #if DEBUG log.Writer("DbKey={0}&ExecuteType={1}&ExecuteSql=\r\n{2}\r\n&ExecuteResult={3}", e.DbKey, e.ExecuteType, e.ExecuteSql != null && e.ExecuteSql.Count > 0 ? string.Join("\r\n", e.ExecuteSql.ToArray()) : "no sql", e.Message); #endif }), new ZeroDbs.Common.LocalMemCache(null)); /*List<MyDbs.LocalFiles.tUploadRecord> fileRecords = new List<MyDbs.LocalFiles.tUploadRecord>(); * for (var i=0;i<5; i++) * { * fileRecords.Add(new MyDbs.LocalFiles.tUploadRecord * { * ID = 0, * FilePath = "D:\\works\\a"+i+".txt", * FileCreationTime = DateTime.Now, * FileLastWriteTime = DateTime.Now, * FileUploadTime = DateTime.Now, * FileUploadStatus = 0, * FileUploadStatusRemark = "待上传(新加入)" * }); * } * dbService.Insert(fileRecords);*/ var records = dbService.Select <MyDbs.LocalFiles.tUploadRecord>(""); foreach (var m in records) { Console.WriteLine("{0}\t{1}", m.ID, m.FilePath); } dbService.Update(records); }