public object QueryPushRule(Dictionary <string, object> dicParas)
{
try
{
XCCloudUserTokenModel userTokenKeyModel = (XCCloudUserTokenModel)dicParas[Constant.XCCloudUserTokenModel];
string storeId = (userTokenKeyModel.DataModel as UserDataModel).StoreID;
string errMsg = string.Empty;
object[] conditions = dicParas.ContainsKey("conditions") ? (object[])dicParas["conditions"] : null;
SqlParameter[] parameters = new SqlParameter[0];
string sqlWhere = string.Empty;
if (conditions != null && conditions.Length > 0)
{
if (!QueryBLL.GenDynamicSql(conditions, "a.", ref sqlWhere, ref parameters, out errMsg))
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
}
string sql = @"select b.GameID, b.GameName, a.ID, a.MemberLevelName, a.Week, a.Allow_Out, a.Allow_In, a.Coin, a.Level, a.StartTime as ST, a.EndTime as ET from Data_Push_Rule a " +
" inner join Data_GameInfo b on a.GameIndexID=b.ID " +
" where b.StoreID='" + storeId + "'";
sql = sql + sqlWhere;
IData_Push_RuleService data_Push_RuleService = BLLContainer.Resolve <IData_Push_RuleService>();
var data_Push_Rule = data_Push_RuleService.SqlQuery <Data_Push_RuleList>(sql, parameters).ToList();
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn, data_Push_Rule));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object DelPushRule(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
string id = dicParas.ContainsKey("id") ? (dicParas["id"] + "") : string.Empty;
if (string.IsNullOrEmpty(id))
{
errMsg = "投币规则流水号不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
int iId = Convert.ToInt32(id);
IData_Push_RuleService data_Push_RuleService = BLLContainer.Resolve <IData_Push_RuleService>();
if (!data_Push_RuleService.Any(a => a.ID == iId))
{
errMsg = "该投币规则信息不存在";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
var data_Push_Rule = data_Push_RuleService.GetModels(p => p.ID == iId).FirstOrDefault();
if (!data_Push_RuleService.Delete(data_Push_Rule))
{
errMsg = "删除投币规则信息失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
public object AddPushRule(Dictionary <string, object> dicParas)
{
try
{
string errMsg = string.Empty;
var gameIndexIds = dicParas.ContainsKey("gameIndexIds") ? ((object[])dicParas["gameIndexIds"]).ToList().Select <object, int>(x => Convert.ToInt32(x)) : null;
string memberLevelId = dicParas.ContainsKey("memberLevelId") ? (dicParas["memberLevelId"] + "") : string.Empty;
string memberLevelName = dicParas.ContainsKey("memberLevelName") ? (dicParas["memberLevelName"] + "") : string.Empty;
string allow_Out = dicParas.ContainsKey("allow_Out") ? (dicParas["allow_Out"] + "") : string.Empty;
string allow_In = dicParas.ContainsKey("allow_In") ? (dicParas["allow_In"] + "") : string.Empty;
var weeks = dicParas.ContainsKey("weeks") ? ((object[])dicParas["weeks"]).ToList().Select <object, int>(x => Convert.ToInt32(x)) : null;
string coin = dicParas.ContainsKey("coin") ? (dicParas["coin"] + "") : string.Empty;
string level = dicParas.ContainsKey("level") ? (dicParas["level"] + "") : string.Empty;
string startTime = dicParas.ContainsKey("startTime") ? (dicParas["startTime"] + "") : string.Empty;
string endTime = dicParas.ContainsKey("endTime") ? (dicParas["endTime"] + "") : string.Empty;
#region 参数验证
if (gameIndexIds == null || gameIndexIds.Count() == 0)
{
errMsg = "游戏机数组gameIndexIds不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(memberLevelId))
{
errMsg = "会员级别memberLevelId不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(memberLevelName))
{
errMsg = "会员级别名称memberLevelName不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(allow_Out))
{
errMsg = "是否允许退币allow_Out不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(allow_Out))
{
errMsg = "是否允许退币allow_Out格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(allow_In))
{
errMsg = "是否允许投币allow_In不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(allow_In))
{
errMsg = "是否允许投币allow_In格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (weeks == null || weeks.Count() == 0)
{
errMsg = "周数组weeks不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(coin))
{
errMsg = "投币数coin不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(coin))
{
errMsg = "投币数coin格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(level))
{
errMsg = "优先级level不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (!Utils.isNumber(level))
{
errMsg = "优先级level格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(startTime))
{
errMsg = "生效时段startTime不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
TimeSpan st;
try
{
//st = Utils.StrToTimeSpan(startTime);
DateTime t = DateTime.ParseExact(startTime, "HH:mm:ss", CultureInfo.InvariantCulture); //24小时制，hh:mm:ss 12小时制
st = t - t.Date;
}
catch
{
errMsg = "生效时段startTime格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (string.IsNullOrEmpty(endTime))
{
errMsg = "生效时段endTime不能为空";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
TimeSpan et;
try
{
//et = Utils.StrToTimeSpan(endTime);
DateTime t = DateTime.ParseExact(endTime, "HH:mm:ss", CultureInfo.InvariantCulture); //24小时制，hh:mm:ss 12小时制
et = t - t.Date;
}
catch
{
errMsg = "生效时段endTime格式不正确";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
if (st.CompareTo(et) > 0)
{
errMsg = "生效时段开始时间startTime须小于结束时间endTime";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
#endregion
IData_Push_RuleService data_Push_RuleService = BLLContainer.Resolve <IData_Push_RuleService>();
//开启EF事务
using (TransactionScope ts = new TransactionScope())
{
try
{
foreach (int gameIndexId in gameIndexIds)
{
foreach (int week in weeks)
{
var data_Push_Rule = new Data_Push_Rule();
data_Push_Rule.Allow_In = Convert.ToInt32(allow_In);
data_Push_Rule.Allow_Out = Convert.ToInt32(allow_Out);
data_Push_Rule.Coin = Convert.ToInt32(coin);
data_Push_Rule.Week = Convert.ToInt32(week);
data_Push_Rule.Level = Convert.ToInt32(level);
data_Push_Rule.StartTime = st;
data_Push_Rule.EndTime = et;
data_Push_Rule.MemberLevelID = Convert.ToInt32(memberLevelId);
data_Push_Rule.MemberLevelName = memberLevelName;
data_Push_Rule.GameIndexID = gameIndexId;
data_Push_RuleService.AddModel(data_Push_Rule);
}
}
if (!data_Push_RuleService.SaveChanges())
{
errMsg = "添加投币规则失败";
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, errMsg));
}
ts.Complete();
}
catch (Exception ex)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, ex.Message));
}
}
return(ResponseModelFactory.CreateSuccessModel(isSignKeyReturn));
}
catch (DbEntityValidationException e)
{
return(ResponseModelFactory.CreateFailModel(isSignKeyReturn, e.EntityValidationErrors.ToErrors()));
}
catch (Exception e)
{
return(ResponseModelFactory.CreateReturnModel(isSignKeyReturn, Return_Code.F, e.Message));
}
}
