/// <summary>
/// 存储HTML
/// </summary>
/// <param name="htmlEdit">单个商品HTML代码</param>
/// <returns>成功失败</returns>
public bool SaveHtml(SingleGoodHtmlEdit htmlEdit)
{
string lSqlstring = "insert SingleGoodHtmlEdit(GoodID,EditText,EditImg) values('" + htmlEdit.GoodID + "',N'" + htmlEdit.EditText + "',N'" + htmlEdit.EditImg + "')";
if (SqlHelper.ExecuteNonQuery(lSqlstring) > 0)
{
return(true);
}
else
{
return(false);
}
}
public static List <SingleGoodHtmlEdit> GetSingleGoodInfo(int GoodID)
{
List <SingleGoodHtmlEdit> SingleGoodHtmlList = new List <SingleGoodHtmlEdit>();
string lSqlString = "select * from SingleGoodHtmlEdit where GoodID='" + GoodID + "'";
SqlHelper.ReadDateReadBegin(lSqlString);
while (SqlHelper.SqlReader.Read())
{
SingleGoodHtmlEdit lSingleGoodHtmlEdit = new SingleGoodHtmlEdit();
lSingleGoodHtmlEdit.EditImg = SqlHelper.SqlReader["EditImg"].ToString();
lSingleGoodHtmlEdit.EditText = SqlHelper.SqlReader["EditText"].ToString();
SingleGoodHtmlList.Add(lSingleGoodHtmlEdit);
}
SqlHelper.ReadDateReadEnd();
return(SingleGoodHtmlList);
}
public static List <SingleGoodHtmlEdit> getSingleGoodHtmlEditInfo(int goodid)
{
List <SingleGoodHtmlEdit> singGoodHtmlList = new List <SingleGoodHtmlEdit>();
string lSqlstring = "select * from SingleGoodHtmlEdit where GoodID='" + goodid + "'";
SqlHelper.ReadDateReadBegin(lSqlstring);
while (SqlHelper.SqlReader.Read())
{
SingleGoodHtmlEdit singleGoodHtml = new SingleGoodHtmlEdit();
singleGoodHtml.EditImg = SqlHelper.SqlReader["EditImg"].ToString();
singleGoodHtml.EditText = SqlHelper.SqlReader["EditText"].ToString();
singGoodHtmlList.Add(singleGoodHtml);
}
SqlHelper.ReadDateReadEnd();
return(singGoodHtmlList);
}