/// <summary>
/// 导出库存变更数据
/// </summary>
/// <param name="SearchCondition"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public GetAdjustmentDetailByConditionResponse ExportadjustByCondition(AdjustmentSearchCondition SearchCondition)
{
GetAdjustmentDetailByConditionResponse response = new GetAdjustmentDetailByConditionResponse();
string sqlWhere = this.GenGetAdjustWhere(SearchCondition);
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input),
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_ExportAdjustmentByCondition", dbParams);
response.AdjustmentCollection = ds.Tables[0].ConvertToEntityCollection <Adjustment>();
response.AdjustmentDetailCollection = ds.Tables[1].ConvertToEntityCollection <AdjustmentDetail>();
return(response);
}
/// <summary>
/// 库存变更数据查询
/// </summary>
/// <param name="SearchCondition"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public GetAdjustmentDetailByConditionResponse GetadjustByCondition(AdjustmentSearchCondition SearchCondition, int pageIndex, int pageSize, out int rowCount)
{
GetAdjustmentDetailByConditionResponse response = new GetAdjustmentDetailByConditionResponse();
string sqlWhere = this.GenGetAdjustWhere(SearchCondition);
int tempRowCount = 0;
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input),
new DbParam("@PageIndex", DbType.Int32, pageIndex, ParameterDirection.Input),
new DbParam("@PageSize", DbType.Int32, pageSize, ParameterDirection.Input),
new DbParam("@RowCount", DbType.Int32, tempRowCount, ParameterDirection.Output)
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetAdjustmentByCondition", dbParams);
rowCount = (int)dbParams[3].Value;
response.AdjustmentCollection = ds.Tables[0].ConvertToEntityCollection <Adjustment>();
//response.AdjustmentDetailCollection = ds.Tables[1].ConvertToEntityCollection<AdjustmentDetail>();
return(response);
}
