protected void Page_Load(object sender, EventArgs e)
{
string id, name, pwd, tel, email, addr;
id = Request.Form["id"];
name = Request.Form["name"];
pwd = Request.Form["pwd"];
tel = Request.Form["tel"];
email = Request.Form["email"];
addr = Request.Form["addr"];
//Response.Write("true");
dbutils db = new dbutils();
db.createConnect();
string sql = "insert into user (u_id,u_name ,u_password,u_tel,u_email,u_addr) values( '" + id + "','" + name + "','" + pwd + "','" + tel + "','" + email + "','" + addr + "') ;";
int count = db.ExecuteNonQuery(sql);
db.closeConnect();
if (count == 1)
{
Response.Write("true");
}
else
{
Response.Write("false");
}
}
protected void Page_Load(object sender, EventArgs e)
{
dbutils db = new dbutils();
db.createConnect();
string g_id = Request.Form["g_id"];
user u = (user)Session["user"];
string u_id = "";
if (u == null)
{
Response.Write("no");
return;
}
else
{
u_id = u.U_ID;
}
string sql = "insert into shoppingcart(sc_num,u_id,g_id) values(1,'" + u_id + "','" + int.Parse(g_id.Trim()) + "')";
int res = db.ExecuteNonQuery(sql);
db.closeConnect();
if (res == 1)
{
Response.Write("true");
return;
}
else
{
Response.Write("false");
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
dbutils db = new dbutils();
db.createConnect();
string id = Request.Form["u_id"];
string pwd = Request.Form["u_pwd"];
int flag = int.Parse(Request.Form["flag"]);
if (flag == 1)
{
string sql = "select COUNT(*) from user WHERE user.u_id = '" + id + "' and user.u_password = '******';";
DataSet ds = db.executeQueue(sql);
db.closeConnect();
int count = int.Parse(ds.Tables[0].Rows[0][0].ToString());
if (count == 1)
{
//Session.Add("user", new user(id, pwd)); //登录成功以后将用户信息保存在Session中
Session["user"] = new user(id, pwd);
Session["u_id"] = id;
Response.Write("true");
}
else
{
Response.Write("false");
}
}
else
{
Session.Remove("user");//退出以后将user从session中移除
Response.Write("true");
}
}
public string get_images()
{
//u_id_cur = Session["u_id"].ToString();
string text = Request.QueryString["g_id"];
dbutils db = new dbutils();
db.createConnect();
string output1 = "";
string sql2 = "select * from goods where goods.g_id ='" + text + "'";
DataSet ds2 = db.executeQueue(sql2);
db.closeConnect();
output1 += "<div class=\"product_content_inner\">";
output1 += "<div class=\"product_image_row d-flex flex-md-row flex-column align-items-md-end align-items-start justify-content-start\">";
output1 += "<div class=\"product_image_1 product_image\">";
output1 += "<img src = " + ds2.Tables[0].Rows[0][4].ToString() + " alt=\"\"/>";
output1 += "</div>";
output1 += "<div class=\"product_image_2 product_image\"><img src = " + ds2.Tables[0].Rows[0][5].ToString() + " alt=\"\"/></div>";
output1 += "</div>";
output1 += "<div class=\"product_image_row\">";
output1 += "<div class=\"product_image_3 product_image\"><img src = " + ds2.Tables[0].Rows[0][6].ToString() + " alt=\"\"/></div>";
output1 += "</div>";
output1 += "<div class=\"product_image_row d-flex flex-md-row flex-column align-items-start justify-content-start\">";
output1 += "<div class=\"product_image_4 product_image\"><img src = " + ds2.Tables[0].Rows[0][7].ToString() + " alt=\"\"/></div>";
output1 += "<div class=\"product_image_5 product_image\"><img src = " + ds2.Tables[0].Rows[0][4].ToString() + " alt=\"\"/></div>";
output1 += "</div>";
output1 += "</div>";
db.closeConnect();
return(output1);
}
protected void Page_Load(object sender, EventArgs e)
{
List <good> list = new List <good>();
dbutils db = new dbutils();
db.createConnect();
string search = Request.Form["search"];
string type = Request.Form["type"];
string sort = Request.Form["sort"];
string output = get_goods(0, type, sort, search);
Response.Write(output);
}
protected void Button1_Click(object sender, EventArgs e)
{
user u = (user)Session["user"];
string u_id = "";
if (u == null)
{
Response.Write("<script language=javascript>alert('请登录后购买！')</script>");
return;
}
else
{
u_id = u.U_ID;
}
string text = Request.QueryString["g_id"];
dbutils db = new dbutils();
db.createConnect();
string sc_num = TextBox1.Text;
//user u = (user)Session["user"];
//string u_id = "";
//if (u == null)
//{
// Response.Write("no");
// return;
//}
//else
//{
// u_id = u.U_ID;
//}
string sql = "insert into shoppingcart(sc_num,u_id,g_id) values('" + sc_num + "','" + u_id + "','" + text + "')";
int res = db.ExecuteNonQuery(sql);
db.closeConnect();
if (res == 1)
{
Response.Write("<script language=javascript>alert('添加成功！')</script>");
}
else
{
Response.Write("<script language=javascript>alert('添加失败！')</script>");
}
}
//protected void But_deleteall(object sender, EventArgs e)
//{
// dbutils db = new dbutils();
// db.createConnect();
// string sc_id = Request.Form["sc_id"];
// user u = (user)Session["user"];
// string u_id = "";
// if (u == null)
// {
// Response.Write("no");
// return;
// }
// else
// {
// u_id = u.U_ID;
// }
// string sql = "DELETE FROM shoppingcart where u_id = '" + u_id + "'";
// int res = db.ExecuteNonQuery(sql);
// db.closeConnect();
//}
public string get_order()
{
u_id_cur = Session["u_id"].ToString();
dbutils db = new dbutils();
db.createConnect();
string output = "";
string sql2 = "SELECT orderlist.o_id,user.u_name,goods.g_name,orderlist.g_id,o_num,o_sum_price,o_state from (goods,orderlist,user) where buy_id ='" + u_id_cur + "' and buy_id = user.u_id and orderlist.g_id = goods.g_id";
DataSet ds2 = db.executeQueue(sql2);
db.closeConnect();
num = ds2.Tables[0].Rows.Count;
for (int i = 0; i < num; ++i)
{
string state;
if (ds2.Tables[0].Rows[i][6].ToString() == "0")
{
state = "未发货";
}
else
{
state = "已发货";
}
//double tatol = Convert.ToDouble(ds2.Tables[0].Rows[i][3].ToString()) * Convert.ToDouble(ds2.Tables[0].Rows[i][4].ToString());
output += "<li class=\"cart_item item_list d - flex flex - lg - row flex - column align - items - lg - center align - items - start justify - content - start\">";
output += "<div class=\"product d-flex flex-lg-row flex-column align-items-lg-center align-items-start justify-content-start\">";
output += "<div class=\"product_total text-lg-center product_text\"><span>订单状态: </span>" + state + " <button class=\"btn btn-outline-primary btn-sm btn_delete\" runat=\"server\"><span style=\"display:none\">" + ds2.Tables[0].Rows[i][0].ToString() + "</span><i class=\"fa fa-times\" aria-hidden=\"true\"></i></button></div>";
output += "</div>";
output += "<div class=\"product_size text-lg-center product_text\"><span>订单编号：</span>" + ds2.Tables[0].Rows[i][0].ToString() + "</div>";
output += "<div class=\"product_size text-lg-center product_text\"><span>卖家：</span>" + ds2.Tables[0].Rows[i][1].ToString() + "</div>";
//output += "<div class=\"product_size text-lg-center product_text\"><span>商品：</span>" + ds2.Tables[0].Rows[i][2].ToString() + "</div>";
output += "<div class=\"product_size text-lg-center product_text\"><span>商品ID：</span>" + ds2.Tables[0].Rows[i][3].ToString() + "</div>";
output += "<div class=\"product_price text-lg-center product_text\"><span>数量: </span>" + ds2.Tables[0].Rows[i][4].ToString() + "</div>";
output += "<div class=\"product_price text-lg-center product_text\"><span>总价: </span>$" + ds2.Tables[0].Rows[i][5].ToString() + "</div>";
//output += "<div class=\"product_total text-lg-center product_text\"><span>订单状态: </span>" + state + " <button class=\"btn btn-outline-primary btn-sm btn_delete\" runat=\"server\"><span style=\"display:none\">" + ds2.Tables[0].Rows[i][0].ToString() + "</span><i class=\"fa fa-times\" aria-hidden=\"true\"></i></button></div>";
//output += "<label id=label" + i.ToString() + ">";
output += "</li>";
}
db.closeConnect();
return(output);
}
public string get_goods()
{
u_id_cur = Session["u_id"].ToString();
List <good> list = new List <good>();
dbutils db = new dbutils();
db.createConnect();
string output = "";
string sql2 = "SELECT goods.g_image1,g_name,g_info,g_price,sc_num,goods.g_id,sc_id from (goods,shoppingcart) where goods.g_id = shoppingcart.g_id and shoppingcart.u_id = '" + u_id_cur + "';";
DataSet ds2 = db.executeQueue(sql2);
db.closeConnect();
num = ds2.Tables[0].Rows.Count;
for (int i = 0; i < num; ++i)
{
double tatol = Convert.ToDouble(ds2.Tables[0].Rows[i][3].ToString()) * Convert.ToDouble(ds2.Tables[0].Rows[i][4].ToString());
output += "<li class=\"cart_item item_list d - flex flex - lg - row flex - column align - items - lg - center align - items - start justify - content - start\">";
output += "<div class=\"product d-flex flex-lg-row flex-column align-items-lg-center align-items-start justify-content-start\">";
output += "<div><div class=\"product_image\"><img src = \"" + ds2.Tables[0].Rows[i][0].ToString() + "\" alt=\"\"/></div></div>";
output += "<div class=\"product_name\"><a href = \"goodsdetail.aspx?g_id=" + ds2.Tables[0].Rows[i][5].ToString() + "\"> " + ds2.Tables[0].Rows[i][1].ToString() + "</a></div>";
output += "</div>";
output += "<div class=\"product_size text-lg-center product_text\"><span>商品ID：</span>" + ds2.Tables[0].Rows[i][5].ToString() + "</div>";
output += "<div class=\"product_size text-lg-center product_text\"><span>详细信息：</span>" + ds2.Tables[0].Rows[i][2].ToString() + "</div>";
output += "<div class=\"product_price text-lg-center product_text\"><span>价格: </span>$" + ds2.Tables[0].Rows[i][3].ToString() + "</div>";
output += "<div class=\"product_quantity_container\">";
output += "<div class=\"product_quantity ml-lg-auto mr-lg-auto text-center\">";
output += "<span class=\"product_text product_num\">" + ds2.Tables[0].Rows[i][4].ToString() + "</span>";
output += "<div class=\"qty_sub qty_button trans_200 text-center\"><span>-</span></div>";
output += "<div class=\"qty_add qty_button trans_200 text-center\"><span>+</span></div>";
output += "</div>";
output += "</div>";
output += "<div class=\"product_total text-lg-center product_text\"><span>总价: </span>$" + tatol.ToString() + " <button class=\"btn btn-outline-primary btn-sm btn_delete\" runat=\"server\"><span style=\"display:none\">" + ds2.Tables[0].Rows[i][6].ToString() + "</span><i class=\"fa fa-times\" aria-hidden=\"true\"></i></button> <button class=\"btn btn-outline-primary btn-sm btn_buy\" runat=\"server\"><span style=\"display:none\">" + ds2.Tables[0].Rows[i][6].ToString() + "</span>购买</button></div>";
//output += "<label id=label"+i.ToString()+">";
output += "</li>";
}
db.closeConnect();
return(output);
}
protected void Page_Load(object sender, EventArgs e)
{
dbutils db = new dbutils();
db.createConnect();
string sc_id = Request.Form["sc_id"];
user u = (user)Session["user"];
string u_id = "";
if (u == null)
{
Response.Write("no");
return;
}
else
{
u_id = u.U_ID;
}
string sql = "DELETE FROM shoppingcart where sc_id = '" + sc_id + "'";
int res = db.ExecuteNonQuery(sql);
db.closeConnect();
if (res == 1)
{
//更新前端数据
//Response.Write("true");
Response.Redirect("shoppingcart2.aspx");
return;
}
else
{
Response.Write("false");
return;
}
}
protected void But_deleteall(object sender, EventArgs e)
{
dbutils db = new dbutils();
db.createConnect();
string sc_id = Request.Form["sc_id"];
user u = (user)Session["user"];
string u_id = "";
if (u == null)
{
Response.Write("no");
return;
}
else
{
u_id = u.U_ID;
}
string sql = "DELETE FROM shoppingcart where u_id = '" + u_id + "'";
int res = db.ExecuteNonQuery(sql);
db.closeConnect();
}
public string get_goods()
{
//u_id_cur = Session["u_id"].ToString();
string text = Request.QueryString["g_id"];
dbutils db = new dbutils();
db.createConnect();
string output1 = "";
string sql2 = "select g_name,g_price,t_name,u_id,g_info from(goods,goodstype) where goods.g_id ='" + text + "' and goods.t_id = goodstype.t_id";
DataSet ds2 = db.executeQueue(sql2);
db.closeConnect();
output1 += "<div class=\"product_name\">" + ds2.Tables[0].Rows[0][0].ToString() + "</div>";
output1 += "<div class=\"product_price\">单价：$" + ds2.Tables[0].Rows[0][1].ToString() + "</div>";
output1 += "<div class=\"product_price\">类型：" + ds2.Tables[0].Rows[0][2].ToString() + "</div>";
output1 += "<div class=\"product_price\">卖家：" + ds2.Tables[0].Rows[0][3].ToString() + "</div>";
output1 += "<div class=\"product_price\">详细信息：<br>" + ds2.Tables[0].Rows[0][4].ToString() + "</div>";
db.closeConnect();
return(output1);
}
/*
* 绑定证件类型
*/
public void bindCerType()
{
//绑定排序方式
string[] Month = new string[3] {
"未排序", "销量", "价格"
};
this.DropDownList2.DataSource = Month;
this.DropDownList2.DataBind();
string sql = sql = "SELECT t_id,t_name from goodstype;";
dbutils db = new dbutils();
db.createConnect();
DataSet ds = db.executeQueue(sql);
DataTable dt = ds.Tables[0];
li_cer_type.DataSource = dt;
li_cer_type.DataTextField = "t_name";
li_cer_type.DataValueField = "t_id";
li_cer_type.DataBind();
db.closeConnect();
}
protected void Page_Load(object sender, EventArgs e)
{
dbutils db = new dbutils();
db.createConnect();
string sc_id = Request.Form["sc_id"];
user u = (user)Session["user"];
string u_id = "";
if (u == null)
{
Response.Write("no");
return;
}
else
{
u_id = u.U_ID;
}
string sql1 = "select shoppingcart.g_id,goods.u_id,g_price,sc_num,g_num from(goods,shoppingcart) where sc_id='" + sc_id + "' and shoppingcart.g_id = goods.g_id";
DataSet ds1 = db.executeQueue(sql1);
string g_id = ds1.Tables[0].Rows[0][0].ToString();
string sc_num = ds1.Tables[0].Rows[0][3].ToString();
string g_num = ds1.Tables[0].Rows[0][4].ToString();
string sell_id = ds1.Tables[0].Rows[0][1].ToString();
string price = ds1.Tables[0].Rows[0][2].ToString();
db.closeConnect();
int sc_num_cur = Convert.ToInt32(sc_num);
int g_num_cur = Convert.ToInt32(g_num);
double sum_price = sc_num_cur * Convert.ToDouble(price);
if (sc_num_cur > g_num_cur)
{
db.createConnect();
string sql2 = "DELETE FROM shoppingcart where sc_id = '" + sc_id + "'";
int res = db.ExecuteNonQuery(sql2);
db.closeConnect();
if (res == 1)
{
//更新前端数据
Response.Redirect("shoppingcart2.aspx");
return;
}
Response.Write("库存不足");
}
else
{
db.createConnect();
string sql3 = "insert into orderlist(g_id,buy_id,sell_id,o_state,o_num,o_sum_price) values( '" + g_id + "','" + u_id + "','" + sell_id + "','0','" + sc_num + "','" + sum_price.ToString() + "') ;";
int count = db.ExecuteNonQuery(sql3);
db.closeConnect();
db.createConnect();
int all_num = g_num_cur - sc_num_cur;
string sql5 = "update goods set g_num = '" + all_num.ToString() + "' where g_id ='" + g_id + "'";
db.ExecuteNonQuery(sql5);
db.closeConnect();
db.createConnect();
string sql4 = "DELETE FROM shoppingcart where sc_id = '" + sc_id + "'";
int res = db.ExecuteNonQuery(sql4);
db.closeConnect();
if (res == 1)
{
//更新前端数据
Response.Redirect("shoppingcart2.aspx");
return;
}
}
}
//public string get_goodstype()
// {
// List<good> list = new List<good>();
// dbutils db = new dbutils();
// db.createConnect();
// string sql = "";
// sql = "SELECT t_id,t_name from goodstype;";
// DataSet ds = db.executeQueue(sql);
// string output = "";
// for (int i = 0; i < ds.Tables[0].Rows.Count; ++i)
// {
// output += "<a class=\"dropdown-item type\" href=\"#\" runat=\"server\">" + ds.Tables[0].Rows[i][1].ToString() + "<span style=\"display:none\">" + ds.Tables[0].Rows[i][0].ToString() + "</span></a>";
// }
// db.closeConnect();
// return output;
// }
public string get_goods(int flag)
{
List <good> list = new List <good>();
dbutils db = new dbutils();
db.createConnect();
//string search = input.Value;
//获取选择的类型值
//1、首先获取到按钮中的html文本，然后从中提取到类型的编号
//string type = "";
//type = Regex.Replace(type, @"[^0-9]+", "");
//string sort = "";
//sort = Regex.Replace(sort, @"[\r\n]+", "");
//sort = sort.Trim();
string output = "";
string sql = "";
if (flag == 1) //表示页面第一次加载，查询所有的数据
{
sql = "SELECT g_id,g_name,g_price,g_image1,g_info from goods;";
}
else
{
string sort = this.DropDownList2.SelectedValue;
string type = this.li_cer_type.SelectedValue;
string search = this.input.Value;
if (sort.Equals("销量"))
{
sql = "SELECT goods.g_id,g_name,g_price,g_image1,g_info from goods,orderlist where orderlist.g_id = goods.g_id and t_id = '" + int.Parse(type) + "' and (g_name LIKE '%" + search + "%' OR g_info LIKE '%" + search + "%' ) order by o_num DESC;";
}
else if (sort.Equals("价格"))
{
sql = "SELECT goods.g_id,g_name,g_price,g_image1,g_info from goods where t_id = '" + int.Parse(type) + "' and (g_name LIKE '%" + search + "%' OR g_info LIKE '%" + search + "%') order by g_price DESC;";
}
else
{
sql = "SELECT g_id,g_name,g_price,g_image1,g_info from goods where t_id = '" + int.Parse(type) + "' and (g_name LIKE '%" + search + "%' OR g_info LIKE '%" + search + "%');";
}
}
DataSet ds = db.executeQueue(sql);
db.closeConnect();
int f = 0;
int num = ds.Tables[0].Rows.Count;
for (int i = 0; i < num; ++i)
{
if (f % 4 == 0)
{
output += " <div class=\"row p-2 rows\" >";
}
output += "<div class=\"col-sm-3 \"><div class=\"card post-slide\" \"><div class=\"post-img \" style=\"margin:0px;padding:0px;\"> <a href=\"goodsdetail.aspx?g_id=" + ds.Tables[0].Rows[i][0].ToString() + "\"><img src=" + ds.Tables[0].Rows[i][3].ToString() + " class=\"card-img-top\" alt=\"\"/></a></div><div class=\"card-body\"> <p class=\"card-text\">" + ds.Tables[0].Rows[i][4].ToString() + "</p></div><div class=\"card-footer\"><a class=\"btn btn-light\"><small class=\"text-muted\"><strong>Price:$" + ds.Tables[0].Rows[i][2].ToString() + "</strong></small></a><button href=\"#\" class=\"btn btn-outline-info good\"><i class=\"fa fa-cart-arrow-down \" aria-hidden=\"true\"><span style=\"display:none\">" + ds.Tables[0].Rows[i][0].ToString() + "</span></i></button></div></div> </div>";
if ((f + 1) % 4 == 0)
{
output += "</div>";
}
f++;
//list.Add(new good(ds.Tables[0].Rows[i][0].ToString(), ds.Tables[0].Rows[i][1].ToString(), double.Parse(ds.Tables[0].Rows[i][2].ToString()), ds.Tables[0].Rows[i][3].ToString(), ds.Tables[0].Rows[i][4].ToString()));
}
db.closeConnect();
return(output);
}
