public override OpRes doQuery(object param, GMUser user)
{
m_result.Clear();
ParamGmAccountCascade p = (ParamGmAccountCascade)param;
string cmd =
string.Format("select acc from {0} where accType={1} and owner='{2}'",
TableName.GM_ACCOUNT,
p.m_searchAccType,
p.m_owner);
List <Dictionary <string, object> > dataList = user.sqlDb.queryList(cmd, user.getMySqlServerID(), MySqlDbName.DB_XIANXIA);
if (dataList == null)
{
return(OpRes.op_res_failed);
}
for (int i = 0; i < dataList.Count; i++)
{
MemberInfo info = new MemberInfo();
m_result.Add(info);
info.m_acc = Convert.ToString(dataList[i]["acc"]);
}
return(OpRes.opres_success);
}
// gm账号的级联查询填充
public static void fillDropDownList(DropDownList dList,
int searchAccType,
string owner,
GMUser user)
{
ParamGmAccountCascade param = new ParamGmAccountCascade();
param.m_searchAccType = searchAccType;
param.m_owner = owner;
user.doQuery(param, QueryType.queryTypeGmAccountCascade);
List <MemberInfo> data = (List <MemberInfo>)user.getQueryResult(QueryType.queryTypeGmAccountCascade);
for (int i = 0; i < data.Count; i++)
{
MemberInfo info = data[i];
dList.Items.Add(new ListItem(info.m_acc, info.m_acc));
}
}
