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);
}
