/// <summary>
/// 开奖
/// </summary>
/// <param name="interval">访问数据库频率</param>
/// <param name="errorString">错误信息</param>
/// <returns>业务操作结果</returns>
public OperationResult RevealLottery(int interval, out string errorString)
{
errorString = string.Empty;
try
{
List <SqlParameter> paramList = new List <SqlParameter>();
SqlParameter paramInterval = new SqlParameter("@interval", SqlDbType.Int);
paramInterval.Value = interval;
paramList.Add(paramInterval);
SqlParameter paramErrorString = new SqlParameter("@errorString", SqlDbType.VarChar, -1); //-1代表max
paramErrorString.Direction = ParameterDirection.Output;
paramList.Add(paramErrorString);
SqlCommand command = new SqlCommand();
DataSet ds = PrizeOrderRepository.ExecProcdureReturnDataSet("sp_revealLottery", out command, paramList.ToArray());
errorString = command.Parameters["@errorString"].Value.ToString();
return(new OperationResult(OperationResultType.Success, "开奖过程数据库操作顺利。", ds));
}
catch (System.Exception ex)
{
return(new OperationResult(OperationResultType.Error, ex.Message));
}
}
/// <summary>
/// 置顶
/// </summary>
/// <param name="poid">奖单ID</param>
/// <param name="moneyvalue">用户缴费金额</param>
/// <param name="datelong">置顶时长</param>
/// <param name="operatorid">操作者Id</param>
public OperationResult Set2Top(Guid poid, decimal moneyvalue, int datelong, long operatorid)
{
try
{
List <SqlParameter> paramList = new List <SqlParameter>();
//排序字符串
SqlParameter paramPoId = new SqlParameter("@PrizeOrderId", SqlDbType.VarChar, 100);
paramPoId.Value = poid.ToString();
paramList.Add(paramPoId);
//置顶时长
SqlParameter paramdl = new SqlParameter("@DateLong", SqlDbType.Int);
paramdl.Value = datelong;
paramList.Add(paramdl);
//缴费金额
SqlParameter parammval = new SqlParameter("@PaymentAmout", SqlDbType.Decimal);
parammval.Value = moneyvalue;
paramList.Add(parammval);
//操作者Id
SqlParameter paramopid = new SqlParameter("@OperatorId", SqlDbType.BigInt);
paramopid.Value = operatorid;
paramList.Add(paramopid);
SqlParameter paramec = new SqlParameter("@ErrorCode", SqlDbType.VarChar, 10);
paramec.Direction = ParameterDirection.Output;
paramList.Add(paramec);
SqlParameter parammsg = new SqlParameter("@Message", SqlDbType.VarChar, -1); //-1代表max
parammsg.Direction = ParameterDirection.Output;
paramList.Add(parammsg);
SqlCommand command = new SqlCommand();
DataSet ds = PrizeOrderRepository.ExecProcdureReturnDataSet("sp_set2Top", out command, paramList.ToArray());
string errorCode = command.Parameters["@ErrorCode"].Value.ToString();
string message = command.Parameters["@Message"].Value.ToString();
if (string.IsNullOrEmpty(errorCode))
{
return(new OperationResult(OperationResultType.Success, "奖单置顶成功。", message));
}
else
{
switch (errorCode)
{
case "Error_01":
return(new OperationResult(OperationResultType.Warning, "当前奖单已置顶过，上次置顶还未到期。", null));
default:
return(new OperationResult(OperationResultType.Warning, "出错了。", null));
}
}
}
catch (System.Exception ex)
{
return(new OperationResult(OperationResultType.Error, ex.Message));
}
}
/// <summary>
/// 取奖单
/// </summary>
/// <param name="pageSize">每页输出的记录数</param>
/// <param name="pageIndex">当前页数</param>
/// <param name="whereString">条件字符串</param>
/// <param name="orderbyString">排序字符串</param>
/// <param name="totalCount">返回总记录</param>
/// <param name="totalPageCount">返回总页数</param>
/// <param name="revealtype">开奖类型</param>
/// <param name="revealstate">奖单状态</param>
/// <returns></returns>
public OperationResult GetLotteries(int pageSize, int pageIndex, string whereString, string orderbyString, out int totalCount, out int totalPageCount, int revealtype = 0, int revealstate = 0, string tableName = "")
{
totalCount = 0;
totalPageCount = 0;
try
{
List <SqlParameter> paramList = new List <SqlParameter>();
//开奖类型
SqlParameter paramRT = new SqlParameter("@RevealType", SqlDbType.Int);
paramRT.Value = revealtype;
paramList.Add(paramRT);
//奖单状态
SqlParameter paramRS = new SqlParameter("@RevealState", SqlDbType.Int);
paramRS.Value = revealstate;
paramList.Add(paramRS);
//每页输出的记录数
SqlParameter paramPS = new SqlParameter("@PageSize", SqlDbType.Int);
paramPS.Value = pageSize;
paramList.Add(paramPS);
//当前页数
SqlParameter paramPI = new SqlParameter("@PageIndex", SqlDbType.Int);
paramPI.Value = pageIndex;
paramList.Add(paramPI);
//表名字符串
SqlParameter paramTbName = new SqlParameter("@TableName", SqlDbType.VarChar, 1000);
paramTbName.Value = tableName;
paramList.Add(paramTbName);
//排序字符串
SqlParameter paramWhere = new SqlParameter("@Where", SqlDbType.VarChar, 2000);
paramWhere.Value = whereString;
paramList.Add(paramWhere);
//排序字符串
SqlParameter paramOrder = new SqlParameter("@Order", SqlDbType.VarChar, 1000);
paramOrder.Value = orderbyString;
paramList.Add(paramOrder);
SqlParameter paramtc = new SqlParameter("@TotalCount", SqlDbType.Int);
paramtc.Direction = ParameterDirection.Output;
paramList.Add(paramtc);
SqlParameter paramtpc = new SqlParameter("@TotalPageCount", SqlDbType.Int);
paramtpc.Direction = ParameterDirection.Output;
paramList.Add(paramtpc);
SqlCommand command = new SqlCommand();
DataSet ds = PrizeOrderRepository.ExecProcdureReturnDataSet("sp_getLotteries", out command, paramList.ToArray());
totalCount = Convert.ToInt32(command.Parameters["@TotalCount"].Value);
totalPageCount = Convert.ToInt32(command.Parameters["@TotalPageCount"].Value);
return(new OperationResult(OperationResultType.Success, "开奖过程数据库操作顺利。", ds));
}
catch (System.Exception ex)
{
return(new OperationResult(OperationResultType.Error, ex.Message));
}
}
/// <summary>
/// 后知答案“竞猜开奖”
/// </summary>
/// <param name="id">奖单Id</param>
/// <param name="answer">竞猜答案</param>
public OperationResult RevealManualAnswerLottery(Guid id, string answer)
{
try
{
List <SqlParameter> paramList = new List <SqlParameter>();
SqlParameter paramPoid = new SqlParameter("@PrizeOrderId", SqlDbType.VarChar, 100);
paramPoid.Value = id.ToString();
paramList.Add(paramPoid);
SqlParameter paramAnswer = new SqlParameter("@Answer", SqlDbType.VarChar, -1);
paramAnswer.Value = answer;
paramList.Add(paramAnswer);
SqlParameter paramerrorcode = new SqlParameter("@ErrorCode", SqlDbType.VarChar, 10);
paramerrorcode.Direction = ParameterDirection.Output;
paramList.Add(paramerrorcode);
SqlParameter paramerrorstring = new SqlParameter("@ErrorString", SqlDbType.VarChar, -1);
paramerrorstring.Direction = ParameterDirection.Output;
paramList.Add(paramerrorstring);
SqlCommand command = new SqlCommand();
PrizeOrderRepository.ExecProcdureReturnDataSet("sp_revealSingleAnswerLottery", out command, paramList.ToArray());
string errorCode = command.Parameters["@ErrorCode"].Value.ToString();
string errorstring = command.Parameters["@ErrorString"].Value.ToString();
if (string.IsNullOrEmpty(errorCode))
{
return(new OperationResult(OperationResultType.Success, "开奖成功。", id));
}
else
{
switch (errorCode)
{
case "Error_01":
return(new OperationResult(OperationResultType.Warning, "奖单投注者总数小于所设置的中奖人数，不能开奖", errorstring));
case "Error_02":
return(new OperationResult(OperationResultType.Warning, "竞猜正确者总数小于所设置的中奖人数，不能开奖", errorstring));
default:
return(new OperationResult(OperationResultType.Warning, "出错了。", id));
}
}
}
catch (System.Exception ex)
{
return(new OperationResult(OperationResultType.Error, ex.Message));
}
}
/// <summary>
/// 获取奖单
/// </summary>
/// <returns>奖单信息结果集</returns>
public OperationResult GetTopPrizeOrders(int topCount, int?rtype)
{
try
{
List <SqlParameter> paramList = new List <SqlParameter>();
SqlParameter paramTopCount = new SqlParameter("@topCount", SqlDbType.Int);
paramTopCount.Value = topCount;
paramList.Add(paramTopCount);
SqlParameter paramRType = new SqlParameter("@revealType", SqlDbType.Int);
paramRType.Value = rtype ?? 0;
paramList.Add(paramRType);
DataSet ds = PrizeOrderRepository.ExecProcdureReturnDataSet("sp_getTopPrizeOrders", paramList.ToArray());
return(new OperationResult(OperationResultType.Success, "获取Top奖单成功。", ds));
}
catch (System.Exception ex)
{
return(new OperationResult(OperationResultType.Error, ex.Message));
}
}
/// <summary>
/// 手动开奖
/// </summary>
/// <param name="poid">奖单Id</param>
/// <param name="rtype">开奖类型</param>
public OperationResult ManualRevealLottery(Guid poid, int rtype)
{
try
{
List <SqlParameter> paramList = new List <SqlParameter>();
SqlParameter paramPoid = new SqlParameter("@PrizeOrderId", SqlDbType.VarChar, 100);
paramPoid.Value = poid.ToString();
paramList.Add(paramPoid);
SqlParameter paramRType = new SqlParameter("@RevealType", SqlDbType.Int);
paramRType.Value = rtype;
paramList.Add(paramRType);
SqlParameter paramerrorcode = new SqlParameter("@ErrorCode", SqlDbType.VarChar, 10);
paramerrorcode.Direction = ParameterDirection.Output;
paramList.Add(paramerrorcode);
SqlParameter paramerrorstring = new SqlParameter("@ErrorString", SqlDbType.VarChar, -1);
paramerrorstring.Direction = ParameterDirection.Output;
paramList.Add(paramerrorstring);
SqlCommand command = new SqlCommand();
PrizeOrderRepository.ExecProcdureReturnDataSet("sp_manualReveal", out command, paramList.ToArray());
string errorCode = command.Parameters["@ErrorCode"].Value.ToString();
string errorstring = command.Parameters["@ErrorString"].Value.ToString();
if (string.IsNullOrEmpty(errorCode))
{
return(new OperationResult(OperationResultType.Success, "开奖成功。", poid));
}
else
{
switch (errorCode)
{
case "Error_01":
return(new OperationResult(OperationResultType.Warning, "奖单投注者小于中奖人数，不能开奖", errorstring));
case "Error_02":
return(new OperationResult(OperationResultType.Warning, "奖单投注者总数小于所设置的奖池上限，未达到开奖条件", errorstring));
case "Error_03":
return(new OperationResult(OperationResultType.Warning, "开奖日期还没到，不能开奖", errorstring));
case "Error_04":
return(new OperationResult(OperationResultType.Warning, "竞猜正确者总数为0", errorstring));
case "Error_05":
return(new OperationResult(OperationResultType.Warning, "奖单投注者总数小于所设置的中奖人数,中止此奖单的开奖", errorstring));
default:
return(new OperationResult(OperationResultType.Warning, "出错了。", poid));
}
}
}
catch (System.Exception ex)
{
return(new OperationResult(OperationResultType.Error, ex.Message));
}
}