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