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); }