//get value in findJson
public static string GetFindValue(DtDto dt, string fid)
{
if (_Str.IsEmpty(dt.findJson))
{
return("");
}
var findJson = _Str.ToJson(dt.findJson);
return((findJson[fid] == null)
? ""
: findJson[fid].ToString());
}
public ContentResult GetPage(DtDto dt)
{
return(Content(new RoleRead().GetPage(dt).ToString(), _Web.AppJson));
}
public ContentResult GetPage(DtDto dt)
{
return(Content(new ColumnRead().GetPage(dt).ToString(), _Web.AppJson, Encoding.UTF8));
}
//傳回一頁資料列
public JObject GetPage(DtDto dt)
{
//呼叫公用類別 CrudRead
return(new CrudRead().GetPage(model, dt));
}
public JObject GetPage(DtDto dt)
{
return(new CrudRead().GetPage(dto, dt));
}
public async Task <ContentResult> GetPage(DtDto dt)
{
return(JsonToCnt(await new TableRead().GetPageAsync(Ctrl, dt)));
}
/// <summary>
/// get page rows for dataTables(json)
/// </summary>
/// <param name="crud"></param>
/// <param name="dt"></param>
/// <param name="findJson">if not null, will query by this and not from dtIn.findJson</param>
/// <returns>jquery dataTables object</returns>
public JObject GetPage(ReadDto crud, DtDto dt, JObject findJson = null)
{
//adjust
if (dt.length < 10)
{
dt.length = 10;
}
//set instance variables from input args
_dtIn = dt;
if (findJson == null)
{
findJson = string.IsNullOrEmpty(dt.findJson) ? null : _Json.StrToJson(dt.findJson);
}
//convert sql to model
var sqlDto = _Sql.SqlToDto(crud.ReadSql, crud.UseSquare);
if (sqlDto == null)
{
return(null);
}
//prepare sql where & set sql args by user input condition
//var sqlModel = sqlModel0.Value;
var where = GetWhere(crud, findJson, _dtIn.search.value);
if (where != "")
{
sqlDto.Where = (sqlDto.Where == "")
? "Where " + where : sqlDto.Where + " And " + where;
}
#region get rows count if need
JArray rows = null;
var db = GetDb();
var rowCount = dt.recordsFiltered;
var sql = "";
var group = (sqlDto.Group == "") ? "" : " " + sqlDto.Group; //remove last space
if (rowCount < 0)
{
sql = "Select Count(*) as _count " +
sqlDto.From + " " +
sqlDto.Where +
group;
var row = db.GetJson("\n" + sql, _sqlArgs); //for log 斷行
if (row == null)
{
rowCount = 0;
goto lab_exit;
}
//case of ok
rowCount = Convert.ToInt32(row["_count"]);
}
#endregion
//sorting
var orderColumn = (dt.order == null || dt.order.Count == 0)
? -1 : dt.order[0].column;
if (orderColumn >= 0)
{
sqlDto.Order = "Order By " +
sqlDto.Columns[orderColumn].Trim() +
(dt.order[0].dir == OrderTypeEnum.Asc ? "" : " Desc");
}
//set dbModel, consider crud.ColList
sql = sqlDto.Select + " " +
sqlDto.From + " " +
sqlDto.Where + group;
//get data
sql = string.Format(_Fun.ReadPageSql, sql, sqlDto.Order, dt.start, dt.length).Replace(" ", " "); //2012
rows = db.GetJsons(sql, _sqlArgs);
lab_exit:
var result = JObject.FromObject(new
{
dt.draw,
data = rows,
recordsTotal = 0,
recordsFiltered = rowCount,
});
//close db & return
db.Dispose();
return(result);
}
public async Task <ContentResult> GetPage(DtDto dt)
{
return(JsonToCnt(await new ColumnRead().GetPageAsync(dt)));
}
