public string Execute(Hashtable params_ht)
{
Hashtable res = params_ht;
if (res["UID"] == null || res["UID"].ToString().Trim().Length <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "参数不完整"));
}
else
{
uid = res["UID"].ToString().Trim();
DepositReturnManager depositManager = new DepositReturnManager();
string state = depositManager.GetDepositState(uid);
if (string.IsNullOrEmpty(state))
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "没有数据"));
}
else
{
Hashtable result = new Hashtable();
result["State"] = state;
return(SiteHelper.GetJsonFromHashTable(result, "success", "获取数据成功", "data"));
}
}
}
/// <summary>
/// 绑定数据源
/// </summary>
private void DataBindGrid()
{
DepositReturnManager depositManager = new DepositReturnManager();
int count = 0;
KeyValuePair <StringBuilder, IList <SqlParam> > keyValue = InitCondition();
DataTable dt = depositManager.GetPage(keyValue.Key, keyValue.Value, PageControl1.PageIndex, PageControl1.PageSize, ref count);
ControlBindHelper.BindRepeaterList(dt, rp_Item);
this.PageControl1.RecordCount = Convert.ToInt32(count);
this.PageControl1.PageChecking();
}
public string Execute(Hashtable params_ht)
{
Hashtable res = params_ht;
if (res["UID"] == null || res["UID"].ToString().Trim().Length <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "参数不完整"));
}
else
{
uid = res["UID"].ToString().Trim();
SysSettingManager settingManager = new SysSettingManager();
UserInfoManager uim = new UserInfoManager();
Hashtable user = uim.GetUserInfoByUserID(uid);
if (user == null || user.Keys.Count <= 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "您不是有效会员"));
}
OrdersManager om = new OrdersManager();
Hashtable unpaid_ht = om.GetUnPaidOrderByUser(uid);
if (unpaid_ht != null && unpaid_ht.Keys.Count > 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "存在未支付订单,申请押金退款失败"));
}
Hashtable uservehicle_ht = om.GetUserCurrentOrderVehicle(uid);
if (uservehicle_ht != null && uservehicle_ht.Keys.Count > 0)
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "存在进行中的订单,申请押金退款失败"));
}
DepositReturnManager depositManager = new DepositReturnManager();
bool result = depositManager.ApplyReturnDeposit(uid);
if (result)
{
string returnDepositMode = settingManager.GetValueByKey("ReturnDepositMode");
//押金退还模式，1即时退，0后台退
if (returnDepositMode == "1")
{
Hashtable apply_ht = depositManager.GetAppyInfoByUid(uid);
Refund(apply_ht["ID"].ToString());
}
return(SiteHelper.GetJsonFromHashTable(null, "success", "成功申请押金退款", "data"));
}
else
{
return(SiteHelper.GetJsonFromHashTable(null, "faild", "申请押金退款失败"));
}
}
}
/// <summary>
/// 秒退款操作
/// </summary>
/// <param name="applyid"></param>
/// <returns></returns>
private bool Refund(string applyid)
{
try
{
bool result = false;
DepositReturnManager depositManager = new DepositReturnManager();
Hashtable ht = depositManager.GetDataByID(applyid);
string state = SiteHelper.GetHashTableValueByKey(ht, "State");
string depositMoney = SiteHelper.GetHashTableValueByKey(ht, "DepositMoney");
string depositPayWay = SiteHelper.GetHashTableValueByKey(ht, "DepositPayWay");
string depositTradeNo = SiteHelper.GetHashTableValueByKey(ht, "DepositTradeNo");
decimal refundMoney = 0.00m;
refundMoney = decimal.Parse(depositMoney);
string errmsg = "";
string code = "";
if (depositPayWay == "1")
{
//查询支付结果 支付宝退款
AlipayRefund alipay = new AlipayRefund();
result = alipay.Refund2(depositTradeNo, refundMoney, out errmsg, out code);
}
else if (depositPayWay == "2")
{
//微信退款
WxRefund wxpay = new WxRefund();
result = wxpay.refund2(depositTradeNo, refundMoney, out errmsg);
}
else if (depositPayWay == "5")
{
//微信公众号退款
api.weapp.pay.wxpay.WxRefund wxpay = new api.weapp.pay.wxpay.WxRefund();
result = wxpay.refund2(depositTradeNo, refundMoney, out errmsg);
}
if (result)
{
result = depositManager.HandleReturnDeposit(applyid, "2", "", "系统");
}
return(result);
}
catch
{
return(false);
}
}
protected void lbtExport_Click(object sender, EventArgs e)
{
DepositReturnManager depositManager = new DepositReturnManager();
int count = 0;
KeyValuePair <StringBuilder, IList <SqlParam> > keyValue = InitCondition();
DataTable dt = depositManager.GetPage(keyValue.Key, keyValue.Value, PageControl1.PageIndex, 1000000000, ref count);
StringBuilder s = new StringBuilder();
s.AppendLine("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">");
s.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
//写出列名
s.AppendLine("<tr style=\"background-color: #FFE88C;font-weight: bold; white-space: nowrap;\">");
s.AppendLine("<td>用户姓名/td><td>手机号</td><td>押金金额</td><td>押金支付方式</td><td>押金支付交易号</td><td>申请状态</td><td>创建时间</td>");
s.AppendLine("</tr>");
//写数据
foreach (DataRow row in dt.Rows)
{
s.Append("<tr>");
s.Append("<td>").Append(row["RealName"].ToString()).Append("</td>");
s.Append("<td>").Append(row["BindPhone"].ToString()).Append("</td>");
s.Append("<td>").Append(row["DepositMoney"].ToString()).Append("</td>");
s.Append("<td>").Append(EnumHelper.GetEnumShowName(typeof(UserFinancialOperatorWay), Convert.ToInt32(row["DepositPayWay"].ToString()))).Append("</td>");
s.Append("<td>'").Append(row["DepositTradeNo"].ToString()).Append("</td>");
s.Append("<td>").Append(GetStateTxt(row["State"].ToString())).Append("</td>");
s.Append("<td>").Append(row["CreateTime"].ToString()).Append("</td>");
s.AppendLine("</tr>");
}
s.AppendLine("</table>");
this.Page.Response.ContentType = "application/vnd.ms-excel";
this.Page.Response.ContentEncoding = System.Text.Encoding.UTF8;
this.Page.Response.Charset = "Utf-8";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=押金退款列表" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
this.Page.Response.Write(s.ToString());
this.Page.Response.End();
}
