public ShelvesPanelResponse ShelvesPanel_Receipt(string id, string WorkStationId)
{
ShelvesPanelResponse response = new ShelvesPanelResponse();
//long IDs = ID;
DbParam[] dbParams = new DbParam[] {
new DbParam("@Id", DbType.String, id, ParameterDirection.Input),
new DbParam("@WorkStationId", DbType.String, WorkStationId, ParameterDirection.Input)
};
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetShelvesPanel_Receipt", dbParams);
response.shelvesPanel = ds.Tables[0].ConvertToEntityCollection <ShelvesPanel>();
response.instructions = ds.Tables[1].ConvertToEntityCollection <Instructions>();
return(response);
}
public ShelvesPanelResponse GetPickUpGoodsWall(long WorkStationId)
{
ShelvesPanelResponse response = new ShelvesPanelResponse();
//long IDs = ReleatedDetailID; @
DbParam[] dbParams = new DbParam[] {
new DbParam("@WorkStationId", DbType.Int64, WorkStationId, ParameterDirection.Input),
new DbParam("@message", DbType.String, "", ParameterDirection.Input)
};
string s = (string)dbParams[1].Value;
DataSet ds = this.ExecuteDataSet("Proc_WMS_GetPickUpGoodsWall", dbParams);
response.pickUpGoodsWall = ds.Tables[0].ConvertToEntityCollection <PickUpGoodsWall>();
//response.mapping = ds.Tables[1].ConvertToEntityCollection<Instruction_Order_Mapping>();
return(response);
}
public ShelvesPanelResponse SubmitData_Receipt(long ID, decimal ActualQty)
{
ShelvesPanelResponse response = new ShelvesPanelResponse();
//long IDs = ReleatedDetailID; @
DbParam[] dbParams = new DbParam[] {
new DbParam("@ID", DbType.Int64, ID, ParameterDirection.Input),
new DbParam("@ActualQty", DbType.Decimal, ActualQty, ParameterDirection.Input),
new DbParam("@message", DbType.String, "", ParameterDirection.Input)
};
string s = (string)dbParams[2].Value;
DataTable dt = this.ExecuteDataTable("Proc_WMS_InstructionsAddActualQty_Receipt", dbParams);
response.instructions = dt.ConvertToEntityCollection <Instructions>();
return(response);
}
