DataSet SampleQueryDataset(RequestParam param, string procedureName)
{
if (!param.Date.HasValue)
{
param.Date = int.Parse(DateTime.Now.ToString("yyyyMMdd"));
}
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("@bigZoneId", DbType.Int32)
{
Value = param.BigZoneId
});
ps.Add(new SqlParameter("@zoneId", DbType.Int32)
{
Value = param.ZoneId
});
ps.Add(new SqlParameter("@dayint", DbType.Int32)
{
Value = param.Date.Value
});
List <FriendLog> fs = new List <FriendLog>();
DataSet ds = db.RunProcedure(procedureName, ps.ToArray(), typeof(FriendLog).Name);
return(ds);
}
public JsonData TheDayActiveMount(RequestParam param, int userId = 0)
{
JsonData json = new JsonData();
try
{
if (!param.Date.HasValue)
{
string date = DateTime.Now.ToString("yyyyMMdd");
param.Date = Convert.ToInt32(date);
}
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("@bigZoneId", SqlDbType.Int)
{
Value = param.BigZoneId
});
ps.Add(new SqlParameter("@zoneId", SqlDbType.Int)
{
Value = param.ZoneId
});
if (userId > 0)
{
ps.Add(new SqlParameter("@userid", SqlDbType.Int)
{
Value = userId
});
}
ps.Add(new SqlParameter("@dayInt", SqlDbType.Int)
{
Value = param.Date.Value
});
DataSet ds = db.RunProcedure("SP_UserActiveMount", ps.ToArray(), typeof(UserRelatedDataStatis).Name);
List <OtherLog> logs = (new OtherLog()).GatherEntityDataWithMapColumn(ds); // string opbak = string.IsNullOrEmpty(l.opbak) ? l.opbak : (l.opbak.LastIndexOf("_") == l.opbak.Length - 1 ? l.opbak = l.opbak.Substring(0, l.opbak.Length - 2) : l.opbak);
ds.Dispose();
List <UserMountResponse> response = CalculateUserActiveMount(logs);
json.Count = response.Count;
json.Data = response;
json.Result = true;
}
catch (Exception ex)
{
json.Message = ex.ToString();
}
return(json);
}
JsonData GetSocialContactLog(RequestParam param, string procedureName)
{
JsonData json = new JsonData();
List <FriendLog> fs;
try
{
DataSet ds = SampleQueryDataset(param, procedureName);
fs = (new FriendLog()).GatherEntityDataWithMapColumn(ds).OrderBy(s => s.Level).ToList();
}
catch (Exception ex)
{
string msg = ex.Message;
json.Message = msg;
return(json);
}
List <FriendLog> add = new List <FriendLog>();
List <FriendLog> del = new List <FriendLog>();
foreach (FriendLog item in fs)
{
string[] p = item.OpBak.Split('_');
item.ActionType = int.Parse(p[0]);
if (item.ActionType == 1)
{
add.Add(item);
}
else
{
del.Add(item);
}
}
json.Data = new object[] { add, del };
json.Result = true;
return(json);
}
public static JsonData GetAjaxData(string tag, string time, string otherParam, int start, int end)
{
JsonData json = new JsonData()
{
Result = true
};
DateTime date = DateTime.Parse(time);
GridCategory grid;
Enum.TryParse(tag, out grid);
int zoneID = 0;
string[] param = otherParam.Split('&');//提取战区ID
foreach (string item in param)
{
string[] paramValue = item.Split('=');
if (paramValue[0] == "zoneid")
{
int.TryParse(paramValue[1], out zoneID);
break;
}
}
if (!string.IsNullOrEmpty(otherParam))
{
otherParam = otherParam.Trim();
}
RequestParam rp = new RequestParam()
{
Begin = start,
End = end,
BigZoneId = bigZoneId,
ZoneId = zoneID,
Date = int.Parse(date.ToString("yyyyMMdd"))
};
switch (grid)
{
case GridCategory.AuctionRoom:
List <PMHResponse> lis = new List <PMHResponse>();
for (int i = 0; i < 20; i++)
{
PMHResponse r = new PMHResponse()
{
Top = i + 1,
Money = (int)(i * 5.6),
User = "******" + i,
Role = "role" + i
};
lis.Add(r);
}
json.Data = lis;
json.Count = lis.Count;
break;
case GridCategory.GMUser:
Model.GMUserManage gm = new Model.GMUserManage();
json = gm.QueryGMUser(zoneID, start, end);
break;
case GridCategory.UserEmailData:
UserEmailDataManage udm = new UserEmailDataManage(DigDbConnString);
json = udm.QueryData(new UserEmailRequestParam()
{
Begin = start, End = end, BigZoneId = bigZoneId, ZoneId = zoneID
});
if (string.IsNullOrEmpty(json.Message))
{
json.Result = true;
}
break;
case GridCategory.UserActiveMountStatics:
UserRelatedDataStatis relate = new UserRelatedDataStatis(DigDbConnString);
json = relate.TheDayActiveMount(new RequestParam()
{
Begin = start,
End = end,
BigZoneId = bigZoneId,
ZoneId = zoneID,
Date = int.Parse(date.ToString("yyyyMMdd"))
});
break;
case GridCategory.UserMountLevelStatic:
relate = new UserRelatedDataStatis(DigDbConnString);
json = relate.UserMountLevelStatic(new RequestParam()
{
Begin = start,
End = end,
BigZoneId = bigZoneId,
ZoneId = zoneID,
Date = int.Parse(date.ToString("yyyyMMdd"))
});
break;
case GridCategory.UserAddFriendLog:
relate = new UserRelatedDataStatis(DigDbConnString);
json = relate.GetUserFriendLogs(rp);
break;
case GridCategory.Ememy:
relate = new UserRelatedDataStatis(DigDbConnString);
json = relate.GetEmemy(rp);
break;
default:
break;
}
return(json);
}
public JsonData GetEmemy(RequestParam param)
{
return(GetSocialContactLog(param, "SP_QueryEmemyLog"));
}
/// <summary>
/// 添加以及删除的记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public JsonData GetUserFriendLogs(RequestParam param)
{
return(GetSocialContactLog(param, "SP_UserFriendLog"));
}
/// <summary>
/// 坐骑进阶
/// Param1:坐骑ID
/// Param2:进阶结果(1:成功 0:失败) Param3:进阶之前的等级 Param4:进阶之后的等级
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public JsonData UserMountLevelStatic(RequestParam param)
{//用户坐骑等级变化统计
JsonData json = new JsonData()
{
Result = true
};
try
{
if (!param.Date.HasValue)
{
string date = DateTime.Now.ToString("yyyyMMdd");
param.Date = Convert.ToInt32(date);
}
List <SqlParameter> sqlparam = new List <SqlParameter>();
sqlparam.Add(new SqlParameter("@bigZoneId", SqlDbType.Int)
{
Value = param.BigZoneId
});
sqlparam.Add(new SqlParameter("@zoneId", SqlDbType.Int)
{
Value = param.ZoneId
});
sqlparam.Add(new SqlParameter("@dayInt", SqlDbType.Int)
{
Value = param.Date.Value
});
DataSet ds = db.RunProcedure("SP_MountLevel", sqlparam.ToArray(), typeof(UserRelatedDataStatis).Name);
List <OtherLog> logs = (new OtherLog()).GatherEntityDataWithMapColumn(ds);
List <UserMountLevel> levels = new List <UserMountLevel>();
foreach (OtherLog item in logs)
{
string mountId = item.opbak.Split('_')[MountUpLevelBakParam.MountId.GetHashCode()];
int g = int.Parse(item.opbak.Split('_')[MountUpLevelBakParam.NowLevel.GetHashCode()]);
UserMountLevel level = levels.Where(le => le.mountId == mountId && le.roleid == item.roleid).FirstOrDefault();
if (level == null)
{
levels.Add(new UserMountLevel()
{
roleid = item.roleid, mountId = mountId, level = g
});
}
else
{
foreach (UserMountLevel ml in levels)
{
if (ml.roleid == level.roleid && ml.mountId == level.mountId)
{
ml.level = ml.level < g ? g : ml.level;
break;
}
}
}
}
//不统计到用户：每一坐骑每一个等级的数目
List <UserMountLevelStatisc> sample = new List <UserMountLevelStatisc>();
foreach (UserMountLevel item in levels)
{
UserMountLevelStatisc sa = sample.Where(s => s.mountId == item.mountId && s.level == item.level).FirstOrDefault();
if (sa == null)
{
sample.Add(new UserMountLevelStatisc()
{
mountId = item.mountId, level = item.level
});
continue;
}
}
foreach (UserMountLevel item in levels)
{
foreach (UserMountLevelStatisc s in sample)
{
if (item.mountId == s.mountId && item.level == s.level)
{
s.mountNumber++;
break;
}
}
}
json.Data = sample;
json.Count = sample.Count;
return(json);
}
catch (Exception ex)
{
json.Result = false;
json.Message = ex.ToString();
}
return(json);
}
