MySQL Efficient distributed SQL

1          Public stringGetquerysql (Itspareaquerymodel model,ObjectState =NULL)2         {3             varSqlbuilder =NewStringBuilder (850);4Sqlbuilder.appendformat (@"{0}5 / *---Script for Select Top N Rows---* /6 SELECT sql_calc_found_rows7 a.ID,8 A.areaname,9 A.location,Ten A.areahead, One A.remark, A A.rowstate, - A.createon, - A.createby, the A.updateon, - A.updateby - From Itsparea as a", _sqlcomment); -             if(model. RowState = =NULL) +             { -Sqlbuilder.appendformat ("{0}where a.rowstate in (0,1)", Environment.NewLine); +             } A             Else at             { -Sqlbuilder.appendformat ("{0}where A.rowstate={1}", Environment.NewLine, model. RowState); -             } -             if(!string. IsNullOrEmpty (model. AreaName)) -             { -Sqlbuilder.appendformat ("{0}and [email protected]", Environment.NewLine); in             } -             if(!string. IsNullOrEmpty (model. Areahead)) to             { +Sqlbuilder.appendformat ("{0}and [email protected]", Environment.NewLine); -             } theSqlbuilder.appendformat ("{0}order by a.createon desc", Environment.NewLine); *Sqlbuilder.appendformat ("{0}limit {1},{2};", Environment.NewLine, (model. PageIndex-1) *model. PageSize, model. PageSize); $Sqlbuilder.appendformat ("{0}select found_rows ()", Environment.NewLine);Panax Notoginseng             returnsqlbuilder.tostring (); -}

MySQL Efficient distributed SQL