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