/// <summary>
/// 核增查询
/// </summary>
/// <param name="resultMsg"></param>
/// <param name="recordCount"></param>
/// <param name="TotalPages"></param>
/// <param name="criteria"></param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public DataTable QueryV_HZListPager(out string resultMsg, out int recordCount, out int TotalPages, CriteriaNuclearGrowth criteria, int pageSize = 10, int pageIndex = 1)
{
var data = this.logicVHz.QueryV_HZListPager(out resultMsg, out recordCount, out TotalPages, criteria, pageSize, pageIndex);
return(data);
}
/// <summary>
/// 核增分页查询
/// </summary>
/// <param name="resultMsg"></param>
/// <param name="recordCount"></param>
/// <param name="criteria"></param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public DataTable QueryV_HZListPager(out string resultMsg, out int recordCount, out int TotalPages, CriteriaNuclearGrowth criteria, int pageSize = 10, int pageIndex = 1)
{
recordCount = 0;
TotalPages = 0;
resultMsg = string.Empty;
DataSet data = new DataSet();
DataTable dt = new DataTable();
try
{
//存储过程名称
string sql = "usp_v_hz_select_pager";
//参数添加
IList <DBParameter> parm = new List <DBParameter>();
parm.Add(new DBParameter()
{
ParameterName = "CargoTypeTest", ParameterValue = criteria.CargoTypeTest, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "CustomerName", ParameterValue = criteria.CustomerName, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "OrderNumber", ParameterValue = criteria.OrderNumber, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "WarehousingApproach", ParameterValue = criteria.WarehousingApproach, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "Remark", ParameterValue = criteria.Remark, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "NoDeclaration", ParameterValue = criteria.NoDeclaration, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "ApprovalStatus", ParameterValue = criteria.ApprovalStatus, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "WarehousingStartTime", ParameterValue = criteria.WarehousingStartTime, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "WarehousingEndTime", ParameterValue = criteria.WarehousingEndTime, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "CustomsCode", ParameterValue = criteria.CustomsCode, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "LockStatus", ParameterValue = criteria.LockStatus, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32
});
parm.Add(new DBParameter()
{
ParameterName = "Trade", ParameterValue = criteria.Trade, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "CustomerOrderNumber", ParameterValue = criteria.CustomerOrderNumber, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "NuclearGrowthNumber", ParameterValue = criteria.NuclearGrowthNumber, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.String
});
parm.Add(new DBParameter()
{
ParameterName = "PagerIndex", ParameterValue = pageIndex, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32
});
parm.Add(new DBParameter()
{
ParameterName = "PagerSize", ParameterValue = pageSize, ParameterInOut = BaseDict.ParmIn, ParameterType = DbType.Int32
});
parm.Add(new DBParameter()
{
ParameterName = "RowCount", ParameterInOut = BaseDict.ParmOut, ParameterType = DbType.Int32
});
parm.Add(new DBParameter()
{
ParameterName = "TotalPages", ParameterInOut = BaseDict.ParmOut, ParameterType = DbType.Int32
});
//查询执行
using (data = DBHelper.ExecuteDataSet(sql, isStoredProc: true, parm: parm))
{
foreach (var item in parm)
{
//获取输出参数值
if (item.ParameterName == "RowCount")
{
int.TryParse(item.ParameterValue.ToString(), out recordCount);
}
if (item.ParameterName == "TotalPages")
{
int.TryParse(item.ParameterValue.ToString(), out TotalPages);
}
}
}
if (data != null && data.Tables.Count > 0)
{
dt = data.Tables[0];
}
}
catch (Exception ex)
{
resultMsg = string.Format("{0} {1}", BaseDict.ErrorPrefix, ex.ToString());
}
return(dt);
}
