"GoodsID"附近有语法错误

2016-05-20 04:59:06 431 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

使用.NET 免费开源包ViewFaceCore做一个人脸识别并注册的功能，没有比我更全的本文介绍了一个基于WinForm的免费人脸识别系统实现方案。系统使用AForge和ViewFaceCore库，支持从USB或电脑自带摄像头采集图像，具备人脸注册和快速识别功能。硬件方面仅需普通摄像头，软件依赖多个NuGet包（如AForge.Video、ViewFaceCore等）。界面包含视频显示、图像预览和功能按钮控件，后台采用SQLServer存储用户面部特征数据。核心代码展示了人脸检测、特征提取和多线程处理逻辑，通过ViewFaceCore实现高效识别。系统具有识别速度快、准确率高的特点，适合Win 阅读详情

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class ShoppingCart : System.Web.UI.Page
{
public static string M_str_Count;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["users"] != null)
{
//向购物车中添加商品，如果购物车中已经存在该商品，则商品数量加１，如果是第一次购买，则向购物车中添加一条商品信息
string P_str_CartID = Session["users"].ToString();
string P_str_GoodsID = Request["GoodsID"];
DataSet ds = DBClass.reDs("select count(*) from tb_Cart where CartID=" + P_str_CartID + "and GoodsID=" + P_str_GoodsID);
if (ds.Tables[0].Rows[0][0].ToString() == "0")
{

DataSet ds1 = DBClass.reDs("select GoodsName,GoodsPrice from tb_GoodsInfo where GoodsID=" + P_str_GoodsID);
string P_str_GoodsName = ds1.Tables[0].Rows[0][0].ToString();
string P_str_GoodsPrice = ds1.Tables[0].Rows[0][1].ToString();
string P_str_Num = "1";
DBClass.ExSql("insert into tb_Cart values(" + P_str_CartID + "," + P_str_GoodsID + ",'" + P_str_GoodsName + "'," + P_str_GoodsPrice + "," + P_str_Num + ")");
}
else
{
DBClass.ExSql("update tb_Cart set Num=Num+1 where CartID=" + P_str_CartID + "and GoodsID=" + P_str_GoodsID);
}

//显示购物车中的商品信息
Bind();
}
else
Response.Write("<script>alert('您还没有登录，请登录后再使用，谢谢！');</script>");
}
}
//绑定DataList控件
public void Bind()
{
DataSet ds2 = DBClass.reDs("select *,GoodsPrice*Num As Count from tb_Cart where CartID=" + Session["users"]);
float P_fl_Count = 0;
foreach (DataRow dr in ds2.Tables[0].Rows)
{
P_fl_Count += Convert.ToSingle(dr[6]);
}
M_str_Count = P_fl_Count.ToString();
dlShoppingCart.DataSource = ds2;
dlShoppingCart.DataBind();
}

protected void dlShoppingCart_ItemDataBound(object sender, DataListItemEventArgs e)
{
//用来实现数量文本框中只能输入数字
TextBox txtGoodsNum = (TextBox)e.Item.FindControl("txtGoodsNum");
if (txtGoodsNum != null)
{
txtGoodsNum.Attributes["onkeyup"] = "value=value.replace(/[^\\d]/g,'')";
}

}
//清空购物车
protected void lnkbtnClear_Click(object sender, EventArgs e)
{
bool P_bool_reVal = DBClass.ExSql("Delete from tb_Cart where CartID=" + Session["users"]);
if (!P_bool_reVal)
Response.Write("<script>清空失败，请重试！</script>");
else
Bind();
}
//清空购物车时的提示信息
protected void lnkbtnClear_Load(object sender, EventArgs e)
{
lnkbtnClear.Attributes["onclick"] = "javascript:return confirm('你确定要清空购物车吗？')";
}
//继续购物
protected void lnkbtnContinue_Click(object sender, EventArgs e)
{
Response.Redirect("~/GoodsList.aspx");
}
//删除购物车中的商品
protected void dlShoppingCart_DeleteCommand(object source, DataListCommandEventArgs e)
{
bool P_bool_reVal = DBClass.ExSql("Delete from tb_Cart where CartID=" + Session["users"] + " and GoodsID=" + e.CommandArgument.ToString());
if (!P_bool_reVal)
Response.Write("<script>删除失败，请重试！</script>");
else
Bind();
}
//删除购物车中的商品时的提示信息
protected void lnkbtnDel_Load(object sender, EventArgs e)
{
((LinkButton)sender).Attributes["onclick"] = "javascript:return confirm('你确定要删除该物品吗？')";
}
//更新购物车
protected void dlShoppingCart_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "updateNum")
{
string P_str_Num = ((TextBox)e.Item.FindControl("txtGoodsNum")).Text;
bool P_bool_reVal = DBClass.ExSql("update tb_Cart set Num=" + P_str_Num + "where CartID=" + Session["users"] + "and GoodsID=" + e.CommandArgument.ToString());
if (P_bool_reVal)
Bind();
}
}
protected void lnkbtnSettleAccounts_Click(object sender, EventArgs e)
{
if (M_str_Count == "")
{
Response.Write("<script>alert('您的购物车中没有任何物品!');</script>");
}
else
{
DataSet ds = DBClass.reDs("select MemberMoney from tb_Member where MemberName=" + Session["users"].ToString());
decimal P_str_Money = Convert.ToDecimal(ds.Tables[0].Rows[0][0].ToString());
if (P_str_Money < Convert.ToDecimal(M_str_Count))
{
Response.Write("<script>alert('您的余额不足，请重新充值后再购买！');</script>");
}
else
{
bool P_bool_reVal1 = DBClass.ExSql("Delete from tb_Cart where CartID=" + Session["users"]);
bool P_bool_reval2 = DBClass.ExSql("update tb_Member set MemberMoney=MemberMoney-" + M_str_Count + " where MemberName=" + Session["users"]);
if (!P_bool_reVal1 & !P_bool_reval2)
{
Response.Write("<script>结账失败，请重试！</script>");
}
else
{
Bind();
//Response.Redirect("SuccessShop.aspx");
Response.Write("<script>window.open('SuccessShop.aspx','','Width=300px;Height=250px;status=no;help=no;scrollbars=no');</script>");
}
}
}
}
}

...全文