public string ModelListEntity(string sqlwhere) { if (string.IsNullOrEmpty(sqlwhere)) { sqlwhere += "1=1"; } else sqlwhere += " and 1=1"; ModelListBll ob = new ModelListBll(); List<ModelList> orderList = new List<ModelList>(); //转换 List<ConvertEntity> ce = new List<ConvertEntity>(); orderList = ob.GetModelList(sqlwhere); foreach (ModelList item in orderList) { ConvertEntity ceSingle = new ConvertEntity(); ceSingle.ModalName = item.ModelName; ceSingle.RemarkD = item.Remark; ceSingle.eg3 = item.ModelPrice; ceSingle.eg4 = item.StationPrice; ceSingle.Unit = item.Unit; ceSingle.ModelProfit = item.ModelProfit; ceSingle.StationProfit = item.StationProfit; ce.Add(ceSingle); } int rows = ob.GetRecordCount(sqlwhere); string output = JsonConvert.SerializeObject(ce); string json = @"{""Rows"":" + output + @",""Total"":""" + rows + @"""}"; return json; }
public string ModelListList(string sqlwhere) { if (string.IsNullOrEmpty(sqlwhere)) { sqlwhere += "1=1"; } else sqlwhere += " and 1=1"; ModelListBll ob = new ModelListBll(); List<ModelList> orderList = new List<ModelList>(); orderList = ob.GetModelList(sqlwhere); int rows = ob.GetRecordCount(sqlwhere); string output = JsonConvert.SerializeObject(orderList); string json = @"{""Rows"":" + output + @",""Total"":""" + rows + @"""}"; return json; }