private CategoryConditionModel GetBrandCondition(int scenceId, int cateId)
{
CategoryConditionModel ccmodel = null;
List<string> selvals = new List<string>();
foreach(ListItem item in cblBrands.Items)
{
if (item.Selected)
selvals.Add(item.Value);
}
if (selvals.Count > 0)
{
string selbrans = String.Join(",",selvals.ToArray());
ccmodel = new CategoryConditionModel(scenceId, cateId,"brandid",selbrans );
}
return ccmodel;
}
private CategoryConditionModel GetParaCondition(int scenceId, int cateId, RepeaterItem item)
{
CategoryConditionModel ccmodel = null;
Label lblPropName = item.FindControl("lblPropName") as Label;
CheckBoxList cblPara = item.FindControl("cblPara") as CheckBoxList;
List<string> selvals = new List<string>();
foreach (ListItem sitem in cblPara.Items)
{
if (sitem.Selected)
selvals.Add("'" + sitem.Value + "'");
}
if (selvals.Count > 0)
{
string rulvals = String.Join(",", selvals.ToArray());
ccmodel = new CategoryConditionModel(scenceId, cateId, int.Parse(lblPropName.ToolTip), rulvals);
}
return ccmodel;
}
private CategoryConditionModel GetPriceCondition(int scenceId,int cateId)
{
CategoryConditionModel ccmodel = null;
int maxprice, minprice;
if (!int.TryParse(txtMaxPrice.Text, out maxprice))
{
maxprice = int.MaxValue;
}
if (!int.TryParse(txtMinPrice.Text, out minprice))
{
minprice = 0;
}
if (minprice > 0 || maxprice < int.MaxValue)
{
ccmodel = new CategoryConditionModel(scenceId, cateId, maxprice, minprice);
}
return ccmodel;
}
/// <summary>
/// ����һ������
/// </summary>
public void Save(CategoryConditionModel model)
{
DbCommand dbCommand = dbw.GetStoredProcCommand("UP_slCategoryCondition_Save");
dbw.AddInParameter(dbCommand, "CateId", DbType.Int32, model.CateId);
dbw.AddInParameter(dbCommand, "SenceId", DbType.Int32, model.SenceId);
dbw.AddInParameter(dbCommand, "RuleName", DbType.AnsiString, model.RuleName);
dbw.AddInParameter(dbCommand, "RuleValue", DbType.AnsiString, model.RuleValue);
dbw.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// ����ʵ�������
/// </summary>
public CategoryConditionModel ReaderBind(IDataReader dataReader)
{
CategoryConditionModel model = new CategoryConditionModel();
object ojb;
ojb = dataReader["CateId"];
if(ojb != null && ojb != DBNull.Value)
{
model.CateId=(int)ojb;
}
ojb = dataReader["SenceId"];
if(ojb != null && ojb != DBNull.Value)
{
model.SenceId=Convert.ToInt32(ojb);
}
model.RuleName=dataReader["RuleName"].ToString();
model.RuleValue=dataReader["RuleValue"].ToString();
return model;
}
/// <summary>
/// ����һ������
/// </summary>
public void Save(CategoryConditionModel model)
{
dal.Save(model);
}
