public IList <Vdepotinformation> DescendOrderPaginationFindAll(VdepotinformationPagination obj)
{
String stmtId = "Vdepotinformation.DescendOrderFindAllPagination";
IList <Vdepotinformation> result = this.sqlMapper.QueryForList <Vdepotinformation>(stmtId, obj);
return(result);
}
public IList <Vdepotinformation> PaginationFindByUsername(VdepotinformationPagination obj)
{
String stmtId = "VdepotinformationPagination.FindByUsername";
IList <Vdepotinformation> result = this.sqlMapper.QueryForList <Vdepotinformation>(stmtId, obj);
return(result);
}
public int DynamicCount(VdepotinformationPagination obj)
{
String stmtId = "Vdepotinformation.DynamicCount";
int result = this.sqlMapper.QueryForObject <int>(stmtId, obj);
return(result);
}
public IList <Vdepotinformation> DynamicQuery(VdepotinformationPagination obj)
{
String stmtId = "Vdepotinformation.DynamicQuery";
IList <Vdepotinformation> result = this.sqlMapper.QueryForList <Vdepotinformation>(stmtId, obj);
return(result);
}
public string generateDepotInfoHtml(string pageNumber, string pageSize, string bitParams)
{
pageNumber = int.Parse(pageNumber) < 0 ? "0" : pageNumber;
VdepotinformationPagination pageNationPoco = new VdepotinformationPagination();
pageNationPoco.Limit = int.Parse(pageSize);
pageNationPoco.Offset = (int.Parse(pageNumber) - 1) * pageNationPoco.Limit;
logger.Info("Got offset:" + pageNationPoco.Offset.ToString());
DepotParamPojo pojo = this.paramBitMapParser(bitParams);
pageNationPoco.Area = int.Parse(pojo.Area);
Hashtable areaMap = this.areaMap(pojo.Area);
pageNationPoco.AreaLow = int.Parse(areaMap["low"].ToString());
pageNationPoco.AreaHigh = int.Parse(areaMap["high"].ToString());
pageNationPoco.Citycode = pojo.CityId;
pageNationPoco.Depottypeid = long.Parse(pojo.TypeId);
pageNationPoco.Scopeid = long.Parse(pojo.ScopeId);
IList <Vdepotinformation> trunksInfoList = this.vDepotInfoDao.DynamicQuery(pageNationPoco);
logger.Info("Got items:" + trunksInfoList.Count.ToString());
string tableHtml = this.getTableHtml(this.getTableBodyHtml(trunksInfoList));
logger.Info("table html:" + tableHtml);
return(tableHtml);
}
public void ProcessRequest(HttpContext context)
{
if (context.Request.RequestType == "POST")
{// POST
StreamReader streamReader = new StreamReader(context.Request.InputStream);
string parameters = streamReader.ReadToEnd();
logger.Info("Got post parameters:" + parameters);
VdepotinformationPagination poco = new VdepotinformationPagination();
Hashtable data = (Hashtable)JsonConvert.DeserializeObject <Hashtable>(parameters);
if (data == null || data.Count < 1)
{
data = new Hashtable();
int count = this.vDepotInfoDao.GetCount();
data.Add("item_count", count.ToString());
logger.Info("got item count:" + count.ToString());
data.Add("params", "0-0-0-0");
}
else
{
string bitMap = this.hashtable2BitMap(data);
poco.Citycode = data["cityId"] == null ? null : data["cityId"].ToString();
poco.Depottypeid = data["typeId"] == null ? 0 : long.Parse(data["typeId"].ToString());
poco.Scopeid = data["scopeId"] == null ? 0 : long.Parse(data["scopeId"].ToString());
string area = data["area"] == null ? "0" : data["area"].ToString();
Hashtable areaMap = this.areaMap(area);
poco.AreaLow = int.Parse(areaMap["low"].ToString());
poco.AreaHigh = int.Parse(areaMap["high"].ToString());
poco.Area = int.Parse(area);
int count = this.vDepotInfoDao.DynamicCount(poco);
logger.Info("Got items count:" + count.ToString());
data = new Hashtable();
data.Add("item_count", count.ToString());
data.Add("params", bitMap);
logger.Info("Post back bitMap:" + bitMap);
}
context.Response.ContentType = "text/plain";
context.Response.Write(JsonConvert.SerializeObject(data));
}
else
{// GET
string pageNumber = context.Request.QueryString["pageNumber"].ToString();
logger.Info("Got page number:" + pageNumber);
string pageSize = context.Request.QueryString["pageSize"].ToString();
logger.Info("Got page size:" + pageSize);
string bitParams = context.Request.QueryString["bitparams"].ToString();//null
logger.Info("Got bitmap params:" + bitParams);
string tableHtml = this.generateDepotInfoHtml(pageNumber, pageSize, bitParams);
context.Response.ContentType = "text/plain";
context.Response.Write(tableHtml);
}
}
