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