protected void Button1_Click(object sender, EventArgs e) { //生成会员,没有就成no_name会员 //生成主订单 double order_amount = Convert.ToDouble(TextRealMoney.Text); if (order_amount <= 0 || order_amount > all_sales) { JSHelper.WriteScript("alert('实收金额有误');history.back();"); return; } double order_plus = 0; order_plus = all_sales - order_amount; SqlHelper helper = LocalSqlHelper.WH; string Sql = "select * from Tb_cashier_cart where cashier_id=@cashier_id and trace_id=@trace_id"; helper.Params.Add("@cashier_id", my_admin_id); helper.Params.Add("@trace_id", trace_id); DataTable dt = helper.ExecDataTable(Sql); DateTime pay_time = DateTime.Now; string dingdan = "RT" + PublicHelper.ConvertDateTimeInt(pay_time); //插入订单商品 for (int i = 0; i < dt.Rows.Count; i++) { helper.Params.Clear(); int p_quantity = Convert.ToInt32(dt.Rows[i]["quantity"]); string p_txm = Convert.ToString(dt.Rows[i]["txm"]); helper.Params.Add("supplierid", StorageHelper.getSupplierIdByTxm(p_txm)); helper.Params.Add("dingdan", dingdan); helper.Params.Add("shopxpptid", Convert.ToInt32(dt.Rows[i]["goods_id"])); helper.Params.Add("style_id", Convert.ToInt32(dt.Rows[i]["spec_id"])); helper.Params.Add("shopxpptname", dt.Rows[i]["goods_name"]); helper.Params.Add("p_size", dt.Rows[i]["specification"]); helper.Params.Add("txm", p_txm); helper.Params.Add("productcount", p_quantity); helper.Params.Add("danjia", Convert.ToDouble(dt.Rows[i]["price"])); helper.Params.Add("voucher", Convert.ToDouble(dt.Rows[i]["voucher_price"])); helper.Insert("Direct_OrderDetail"); StorageHelper.changeStock(my_warehouse_id, Convert.ToInt32(dt.Rows[i]["spec_id"]), 0 - p_quantity, dingdan, "店面销售"); } //生成主订单 helper.Params.Clear(); string UserName = TextLoginName.Text; int userid = 0; if (UserName.IsNotNullAndEmpty()) { userid = UserHelper.getUserId(UserName); if (TextLoginName.Text != TextLoginName2.Text) { JSHelper.WriteScript("alert('两次客户标识不一致!');history.back();"); return; } if (userid == 0) { if (!UserName.IsCellPhone()) { JSHelper.WriteScript("alert('要求为手机号');history.back();"); return; } //生成新会员 UserInfo newUser = new UserInfo(); newUser.User_name = UserName; newUser.User_Mobile = UserName; newUser.is_hide = 0; newUser.User_Pwd = "666666"; newUser.User_level = 0; newUser.True_name = ""; newUser.cashier_id_from = my_admin_id; newUser.store_id_from = my_warehouse_id; userid = UserHelper.addUser(newUser); } helper.Params.Add("userid", userid); helper.Params.Add("user_name", UserName); } helper.Params.Add("warehouse_id", my_warehouse_id); helper.Params.Add("store_id", my_warehouse_id); //myStorageInfo.warehouse_name helper.Params.Add("seller_name", ""); helper.Params.Add("dingdan", dingdan); helper.Params.Add("dingdan_type", 99); helper.Params.Add("user_type", 0); helper.Params.Add("order_amount", order_amount); helper.Params.Add("order_plus", order_plus); helper.Params.Add("payment_name", DDPaymentName.Text); string phone_tel = ""; helper.Params.Add("usertel", phone_tel); helper.Params.Add("liuyan", ""); helper.Params.Add("shopxp_shfs", 0); helper.Params.Add("fksj", pay_time); int OrderStatus = 8; //实体店订单直接打单成功 helper.Params.Add("fhsj", pay_time); helper.Params.Add("zhuangtai", OrderStatus); helper.Params.Add("ShippingCompany", "noname"); helper.Params.Add("guide_id", Request["GuideList"]); helper.Params.Add("cashier_id", my_admin_id); helper.Insert("Direct_OrderMain"); //清除购物车 helper.Params.Clear(); helper.Params.Add("@cashier_id", my_admin_id); helper.Params.Add("@trace_id", trace_id); helper.Execute("delete from Tb_cashier_cart where cashier_id=@cashier_id and trace_id=@trace_id"); /* * helper.BeginTran(); * try * { * helper.CommitTran(); * } * catch (Exception ex) * { * helper.RollbackTran(); * JSHelper.WriteScript("alert('"+ex.Message+"');history.back();"); * } * */ JSHelper.WriteScript("alert('结算成功');location.href='CashierPrint.aspx?dingdan=" + dingdan + "';"); //Response.Write(RoleList.Text); Response.End(); }
protected void Button1_Click(object sender, EventArgs e) { //生成会员,没有就成no_name会员 //生成主订单 double order_amount = Convert.ToDouble(TextRealMoney.Text); if (order_amount <= 0 || order_amount > all_sales) { JSHelper.WriteScript("alert('实收金额有误');history.back();"); return; } double order_plus = 0; order_plus = all_sales - order_amount; SqlHelper helper = LocalSqlHelper.WH; string order_sql = "select * from dbo.Direct_OrderMain where shopxpacid=@shopxpacid"; helper.Params.Add("@shopxpacid", trace_id); DataTable order_dt = helper.ExecDataTable(order_sql); if (order_dt.Rows.Count == 0) { Response.Write("传递有误"); Response.End(); } string Sql = "select * from Tb_cashier_cart where cashier_id=@cashier_id and is_return=1 and trace_id=@trace_id"; helper.Params.Add("@cashier_id", my_admin_id); helper.Params.Add("@trace_id", trace_id); DataTable dt = helper.ExecDataTable(Sql); DateTime pay_time = DateTime.Now; string dingdan = order_dt.Rows[0]["dingdan"] + "_" + PublicHelper.ConvertDateTimeInt(pay_time) + "_return"; dingdan = "TH_" + PublicHelper.ConvertDateTimeInt(pay_time); //插入订单商品 for (int i = 0; i < dt.Rows.Count; i++) { helper.Params.Clear(); int p_quantity = Convert.ToInt32(dt.Rows[i]["quantity"]); string p_txm = Convert.ToString(dt.Rows[i]["txm"]); helper.Params.Add("supplierid", StorageHelper.getSupplierIdByTxm(p_txm)); helper.Params.Add("dingdan", dingdan); helper.Params.Add("shopxpptid", Convert.ToInt32(dt.Rows[i]["goods_id"])); helper.Params.Add("style_id", Convert.ToInt32(dt.Rows[i]["spec_id"])); helper.Params.Add("shopxpptname", dt.Rows[i]["goods_name"]); helper.Params.Add("p_size", dt.Rows[i]["specification"]); helper.Params.Add("txm", p_txm); helper.Params.Add("productcount", p_quantity); helper.Params.Add("danjia", Convert.ToDouble(dt.Rows[i]["price"])); helper.Params.Add("voucher", Convert.ToDouble(dt.Rows[i]["voucher_price"])); helper.Params.Add("return_detail_id", dt.Rows[i]["order_goods_id"]); helper.Insert("Direct_OrderDetail"); //更新原单中可退数量 helper.Params.Clear(); helper.Execute("update Direct_OrderDetail set productcount_return=productcount_return+" + (0 - p_quantity) + " where id=" + dt.Rows[i]["order_goods_id"]); StorageHelper.changeStock(my_warehouse_id, Convert.ToInt32(dt.Rows[i]["spec_id"]), 0 - p_quantity, dingdan, "店面销售"); } //生成主订单 helper.Params.Clear(); helper.Params.Add("userid", order_dt.Rows[0]["userid"]); helper.Params.Add("user_name", order_dt.Rows[0]["user_name"]); helper.Params.Add("warehouse_id", order_dt.Rows[0]["warehouse_id"]); helper.Params.Add("store_id", order_dt.Rows[0]["store_id"]); //myStorageInfo.warehouse_name helper.Params.Add("seller_name", order_dt.Rows[0]["userid"]); helper.Params.Add("dingdan", dingdan); helper.Params.Add("dingdan_type", 99); helper.Params.Add("user_type", 0); helper.Params.Add("order_amount", order_amount); helper.Params.Add("order_plus", order_plus); helper.Params.Add("payment_name", DDPaymentName.Text); helper.Params.Add("usertel", order_dt.Rows[0]["usertel"]); helper.Params.Add("liuyan", ""); helper.Params.Add("shopxp_shfs", 0); helper.Params.Add("fksj", pay_time); int OrderStatus = 11;//退货新生成 helper.Params.Add("fhsj", pay_time); helper.Params.Add("zhuangtai", OrderStatus); helper.Params.Add("guide_id", order_dt.Rows[0]["guide_id"]); helper.Params.Add("cashier_id", my_admin_id); helper.Params.Add("is_tiaohuan", 1); helper.Params.Add("return_order_id", trace_id); helper.Insert("Direct_OrderMain"); //清除购物车 helper.Params.Clear(); helper.Params.Add("@cashier_id", my_admin_id); helper.Params.Add("@trace_id", trace_id); helper.Execute("delete from Tb_cashier_cart where cashier_id=@cashier_id and is_return=1 and trace_id=@trace_id"); JSHelper.WriteScript("alert('退单成功');location.href='CashierPrint.aspx?dingdan=" + dingdan + "';"); //Response.Write(RoleList.Text); Response.End(); }