public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer)
{
var collection = new List <NewsArticle>();
NewsArticle item = null;
while (reader.Read())
{
switch (reader.TokenType)
{
case JsonToken.StartObject:
item = new NewsArticle();
collection.Add(item);
break;
case JsonToken.PropertyName:
SetProperty(reader, item);
break;
case JsonToken.EndArray:
return(collection);
}
}
return(collection);
}
public HttpResponseMessage Add(int categoryId, int articleTypeId)
{
try
{
var articleType = _articleRepository.FetchType(articleTypeId);
if (articleType.Name == "News")
{
var obj = NewsArticle.NewNewsArticle(categoryId, _articleRepository);
return(Request.CreateResponse(HttpStatusCode.OK, obj.GetJSONModel()));
}
if (articleType.Name == "Review")
{
var obj = ReviewArticle.NewReviewArticle(categoryId);
return(Request.CreateResponse(HttpStatusCode.OK, obj.GetJSONModel()));
}
throw new ArgumentException("Unknown Article Type");
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public IActionResult Details(int id)
{
if (id == 0)
{
return(NotFound());
}
NewsArticle newsArticle = newsArticleService.GetByID(id);
if (newsArticle == null)
{
return(NotFound());
}
NewsArticleCategory category = newsArticleCategoryService.GetByID(newsArticle.CategoryID);
NewsArticleDetailsViewModel viewModel = new NewsArticleDetailsViewModel
{
NewsArticle = newsArticle,
NewsArticleCategory = category ?? null
};
return(View(viewModel));
}
public static NewsArticle ToNewsArticleEntity(
NewsArticleModel newsArticleModel,
DbUsersRepository usersRepository,
IRepository <Comment> commentsRepository)
{
NewsArticle newsArticleEntity = new NewsArticle()
{
ID = newsArticleModel.ID,
Author = usersRepository.GetByNickname(newsArticleModel.Author),
Content = newsArticleModel.Content,
Date = newsArticleModel.Date,
ImagesUrls = newsArticleModel.ImagesUrls,
Rating = newsArticleModel.Rating,
Title = newsArticleModel.Title
};
foreach (CommentModel comment in newsArticleModel.Comments)
{
newsArticleEntity.Comments.Add(
Extensions.CreateOrLoadComment(comment, commentsRepository, usersRepository));
}
return(newsArticleEntity);
}
public IList <NewsArticle> FindALL(object cid)
{
List <NewsArticle> list = new List <NewsArticle>();
if (cid != null && cid.ToString() != "")
{
sql = "select * from NewsArticle where cid=" + cid + " order by id desc";
}
else
{
sql = "select * from NewsArticle order by id desc";
}
ds = DbHelperSQL.GetDataSet(sql);
if (ds == null)
{
return(null);
}
else
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
NewsArticle a = new NewsArticle();
a.AddDate = Convert.ToDateTime(dr["addDate"].ToString());
a.Cid = dr["cid"];
a.Content = dr["Content"].ToString();
a.Hits = Convert.ToInt32(dr["hits"]);
a.Id = dr["id"];
a.Title = dr["Title"].ToString();
a.Writer = dr["Writer"].ToString();
list.Add(a);
}
return(list);
}
}
public void DeleteAfterDate()
{
var newsArticle = new NewsArticle()
{
Title = "test", PublishedDate = DateTime.Now.AddDays(-1)
};
_sportsContext.NewsArticles.Add(newsArticle);
Assert.NotEqual(Guid.Empty, newsArticle.NewsArticleId);
_sportsContext.NewsArticlesComments.Add(new NewsArticleComment()
{
NewsArticleId = newsArticle.NewsArticleId,
Text = string.Empty
});
_sportsContext.SaveChanges();
Assert.True(_sportsContext.NewsArticlesComments.Any());
Assert.True(_sportsContext.NewsArticles.Any());
_syncService.DeleteOldData(DateTimeOffset.Now);
Assert.False(_sportsContext.NewsArticlesComments.Any());
Assert.False(_sportsContext.NewsArticles.Any());
}
public void WhenShowNewsReaderCommandInvokes_RegionIsNavigated()
{
// Prepare
NewsArticle newsArticle = new NewsArticle();
var tickerSymbolSelectedEvent = new Mock <TickerSymbolSelectedEvent>().Object;
Mock <INewsFeedService> mockNewsFeedService = new Mock <INewsFeedService>();
Mock <IRegionManager> mockRegionManager = new Mock <IRegionManager>();
Mock <IEventAggregator> mockEventAggregator = new Mock <IEventAggregator>();
mockEventAggregator.Setup(x => x.GetEvent <TickerSymbolSelectedEvent>()).Returns(tickerSymbolSelectedEvent);
INewsFeedService newsFeedService = mockNewsFeedService.Object;
IRegionManager regionManager = mockRegionManager.Object;
IEventAggregator eventAggregator = mockEventAggregator.Object;
ArticleViewModel target = new ArticleViewModel(newsFeedService, regionManager, eventAggregator);
bool propertyChangedRaised = false;
target.PropertyChanged += delegate(object sender, PropertyChangedEventArgs e)
{
if (e.PropertyName == "SelectedArticle")
{
propertyChangedRaised = true;
}
};
// Act
target.SelectedArticle = newsArticle;
// Verify
Assert.AreEqual(newsArticle, target.SelectedArticle);
Assert.IsTrue(propertyChangedRaised);
}
// GET: NewsArticles/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
NewsArticle newsArticle = db.NewsArticles.Find(id);
if (newsArticle == null)
{
return(HttpNotFound());
}
var newsEditorModel = new NewsEditorModel
{
Editor = new Editor(System.Web.HttpContext.Current, "NewsEditor"),
SelectedArticle = newsArticle
};
newsEditorModel.Editor.LoadFormData(newsArticle.Content);
newsEditorModel.Editor.MvcInit();
return(View(newsEditorModel));
}
public void updateCompanyData(NewsArticle article)
{
foreach (Company company in Globals.companies)
{
if (company.getName() == (article.getCompany().getName()))
{
Debug.Log("stonk " + company.getStonkValue());
float onePercent = company.getStonkValue() / 100;
float totalPercent = onePercent * article.getScore();
if ((float)company.getStonkValue() + totalPercent <= 100)
{
company.setStonkValue(100);
}
else
{
company.setStonkValue(Mathf.RoundToInt((float)company.getStonkValue() + totalPercent));
}
company.updateStonkHistory(article.getHourCreated(), company.getStonkValue());
Debug.Log(company.getStonkValue());
}
}
}
public bool AllowArticle(NewsArticle newsArticle, string searchTerm, KeyValueStorage storage)
{
Uri uri = new Uri(newsArticle.Url);
string domain = String.Join(".", TakeLast(uri.Host.Split('.'),
IsThreePartDomain(uri.Host) ? 3 : 2));
InitializeDomainRater(storage);
int minimumMonthlyVisitors = storage.GetInteger(
DomainRatingNewsFilterSettingsPage.MinimumMonthlyVisitorsKey);
if (minimumMonthlyVisitors <= 0)
{
return(true);
}
DomainRating rating = _domainRater.GetDomainRating(domain);
if (rating.Decision == DomainRatingDecision.Whitelisted)
{
return(true);
}
else if (rating.Decision == DomainRatingDecision.Blacklisted)
{
return(false);
}
bool allow = rating.MonthlyVisitors >= minimumMonthlyVisitors;
if (!allow)
{
System.Diagnostics.Debug.WriteLine("Not allowing domain " +
domain + " " + rating);
}
return(allow);
}
public void SetNewsArticleUpdatesProperty()
{
var target = new NewsReaderViewModel();
bool propertyChangedRaised = false;
target.PropertyChanged += delegate(object sender, PropertyChangedEventArgs e)
{
if (e.PropertyName == "NewsArticle")
{
propertyChangedRaised = true;
}
};
NewsArticle article = new NewsArticle()
{
Title = "My Title", Body = "My Body"
};
target.NewsArticle = article;
Assert.AreSame(article, target.NewsArticle);
Assert.IsTrue(propertyChangedRaised);
}
/// <summary>
/// 修改永久图文素材
/// </summary>
/// <param name="media_id">要修改的图文消息的id</param>
/// <param name="index">要更新的文章在图文消息中的位置（多图文消息时，此字段才有意义），第一篇为0</param>
/// <param name="article">文章信息</param>
/// <param name="config"></param>
/// <returns></returns>
public static Task UpdateNews(string media_id, int index, NewsArticle article, ApiConfig config = null)
{
return(ApiHelper.PostVoid("https://api.weixin.qq.com/cgi-bin/material/update_news?$acac$", new { media_id, index, articles = article }, config));
}
/// <summary>
/// Put the message in cache.
/// </summary>
/// <param name="article">Article.</param>
protected void PutInCache(NewsArticle article)
{
PutInCache(article, null);
}
public void DeleteApod(NewsArticle newsItem)
{
NewsCollection.Remove(newsItem);
}
public bool AllowArticle(NewsArticle newsArticle, string searchTerm, KeyValueStorage storage)
{
Mapping.Load(storage);
return(!FilteredOrganizations.Contains(newsArticle.OrganizationName));
}
public void AddNew(NewsArticle newsArticle)
{
_inMemoryNews.Add(newsArticle);
}
public long Insert(NewsArticle entity)
{
db.NewsArticles.Add(entity);
db.SaveChanges();
return(entity.id);
}
// Retrieves all news of a specific game.
public NewsArticle[] GetNews(int appId, int count, int length)
{
return(NewsArticle.Query(appId, count, length));
}
public Window CreateQuickFilterWindow(NewsArticle newsArticle, KeyValueStorage storage)
{
return(null);
}
void IEWrapper.NewsArticle(int requestId, int articleType, string articleText)
{
NewsArticle?.Invoke(new NewsArticleMessage(requestId, articleType, articleText));
}
public void SaveArticle(NewsArticle article)
{
_newsArticleRepository.AddArticle(article);
}
public void SetNewsArticle(NewsArticle article)
{
SetNewsArticleCalled = true;
}
public void CurrentNewsArticleChanged(NewsArticle article)
{
this.readerPresenter.SetNewsArticle(article);
}
public void OnDialogOpened(IDialogParameters parameters)
{
NewsArticle = parameters.GetValue <NewsArticle>("NewsArticle");
}
public void PersistArticle(NewsArticle article)
{
this.Data.NewsArticles.Add(article);
this.Data.SaveChanges();
}
public ViewArticles()
{
Articles = new NewsArticle[0];
ImageRelativePath = string.Empty;
PodcastRelativePath = string.Empty;
}
public void Test1()
{
var dcksdkdsk = g.sqlite.Select <NewsArticle>().Where(a => a.testaddtime2.HasValue).ToSql();
var dcksdkdsk2 = g.sqlite.Select <NewsArticle>().Where(a => !a.testaddtime2.HasValue).ToSql();
var testgrpsql = g.sqlite.Select <TaskBuild>()
.From <Templates>((a, b) => a.InnerJoin(aa => aa.TemplatesId
== b.Id2))
.GroupBy((a, b) => b.Code)
.ToSql(a => new
{
a.Key,
sss = a.Sum(a.Value.Item1.Id),
sss2 = a.Sum(a.Value.Item2.Id2)
});
var testgrpsql2 = g.sqlite.Select <TaskBuild>()
.From <Templates>((a, b) => a.InnerJoin(aa => aa.TemplatesId
== b.Id2))
.GroupBy((a, b) => b.Code)
.ToList(a => new
{
a.Key,
sss = a.Sum(a.Value.Item1.Id),
sss2 = a.Sum(a.Value.Item2.Id2)
});
var tbid = g.sqlite.Select <TaskBuild>().First()?.Id ?? Guid.Empty;
var testarray = new[] { 1, 2, 3 };
var tbidsql = g.sqlite.Update <TaskBuild>().Where(a => a.Id == tbid)
.Set(a => new TaskBuild
{
FileName = "111",
TaskName = a.TaskName + "333",
OptionsEntity02 = false,
OptionsEntity04 = testarray[0]
}).ToSql();
var dkdkdkd = g.oracle.Select <Templates>().ToList();
//var testaddlist = new List<NewsArticle>();
//for(var a = 0; a < 133905; a++) {
// testaddlist.Add(new NewsArticle {
// ArticleTitle = "testaddlist_topic" + a,
// Hits = a,
// });
//}
//g.sqlite.Insert<NewsArticle>(testaddlist)
// //.NoneParameter()
// .ExecuteAffrows();
g.mysql.Aop.ParseExpression = (s, e) =>
{
if (e.Expression.NodeType == ExpressionType.Call)
{
var callExp = e.Expression as MethodCallExpression;
if (callExp.Object?.Type == typeof(DateTime) &&
callExp.Method.Name == "ToString" &&
callExp.Arguments.Count == 1 &&
callExp.Arguments[0].Type == typeof(string) &&
callExp.Arguments[0].NodeType == ExpressionType.Constant)
{
var format = (callExp.Arguments[0] as ConstantExpression)?.Value?.ToString();
if (string.IsNullOrEmpty(format) == false)
{
var tmp = e.FreeParse(callExp.Object);
switch (format)
{
case "yyyy-MM-dd HH:mm":
tmp = $"date_format({tmp}, '%Y-%m-%d %H:%i')";
break;
}
e.Result = tmp;
}
}
}
};
g.mysql.Select <NewsArticle>().ToList(a => new
{
testaddtime = a.testaddtime.ToString("yyyy-MM-dd HH:mm")
});
var ttdkdk = g.mysql.Select <NewsArticle>().Where <TaskBuild>(a => a.NamespaceName == "ddd").ToSql();
var tsqlddd = g.sqlite.Select <NewsArticle>().Where(a =>
g.sqlite.Select <TaskBuild>().Where(b => b.NamespaceName == a.ArticleTitle)
.Where("@id=1", new { id = 1 }).Any()
).ToSql();
g.sqlite.SetDbContextOptions(opt => opt.EnableAddOrUpdateNavigateList = true);
var trepo = g.sqlite.GetGuidRepository <TaskBuild>();
trepo.Insert(new TaskBuild
{
TaskName = "tt11",
Builds = new[] {
new TaskBuildInfo {
Level = 1,
Name = "t111_11"
}
}
});
var ttdkdkd = trepo.Select.Where(a => a.Builds.AsSelect().Any()).ToList();
var list1113233 = trepo.Select.ToList();
var entity = new NewsArticle
{
ArticleId = 1,
ArticleTitle = "测试标题"
};
var where = new NewsArticle
{
ArticleId = 1,
ChannelId = 1,
};
g.mysql.Insert(new[] { entity }).ExecuteAffrows();
var sqldddkdk = g.mysql.Update <NewsArticle>(where)
.SetSource(entity)
.UpdateColumns(x => new { x.Status, x.CategoryId, x.ArticleTitle })
.ToSql();
var sqldddklist = g.mysql.Select <NewsArticle>().Select(a => new NewsArticleDto {
}).ToList();
var sql1111333 = g.mysql.Update <Model2>()
.SetSource(new Model2 {
id = 1, Title = "xxx", Parent_id = 0
})
.UpdateColumns(x => new { x.Parent_id, x.Date, x.Wa_xxx2 })
.NoneParameter()
.ToSql();
g.sqlite.Insert(new TestEnum {
}).ExecuteAffrows();
var telist = g.sqlite.Select <TestEnum>().ToList();
Assert.Throws <Exception>(() => g.sqlite.CodeFirst.SyncStructure <TestEnumable>());
var TestEnumable = new TestEnumable();
g.sqlite.GetRepository <Model1, int>().Insert(new Model1
{
title = "test_" + DateTime.Now.ToString("yyyyMMddHHmmss"),
M2Id = DateTime.Now.Second + DateTime.Now.Minute,
Childs = new[] {
new Model2 {
Title = "model2Test_title_" + DateTime.Now.ToString("yyyyMMddHHmmss") + "0001",
},
new Model2 {
Title = "model2Test_title_" + DateTime.Now.ToString("yyyyMMddHHmmss") + "0002",
},
new Model2 {
Title = "model2Test_title_" + DateTime.Now.ToString("yyyyMMddHHmmss") + "0003",
},
new Model2 {
Title = "model2Test_title_" + DateTime.Now.ToString("yyyyMMddHHmmss") + "0004",
}
}
});
var includet1 = g.sqlite.Select <Model1>()
.IncludeMany(a => a.Childs.Take(2), s => s.Where(a => a.id > 0))
.IncludeMany(a => a.TestManys.Take(1).Where(b => b.id == a.id))
.Where(a => a.id > 10)
.ToList();
var ttt1 = g.sqlite.Select <Model1>().Where(a => a.Childs.AsSelect().Any(b => b.Title == "111")).ToList();
var linqto1 =
from p in g.sqlite.Select <Order>()
where p.Id >= 0
// && p.OrderDetails.AsSelect().Where(c => c.Id > 10).Any()
orderby p.Id descending
orderby p.CustomerName ascending
select new { Name = p.CustomerName, Length = p.Id };
var testddd = new TestEntity
{
Test = 22,
Title = "xxx"
};
//testddd.Persistent().Wait();
g.sqlite.GetRepository <TestEntity, int>().Insert(testddd);
var testpid1 = g.mysql.Insert <TestTypeInfo>().AppendData(new TestTypeInfo {
Name = "Name" + DateTime.Now.ToString("yyyyMMddHHmmss")
}).ExecuteIdentity();
g.mysql.Insert <TestInfo>().AppendData(new TestInfo {
Title = "Title" + DateTime.Now.ToString("yyyyMMddHHmmss"), CreateTime = DateTime.Now, TypeGuid = (int)testpid1
}).ExecuteAffrows();
var aggsql1 = select
.GroupBy(a => a.Title)
.ToSql(b => new
{
b.Key,
cou = b.Count(),
sum = b.Sum(b.Key),
sum2 = b.Sum(b.Value.TypeGuid)
});
var aggtolist1 = select
.GroupBy(a => a.Title)
.ToList(b => new
{
b.Key,
cou = b.Count(),
sum = b.Sum(b.Key),
sum2 = b.Sum(b.Value.TypeGuid)
});
var aggsql2 = select
.GroupBy(a => new { a.Title, yyyy = string.Concat(a.CreateTime.Year, '-', a.CreateTime.Month) })
.ToSql(b => new
{
b.Key.Title,
b.Key.yyyy,
cou = b.Count(),
sum = b.Sum(b.Key.yyyy),
sum2 = b.Sum(b.Value.TypeGuid)
});
var aggtolist2 = select
.GroupBy(a => new { a.Title, yyyy = string.Concat(a.CreateTime.Year, '-', a.CreateTime.Month) })
.ToList(b => new
{
b.Key.Title,
b.Key.yyyy,
cou = b.Count(),
sum = b.Sum(b.Key.yyyy),
sum2 = b.Sum(b.Value.TypeGuid)
});
var aggsql3 = select
.GroupBy(a => a.Title)
.ToSql(b => new
{
b.Key,
cou = b.Count(),
sum = b.Sum(b.Key),
sum2 = b.Sum(b.Value.TypeGuid),
sum3 = b.Sum(b.Value.Type.Parent.Parent.Id)
});
var sqlrepos = g.sqlite.GetRepository <TestTypeParentInfo, int>();
sqlrepos.Insert(new TestTypeParentInfo
{
Name = "testroot",
Childs = new[] {
new TestTypeParentInfo {
Name = "testpath2",
Childs = new[] {
new TestTypeParentInfo {
Name = "testpath3",
Childs = new[] {
new TestTypeParentInfo {
Name = "11"
}
}
}
}
}
}
});
var sql = g.sqlite.Select <TestTypeParentInfo>().Where(a => a.Parent.Parent.Parent.Name == "testroot").ToSql();
var sql222 = g.sqlite.Select <TestTypeParentInfo>().Where(a => a.Parent.Parent.Parent.Name == "testroot").ToList();
Expression <Func <TestInfo, object> > orderBy = null;
orderBy = a => a.CreateTime;
var testsql1 = select.OrderBy(orderBy).ToSql();
orderBy = a => a.Title;
var testsql2 = select.OrderBy(orderBy).ToSql();
var testjson = @"[
{
""acptNumBelgCityName"":""泰州"",
""concPrsnName"":""常**"",
""srvReqstTypeName"":""家庭业务→网络质量→家庭宽带→自有宽带→功能使用→游戏过程中频繁掉线→全局流转"",
""srvReqstCntt"":""客户来电表示宽带使用（ 所有）出现（频繁掉线不稳定） ，客户所在地址为（安装地址泰州地区靖江靖城街道工农路科技小区科技3区176号2栋2单元502），联系方式（具体联系方式），烦请协调处理。"",
""acptTime"":""2019-04-15 15:17:05"",
""acptStaffDeptId"":""0003002101010001000600020023""
},
{
""acptNumBelgCityName"":""苏州"",
""concPrsnName"":""龚**"",
""srvReqstTypeName"":""移动业务→基础服务→账/详单→全局流转→功能使用→账/详单信息不准确→全局流转"",
""srvReqstCntt"":""用户参与 2018年苏州任我用关怀活动 送的分钟数500分钟，说自己只使用了116分钟，但是我处查询到本月已经使用了306分钟\r\n，烦请处理"",
""acptTime"":""2019-04-15 15:12:05"",
""acptStaffDeptId"":""0003002101010001000600020023""
}
]";
//var dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<string, dynamic>>(testjson);
var reqs = Newtonsoft.Json.JsonConvert.DeserializeObject <List <ServiceRequestNew> >(testjson);
reqs.ForEach(t =>
{
g.oracle.Insert <ServiceRequestNew>(t).ExecuteAffrows();
});
var sql111 = g.sqlite.Select <TestUser>().AsTable((a, b) => "(select * from TestUser where stringid > 10)").Page(1, 10).ToSql();
var xxx = g.sqlite.Select <TestUser>().GroupBy(a => new { a.stringid }).ToList(a => a.Key.stringid);
var tuser = g.sqlite.Select <TestUser>().Where(u => u.accname == "admin")
.InnerJoin(a => a.LogOn.id == a.stringid).ToSql();
var parentSelect1 = select.Where(a => a.Type.Parent.Parent.Parent.Parent.Name == "").Where(b => b.Type.Name == "").ToSql();
var collSelect1 = g.mysql.Select <Order>().Where(a =>
a.OrderDetails.AsSelect().Any(b => b.Id > 100)
);
var collectionSelect = select.Where(a =>
//a.Type.Guid == a.TypeGuid &&
//a.Type.Parent.Id == a.Type.ParentId &&
a.Type.Parent.Types.AsSelect().Where(b => b.Name == a.Title).Any(
//b => b.ParentId == a.Type.Parent.Id
)
);
var collectionSelect2 = select.Where(a =>
a.Type.Parent.Types.AsSelect().Where(b => b.Name == a.Title).Any(
b => b.Parent.Name == "xxx" && b.Parent.Parent.Name == "ccc" &&
b.Parent.Parent.Parent.Types.AsSelect().Any(cb => cb.Name == "yyy")
)
);
var collectionSelect3 = select.Where(a =>
a.Type.Parent.Types.AsSelect().Where(b => b.Name == a.Title).Any(
bbb => bbb.Parent.Types.AsSelect().Where(lv2 => lv2.Name == bbb.Name + "111").Any(
)
)
);
var neworder = new Order
{
CustomerName = "testCustomer",
OrderTitle = "xxx#cccksksk",
TransactionDate = DateTime.Now,
OrderDetails = new List <OrderDetail>(new[] {
new OrderDetail {
},
new OrderDetail {
}
})
};
g.mysql.GetRepository <Order>().Insert(neworder);
var order = g.mysql.Select <Order>().Where(a => a.Id == neworder.Id).ToOne(); //查询订单表
if (order == null)
{
var orderId = g.mysql.Insert(new Order {
}).ExecuteIdentity();
order = g.mysql.Select <Order>(orderId).ToOne();
}
var orderDetail1 = order.OrderDetails; //第一次访问，查询数据库
var orderDetail2 = order.OrderDetails; //第二次访问，不查
var order1 = orderDetail1.FirstOrDefault().Order; //访问导航属性，此时不查数据库，因为 OrderDetails 查询出来的时候已填充了该属性
var queryable = g.mysql.Queryable <TestInfo>().Where(a => a.Id == 1).ToList();
var sql2222 = select.Where(a =>
select.Where(b => b.Id == a.Id &&
select.Where(c => c.Id == b.Id).Where(d => d.Id == a.Id).Where(e => e.Id == b.Id)
//.Offset(a.Id)
.Any()
).Any()
).ToList();
var groupbysql = g.mysql.Select <TestInfo>().From <TestTypeInfo, TestTypeParentInfo>((s, b, c) => s
.Where(a => a.Id == 1)
.WhereIf(false, a => a.Id == 2)
)
.WhereIf(true, (a, b, c) => a.Id == 3)
.GroupBy((a, b, c) => new { tt2 = a.Title.Substring(0, 2), mod4 = a.Id % 4 })
.Having(a => a.Count() > 0 && a.Avg(a.Key.mod4) > 0 && a.Max(a.Key.mod4) > 0)
.Having(a => a.Count() < 300 || a.Avg(a.Key.mod4) < 100)
.OrderBy(a => a.Key.tt2)
.OrderByDescending(a => a.Count()).ToSql(a => new
{
cou = a.Sum(a.Value.Item1.Id),
a.Key.mod4,
a.Key.tt2,
max = a.Max("a.id"),
max2 = Convert.ToInt64("max(a.id)")
});
var groupbysql2 = g.mysql.Select <TestInfo>().From <TestTypeInfo, TestTypeParentInfo>((s, b, c) => s
.Where(a => a.Id == 1)
.WhereIf(true, a => a.Id == 2)
)
.WhereIf(false, (a, b, c) => a.Id == 3)
.GroupBy((a, b, c) => new { tt2 = a.Title.Substring(0, 2), mod4 = a.Id % 4 })
.Having(a => a.Count() > 0 && a.Avg(a.Key.mod4) > 0 && a.Max(a.Key.mod4) > 0)
.Having(a => a.Count() < 300 || a.Avg(a.Key.mod4) < 100)
.OrderBy(a => a.Key.tt2)
.OrderByDescending(a => a.Count()).ToSql(a => a.Key.mod4);
var groupby = g.mysql.Select <TestInfo>().From <TestTypeInfo, TestTypeParentInfo>((s, b, c) => s
.Where(a => a.Id == 1)
.WhereIf(true, a => a.Id == 2)
)
.WhereIf(true, (a, b, c) => a.Id == 3)
.GroupBy((a, b, c) => new { tt2 = a.Title.Substring(0, 2), mod4 = a.Id % 4 })
.Having(a => a.Count() > 0 && a.Avg(a.Key.mod4) > 0 && a.Max(a.Key.mod4) > 0)
.Having(a => a.Count() < 300 || a.Avg(a.Key.mod4) < 100)
.OrderBy(a => a.Key.tt2)
.OrderByDescending(a => a.Count())
.ToList(a => new
{
a.Key.tt2,
cou1 = a.Count(),
arg1 = a.Avg(a.Key.mod4),
ccc2 = a.Key.tt2 ?? "now()",
//ccc = Convert.ToDateTime("now()"), partby = Convert.ToDecimal("sum(num) over(PARTITION BY server_id,os,rid,chn order by id desc)")
});
var arrg = g.mysql.Select <TestInfo>().ToAggregate(a => new { sum = a.Sum(a.Key.Id + 11.11), avg = a.Avg(a.Key.Id), count = a.Count(), max = a.Max(a.Key.Id), min = a.Min(a.Key.Id) });
var arrg222 = g.mysql.Select <NullAggreTestTable>().ToAggregate(a => new { sum = a.Sum(a.Key.Id + 11.11), avg = a.Avg(a.Key.Id), count = a.Count(), max = a.Max(a.Key.Id), min = a.Min(a.Key.Id) });
var t1 = g.mysql.Select <TestInfo>().Where("").Where(a => a.Id > 0).Skip(100).Limit(200).ToList();
var t2 = g.mysql.Select <TestInfo>().As("b").Where("").Where(a => a.Id > 0).Skip(100).Limit(200).ToList();
var sql1 = select.LeftJoin(a => a.Type.Guid == a.TypeGuid).ToList();
var sql2 = select.LeftJoin <TestTypeInfo>((a, b) => a.TypeGuid == b.Guid && b.Name == "111").ToList();
var sql3 = select.LeftJoin("TestTypeInfo b on b.Guid = a.TypeGuid").ToList();
//g.mysql.Select<TestInfo, TestTypeInfo, TestTypeParentInfo>().Join((a, b, c) => new Model.JoinResult3(
// Model.JoinType.LeftJoin, a.TypeGuid == b.Guid,
// Model.JoinType.InnerJoin, c.Id == b.ParentId && c.Name == "xxx")
//);
//var sql4 = select.From<TestTypeInfo, TestTypeParentInfo>((a, b, c) => new SelectFrom()
// .InnerJoin(a.TypeGuid == b.Guid)
// .LeftJoin(c.Id == b.ParentId)
// .Where(b.Name == "xxx"))
//.Where(a => a.Id == 1).ToSql();
var sql4 = select.From <TestTypeInfo, TestTypeParentInfo>((s, b, c) => s
.InnerJoin(a => a.TypeGuid == b.Guid)
.LeftJoin(a => c.Id == b.ParentId)
.Where(a => b.Name == "xxx")).ToList();
//.Where(a => a.Id == 1).ToSql();
var list111 = select.From <TestTypeInfo, TestTypeParentInfo>((s, b, c) => s
.InnerJoin(a => a.TypeGuid == b.Guid)
.LeftJoin(a => c.Id == b.ParentId)
.Where(a => b.Name != "xxx"))
.ToList((a, b, c) => new
{
a.Id,
a.Title,
a.Type,
ccc = new { a.Id, a.Title },
tp = a.Type,
tp2 = new
{
a.Id,
tp2 = a.Type.Name
},
tp3 = new
{
a.Id,
tp33 = new
{
a.Id
}
}
});
var ttt122 = g.mysql.Select <TestTypeParentInfo>().Where(a => a.Id > 0).ToList();
var sql5 = g.mysql.Select <TestInfo>().From <TestTypeInfo, TestTypeParentInfo>((s, b, c) => s).Where((a, b, c) => a.Id == b.ParentId).ToList();
//((JoinType.LeftJoin, a.TypeGuid == b.Guid), (JoinType.InnerJoin, b.ParentId == c.Id)
var t11112 = g.mysql.Select <TestInfo>().ToList(a => new
{
a.Id,
a.Title,
a.Type,
ccc = new { a.Id, a.Title },
tp = a.Type,
tp2 = new
{
a.Id,
tp2 = a.Type.Name
},
tp3 = new
{
a.Id,
tp33 = new
{
a.Id
}
}
});
var t100 = g.mysql.Select <TestInfo>().Where("").Where(a => a.Id > 0).Skip(100).Limit(200).ToList();
var t101 = g.mysql.Select <TestInfo>().As("b").Where("").Where(a => a.Id > 0).Skip(100).Limit(200).ToList();
var t1111 = g.mysql.Select <TestInfo>().ToList(a => new { a.Id, a.Title, a.Type });
var t2222 = g.mysql.Select <TestInfo>().ToList(a => new { a.Id, a.Title, a.Type.Name });
var t3 = g.mysql.Insert <TestInfo>(new[] { new TestInfo {
}, new TestInfo {
} }).IgnoreColumns(a => a.Title).ToSql();
var t4 = g.mysql.Insert <TestInfo>(new[] { new TestInfo {
}, new TestInfo {
} }).IgnoreColumns(a => new { a.Title, a.CreateTime }).ToSql();
var t5 = g.mysql.Insert <TestInfo>(new[] { new TestInfo {
}, new TestInfo {
} }).IgnoreColumns(a => new { a.Title, a.TypeGuid, a.CreateTime }).ToSql();
var t6 = g.mysql.Insert <TestInfo>(new[] { new TestInfo {
}, new TestInfo {
} }).InsertColumns(a => new { a.Title }).ToSql();
var t7 = g.mysql.Update <TestInfo>().ToSql();
var t8 = g.mysql.Update <TestInfo>().Where(new TestInfo {
}).ToSql();
var t9 = g.mysql.Update <TestInfo>().Where(new[] { new TestInfo {
Id = 1
}, new TestInfo {
Id = 2
} }).ToSql();
var t10 = g.mysql.Update <TestInfo>().Where(new[] { new TestInfo {
Id = 1
}, new TestInfo {
Id = 2
} }).Where(a => a.Title == "111").ToSql();
var t11 = g.mysql.Update <TestInfo>().SetSource(new[] { new TestInfo {
Id = 1, Title = "111"
}, new TestInfo {
Id = 2, Title = "222"
} }).ToSql();
var t12 = g.mysql.Update <TestInfo>().SetSource(new[] { new TestInfo {
Id = 1, Title = "111"
}, new TestInfo {
Id = 2, Title = "222"
} }).Where(a => a.Title == "111").ToSql();
var t13 = g.mysql.Update <TestInfo>().Set(a => a.Title, "222111").ToSql();
var t14 = g.mysql.Update <TestInfo>().Set(a => a.Title, "222111").Where(new TestInfo {
}).ToSql();
var t15 = g.mysql.Update <TestInfo>().Set(a => a.Title, "222111").Where(new[] { new TestInfo {
Id = 1
}, new TestInfo {
Id = 2
} }).ToSql();
var t16 = g.mysql.Update <TestInfo>().Set(a => a.Title, "222111").Where(new[] { new TestInfo {
Id = 1
}, new TestInfo {
Id = 2
} }).Where(a => a.Title == "111").ToSql();
var t17 = g.mysql.Update <TestInfo>().SetSource(new[] { new TestInfo {
Id = 1, Title = "111"
}, new TestInfo {
Id = 2, Title = "222"
} }).Set(a => a.Title, "222111").ToSql();
var t18 = g.mysql.Update <TestInfo>().SetSource(new[] { new TestInfo {
Id = 1, Title = "111"
}, new TestInfo {
Id = 2, Title = "222"
} }).Set(a => a.Title, "222111").Where(a => a.Title == "111").ToSql();
var t19 = g.mysql.Update <TestInfo>().Set(a => a.TypeGuid + 222111).ToSql();
var t20 = g.mysql.Update <TestInfo>().Set(a => a.TypeGuid + 222111).Where(new TestInfo {
}).ToSql();
var t21 = g.mysql.Update <TestInfo>().Set(a => a.TypeGuid + 222111).Where(new[] { new TestInfo {
Id = 1
}, new TestInfo {
Id = 2
} }).ToSql();
var t22 = g.mysql.Update <TestInfo>().Set(a => a.TypeGuid + 222111).Where(new[] { new TestInfo {
Id = 1
}, new TestInfo {
Id = 2
} }).Where(a => a.Title == "111").ToSql();
var t23 = g.mysql.Update <TestInfo>().SetSource(new[] { new TestInfo {
Id = 1, Title = "111"
}, new TestInfo {
Id = 2, Title = "222"
} }).Set(a => a.TypeGuid + 222111).ToSql();
var t24 = g.mysql.Update <TestInfo>().SetSource(new[] { new TestInfo {
Id = 1, Title = "111"
}, new TestInfo {
Id = 2, Title = "222"
} }).Set(a => a.TypeGuid + 222111).Where(a => a.Title == "111").ToSql();
var t1000 = g.sqlite.Select <ExamPaper>().ToSql();
var t1001 = g.sqlite.Insert <ExamPaper>().AppendData(new ExamPaper()).ToSql();
}
public bool Add(NewsArticle news)
{
return(NewsArticleDao.Add(news));
}
bool PassesAllFilters(NewsArticle newsArticle, string searchTerm)
{
return(SettingsManager.FilterExtensionManager.Features.All(
f => f.Extension.AllowArticle(newsArticle, searchTerm, f.KeyValueStorage)));
}
public bool Update(NewsArticle news)
{
return(NewsArticleDao.Update(news));
}
