/// <summary>
/// 临时数据刷进数据库，仅支持sqlserver
/// </summary>
/// <param name="database"></param>
/// <returns></returns>
public bool FlushToTable(string database = "DefaultDB", string insertDuplicate = null)
{
if (Count() == 0)
{
return(true);
}
if (string.IsNullOrEmpty(TabName))
{
throw new Exception("未定义表名");
}
DataContextMoudle <T> dataContext = DataContextMoudelFactory <T> .GetDataContext(database);
if (dataContext is MSSqlDataContextMoudle <T> )
{
return(SqlServerFlush(dataContext));
}
else if (dataContext is MySqlDataContextMoudle <T> )
{
return(MysqlServerFlush(dataContext, insertDuplicate));
}
throw new NotImplementedException();
}
public void Fun99()
{
long nid = 0;
List <GubaBandResultEntity> list = null;
Console.WriteLine("开始读数据");
while ((list = DataContextMoudelFactory <GubaBandResultEntity> .GetDataContext("ConndbDB$GubaData").WhereBiger(p => p.ID, nid).Top(10000).OrderBy(p => p.ID).ExecuteList()).Count > 0)
{
nid = list.Last().ID;
int findcount = 0;
DateTime now = DateTime.Now;
ProcessTraceUtil.StartTrace();
foreach (var item in list)
{
var re = BigEntityTableEngine.LocalEngine.Find <GubaBandResultEntity>("GubaBandResultEntity", "GubaCode_Uid_Recount", new object[] { item.GubaCode, item.Uid, item.Recount });
if (re.Count() == 0)
{
Console.WriteLine("找不到数据:" + item.GubaCode + "," + item.Uid + "," + item.Recount);
Console.Read();
}
else
{
findcount++;
}
}
LJC.FrameWork.LogManager.LogHelper.Instance.Debug("查找：" + ProcessTraceUtil.PrintTrace());
Console.WriteLine("找到数:" + findcount + ",用时" + (DateTime.Now.Subtract(now).TotalMilliseconds) + "ms");
}
Console.WriteLine("读数据完成");
}
static void Main(string[] args)
{
var maxid = DataContextMoudelFactory <NewsEntity> .GetDataContext("ConndbDB$CjzfDB").Max("id");
//var maxid = 304734;
List <NewsEntity> list;
while ((list = DataContextMoudelFactory <NewsEntity> .GetDataContext("ConndbDB$CjzfDB")
.WhereSmallerEq(p => p.Id, maxid)
.WhereNotEq(p => p.Class, "公告")
.OrderByDesc(p => p.Id)
.Top(1000).ExecuteList()).Count > 0)
{
maxid = list.Last().Id - 1;
try
{
Console.WriteLine("开始写入新闻：" + list.Count + "条");
int count = 0;
foreach (var news in list)
{
count++;
try
{
var doc = new ES.Core.ESDocument <NewsEntity>();
doc.Document = new NewsEntity
{
Class = news.Class,
Title = news.Title,
NewsDate = news.NewsDate,
Source = news.Source,
Content = news.Content,
Id = news.Id,
};
doc.DocumentID = news.Id.ToString();
doc.DocumentType = "news";
doc.IndexName = "cjzf.news";
escore.Index <NewsEntity>(doc);
Console.WriteLine("写入新闻成功,第" + count + "条,新闻ID：" + news.Id + "：" + news.Title);
}
catch (Exception ex)
{
Console.WriteLine("写入新闻失败,第" + count + "条," + news.Id + "：" + ex.Message);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
Console.Read();
}
static void Main0(string[] args)
{
for (int i = 0; i < 1000000; i++)
{
List <StockCmd> stockCmds = DataContextMoudelFactory <StockCmd> .GetDataContext()
//.WhereSmallerEq("CreateTime", DateTime.Now)
.WhereBigerEq("EffDate", DateTime.Now.Date)
.ExecuteList();
Console.WriteLine(i);
Thread.Sleep(2);
}
Console.Read();
}
public void Fun98()
{
BigEntityTableEngine.LocalEngine.CreateTable("GubaBandResultEntity", "ID", typeof(GubaBandResultEntity), new IndexInfo[] {
new IndexInfo
{
IndexName = "GubaCode_Uid_Recount",
Indexs = new IndexItem[]
{
new IndexItem
{
Direction = 1,
Field = "GubaCode",
FieldType = LJC.FrameWork.EntityBuf.EntityType.STRING
},
new IndexItem
{
Direction = 1,
Field = "Uid",
FieldType = LJC.FrameWork.EntityBuf.EntityType.STRING
},
new IndexItem
{
Direction = -1,
Field = "Recount",
FieldType = LJC.FrameWork.EntityBuf.EntityType.INT32
}
}
}
});
long nid = 0;
List <GubaBandResultEntity> list = null;
Console.WriteLine("开始读数据");
while ((list = DataContextMoudelFactory <GubaBandResultEntity> .GetDataContext("ConndbDB$GubaData").WhereBiger(p => p.ID, nid).Top(10000).OrderBy(p => p.ID).ExecuteList()).Count > 0)
{
nid = list.Last().ID;
Console.WriteLine("nid:" + nid);
DateTime now = DateTime.Now;
BigEntityTableEngine.LocalEngine.InsertBatch("GubaBandResultEntity", list);
Console.WriteLine("写入完成:" + (DateTime.Now.Subtract(now).TotalMilliseconds + "ms"));
}
Console.WriteLine("读数据完成");
}
private void TestKeyWord()
{
BigEntityTableEngine.LocalEngine.CreateTable("NewsKeysEntity", "NewsKeysID", typeof(NewsKeysEntity), new IndexInfo[] {
new IndexInfo
{
IndexName = "NewsID",
Indexs = new IndexItem[]
{
new IndexItem
{
Direction = 1,
Field = "NewsID",
FieldType = LJC.FrameWork.EntityBuf.EntityType.INT64
}
}
}, new IndexInfo
{
IndexName = "Keys",
Indexs = new IndexItem[]
{
new IndexItem
{
Direction = 1,
Field = "Keys",
FieldType = LJC.FrameWork.EntityBuf.EntityType.STRING
}
}
}
});
long nid = 0;
List <NewsKeysEntity> list = null;
Console.WriteLine("开始读数据");
while ((list = DataContextMoudelFactory <NewsKeysEntity> .GetDataContext("ConndbDB$CjzfDB").WhereBiger(p => p.NewsKeysID, nid).Top(10000).OrderBy(p => p.NewsKeysID).ExecuteList()).Count > 0)
{
nid = list.Last().NewsKeysID;
Console.WriteLine("nid:" + nid);
DateTime now = DateTime.Now;
BigEntityTableEngine.LocalEngine.InsertBatch("NewsKeysEntity", list);
Console.WriteLine("写入完成:" + (DateTime.Now.Subtract(now).TotalMilliseconds + "ms"));
}
Console.WriteLine("读数据完成");
}
static void Main00(string[] args)
{
//
var et = DataContextMoudelFactory <NewsEntity> .GetDataContext().WhereEq(p => p.Id, 16751).ExecuteEntity();
et.Mdate = DateTime.Now;
et.Keywords = "修改了2233";
et.Content = string.Empty;
bool boo = DataContextMoudelFactory <NewsEntity> .GetDataContext(et).NotUpdate(p => p.Content, p => p.Mdate);
return;
var str = LJC.FrameWork.Comm.StringHelper.ChineseCap("工商银行");
//var bytes = new byte[] { 0x01};
//var bb = LJC.FrameWork.Comm.GZip.Compress(bytes);
//bool boo = LJC.FrameWork.Comm.StringHelper.IsUserAccount("李大",2,20);
LJC.FrameWork.SOA.ESBConfig.WriteConfig("ljcserver", 9990, true);
var config = LJC.FrameWork.SOA.ESBConfig.ReadConfig();
return;
SOAServicesTest soasevice = new SOAServicesTest(1);
soasevice.StartClient();
soasevice.LoginFail += () =>
{
Console.WriteLine(soasevice.ServiceNo);
};
soasevice.LoginSuccess += () =>
{
//soasevice.Logout();
};
soasevice.Login("1", "1");
Console.Read();
soasevice.Logout();
}
public static long LogToDB(Log log)
{
//new DataContextMoudle<Log>(log).Add();
return(DataContextMoudelFactory <Log> .GetDataContext(log).Add());
}
public List <Log> ReadLog()
{
//return new DataContextMoudle<Log>().WhereBigerEq("Level", level).ExecuteList();
return(DataContextMoudelFactory <Log> .GetDataContext().WhereBigerEq("Level", level).ExecuteList());
}
public List <Log> ReadLog()
{
//return new DataContextMoudle<Log>().WhereEq("Category", cateGory).ExecuteList();
return(DataContextMoudelFactory <Log> .GetDataContext().WhereEq("Category", cateGory).ExecuteList());
}
