public OSRStorageResponses GetOSRReceivingDetailed(OSRStorageCondition request)
{
OSRStorageResponses response = new OSRStorageResponses();
try
{
response = new DaoOSRStorage().GetOSRReceivingDetailed(request);
}
catch (Exception ex)
{
LogError(ex);
}
return(response);
}
public OSRStorageResponses GetOSRReceivingDetailed(OSRStorageCondition WhereStorage)
{
DataSet ds = new DataSet();
OSRStorageResponses or = new OSRStorageResponses();
using (SqlConnection conn = new SqlConnection(connStr))
{
try
{
SqlCommand cmd = new SqlCommand();
if (WhereStorage.Identification == "Export")
{
cmd.CommandText = "pro_wms_OSRReceivingExport";
}
else
{
cmd.CommandText = "pro_wms_OSRReceivingDetailed";
}
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PE", WhereStorage.PE);
cmd.Parameters[0].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[0].Size = 100;
cmd.Parameters.AddWithValue("@Category", WhereStorage.Category);
cmd.Parameters[1].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[1].Size = 100;
cmd.Parameters.AddWithValue("@TransOrderNO", WhereStorage.TransOrderNO);
cmd.Parameters[2].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[2].Size = 2000;
cmd.Parameters.AddWithValue("@Status", WhereStorage.Status);
cmd.Parameters[3].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[3].Size = 100;
cmd.Parameters.AddWithValue("@BeginTime", WhereStorage.BeginTime);
cmd.Parameters[4].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[4].Size = 50;
cmd.Parameters.AddWithValue("@EndTime", WhereStorage.EndTime);
cmd.Parameters[5].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[5].Size = 50;
cmd.Parameters.AddWithValue("@ShiptoCode", WhereStorage.ShiptoCode);
cmd.Parameters[6].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[6].Size = 10;
cmd.Parameters.AddWithValue("@Type", WhereStorage.Type);
cmd.Parameters[7].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[7].Size = 10;
cmd.Parameters.AddWithValue("@ReceiptNumber", WhereStorage.ReceiptNumber);
cmd.Parameters[8].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[8].Size = 100;
cmd.CommandTimeout = 180;
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ds);
if (WhereStorage.Identification == "Export")
{
or.Export = ds.Tables[0].ConvertToEntityCollection <OSRStorageSelect>();
}
else
{
or.Header = ds.Tables[0].ConvertToEntityCollection <OSRStorageHeader>();
or.Detailed = ds.Tables[1].ConvertToEntityCollection <OSRStorageDetailed>();
conn.Close();
}
}
catch (Exception)
{
throw;
}
}
return(or);
}
public OSRStorageResponses GetOSRStorage(OSRStorageCondition WhereStorage)
{
DataSet ds = new DataSet();
OSRStorageResponses or = new OSRStorageResponses();
using (SqlConnection conn = new SqlConnection(connStr))
{
try
{
SqlCommand cmd = new SqlCommand("pro_wms_OSRStorageSelect", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PE", WhereStorage.PE);
cmd.Parameters[0].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[0].Size = 100;
cmd.Parameters.AddWithValue("@Category", WhereStorage.Category);
cmd.Parameters[1].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[1].Size = 100;
cmd.Parameters.AddWithValue("@TransOrderNO", WhereStorage.TransOrderNO);
cmd.Parameters[2].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[2].Size = 2000;
cmd.Parameters.AddWithValue("@Status", WhereStorage.Status);
cmd.Parameters[3].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[3].Size = 100;
cmd.Parameters.AddWithValue("@BeginTime", WhereStorage.BeginTime);
cmd.Parameters[4].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[4].Size = 50;
cmd.Parameters.AddWithValue("@EndTime", WhereStorage.EndTime);
cmd.Parameters[5].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[5].Size = 50;
cmd.Parameters.AddWithValue("@ShiptoCode", WhereStorage.ShiptoCode);
cmd.Parameters[6].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[6].Size = 10;
cmd.Parameters.AddWithValue("@Type", WhereStorage.Type);
cmd.Parameters[7].SqlDbType = SqlDbType.VarChar;
cmd.Parameters[7].Size = 10;
cmd.Parameters.AddWithValue("@PageIndex", WhereStorage.PageIndex);
cmd.Parameters[8].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@PageSize", WhereStorage.PageSize);
cmd.Parameters[9].SqlDbType = SqlDbType.Int;
cmd.Parameters.AddWithValue("@RowCount", 0);
cmd.Parameters[10].Direction = ParameterDirection.Output;
cmd.Parameters[10].SqlDbType = SqlDbType.Int;
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
sda.Fill(ds);
or.RowCount = (int)cmd.Parameters[10].Value;
or.Header = ds.Tables[0].ConvertToEntityCollection <OSRStorageHeader>();
conn.Close();
}
catch (Exception)
{
throw;
}
}
return(or);
}
