public static string AddActiveFallConfig(GSSModel.Request.ActiveFallGoodsData fall) {//LKSV_7_gspara_db_0_1 //首先将数据写入到GSSDB中 List <string> scenes = new List <string>(); foreach (int item in fall.SceneIds) { scenes.Add(item.ToString()); } GSSModel.Request.ActiveFallGoodLogicData goods = fall.MapObject <GSSModel.Request.ActiveFallGoodsData, GSSModel.Request.ActiveFallGoodLogicData>(true); string json = goods.ConvertJson(); GSSModel.SampleWorkOrder sample = new GSSModel.SampleWorkOrder() { Title = goods.ActiveName, Note = goods.ActiveName, BigZoneName = fall.BigZoneName, ZoneName = fall.ZoneName, TypeId = fall.TaskTypeID, AppId = fall.AppId, CreateBy = fall.CreateBy, LogicData = json }; DBHandle gss = new DBHandle(); int taskId = gss.AddSampleTaskWithLogicData(sample); if (!fall.SyncConfig) {//是否同时将配置写入到MySQL? return(string.Empty); } string linkName = string.Format("LKSV_GSS_7_gspara_db_{0}_{1}", fall.BigZoneID, fall.ZoneID); string conn, error = string.Empty; conn = QueryMysqlLinkConnString(linkName, ref error); if (!string.IsNullOrEmpty(error)) { return(error); } //此处需要确认MySQL中新增了列【最低等级,最高等级,掉落类型】 string cmd = @"insert into hugeaward_cfg(szName,NGSID,tBeginDate,tEndDate,tBeginTime,tEndTime,nDropItemID,nDropMax,nDropProbability,szDropScene,minLevel,maxLevel,fallType,TaskId ) values('{0}',-1,'{1}','{2}','{3}','{4}',{5},{6},{7},'{8}',{9},{10},{11},{12})"; //nDropProbability 存储的是概率分母 cmd = string.Format(cmd, fall.ActiveName, fall.StartTime.ToString(AppConfig.DateFormat), fall.EndTime.ToString(AppConfig.DateFormat), fall.StartTime.ToString(AppConfig.TimeFormat), fall.EndTime.ToString(AppConfig.TimeFormat), fall.EquipNo, fall.FallGoodNum, fall.GoodsFallPRDenominator, string.Join(",", scenes.ToArray()), fall.MinRoleLevel, fall.MaxRoleLevel, fall.FallType, taskId); string filter = FilterDBConnString(conn); //查询目前数据库中最大的ID DbHelperMySQL.connectionString = filter; try { int result = DbHelperMySQL.ExecuteSql(cmd); if (result > 0) { gss.FinshSyncLogicData(taskId); } } catch (Exception ex) { string msg = ex.ToString(); msg.Logger(); return(msg); } return(string.Empty); }