public ActionResult GetUserInfo()
{
Avatar avatar = Session[SessionKey.AvatarKey] as Avatar;
//Session[SessionKey.AvatarKey] = avatar;
UserPiecesTotal usepiecestotal = new UserPiecesTotal();
usepiecestotal.AreaID = avatar.GameAreaID;
usepiecestotal.UserId = avatar.UserID;
List <UserPiecesTotal> userinfo = PuzzleEventBll.GetUserPiecesTotalAll(usepiecestotal);
var data = new { UserID = UserCookie.UserID, LoginName = UserCookie.LoginName, GameAreaID = avatar.GameAreaID, AvatarName = avatar.AvatarName, userinfo = userinfo };
return(Jsonp(ErrorCode.Succuess, data));
}
public List <UserPiecesTotal> GetUserPiecesTotalAll(UserPiecesTotal userpiecestotal)
{
_client = new PuzzleEventService.PuzzleEventServiceClient();
List <UserPiecesTotal> lists = new List <UserPiecesTotal>();
try
{
lists = _client.GetUserPiecesTotalAll(userpiecestotal);
_client.Close();
return(lists);
}
catch (Exception ex)
{
_client.CloseCatch(ex, "GetUserPiecesTotalAll 获取指定用户信息失败");
return(lists);
}
}
/// <summary>
/// 获取 UserPiecesTotal 全部数据
/// </summary>
/// Create By zhouqi
/// 2016/4/5 18:44:26
/// <returns></returns>
public List <UserPiecesTotal> GetUserPiecesTotalAll(UserPiecesTotal userpiecestotal)
{
DbCommand cmd = DB.GetStoredProcCommand("UserPiecesTotal_GetAll");
DB.AddInParameter(cmd, UserPiecesTotal.AreaIDField, DbType.Int32, userpiecestotal.AreaID);
DB.AddInParameter(cmd, UserPiecesTotal.UserIdField, DbType.Int64, userpiecestotal.UserId);
List <UserPiecesTotal> userPiecesTotalList = new List <UserPiecesTotal>();
using (IDataReader dr = DB.ExecuteReader(cmd))
{
if (dr.FieldCount > 0)
{
int coRecordID = dr.GetOrdinal(UserPiecesTotal.RecordIDField);
int coUserId = dr.GetOrdinal(UserPiecesTotal.UserIdField);
int coAreaID = dr.GetOrdinal(UserPiecesTotal.AreaIDField);
int coPiecesTotal = dr.GetOrdinal(UserPiecesTotal.PiecesTotalField);
int coPiecesConsume = dr.GetOrdinal(UserPiecesTotal.PiecesConsumeField);
int coPiecesBalance = dr.GetOrdinal(UserPiecesTotal.PiecesBalanceField);
int coPiecesOccupied = dr.GetOrdinal(UserPiecesTotal.PiecesOccupiedField);
int coPuzzleTypeID = dr.GetOrdinal(UserPiecesTotal.PuzzleTypeIDField);
int coRemainPoints = dr.GetOrdinal(UserPiecesTotal.RemainPointsField);
int coIsFirst = dr.GetOrdinal(UserPiecesTotal.IsFirstField);
while (dr.Read())
{
UserPiecesTotal userPiecesTotal = new UserPiecesTotal();
userPiecesTotal.RecordID = dr.IsDBNull(coRecordID) ? (long)0 : dr.GetInt64(coRecordID);
userPiecesTotal.UserId = dr.IsDBNull(coUserId) ? (long)0 : dr.GetInt64(coUserId);
userPiecesTotal.AreaID = dr.IsDBNull(coAreaID) ? (int)0 : dr.GetInt32(coAreaID);
userPiecesTotal.PiecesTotal = dr.IsDBNull(coPiecesTotal) ? (long)0 : dr.GetInt64(coPiecesTotal);
userPiecesTotal.PiecesConsume = dr.IsDBNull(coPiecesConsume) ? (int)0 : dr.GetInt32(coPiecesConsume);
userPiecesTotal.PiecesBalance = dr.IsDBNull(coPiecesBalance) ? (int)0 : dr.GetInt32(coPiecesBalance);
userPiecesTotal.PiecesOccupied = dr.IsDBNull(coPiecesOccupied) ? (int)0 : dr.GetInt32(coPiecesOccupied);
userPiecesTotal.PuzzleTypeID = dr.IsDBNull(coPuzzleTypeID) ? (int)0 : dr.GetInt32(coPuzzleTypeID);
userPiecesTotal.RemainPoints = dr.IsDBNull(coRemainPoints) ? (int)0 : dr.GetInt32(coRemainPoints);
userPiecesTotal.IsFirst = dr.IsDBNull(coIsFirst) ? (int)0 : dr.GetInt32(coIsFirst);
userPiecesTotalList.Add(userPiecesTotal);
}
}
}
//UserPiecesTotal UserPoints = new UserPiecesTotal();
//UserPoints.RemainPoints = Convert.ToInt64(DB.GetParameterValue(cmd, UserPiecesTotal.RemainPointsField));
//userPiecesTotalList.Add(UserPoints);
return(userPiecesTotalList);
}
public List <UserPiecesTotal> GetUserPiecesTotalList(ref DataPage dp, UserPiecesTotal searchUserPiecesTotal)
{
_admin = new PuzzleEventAdminService.PuzzleEventAdminServiceClient();
List <UserPiecesTotal> lists = new List <UserPiecesTotal>();
try
{
lists = _admin.GetUserPiecesTotalList(ref dp, searchUserPiecesTotal);
_admin.Close();
return(lists);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "GetUserPiecesTotalList 获取拼图列表失败");
return(lists);
}
}
public List <UserPiecesTotal> GetUserPiecesTotalList(ref DataPage dp, UserPiecesTotal searchUserPiecesTotal)
{
return(_dal.GetUserPiecesTotalList(ref dp, searchUserPiecesTotal));
}
public List <UserPiecesTotal> GetUserPiecesTotalAll(UserPiecesTotal userpiecestotal)
{
return(_dal.GetUserPiecesTotalAll(userpiecestotal));
}
