private void SaveCateConditions()
{
CategoryConditionBll ccbll = new CategoryConditionBll();
CategoryConditionModel pmodel = null;
int scenceId = int.Parse(lblSenceId.Text);
int cateId = int.Parse(lblCateId.Text);
pmodel = GetPriceCondition(scenceId, cateId);
if (pmodel != null)
{
ccbll.Save(pmodel);
}
pmodel = GetBrandCondition(scenceId, cateId);
if (pmodel != null)
{
ccbll.Save(pmodel);
}
pmodel = GetSubCondition(scenceId, cateId);
if (pmodel != null)
{
ccbll.Save(pmodel);
}
foreach (RepeaterItem item in rpItems.Items)
{
pmodel = GetParaCondition(scenceId, cateId, item);
if (pmodel != null)
{
ccbll.Save(pmodel);
}
}
}
/// <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);
}
public CategoryConditionModel GetModel(int ScenceID, int CategoryID)
{
string sql = "select * from slcategorycondition where senceid={0} and cateid={1}";
CategoryConditionModel model = null;
using (IDataReader dataReader = dbr.ExecuteReader(CommandType.Text, String.Format(sql, ScenceID, CategoryID)))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <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);
}
private CategoryConditionModel GetSubCondition(int scenceId, int cateId)
{
CategoryConditionModel ccmodel = null;
List <string> selvals = new List <string>();
foreach (ListItem item in cblSubCate.Items)
{
if (item.Selected)
{
selvals.Add(item.Value);
}
}
if (selvals.Count > 0)
{
string selsubids = String.Join(",", selvals.ToArray());
ccmodel = new CategoryConditionModel(scenceId, cateId, "cateid", selsubids);
}
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);
}
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);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Save(CategoryConditionModel model)
{
dal.Save(model);
}
