void FillBuffMemberSkill(DTOBuffMemberView view, NbManagerbuffmemberEntity member, DTOBuffPlayer player)
{
member.MatchPropList = player.MatchPropList;
member.MatchBoostList = player.MatchBoostList;
if (null == view.ReadySkillList)
{
view.ReadySkillList = new List <string>();
}
member.LiveSkillList = new List <string>();
member.FirmSkillList = new List <string>();
if (null != player.SBMList)
{
var rankSkills = BuffCache.Instance().GetRankedSkillList(player.SBMList);
view.ReadySkillList.AddRange(rankSkills[0]);
member.LiveSkillList.AddRange(rankSkills[1]);
member.FirmSkillList.AddRange(rankSkills[2]);
}
var skill = player.ActionSkill;
if (!string.IsNullOrEmpty(skill))
{
member.LiveSkillList.Add(skill);
}
skill = player.StarPlusSkill;
if (!string.IsNullOrEmpty(skill))
{
member.LiveSkillList.Add(skill);
}
skill = player.StarSkill;
if (!string.IsNullOrEmpty(skill))
{
member.LiveSkillList.AddRange(player.AsStarSkill);
}
}
/// <summary>
/// 位置不适应 -BUFF
/// </summary>
/// <param name="buffMember">Buff列表</param>
/// <param name="ballParkPoint">场上位置</param>
/// <param name="playerposition">球员最佳位置</param>
private static void CheckBuff(NbManagerbuffmemberEntity buffMember, string ballParkPoint, string playerposition)
{
try
{
var config = CacheFactory.FormationCache.GetFormationPoint(playerposition, ballParkPoint);
if (config == null)
{
return;
}
buffMember.AccelerationConst = buffMember.AccelerationConst * config.Buff / 100;
buffMember.AggressionConst = buffMember.AggressionConst * config.Buff / 100;
buffMember.BalanceConst = buffMember.BalanceConst * config.Buff / 100;
buffMember.BounceConst = buffMember.BounceConst * config.Buff / 100;
buffMember.DisturbConst = buffMember.DisturbConst * config.Buff / 100;
buffMember.DribbleConst = buffMember.DribbleConst * config.Buff / 100;
buffMember.FreeKickConst = buffMember.FreeKickConst * config.Buff / 100;
buffMember.HandControlConst = buffMember.HandControlConst * config.Buff / 100;
buffMember.InterceptionConst = buffMember.InterceptionConst * config.Buff / 100;
buffMember.MentalityConst = buffMember.MentalityConst * config.Buff / 100;
buffMember.PassConst = buffMember.PassConst * config.Buff / 100;
buffMember.PhysiqueConst = buffMember.PhysiqueConst * config.Buff / 100;
buffMember.PositioningConst = buffMember.PositioningConst * config.Buff / 100;
buffMember.PowerConst = buffMember.PowerConst * config.Buff / 100;
buffMember.ResponseConst = buffMember.ResponseConst * config.Buff / 100;
buffMember.ShootConst = buffMember.ShootConst * config.Buff / 100;
buffMember.SpeedConst = buffMember.SpeedConst * config.Buff / 100;
}
catch (Exception ex)
{
SystemlogMgr.Error("位置不适应 -BUFF", ex.ToString(), ballParkPoint + "__" + playerposition);
}
}
NbManagerbuffmemberEntity BuildBuffMember(DicPlayerEntity dic)
{
NbManagerbuffmemberEntity member = new NbManagerbuffmemberEntity();
member.PPos = dic.Position;
member.IsMain = true;
var props = dic.GetRawProps();
member.SpeedCount += props[0];
member.ShootCount += props[1];
member.FreeKickCount += props[2];
member.BalanceCount += props[3];
member.PhysiqueCount += props[4];
member.BounceCount += props[5];
member.AggressionCount += props[6];
member.DisturbCount += props[7];
member.InterceptionCount += props[8];
member.DribbleCount += props[9];
member.PassCount += props[10];
member.MentalityCount += props[11];
member.ResponseCount += props[12];
member.PositioningCount += props[13];
member.HandControlCount += props[14];
member.AccelerationCount += props[15];
return(member);
}
/// <summary>
/// 将IDataReader的当前记录读取到NbManagerbuffmemberEntity 对象
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public NbManagerbuffmemberEntity LoadSingleRow(IDataReader reader)
{
var obj = new NbManagerbuffmemberEntity();
obj.Id = (System.Int64)reader["Id"];
obj.ManagerId = (System.Guid)reader["ManagerId"];
obj.Tid = (System.Guid)reader["Tid"];
obj.Pid = (System.Int32)reader["Pid"];
obj.PPos = (System.Int32)reader["PPos"];
obj.PPosOn = (System.Int32)reader["PPosOn"];
obj.Kpi = (System.Int32)reader["Kpi"];
obj.Level = (System.Int32)reader["Level"];
obj.Strength = (System.Int32)reader["Strength"];
obj.ShowOrder = (System.Int32)reader["ShowOrder"];
obj.IsMain = (System.Boolean)reader["IsMain"];
obj.ReadySkills = (System.String)reader["ReadySkills"];
obj.LiveSkills = (System.String)reader["LiveSkills"];
obj.SpeedConst = (System.Double)reader["SpeedConst"];
obj.SpeedCount = (System.Double)reader["SpeedCount"];
obj.ShootConst = (System.Double)reader["ShootConst"];
obj.ShootCount = (System.Double)reader["ShootCount"];
obj.FreeKickConst = (System.Double)reader["FreeKickConst"];
obj.FreeKickCount = (System.Double)reader["FreeKickCount"];
obj.BalanceConst = (System.Double)reader["BalanceConst"];
obj.BalanceCount = (System.Double)reader["BalanceCount"];
obj.PhysiqueConst = (System.Double)reader["PhysiqueConst"];
obj.PhysiqueCount = (System.Double)reader["PhysiqueCount"];
obj.PowerConst = (System.Double)reader["PowerConst"];
obj.PowerCount = (System.Double)reader["PowerCount"];
obj.AggressionConst = (System.Double)reader["AggressionConst"];
obj.AggressionCount = (System.Double)reader["AggressionCount"];
obj.DisturbConst = (System.Double)reader["DisturbConst"];
obj.DisturbCount = (System.Double)reader["DisturbCount"];
obj.InterceptionConst = (System.Double)reader["InterceptionConst"];
obj.InterceptionCount = (System.Double)reader["InterceptionCount"];
obj.DribbleConst = (System.Double)reader["DribbleConst"];
obj.DribbleCount = (System.Double)reader["DribbleCount"];
obj.PassConst = (System.Double)reader["PassConst"];
obj.PassCount = (System.Double)reader["PassCount"];
obj.MentalityConst = (System.Double)reader["MentalityConst"];
obj.MentalityCount = (System.Double)reader["MentalityCount"];
obj.ResponseConst = (System.Double)reader["ResponseConst"];
obj.ResponseCount = (System.Double)reader["ResponseCount"];
obj.PositioningConst = (System.Double)reader["PositioningConst"];
obj.PositioningCount = (System.Double)reader["PositioningCount"];
obj.HandControlConst = (System.Double)reader["HandControlConst"];
obj.HandControlCount = (System.Double)reader["HandControlCount"];
obj.AccelerationConst = (System.Double)reader["AccelerationConst"];
obj.AccelerationCount = (System.Double)reader["AccelerationCount"];
obj.BounceConst = (System.Double)reader["BounceConst"];
obj.BounceCount = (System.Double)reader["BounceCount"];
obj.RowTime = (System.DateTime)reader["RowTime"];
obj.RowVersion = (System.Byte[])reader["RowVersion"];
return(obj);
}
public static double AsKpi(this NbManagerbuffmemberEntity buffMember, int index, int formationId)
{
return(AsKpiNew(buffMember, index, formationId));
//double kpi = 0;
//double memberKpi = 0;
//switch (buffMember.PPos)
//{
// case (int)EnumPosition.Goalkeeper:
// kpi = buffMember.TotalResponse + buffMember.TotalPositioning + buffMember.TotalHandControl;
// break;
// case (int)EnumPosition.Fullback:
// kpi = (buffMember.TotalBalance + buffMember.TotalPhysique + buffMember.TotalPower) * 0.4
// + (buffMember.TotalAggression + buffMember.TotalDisturb + buffMember.TotalInterception) * 0.6;
// break;
// case (int)EnumPosition.Midfielder:
// kpi = (buffMember.TotalDribble + buffMember.TotalPass + buffMember.TotalMentality) * 0.6
// + (buffMember.TotalSpeed + buffMember.TotalShoot + buffMember.TotalFreeKick) * 0.2
// + (buffMember.TotalBalance + buffMember.TotalPhysique + buffMember.TotalPower) * 0.2;
// break;
// case (int)EnumPosition.Forward:
// kpi = (buffMember.TotalSpeed + buffMember.TotalShoot + buffMember.TotalFreeKick) * 0.6
// + (buffMember.TotalBalance + buffMember.TotalPhysique + buffMember.TotalPower) * 0.2
// + (buffMember.TotalDribble + buffMember.TotalPass + buffMember.TotalMentality) * 0.2;
// break;
//}
////var pPos = buffMember.IsMain ? buffMember.PPosOn : buffMember.PPos;
//switch (buffMember.PPos)
//{
// case (int)EnumPosition.Goalkeeper:
// memberKpi = (buffMember.TotalResponse + buffMember.TotalHandControl + buffMember.TotalPositioning) / 3;
// break;
// case (int)EnumPosition.Fullback:
// memberKpi = (buffMember.TotalAggression + buffMember.TotalDisturb + buffMember.TotalInterception) / 3;
// break;
// case (int)EnumPosition.Midfielder:
// memberKpi = (buffMember.TotalBalance + buffMember.TotalDribble + buffMember.TotalPass +
// buffMember.TotalMentality) / 4;
// break;
// case (int)EnumPosition.Forward:
// memberKpi = (buffMember.TotalSpeed + buffMember.TotalShoot + buffMember.TotalDribble +
// buffMember.TotalMentality) / 4;
// break;
//}
//buffMember.Kpi = Convert.ToInt32(memberKpi);
//return buffMember.IsMain ? kpi : 0;
}
public void FillBuffView(DTOBuffMemberView buffView, Dictionary <Guid, DTOBuffPlayer> buffPlayers, bool fillProp = true, int fillKpi = 0, int formationId = 0)
{
if (null == buffPlayers)
{
return;
}
var dic = buffView.BuffMembers;
if (null == dic)
{
dic = new Dictionary <Guid, NbManagerbuffmemberEntity>(buffPlayers.Count);
buffView.BuffMembers = dic;
}
Guid tid = Guid.Empty;
NbManagerbuffmemberEntity member = null;
double kpi = 0;
int index = 0;
foreach (var kvp in buffPlayers)
{
tid = kvp.Key;
if (!dic.TryGetValue(tid, out member))
{
member = CreateBuffMember(tid, kvp.Value);
FillBuffMemberSkill(buffView, member, kvp.Value);
dic[tid] = member;
}
if (fillProp)
{
FillBuffMemberProp(member, kvp.Value);
}
if (fillKpi > 0)
{
kpi += member.AsKpi(index, formationId);
}
index++;
}
if (fillKpi == 1)
{
buffView.Kpi = buffView.KpiReady = Convert.ToInt32(kpi);
}
else if (fillKpi > 1)
{
buffView.KpiReady = Convert.ToInt32(kpi);
}
}
static void BuildTeammemberData(PlayerInput dstData, NbManagerbuffmemberEntity srcTeammember, double buffScale, bool isGuide = false)
{
if (null == dstData || null == srcTeammember)
{
return;
}
dstData.Speed = srcTeammember.TotalSpeed * buffScale;
dstData.Shooting = srcTeammember.TotalShoot * buffScale;
dstData.FreeKick = srcTeammember.TotalFreeKick * buffScale;
dstData.Balance = srcTeammember.TotalBalance * buffScale;
dstData.Stamina = srcTeammember.TotalPhysique * buffScale;
dstData.Strength = srcTeammember.TotalPower * buffScale;
dstData.Aggression = srcTeammember.TotalAggression * buffScale;
dstData.Disturb = srcTeammember.TotalDisturb * buffScale;
dstData.Interception = srcTeammember.TotalInterception * buffScale;
dstData.Dribble = srcTeammember.TotalDribble * buffScale;
dstData.Passing = srcTeammember.TotalPass * buffScale;
dstData.Mentality = srcTeammember.TotalMentality * buffScale;
dstData.Reflexes = srcTeammember.TotalResponse * buffScale;
dstData.Positioning = srcTeammember.TotalPositioning * buffScale;
dstData.Handling = srcTeammember.TotalHandControl * buffScale;
dstData.Acceleration = srcTeammember.TotalAcceleration * buffScale;
dstData.Bounce = srcTeammember.TotalBounce * buffScale;
dstData.Skills = srcTeammember.LiveSkillList;
if (null != srcTeammember.MatchPropList)
{
dstData.PropList = new List <PropInput>();
foreach (var item in srcTeammember.MatchPropList)
{
dstData.PropList.Add(new PropInput(item.Point, item.Percent, item.BuffId));
}
}
if (null != srcTeammember.MatchBoostList)
{
dstData.BoostList = new List <BoostInput>();
foreach (var item in srcTeammember.MatchBoostList)
{
dstData.BoostList.Add(new BoostInput(item.BoostType, item.Point, item.Percent, item.BuffId));
}
}
}
/// <summary>
/// GetById
/// </summary>
/// <param name="id">id</param>
/// <returns>NbManagerbuffmemberEntity</returns>
/// <remarks>2016/4/22 15:12:23</remarks>
public NbManagerbuffmemberEntity GetById(System.Int64 id)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("P_NbManagerbuffmember_GetById");
database.AddInParameter(commandWrapper, "@Id", DbType.Int64, id);
NbManagerbuffmemberEntity obj = null;
using (IDataReader reader = database.ExecuteReader(commandWrapper))
{
if (reader.Read())
{
obj = LoadSingleRow(reader);
}
}
return(obj);
}
void FillBuffMemberProp(NbManagerbuffmemberEntity member, DTOBuffPlayer player)
{
var props = player.Props;
member.SpeedCount += props[0].BuffValue;
member.ShootCount += props[1].BuffValue;
member.FreeKickCount += props[2].BuffValue;
member.BalanceCount += props[3].BuffValue;
member.PhysiqueCount += props[4].BuffValue;
member.PowerConst += props[5].BuffValue;
member.AggressionCount += props[6].BuffValue;
member.DisturbCount += props[7].BuffValue;
member.InterceptionCount += props[8].BuffValue;
member.DribbleCount += props[9].BuffValue;
member.PassCount += props[10].BuffValue;
member.MentalityCount += props[11].BuffValue;
member.ResponseCount += props[12].BuffValue;
member.PositioningCount += props[13].BuffValue;
member.HandControlCount += props[14].BuffValue;
member.AccelerationCount += props[15].BuffValue;
member.BounceCount += props[16].BuffValue;
player.ClearBuff();
}
NbManagerbuffmemberEntity CreateBuffMember(Guid tid, DTOBuffPlayer player)
{
if (null == player)
{
return(null);
}
var member = new NbManagerbuffmemberEntity();
member.Tid = tid;
member.Pid = player.AsPid;
member.PPos = player.Pos;
member.PPosOn = player.PosOn;
member.Level = player.Level;
member.Strength = player.Strength;
member.IsMain = player.OnFlag;
member.ShowOrder = player.ShowOrder;
var props = player.Props;
member.SpeedConst = props[0].Orig;
member.ShootConst = props[1].Orig;
member.FreeKickConst = props[2].Orig;
member.BalanceConst = props[3].Orig;
member.PhysiqueConst = props[4].Orig;
member.PowerConst = props[5].Orig;
member.AggressionConst = props[6].Orig;
member.DisturbConst = props[7].Orig;
member.InterceptionConst = props[8].Orig;
member.DribbleConst = props[9].Orig;
member.PassConst = props[10].Orig;
member.MentalityConst = props[11].Orig;
member.ResponseConst = props[12].Orig;
member.PositioningConst = props[13].Orig;
member.HandControlConst = props[14].Orig;
member.AccelerationConst = props[15].Orig;
member.BounceConst = props[16].Orig;
return(member);
}
void FillBuffMemberProp(NbManagerbuffmemberEntity member, DicPlayerEntity cfg)
{
if (null == member || null == cfg)
{
return;
}
member.SpeedConst = cfg.Speed;
member.ShootConst = cfg.Shoot;
member.FreeKickConst = cfg.FreeKick;
member.BalanceConst = cfg.Balance;
member.PhysiqueConst = cfg.Physique;
member.PowerConst = cfg.Power;
member.BounceConst = cfg.Bounce;
member.AggressionConst = cfg.Aggression;
member.DisturbConst = cfg.Disturb;
member.InterceptionConst = cfg.Interception;
member.DribbleConst = cfg.Dribble;
member.PassConst = cfg.Pass;
member.MentalityConst = cfg.Mentality;
member.ResponseConst = cfg.Response;
member.PositioningConst = cfg.Positioning;
member.HandControlConst = cfg.HandControl;
member.AccelerationConst = cfg.Acceleration;
}
public static bool Update(NbManagerbuffmemberEntity nbManagerbuffmemberEntity, DbTransaction trans = null, string zoneId = "")
{
var provider = new NbManagerbuffmemberProvider(zoneId);
return(provider.Update(nbManagerbuffmemberEntity, trans));
}
public static double AsKpiNew(NbManagerbuffmemberEntity buffMember, int index, int formationId)
{
double kpi = 0;
double memberKpi = 0;
string playerPosition = "";
var player = CacheFactory.PlayersdicCache.GetPlayer(buffMember.Pid);
if (player == null)
{
return(0);
}
//计算位置适应
if (formationId > 0)
{
try
{
var formationList = CacheFactory.FormationCache.GetFormationDetail(formationId);
if (formationList != null && formationList.Count > index)
{
var formation = formationList[index];
playerPosition = formation.SpecificPointDesc.Trim();
if (player.PositionDesc.Length > 0)
{
if (player.AllPosition.IndexOf(playerPosition) < 0) //位置不适应
{
CheckBuff(buffMember, playerPosition.Trim(), player.PositionDesc.Trim());
}
}
}
}
catch (Exception ex)
{
SystemlogMgr.Error("KPI", ex);
}
}
switch (playerPosition)
{
case "GK":
kpi = buffMember.TotalResponse + buffMember.TotalPositioning + buffMember.TotalHandControl;
break;
case "CB":
case "LB":
case "RB":
kpi = (buffMember.TotalBalance + buffMember.TotalPhysique + buffMember.TotalPower) * 0.4
+
(buffMember.TotalAggression + buffMember.TotalDisturb + buffMember.TotalInterception) * 0.6;
break;
case "LM":
case "RM":
case "CDM":
case "CAM":
kpi = (buffMember.TotalDribble + buffMember.TotalPass + buffMember.TotalMentality) * 0.6
+ (buffMember.TotalSpeed + buffMember.TotalShoot + buffMember.TotalFreeKick) * 0.2
+ (buffMember.TotalBalance + buffMember.TotalPhysique + buffMember.TotalPower) * 0.2;
break;
case "CF":
kpi = (buffMember.TotalSpeed + buffMember.TotalShoot + buffMember.TotalFreeKick) * 0.6
+ (buffMember.TotalBalance + buffMember.TotalPhysique + buffMember.TotalPower) * 0.2
+ (buffMember.TotalDribble + buffMember.TotalPass + buffMember.TotalMentality) * 0.2;
break;
}
switch (player.PositionDesc)
{
case "CF":
memberKpi = (buffMember.TotalSpeed + buffMember.TotalShoot + buffMember.TotalBalance +
buffMember.TotalDribble + buffMember.TotalMentality) / 5;
break;
case "CDM": //抢断，控球，传球，力量，侵略性
memberKpi = (buffMember.TotalInterception + buffMember.TotalDribble + buffMember.TotalPass +
buffMember.TotalPower + buffMember.TotalAggression) / 5;
break;
case "CAM":
memberKpi = (buffMember.TotalShoot + buffMember.TotalBalance + buffMember.TotalDribble +
buffMember.TotalPass) / 4;
break;
case "LM":
case "RM":
memberKpi = (buffMember.TotalSpeed + buffMember.TotalBalance + buffMember.TotalDribble +
buffMember.TotalPass + buffMember.TotalMentality) / 5;
break;
case "CB":
memberKpi = (buffMember.TotalPhysique + buffMember.TotalPower + buffMember.TotalAggression +
buffMember.TotalDisturb + buffMember.TotalInterception) / 5;
break;
case "LB":
case "RB": //控制，传球，干扰，抢断，侵略性
memberKpi = (buffMember.TotalBalance + buffMember.TotalPass + buffMember.TotalDisturb +
buffMember.TotalInterception + buffMember.TotalAggression) / 5;
break;
case "GK":
memberKpi = (buffMember.TotalHandControl + buffMember.TotalPositioning +
buffMember.TotalResponse) / 3;
break;
}
buffMember.Kpi = Convert.ToInt32(memberKpi);
return(buffMember.IsMain ? kpi : 0);
}
/// <summary>
/// 带事务的Update
/// </summary>
/// <param name="entity"></param>
/// <param name="trans">The trans.</param>
/// <returns></returns>
/// <remarks>2016/4/22 15:12:23</remarks>
public bool Update(NbManagerbuffmemberEntity entity, DbTransaction trans = null)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_NbManagerbuffmember_Update");
database.AddInParameter(commandWrapper, "@Id", DbType.Int64, entity.Id);
database.AddInParameter(commandWrapper, "@ManagerId", DbType.Guid, entity.ManagerId);
database.AddInParameter(commandWrapper, "@Tid", DbType.Guid, entity.Tid);
database.AddInParameter(commandWrapper, "@Pid", DbType.Int32, entity.Pid);
database.AddInParameter(commandWrapper, "@PPos", DbType.Int32, entity.PPos);
database.AddInParameter(commandWrapper, "@PPosOn", DbType.Int32, entity.PPosOn);
database.AddInParameter(commandWrapper, "@Kpi", DbType.Int32, entity.Kpi);
database.AddInParameter(commandWrapper, "@Level", DbType.Int32, entity.Level);
database.AddInParameter(commandWrapper, "@Strength", DbType.Int32, entity.Strength);
database.AddInParameter(commandWrapper, "@ShowOrder", DbType.Int32, entity.ShowOrder);
database.AddInParameter(commandWrapper, "@IsMain", DbType.Boolean, entity.IsMain);
database.AddInParameter(commandWrapper, "@ReadySkills", DbType.AnsiString, entity.ReadySkills);
database.AddInParameter(commandWrapper, "@LiveSkills", DbType.AnsiString, entity.LiveSkills);
database.AddInParameter(commandWrapper, "@SpeedConst", DbType.Double, entity.SpeedConst);
database.AddInParameter(commandWrapper, "@SpeedCount", DbType.Double, entity.SpeedCount);
database.AddInParameter(commandWrapper, "@ShootConst", DbType.Double, entity.ShootConst);
database.AddInParameter(commandWrapper, "@ShootCount", DbType.Double, entity.ShootCount);
database.AddInParameter(commandWrapper, "@FreeKickConst", DbType.Double, entity.FreeKickConst);
database.AddInParameter(commandWrapper, "@FreeKickCount", DbType.Double, entity.FreeKickCount);
database.AddInParameter(commandWrapper, "@BalanceConst", DbType.Double, entity.BalanceConst);
database.AddInParameter(commandWrapper, "@BalanceCount", DbType.Double, entity.BalanceCount);
database.AddInParameter(commandWrapper, "@PhysiqueConst", DbType.Double, entity.PhysiqueConst);
database.AddInParameter(commandWrapper, "@PhysiqueCount", DbType.Double, entity.PhysiqueCount);
database.AddInParameter(commandWrapper, "@PowerConst", DbType.Double, entity.PowerConst);
database.AddInParameter(commandWrapper, "@PowerCount", DbType.Double, entity.PowerCount);
database.AddInParameter(commandWrapper, "@AggressionConst", DbType.Double, entity.AggressionConst);
database.AddInParameter(commandWrapper, "@AggressionCount", DbType.Double, entity.AggressionCount);
database.AddInParameter(commandWrapper, "@DisturbConst", DbType.Double, entity.DisturbConst);
database.AddInParameter(commandWrapper, "@DisturbCount", DbType.Double, entity.DisturbCount);
database.AddInParameter(commandWrapper, "@InterceptionConst", DbType.Double, entity.InterceptionConst);
database.AddInParameter(commandWrapper, "@InterceptionCount", DbType.Double, entity.InterceptionCount);
database.AddInParameter(commandWrapper, "@DribbleConst", DbType.Double, entity.DribbleConst);
database.AddInParameter(commandWrapper, "@DribbleCount", DbType.Double, entity.DribbleCount);
database.AddInParameter(commandWrapper, "@PassConst", DbType.Double, entity.PassConst);
database.AddInParameter(commandWrapper, "@PassCount", DbType.Double, entity.PassCount);
database.AddInParameter(commandWrapper, "@MentalityConst", DbType.Double, entity.MentalityConst);
database.AddInParameter(commandWrapper, "@MentalityCount", DbType.Double, entity.MentalityCount);
database.AddInParameter(commandWrapper, "@ResponseConst", DbType.Double, entity.ResponseConst);
database.AddInParameter(commandWrapper, "@ResponseCount", DbType.Double, entity.ResponseCount);
database.AddInParameter(commandWrapper, "@PositioningConst", DbType.Double, entity.PositioningConst);
database.AddInParameter(commandWrapper, "@PositioningCount", DbType.Double, entity.PositioningCount);
database.AddInParameter(commandWrapper, "@HandControlConst", DbType.Double, entity.HandControlConst);
database.AddInParameter(commandWrapper, "@HandControlCount", DbType.Double, entity.HandControlCount);
database.AddInParameter(commandWrapper, "@AccelerationConst", DbType.Double, entity.AccelerationConst);
database.AddInParameter(commandWrapper, "@AccelerationCount", DbType.Double, entity.AccelerationCount);
database.AddInParameter(commandWrapper, "@BounceConst", DbType.Double, entity.BounceConst);
database.AddInParameter(commandWrapper, "@BounceCount", DbType.Double, entity.BounceCount);
database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime);
database.AddInParameter(commandWrapper, "@RowVersion", DbType.Binary, entity.RowVersion);
int results = 0;
if (trans != null)
{
results = database.ExecuteNonQuery(commandWrapper, trans);
}
else
{
results = database.ExecuteNonQuery(commandWrapper);
}
return(Convert.ToBoolean(results));
}
