/// <summary>
/// 根据ID获取 PiecesReceive
/// </summary>
/// Create By zhouqi
/// 2016/4/6 16:43:36
/// <param name="piecesReceive">PiecesReceive 实体</param>
/// <returns></returns>
public List <PuzzlePieces> GetPiecesReceive(UserSearch searchPiecesReceive)
{
List <PuzzlePieces> PuzzlePiecesLists = new List <PuzzlePieces>();
DbCommand cmd = DB.GetStoredProcCommand("PiecesReceive_GetByUser");
DB.AddInParameter(cmd, UserSearch.UserIdField, DbType.Int64, searchPiecesReceive.UserId);
DB.AddInParameter(cmd, UserSearch.AreaIDField, DbType.Int32, searchPiecesReceive.AreaID);
PuzzlePieces piecesReceive = new PuzzlePieces();
using (IDataReader dr = DB.ExecuteReader(cmd))
{
if (dr.FieldCount > 0)
{
int coPuzzleName = dr.GetOrdinal(PuzzlePieces.PuzzleNameField);
int coPuzzlePieceName = dr.GetOrdinal(PuzzlePieces.PuzzlePieceNameField);
int coPieceOrder = dr.GetOrdinal(PuzzlePieces.PieceOrderField);
int coPuzzleID = dr.GetOrdinal(PuzzlePieces.PuzzleIDField);
while (dr.Read())
{
PuzzlePieces puzzlepieces = new PuzzlePieces();
puzzlepieces.PuzzleName = dr.IsDBNull(coPuzzleName) ? string.Empty : dr.GetString(coPuzzleName);
puzzlepieces.PuzzlePieceName = dr.IsDBNull(coPuzzlePieceName) ? string.Empty : dr.GetString(coPuzzlePieceName);
puzzlepieces.PieceOrder = dr.IsDBNull(coPieceOrder) ? (int)0 : dr.GetInt32(coPieceOrder);
puzzlepieces.PuzzleID = dr.IsDBNull(coPuzzleID) ? (int)0 : dr.GetInt32(coPuzzleID);
PuzzlePiecesLists.Add(puzzlepieces);
}
}
}
return(PuzzlePiecesLists);
}
public Int32 UpdatePuzzlePieces(PuzzlePieces puzzlePieces)
{
_admin = new PuzzleEventAdminService.PuzzleEventAdminServiceClient();
try
{
int rs = _admin.UpdatePuzzlePieces(puzzlePieces);
_admin.Close();
return(rs);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "UpdatePuzzlePieces 更新宝箱礼包信息失败");
return(0);
}
}
public List <PuzzlePieces> GetPuzzlePiecesList(ref DataPage dp, PuzzlePieces searchPuzzlePieces)
{
_admin = new PuzzleEventAdminService.PuzzleEventAdminServiceClient();
List <PuzzlePieces> lists = new List <PuzzlePieces>();
try
{
lists = _admin.GetPuzzlePiecesList(ref dp, searchPuzzlePieces);
_admin.Close();
return(lists);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "GetPuzzlePiecesList 获取拼图碎片列表失败");
return(lists);
}
}
public PuzzlePieces GetPuzzlePieces(PuzzlePieces searchPuzzlePieces)
{
_admin = new PuzzleEventAdminService.PuzzleEventAdminServiceClient();
PuzzlePieces lists = new PuzzlePieces();
try
{
lists = _admin.GetPuzzlePieces(searchPuzzlePieces);
_admin.Close();
return(lists);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "GetPuzzlePieces 获取拼图列表失败");
return(lists);
}
}
private void Start()
{
puzzle = GetComponent <PuzzlePieces>();
}
public List <PuzzlePieces> GetPuzzlePiecesList(ref DataPage dp, PuzzlePieces searchPuzzlePieces)
{
return(_dal.GetPuzzlePiecesList(ref dp, searchPuzzlePieces));
}
public PuzzlePieces GetPuzzlePieces(PuzzlePieces searchPuzzlePieces)
{
return(_dal.GetPuzzlePieces(searchPuzzlePieces));
}
public Int32 UpdatePuzzlePieces(PuzzlePieces puzzlePieces)
{
return(_dal.UpdatePuzzlePieces(puzzlePieces));
}
