public ActionResult PayTc()
{
JMP.BLL.jmp_userbank ubkBll = new JMP.BLL.jmp_userbank();
List <JMP.MDL.jmp_userbank> ubklist = new List <JMP.MDL.jmp_userbank>();
int id = UserInfo.UserId;
int pageCount = 0;
int pageIndexs = string.IsNullOrEmpty(Request["pageIndexs"]) ? 1 : Int32.Parse(Request["pageIndexs"]); //当前页
int PageSize = string.IsNullOrEmpty(Request["PageSize"]) ? 10 : Int32.Parse(Request["PageSize"]); //每页显示数量
//搜索条件
string searchType = string.IsNullOrEmpty(Request["searchType"]) ? "0" : Request["searchType"];
//搜索信息
string banknumber = string.IsNullOrEmpty(Request["banknumber"]) ? "" : Request["banknumber"];
//付款标识
string flag = string.IsNullOrEmpty(Request["flag"]) ? "" : Request["flag"];
//查询开发者绑定的银行卡信息(审核通过并未被冻结的)
ubklist = ubkBll.SelectUserBankListStart(id, searchType, banknumber, flag, pageIndexs, PageSize, out pageCount);
ViewBag.ubklist = ubklist;
ViewBag.pageIndexs = pageIndexs;
ViewBag.PageSize = PageSize;
ViewBag.pageCount = pageCount;
ViewBag.searchType = searchType;
ViewBag.banknumber = banknumber;
ViewBag.flag = flag;
return(View());
}
public ActionResult AppUserBankAuditing(int id)
{
int userid = string.IsNullOrEmpty(Request["id"]) ? 0 : int.Parse(Request["id"]);
JMP.BLL.jmp_userbank bll = new JMP.BLL.jmp_userbank();
JMP.MDL.jmp_userbank model = bll.GetModel(userid);
//审核状态
ViewBag.start = model.u_state;
ViewBag.reaks = model.u_remarks;
ViewBag.userid = userid;
return(View());
}
public JsonResult DoAll(string uids, int tag)
{
JMP.BLL.jmp_userbank userBll = new JMP.BLL.jmp_userbank();
bool flag = userBll.UpdateState(uids, tag);
//写日志
if (flag)
{
string info = "批量更新开发者的银行账号ID（" + uids + "）的状态为" + (tag == 1 ? "正常。" : "冻结。");
Logger.OperateLog("批量更新开发者状态", info);
}
return(Json(new { success = flag ? 1 : 0, msg = flag ? "更新成功！" : "更新失败！" }));
}
public JsonResult CheckAuditing()
{
int id = string.IsNullOrEmpty(Request["userid"]) ? 0 : int.Parse(Request["userid"]);
int u_auditstate = string.IsNullOrEmpty(Request["u_auditstate"]) ? 0 : int.Parse(Request["u_auditstate"]);
string u_remarks = string.IsNullOrEmpty(Request["u_remarks"]) ? "" : Request["u_remarks"];
string name = UserInfo.UserName;
JMP.BLL.jmp_userbank bll = new JMP.BLL.jmp_userbank();
bool flag = bll.UpdateAuditState(id, u_auditstate, name, u_remarks);
if (flag)
{
string info = "审核开发者（" + id + "）绑定的银行卡信息状态为" + u_auditstate + "";
Logger.OperateLog("审核开发者绑定的银行卡信息状态", info);
}
return(Json(new { success = flag ? 1 : 0, msg = flag ? "审核成功！" : "审核失败！" }));
}
public ActionResult pays_single()
{
JMP.MDL.CoSettlementDeveloperOverview comodeT1 = new JMP.MDL.CoSettlementDeveloperOverview();
JMP.MDL.CoSettlementDeveloperOverview comodeT2 = new JMP.MDL.CoSettlementDeveloperOverview();
//开发者选中的账单ID
string payid = string.IsNullOrEmpty(Request["payid"]) ? "" : Request["payid"];
ViewBag.payid = payid;
string sqlstr = string.Format(@";WITH O AS(
select * from CoSettlementDeveloperOverview where id in({0}) and DeveloperId={1}
),bll as(
select p_bill_id,isnull(SUM(p_money),0) as p_money from dx_base.dbo.jmp_pays a, dx_base.dbo.jmp_BankPlaymoney b
where a.p_batchnumber=b.b_batchnumber and a.p_state!=-1 and b.b_tradestate!=4 and p_bill_id in({0}) and p_userid={1}
group by p_bill_id
)
select
(isnull(SUM(TotalAmount),0)-isnull(SUM(ServiceFee),0)-isnull(SUM(PortFee),0)-isnull(SUM(bll.p_money),0)) as ketiMoney
from O
left join bll on bll.p_bill_id=O.Id", payid, UserInfo.UserId);
//查询选中数据
DataTable dt = bll_CoSDO.SelectSum(sqlstr);
comodeT1 = dt.Rows.Count > 0 ? JMP.TOOL.MdlList.ToModel <JMP.MDL.CoSettlementDeveloperOverview>(dt) : new JMP.MDL.CoSettlementDeveloperOverview();
ViewBag.comodeT1 = comodeT1;
//开发者账单总金额与冻结金额
string sqlstrSum = string.Format(@";
WITH O AS(
select * from dx_total.dbo.CoSettlementDeveloperOverview where DeveloperId={0}
),bll as(
select p_bill_id,isnull(SUM(p_money),0) as p_money from dx_base.dbo.jmp_pays a, dx_base.dbo.jmp_BankPlaymoney b
where a.p_batchnumber=b.b_batchnumber and a.p_state!=-1 and b.b_tradestate!=4 and p_userid={0}
group by p_bill_id
),users as
(
select u_id,ISNULL(FrozenMoney,0) as FrozenMoney from dx_base.dbo.jmp_user where u_id={0}
),kt as
(
select DeveloperId,
(isnull(SUM(TotalAmount),0)-isnull(SUM(ServiceFee),0)-isnull(SUM(PortFee),0)-isnull(SUM(bll.p_money),0)) as ketiMoney
from O
left join bll on bll.p_bill_id=O.Id group by DeveloperId
)
select FrozenMoney,ketiMoney from users inner join kt on users.u_id=kt.DeveloperId", UserInfo.UserId);
DataTable dt2 = bll_CoSDO.SelectSum(sqlstrSum);
comodeT2 = dt2.Rows.Count > 0 ? JMP.TOOL.MdlList.ToModel <JMP.MDL.CoSettlementDeveloperOverview>(dt2) : new JMP.MDL.CoSettlementDeveloperOverview();
ViewBag.comodeT2 = comodeT2;
JMP.BLL.jmp_userbank ubkBll = new JMP.BLL.jmp_userbank();
List <JMP.MDL.jmp_userbank> ubklist = new List <JMP.MDL.jmp_userbank>();
//查询开发者绑定的银行卡信息(审核通过并未被冻结的)
ubklist = ubkBll.GetModelList("u_userid=" + UserInfo.UserId + " and u_state=1 and u_freeze=0");
ViewBag.ubklist = ubklist;
return(View());
}
public ActionResult Index()
{
//获取请求参数
int pageCount = 0;
int pageIndexs = string.IsNullOrEmpty(Request["curr"]) ? 1 : Int32.Parse(Request["curr"]); //当前页
int PageSize = string.IsNullOrEmpty(Request["psize"]) ? 20 : Int32.Parse(Request["psize"]); //每页显示数量
string type = string.IsNullOrEmpty(Request["stype"]) ? "0" : Request["stype"]; //查询条件类型
string sea_name = string.IsNullOrEmpty(Request["skeys"]) ? "" : Request["skeys"].Trim(); //查询条件值
string u_state = string.IsNullOrEmpty(Request["scheck"]) ? "" : Request["scheck"]; //银行卡审核状态
string u_freeze = string.IsNullOrEmpty(Request["state"]) ? "" : Request["state"]; //银行卡状态
int px = string.IsNullOrEmpty(Request["s_sort"]) ? 1 : Int32.Parse(Request["s_sort"]); //排序
//获取用户列表
string where = "where 1=1";
if (!string.IsNullOrEmpty(type.ToString()))
{
if (!string.IsNullOrEmpty(sea_name))
{
if (type == "0")
{
where += string.Format(" and b.u_email ='{0}'", sea_name);
}
else if (type == "1")
{
where += string.Format(" and a.u_name ='{0}'", sea_name);
}
else if (type == "3")
{
where += string.Format(" and a.u_banknumber ='{0}'", sea_name);
}
else if (type == "4")
{
where += string.Format(" and (a.u_bankname like '%{0}%')", sea_name);
}
else if (type == "5")
{
where += string.Format(" and (a.u_openbankname like '%{0}%')", sea_name);
}
}
}
if (!string.IsNullOrEmpty(u_state))
{
where += string.Format(" and a.u_state={0}", u_state);
}
if (!string.IsNullOrEmpty(u_freeze))
{
where += string.Format(" and a.u_freeze={0}", u_freeze);
}
string Order = " order by u_id " + (px == 0 ? "" : " desc ") + " ";
JMP.BLL.jmp_userbank bll = new JMP.BLL.jmp_userbank();
string query = "select a.*,b.u_email,b.u_realname from jmp_userbank a left join jmp_user b on a.u_userid=b.u_id " + where;
var list = bll.GetAppuserbankLists(query, Order, pageIndexs, PageSize, out pageCount);
//返回
ViewBag.CurrPage = pageIndexs;
ViewBag.PageSize = PageSize;
ViewBag.PageCount = pageCount;
ViewBag.stype = type;
ViewBag.skeys = sea_name;
ViewBag.state = u_freeze;
ViewBag.scheck = u_state;
ViewBag.s_sort = px;
ViewBag.list = list;
ViewBag.btnstr = GetVoidHtml();
return(View());
}