protected string[] GetCount(string strWhere) { string[] arrCount = new string[2]; decimal inMoney = 0; decimal outMoney = 0; ShowShop.BLL.Member.UserinAndExp bll = new ShowShop.BLL.Member.UserinAndExp(); ChangeHope.DataBase.DataByPage dataPage = bll.GetList(strWhere); if (dataPage.DataReader != null) { while (dataPage.DataReader.Read()) { if (dataPage.DataReader["incomeandexpstate"].ToString() == "0") { inMoney += Convert.ToDecimal(dataPage.DataReader["adsummoney"]); } else { outMoney += Convert.ToDecimal(dataPage.DataReader["adsummoney"]); } } } arrCount[0] = inMoney.ToString(); arrCount[1] = outMoney.ToString(); return arrCount; }
protected void ExpBind() { int id = ChangeHope.WebPage.PageRequest.GetQueryInt("id"); ShowShop.BLL.Member.UserinAndExp bll = new ShowShop.BLL.Member.UserinAndExp(); ShowShop.Model.Member.UserinAndExp model = bll.GetModelByID(id); this.lblAdsumMoneyDate.Text = model.AdsumMoneyDate.ToString(); this.lblUserID.Text = model.UserId; this.lblUserName.Text = GetUserName(Convert.ToInt32(model.UID)); this.lblRemitMode.Text = GetRemitMode(model.RemitMode.ToString()); if (model.InComeandExpState.ToString() == "0") { this.lblAdsumMoneyIn.Text = model.AdsumMoney.ToString(); this.lblAdsumMoneyOut.Text = "0"; } else { this.lblAdsumMoneyIn.Text = "0"; this.lblAdsumMoneyOut.Text = model.AdsumMoney.ToString(); } this.lblRemitBank.Text = model.RemitBank; this.lblState.Text = model.State == 0 ? "确认" : "未确认"; this.lblNoteName.Text = model.NoteName; this.lblNoteDate.Text = model.NoteDate.ToString(); this.lblRemitBank.Text = model.Remark; this.lblBosomNote.Text = model.BosomNote; }
/// <summary> /// 列表 /// </summary> /// <returns></returns> protected string GetList(string strWhere) { ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table(); ShowShop.BLL.Member.UserinAndExp bll = new ShowShop.BLL.Member.UserinAndExp(); ChangeHope.DataBase.DataByPage dataPage = bll.GetList(strWhere); //第一步先添加表头 table.AddHeadCol("", "序号"); table.AddHeadCol("", "到款时间"); table.AddHeadCol("", "会员账号"); table.AddHeadCol("", "交易方式"); table.AddHeadCol("", "收入金额"); table.AddHeadCol("", "支出金额"); table.AddHeadCol("", "银行名称"); table.AddHeadCol("", "备注/说明"); table.AddHeadCol("", "是否确认"); table.AddHeadCol("", "操作"); table.AddRow(); //添加表的内容 if (dataPage.DataReader != null) { int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex"); if (curpage < 0) { curpage = 1; } int count = 0; while (dataPage.DataReader.Read()) { count++; string No = (15 * (curpage - 1) + count).ToString(); string option = string.Empty; if (dataPage.DataReader["state"].ToString() == "0") { option = string.Format("<a href=userinandexp_view_single.aspx?id={0}>查看</a>", dataPage.DataReader["id"].ToString()); } else { option = string.Format("<a href=userinandexp_view_single.aspx?id={0}>查看</a> <a href='javascript:void(0)' onclick='Del({0})'>删除</a> <a href='javascript:void(0)' onclick='SetState({0})'>确认</a>", dataPage.DataReader["id"].ToString()); } table.AddCol(No); table.AddCol(Convert.ToDateTime(dataPage.DataReader["adsummoneydate"].ToString()).ToShortDateString()); table.AddCol(dataPage.DataReader["userid"].ToString()); table.AddCol(GetRemitMode(dataPage.DataReader["remitmode"].ToString())); table.AddCol(dataPage.DataReader["incomeandexpstate"].ToString() == "0" ? dataPage.DataReader["adsummoney"].ToString() : string.Empty); table.AddCol(dataPage.DataReader["incomeandexpstate"].ToString() == "1" ? dataPage.DataReader["adsummoney"].ToString() : string.Empty); table.AddCol(dataPage.DataReader["remitbank"].ToString()); table.AddCol(dataPage.DataReader["remark"].ToString()); table.AddCol(dataPage.DataReader["state"].ToString() == "0" ? "确认" : "未确认"); table.AddCol(option); table.AddRow(); } } string view = table.GetTable() + dataPage.PageToolBar; dataPage.Dispose(); dataPage = null; return view; }
/// <summary> /// 银行资金明细 /// </summary> /// <param name="id"></param> /// <returns></returns> public string GetCapitalList(int id) { ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table(); ShowShop.BLL.Member.UserinAndExp expBll = new ShowShop.BLL.Member.UserinAndExp(); ChangeHope.DataBase.DataByPage dataPage = expBll.GetList(" uid="+id+" "); table.AddHeadCol("","交易时间"); table.AddHeadCol("","交易方式"); table.AddHeadCol("","收入资金"); table.AddHeadCol("","支出资金"); table.AddHeadCol("","银行名称"); table.AddHeadCol("","备注/原因"); table.AddHeadCol("","状态"); table.AddRow(); if (dataPage.DataReader != null) { while (dataPage.DataReader.Read()) { table.AddCol(dataPage.DataReader["notedate"].ToString()); table.AddCol(GetOutType(Convert.ToInt32(dataPage.DataReader["remitmode"]))); table.AddCol(dataPage.DataReader["incomeandexpstate"].ToString() == "0" ? dataPage.DataReader["adsummoney"].ToString() : ""); table.AddCol(dataPage.DataReader["incomeandexpstate"].ToString() == "1" ? dataPage.DataReader["adsummoney"].ToString() : ""); table.AddCol(dataPage.DataReader["remitbank"].ToString()); table.AddCol(dataPage.DataReader["remark"].ToString()); table.AddCol(dataPage.DataReader["state"].ToString() == "0" ? "确认" : "未确认"); table.AddRow(); } string view = table.GetTable() + dataPage.PageToolBar; dataPage.Dispose(); dataPage = null; return view; } else { return "没有找到相关信息"; } }
protected void lbtnSave_Click(object sender, EventArgs e) { /*修改人:YM *修改时间:2009-12-17 *判断订单是否是会员订单及用户是否存在 */ if (this.lblUserName.Text.Trim() == "") { this.ltlMsg.Text = "操作失败!您所支付的订单可能是非会员生成的订单."; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } ShowShop.Model.Admin.AdminInfo adminInfo = (ShowShop.Model.Admin.AdminInfo)ShowShop.Common.AdministrorManager.Get(); ShowShop.BLL.Member.MemberAccount memberBll = new ShowShop.BLL.Member.MemberAccount(); ShowShop.Model.Member.MemberAccount memberModel = memberBll.GetModel(this.lblUserName.Text); if (memberModel == null) { this.ltlMsg.Text = "操作失败!该会员不存在."; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } #region 订单预付款资金 ShowShop.Model.Order.PrepayMoney preModel = new ShowShop.Model.Order.PrepayMoney(); ShowShop.BLL.Order.PrepayMoney preBll = new ShowShop.BLL.Order.PrepayMoney(); preModel.OrderId = this.lblOrderId.Text; preModel.UserName = this.lblUserName.Text; preModel.PayoutMoney = Convert.ToDecimal(this.txtPayoutMoney.Text.Trim()); preModel.Remark = this.txtRemark.Text; preModel.BosomNote = this.txtBosomNote.Text; preModel.NoteDate = DateTime.Now; preModel.NoteName = adminInfo.AdminName; #endregion #region 用户交易明细 ShowShop.Model.Member.UserinAndExp userModel = new ShowShop.Model.Member.UserinAndExp(); ShowShop.BLL.Member.UserinAndExp userBll = new ShowShop.BLL.Member.UserinAndExp(); //资金的明细 userModel.UID = memberModel.UID; userModel.AdsumMoneyDate = Convert.ToDateTime(this.txtAdsumMoneyDate.Text); userModel.AdsumMoney = Convert.ToDecimal(this.txtPayoutMoney.Text); userModel.PresentCoupons = 0; userModel.RemitMode = 2; userModel.RemitBank = string.Empty; userModel.Remark = this.txtRemark.Text; userModel.FormMode = string.Empty; //通知方式 userModel.BosomNote = this.txtBosomNote.Text; userModel.NoteDate = DateTime.Now; userModel.NoteName = adminInfo.AdminName; userModel.InComeandExpState = 1; userModel.State = 0; userModel.UserId = this.lblUserName.Text; #endregion #region 订单状态 ShowShop.BLL.Order.Orders orderBll = new ShowShop.BLL.Order.Orders(); ShowShop.Model.Order.Orders orderModel = orderBll.GetModel(this.lblOrderId.Text); #endregion ShowShop.BLL.Member.MemberAccount mabll = new ShowShop.BLL.Member.MemberAccount(); ShowShop.Model.Member.MemberAccount mamodel = mabll.GetModel(this.lblUserName.Text); try { //已付款+此次汇款的总和 decimal payTotail = Convert.ToDecimal(this.GetPayed(this.lblOrderId.Text)) + Convert.ToDecimal(this.txtPayoutMoney.Text.Trim()); #region 如果有多余的钱 if (payTotail > Convert.ToDecimal(orderModel.FactPrice)) { ChangeHope.WebPage.BasePage.PageError("输入的金额大于了订单总额!", "order_bank_pay.aspx?OrderId=" + orderModel.Id); return; } #endregion #region 查询用户金额 操作用户金额 if (mamodel != null) { decimal Price = decimal.Parse(mamodel.Capital.ToString()); if (Convert.ToDecimal(this.txtPayoutMoney.Text) > Price) { ChangeHope.WebPage.BasePage.PageError("用户余额不足!", "order_bank_pay.aspx?OrderId=" + orderModel.Id); return; } mabll.Amend(mamodel.UID, "Capital", (Convert.ToDecimal(mamodel.Capital.ToString()) - Convert.ToDecimal(this.txtPayoutMoney.Text))); } #endregion preBll.Add(preModel); userBll.Add(userModel); #region 操作付款状态 订单状态 int OrderId = ChangeHope.WebPage.PageRequest.GetQueryInt("OrderId"); if (payTotail >= Convert.ToDecimal(orderModel.FactPrice)) { if (OrderId > 0) { orderBll.Amend(OrderId, "OrderStatus", ShowShop.Common.OrdersStatusEnum.OrderStatu.未结清.GetHashCode()); orderBll.Amend(OrderId, "PaymentStatus", ShowShop.Common.OrdersStatusEnum.PaymentStatu.已经付清.GetHashCode()); orderBll.Amend(OrderId, "OgisticsStatus", ShowShop.Common.OrdersStatusEnum.OgisticsStatus.配送中.GetHashCode()); } } else { if (OrderId > 0) { orderBll.Amend(OrderId, "OrderStatus", ShowShop.Common.OrdersStatusEnum.OrderStatu.未结清.GetHashCode()); orderBll.Amend(OrderId, "PaymentStatus", ShowShop.Common.OrdersStatusEnum.PaymentStatu.未付清.GetHashCode()); } } #endregion ChangeHope.WebPage.BasePage.PageRight("已保存该信息", "order_bank_pay.aspx?OrderId=" + orderModel.Id); } catch { this.ltlMsg.Text = "操作失败!"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; } finally { adminInfo = null; preModel = null; preBll = null; orderBll = null; orderModel = null; GC.Collect(); } }
protected void lbtnSave_Click(object sender, EventArgs e) { ShowShop.Model.Admin.AdminInfo adminInfo = (ShowShop.Model.Admin.AdminInfo)ShowShop.Common.AdministrorManager.Get(); if (Convert.ToDecimal(this.txtRefundmentMoney.Text.Trim()) + Convert.ToDecimal(this.txtPoundAge.Text.Trim()) > Convert.ToDecimal(GetPayed(this.lblOrderId.Text))) { this.ltlMsg.Text = "退款的金额不能大于已付的金额!"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } //银行支付 ShowShop.BLL.Order.RemittanceInfo remBll = new ShowShop.BLL.Order.RemittanceInfo(); ShowShop.Model.Order.RemittanceInfo remModel = remBll.GetModelByOrderId(this.lblOrderId.Text); //现金支付 ShowShop.BLL.Order.PaymentMoney payBll = new ShowShop.BLL.Order.PaymentMoney(); ShowShop.Model.Order.PaymentMoney payModel = payBll.GetModelByOrderId(this.lblOrderId.Text); //预付款 ShowShop.BLL.Order.PrepayMoney preBll = new ShowShop.BLL.Order.PrepayMoney(); ShowShop.Model.Order.PrepayMoney preModel = preBll.GetModelByOrderId(this.lblOrderId.Text); //订单信息 ShowShop.BLL.Order.Orders orderBll = new ShowShop.BLL.Order.Orders(); ShowShop.Model.Order.Orders orderModel = orderBll.GetModel(this.lblOrderId.Text); #region 退款信息 ShowShop.BLL.Order.RefundMent refBll = new ShowShop.BLL.Order.RefundMent(); ShowShop.Model.Order.RefundMent refModel = new ShowShop.Model.Order.RefundMent(); refModel.OrderId = this.lblOrderId.Text; refModel.UserName = this.lblUserId.Text; refModel.PaymentDate = Convert.ToDateTime(this.txtPaymentDate.Text); refModel.PoundAge = Convert.ToDecimal(this.txtPoundAge.Text.Trim()); refModel.RefundMentMoney = Convert.ToDecimal(this.txtRefundmentMoney.Text.Trim()); refModel.RefundMentMode = this.rabRefundmentMode.SelectedItem.Text; refModel.Remark = this.txtRemark.Text; refModel.InformMode = GetInforMode(cbxInformMode)["txt"]; //通知方式 refModel.NoteDate = DateTime.Now; refModel.NoteName = adminInfo.AdminName; #endregion #region 用户交易明细 ShowShop.Model.Member.UserinAndExp userModel = new ShowShop.Model.Member.UserinAndExp(); ShowShop.BLL.Member.UserinAndExp userBll = new ShowShop.BLL.Member.UserinAndExp(); //银行资金的明细 userModel.UID = this.GetUidByUserId(this.lblUserId.Text); userModel.AdsumMoneyDate = Convert.ToDateTime(this.txtPaymentDate.Text); userModel.AdsumMoney = Convert.ToDecimal(this.txtRefundmentMoney.Text); userModel.PresentCoupons = 0; userModel.RemitMode = 1; userModel.RemitBank = string.Empty; userModel.Remark = this.txtRemark.Text; userModel.FormMode = GetInforMode(cbxInformMode)["txt"]; //通知方式 userModel.BosomNote = this.txtBosomNote.Text; userModel.NoteDate = DateTime.Now; userModel.NoteName = adminInfo.AdminName; userModel.InComeandExpState = 0; userModel.State = 0; userModel.UserId = this.lblUserId.Text; #endregion try { if (refModel.RefundMentMoney == orderModel.FactPrice)//如果退款和订单价 匹配 { remBll.Delete(remModel.ID.ToString()); payBll.Delete(payModel.ID.ToString()); preBll.Delete(preModel.ID.ToString()); } else { if (remModel.RemittanceMoney > 0) //银行汇款 { if (remModel.RemittanceMoney <= refModel.RefundMentMoney) { remBll.Delete(remModel.ID.ToString()); } else { remModel.RemittanceMoney = remModel.RemittanceMoney - refModel.RefundMentMoney; remBll.Amend(remModel); } } if (preModel.PayoutMoney > 0) //预付款 { if (preModel.PayoutMoney <= refModel.RefundMentMoney) { preBll.Delete(preModel.ID.ToString()); } else { preModel.PayoutMoney = (preModel.PayoutMoney + remModel.RemittanceMoney) - refModel.RefundMentMoney; preBll.Amend(preModel); } } if (payModel.GatheringMoney > 0) //现金支付 { if (payModel.GatheringMoney == (refModel.RefundMentMoney - remModel.RemittanceMoney - preModel.PayoutMoney)) { payBll.Delete(payModel.ID.ToString()); } else { payModel.GatheringMoney = (remModel.RemittanceMoney + preModel.PayoutMoney + payModel.GatheringMoney) - refModel.RefundMentMoney; payBll.Amend(payModel); } } } refBll.Add(refModel); //退款信息 userBll.Add(userModel); //明细记录 //已付款 decimal payTotail = Convert.ToDecimal(this.GetPayed(this.lblOrderId.Text)); if ((payTotail - (Convert.ToDecimal(this.txtRefundmentMoney.Text.Trim()))) < 0) { orderModel.PaymentStatus = ShowShop.Common.OrdersStatusEnum.PaymentStatu.等待汇款.GetHashCode(); } else { orderModel.PaymentStatus = ShowShop.Common.OrdersStatusEnum.PaymentStatu.已收定金.GetHashCode(); } orderModel.OrderStatus = ShowShop.Common.OrdersStatusEnum.OrderStatu.已经确认.GetHashCode(); orderBll.Update(orderModel); ChangeHope.WebPage.BasePage.PageRight("已保存该信息.", "order_bank_pay.aspx?OrderId=" + orderModel.Id, "<li><a href='order_order_info.aspx?OrderId=" + orderModel.Id.ToString() + "'>返回信息页</a></li>"); } catch { this.ltlMsg.Text = "操作失败!"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; } finally { adminInfo = null; remModel = null; remBll = null; userModel = null; userBll = null; payBll = null; payModel = null; preBll = null; preModel = null; orderBll = null; orderModel = null; GC.Collect(); } }
private void SetState(int id,string message) { if (message != "ok") { ShowShop.BLL.Member.UserinAndExp bll = new ShowShop.BLL.Member.UserinAndExp(); bll.Amend(id, "state", 0); Response.Write("ok"); } else { Response.Write("no"); } }
/// <summary> /// 删除 /// </summary> /// <param name="id"></param> private void Del(string id, string message) { if (message != "ok") { ShowShop.BLL.Member.UserinAndExp bll = new ShowShop.BLL.Member.UserinAndExp(); bll.Delete(id); Response.Write("ok"); } else { Response.Write("no"); } }
private void SetState(int id) { ShowShop.BLL.Member.UserinAndExp bll = new ShowShop.BLL.Member.UserinAndExp(); bll.Amend(id, "state", 0); Response.Write("ok"); }
/// <summary> /// 删除 /// </summary> /// <param name="id"></param> private void Del(string id) { ShowShop.BLL.Member.UserinAndExp bll = new ShowShop.BLL.Member.UserinAndExp(); bll.Delete(id); }