public OSRStockResponses GetOSRStock(OSRStockCondition request) { OSRStockResponses response = new OSRStockResponses(); try { response = new DaoOSRStorage().GetOSRStock(request); } catch (Exception ex) { LogError(ex); } return(response); }
public OSRStockResponses GetOSRStock(OSRStockCondition WhereStock) { OSRStockResponses or = new OSRStockResponses(); using (SqlConnection conn = new SqlConnection(connStr)) { try { SqlCommand cmd = new SqlCommand("pro_wms_OSRStockSelect", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SKU", WhereStock.SKU); cmd.Parameters[0].SqlDbType = SqlDbType.VarChar; cmd.Parameters[0].Size = 4000; cmd.Parameters.AddWithValue("@Season", WhereStock.Season); cmd.Parameters[1].SqlDbType = SqlDbType.VarChar; cmd.Parameters[1].Size = 2000; cmd.Parameters.AddWithValue("@Category", WhereStock.Category); cmd.Parameters[2].SqlDbType = SqlDbType.VarChar; cmd.Parameters[2].Size = 2000; cmd.Parameters.AddWithValue("@Article", WhereStock.Article); cmd.Parameters[3].SqlDbType = SqlDbType.VarChar; cmd.Parameters[3].Size = 2000; cmd.Parameters.AddWithValue("@UPC", WhereStock.UPC); cmd.Parameters[4].SqlDbType = SqlDbType.VarChar; cmd.Parameters[4].Size = 2000; cmd.Parameters.AddWithValue("@PE", WhereStock.PE); cmd.Parameters[5].SqlDbType = SqlDbType.VarChar; cmd.Parameters[5].Size = 100; cmd.Parameters.AddWithValue("@PageIndex", WhereStock.PageIndex); cmd.Parameters[6].SqlDbType = SqlDbType.Int; cmd.Parameters.AddWithValue("@PageSize", WhereStock.PageSize); cmd.Parameters[7].SqlDbType = SqlDbType.Int; cmd.Parameters.AddWithValue("@RowCount", 0); cmd.Parameters[8].Direction = ParameterDirection.Output; cmd.Parameters[8].SqlDbType = SqlDbType.Int; cmd.Parameters.AddWithValue("@Total", 0); cmd.Parameters[9].Direction = ParameterDirection.Output; cmd.Parameters[9].SqlDbType = SqlDbType.Int; conn.Open(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; sda.Fill(dt); or.RowCount = (int)cmd.Parameters[8].Value; or.Total = (int)cmd.Parameters[9].Value; or.OSRsk = dt.ConvertToEntityCollection <OSRStockSelect>(); conn.Close(); } catch (Exception) { throw; } } return(or); }