public PuzzleDrawDetails PuzzleReceive(PuzzleDrawDetails PuzzleDrawDetails)
{
DbCommand cmd = DB.GetStoredProcCommand("PuzzleReceiveDetails_Add");
DB.AddInParameter(cmd, PuzzleDrawDetails.UserIDField, DbType.Int64, PuzzleDrawDetails.UserID);
DB.AddInParameter(cmd, PuzzleDrawDetails.AreaIDField, DbType.Int32, PuzzleDrawDetails.AreaID);
DB.AddInParameter(cmd, PuzzleDrawDetails.AvatarIDField, DbType.Int64, PuzzleDrawDetails.AvatarID);
DB.AddInParameter(cmd, PuzzleDrawDetails.CreateTSField, DbType.DateTime, PuzzleDrawDetails.CreateTS);
DB.AddInParameter(cmd, PuzzleDrawDetails.PuzzleIDField, DbType.Int32, PuzzleDrawDetails.PuzzleID);
DB.AddInParameter(cmd, PuzzleDrawDetails.PuzzleTypeIdField, DbType.Int32, PuzzleDrawDetails.PuzzleTypeId);
DB.AddInParameter(cmd, PuzzleDrawDetails.AllPiecesRateField, DbType.Int32, PuzzleDrawDetails.AllPiecesRate);
DB.AddOutParameter(cmd, PuzzleDrawDetails.AwardPuzzlePacketField, DbType.String, 255);
DB.AddParameter(cmd, PuzzleDrawDetails.IsCompleteField, DbType.Int32, ParameterDirection.InputOutput, PuzzleDrawDetails.IsCompleteField, DataRowVersion.Current, PuzzleDrawDetails.IsComplete);
// DB.AddParameter(cmd, PuzzleDrawDetails.AwardPuzzlePacketField, DbType.String, ParameterDirection.InputOutput, PuzzleDrawDetails.AwardPuzzlePacketField, DataRowVersion.Current, PuzzleDrawDetails.AwardPuzzlePacket);
DB.AddParameter(cmd, PuzzleDrawDetails.PuzzleNoticeField, DbType.Boolean, ParameterDirection.InputOutput, PuzzleDrawDetails.PuzzleNoticeField, DataRowVersion.Current, PuzzleDrawDetails.PuzzleNotice);
DB.AddInParameter(cmd, PuzzleDrawDetails.SexField, DbType.Int32, PuzzleDrawDetails.Sex);
//增加返回参数
DB.AddParameter(cmd, ConstUtil.ReturnValue, DbType.Int32, ParameterDirection.ReturnValue,
string.Empty, DataRowVersion.Default, (int)ReturnState.UnSuccessful);
DB.ExecuteNonQuery(cmd);
PuzzleDrawDetails Packet = new PuzzleDrawDetails();
PuzzleDrawDetails.IsComplete = Convert.ToInt32(DB.GetParameterValue(cmd, "IsComplete"));
PuzzleDrawDetails.AwardPuzzlePacket = Convert.ToString(DB.GetParameterValue(cmd, "AwardPuzzlePacket"));
PuzzleDrawDetails.PuzzleNotice = Convert.ToBoolean(DB.GetParameterValue(cmd, "PuzzleNotice"));
//注意：
//增加方法 如果增加成功，返回ID，如果失败，返回0，如果检测到重复值，返回-1
//更新方法 如果更新成功，返回ID，如果失败，返回0，如果检测到重复值，返回-1
//删除方法 如果删除成功，返回ID，如果失败，返回0
// int rs = Convert.ToInt32(DB.GetParameterValue(cmd, ConstUtil.ReturnValue));
Packet = PuzzleDrawDetails;
return(Packet);
}
public Int32 AddPuzzleDrawDetails(PuzzleDrawDetails puzzleDrawDetails)
{
_client = new PuzzleEventService.PuzzleEventServiceClient();
try
{
int rs = _client.AddPuzzleDrawDetails(puzzleDrawDetails);
_client.Close();
return(rs);
}
catch (Exception ex)
{
_client.CloseCatch(ex, "AddPuzzleDrawDetails 兑换积分失败");
return(0);
}
}
public ActionResult PuzzleDraw(int DrawCount, int PuzzleTypeID)
{
int DrawConfig = CommonLibs.Common.AppSetting.GetInt32("DrawConfig");
int DrawExtra = CommonLibs.Common.AppSetting.GetInt32("DrawExtra");
Avatar avatar = Session[SessionKey.AvatarKey] as Avatar;
PuzzleDrawDetails useinfo = new PuzzleDrawDetails();
useinfo.UserID = avatar.UserID;
useinfo.LoginName = UserCookie.LoginName;
useinfo.AreaID = avatar.GameAreaID;
useinfo.AvatarID = avatar.AvatarID;
useinfo.AvatarName = avatar.AvatarName;
useinfo.DrawCount = DrawCount;
useinfo.PuzzleTypeId = PuzzleTypeID;
useinfo.Sex = avatar.OriginalSex;
if (DrawCount == DrawConfig)
{
useinfo.ExtraCount = DrawExtra;
useinfo.ActualCount = DrawCount + DrawExtra;
}
else
{
useinfo.ExtraCount = 0;
useinfo.ActualCount = DrawCount;
}
List <PuzzleDrawDetails> DrawResult = PuzzleEventBll.PuzzleDraw(useinfo);
if (DrawResult.Count > 0)
{
foreach (PuzzleDrawDetails drawdetail in DrawResult)
{
if (drawdetail.IsNotice && CommonLibs.Common.AppSetting.GetBool("IsNotice"))
{
string content = string.Format(CommonLibs.Common.AppSetting.GetString("NoticeContent"), avatar.AvatarName, drawdetail.AwardName);
marsApi.PublishBC(avatar.GameAreaID, content, "五周年纪念活动");
}
if (drawdetail.PuzzleNotice && CommonLibs.Common.AppSetting.GetBool("IsNotice"))
{
string content = string.Format(CommonLibs.Common.AppSetting.GetString("NoticeContent"), avatar.AvatarName, drawdetail.AwardPuzzlePacket);
marsApi.PublishBC(avatar.GameAreaID, content, "五周年纪念活动");
}
}
return(Jsonp(ErrorCode.Succuess, DrawResult));
}
return(Jsonp(ErrorCode.DrawFailed, null));
}
public PuzzleDrawDetails AddPiecesPacketDetails(PuzzleDrawDetails piecesPacketDetails)
{
_client = new PuzzleEventService.PuzzleEventServiceClient();
PuzzleDrawDetails lists = new PuzzleDrawDetails();
try
{
lists = _client.AddPiecesPacketDetails(piecesPacketDetails);
_client.Close();
return(lists);
}
catch (Exception ex)
{
_client.CloseCatch(ex, "GetUserPiecesTotalAll 获取指定用户信息失败");
return(lists);
}
}
public PuzzleDrawDetails PuzzleReceive(PuzzleDrawDetails PuzzleDrawDetails)
{
_client = new PuzzleEventService.PuzzleEventServiceClient();
PuzzleDrawDetails lists = new PuzzleDrawDetails();
try
{
lists = _client.PuzzleReceive(PuzzleDrawDetails);
_client.Close();
return(lists);
}
catch (Exception ex)
{
_client.CloseCatch(ex, "PuzzleReceive 失败");
return(lists);
}
}
public List <PuzzleDrawDetails> PuzzleDraw(PuzzleDrawDetails piecesPacketDetails)
{
_client = new PuzzleEventService.PuzzleEventServiceClient();
List <PuzzleDrawDetails> lists = new List <PuzzleDrawDetails>();
try
{
lists = _client.PuzzleDraw(piecesPacketDetails);
_client.Close();
return(lists);
}
catch (Exception ex)
{
_client.CloseCatch(ex, "PuzzleDraw 购买拼图礼包失败");
return(lists);
}
}
/// <summary>
/// 增加 PiecesPacketDetails
/// </summary>
/// Create By zhouqi
/// 2016/4/6 17:49:35
/// <param name="piecesPacketDetails">PiecesPacketDetails 实体</param>
/// <returns></returns>
public PuzzleDrawDetails AddPiecesPacketDetails(PuzzleDrawDetails piecesPacketDetails)
{
DbCommand cmd = DB.GetStoredProcCommand("PiecesPacketDetails_Add");
//DB.AddParameter(cmd, PuzzleDrawDetails.AwardNameField, DbType.String, ParameterDirection.InputOutput, PuzzleDrawDetails.AwardNameField, DataRowVersion.Current, piecesPacketDetails.AwardName);
DB.AddParameter(cmd, PuzzleDrawDetails.IsNoticeField, DbType.Boolean, ParameterDirection.InputOutput, PuzzleDrawDetails.IsNoticeField, DataRowVersion.Current, piecesPacketDetails.IsNotice);
DB.AddParameter(cmd, PuzzleDrawDetails.IsPuzzleField, DbType.Int32, ParameterDirection.InputOutput, PuzzleDrawDetails.IsPuzzleField, DataRowVersion.Current, piecesPacketDetails.PuzzleDrawID);
DB.AddParameter(cmd, PuzzleDrawDetails.IsCompleteField, DbType.Int32, ParameterDirection.InputOutput, PuzzleDrawDetails.IsCompleteField, DataRowVersion.Current, piecesPacketDetails.IsComplete);
//DB.AddParameter(cmd, PuzzleDrawDetails.AwardPuzzlePacketField, DbType.String, ParameterDirection.InputOutput, PuzzleDrawDetails.AwardPuzzlePacketField, DataRowVersion.Current, piecesPacketDetails.AwardPuzzlePacket);
DB.AddParameter(cmd, PuzzleDrawDetails.PuzzleNoticeField, DbType.Boolean, ParameterDirection.InputOutput, PuzzleDrawDetails.PuzzleNoticeField, DataRowVersion.Current, piecesPacketDetails.PuzzleNotice);
DB.AddParameter(cmd, PuzzleDrawDetails.PuzzleIDField, DbType.Int32, ParameterDirection.InputOutput, PuzzleDrawDetails.PuzzleIDField, DataRowVersion.Current, piecesPacketDetails.PuzzleID);
DB.AddParameter(cmd, PuzzleDrawDetails.PiecesOrderField, DbType.Int32, ParameterDirection.InputOutput, PuzzleDrawDetails.PiecesOrderField, DataRowVersion.Current, piecesPacketDetails.PiecesOrder);
DB.AddParameter(cmd, PuzzleDrawDetails.PuzzleRandomField, DbType.Int32, ParameterDirection.InputOutput, PuzzleDrawDetails.PuzzleRandomField, DataRowVersion.Current, piecesPacketDetails.PuzzleRandom);
DB.AddOutParameter(cmd, PuzzleDrawDetails.AwardNameField, DbType.String, 255);
DB.AddOutParameter(cmd, PuzzleDrawDetails.AwardPuzzlePacketField, DbType.String, 255);
DB.AddInParameter(cmd, PuzzleDrawDetails.UserIDField, DbType.Int64, piecesPacketDetails.UserID);
DB.AddInParameter(cmd, PuzzleDrawDetails.AreaIDField, DbType.Int32, piecesPacketDetails.AreaID);
DB.AddInParameter(cmd, PuzzleDrawDetails.AvatarIDField, DbType.Int64, piecesPacketDetails.AvatarID);
DB.AddInParameter(cmd, PuzzleDrawDetails.SexField, DbType.Int32, piecesPacketDetails.Sex);
DB.AddInParameter(cmd, PuzzleDrawDetails.PointsField, DbType.Int32, piecesPacketDetails.Points);
DB.AddInParameter(cmd, PuzzleDrawDetails.PuzzleTypeIdField, DbType.Int32, piecesPacketDetails.PuzzleTypeId);
DB.AddInParameter(cmd, PuzzleDrawDetails.PuzzleDrawIDField, DbType.Int32, piecesPacketDetails.PuzzleDrawID);
DB.AddInParameter(cmd, PuzzleDrawDetails.RateField, DbType.Int32, piecesPacketDetails.Rate);
DB.AddInParameter(cmd, PuzzleDrawDetails.PacketRateField, DbType.Int32, piecesPacketDetails.PacketRate);
DB.AddInParameter(cmd, PuzzleDrawDetails.AllPiecesRateField, DbType.Int32, piecesPacketDetails.AllPiecesRate);
//增加返回参数
DB.AddParameter(cmd, ConstUtil.ReturnValue, DbType.Int32, ParameterDirection.ReturnValue,
string.Empty, DataRowVersion.Default, (int)ReturnState.UnSuccessful);
DB.ExecuteNonQuery(cmd);
PuzzleDrawDetails piecesPacket = new PuzzleDrawDetails();
piecesPacket.AwardName = Convert.ToString(DB.GetParameterValue(cmd, "AwardName"));
piecesPacket.IsNotice = Convert.ToBoolean(DB.GetParameterValue(cmd, "IsNotice"));
piecesPacket.IsComplete = Convert.ToInt32(DB.GetParameterValue(cmd, "IsComplete"));
piecesPacket.IsPuzzle = Convert.ToInt32(DB.GetParameterValue(cmd, "IsPuzzle"));
piecesPacket.AwardPuzzlePacket = Convert.ToString(DB.GetParameterValue(cmd, "AwardPuzzlePacket"));
piecesPacket.PuzzleNotice = Convert.ToBoolean(DB.GetParameterValue(cmd, "PuzzleNotice"));
piecesPacket.DrawRS = Convert.ToInt32(DB.GetParameterValue(cmd, ConstUtil.ReturnValue));
piecesPacket.PuzzleID = Convert.ToInt32(DB.GetParameterValue(cmd, "PuzzleID"));
piecesPacket.PiecesOrder = Convert.ToInt32(DB.GetParameterValue(cmd, "PiecesOrder"));
piecesPacket.PuzzleRandom = Convert.ToInt32(DB.GetParameterValue(cmd, "PuzzleRandom"));
return(piecesPacket);
}
public List <PuzzleDrawDetails> GetPuzzleDrawDetailsList(ref DataPage dp, PuzzleDrawDetails searchPuzzleDrawDetails)
{
_admin = new PuzzleEventAdminService.PuzzleEventAdminServiceClient();
List <PuzzleDrawDetails> lists = new List <PuzzleDrawDetails>();
try
{
lists = _admin.GetPuzzleDrawDetailsList(ref dp, searchPuzzleDrawDetails);
_admin.Close();
return(lists);
}
catch (Exception ex)
{
_admin.CloseCatch(ex, "GetPuzzleDrawDetailsList 获取拼图列表失败");
return(lists);
}
}
/// <summary>
/// 增加 PuzzleDrawDetails
/// </summary>
/// Create By zhouqi
/// 2016/4/6 17:42:46
/// <param name="puzzleDrawDetails">PuzzleDrawDetails 实体</param>
/// <returns></returns>
public Int32 AddPuzzleDrawDetails(PuzzleDrawDetails puzzleDrawDetails)
{
DbCommand cmd = DB.GetStoredProcCommand("PuzzleDrawDetails_Add");
DB.AddParameter(cmd, PuzzleDrawDetails.PuzzleDrawIDField, DbType.Int32, ParameterDirection.InputOutput, PuzzleDrawDetails.PuzzleDrawIDField, DataRowVersion.Current, puzzleDrawDetails.PuzzleDrawID);
DB.AddInParameter(cmd, PuzzleDrawDetails.UserIDField, DbType.Int64, puzzleDrawDetails.UserID);
DB.AddInParameter(cmd, PuzzleDrawDetails.LoginNameField, DbType.String, puzzleDrawDetails.LoginName);
DB.AddInParameter(cmd, PuzzleDrawDetails.AreaIDField, DbType.Int32, puzzleDrawDetails.AreaID);
DB.AddInParameter(cmd, PuzzleDrawDetails.AvatarIDField, DbType.Int64, puzzleDrawDetails.AvatarID);
DB.AddInParameter(cmd, PuzzleDrawDetails.AvatarNameField, DbType.String, puzzleDrawDetails.AvatarName);
DB.AddInParameter(cmd, PuzzleDrawDetails.DrawCountField, DbType.Int32, puzzleDrawDetails.DrawCount);
DB.AddInParameter(cmd, PuzzleDrawDetails.ActualCountField, DbType.Int32, puzzleDrawDetails.ActualCount);
DB.AddInParameter(cmd, PuzzleDrawDetails.PuzzleTypeIdField, DbType.Int32, puzzleDrawDetails.PuzzleTypeId);
DB.AddInParameter(cmd, PuzzleDrawDetails.SexField, DbType.Int32, puzzleDrawDetails.Sex);
//增加返回参数
DB.AddParameter(cmd, ConstUtil.ReturnValue, DbType.Int32, ParameterDirection.ReturnValue,
string.Empty, DataRowVersion.Default, (int)ReturnState.UnSuccessful);
DB.ExecuteNonQuery(cmd);
puzzleDrawDetails.PuzzleDrawID = Convert.ToInt32(DB.GetParameterValue(cmd, "PuzzleDrawID"));
return(puzzleDrawDetails.PuzzleDrawID);
}
public List <PuzzleDrawDetails> PuzzleDraw(PuzzleDrawDetails piecesPacketDetails)
{
int randend = 3;
DbConnection conn = DB.CreateConnection();
conn.Open();
DbTransaction tran = conn.BeginTransaction();
try
{
piecesPacketDetails.PuzzleDrawID = AddPuzzleDrawDetails(piecesPacketDetails);
if (piecesPacketDetails.PuzzleDrawID < 1)
{
tran.Rollback();
}
List <PuzzleDrawDetails> list = new List <PuzzleDrawDetails>();
if (piecesPacketDetails.PuzzleTypeId == 3)
{
randend = 25;
}
for (int i = 0; i < piecesPacketDetails.DrawCount; i++)
{
piecesPacketDetails.Rate = GetRandomNum(1, 10000);
piecesPacketDetails.PacketRate = GetRandomNum(1, 10000);
piecesPacketDetails.AllPiecesRate = GetRandomNum(1, 10000);
piecesPacketDetails.Points = 1;
piecesPacketDetails.PuzzleRandom = GetRandomNum(1, randend);
PuzzleDrawDetails onedraw = new PuzzleDrawDetails();
onedraw = AddPiecesPacketDetails(piecesPacketDetails);
//System.Threading.Thread.Sleep(500);
if (onedraw.DrawRS == 1)
{
list.Add(onedraw);
}
}
if (piecesPacketDetails.ExtraCount > 0)
{
for (int i = 0; i < piecesPacketDetails.ExtraCount; i++)
{
piecesPacketDetails.Rate = GetRandomNum(1, 10000);
piecesPacketDetails.PacketRate = GetRandomNum(1, 10000);
piecesPacketDetails.AllPiecesRate = GetRandomNum(1, 10000);
piecesPacketDetails.Points = 0;
piecesPacketDetails.PuzzleRandom = GetRandomNum(1, randend);
PuzzleDrawDetails onedraw = new PuzzleDrawDetails();
onedraw = AddPiecesPacketDetails(piecesPacketDetails);
if (onedraw.DrawRS == 1)
{
list.Add(onedraw);
}
}
}
tran.Commit();
return(list);
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
public List <PuzzleDrawDetails> GetPuzzleDrawDetailsList(ref DataPage dp, PuzzleDrawDetails searchPuzzleDrawDetails)
{
return(_dal.GetPuzzleDrawDetailsList(ref dp, searchPuzzleDrawDetails));
}
public PuzzleDrawDetails PuzzleReceive(PuzzleDrawDetails PuzzleDrawDetails)
{
return(_dal.PuzzleReceive(PuzzleDrawDetails));
}
public List <PuzzleDrawDetails> PuzzleDraw(PuzzleDrawDetails piecesPacketDetails)
{
return(_dal.PuzzleDraw(piecesPacketDetails));
}
public PuzzleDrawDetails AddPiecesPacketDetails(PuzzleDrawDetails piecesPacketDetails)
{
return(_dal.AddPiecesPacketDetails(piecesPacketDetails));
}
public Int32 AddPuzzleDrawDetails(PuzzleDrawDetails puzzleDrawDetails)
{
return(_dal.AddPuzzleDrawDetails(puzzleDrawDetails));
}
