/// <summary>
/// 获取数据分页列表，并返回所有记录数
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalRecords"></param>
/// <param name="sqlWhere"></param>
/// <param name="cmdParms"></param>
/// <returns></returns>
public string GetResidentialBuildingList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
ResidentialBuilding bll = new ResidentialBuilding();
List <ResidentialBuildingInfo> list = bll.GetList(pageIndex, pageSize, out totalRecords, sqlWhere, cmdParms);
if (list == null || list.Count == 0)
{
return("[]");
}
return(JsonConvert.SerializeObject(list));
}
/// <summary>
/// 获取满足当前条件的数据列表
/// </summary>
/// <param name="sqlWhere"></param>
/// <param name="cmdParms"></param>
/// <returns></returns>
public string GetResidentialBuildingList(string sqlWhere, params SqlParameter[] cmdParms)
{
ResidentialBuilding bll = new ResidentialBuilding();
List <ResidentialBuildingInfo> list = bll.GetList(sqlWhere, cmdParms);
if (list == null || list.Count == 0)
{
return("[]");
}
return(JsonConvert.SerializeObject(list));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <returns></returns>
public string GetResidentialBuildingList()
{
ResidentialBuilding bll = new ResidentialBuilding();
List <ResidentialBuildingInfo> list = bll.GetList();
if (list == null || list.Count == 0)
{
return("[]");
}
return(JsonConvert.SerializeObject(list));
}
private void GetJsonForDatagrid(HttpContext context)
{
int totalRecords = 0;
int pageIndex = 1;
int pageSize = 10;
int.TryParse(context.Request.QueryString["page"], out pageIndex);
int.TryParse(context.Request.QueryString["rows"], out pageSize);
string sqlWhere = string.Empty;
ParamsHelper parms = null;
if (!string.IsNullOrEmpty(context.Request.QueryString["buildingCode"]))
{
sqlWhere = "and BuildingCode like @BuildingCode ";
SqlParameter parm = new SqlParameter("@BuildingCode", SqlDbType.VarChar, 50);
parm.Value = "%" + context.Request.QueryString["buildingCode"].Trim() + "%";
if (parms == null)
{
parms = new ParamsHelper();
}
parms.Add(parm);
}
if (!string.IsNullOrEmpty(context.Request.QueryString["communityId"]))
{
Guid communityId = Guid.Parse(context.Request.QueryString["communityId"]);
sqlWhere = "and ResidenceCommunityId = @ResidenceCommunityId ";
SqlParameter parm = new SqlParameter("@ResidenceCommunityId", SqlDbType.UniqueIdentifier);
parm.Value = communityId;
if (parms == null)
{
parms = new ParamsHelper();
}
parms.Add(parm);
}
ResidentialBuilding bll = new ResidentialBuilding();
var list = bll.GetList(pageIndex, pageSize, out totalRecords, sqlWhere, parms != null ? parms.ToArray() : null);
if (list == null || list.Count == 0)
{
context.Response.Write("{\"total\":0,\"rows\":[]}");
return;
}
StringBuilder sb = new StringBuilder();
foreach (var model in list)
{
sb.Append("{\"Id\":\"" + model.Id + "\",\"BuildingCode\":\"" + model.BuildingCode + "\"},");
}
context.Response.Write("{\"total\":" + totalRecords + ",\"rows\":[" + sb.ToString().Trim(',') + "]}");
}
