public SampleStockResponses GetSampleStock(SampleStockCondition request)
{
SampleStockResponses response = new SampleStockResponses();
try
{
response = new DaoSampleStorage().GetSampleStock(request);
}
catch (Exception ex)
{
LogError(ex);
}
return(response);
}
private string StockCondition(SampleStockCondition Stock)
{
StringBuilder sb = new StringBuilder();
sb.Append(" 1=1");
if (Stock.SKU != null && Stock.SKU != "")
{
sb.Append(" AND substring(sk.SKUCategory10,1,len(sk.SKUCategory10)-6) in(" + Stock.SKU + ")");
}
if (Stock.PE != null && Stock.PE != "")
{
sb.Append(" AND SKUCategory07 ='" + Stock.PE + "'");
}
if (Stock.Gender != null && Stock.Gender != "")
{
sb.Append(" AND SKUCategory01 in(" + Stock.Gender + ")");
}
if (Stock.Size != null && Stock.Size != "")
{
sb.Append(" AND SKUCategory09 in(" + Stock.Size + ")");
}
if (Stock.ModelName != null && Stock.ModelName != "")
{
sb.Append(" AND sk.SKUCategory03 ='" + Stock.ModelName + "'");
}
if (Stock.Silhouette != null && Stock.Silhouette != "")
{
if (Stock.Silhouette.IndexOf(',') > 0)
{
sb.Append(" AND (1=1");
string[] str = Stock.Silhouette.Split(',');
for (int i = 0; i < str.Length; i++)
{
sb.Append(" OR sk.AllocationRule LIKE '%" + str[i].ToString() + "%'");
}
sb.Append(") ");
}
else
{
sb.Append(" AND sk.AllocationRule LIKE '%" + Stock.Silhouette + "%'");
}
}
if (Stock.Season != null && Stock.Season != "")
{
if (Stock.Season.IndexOf(',') > 0)
{
sb.Append(" AND (1=1");
string[] str = Stock.Season.Split(',');
for (int i = 0; i < str.Length; i++)
{
sb.Append(" OR lc.LotCategory02 LIKE '%" + str[i].ToString() + "%'");
}
sb.Append(") ");
}
else
{
sb.Append(" AND lc.LotCategory02 LIKE '%" + Stock.Season + "%'");
}
}
//if (Stock.ModelName != null && Stock.ModelName != "")
//{
// if (Stock.ModelName.IndexOf(',') > 0)
// {
// sb.Append(" AND (1=1");
// string[] str = Stock.ModelName.Split(',');
// for (int i = 0; i < str.Length; i++)
// {
// sb.Append(" OR sk.AttentionToAddressLine2 LIKE '%" + str[i].ToString() + "%'");
// }
// sb.Append(") ");
// }
// else
// sb.Append(" AND sk.AttentionToAddressLine2 LIKE '%" + Stock.ModelName + "%'");
//}
if (Stock.RetailPriceBegin != null && Stock.RetailPriceBegin != "")
{
sb.Append(" AND sk.AttentionToAddressLine4 >=" + Stock.RetailPriceBegin + "");
}
if (Stock.RetailPriceEnd != null && Stock.RetailPriceEnd != "")
{
sb.Append(" AND sk.AttentionToAddressLine4 <=" + Stock.RetailPriceEnd + "");
}
if (Stock.FOBBegin != null && Stock.FOBBegin != "")
{
sb.Append(" AND sk.AttentionToAddressLine3 >=" + Stock.FOBBegin + "");
}
if (Stock.FOBEnd != null && Stock.FOBEnd != "")
{
sb.Append(" AND sk.AttentionToAddressLine3 <=" + Stock.FOBEnd + "");
}
return(sb.ToString());
}
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);
}
