public string InsertOrEditProduct(string name, string price, string type, string head, string title, string detail, string pimage, string pnumber, string id = null, string tj = null, string zs = null)
{
string[] images = pimage.Split(',');
MySqlParameter[] msp;
if (id == null)
{
msp = new MySqlParameter[]
{
new MySqlParameter("goodsName", name), new MySqlParameter("GoodsDetail", detail),
new MySqlParameter("ClassID", type), new MySqlParameter("Images", string.Join(";", images)),
new MySqlParameter("Price", price), new MySqlParameter("Photos", head), new MySqlParameter("deleted", "0"),
new MySqlParameter("Title", title), new MySqlParameter("GoodsNo", pnumber), new MySqlParameter("Created", DateTime.Now)
};
}
else
{
msp = new MySqlParameter[]
{
new MySqlParameter("goodsName", name), new MySqlParameter("GoodsDetail", detail),
new MySqlParameter("ClassID", type), new MySqlParameter("Images", string.Join(";", images)),
new MySqlParameter("Price", price), new MySqlParameter("Photos", head),
new MySqlParameter("Title", title), new MySqlParameter("GoodsNo", pnumber), new MySqlParameter("id", id ?? "")
};
}
msp = new MySqlParameter[]
{
new MySqlParameter("goodsName", name), new MySqlParameter("GoodsDetail", detail), new MySqlParameter("HomeRecommend", tj == "true"?"1":"0"),
new MySqlParameter("ClassID", type), new MySqlParameter("Images", pimage), new MySqlParameter("HomeShow", zs == "true"?"1":"0"),
new MySqlParameter("Price", price), new MySqlParameter("Photos", head), new MySqlParameter("deleted", "0"),
new MySqlParameter("Title", title), new MySqlParameter("GoodsNo", pnumber), new MySqlParameter("Created", DateTime.Now), new MySqlParameter("id", id ?? "")
};
string strSql = "";
if (id == null)
{
strSql = @"insert into goods(goodsName,GoodsNo,ClassID,Price,Title,GoodsDetail,HomeRecommend,HomeShow,Photos,deleted,Images,Created) VALUES
(?goodsName,?GoodsNo,?ClassID, ?Price,?Title,?GoodsDetail,?HomeRecommend,?HomeShow, ?Photos, ?deleted, ?Images,?Created)";
}
else
{
strSql = @" UPDATE goods set GoodsName=?goodsName,GoodsNo=?GoodsNo,ClassID=?ClassID,Price=?Price,Title=?Title,GoodsDetail=?GoodsDetail,HomeShow=?HomeShow,HomeRecommend=?HomeRecommend,Photos=?Photos,Images=?Images
where id = ?id";
}
SqlOper.SqlHelper sqlHelper = new SqlOper.SqlHelper();
int count = sqlHelper.ExecutionMySql(strSql, msp);
if (count > 0)
{
return("{ \"statusCode\":\"200\",\"message\":\"保存成功\" }");
}
else
{
return("{ \"statusCode\":\"300\",\"message\":\"保存失败\"}");
}
}
