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