public SampleStockResponses GetSampleStock(SampleStockCondition request) { SampleStockResponses response = new SampleStockResponses(); try { response = new DaoSampleStorage().GetSampleStock(request); } catch (Exception ex) { LogError(ex); } return(response); }
public SampleStockResponses GetSampleStock(SampleStockCondition WhereStock) { string sqlWhere = ""; if (WhereStock != null) { sqlWhere = StockCondition(WhereStock); } SampleStockResponses Sample = new SampleStockResponses(); using (SqlConnection conn = new SqlConnection(connStr)) { try { SqlCommand cmd = new SqlCommand("[pro_wms_SampleStockSelect]", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Where", sqlWhere); cmd.Parameters[0].SqlDbType = SqlDbType.VarChar; cmd.Parameters[0].Size = 4000; cmd.Parameters.AddWithValue("@PageIndex", WhereStock.PageIndex); cmd.Parameters[1].SqlDbType = SqlDbType.Int; cmd.Parameters.AddWithValue("@PageSize", WhereStock.PageSize); cmd.Parameters[2].SqlDbType = SqlDbType.Int; cmd.Parameters.AddWithValue("@RowCount", 0); cmd.Parameters[3].Direction = ParameterDirection.Output; cmd.Parameters[3].SqlDbType = SqlDbType.Int; //cmd.Parameters.AddWithValue("@Size", WhereStock.Size); //cmd.Parameters[0].SqlDbType = SqlDbType.VarChar; //cmd.Parameters[0].Size = 4000; //cmd.Parameters.AddWithValue("@Gender", WhereStock.Gender); //cmd.Parameters[1].SqlDbType = SqlDbType.VarChar; //cmd.Parameters[1].Size = 4000; //cmd.Parameters.AddWithValue("@Season", WhereStock.Season); //cmd.Parameters[2].SqlDbType = SqlDbType.VarChar; //cmd.Parameters[2].Size = 100; //cmd.Parameters.AddWithValue("@SKU", WhereStock.SKU); //cmd.Parameters[3].SqlDbType = SqlDbType.VarChar; //cmd.Parameters[3].Size = 8000; //cmd.Parameters.AddWithValue("@PE", WhereStock.PE); //cmd.Parameters[4].SqlDbType = SqlDbType.VarChar; //cmd.Parameters[4].Size = 100; //cmd.Parameters.AddWithValue("@ModelName", WhereStock.ModelName); //cmd.Parameters[5].SqlDbType = SqlDbType.VarChar; //cmd.Parameters[5].Size = 100; //cmd.Parameters.AddWithValue("@FOBBegin", WhereStock.FOBBegin); //cmd.Parameters[6].SqlDbType = SqlDbType.VarChar; //cmd.Parameters[6].Size = 100; //cmd.Parameters.AddWithValue("@FOBEnd", WhereStock.FOBEnd); //cmd.Parameters[7].SqlDbType = SqlDbType.VarChar; //cmd.Parameters[7].Size = 100; //cmd.Parameters.AddWithValue("@RetailPriceBegin", WhereStock.RetailPriceBegin); //cmd.Parameters[8].SqlDbType = SqlDbType.VarChar; //cmd.Parameters[8].Size = 100; //cmd.Parameters.AddWithValue("@RetailPriceEnd", WhereStock.RetailPriceEnd); //cmd.Parameters[9].SqlDbType = SqlDbType.VarChar; //cmd.Parameters[9].Size = 100; //cmd.Parameters.AddWithValue("@Silhouette", WhereStock.Silhouette); //cmd.Parameters[10].SqlDbType = SqlDbType.VarChar; //cmd.Parameters[10].Size = 100; //cmd.Parameters.AddWithValue("@PageIndex", WhereStock.PageIndex); //cmd.Parameters[11].SqlDbType = SqlDbType.Int; //cmd.Parameters.AddWithValue("@PageSize", WhereStock.PageSize); //cmd.Parameters[12].SqlDbType = SqlDbType.Int; //cmd.Parameters.AddWithValue("@RowCount", 0); //cmd.Parameters[13].Direction = ParameterDirection.Output; //cmd.Parameters[13].SqlDbType = SqlDbType.Int; conn.Open(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; sda.Fill(ds); Sample.RowCount = (int)cmd.Parameters[3].Value; Sample.SampleSS = ds.ConvertToEntityCollection <SampleStockSelect>(); conn.Close(); } catch (Exception) { throw; } } return(Sample); }