public List <P_OCAgent_Rebate> QueryLowerAgentListByParentId(string parentId)
{
string strSql = "select r.CreateTime,isnull(r.GameCode,'')GameCode,isnull(r.GameType,'')GameType,r.Id,isnull(r.Rebate,0)Rebate,isnull(r.SubUserRebate,0)SubUserRebate,u.UserId from C_User_Register u left join P_OCAgent_Rebate r on u.UserId=r.UserId where u.ParentPath like '%" + parentId + "%'";
var query = DB.CreateSQLQuery(strSql).List <object>();
List <P_OCAgent_Rebate> ocList = new List <P_OCAgent_Rebate>();
if (query != null && query.Count > 0)
{
foreach (var item in query)
{
var array = item as object[];
P_OCAgent_Rebate entity = new P_OCAgent_Rebate();
entity.CreateTime = Convert.ToDateTime(array[0]);
entity.GameCode = Convert.ToString(array[1]);
entity.GameType = Convert.ToString(array[2]);
entity.Id = Convert.ToInt32(array[3]);
entity.Rebate = Convert.ToDecimal(array[4]);
entity.SubUserRebate = Convert.ToDecimal(array[6]);
entity.UserId = Convert.ToString(array[6]);
ocList.Add(entity);
}
}
return(ocList);
}
/// <summary>
/// 修改用户返点
/// </summary>
/// <param name="rebate"></param>
public void UpdateOCAgentRebate(P_OCAgent_Rebate rebate)
{
DB.GetDal <P_OCAgent_Rebate>().Update(rebate);
}
/// <summary>
/// 新增用户返点配置
/// </summary>
public void AddOCAgentRebate(P_OCAgent_Rebate OCAgentRebate)
{
DB.GetDal <P_OCAgent_Rebate>().Add(OCAgentRebate);
}
