MySql高效分布SQL
时间：2021-07-01 10:21:17
帮助过：2人阅读
public string GetQuerySql(ITSPAreaQueryModel model,
object state =
null)
2 {
3 var sqlBuilder =
new StringBuilder(
850);
4 sqlBuilder.AppendFormat(
@"{0}
5 /*---Script For Select Top N Rows---*/
6 SELECT SQL_CALC_FOUND_ROWS
7 a.Id,
8 a.AreaName ,
9 a.Location ,
10 a.AreaHead ,
11 a.Remark ,
12 a.RowState,
13 a.CreateOn,
14 a.CreateBy,
15 a.UpdateOn,
16 a.UpdateBy
17 FROM ITSPArea as a", _SqlComment);
18 if (model.RowState ==
null)
19 {
20 sqlBuilder.AppendFormat(
"{0}WHERE a.RowState IN ( 0,1 )", Environment.NewLine);
21 }
22 else
23 {
24 sqlBuilder.AppendFormat(
"{0}WHERE a.RowState={1}", Environment.NewLine, model.RowState);
25 }
26 if (!
string.IsNullOrEmpty(model.AreaName))
27 {
28 sqlBuilder.AppendFormat(
"{0}and a.AreaName=@AreaName", Environment.NewLine);
29 }
30 if (!
string.IsNullOrEmpty(model.AreaHead))
31 {
32 sqlBuilder.AppendFormat(
"{0}and a.AreaHead=@AreaHead", Environment.NewLine);
33 }
34 sqlBuilder.AppendFormat(
"{0}order by a.CreateOn desc", Environment.NewLine);
35 sqlBuilder.AppendFormat(
"{0}LIMIT {1},{2};", Environment.NewLine, (model.PageIndex -
1) *
model.PageSize, model.PageSize);
36 sqlBuilder.AppendFormat(
"{0}SELECT FOUND_ROWS()", Environment.NewLine);
37 return sqlBuilder.ToString();
38 }
MySql高效分布SQL
标签：
