public ActionResult InsertAttributevalue(AttributeValuesModel valmodel) { int k = categoryandproduct.InsertAttributeValue(valmodel); if (k > 0) { return(Json("1", JsonRequestBehavior.DenyGet)); } else { return(Json("0", JsonRequestBehavior.DenyGet)); } }
/// <summary> /// 查询属性值 /// </summary> /// <param name="attrid"></param> /// <returns></returns> public List <AttributeValuesModel> GetAttributeValues(int attrid) { DataTable dt = dal.GetAttributevalues(attrid); List <AttributeValuesModel> list = new List <AttributeValuesModel>(); foreach (DataRow item in dt.Rows) { AttributeValuesModel model = new AttributeValuesModel(); model.attrid = int.Parse(item["attrid"].ToString()); model.attrshowtype = int.Parse(item["attrshowtype"].ToString()); model.attrvalueCode = item["attrvalueCode"].ToString(); model.attrvalueid = int.Parse(item["attrvalueid"].ToString()); model.attrvaluename = item["attrvaluename"].ToString(); model.Enablename = item["enablename"].ToString(); model.IsEnable = int.Parse(item["IsEnable"].ToString()); model.isinput = int.Parse(item["isinput"].ToString()); model.Showtypename = item["showtypename"].ToString(); list.Add(model); } return(list); }
/// <summary> /// 插入属性值信息 /// </summary> /// <param name="valuemodel"></param> /// <returns></returns> public int InsertAttributeValue(AttributeValuesModel valuemodel) { string sqltxt = @"INSERT INTO ShoppingStore.dbo.bsp_attributevalues ( attrid , attrvaluename , isinput , attrvalueCode , attrvaluedisplayorder , attrshowtype , IsEnable ) VALUES ( @attrid , @attrvaluename , @isinput , @attrvalueCode , 0 , @attrshowtype , @IsEnable )"; SqlParameter[] paramter = { new SqlParameter("@attrid", SqlDbType.Int), new SqlParameter("@attrvaluename", SqlDbType.NVarChar), new SqlParameter("@isinput", SqlDbType.Int), new SqlParameter("@attrvalueCode", SqlDbType.NVarChar), new SqlParameter("@attrshowtype", SqlDbType.Int), new SqlParameter("@IsEnable", SqlDbType.Int) }; paramter[0].Value = valuemodel.attrid; paramter[1].Value = valuemodel.attrvaluename; paramter[2].Value = valuemodel.isinput; paramter[3].Value = valuemodel.attrvalueCode; paramter[4].Value = valuemodel.attrshowtype; paramter[5].Value = valuemodel.IsEnable; return(helper.ExecuteSql(sqltxt, paramter)); }
/// <summary> /// 插入属性值信息 /// </summary> /// <param name="valuemodel"></param> /// <returns></returns> public int InsertAttributeValue(AttributeValuesModel valuemodel) { return(dal.InsertAttributeValue(valuemodel)); }