/// <summary>
/// 验证交接单里面的明细是否有前面称重的时候没拦住的取消单
/// </summary>
/// <param name="deliverID"></param>
/// <returns></returns>
public IEnumerable <OrderInfo> ValidDeliverOrderCancel(long deliverID)
{
GetDeliverByConditionResponse response = new GetDeliverByConditionResponse();
DbParam[] dbParams = new DbParam[] {
new DbParam("@DeliverID", DbType.Int64, deliverID, ParameterDirection.Input)//交接单主表ID
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_ValidDeliverOrderCancel", dbParams);
return(ds.Tables[0].ConvertToEntityCollection <OrderInfo>());
}
/// <summary>
/// 打印交接清单
/// </summary>
/// <param name="deliverID"></param>
/// <param name="Proc">存储过程可配置</param>
/// <returns></returns>
public GetDeliverByConditionResponse GetPrintDelivery(long deliverID, string Proc)
{
GetDeliverByConditionResponse response = new GetDeliverByConditionResponse();
DbParam[] dbParams = new DbParam[] {
new DbParam("@DeliverID", DbType.String, deliverID, ParameterDirection.Input)//交接单主表ID
};
DataSet ds = this.ExecuteDataSet(Proc, dbParams);
response.DeliverHeaderConnection = ds.Tables[0].ConvertToEntityCollection <DeliverHeader>();
response.DeliverDetailConnection = ds.Tables[1].ConvertToEntityCollection <DeliverDetail>();
return(response);
}
/// <summary>
/// ID查询交接单明细
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public GetDeliverByConditionResponse GetDeliverHeaderAndDetailByID(int ID)
{
GetDeliverByConditionResponse response = new GetDeliverByConditionResponse();
DbParam[] dbParams = new DbParam[] {
new DbParam("@ID", DbType.Int32, ID, ParameterDirection.Input)
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetDeliverHeaderAndDetailByID", dbParams);
response.DeliverHeaderConnection = ds.Tables[0].ConvertToEntityCollection <DeliverHeader>();
//response.DeliverDetailConnection = ds.Tables[1].ConvertToEntityCollection<DeliverDetail>();
response.DeliverExpressNoConnection = ds.Tables[1].ConvertToEntityCollection <DeliverDetail>();
return(response);
}
/// <summary>
/// ID查询交接单明细
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public GetDeliverByConditionResponse GetDeliverUploadData(string express, long customerID, string warehouse)
{
GetDeliverByConditionResponse response = new GetDeliverByConditionResponse();
DbParam[] dbParams = new DbParam[] {
new DbParam("@Expresskey", DbType.String, express, ParameterDirection.Input),
new DbParam("@CustomerID", DbType.String, customerID, ParameterDirection.Input),
new DbParam("@Warehouse", DbType.String, warehouse, ParameterDirection.Input)
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetDeliverUploadData", dbParams);
response.DeliverDetailConnection = ds.Tables[0].ConvertToEntityCollection <DeliverDetail>();
return(response);
}
/// <summary>
/// 交接单主表查询
/// </summary>
/// <param name="SearchCondition"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public GetDeliverByConditionResponse GetDeliverHeaderByCondition(DeliverHeaderSearchCondition SearchCondition, int pageIndex, int pageSize, out int rowCount)
{
GetDeliverByConditionResponse response = new GetDeliverByConditionResponse();
string sqlWhere = this.GenGetDeliverHeaderWhere(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_GetDeliverHeaderByCondition", dbParams);
rowCount = (int)dbParams[3].Value;
response.DeliverHeaderConnection = ds.Tables[0].ConvertToEntityCollection <DeliverHeader>();
return(response);
}
