/// <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));
}
