//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { ChkAdminLevel("order_express", DTEnums.ActionEnum.Delete.ToString()); //检查权限 int sucCount = 0; int errorCount = 0; BLL.express bll = new BLL.express(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { if (bll.Delete(id)) { sucCount += 1; } else { errorCount += 1; } } } AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除配送方式成功" + sucCount + "条,失败" + errorCount + "条"); //记录日志 JscriptMsg("删除成功" + sucCount + "条,失败" + errorCount + "条!", Utils.CombUrlTxt("express_list.aspx", "keywords={0}", this.keywords), "Success"); }
private bool DoAdd() { Model.express model = new Model.express(); BLL.express bll = new BLL.express(); model.title = txtTitle.Text.Trim(); model.express_code = txtExpressCode.Text.Trim(); model.express_fee = Vincent._DTcms.Utils.StrToDecimal(txtExpressFee.Text.Trim(), 0); model.img_url = txtImgUrl.Text; model.website = txtWebSite.Text.Trim(); model.remark = Vincent._DTcms.Utils.ToHtml(txtRemark.Text); if (cbIsLock.Checked == true) { model.is_lock = 0; } else { model.is_lock = 1; } model.sort_id = Vincent._DTcms.Utils.StrToInt(txtSortId.Text.Trim(), 99); if (bll.Add(model) > 0) { AddAdminLog(Vincent._DTcms.DTEnums.ActionEnum.Add.ToString(), "添加配送方式:" + model.title); //记录日志 return(true); } return(false); }
protected void Page_Load(object sender, EventArgs e) { this.id = TWRequest.GetQueryInt("id"); if (this.id == 0) { JscriptMsg("傳輸參數不正確!", "back"); return; } if (!new BLL.orders().Exists(this.id)) { JscriptMsg("記錄不存在或已被刪除!", "back"); return; } if (!Page.IsPostBack) { BLL.express bll2 = new BLL.express(); DataTable dt = bll2.GetList("").Tables[0]; ddlExpressId.Items.Clear(); ddlExpressId.Items.Add(new ListItem("請選擇配送方式", "")); foreach (DataRow dr in dt.Rows) { ddlExpressId.Items.Add(new ListItem(dr["title"].ToString(), dr["id"].ToString())); } //ChkAdminLevel("order_list", TWEnums.ActionEnum.View.ToString()); //檢查許可權 ShowInfo(this.id); } }
//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { ChkAdminLevel("order_express", AXEnums.ActionEnum.Delete.ToString()); //检查权限 int sucCount = 0; int errorCount = 0; BLL.express bll = new BLL.express(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { if (bll.Delete(id)) { sucCount += 1; } else { errorCount += 1; } } } AddAdminLog(AXEnums.ActionEnum.Delete.ToString(), "删除配送小区成功" + sucCount + "条,失败" + errorCount + "条"); //记录日志 JscriptMsg("删除成功" + sucCount + "条,失败" + errorCount + "条!", Utils.CombUrlTxt("express_list.aspx", "keywords={0}", this.keywords), "Success"); }
private bool DoEdit(int _id) { bool result = false; BLL.express bll = new BLL.express(); Model.express model = bll.GetModel(_id); model.title = txtTitle.Text.Trim(); model.express_code = txtExpressCode.Text.Trim(); model.express_fee = Utils.StrToDecimal(txtExpressFee.Text.Trim(), 0); model.website = txtWebSite.Text.Trim(); model.remark = Utils.ToHtml(txtRemark.Text); if (cbIsLock.Checked == true) { model.is_lock = 0; } else { model.is_lock = 1; } model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99); if (bll.Update(model)) { AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "修改配送方式:" + model.title); //记录日志 result = true; } return(result); }
private bool DoAdd() { Model.express model = new Model.express(); BLL.express bll = new BLL.express(); Model.wx_userweixin weixin = GetWeiXinCode(); model.title = txtTitle.Text.Trim(); model.express_code = txtExpressCode.Text.Trim(); model.express_fee = Utils.StrToDecimal(txtExpressFee.Text.Trim(), 0); model.website = txtWebSite.Text.Trim(); model.remark = Utils.ToHtml(txtRemark.Text); model.wid = weixin.id; if (cbIsLock.Checked == true) { model.is_lock = 0; } else { model.is_lock = 1; } model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99); if (bll.Add(model) > 0) { AddAdminLog(MXEnums.ActionEnum.Add.ToString(), "添加配送方式:" + model.title); //记录日志 return(true); } return(false); }
/// <summary> /// 重写虚方法,此方法在Init事件执行 /// </summary> protected override void InitPage() { id = DTRequest.GetQueryInt("id"); BLL.orders bll = new BLL.orders(); if (!bll.Exists(id)) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错了,您要浏览的页面不存在或已删除!"))); return; } model = bll.GetModel(id); if (model.user_id != userModel.id) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错了,您所查看的并非自己的订单信息!"))); return; } payModel = new BLL.payment().GetModel(model.payment_id); if (payModel == null) { payModel = new Model.payment(); } //根据订单状态和物流单号跟踪物流信息 if (model.status > 1 && model.status < 4 && model.express_status == 2 && model.express_no.Trim().Length > 0) { Model.express modelt = new BLL.express().GetModel(model.express_id); Model.orderconfig orderConfig = new BLL.orderconfig().loadConfig(); } }
private bool DoAdd() { Model.express model = new Model.express(); BLL.express bll = new BLL.express(); Model.wx_userweixin weixin = GetWeiXinCode(); model.title = txtTitle.Text.Trim(); model.express_code = txtExpressCode.Text.Trim(); model.express_fee = Utils.StrToDecimal(txtExpressFee.Text.Trim(), 0); model.website = txtWebSite.Text.Trim(); model.remark = Utils.ToHtml(txtRemark.Text); model.wid = weixin.id; if (cbIsLock.Checked == true) { model.is_lock = 0; } else { model.is_lock = 1; } model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99); if (bll.Add(model) > 0) { AddAdminLog(MXEnums.ActionEnum.Add.ToString(), "添加配送方式:" + model.title); //记录日志 return true; } return false; }
/// <summary> /// 重写虚方法,此方法在Init事件执行 /// </summary> protected override void InitPage() { id = DTRequest.GetQueryInt("id"); BLL.orders bll = new BLL.orders(); if (!bll.Exists(id)) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错了,您要浏览的页面不存在或已删除!"))); return; } model = bll.GetModel(id); if (model.user_id != userModel.id) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错了,您所查看的并非自己的订单信息!"))); return; } payModel = new BLL.payment().GetModel(model.payment_id); if (payModel == null) { payModel = new Model.payment(); } //根据订单状态和物流单号跟踪物流信息 if (model.status > 1 && model.status < 4 && model.express_status == 2 && model.express_no.Trim().Length > 0) { Model.express modelt = new BLL.express().GetModel(model.express_id); Model.orderconfig orderConfig = new BLL.orderconfig().loadConfig(); } }
public string GetExpress() { BLL.express art = new BLL.express(); var info = art.GetList("1=1"); // Vincent._Json json = new _Json(); return(CreateJsonParameters(info.Tables[0])); }
/// <summary> /// 确认订单页面 /// </summary> public void confirmOrder() { //1用户的地址 BLL.wx_shop_user_addr uAddrBll = new BLL.wx_shop_user_addr(); IList <Model.wx_shop_user_addr> uaddrList = uAddrBll.GetOpenidAddrName(openid, wid); if (uaddrList == null || uaddrList.Count <= 0 || uaddrList[0].id <= 0) { } else { this.Document.SetValue("addrinfo", uaddrList[0]); } //快递信息列表 BLL.express expressBll = new BLL.express(); DataSet dsExpress = expressBll.GetExpressList100(wid); this.Document.SetValue("express", dsExpress); //支付信息列表 BLL.payment pbll = new BLL.payment(); DataSet dsPay = pbll.GetList(0, " is_lock=0 and wid=" + wid, " sort_id asc"); this.Document.SetValue("payment", dsPay); //购物车里的商品 BLL.wx_shop_cart cartBll = new BLL.wx_shop_cart(); IList <Model.cartProduct> cartList = cartBll.GetCartList(openid, wid); this.Document.SetValue("cartlist", cartList); string cartStr = "["; if (cartList.Count > 0) { for (int i = cartList.Count - 1; i >= 0; i--) { if (i != 0) { cartStr += "{ \"ic\": \"" + cartList[i].id + "\", \"attr\": \"\", \"bc\": \"" + cartList[i].productNum + "\", \"mid\": " + cartList[i].skuId + " },"; } else { cartStr += "{ \"ic\": \"" + cartList[i].id + "\", \"attr\": \"\", \"bc\": \"" + cartList[i].productNum + "\", \"mid\": " + cartList[i].skuId + " }"; } } } cartStr += "]"; decimal alltotPrice = cartList.Sum(item => item.totPrice); this.Document.SetValue("alltot", alltotPrice * 100); this.Document.SetValue("alltot_y", alltotPrice); this.Document.SetValue("cartStr", cartStr); }
/// <summary> /// 返回配送列表 /// </summary> /// <param name="top">显示条数</param> /// <param name="strwhere">查询条件</param> /// <returns>DataTable</returns> protected DataTable get_express_list(int top, string strwhere) { DataTable dt = new DataTable(); string _where = "is_lock=0"; if (!string.IsNullOrEmpty(strwhere)) { _where += " and " + strwhere; } dt = new BLL.express().GetList(top, _where, "sort_id asc,id desc").Tables[0]; return dt; }
private void ExpBind(string strWhere) { BLL.express bll = new BLL.express(); DataTable dt = bll.GetList(0, strWhere, "sort_id asc,id asc").Tables[0]; this.ddlExpressId.Items.Clear(); this.ddlExpressId.Items.Add(new ListItem("请选择配送小区...", "")); foreach (DataRow dr in dt.Rows) { this.ddlExpressId.Items.Add(new ListItem(dr["title"].ToString(), dr["id"].ToString())); } }
/// <summary> /// 返回配送列表 /// </summary> /// <param name="top">显示条数</param> /// <param name="strwhere">查询条件</param> /// <returns>DataTable</returns> public List <Model.express> get_express_list(int top, string strwhere) { List <Model.express> list = new List <Model.express>(); string _where = "is_lock=0"; if (!string.IsNullOrEmpty(strwhere)) { _where += " and " + strwhere; } list = new BLL.express().GetModelList(top, _where, "*", "sort_id asc,id desc"); return(list); }
/// <summary> /// 返回配送列表 /// </summary> /// <param name="top">显示条数</param> /// <param name="strwhere">查询条件</param> /// <returns>DataTable</returns> protected DataTable get_express_list(int top, string strwhere) { DataTable dt = new DataTable(); string _where = "is_lock=0"; if (!string.IsNullOrEmpty(strwhere)) { _where += " and " + strwhere; } dt = new BLL.express().GetList(top, _where, "sort_id asc,id desc").Tables[0]; return(dt); }
private void ShowInfo(int _id) { BLL.orders bll = new BLL.orders(); model = bll.GetModel(_id); //绑定商品列表 this.rptList.DataSource = model.order_goods; this.rptList.DataBind(); //根据订单状态,显示各类操作按钮 switch (model.status) { case 1: //如果是线下支付,支付状态为0,如果是线上支付,支付成功后会自动改变订单状态为已确认 if (model.payment_status > 0) { //确认付款、取消订单、修改收货按钮显示 btnPayment.Visible = btnCancel.Visible = btnEditAcceptInfo.Visible = true; } else { //确认订单、取消订单、修改收货按钮显示 btnConfirm.Visible = btnCancel.Visible = btnEditAcceptInfo.Visible = true; } //修改订单备注、修改商品总金额、修改配送费用、修改支付手续费、修改发票税金按钮显示 btnEditRemark.Visible = btnEditRealAmount.Visible = btnEditExpressFee.Visible = btnEditPaymentFee.Visible = btnEditInvoiceTaxes.Visible = true; break; case 2: //如果订单为已确认状态,则进入发货状态 if (model.express_status == 1) { //确认发货、取消订单、修改收货信息按钮显示 btnExpress.Visible = btnCancel.Visible = btnEditAcceptInfo.Visible = true; } else if (model.express_status == 2) { //完成订单、取消订单按钮可见 btnComplete.Visible = btnCancel.Visible = true; } //修改订单备注按钮可见 btnEditRemark.Visible = true; break; case 3: //作废订单、修改订单备注按钮可见 btnInvalid.Visible = btnEditRemark.Visible = true; break; } //根据订单状态和物流单号跟踪物流信息 if (model.express_status == 2 && model.express_no.Trim().Length > 0) { Model.express modelt = new BLL.express().GetModel(model.express_id); Model.orderconfig orderConfig = new BLL.orderconfig().loadConfig(); } }
private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; BLL.express bll = new BLL.express(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("express_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind(string _strWhere, string _orderby) { this.page = MXRequest.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; BLL.express bll = new BLL.express(); this.rptList.DataSource = bll.GetListshop(this.pageSize, this.page, "min_attrid", _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("attr.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind(string _strWhere, string _orderby) { Model.wx_userweixin weixin = GetWeiXinCode(); _strWhere = "wid=" + weixin.id + " " + _strWhere; this.page = MXRequest.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; BLL.express bll = new BLL.express(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("express_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void ShowInfo(string _order_no) { BLL.orders bll = new BLL.orders(); Model.orders model = bll.GetModel(_order_no); BLL.express bll2 = new BLL.express(); DataTable dt = bll2.GetList(0, string.Empty, "sort_id asc,id desc").Tables[0]; ddlExpressId.Items.Clear(); ddlExpressId.Items.Add(new ListItem("请选择配送方式", "")); foreach (DataRow dr in dt.Rows) { ddlExpressId.Items.Add(new ListItem(dr["title"].ToString(), dr["id"].ToString())); } txtExpressNo.Text = model.express_no; ddlExpressId.SelectedValue = model.express_id.ToString(); }
private void ShowInfo(string _order_no) { BLL.orders bll = new BLL.orders(); Model.orders model = bll.GetModel(_order_no); BLL.express bll2 = new BLL.express(); DataTable dt = bll2.GetList("").Tables[0]; ddlExpressId.Items.Clear(); ddlExpressId.Items.Add(new ListItem("请选择配送方式", "")); foreach (DataRow dr in dt.Rows) { ddlExpressId.Items.Add(new ListItem(dr["title"].ToString(), dr["id"].ToString())); } txtExpressNo.Text = model.express_no; ddlExpressId.SelectedValue = model.express_id.ToString(); }
//保存排序 protected void btnSave_Click(object sender, EventArgs e) { ChkAdminLevel("order_express", DTEnums.ActionEnum.Edit.ToString()); //检查权限 BLL.express bll = new BLL.express(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); int sortId; if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId)) { sortId = 99; } bll.UpdateField(id, "sort_id=" + sortId.ToString()); } AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "保存配送方式排序"); //记录日志 JscriptMsg("保存排序成功!", Utils.CombUrlTxt("express_list.aspx", "keywords={0}", this.keywords), "Success"); }
//保存排序 protected void btnSave_Click(object sender, EventArgs e) { ChkAdminLevel("order_express", AXEnums.ActionEnum.Edit.ToString()); //检查权限 BLL.express bll = new BLL.express(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); int sortId; if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId)) { sortId = 99; } bll.UpdateField(id, "sort_id=" + sortId.ToString()); } AddAdminLog(AXEnums.ActionEnum.Edit.ToString(), "保存配送小区排序"); //记录日志 JscriptMsg("保存排序成功!", Utils.CombUrlTxt("express_list.aspx", "keywords={0}", this.keywords), "Success"); }
private void ShowInfo(string _order_no) { BLL.orders bll = new BLL.orders(); Model.orders model = bll.GetModel(_order_no); BLL.express bll2 = new BLL.express(); DataTable dt = bll2.GetList("").Tables[0]; //ddlExpressId.Items.Clear(); //ddlExpressId.Items.Add(new ListItem("请选择配送小区", "")); //foreach (DataRow dr in dt.Rows) //{ // ddlExpressId.Items.Add(new ListItem(dr["title"].ToString(), dr["id"].ToString())); //} txtExpressNo.Text = model.express_no; // ddlExpressId.SelectedValue = model.express_id.ToString(); }
private void ShowInfo(int _id) { BLL.express bll = new BLL.express(); Model.express model = bll.GetModel(_id); txtTitle.Text = model.title; txtExpressCode.Text = model.express_code; txtExpressFee.Text = model.express_fee.ToString(); txtWebSite.Text = model.website; txtRemark.Text = Utils.ToTxt(model.remark); if (model.is_lock == 0) { cbIsLock.Checked = true; } else { cbIsLock.Checked = false; } txtSortId.Text = model.sort_id.ToString(); }
private void ShowInfo(int _id) { BLL.express bll = new BLL.express(); Model.express model = bll.GetModel(_id); txtTitle.Text = model.title; txtExpressCode.Text = model.express_code; txtExpressFee.Text = model.express_fee.ToString(); txtWebSite.Text = model.website; txtRemark.Text = Utils.ToTxt(model.remark); if (model.is_lock == 0) { cbIsLock.Checked = true; } else { cbIsLock.Checked = false; } txtSortId.Text = model.sort_id.ToString(); }
/// <summary> /// 重写虚方法,此方法在Init事件执行 /// </summary> protected override void InitPage() { id = DTRequest.GetQueryInt("id"); BLL.orders bll = new BLL.orders(); if (!bll.Exists(id)) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错了,您要浏览的页面不存在或已删除!"))); return; } model = bll.GetModel(id); if (model.user_id != userModel.id) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错了,您所查看的并非自己的订单信息!"))); return; } payModel = new BLL.site_payment().GetPaymentModel(model.payment_id); if (payModel == null) { payModel = new Model.payment(); } //根据订单状态和物流单号跟踪物流信息 if (model.status > 1 && model.status < 4 && model.express_status == 2 && model.express_no.Trim().Length > 0) { Model.express modelt = new BLL.express().GetModel(model.express_id); Model.orderconfig orderConfig = new BLL.orderconfig().loadConfig(); if (modelt != null && modelt.express_code.Trim().Length > 0 && orderConfig.kuaidiapi != "") { string apiurl = orderConfig.kuaidiapi + "?id=" + orderConfig.kuaidikey + "&com=" + modelt.express_code + "&nu=" + model.express_no + "&show=" + orderConfig.kuaidishow + "&muti=" + orderConfig.kuaidimuti + "&order=" + orderConfig.kuaidiorder; string detail = Utils.HttpGet(@apiurl); if (detail != null) { expressdetail = Utils.ToHtml(detail); } } } }
/// <summary> /// 重写虚方法,此方法在Init事件执行 /// </summary> protected override void InitPage() { id = DTRequest.GetQueryInt("id"); BLL.orders bll = new BLL.orders(); if (!bll.Exists(id)) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错了,您要浏览的页面不存在或已删除!"))); return; } model = bll.GetModel(id); if (model.user_id != userModel.id) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错了,您所查看的并非自己的订单信息!"))); return; } payModel = new BLL.payment().GetModel(model.payment_id); if (payModel == null) { payModel = new Model.payment(); } //根据订单状态和物流单号跟踪物流信息 if (model.status > 1 && model.status < 4 && model.express_status == 2 && model.express_no.Trim().Length > 0) { Model.express modelt = new BLL.express().GetModel(model.express_id); Model.orderconfig orderConfig = new BLL.orderconfig().loadConfig(); if (modelt != null && modelt.express_code.Trim().Length > 0 && orderConfig.kuaidiapi != "") { string apiurl = orderConfig.kuaidiapi + "?id=" + orderConfig.kuaidikey + "&com=" + modelt.express_code + "&nu=" + model.express_no + "&show=" + orderConfig.kuaidishow + "&muti=" + orderConfig.kuaidimuti + "&order=" + orderConfig.kuaidiorder; string detail = Utils.HttpGet(@apiurl); if (detail != null) { expressdetail = Utils.ToHtml(detail); } } } }
private bool DoEdit(int _id) { bool result = false; BLL.express bll = new BLL.express(); Model.express model = bll.GetModel(_id); model.title = txtTitle.Text.Trim(); model.express_code = txtExpressCode.Text.Trim(); model.express_fee = Utils.StrToDecimal(txtExpressFee.Text.Trim(), 0); model.website = txtWebSite.Text.Trim(); model.remark = Utils.ToHtml(txtRemark.Text); if (cbIsLock.Checked == true) { model.is_lock = 0; } else { model.is_lock = 1; } model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99); if (bll.Update(model)) { AddAdminLog(MXEnums.ActionEnum.Edit.ToString(), "修改配送方式:" + model.title); //记录日志 result = true; } return result; }
private void ShowInfo(int _id) { BLL.orders bll = new BLL.orders(); model = bll.GetModel(_id); //绑定商品列表 this.rptList.DataSource = model.order_goods; this.rptList.DataBind(); //获得会员信息 if (model.user_id > 0) { Model.users user_info = new BLL.users().GetModel(model.user_id); if (user_info != null) { Model.user_groups group_info = new BLL.user_groups().GetModel(user_info.group_id); if (group_info != null) { dlUserInfo.Visible = true; lbUserName.Text = user_info.user_name; lbUserGroup.Text = group_info.title; lbUserDiscount.Text = group_info.discount.ToString() + " %"; lbUserAmount.Text = user_info.amount.ToString(); lbUserPoint.Text = user_info.point.ToString(); } } } //根据订单状态,显示各类操作按钮 switch (model.status) { case 1: //如果是线下支付,支付状态为0,如果是线上支付,支付成功后会自动改变订单状态为已确认 if (model.payment_status > 0) { //确认付款、取消订单、修改收货按钮显示 btnPayment.Visible = btnCancel.Visible = btnEditAcceptInfo.Visible = true; } else { //确认订单、取消订单、修改收货按钮显示 btnConfirm.Visible = btnCancel.Visible = btnEditAcceptInfo.Visible = true; } //修改订单备注、修改商品总金额、修改配送费用、修改支付手续费、修改发票税金按钮显示 btnEditRemark.Visible = btnEditRealAmount.Visible = btnEditExpressFee.Visible = btnEditPaymentFee.Visible = btnEditInvoiceTaxes.Visible = true; break; case 2: //如果订单为已确认状态,则进入发货状态 if (model.express_status == 1) { //确认发货、取消订单、修改收货信息按钮显示 btnExpress.Visible = btnCancel.Visible = btnEditAcceptInfo.Visible = true; } else if (model.express_status == 2) { //完成订单、取消订单按钮可见 btnComplete.Visible = btnCancel.Visible = true; } //修改订单备注按钮可见 btnEditRemark.Visible = true; break; case 3: //作废订单、修改订单备注按钮可见 btnInvalid.Visible = btnEditRemark.Visible = true; break; } //根据订单状态和物流单号跟踪物流信息 if (model.express_status == 2 && model.express_no.Trim().Length > 0) { Model.express modelt = new BLL.express().GetModel(model.express_id); Model.orderconfig orderConfig = new BLL.orderconfig().loadConfig(); if (modelt != null && modelt.express_code.Trim().Length > 0 && orderConfig.kuaidiapi != "") { string apiurl = orderConfig.kuaidiapi + "?id=" + orderConfig.kuaidikey + "&com=" + modelt.express_code + "&nu=" + model.express_no + "&show=" + orderConfig.kuaidishow + "&muti=" + orderConfig.kuaidimuti + "&order=" + orderConfig.kuaidiorder; string detail = Utils.HttpGet(@apiurl); if (detail != null) { litExpressDetail.Text = Utils.ToHtml(detail); } } } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/json"; BLL.wx_shop_cart cartBll = new BLL.wx_shop_cart(); string _action = MyCommFun.QueryString("myact"); string openid = MyCommFun.RequestOpenid(); //得到微信用户的openid Dictionary <string, string> jsonDict = new Dictionary <string, string>(); if (_action == "addCart") { #region 添加购物车 try { int wid = MyCommFun.RequestInt("wid"); int productId = MyCommFun.RequestInt("productid"); int skuId = MyCommFun.RequestInt("mid"); string skuInfo = MyCommFun.QueryString("attr"); int productNum = MyCommFun.RequestInt("bc"); decimal totalPrice = (decimal)MyCommFun.RequestFloat("totprice", 0); Model.wx_shop_cart cart = new Model.wx_shop_cart(); IList <Model.wx_shop_cart> cartList = cartBll.GetModelList("productId=" + productId + " and openid='" + openid + "' and skuId=" + skuId); bool isAdd = true; if (cartList != null && cartList.Count > 0) { isAdd = false; cart = cartList[0]; } if (isAdd) { cart.createDate = DateTime.Now; cart.openid = openid; cart.productId = productId; cart.productNum = productNum; cart.skuId = skuId; cart.skuInfo = skuInfo; cart.totPrice = totalPrice * productNum; cart.wid = wid; int ret = cartBll.Add(cart); if (ret > 0) { jsonDict.Add("errCode", "false"); } else { jsonDict.Add("errCode", "true"); } } else { cart.openid = openid; cart.productNum += productNum; cart.skuId = skuId; cart.skuInfo = skuInfo; cart.totPrice += totalPrice * productNum; cart.wid = wid; bool ret = cartBll.Update(cart); if (ret) { jsonDict.Add("errCode", "false"); } else { jsonDict.Add("errCode", "true"); } } } catch (Exception ex) { jsonDict.Add("errCode", "true"); } finally { context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } #endregion } else if (_action == "pcount") { #region 购物车商品数量 jsonDict = new Dictionary <string, string>(); int wid = MyCommFun.RequestInt("wid"); int count = cartBll.GetRecordCount("wid=" + wid + " and openid='" + openid + "'"); jsonDict.Add("data", count.ToString()); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); #endregion } else if (_action == "remove") { #region 移除购物车商品 jsonDict = new Dictionary <string, string>(); int cartId = MyCommFun.RequestInt("id"); cartBll.Delete(cartId); jsonDict.Add("errCode", "false"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); #endregion } else if (_action == "modifyNum") { #region 修改购物车商品数量 jsonDict = new Dictionary <string, string>(); int cartId = MyCommFun.RequestInt("ic"); int newNum = MyCommFun.RequestInt("bc"); cartBll.UpdateNum(cartId, newNum); jsonDict.Add("errCode", "false"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); #endregion } else if (_action == "getCity") { #region 择省份,改变城市列表 int privice = MyCommFun.RequestInt("pvid"); BLL.pre_common_district areaBll = new BLL.pre_common_district(); IList <Model.pre_common_district> disList = areaBll.GetModelList("upid=" + privice + " and level=2"); Model.pre_common_district dis; StringBuilder jsonStr = new StringBuilder("{\"errCode\":0,\"retCode\":0,\"msgType\":0,\"errMsg\":\"\",\"data\":["); for (int i = 0; i < disList.Count; i++) { dis = new Model.pre_common_district(); if (i != disList.Count - 1) { jsonStr.Append("{\"id\":" + disList[i].id + ",\"name\":\"" + disList[i].name + "\"},"); } else { jsonStr.Append("{\"id\":" + disList[i].id + ",\"name\":\"" + disList[i].name + "\"}"); } } jsonStr.Append("]}"); context.Response.Write(jsonStr); #endregion } else if (_action == "getArea") { #region 择城市,改变区域列表 int ctid = MyCommFun.RequestInt("ctid"); BLL.pre_common_district areaBll = new BLL.pre_common_district(); IList <Model.pre_common_district> disList = areaBll.GetModelList("upid=" + ctid + " and level=3"); Model.pre_common_district dis; StringBuilder jsonStr = new StringBuilder("{\"errCode\":0,\"retCode\":0,\"msgType\":0,\"errMsg\":\"\",\"data\":["); for (int i = 0; i < disList.Count; i++) { dis = new Model.pre_common_district(); if (i != disList.Count - 1) { jsonStr.Append("{\"id\":" + disList[i].id + ",\"name\":\"" + disList[i].name + "\"},"); } else { jsonStr.Append("{\"id\":" + disList[i].id + ",\"name\":\"" + disList[i].name + "\"}"); } } jsonStr.Append("]}"); context.Response.Write(jsonStr); #endregion } else if (_action == "order_save") { #region 保存订单信息 //获得传参信息 int wid = MyCommFun.RequestInt("wid"); int payment_id = MyCommFun.RequestInt("pc"); //支付方式:1货到付款;3微支付 int express_id = MyCommFun.RequestInt("mtype"); //物流方式 // string orderStrList = MyCommFun.QueryString("orderStrList"); //检查物流方式 if (express_id == 0) { context.Response.Write("{\"errCode\":3, \"msg\":\"对不起,请选择配送方式!\"}"); return; } BLL.wx_shop_user_addr uAddrBll = new BLL.wx_shop_user_addr(); IList <Model.wx_shop_user_addr> uaddrList = uAddrBll.GetOpenidAddrName(openid, wid); if (uaddrList == null || uaddrList.Count <= 0 || uaddrList[0].id <= 0) { context.Response.Write("{\"errCode\":3, \"msg\":\"收货地址不存在,无法结算!\"}"); return; } //检查购物车商品 IList <Model.cartProduct> cartList = cartBll.GetCartList(openid, wid); if (cartList == null) { context.Response.Write("{\"errCode\":3, \"msg\":\"对不起,购物车为空,无法结算!\"}"); return; } //统计购物车 decimal payable_amount = cartList.Sum(c => c.totPrice); //物流费用 BLL.express expressBll = new BLL.express(); Model.express expModel = expressBll.GetModel(express_id); //支付方式 BLL.payment pbll = new BLL.payment(); Model.payment payModel = pbll.GetModelBypTypeId(payment_id); //保存订单======================================================================= Model.orders model = new Model.orders(); model.order_no = "b" + Utils.GetOrderNumber(); //订单号B开头为商品订单 model.wid = wid; model.openid = openid; model.modelName = "微商城"; model.modelCode = "shop"; model.modelActionName = ""; model.modelActionId = 0; model.user_id = 0; model.user_name = ""; model.payment_id = payment_id; model.express_id = express_id; model.accept_name = uaddrList[0].contractPerson; model.post_code = ""; model.telphone = uaddrList[0].tel; model.mobile = uaddrList[0].tel; model.area = uaddrList[0].province; model.city = uaddrList[0].city; model.district = uaddrList[0].area; model.address = uaddrList[0].province + " " + uaddrList[0].city + " " + uaddrList[0].area + " " + uaddrList[0].addrDetail; model.message = ""; model.payable_amount = payable_amount; //应付商品总金额 model.real_amount = payable_amount; //实际商品总金额, model.status = 1; model.express_status = 1; model.express_fee = expModel.express_fee; //物流费用 if (payment_id == 1) { //货到付款,需要确认订单 model.payment_status = 0; //标记未付款 } else { //先款后货 model.payment_status = 1; //标记未付款 } bool quicklyFH = false; //如果是先款后货的话 if (payment_id == 3) { if (payModel.poundage_type == 1) //百分比 { model.payment_fee = model.real_amount * payModel.poundage_amount / 100; } else //固定金额 { model.payment_fee = payModel.poundage_amount; } BLL.wx_payment_wxpay wxBll = new BLL.wx_payment_wxpay(); Model.wx_payment_wxpay wxpay = wxBll.GetModelByWid(wid); quicklyFH = wxpay.quicklyFH; } if (quicklyFH) { model.express_status = 0; } //订单总金额=实付商品金额+运费+支付手续费 model.order_amount = model.real_amount + model.express_fee + model.payment_fee; //购物积分,可为负数 model.point = 0; model.add_time = DateTime.Now; //商品详细列表 List <Model.order_goods> gls = new List <Model.order_goods>(); foreach (Model.cartProduct item in cartList) { gls.Add(new Model.order_goods { goods_id = item.productId, goods_title = item.productName, goods_price = item.avgPrice, real_price = item.avgPrice, quantity = item.productNum, point = 0 }); } model.order_goods = gls; int result = new BLL.orders().Add(model); if (result < 1) { context.Response.Write("{\"errCode\":3, \"msg\":\"订单保存过程中发生错误,请重新提交!\"}"); return; } //清空购物车,此步骤移到确认支付页面 // //提交成功,返回URL order_no context.Response.Write("{\"errCode\":true,\"payType\":\"" + payment_id + "\", \"order_no\":\"" + model.order_no + "\",\"orderid\":\"" + result + "\",\"wid\":\"" + wid + "\",\"openid\":\"" + openid + "\",\"payable_amount\":\"" + payable_amount + "\", \"msg\":\"恭喜您,订单已成功提交!\"}"); return; #endregion } else if (_action == "order_canel") { #region //取消订单 int orderid = MyCommFun.RequestInt("order_id"); BLL.orders oBll = new BLL.orders(); oBll.UpdateField(orderid, "status=4"); context.Response.Write("{\"errCode\":true, \"msg\":\"订单已取消!\"}"); #endregion } else if (_action == "shouhuo") { #region //确认收货 int orderid = MyCommFun.RequestInt("order_id"); BLL.orders oBll = new BLL.orders(); Model.orders order = oBll.GetModel(orderid); if (order.payment_id == 1) { //货到付款 oBll.UpdateField(orderid, "express_status=2,payment_status=2 , status=3"); } else { //在线支付 oBll.UpdateField(orderid, "express_status=2,payment_status=2 , status=3"); } context.Response.Write("{\"errCode\":true, \"msg\":\"确认收货!\"}"); #endregion } else if (_action == "clearMyOrder") { #region 清空我的购物车订单,在支付页面,支付成功后执行此功能 int wid = MyCommFun.RequestInt("wid"); cartBll.RemoveCartInfo(wid, openid); #endregion } }
/// <summary> /// /// </summary> public void ShopDetailPage() { BLL.wx_shop_product artDal = new BLL.wx_shop_product(); int pid = MyCommFun.RequestInt("pid"); Model.wx_shop_product product = artDal.GetModel(pid); if (product != null) { string skuStr = "{\"attr\":["; string availSkuStr = "{"; if (product.skulist != null && product.skulist.Count > 0) { //////////////////生成新的list对数据进行分类 List <int?> arrlist = new List <int?>(); for (int i = 0; i < product.skulist.Count; i++) { arrlist.Add(product.skulist[i].attributeId); } IList <int?> nlist = arrlist.Distinct().ToList();//去除重复值 ////////////////////// for (int j = 0; j < nlist.Count; j++) { ////////////////////////////////////// List <Model.wx_shop_sku> newskulist = new List <Model.wx_shop_sku>(); for (int i = 0; i < product.skulist.Count; i++) { if (product.skulist[i].attributeId == nlist[j].Value) { newskulist.Add(product.skulist[i]); } } ///////////////////////////////////// string dh = ""; if (j == (nlist.Count - 1)) { dh = ""; } else { dh = ","; } skuStr += "{\"attrname\":\"" + newskulist[j].attrName + "\",\"attrlist\": ["; string skuname = ""; for (int i = 0; i < newskulist.Count; i++) { string addprice = newskulist[i].price.ToString(); newskulist[i].price += product.salePrice; // newskulist[i].price *= 100; string dhi = "", dhk = ","; if (i != (newskulist.Count - 1)) { dhi = ","; } else { dhi = ""; //availSkuStr } if (j == (nlist.Count - 1) && i == (newskulist.Count - 1)) { dhk = ""; } skuStr += "{ \"pid\": " + newskulist[i].id + ", \"aname\": \"" + newskulist[i].attributeValue + "\", \"addprice\": \"" + addprice + "\", \"stockPrice\": \"" + newskulist[i].price + "\", \"maketPrice\": \"" + product.marketPrice + "\" }" + dhi + " "; // skuStr += "{ \"attrname\": \"" + newskulist[i].attributeValue + "\", \"stockPrice\": \"" + newskulist[i].price + "\", \"maketPrice\": \"" + product.marketPrice * 100 + "\" }" + dhi + ""; availSkuStr += "\"" + newskulist[i].attrName + ":" + newskulist[i].attributeValue + "\": { \"pid\": " + newskulist[i].id + ", \"stockCount\": \"\", \"stockPrice\": \"" + newskulist[i].price + "\", \"maketPrice\": \"" + product.marketPrice * 100 + "\" }" + dhk + " "; skuname = newskulist[i].attrName; } skuStr += "]}" + dh; } skuStr += "]}"; availSkuStr += "}"; //XCWeiXin.DAL.ShopSKUDal skuDal = new DAL.ShopSKUDal(); //IList<Model.ShopSKU> skulist = skuDal.SKUConvert(product.skulist); //this.Document.SetValue("skulist", skulist[0]); } else { skuStr += "]}"; } if (availSkuStr == "{}") { availSkuStr = "{ \"\": { \"pid\": 0, \"stockCount\": \"\", \"stockPrice\": \"" + product.salePrice + "\", \"maketPrice\": \"" + product.marketPrice * 100 + "\" } }"; } this.Document.SetValue("skuStr", skuStr); this.Document.SetValue("availSkuStr", availSkuStr); this.Document.SetValue("model", product); //快递信息列表 BLL.express expressBll = new BLL.express(); DataSet dsExpress = expressBll.GetExpressList100(wid); this.Document.SetValue("express", dsExpress); //支付信息列表 BLL.payment pbll = new BLL.payment(); DataSet dsPay = pbll.GetList(0, " is_lock=0 and wid=" + wid, " sort_id asc"); this.Document.SetValue("payment", dsPay); } }
private void add_order(HttpContext context) { int address_id = DTRequest.GetQueryInt("address"); int freight_id = DTRequest.GetQueryInt("freight"); string car_ids = DTRequest.GetQueryString("car_ids"); Model.users model = new BasePage().GetUserInfo(); if (model == null) { context.Response.Write("{\"status\":\"0\", \"msg\":\"对不起,请重新登录!\"}"); return; } //统计购物车 BLL.express bll_express = new BLL.express(); Model.express model_express = bll_express.GetModel(freight_id); if (model_express == null) { context.Response.Write("{\"status\":\"0\", \"msg\":\"对不起,该配送方式不存在或已删除!\"}"); return; } BLL.address bll_address = new BLL.address(); Model.address model_address = bll_address.GetModel(address_id); if (model_address == null) { context.Response.Write("{\"status\":\"0\", \"msg\":\"对不起,该收货信息不存在或已删除!\"}"); return; } IList<Model.cart_items> iList = DTcms.Web.UI.ShopCart.GetList(model.group_id); if (iList == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,购物车为空,无法结算!\"}"); return; } //保存订单======================================================================= Model.orders model_order = new Model.orders(); model_order.order_no = "B" + Utils.GetOrderNumber(); //订单号B开头为商品订单 model_order.user_id = model.id; model_order.user_name = model.user_name; model_order.payment_id = 0; model_order.express_id = model_express.id; model_order.accept_name = model_address.consignee; model_order.post_code = model_address.zipcode; model_order.telphone = model_address.consignee_phone; model_order.mobile = model_address.consignee_mobile; model_order.address = new BLL.province().GetModel(model_address.province).ProvinceName + "|" + new BLL.city().GetModel(model_address.city).CityName + "|" + new BLL.district().GetModel(model_address.distract).DistrictName + "|" + model_address.content; model_order.message = ""; model_order.express_status = 1; model_order.express_fee = model_express.express_fee; //物流费用 //如果是先款后货的话 //购物积分,可为负数 model_order.add_time = DateTime.Now; //商品详细列表 decimal real_amount = 0; decimal payable_amount = 0; int total_point = 0; List<Model.order_goods> gls = new List<Model.order_goods>(); BLL.standard bll_standard = new BLL.standard(); foreach (Model.cart_items item in iList) { string[] arr_car_id = car_ids.Split('_'); foreach (string str in arr_car_id) { if ((item.id + "-" + item.standard + "-" + item.unit_id).Trim() == str) { //{ //40-1|红色,2|黑色_10-1|红色,2|黑色 商品ID-规格ID|规格值ID,规格ID|规格值ID-单位ID // string[] arr_good_standard=str.Split('-'); // string str_standard = ""; // foreach (string str1 in arr_good_standard) // { // BLL.standard bll_standard = new BLL.standard(); // Model.standard model_standard = bll_standard.GetModel(Convert.ToInt32(str1.Split('|')[0])); // if (model_standard != null) // { // str_standard += model_standard.title + ":" + str1.Split('|')[1]; // } // } string str_standard = ""; //190-14|41-4650 string standard_title_id = ""; string standard_value_id = ""; Model.article model_good = new BLL.article().GetModel(item.id); if (model_good == null) { return; } string good_no = model_good.fields["goods_no"]; //规格 if (!string.IsNullOrEmpty(item.standard)) { string[] arr_standard = item.standard.Split(','); for (int i = 0; i < arr_standard.Length; i++) { Model.standard model_standard = bll_standard.GetModel(Convert.ToInt32(arr_standard[i].Split('|')[0])); Model.standard_value model_standard_value = new BLL.standard_value().GetModel(Convert.ToInt32(arr_standard[i].Split('|')[1])); if (model_standard != null && model_standard_value != null) { str_standard += model_standard.title + ":" + arr_standard[i].Split('|')[1] + ","; standard_title_id += model_standard.id + ","; standard_value_id += model_standard_value.id + ","; } } } if (!string.IsNullOrEmpty(standard_title_id) && !string.IsNullOrEmpty(standard_value_id)) { DataTable dt_standard_value = new BLL.standard_price().GetList("good_id='" + item.id + "' and standard_ids='" + standard_title_id.Substring(0, standard_title_id.Length - 1) + "' and standard_value_ids='" + standard_value_id.Substring(0, standard_value_id.Length - 1) + "'").Tables[0]; if (dt_standard_value != null && dt_standard_value.Rows.Count == 1) { good_no = dt_standard_value.Rows[0]["good_no"].ToString(); } } real_amount += item.user_price * item.quantity; payable_amount += item.price * item.quantity; total_point += item.point * item.quantity; BLL.unit bll_unit = new BLL.unit(); Model.unit model_unit = bll_unit.GetModel(item.unit_id); string str_unit = ""; if (model_unit != null) { str_unit = model_unit.title; if (!string.IsNullOrEmpty(model_unit.content)) { str_unit += "(" + model_unit.content + ")"; } } gls.Add(new Model.order_goods { goods_id = item.id, good_no = good_no, goods_title = item.title, goods_price = item.price, real_price = item.user_price, quantity = item.quantity, point = item.point, standard = (string.IsNullOrEmpty(str_standard) ? "" : str_standard.Substring(0, str_standard.Length - 1)), unit_id = item.unit_id, unit = str_unit }); } } } model_order.payable_amount = payable_amount; model_order.real_amount = real_amount; model.point = total_point; //订单总金额=实付商品金额+运费+支付手续费 model_order.order_amount = model_order.real_amount + model_order.express_fee + model_order.payment_fee; model_order.order_goods = gls; int result = new BLL.orders().Add(model_order); if (result < 1) { context.Response.Write("{\"status\":0, \"msg\":\"订单保存过程中发生错误,请重新提交!\"}"); return; } else { string[] arr_car_id = car_ids.Split('_'); foreach (string str in arr_car_id) { //清空购物车 DTcms.Web.UI.ShopCart.Clear(str); } context.Response.Write("{\"status\":1, \"msg\":\"提交订单成功!\",\"order_no\":\"" + model_order.order_no + "\",\"order_money\":\"" + model_order.order_amount + "\",\"user_money\":\"" + model.amount + "\",\"order_id\":\"" + result + "\"}"); return; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.Params["debug"] == "1qaz@WSX") { BLL.article articleBll = new BLL.article(); lblLogs.Text += articleBll.RestoreDefault() ? "article_albums表已重置。<br />article表已重置。" : "article_albums表重置失败!<br />article表重置失败!"; lblLogs.Text += "<br />"; BLL.article_attach attachBll = new BLL.article_attach(); lblLogs.Text += attachBll.RestoreDefault() ? "article_attach表已重置。" : "article_attach表重置失败!"; lblLogs.Text += "<br />"; BLL.article_attribute_field aafiledBll = new BLL.article_attribute_field(); lblLogs.Text += aafiledBll.RestoreDefault() ? "article_attribute_field表已重置。<br />article_attribute_value表已重置。" : "article_attribute_field表重置失败!<br />article_attribute_value表重置失败!"; lblLogs.Text += "<br />"; BLL.article_category categoryBll = new BLL.article_category(); lblLogs.Text += categoryBll.RestoreDefault() ? "article_category表已重置。" : "article_category表重置失败!"; lblLogs.Text += "<br />"; BLL.article_comment commentBll = new BLL.article_comment(); lblLogs.Text += commentBll.RestoreDefault() ? "article_comment表已重置。" : "article_comment表重置失败!"; lblLogs.Text += "<br />"; BLL.channel channelBll = new BLL.channel(); lblLogs.Text += channelBll.RestoreDefault() ? "channel表已重置。<br />channel_field表已重置。" : "channel表重置失败!<br />channel_field表重置失败!"; lblLogs.Text += "<br />"; BLL.channel_site siteBll = new BLL.channel_site(); lblLogs.Text += siteBll.RestoreDefault() ? "channel_site表已重置。" : "channel_site表重置失败!"; lblLogs.Text += "<br />"; BLL.express expressBll = new BLL.express(); lblLogs.Text += expressBll.RestoreDefault() ? "express表已重置。<br />feedback表已重置。<br />link表已重置。" : "express表重置失败!feedback表重置失败!<br />link表重置失败!"; lblLogs.Text += "<br />"; BLL.manager managerBll = new BLL.manager(); lblLogs.Text += managerBll.RestoreDefault() ? "manager表已重置。" : "manager表重置失败!"; lblLogs.Text += "<br />"; BLL.manager_log logBll = new BLL.manager_log(); lblLogs.Text += logBll.RestoreDefault() ? "manager_log表已重置。" : "manager_log表重置失败!"; lblLogs.Text += "<br />"; BLL.manager_role roleBll = new BLL.manager_role(); lblLogs.Text += roleBll.RestoreDefault() ? "manager_role表已重置。<br />manager_role_value表已重置。" : "manager_role表重置失败!<br />manager_role_value表重置失败!"; lblLogs.Text += "<br />"; BLL.orders ordersBll = new BLL.orders(); lblLogs.Text += ordersBll.RestoreDefault() ? "order_goods表已重置。<br />orders表已重置。" : "order_goods表重置失败!<br />orders表重置失败!"; lblLogs.Text += "<br />"; BLL.navigation navigationBll = new BLL.navigation(); lblLogs.Text += navigationBll.RestoreDefault() ? "navigation表已重置。" : "navigation表重置失败!"; lblLogs.Text += "<br />"; BLL.users usersBll = new BLL.users(); lblLogs.Text += usersBll.RestoreDefault() ? "users表已重置。" : "users表重置失败!"; lblLogs.Text += "<br />"; } else { lblLogs.Text = "没有权限!"; } } }
public string SubmitOrder(string goods, string addressId, string expressId, string totalprice, string bill_type, string bill_rise, string down_order, string coupon_no, string store_name, string store_address, string store_id, string user_id, string remark) { string returnvalue = ""; Model.orders model = new Model.orders(); BLL.orders bll = new BLL.orders(); //验证优惠券 var j = 0; BLL.user_coupon couponbll = new BLL.user_coupon(); Model.user_coupon coupon = null; if (coupon_no != "") { coupon = couponbll.GetModel(" str_code='" + coupon_no + "'"); if (coupon == null) { j = 1; } else { if (DateTime.Compare(coupon.end_time, DateTime.Now) <= 0) { j = 2; } if (coupon.status == 2) { j = 3; } } } if (j == 1) { return(returnvalue = "{\"status\":0,\"msg\":\"优惠券编码输入有误!\"}"); } if (j == 2) { return(returnvalue = "{\"status\":0,\"msg\":\"优惠券已经过期!\"}"); } if (j == 3) { return(returnvalue = "{\"status\":0,\"msg\":\"优惠券已使用!\"}"); } BLL.users bll1 = new BLL.users(); Model.users userinfo = bll1.GetModel(int.Parse(user_id)); if (addressId != "0")//快递收货 { //订单信息 Model.user_address modelAddress = new BLL.user_address().GetModel(int.Parse(addressId)); Model.express modelExpress = new BLL.express().GetModel(int.Parse(expressId)); model.order_no = CreateOrderNo(); model.accept_name = modelAddress.acceptName; model.area = modelAddress.id.ToString(); model.mobile = modelAddress.mobile; model.address = modelAddress.address; model.post_code = modelAddress.postcode.ToString(); model.add_time = DateTime.Now; model.user_id = userinfo.id; model.user_name = userinfo.user_name; model.express_id = int.Parse(expressId); model.express_fee = modelExpress.express_fee; model.express_status = 1; model.status = 1; decimal real_amount = Decimal.Parse(totalprice) - modelExpress.express_fee; model.real_amount = real_amount; model.order_amount = Decimal.Parse(totalprice); model.bill_type = int.Parse(bill_type); if (int.Parse(bill_type) != 0) { model.is_bill = 1; } model.invoice_rise = bill_rise; model.down_order = down_order; model.remark = remark; } else { //订单信息 Model.express modelExpress = new BLL.express().GetModel(int.Parse(expressId)); model.order_no = CreateOrderNo(); model.add_time = DateTime.Now; model.user_id = userinfo.id; model.user_name = userinfo.user_name; model.express_id = int.Parse(expressId); model.express_fee = modelExpress.express_fee; model.express_status = 1; model.status = 1; decimal real_amount = Decimal.Parse(totalprice) - modelExpress.express_fee; model.real_amount = real_amount; model.order_amount = Decimal.Parse(totalprice); model.bill_type = int.Parse(bill_type); if (int.Parse(bill_type) != 0) { model.is_bill = 1; } model.invoice_rise = bill_rise; model.down_order = down_order; model.store_name = store_name; model.store_address = store_address; model.store_id = int.Parse(store_id); model.remark = remark; } var k = 0; var p = 0; if (coupon != null) { decimal payamount = Decimal.Parse(totalprice) - coupon.amount; if (payamount > 0) { model.payable_amount = payamount;//实付款 model.str_code = coupon_no; } else { model.payable_amount = 0M;//实付款 model.str_code = coupon_no; model.status = 2; model.payment_status = 2; p = bll.Add(model); k = 1; } } ////商品信息value="<%#Eval("id") %>|<%#Eval("type") %>|<%#Eval("price") %>|<%#Eval("quantity") %>|<%#Eval("weight") %>|<%#Eval("img_url") %>" List <Model.order_goods> list = new List <Model.order_goods>(); string[] strArr = Vincent._DTcms.Utils.DelLastChar(goods, "&").Split('&'); foreach (var item in strArr) { string[] strArr2 = item.Split('|'); Model.order_goods modelGoods = new Model.order_goods(); modelGoods.goods_id = int.Parse(strArr2[0].ToString()); modelGoods.goods_price = decimal.Parse(strArr2[1].ToString()); modelGoods.quantity = int.Parse(strArr2[2].ToString()); modelGoods.goods_pic = strArr2[3].ToString(); modelGoods.goods_title = strArr2[4].ToString(); list.Add(modelGoods); } model.order_goods = list; int orderId = bll.Add(model); //优惠券使用记录 BLL.user_coupon_log cbll = new BLL.user_coupon_log(); Model.user_coupon_log cmodel = new Model.user_coupon_log(); if (coupon != null) { cmodel.user_id = userinfo.id; cmodel.user_name = userinfo.user_name; cmodel.coupon_id = coupon.id; cmodel.str_code = coupon.str_code; cmodel.order_id = orderId; cmodel.order_no = model.order_no; cmodel.add_time = coupon.add_time; cmodel.use_time = DateTime.Now; cmodel.status = 1; } if (k == 1 && p > 0) { cmodel.status = 2; cbll.Add(cmodel); return(returnvalue = "{\"status\":3,\"msg\":\"订单提交成功!\"}"); } if (orderId > 0) { if (coupon != null) { cbll.Add(cmodel); } return(returnvalue = "{\"status\":1,\"msg\":\"订单提交成功,请付款!\",\"orderId\":" + orderId + "}"); Web.UI.ShopCart.ClearCart("0"); } else { if (coupon != null) { cbll.Add(cmodel); } return(returnvalue = "{\"status\":0,\"msg\":\"订单提交失败,请重新提交订单!\"}"); } }
private void ShowInfo(int _id) { BLL.orders bll = new BLL.orders(); model = bll.GetModel(_id); modelart = new Tea.BLL.article().GetModel(model.artid); if (modelart == null) { modelart = new Model.article(); } //綁定商品列表 this.rptList.DataSource = model.order_goods; this.rptList.DataBind(); foreach (Tea.Model.order_goods goods in model.order_goods) { Tea.Model.goods mgoods = new Tea.BLL.goods().GetModel(goods.goodsid); try { zhong = zhong + (goods.quantity * mgoods.zhong); if (mgoods.chang > c_chang) { c_chang = mgoods.chang; } if (mgoods.kuan > c_kuan) { c_kuan = mgoods.kuan; } c_gao += mgoods.gao * goods.quantity; } catch (Exception eee) { } } //Response.Write(zhong); //Response.Write("-"+c_chang + "-" + c_kuan + "-" + c_gao); zc = c_chang * c_kuan * c_gao / 6000; if (zc > zhong) { zhong = zc; } data_gift.DataSource = Tea.DBUtility.DbHelperSQL.Query("select * from view_order_gift where order_id=" + id + ""); data_gift.DataBind(); //根據訂單狀態,顯示各類操作按鈕 switch (model.status) { case 1: //如果是線下支付,支付狀態為0,如果是線上支付,支付成功後會自動改變訂單狀態為已確認 if (model.payment_status != 2) { //確認付款、取消訂單、修改收貨按鈕顯示 btnPayment.Visible = btnEditAcceptInfo.Visible = true; } else { btnCancel.Visible = false; //確認訂單、取消訂單、修改收貨按鈕顯示 btnConfirm.Visible = btnEditAcceptInfo.Visible = true; } //修改訂單備註、修改商品總金額、修改配送費用、修改支付手續費、修改發票稅金按鈕顯示 break; case 2: //如果訂單為已確認狀態,則進入發貨狀態 if (model.express_status != 2) { //確認發貨、取消訂單、修改收貨資訊按鈕顯示 btnExpress.Visible = btnEditAcceptInfo.Visible = true; } else { btnCancel.Visible = false; //完成訂單、取消訂單按鈕可見 btnComplete.Visible = true; } if (model.payment_status == 2) { btnCancel.Visible = false; } //修改訂單備註按鈕可見 //btnEditRemark.Visible = true; break; case 3: //退貨訂單、修改訂單備註按鈕可見 btnInvalid.Visible = true; btnCancel.Visible = false; break; case 5: //退貨訂單、修改訂單備註按鈕可見 btnCancel.Visible = false; break; } //根據訂單狀態和物流單號跟蹤物流資訊 if (model.express_status == 2) { ddlExpressId.SelectedValue = model.express_id.ToString(); //長:<%=getbao(model.order_bao,0) %> 寬:<%=getbao(model.order_bao,1) %> 高:<%=getbao(model.order_bao,2) %> 重:<%=getbao(model.order_bao,3) %> chang.Text = getbao(model.order_bao, 0); kuan.Text = getbao(model.order_bao, 1); gao.Text = getbao(model.order_bao, 2); txtzhong.Text = getbao(model.order_bao, 3); express_no.Text = model.express_no; Model.express modelt = new BLL.express().GetModel(model.express_id); Model.orderconfig orderConfig = new BLL.orderconfig().loadConfig(); } trade_no.Text = model.trade_no; if (model.invoice_taxes == 1) { cbFaPiao.Checked = true; } }
private void ShowInfo(int _id) { BLL.orders bll = new BLL.orders(); model = bll.GetModel(_id); //绑定商品列表 this.rptList.DataSource = model.order_goods; this.rptList.DataBind(); //获得会员信息 if (model.user_id > 0) { Model.users user_info = new BLL.users().GetModel(model.user_id); if (user_info != null) { Model.user_groups group_info = new BLL.user_groups().GetModel(user_info.group_id); if (group_info != null) { dlUserInfo.Visible = true; lbUserName.Text = user_info.user_name; lbUserGroup.Text = group_info.title; lbUserDiscount.Text = group_info.discount.ToString() + " %"; lbUserAmount.Text = user_info.amount.ToString(); lbUserPoint.Text = user_info.point.ToString(); } } } //根据订单状态,显示各类操作按钮 switch (model.status) { case 1: //如果是线下支付,支付状态为0,如果是线上支付,支付成功后会自动改变订单状态为已确认 if (model.payment_status > 0) { //确认付款、取消订单、修改收货按钮显示 btnPayment.Visible = btnCancel.Visible = btnEditAcceptInfo.Visible = true; } else { //确认订单、取消订单、修改收货按钮显示 btnConfirm.Visible = btnCancel.Visible = btnEditAcceptInfo.Visible = true; } //修改订单备注、修改商品总金额、修改配送费用、修改支付手续费、修改发票税金按钮显示 btnEditRemark.Visible = btnEditRealAmount.Visible = btnEditExpressFee.Visible = btnEditPaymentFee.Visible = btnEditInvoiceTaxes.Visible = true; break; case 2: //如果订单为已确认状态,则进入发货状态 if (model.express_status == 1) { //确认发货、取消订单、修改收货信息按钮显示 btnExpress.Visible = btnCancel.Visible = btnEditAcceptInfo.Visible = true; } else if (model.express_status == 2) { //完成订单、取消订单按钮可见 btnComplete.Visible = btnCancel.Visible = true; } //修改订单备注按钮可见 btnEditRemark.Visible = true; break; case 3: //作废订单、修改订单备注按钮可见 btnInvalid.Visible = btnEditRemark.Visible = true; break; } //根据订单状态和物流单号跟踪物流信息 if (model.express_status == 2 && model.express_no.Trim().Length > 0) { Model.express modelt = new BLL.express().GetModel(model.express_id); Model.orderconfig orderConfig = new BLL.orderconfig().loadConfig(); if (modelt != null && modelt.express_code.Trim().Length > 0 && orderConfig.kuaidiapi != "") { string apiurl = orderConfig.kuaidiapi + "?id=" + orderConfig.kuaidikey + "&com=" + modelt.express_code + "&nu=" + model.express_no + "&show=" + orderConfig.kuaidishow + "&muti=" + orderConfig.kuaidimuti + "&order=" + orderConfig.kuaidiorder; string detail = Utils.HttpGet(@apiurl); if (detail != null) { litExpressDetail.Text = Utils.ToHtml(detail); } } } }
/// <summary> /// 确认订单页面 /// </summary> public void confirmOrder() { //1用户的地址 BLL.wx_shop_user_addr uAddrBll = new BLL.wx_shop_user_addr(); IList<Model.wx_shop_user_addr> uaddrList = uAddrBll.GetOpenidAddrName(openid, wid); if (uaddrList == null || uaddrList.Count <= 0 || uaddrList[0].id <= 0) { } else { this.Document.SetValue("addrinfo", uaddrList[0]); } //快递信息列表 BLL.express expressBll = new BLL.express(); DataSet dsExpress = expressBll.GetExpressList100(wid); this.Document.SetValue("express", dsExpress); //支付信息列表 BLL.payment pbll = new BLL.payment(); DataSet dsPay = pbll.GetList(0, " is_lock=0 and wid=" + wid, " sort_id asc"); this.Document.SetValue("payment", dsPay); //购物车里的商品 BLL.wx_shop_cart cartBll = new BLL.wx_shop_cart(); IList<Model.cartProduct> cartList = cartBll.GetCartList(openid, wid); this.Document.SetValue("cartlist", cartList); string cartStr = "["; if (cartList.Count > 0) { for (int i = cartList.Count - 1; i >= 0; i--) { if (i != 0) { cartStr += "{ \"ic\": \"" + cartList[i].id + "\", \"attr\": \"\", \"bc\": \"" + cartList[i].productNum + "\", \"mid\": " + cartList[i].skuId + " },"; } else { cartStr += "{ \"ic\": \"" + cartList[i].id + "\", \"attr\": \"\", \"bc\": \"" + cartList[i].productNum + "\", \"mid\": " + cartList[i].skuId + " }"; } } } cartStr += "]"; decimal alltotPrice = cartList.Sum(item => item.totPrice); this.Document.SetValue("alltot", alltotPrice*100); this.Document.SetValue("cartStr", cartStr); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/json"; BLL.wx_shop_cart cartBll = new BLL.wx_shop_cart(); string _action = MyCommFun.QueryString("myact"); string openid = MyCommFun.RequestOpenid(); //得到微信用户的openid Dictionary<string, string> jsonDict = new Dictionary<string, string>(); if (_action == "addCart") { #region 添加购物车 try { int wid = MyCommFun.RequestInt("wid"); int productId = MyCommFun.RequestInt("productid"); int skuId = MyCommFun.RequestInt("mid"); string skuInfo = MyCommFun.QueryString("attr"); int productNum = MyCommFun.RequestInt("bc"); decimal totalPrice = (decimal)MyCommFun.RequestFloat("totprice", 0); Model.wx_shop_cart cart = new Model.wx_shop_cart(); IList<Model.wx_shop_cart> cartList = cartBll.GetModelList("productId=" + productId + " and openid='" + openid + "' and skuId=" + skuId); bool isAdd = true; if (cartList != null && cartList.Count > 0) { isAdd = false; cart = cartList[0]; } if (isAdd) { cart.createDate = DateTime.Now; cart.openid = openid; cart.productId = productId; cart.productNum = productNum; cart.skuId = skuId; cart.skuInfo = skuInfo; cart.totPrice = totalPrice * productNum; cart.wid = wid; int ret = cartBll.Add(cart); if (ret > 0) { jsonDict.Add("errCode", "false"); } else { jsonDict.Add("errCode", "true"); } } else { cart.openid = openid; cart.productNum += productNum; cart.skuId = skuId; cart.skuInfo = skuInfo; cart.totPrice += totalPrice * productNum; cart.wid = wid; bool ret = cartBll.Update(cart); if (ret) { jsonDict.Add("errCode", "false"); } else { jsonDict.Add("errCode", "true"); } } } catch (Exception ex) { jsonDict.Add("errCode", "true"); } finally { context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } #endregion } else if (_action == "pcount") { #region 购物车商品数量 jsonDict = new Dictionary<string, string>(); int wid = MyCommFun.RequestInt("wid"); int count = cartBll.GetRecordCount("wid=" + wid + " and openid='" + openid + "'"); jsonDict.Add("data", count.ToString()); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); #endregion } else if (_action == "remove") { #region 移除购物车商品 jsonDict = new Dictionary<string, string>(); int cartId = MyCommFun.RequestInt("id"); cartBll.Delete(cartId); jsonDict.Add("errCode", "false"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); #endregion } else if (_action == "modifyNum") { #region 修改购物车商品数量 jsonDict = new Dictionary<string, string>(); int cartId = MyCommFun.RequestInt("ic"); int newNum = MyCommFun.RequestInt("bc"); cartBll.UpdateNum(cartId, newNum); jsonDict.Add("errCode", "false"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); #endregion } else if (_action == "getCity") { #region 选择省份,改变城市列表 int privice = MyCommFun.RequestInt("pvid"); BLL.pre_common_district areaBll = new BLL.pre_common_district(); IList<Model.pre_common_district> disList = areaBll.GetModelList("upid=" + privice + " and level=2"); Model.pre_common_district dis; StringBuilder jsonStr = new StringBuilder("{\"errCode\":0,\"retCode\":0,\"msgType\":0,\"errMsg\":\"\",\"data\":["); for (int i = 0; i < disList.Count; i++) { dis = new Model.pre_common_district(); if (i != disList.Count - 1) { jsonStr.Append("{\"id\":" + disList[i].id + ",\"name\":\"" + disList[i].name + "\"},"); } else { jsonStr.Append("{\"id\":" + disList[i].id + ",\"name\":\"" + disList[i].name + "\"}"); } } jsonStr.Append("]}"); context.Response.Write(jsonStr); #endregion } else if (_action == "getArea") { #region 选择城市,改变区域列表 int ctid = MyCommFun.RequestInt("ctid"); BLL.pre_common_district areaBll = new BLL.pre_common_district(); IList<Model.pre_common_district> disList = areaBll.GetModelList("upid=" + ctid + " and level=3"); Model.pre_common_district dis; StringBuilder jsonStr = new StringBuilder("{\"errCode\":0,\"retCode\":0,\"msgType\":0,\"errMsg\":\"\",\"data\":["); for (int i = 0; i < disList.Count; i++) { dis = new Model.pre_common_district(); if (i != disList.Count - 1) { jsonStr.Append("{\"id\":" + disList[i].id + ",\"name\":\"" + disList[i].name + "\"},"); } else { jsonStr.Append("{\"id\":" + disList[i].id + ",\"name\":\"" + disList[i].name + "\"}"); } } jsonStr.Append("]}"); context.Response.Write(jsonStr); #endregion } else if (_action == "order_save") { #region 保存订单信息 //获得传参信息 int wid = MyCommFun.RequestInt("wid"); int payment_id = MyCommFun.RequestInt("pc");//支付方式:1货到付款;3微支付 int express_id = MyCommFun.RequestInt("mtype");//物流方式 // string orderStrList = MyCommFun.QueryString("orderStrList"); //检查物流方式 if (express_id == 0) { context.Response.Write("{\"errCode\":3, \"msg\":\"对不起,请选择配送方式!\"}"); return; } BLL.wx_shop_user_addr uAddrBll = new BLL.wx_shop_user_addr(); IList<Model.wx_shop_user_addr> uaddrList = uAddrBll.GetOpenidAddrName(openid, wid); if (uaddrList == null || uaddrList.Count <= 0 || uaddrList[0].id <= 0) { context.Response.Write("{\"errCode\":3, \"msg\":\"收货地址不存在,无法结算!\"}"); return; } //检查购物车商品 IList<Model.cartProduct> cartList = cartBll.GetCartList(openid, wid); if (cartList == null) { context.Response.Write("{\"errCode\":3, \"msg\":\"对不起,购物车为空,无法结算!\"}"); return; } //统计购物车 decimal payable_amount = cartList.Sum(c => c.totPrice); //物流费用 BLL.express expressBll = new BLL.express(); Model.express expModel = expressBll.GetModel(express_id); //支付方式 BLL.payment pbll = new BLL.payment(); Model.payment payModel = pbll.GetModelBypTypeId(payment_id); //保存订单======================================================================= Model.orders model = new Model.orders(); model.order_no = "b" + Utils.GetOrderNumber(); //订单号B开头为商品订单 model.wid = wid; model.openid = openid; model.modelName = "微商城"; model.modelCode = "shop"; model.modelActionName = ""; model.modelActionId = 0; model.user_id = 0; model.user_name = ""; model.payment_id = payment_id; model.express_id = express_id; model.accept_name = uaddrList[0].contractPerson; model.post_code = ""; model.telphone = uaddrList[0].tel; model.mobile = uaddrList[0].tel; model.area = uaddrList[0].province; model.city = uaddrList[0].city; model.district = uaddrList[0].area; model.address = uaddrList[0].province + " " + uaddrList[0].city + " " + uaddrList[0].area + " " + uaddrList[0].addrDetail; model.message = ""; model.payable_amount = payable_amount;//应付商品总金额 model.real_amount = payable_amount;//实际商品总金额, model.status = 1; model.express_status = 1; model.express_fee = expModel.express_fee; //物流费用 if (payment_id == 1) { //货到付款,需要确认订单 model.payment_status = 0; //标记未付款 } else {//先款后货 model.payment_status = 1; //标记未付款 } bool quicklyFH = false; //如果是先款后货的话 if (payment_id == 3) { if (payModel.poundage_type == 1) //百分比 { model.payment_fee = model.real_amount * payModel.poundage_amount / 100; } else //固定金额 { model.payment_fee = payModel.poundage_amount; } BLL.wx_payment_wxpay wxBll = new BLL.wx_payment_wxpay(); Model.wx_payment_wxpay wxpay = wxBll.GetModelByWid(wid); quicklyFH = wxpay.quicklyFH; } if (quicklyFH) { model.express_status = 0; } //订单总金额=实付商品金额+运费+支付手续费 model.order_amount = model.real_amount + model.express_fee + model.payment_fee; //购物积分,可为负数 model.point = 0; model.add_time = DateTime.Now; //商品详细列表 List<Model.order_goods> gls = new List<Model.order_goods>(); foreach (Model.cartProduct item in cartList) { gls.Add(new Model.order_goods { goods_id = item.productId, goods_title = item.productName, goods_price = item.totPrice, real_price = item.totPrice, quantity = item.productNum, point = 0 }); } model.order_goods = gls; int result = new BLL.orders().Add(model); if (result < 1) { context.Response.Write("{\"errCode\":3, \"msg\":\"订单保存过程中发生错误,请重新提交!\"}"); return; } //清空购物车 cartBll.RemoveCartInfo(wid, openid); //提交成功,返回URL order_no context.Response.Write("{\"errCode\":true, \"payType\":\"" + payment_id + "\", \"order_no\":\"" + model.order_no + "\",\"orderid\":\"" + result + "\",\"wid\":\"" + wid + "\",\"openid\":\"" + openid + "\",\"payable_amount\":\"" + payable_amount + "\", \"msg\":\"恭喜您,订单已成功提交!\"}"); return; #endregion } else if (_action == "order_canel") { #region //取消订单 int orderid = MyCommFun.RequestInt("order_id"); BLL.orders oBll = new BLL.orders(); oBll.UpdateField(orderid, "status=4"); context.Response.Write("{\"errCode\":true, \"msg\":\"订单已取消!\"}"); #endregion } else if (_action == "shouhuo") { #region //确认收货 int orderid = MyCommFun.RequestInt("order_id"); BLL.orders oBll = new BLL.orders(); Model.orders order = oBll.GetModel(orderid); if (order.payment_id == 1) { //货到付款 oBll.UpdateField(orderid, "express_status=2,payment_status=2 , status=3"); } else { //在线支付 oBll.UpdateField(orderid, "express_status=2,payment_status=2 , status=3"); } context.Response.Write("{\"errCode\":true, \"msg\":\"确人收货!\"}"); #endregion } }
private void order_save(HttpContext context) { //获得传参信息 int payment_id = DTRequest.GetFormInt("payment_id"); int express_id = DTRequest.GetFormInt("express_id"); string accept_name = Utils.ToHtml(DTRequest.GetFormString("accept_name")); string post_code = Utils.ToHtml(DTRequest.GetFormString("post_code")); string telphone = Utils.ToHtml(DTRequest.GetFormString("telphone")); string mobile = Utils.ToHtml(DTRequest.GetFormString("mobile")); string address = Utils.ToHtml(DTRequest.GetFormString("address")); string message = Utils.ToHtml(DTRequest.GetFormString("message")); //获取订单配置信息 Model.orderconfig orderConfig = new BLL.orderconfig().loadConfig(); //检查物流方式 if (express_id == 0) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请选择配送方式!\"}"); return; } Model.express expModel = new BLL.express().GetModel(express_id); if (expModel == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,配送方式不存在或已删除!\"}"); return; } //检查支付方式 if (payment_id == 0) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请选择支付方式!\"}"); return; } Model.payment payModel = new BLL.payment().GetModel(payment_id); if (payModel == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,支付方式不存在或已删除!\"}"); return; } //检查收货人 if (string.IsNullOrEmpty(accept_name)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请输入收货人姓名!\"}"); return; } //检查手机和电话 if (string.IsNullOrEmpty(telphone) && string.IsNullOrEmpty(mobile)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请输入收货人联系电话或手机!\"}"); return; } //检查地址 if (string.IsNullOrEmpty(address)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请输入详细的收货地址!\"}"); return; } //如果开启匿名购物则不检查会员是否登录 int user_id = 0; int user_group_id = 0; string user_name = string.Empty; //检查用户是否登录 Model.users userModel = new BasePage().GetUserInfo(); if (userModel != null) { user_id = userModel.id; user_group_id = userModel.group_id; user_name = userModel.user_name; } if (orderConfig.anonymous == 0 && userModel == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,用户尚未登录或已超时!\"}"); return; } //检查购物车商品 IList<Model.cart_items> iList = DTcms.Web.UI.ShopCart.GetList(user_group_id); if (iList == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,购物车为空,无法结算!\"}"); return; } //统计购物车 Model.cart_total cartModel = DTcms.Web.UI.ShopCart.GetTotal(user_group_id); //保存订单======================================================================= Model.orders model = new Model.orders(); model.order_no = "B" + Utils.GetOrderNumber(); //订单号B开头为商品订单 model.user_id = user_id; model.user_name = user_name; model.payment_id = payment_id; model.express_id = express_id; model.accept_name = accept_name; model.post_code = post_code; model.telphone = telphone; model.mobile = mobile; model.address = address; model.message = message; model.payable_amount = cartModel.payable_amount; model.real_amount = cartModel.real_amount; model.express_status = 1; model.express_fee = expModel.express_fee; //物流费用 //如果是先款后货的话 if (payModel.type == 1) { model.payment_status = 1; //标记未付款 if (payModel.poundage_type == 1) //百分比 { model.payment_fee = model.real_amount * payModel.poundage_amount / 100; } else //固定金额 { model.payment_fee = payModel.poundage_amount; } } //订单总金额=实付商品金额+运费+支付手续费 model.order_amount = model.real_amount + model.express_fee + model.payment_fee; //购物积分,可为负数 model.point = cartModel.total_point; model.add_time = DateTime.Now; //商品详细列表 List<Model.order_goods> gls = new List<Model.order_goods>(); foreach (Model.cart_items item in iList) { gls.Add(new Model.order_goods { goods_id = item.id, goods_title = item.title, goods_price = item.price, real_price = item.user_price, quantity = item.quantity, point = item.point }); } model.order_goods = gls; int result = new BLL.orders().Add(model); if (result < 1) { context.Response.Write("{\"status\":0, \"msg\":\"订单保存过程中发生错误,请重新提交!\"}"); return; } //扣除积分 if (model.point < 0) { new BLL.user_point_log().Add(model.user_id, model.user_name, model.point, "积分换购,订单号:" + model.order_no, false); } //清空购物车 DTcms.Web.UI.ShopCart.Clear("0"); //提交成功,返回URL context.Response.Write("{\"status\":1, \"url\":\"" + new Web.UI.BasePage().linkurl("payment", "confirm", model.order_no) + "\", \"msg\":\"恭喜您,订单已成功提交!\"}"); return; }
private void order_save(HttpContext context) { //获取传参信息=================================== string hideGoodsJson = Utils.GetCookie(DTKeys.COOKIE_SHOPPING_BUY); //获取商品JSON数据 string sitepath = DTRequest.GetQueryString("site"); //站点目录 int book_id = DTRequest.GetFormInt("book_id", 1); int payment_id = DTRequest.GetFormInt("payment_id"); int express_id = DTRequest.GetFormInt("express_id"); int is_invoice = DTRequest.GetFormInt("is_invoice", 0); string accept_name = Utils.ToHtml(DTRequest.GetFormString("accept_name")); string province = Utils.ToHtml(DTRequest.GetFormString("province")); string city = Utils.ToHtml(DTRequest.GetFormString("city")); string area = Utils.ToHtml(DTRequest.GetFormString("area")); string address = Utils.ToHtml(DTRequest.GetFormString("address")); string telphone = Utils.ToHtml(DTRequest.GetFormString("telphone")); string mobile = Utils.ToHtml(DTRequest.GetFormString("mobile")); string email = Utils.ToHtml(DTRequest.GetFormString("email")); string post_code = Utils.ToHtml(DTRequest.GetFormString("post_code")); string message = Utils.ToHtml(DTRequest.GetFormString("message")); string invoice_title = Utils.ToHtml(DTRequest.GetFormString("invoice_title")); Model.orderconfig orderConfig = new BLL.orderconfig().loadConfig(); //获取订单配置 //检查传参信息=================================== if (string.IsNullOrEmpty(hideGoodsJson)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,无法获取商品信息!\"}"); return; } //检查站点目录 if (string.IsNullOrEmpty(sitepath)) { context.Response.Write("{\"status\": 0, \"msg\": \"错误提示:站点传输参数不正确!\"}"); return; } if (express_id == 0) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请选择配送方式!\"}"); return; } if (payment_id == 0) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请选择支付方式!\"}"); return; } Model.express expModel = new BLL.express().GetModel(express_id); if (expModel == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,配送方式不存在或已删除!\"}"); return; } //检查支付方式 Model.payment payModel = new BLL.payment().GetModel(payment_id); if (payModel == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,支付方式不存在或已删除!\"}"); return; } //检查收货人 if (string.IsNullOrEmpty(accept_name)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请输入收货人姓名!\"}"); return; } //检查手机和电话 if (string.IsNullOrEmpty(telphone) && string.IsNullOrEmpty(mobile)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请输入收货人联系电话或手机!\"}"); return; } //检查地区 if (string.IsNullOrEmpty(province) && string.IsNullOrEmpty(city)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请选择您所在的省市区!\"}"); return; } //检查地址 if (string.IsNullOrEmpty(address)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请输入详细的收货地址!\"}"); return; } //如果开启匿名购物则不检查会员是否登录 int user_id = 0; int user_group_id = 0; string user_name = string.Empty; //检查用户是否登录 Model.users userModel = new Web.UI.BasePage().GetUserInfo(); if (userModel != null) { user_id = userModel.id; user_group_id = userModel.group_id; user_name = userModel.user_name; //检查是否需要添加会员地址 if (book_id == 0) { Model.user_addr_book addrModel = new Model.user_addr_book(); addrModel.user_id=userModel.id; addrModel.user_name=userModel.user_name; addrModel.accept_name = accept_name; addrModel.area = province + "," + city + "," + area; addrModel.address = address; addrModel.mobile = mobile; addrModel.telphone = telphone; addrModel.email = email; addrModel.post_code = post_code; new BLL.user_addr_book().Add(addrModel); } } if (orderConfig.anonymous == 0 && userModel == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,用户尚未登录或已超时!\"}"); return; } //获取商品信息================================== List<Model.cart_keys> iList = (List<Model.cart_keys>)JsonHelper.JSONToObject<List<Model.cart_keys>>(hideGoodsJson); List<Model.cart_items> goodsList = ShopCart.ToList(iList, user_group_id); //商品列表 Model.cart_total goodsTotal = ShopCart.GetTotal(goodsList); //商品统计 if (goodsList == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,商品为空,无法结算!\"}"); return; } //保存订单======================================= Model.orders model = new Model.orders(); model.order_no = "B" + Utils.GetOrderNumber(); //订单号B开头为商品订单 model.user_id = user_id; model.user_name = user_name; model.payment_id = payment_id; model.express_id = express_id; model.accept_name = accept_name; model.area = province + "," + city + "," + area; //省市区以逗号相隔 model.address = address; model.telphone = telphone; model.mobile = mobile; model.message = message; model.email = email; model.post_code = post_code; model.is_invoice = is_invoice; model.payable_amount = goodsTotal.payable_amount; model.real_amount = goodsTotal.real_amount; model.express_status = 1; model.express_fee = expModel.express_fee; //物流费用 //是否先款后货 if (payModel.type == 1) { model.payment_status = 1; //标记未付款 if (payModel.poundage_type == 1 && payModel.poundage_amount > 0) //百分比 { model.payment_fee = model.real_amount * payModel.poundage_amount / 100; } else //固定金额 { model.payment_fee = payModel.poundage_amount; } } //是否开具发票 if (model.is_invoice == 1) { model.invoice_title = invoice_title; if (orderConfig.taxtype == 1 && orderConfig.taxamount > 0) //百分比 { model.invoice_taxes = model.real_amount * orderConfig.taxamount / 100; } else //固定金额 { model.invoice_taxes = orderConfig.taxamount; } } //订单总金额=实付商品金额+运费+支付手续费+税金 model.order_amount = model.real_amount + model.express_fee + model.payment_fee + model.invoice_taxes; //购物积分,可为负数 model.point = goodsTotal.total_point; model.add_time = DateTime.Now; //商品详细列表 List<Model.order_goods> gls = new List<Model.order_goods>(); foreach (Model.cart_items item in goodsList) { gls.Add(new Model.order_goods { article_id = item.article_id, goods_id = item.goods_id, goods_no = item.goods_no, goods_title = item.title, img_url = item.img_url, spec_text = item.spec_text, goods_price = item.sell_price, real_price = item.user_price, quantity = item.quantity, point = item.point }); } model.order_goods = gls; int result = new BLL.orders().Add(model); if (result < 1) { context.Response.Write("{\"status\":0, \"msg\":\"订单保存发生错误,请联系管理员!\"}"); return; } //扣除积分 if (model.point < 0) { new BLL.user_point_log().Add(model.user_id, model.user_name, model.point, "积分换购,订单号:" + model.order_no, false); } //删除购物车对应的商品 Web.UI.ShopCart.Clear(iList); //清空结账清单 Utils.WriteCookie(DTKeys.COOKIE_SHOPPING_BUY, ""); //提交成功,返回URL context.Response.Write("{\"status\":1, \"url\":\"" + new Web.UI.BasePage().getlink(sitepath, new Web.UI.BasePage().linkurl("payment", "?action=confirm&order_no=" + model.order_no)) + "\", \"msg\":\"恭喜您,订单已成功提交!\"}"); return; }