private string getCondPlayerScore(ParamMemberInfo p, GMUser user)
{
string cond;
if (p.isSearchAll()) // 搜索所有的
{
string createCode = "";
if (string.IsNullOrEmpty(p.m_creator))
{
createCode = ItemHelp.getCreateCodeSpecial(user);
}
else
{
createCode = ItemHelp.getCreateCode(p.m_creator, user);
}
cond = string.Format(" opSrcCreateCode like '{0}%' ", createCode);
}
else // 直接下级
{
if (string.IsNullOrEmpty(p.m_creator))
{
cond = string.Format(" opSrc='{0}' ", getAccountSpecial(user));
}
else
{
cond = string.Format(" opSrc='{0}' and opSrcCreateCode like '{1}%' ", p.m_creator,
ItemHelp.getCreateCodeSpecial(user));
}
}
return(cond);
}
protected void Page_Load(object sender, EventArgs e)
{
RightMgr.getInstance().opCheck("", Session, Response);
string acc = Request.QueryString["acc"];
if (string.IsNullOrEmpty(acc))
{
Server.Transfer(DefCC.ASPX_EMPTY);
}
GMUser user = (GMUser)Session["user"];
m_isAdmin.Text = user.m_accType.ToString();
ParamMemberInfo param = new ParamMemberInfo();
param.m_creator = acc;
param.m_searchDepth = 1;
m_view = new ViewPlayerScoreInfo(IsRefreshed);
OpRes res = user.doQuery(param, QueryType.queryTypePlayerMember);
m_view.genTable(m_result, res, user);
m_levelStr.InnerHtml = user.getOpLevelMgr().getCurLevelStr(acc);
}
public OpRes genSearchSql(ParamMemberInfo param, GMUser user, ref string sqlCMD)
{
bool timeCanIgnore = timeCanEmpty();
if (!timeCanIgnore) // 时间条件是必须的
{
if (string.IsNullOrEmpty(param.m_time))
{
return(OpRes.op_res_time_format_error);
}
}
DateTime mint = DateTime.Now, maxt = mint;
bool useTime = false;
if (!string.IsNullOrEmpty(param.m_time))
{
useTime = Tool.splitTimeStr(param.m_time, ref mint, ref maxt);
if (!useTime)
{
return(OpRes.op_res_time_format_error);
}
}
sqlCMD = genSearchSqlCmd(param, mint, maxt, useTime, user);
return(OpRes.opres_success);
}
protected void onSearchSpecialAcc()
{
GMUser user = (GMUser)Session["user"];
ParamMemberInfo param = new ParamMemberInfo();
param.m_searchDepth = 1;
param.m_acc = m_acc.Text;
int sel = Convert.ToInt32(m_type.SelectedValue);
switch (sel)
{
case AccType.ACC_AGENCY:
{
OpRes res = user.doQuery(param, QueryType.queryTypeGmAccount);
m_view.genTable(m_result, res, user, new EventHandler(onScoreOp), param);
}
break;
case AccType.ACC_PLAYER:
{
ViewPlayerScoreInfo view = new ViewPlayerScoreInfo(IsRefreshed);
OpRes res = user.doQuery(param, QueryType.queryTypePlayerMember);
view.genTable(m_result, res, user);
}
break;
}
Label L = (Label)m_result.FindControl("Label" + param.m_acc);
if (L != null)
{
L.Text = "";
}
}
private OpRes statDirectlyPlayer(MemberInfo minfo, string time, GMUser user)
{
string cmd = "";
ParamMemberInfo p = new ParamMemberInfo();
p.m_acc = minfo.m_acc;
p.m_time = time;
OpRes res = m_generator.genSearchSql(p, user, ref cmd);
if (res != OpRes.opres_success)
{
return(res);
}
Dictionary <string, object> data
= user.sqlDb.queryOne(cmd, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
StatResultWinLoseItem sitem = m_result.addItem(data, minfo.m_acc, AccType.ACC_PLAYER);
if (sitem != null)
{
sitem.m_agentRatio = minfo.m_agentRatio;
sitem.m_washRatio = minfo.m_washRatio;
}
return(OpRes.opres_success);
}
protected void Page_Load(object sender, EventArgs e)
{
RightMgr.getInstance().opCheck("", Session, Response);
string acc = "";
if (!IsPostBack)
{
if (m_gen.parse(Request))
{
acc = m_gen.m_creator;
}
else
{
acc = Request.QueryString["acc"];
if (string.IsNullOrEmpty(acc))
{
return;
}
m_gen.m_creator = acc;
}
}
GMUser user = (GMUser)Session["user"];
ParamMemberInfo param = new ParamMemberInfo();
param.m_creator = acc;
param.m_searchDepth = 1;
param.m_curPage = m_gen.curPage;
param.m_countEachPage = m_gen.rowEachPage;
OpRes res = user.doQuery(param, QueryType.queryTypePlayerMember);
m_view.genTable(m_result, res, user, this, param);
m_levelStr.InnerHtml = user.getOpLevelMgr().getCurLevelStr(acc);
}
// 生成查询具体账号的条件
protected virtual string genAccSearchCond(GMUser user, ParamMemberInfo p)
{
string cond = "";
if (isSearchGM())
{
if (p.m_acc == user.m_user ||
user.m_accType == AccType.ACC_SUPER_ADMIN) // 是自己
{
cond = string.Format(" acc='{0}' ", p.m_acc);
}
else
{
cond = string.Format(" acc='{0}' and createCode like '{1}%' ", p.m_acc, ItemHelp.getCreateCodeSpecial(user));
}
}
else if (isSearchPlayer())
{
cond = string.Format(" acc='{0}' and createCode like '{1}%' ", p.m_acc, ItemHelp.getCreateCodeSpecial(user));
}
else
{
cond = string.Format(" opDst='{0}' and opSrcCreateCode like '{1}%' ", p.m_acc, ItemHelp.getCreateCodeSpecial(user));
}
return(cond);
}
private OpRes statOnePlayer(GMUser user, ParamWinLose param)
{
string cmd = "";
ParamMemberInfo p = new ParamMemberInfo();
p.m_acc = param.m_playerAcc;
p.m_time = param.m_time;
p.setPlayerWinLoseList();
OpRes res = m_generator.genSearchSql(p, user, ref cmd);
if (res != OpRes.opres_success)
{
return(res);
}
List <Dictionary <string, object> > dataList
= user.sqlDb.queryList(cmd, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
if (dataList != null)
{
foreach (var data in dataList)
{
m_result.addItem(data, p.m_acc, AccType.ACC_PLAYER);
}
}
// StatResultWinLoseItem sitem = m_result.addItem(data, p.m_acc, AccType.ACC_PLAYER);
// if (sitem != null)
// {
// sitem.m_agentRatio = minfo.m_agentRatio;
// sitem.m_washRatio = minfo.m_washRatio;
// }
return(OpRes.opres_success);
}
public void fillCondtion(ParamMemberInfo param, GMUser user)
{
param.m_acc = m_acc.Text;
param.m_time = __gmAccountCascadeStaticTime.Text;
param.m_searchDepth = Convert.ToInt32(m_way.SelectedValue);
param.m_creator = m_creator.Text;
}
private OpRes statBySeller(string creator, string time, GMUser user)
{
string cond = "";
ParamMemberInfo p = new ParamMemberInfo();
p.m_creator = creator;
p.m_time = time;
p.m_searchDepth = 0;
OpRes res = m_generator.genSearchSql(p, user, ref cond);
if (res != OpRes.opres_success)
{
return(res);
}
string cmd = "";
// 售货亭对下级管理员的存款及提款
cmd = string.Format(SqlStrCMD.SQL_STAT_STEP,
//TableName.PLAYER_SCORE,
cond);
List <Dictionary <string, object> > dataList
= user.sqlDb.queryList(cmd, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
doStatTypeDay(dataList, creator, time);
return(OpRes.opres_success);
}
protected void Page_Load(object sender, EventArgs e)
{
RightMgr.getInstance().opCheck("", Session, Response);
string acc = Request.QueryString["acc"];
string depthStr = Request.QueryString["depth"];
if (string.IsNullOrEmpty(acc) ||
string.IsNullOrEmpty(depthStr))
{
return;
}
int depth;
if (!int.TryParse(depthStr, out depth))
{
return;
}
GMUser user = (GMUser)Session["user"];
ParamMemberInfo param = new ParamMemberInfo();
param.m_creator = acc;
param.m_searchDepth = 1;
param.m_creatorDepth = depth;
param.m_subAcc = 2;
OpRes res = user.doQuery(param, QueryType.queryTypeGmAccount);
m_view.genTable(m_result, res, user, new EventHandler(onSetingAcc));
}
public override OpRes doQuery(object param, GMUser user)
{
m_result.Clear();
ParamMemberInfo p = (ParamMemberInfo)param;
return(query(user, p));
}
protected void onQueryMember(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamMemberInfo param = new ParamMemberInfo();
param.m_time = m_time.Text;
OpRes res = user.doQuery(param, QueryType.queryTypePlayerMember);
genTable(m_result, res, user);
}
protected void onQueryPlayerInfo(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamMemberInfo param = new ParamMemberInfo();
param.m_acc = m_acc.Text;
if (!string.IsNullOrEmpty(param.m_acc))
{
OpRes res = user.doQuery(param, QueryType.queryTypePlayerMember);
m_view.genTable(m_result, res, user, null, null);
}
}
protected void queryNextLevelMember(string acc, GMUser user)
{
ParamMemberInfo param = new ParamMemberInfo();
param.m_searchDepth = 1;
param.m_creator = acc;
OpRes res = user.doQuery(param, QueryType.queryTypeGmAccount);
m_view.genTable(m_result, res, user, new EventHandler(onScoreOp), param);
m_levelStr.InnerHtml = user.getOpLevelMgr().getCurLevelStr(acc);
}
protected void onQueryMember(GMUser user)
{
ParamMemberInfo param = new ParamMemberInfo();
// param.m_creator = user.m_user;
param.m_searchDepth = 1;
param.m_subAcc = 2;
m_view = new ViewAPIAdminScoreInfo(IsRefreshed);
OpRes res = user.doQuery(param, QueryType.queryTypeGmAccount);
m_view.genTable(m_result, res, user);
}
protected void onQueryMember(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamMemberInfo param = new ParamMemberInfo();
m_searchCond.fillCondtion(param, user);
param.m_curPage = m_gen.curPage;
param.m_countEachPage = m_gen.rowEachPage;
OpRes res = user.doQuery(param, QueryType.queryTypePlayerMember);
m_view.genTable(m_result, res, user, this, param);
}
void genTable()
{
GMUser user = (GMUser)Session["user"];
ParamMemberInfo param = new ParamMemberInfo();
param.m_searchDepth = 1;
param.m_subAcc = 2;
OpRes res = user.doQuery(param, QueryType.queryTypeGmAccount);
ViewRightAssign view = new ViewRightAssign();
view.genTable(m_result, res, user);
}
// 返回最终的查询语句
protected override string getResultSql(string cond, ParamMemberInfo p)
{
string cmd = "";
if (p.isPlayerWinLoseList())
{
cmd = string.Format(WIN_LOSE_SEARCH_CMD_1, TableName.PLAYER_WIN_LOSE, cond);
}
else
{
cmd = string.Format(WIN_LOSE_SEARCH_CMD, TableName.PLAYER_WIN_LOSE, cond);
}
return(cmd);
}
public override void genPage(ParamQueryBase queryParam, string url, ref string page_link, ref string foot, GMUser user)
{
ParamMemberInfo dparam = (ParamMemberInfo)queryParam;
PageBrowseGenerator p = new PageBrowseGenerator();
long total_page = 0;
Dictionary <string, object> urlParam = new Dictionary <string, object>();
urlParam["creator"] = dparam.m_creator;
page_link = p.genPageFoot(queryParam.m_curPage, m_rowEachPage, url, ref total_page, user, urlParam);
if (total_page != 0)
{
foot = queryParam.m_curPage + "/" + total_page;
}
}
protected void Page_Load(object sender, EventArgs e)
{
RightMgr.getInstance().opCheck("", Session, Response);
GMUser user = (GMUser)Session["user"];
ParamMemberInfo param = new ParamMemberInfo();
param.m_searchDepth = 1;
param.m_subAcc = 2;
OpRes res = user.doQuery(param, QueryType.queryTypeGmAccount);
m_view.genTable(m_result, res, user, new EventHandler(onSetingAcc));
}
protected void initQueryMember(GMUser user)
{
ParamMemberInfo param = new ParamMemberInfo();
param.m_searchDepth = 1;
URLParam uparam = new URLParam();
uparam.m_url = DefCC.ASPX_SCORE_GM;
user.getOpLevelMgr().addRootAcc(param.getRootUser(user), uparam);
m_levelStr.InnerHtml = user.getOpLevelMgr().getCurLevelStr(param.getRootUser(user));
OpRes res = user.doQuery(param, QueryType.queryTypeGmAccount);
m_view.genTable(m_result, res, user, new EventHandler(onScoreOp), param);
}
protected void onQueryMember1(object sender, EventArgs e)
{
GMUser user = (GMUser)Session["user"];
ParamMemberInfo param = new ParamMemberInfo();
m_searchCond.fillCondtion(param, user);
param.m_searchDepth = 1;
URLParam uparam = new URLParam();
uparam.m_url = @"/appaspx/account/AccountSearchSwitch.aspx";
user.getOpLevelMgr().addRootAcc(param.getRootUser(user), uparam);
m_levelStr.InnerHtml = user.getOpLevelMgr().getCurLevelStr(param.getRootUser(user));
OpRes res = user.doQuery(param, QueryType.queryTypeGmAccount);
m_view.genTable(m_result, res, user, new EventHandler(onSetingAcc), param);
}
protected override string genAccSearchCond(GMUser user, ParamMemberInfo p)
{
string cond = "";
if (p.isPlayerWinLoseList())
{
cond = string.Format(" playerAcc='{0}' and playerCreateCode like '{1}%' ",
p.m_acc,
ItemHelp.getCreateCodeSpecial(user));
}
else
{
cond = string.Format(" playerAcc='{0}' and playerCreateCode like '{1}%' ",
p.m_acc,
ItemHelp.getCreateCodeSpecial(user));
}
return(cond);
}
// 返回条件
protected override string getCondition(ParamMemberInfo p, GMUser user)
{
string cond = "";
if (p.isSearchAll()) // 搜索所有的下级代理下下级代理...所创建的玩家的输赢情况
{
string createCode = "";
string parent = null;
if (string.IsNullOrEmpty(p.m_creator))
{
createCode = ItemHelp.getCreateCodeSpecial(user);
parent = user.m_user;
}
else
{
createCode = ItemHelp.getCreateCode(p.m_creator, user);
parent = p.m_creator;
}
if (p.isIncludeDirectlyPlayer())
{
cond = string.Format(" playerCreateCode like '{0}%' ", createCode);
}
else
{
cond = string.Format(" playerCreateCode like '{0}%' and playerCreator<>'{1}' ", createCode, parent);
}
}
else // 直属会员
{
if (string.IsNullOrEmpty(p.m_creator))
{
cond = string.Format(" playerCreator='{0}' ", getAccountSpecial(user));
}
else
{
cond = string.Format(" playerCreator='{0}' and playerCreateCode like '{1}%' ", p.m_creator,
ItemHelp.getCreateCodeSpecial(user));
}
}
return(cond);
}
// canSearchAll是否允许搜索所有信息
public void fillCondtion(ParamMemberInfo param, GMUser user, bool canSearchAll = false)
{
param.m_dealer = m_dealer.SelectedValue;
param.m_dealerAdmin = m_dealerAdmin.SelectedValue;
param.m_seller = m_seller.SelectedValue;
param.m_sellerAdmin = m_sellerAdmin.SelectedValue;
param.m_acc = m_acc.Text;
param.m_time = __gmAccountCascadeStaticTime.Text;
if (canSearchAll)
{
return;
}
switch (user.m_accType)
{
case AccType.ACC_DEALER:
{
param.m_dealer = user.m_user;
}
break;
case AccType.ACC_DEALER_ADMIN:
{
param.m_dealerAdmin = user.m_user;
}
break;
case AccType.ACC_SELLER:
{
param.m_seller = user.m_user;
}
break;
case AccType.ACC_SELLER_ADMIN:
{
param.m_sellerAdmin = user.m_user;
}
break;
}
}
private OpRes statDirectlyPlayerSum(string creator, string time, GMUser user)
{
string cmd = "";
ParamMemberInfo p = new ParamMemberInfo();
p.m_creator = creator;
p.m_time = time;
p.m_searchDepth = 1;
OpRes res = m_generator.genSearchSql(p, user, ref cmd);
if (res != OpRes.opres_success)
{
return(res);
}
Dictionary <string, object> data
= user.sqlDb.queryOne(cmd, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
m_result.setDirectlyPlayerItem(data, creator, 0);
return(OpRes.opres_success);
}
protected void onQueryMember(GMUser user)
{
ParamMemberInfo param = new ParamMemberInfo();
if (!string.IsNullOrEmpty(m_creator))
{
param.m_creator = m_creator;
}
param.m_searchDepth = 1;
param.m_curPage = m_gen.curPage;
param.m_countEachPage = m_gen.rowEachPage;
m_view = new ViewPlayerScoreInfo(IsRefreshed);
OpRes res = user.doQuery(param, QueryType.queryTypePlayerMember);
m_view.genTable(m_result, res, user, this, param);
if (!string.IsNullOrEmpty(m_creator))
{
m_levelStr.InnerHtml = user.getOpLevelMgr().getCurLevelStr(m_creator);
}
}
protected void Page_Load(object sender, EventArgs e)
{
RightMgr.getInstance().opCheck("", Session, Response);
string acc = Request.QueryString["acc"];
if (string.IsNullOrEmpty(acc))
{
Server.Transfer(DefCC.ASPX_EMPTY);
}
GMUser user = (GMUser)Session["user"];
ParamMemberInfo param = new ParamMemberInfo();
param.m_creator = acc;
param.m_searchDepth = 1;
OpRes res = user.doQuery(param, QueryType.queryTypeGmAccount);
m_view.genTable(m_result, res, user, new EventHandler(onSetingAcc), param);
m_creator.InnerHtml = user.getOpLevelMgr().getCurLevelStr(acc);
}
