/// <summary>
/// 组装查询语句
/// </summary>
/// <param name="type">枚举码</param>
/// <param name="arg"></param>
/// <returns></returns>
private string GetSeleteSQL(SCCLottery type, HistoryLotteryArgEnyity arg)
{
StringBuilder builder = new StringBuilder();
string res = String.Empty;
int total = type.GetEnumText().TryToInt32();
string tableName = type.GetSCCLotteryTableName();
for (int i = 1; i <= total; i++)
{
builder.Append("[OpenCode" + i + "],");
}
if (arg.TotalRecord > 0)
{
res = string.Format(GetLotterySqlByTableNameWithTop, arg.TotalRecord, StringHelper.DelLastChar(builder.ToString(), ","), tableName);
}
else if (!string.IsNullOrEmpty(arg.StartTime))
{
string time = arg.StartTime.CheckDateTime()
? arg.StartTime
: DateTimeHelper.Now.AddDays(-7).ToString("yyyy-MM-dd");
res = string.Format(GetLotterySqlByTableNameWithStartTime, StringHelper.DelLastChar(builder.ToString(), ","), tableName, time);
}
else
{
res = string.Format(GetLotterySqlByTableNameWithTop, "20", StringHelper.DelLastChar(builder.ToString(), ","), tableName);
}
return(res);
}
/// <summary>
/// 获取开奖历史
/// </summary>
/// <param name="type"></param>
/// <param name="arg"></param>
/// <returns></returns>
private string GetResultByEnumCode(SCCLottery type, HistoryLotteryArgEnyity arg)
{
string res = String.Empty;
DataTable data = GetData(type, arg);
switch (type)
{
case SCCLottery.FC3D:
res = AppendFC3DResult(data, SCCLottery.FC3D);
break;
case SCCLottery.SSQ:
res = AppendSSQResult(data, SCCLottery.SSQ);
break;
case SCCLottery.QLC:
res = AppendQLCResult(data, SCCLottery.QLC);
break;
default:
res = AppendCommonResult(data, type);
break;
}
return(res);
}
/// <summary>
/// 查询数据集
/// </summary>
/// <param name="type"></param>
/// <param name="arg"></param>
/// <returns></returns>
private DataTable GetData(SCCLottery type, HistoryLotteryArgEnyity arg)
{
//组装查询语句
string sql = GetSeleteSQL(type, arg);
//查询结果
DataTable o = commonBll.ExcuteSqlDataTable(sql, DatabaseLinksEnum.LotteryNumber, null);
return(o);
}
/// <summary>
/// 获取开奖历史
/// </summary>
/// <param name="type"></param>
/// <param name="arg"></param>
/// <returns></returns>
private string GetResultByEnumCode(SCCLottery type, HistoryLotteryArgEnyity arg)
{
string res = String.Empty;
DataTable data = GetData(type, arg);
switch (type)
{
case SCCLottery.ShanDongKLPK3:
res = AppendShanDongKLPK3Result(data, SCCLottery.ShanDongKLPK3);
break;
default:
res = AppendCommonResult(data, type);
break;
}
return(res);
}
/// <summary>
/// 获取开奖历史
/// </summary>
/// <param name="type"></param>
/// <param name="arg"></param>
/// <returns></returns>
private string GetResultByEnumCode(SCCLottery type, HistoryLotteryArgEnyity arg)
{
string res = String.Empty;
DataTable data = GetData(type, arg);
switch (type)
{
case SCCLottery.DF6J1:
res = AppendCommonResult(data, SCCLottery.DF6J1);
break;
case SCCLottery.HD15X5:
res = AppendHD15X5Result(data, SCCLottery.HD15X5);
break;
default:
res = AppendCommonResult(data, type);
break;
}
return(res);
}
public HttpResponseMessage GetDFCHistoryLotteryList(HistoryLotteryArgEnyity arg)
{
BaseJson <string> resultMsg = new BaseJson <string> {
Status = (int)JsonObjectStatus.Error, Message = "服务器未知错误。", Data = null
};
Logger(typeof(DFCController), arg.TryToJson(), "获取地方彩彩种历史记录-GetDFCHistoryLotteryList", () =>
{
if (!string.IsNullOrEmpty(arg.t))
{
if (arg.t.CheckTimeStamp())
{
if (!string.IsNullOrEmpty(arg.EnumCode))
{
bool isSucc = Enum.TryParse <SCCLottery>(arg.EnumCode, true, out SCCLottery type);
//SCCLottery type = (SCCLottery)Enum.Parse(typeof(SCCLottery), arg.EnumCode, true);
if (!isSucc)
{
resultMsg = new BaseJson <string>
{
Status = (int)JsonObjectStatus.Fail,
Data = null,
Message = $"参数值{arg.EnumCode}无效。",
BackUrl = null
};
}
else
{
//获取组装完成后的Json字符串
string res = GetResultByEnumCode(type, arg);
resultMsg = new BaseJson <string>
{
Status = (int)JsonObjectStatus.Success,
Data = res.ToString(),
Message = JsonObjectStatus.Success.GetEnumText(),
BackUrl = null
};
}
}
else
{
resultMsg = new BaseJson <string>
{
Status = (int)JsonObjectStatus.Fail,
Data = null,
Message = JsonObjectStatus.Fail.GetEnumText() + "，请求参数EnumCode为空。",
BackUrl = null
};
}
}
else
{
resultMsg = new BaseJson <string>
{
Status = (int)JsonObjectStatus.Fail,
Data = null,
Message = JsonObjectStatus.Fail.GetEnumText() + "，无效参数。",
BackUrl = null
};
}
}
else
{
resultMsg = new BaseJson <string>
{
Status = (int)JsonObjectStatus.Fail,
Data = null,
Message = JsonObjectStatus.Fail.GetEnumText() + "，请求参数为空。",
BackUrl = null
};
}
}, e =>
{
resultMsg = new BaseJson <string>
{
Status = (int)JsonObjectStatus.Exception,
Data = null,
Message = JsonObjectStatus.Exception.GetEnumText() + "，异常信息：" + e.Message,
BackUrl = null
};
});
return(resultMsg.TryToJson().ToHttpResponseMessage());
}
