/// <summary> /// 分页获取数据列表 /// </summary> public DataTable GetListByPage(SpxxReq model, string orderby, int rows, int page) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM ( "); strSql.Append(" SELECT ROW_NUMBER() OVER ("); if (!string.IsNullOrEmpty(orderby.Trim())) { strSql.Append("order by T." + orderby); } else { strSql.Append("order by T.spId desc"); } strSql.Append(")AS RowId, T.* from tbl_Spxx T "); //if (!string.IsNullOrEmpty(strWhere.Trim())) //{ // strSql.Append(" WHERE " + strWhere); //} strSql.Append(" ) TT"); strSql.AppendFormat(" WHERE TT.RowId between {0} and {1}", rows * (page - 1), rows); //strSql.AppendFormat("select * from tbl_spxx limit {0},{1}", rows * (page - 1), rows); return(DbHelperSQL.Query(strSql.ToString()).Tables[0]); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获得商品信息数据列表 /// </summary> public DataTable GetList(SpxxReq model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("select"); strSql.Append(" spId,"); strSql.Append(" spName,"); strSql.Append(" spHPH,"); strSql.Append(" spCPRQ,"); strSql.Append(" spHPDQR,"); strSql.Append(" spCPRQC,"); strSql.Append(" IsKZR,"); strSql.Append(" spPJZT,"); strSql.Append(" spSPRQC,"); strSql.Append(" spCPRCN,"); strSql.Append(" spCDRCN,"); strSql.Append(" IsBLJ,"); strSql.Append(" spPMFS,"); strSql.Append(" spQPJ,"); strSql.Append(" spJJFD,"); strSql.Append(" spPMKSSJ,"); strSql.Append(" spPMJSSJ,"); strSql.Append(" spMS,"); strSql.Append(" spFKFS,"); strSql.Append(" spUrl,"); strSql.Append(" spBZJYQ,"); strSql.Append(" spPJGY from tbl_Spxx "); return(DbHelperSQL.Query(strSql.ToString()).Tables[0]); } catch (Exception ex) { throw ex; } }
public DataTable GetListByPage(SpxxReq model, string orderby, int rows, int page) { try { return(spxxServices.GetListByPage(model, orderby, rows, page)); } catch (Exception ex) { throw ex; } }
public int GetRecordCount(SpxxReq model) { try { return(spxxServices.GetRecordCount(model)); } catch (Exception ex) { throw ex; } }
public DataTable GetList(SpxxReq model) { try { return(spxxServices.GetList(model)); } catch (Exception ex) { throw ex; } }
public string QuerySpxxList([FromBody] SpxxReq req) { Result <DataTable> result = new Result <DataTable>(); try { result.status = 1; result.data = spxxManage.GetList(req); } catch (Exception ex) { result.status = 0; result.msg = "信息异常!查询商品信息:" + ex.Message; LogHelper.WriteLog(this.GetType(), "查询部门信息列表出错了!错误信息:" + ex.Message, LogHelper.logLevel.ERROR); } return(JsonHelper.ConvertToJosnString(result)); }
/// <summary> /// 获取记录总数 /// </summary> public int GetRecordCount(SpxxReq model) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM tbl_Spxx "); //if (strWhere.Trim() != "") //{ // strSql.Append(" where " + strWhere); //} object obj = DbHelperSQL.GetSingle(strSql.ToString()); return(obj == null ? 0 : Convert.ToInt32(obj)); } catch (Exception ex) { throw ex; } }
public string QuerySpxxListByPage([FromBody] SpxxReq req) { Result <ResultData <SpxxRes> > result = new Result <ResultData <SpxxRes> >(); try { DataTable dt = spxxManage.GetListByPage(req, string.Empty, req.rows, req.page); ResultData <SpxxRes> data = new ResultData <SpxxRes>(); data.total = spxxManage.GetRecordCount(req); data.rows = ModelEx.SetListValueFromDB <SpxxRes>(new List <SpxxRes>(), dt); result.status = 1; result.data = data; } catch (Exception ex) { result.status = 0; result.msg = "信息异常!查询商品信息:" + ex.Message; LogHelper.WriteLog(this.GetType(), "查询部门信息列表出错了!错误信息:" + ex.Message, LogHelper.logLevel.ERROR); } return(JsonHelper.ConvertToJosnString(result)); }