public bool Insert(AppCommentSummaryEntity entity)
{
#region CommandText
string commandText = @" INSERT INTO appcommentsummary (
AppId,
CommentTimes,
ScoreTimes,
ScoreSum,
ScoreAvg,
ScoreTimes1,
ScoreTimes2,
ScoreTimes3,
ScoreTimes4,
ScoreTimes5
)
VALUES
(
@AppId,
@CommentTimes,
@ScoreTimes,
@ScoreSum,
@ScoreAvg,
@ScoreTimes1,
@ScoreTimes2,
@ScoreTimes3,
@ScoreTimes4,
@ScoreTimes5
);";
#endregion
return(ExecuteNonQuery(commandText, entity));
}
private bool ExecuteNonQuery(string commandText, AppCommentSummaryEntity entity)
{
List <MySqlParameter> paramsList = GetMySqlParameters(entity);
int result = MySqlHelper.ExecuteNonQuery(this.ConnectionString, commandText, paramsList.ToArray());
return(base.ExecuteStatus(result));
}
private List <MySqlParameter> GetMySqlParameters(AppCommentSummaryEntity entity)
{
List <MySqlParameter> paramsList = new List <MySqlParameter>()
{
new MySqlParameter("@CommentTimes", entity.CommentTimes),
new MySqlParameter("@ScoreTimes", entity.ScoreTimes),
new MySqlParameter("@ScoreSum", entity.ScoreSum),
new MySqlParameter("@ScoreAvg", entity.ScoreAvg),
new MySqlParameter("@ScoreTimes1", entity.ScoreTimes1),
new MySqlParameter("@ScoreTimes2", entity.ScoreTimes2),
new MySqlParameter("@ScoreTimes3", entity.ScoreTimes3),
new MySqlParameter("@ScoreTimes4", entity.ScoreTimes4),
new MySqlParameter("@ScoreTimes5", entity.ScoreTimes5),
new MySqlParameter("@AppId", entity.AppID)
};
return(paramsList);
}
/// <summary>
/// 修改应用评星
/// </summary>
/// <param name="appID"></param>
/// <param name="DownTimes"></param>
/// <param name="RecommLevel"></param>
public void UpdateSummary(int appID, int DownTimes, int RecommLevel)
{
Random ran = new Random();
double count = 0;
if (DownTimes > 1000)
{
double ttimes = 0;
double tcount = 0;
if (DownTimes > 1100)
{
ttimes = ran.Next(800, 1100);
}
else
{
ttimes = ran.Next(800, 1000);
}
tcount = DownTimes / ttimes;
double scale_random = 0;
if (tcount < 5)
{
scale_random = ran.Next(10, 20) / 10.0;
}
else
{
scale_random = ran.Next(7, 15) / 10.0;
}
count = tcount * scale_random;
if (count == 1)
{
count = ran.Next(1, 9);
}
}
else
{
count = ran.Next(5, 20);
}
if (count > 10)
{
string [] scales = new string[5];
if (count > 5000 && count <= 10000 && RecommLevel < 6)
{
scales = get_scale(6);
}
if (count > 10000 && RecommLevel < 6)
{
scales = get_scale(7);
}
else
{
scales = get_scale(RecommLevel);
}
int ScoreTimes5 = getInt(count * double.Parse(scales[0]), "floor");
int ScoreTimes4 = getInt(count * double.Parse(scales[1]), "floor");
int ScoreTimes3 = getInt(count * double.Parse(scales[2]), "floor");
int ScoreTimes2 = getInt(count * double.Parse(scales[3]), "floor");
int ScoreTimes1 = getInt(count * double.Parse(scales[4]), "floor");
int ScoreTimes = ScoreTimes5 + ScoreTimes4 + ScoreTimes3 + ScoreTimes2 + ScoreTimes1;
int ScoreSum = ScoreTimes5 * 5 + ScoreTimes4 * 4 + ScoreTimes3 * 3 + ScoreTimes2 * 2 + ScoreTimes1;
int ScoreAvg = getInt(((double)ScoreSum * 2 / (double)ScoreTimes), "ceil");
AppCommentSummaryEntity entity = new AppCommentSummaryEntity()
{
AppID = appID, CommentTimes = 0, ScoreSum = ScoreSum, ScoreTimes = ScoreTimes, ScoreAvg = ScoreAvg, ScoreTimes1 = ScoreTimes1, ScoreTimes2 = ScoreTimes2, ScoreTimes3 = ScoreTimes3, ScoreTimes4 = ScoreTimes4, ScoreTimes5 = ScoreTimes5
};
if (Delete(appID))
{
Insert(entity);
}
}
else
{
int ScoreTimes5 = getInt((count * 0.7), "floor");
int ScoreTimes4 = getInt((count * 0.2), "floor");
int ScoreTimes3 = getInt((count * 0.1), "floor");
if (ScoreTimes5 == 0)
{
ScoreTimes5 = Convert.ToInt32(count);
}
int ScoreTimes = ScoreTimes5 + ScoreTimes4 + ScoreTimes3;
int ScoreSum = ScoreTimes5 * 5 + ScoreTimes4 * 4 + ScoreTimes3 * 3;
int ScoreAvg = getInt(((double)ScoreSum * 2 / (double)ScoreTimes), "ceil");
AppCommentSummaryEntity entity = new AppCommentSummaryEntity()
{
AppID = appID, CommentTimes = 0, ScoreSum = ScoreSum, ScoreTimes = ScoreTimes, ScoreAvg = ScoreAvg, ScoreTimes1 = 0, ScoreTimes2 = 0, ScoreTimes3 = ScoreTimes3, ScoreTimes4 = ScoreTimes4, ScoreTimes5 = ScoreTimes5
};
if (Delete(appID))
{
Insert(entity);
}
}
}
public bool Insert(AppCommentSummaryEntity entity)
{
return(new AppCommentSummaryDAL().Insert(entity));
}
