public string OperationUserLocation(ERUserLocationEntity location, string operationType)
{
string returnValue = string.Empty;
DataAccessManager.ExecuteCommand("OperationUserLocation", cmd =>
{
dynamic o = new { Entity = location, OpType = operationType };
returnValue = cmd.ExecuteNonQuery(o) != 0 ? location.UserID : string.Empty;
});
return(returnValue);
}
/// <summary>
/// 获取多个用户位置
/// </summary>
/// <param name="userIds"></param>
/// <returns></returns>
public List <ERUserLocationEntity> GetUsersLocation(List <string> userIds)
{
var usersLocation = new List <ERUserLocationEntity>();
var sb = new StringBuilder();
foreach (string id in userIds)
{
sb.AppendFormat("'{0}',", id);
}
DataAccessManager.ExecuteCommand("GetUsersLocation", cmd =>
{
cmd.CommandText = cmd.CommandText.Replace("#IDs#", sb.ToString().TrimEnd(','));
using (var reader = cmd.ExecuteDataReader())
{
while (reader.Read())
{
var userLocation = new ERUserLocationEntity();
userLocation.Build(reader);
usersLocation.Add(userLocation);
}
}
});
return(usersLocation);
}
