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