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