/// <summary>
/// 增加一条数据
/// </summary>
public string Add(Model.t_ind_tweetslist model)
{
return(dal.Add(model));
}
private void InitRequest()
{
FetchKeyGUID("ID", lblTweetID);
string tweetID = lblTweetID.Text.Trim();
if (tweetID != null && LTP.Common.CheckInput.CheckGUID(tweetID))
{
tweetModel = tweetlistBll.GetModel(tweetID);
if (tweetModel != null)
{
TweetStatusID.Text = tweetModel.StatusID;
CreatedByUser.Text = tweetModel.CreatedByUser;
AccountCreatedDate.Text = tweetModel.AccountCreatedDate.ToString();
AccountAge.Text = tweetModel.AccountAge;
FollowersCount.Text = tweetModel.FollowersCount;
FriendsCount.Text = tweetModel.FriendsCount;
FavoritesCount.Text = tweetModel.FavoritesCount;
StatusesCount.Text = tweetModel.StatusesCount;
TweetContent.Text = tweetModel.TweetContent;
RetweetCount.Text = tweetModel.RetweetCount;
FavoriteCount.Text = tweetModel.FavoriteCount;
UserMentionsCount.Text = tweetModel.UserMentionsCount;
UrlsCount.Text = tweetModel.UrlsCount;
if (tweetModel.knnResult != "")
{
if (tweetModel.knnResult == "spammer")
{
knnRs = "-1";
knn.Text = "Spammer";
spamsCount++;
}
if (tweetModel.knnResult == "non-spammer")
{
knnRs = "1";
knn.Text = "Non-spammer";
non_spamsCount++;
}
}
else
{
knnRs = "0";
knn.Text = "Undetected";
}
if (tweetModel.kknnResult != "")
{
if (tweetModel.kknnResult == "spammer")
{
kknnRs = "-1";
kknn.Text = "Spammer";
spamsCount++;
}
if (tweetModel.kknnResult == "non-spammer")
{
kknnRs = "1";
kknn.Text = "Non-spammer";
non_spamsCount++;
}
}
else
{
kknnRs = "0";
kknn.Text = "Undetected";
}
if (tweetModel.naivebayesResult != "")
{
if (tweetModel.naivebayesResult == "spammer")
{
nbRs = "-1";
nb.Text = "Spammer";
spamsCount++;
}
if (tweetModel.naivebayesResult == "non-spammer")
{
nbRs = "1";
nb.Text = "Non-spammer";
non_spamsCount++;
}
}
else
{
nbRs = "0";
nb.Text = "Undetected";
}
if (tweetModel.randomforestResult != "")
{
if (tweetModel.randomforestResult == "spammer")
{
rfRs = "-1";
rf.Text = "Spammer";
spamsCount++;
}
if (tweetModel.randomforestResult == "non-spammer")
{
rfRs = "1";
rf.Text = "Non-spammer";
non_spamsCount++;
}
}
else
{
rfRs = "0";
rf.Text = "Undetected";
}
if (tweetModel.c50Result != "")
{
if (tweetModel.c50Result == "spammer")
{
c50Rs = "-1";
c50.Text = "Spammer";
spamsCount++;
}
if (tweetModel.c50Result == "non-spammer")
{
c50Rs = "1";
c50.Text = "Non-spammer";
non_spamsCount++;
}
}
else
{
c50Rs = "0";
c50.Text = "Undetected";
}
if (tweetModel.gbmResult != "")
{
if (tweetModel.gbmResult == "spammer")
{
gbmRs = "-1";
gbm.Text = "Spammer";
spamsCount++;
}
if (tweetModel.gbmResult == "non-spammer")
{
gbmRs = "1";
gbm.Text = "Non-spammer";
non_spamsCount++;
}
}
else
{
gbmRs = "0";
gbm.Text = "Undetected";
}
if (tweetModel.logisticregressionResult != "")
{
if (tweetModel.logisticregressionResult == "spammer")
{
logrRs = "-1";
logr.Text = "Spammer";
spamsCount++;
}
if (tweetModel.logisticregressionResult == "non-spammer")
{
logrRs = "1";
logr.Text = "Non-spammer";
non_spamsCount++;
}
}
else
{
logrRs = "0";
logr.Text = "Undetected";
}
if (tweetModel.neuralnetworkResult != "")
{
if (tweetModel.neuralnetworkResult == "spammer")
{
nnetRs = "-1";
nnet.Text = "Spammer";
spamsCount++;
}
if (tweetModel.neuralnetworkResult == "non-spammer")
{
nnetRs = "1";
nnet.Text = "Non-spammer";
non_spamsCount++;
}
}
else
{
nnetRs = "0";
nnet.Text = "Undetected";
}
if ((spamsCount == 0) && (non_spamsCount == 0))
{
proOfUndetected.Text = "0";
}
proOfSpams.Text = spamsCount.ToString();
proOfNonSpams.Text = non_spamsCount.ToString();
}
else
{
LTP.Common.WindowClass.WindowBack("Failed to acquire the tweet model!");
}
}
else
{
LTP.Common.WindowClass.WindowBack("The Tweet ID is NULL or invalid!");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.t_ind_tweetslist DataRowToModel(DataRow row)
{
Model.t_ind_tweetslist model = new Model.t_ind_tweetslist();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["StatusID"] != null)
{
model.StatusID = row["StatusID"].ToString();
}
if (row["CreatedByUser"] != null)
{
model.CreatedByUser = row["CreatedByUser"].ToString();
}
if (row["AccountCreatedDate"] != null && row["AccountCreatedDate"].ToString() != "")
{
model.AccountCreatedDate = DateTime.Parse(row["AccountCreatedDate"].ToString());
}
if (row["TweetCreatedDate"] != null && row["TweetCreatedDate"].ToString() != "")
{
model.TweetCreatedDate = DateTime.Parse(row["TweetCreatedDate"].ToString());
}
if (row["AccountAge"] != null)
{
model.AccountAge = row["AccountAge"].ToString();
}
if (row["FollowersCount"] != null)
{
model.FollowersCount = row["FollowersCount"].ToString();
}
if (row["FriendsCount"] != null)
{
model.FriendsCount = row["FriendsCount"].ToString();
}
if (row["FavoritesCount"] != null)
{
model.FavoritesCount = row["FavoritesCount"].ToString();
}
if (row["ListedCount"] != null)
{
model.ListedCount = row["ListedCount"].ToString();
}
if (row["StatusesCount"] != null)
{
model.StatusesCount = row["StatusesCount"].ToString();
}
if (row["RetweetCount"] != null)
{
model.RetweetCount = row["RetweetCount"].ToString();
}
if (row["FavoriteCount"] != null)
{
model.FavoriteCount = row["FavoriteCount"].ToString();
}
if (row["HashTapsCount"] != null)
{
model.HashTapsCount = row["HashTapsCount"].ToString();
}
if (row["UserMentionsCount"] != null)
{
model.UserMentionsCount = row["UserMentionsCount"].ToString();
}
if (row["UrlsCount"] != null)
{
model.UrlsCount = row["UrlsCount"].ToString();
}
if (row["NumberOfChar"] != null)
{
model.NumberOfChar = row["NumberOfChar"].ToString();
}
if (row["NumberOfDigits"] != null)
{
model.NumberOfDigits = row["NumberOfDigits"].ToString();
}
if (row["TweetContent"] != null)
{
model.TweetContent = row["TweetContent"].ToString();
}
if (row["IsSpam"] != null)
{
model.IsSpam = row["IsSpam"].ToString();
}
if (row["knnResult"] != null)
{
model.knnResult = row["knnResult"].ToString();
}
if (row["kknnResult"] != null)
{
model.kknnResult = row["kknnResult"].ToString();
}
if (row["naivebayesResult"] != null)
{
model.naivebayesResult = row["naivebayesResult"].ToString();
}
if (row["randomforestResult"] != null)
{
model.randomforestResult = row["randomforestResult"].ToString();
}
if (row["c50Result"] != null)
{
model.c50Result = row["c50Result"].ToString();
}
if (row["gbmResult"] != null)
{
model.gbmResult = row["gbmResult"].ToString();
}
if (row["logisticregressionResult"] != null)
{
model.logisticregressionResult = row["logisticregressionResult"].ToString();
}
if (row["neuralnetworkResult"] != null)
{
model.neuralnetworkResult = row["neuralnetworkResult"].ToString();
}
if (row["ProbabilityOfSpam"] != null)
{
model.ProbabilityOfSpam = row["ProbabilityOfSpam"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public string Add(Model.t_ind_tweetslist model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_ind_tweetslist(");
strSql.Append("ID,StatusID,CreatedByUser,AccountCreatedDate,TweetCreatedDate,AccountAge,FollowersCount,FriendsCount,FavoritesCount,ListedCount,StatusesCount,RetweetCount,FavoriteCount,HashTapsCount,UserMentionsCount,UrlsCount,NumberOfChar,NumberOfDigits,TweetContent,IsSpam,knnResult,kknnResult,naivebayesResult,randomforestResult,c50Result,gbmResult,logisticregressionResult,neuralnetworkResult,ProbabilityOfSpam)");
strSql.Append(" values (");
strSql.Append("@ID,@StatusID,@CreatedByUser,@AccountCreatedDate,@TweetCreatedDate,@AccountAge,@FollowersCount,@FriendsCount,@FavoritesCount,@ListedCount,@StatusesCount,@RetweetCount,@FavoriteCount,@HashTapsCount,@UserMentionsCount,@UrlsCount,@NumberOfChar,@NumberOfDigits,@TweetContent,@IsSpam,@knnResult,@kknnResult,@naivebayesResult,@randomforestResult,@c50Result,@gbmResult,@logisticregressionResult,@neuralnetworkResult,@ProbabilityOfSpam)");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 36),
new MySqlParameter("@StatusID", MySqlDbType.VarChar, 36),
new MySqlParameter("@CreatedByUser", MySqlDbType.VarChar, 255),
new MySqlParameter("@AccountCreatedDate", MySqlDbType.DateTime),
new MySqlParameter("@TweetCreatedDate", MySqlDbType.DateTime),
new MySqlParameter("@AccountAge", MySqlDbType.VarChar, 50),
new MySqlParameter("@FollowersCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@FriendsCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@FavoritesCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@ListedCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@StatusesCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@RetweetCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@FavoriteCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@HashTapsCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@UserMentionsCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@UrlsCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@NumberOfChar", MySqlDbType.VarChar, 50),
new MySqlParameter("@NumberOfDigits", MySqlDbType.VarChar, 50),
new MySqlParameter("@TweetContent", MySqlDbType.MediumText),
new MySqlParameter("@IsSpam", MySqlDbType.VarChar, 20),
new MySqlParameter("@knnResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@kknnResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@naivebayesResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@randomforestResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@c50Result", MySqlDbType.VarChar, 20),
new MySqlParameter("@gbmResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@logisticregressionResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@neuralnetworkResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@ProbabilityOfSpam", MySqlDbType.VarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.StatusID;
parameters[2].Value = model.CreatedByUser;
parameters[3].Value = model.AccountCreatedDate;
parameters[4].Value = model.TweetCreatedDate;
parameters[5].Value = model.AccountAge;
parameters[6].Value = model.FollowersCount;
parameters[7].Value = model.FriendsCount;
parameters[8].Value = model.FavoritesCount;
parameters[9].Value = model.ListedCount;
parameters[10].Value = model.StatusesCount;
parameters[11].Value = model.RetweetCount;
parameters[12].Value = model.FavoriteCount;
parameters[13].Value = model.HashTapsCount;
parameters[14].Value = model.UserMentionsCount;
parameters[15].Value = model.UrlsCount;
parameters[16].Value = model.NumberOfChar;
parameters[17].Value = model.NumberOfDigits;
parameters[18].Value = model.TweetContent;
parameters[19].Value = model.IsSpam;
parameters[20].Value = model.knnResult;
parameters[21].Value = model.kknnResult;
parameters[22].Value = model.naivebayesResult;
parameters[23].Value = model.randomforestResult;
parameters[24].Value = model.c50Result;
parameters[25].Value = model.gbmResult;
parameters[26].Value = model.logisticregressionResult;
parameters[27].Value = model.neuralnetworkResult;
parameters[28].Value = model.ProbabilityOfSpam;
int result = 0;
try
{
result = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
}
catch { }
if (result > 0)
{
return("");
}
else
{
return("Failed to add tweet's data to database, please contact system admin!");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.t_ind_tweetslist model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update t_ind_tweetslist set ");
strSql.Append("StatusID=@StatusID,");
strSql.Append("CreatedByUser=@CreatedByUser,");
strSql.Append("AccountCreatedDate=@AccountCreatedDate,");
strSql.Append("TweetCreatedDate=@TweetCreatedDate,");
strSql.Append("AccountAge=@AccountAge,");
strSql.Append("FollowersCount=@FollowersCount,");
strSql.Append("FriendsCount=@FriendsCount,");
strSql.Append("FavoritesCount=@FavoritesCount,");
strSql.Append("ListedCount=@ListedCount,");
strSql.Append("StatusesCount=@StatusesCount,");
strSql.Append("RetweetCount=@RetweetCount,");
strSql.Append("FavoriteCount=@FavoriteCount,");
strSql.Append("HashTapsCount=@HashTapsCount,");
strSql.Append("UserMentionsCount=@UserMentionsCount,");
strSql.Append("UrlsCount=@UrlsCount,");
strSql.Append("NumberOfChar=@NumberOfChar,");
strSql.Append("NumberOfDigits=@NumberOfDigits,");
strSql.Append("TweetContent=@TweetContent,");
strSql.Append("IsSpam=@IsSpam,");
strSql.Append("knnResult=@knnResult,");
strSql.Append("kknnResult=@kknnResult,");
strSql.Append("naivebayesResult=@naivebayesResult,");
strSql.Append("randomforestResult=@randomforestResult,");
strSql.Append("c50Result=@c50Result,");
strSql.Append("gbmResult=@gbmResult,");
strSql.Append("logisticregressionResult=@logisticregressionResult,");
strSql.Append("neuralnetworkResult=@neuralnetworkResult,");
strSql.Append("ProbabilityOfSpam=@ProbabilityOfSpam");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@StatusID", MySqlDbType.VarChar, 36),
new MySqlParameter("@CreatedByUser", MySqlDbType.VarChar, 255),
new MySqlParameter("@AccountCreatedDate", MySqlDbType.DateTime),
new MySqlParameter("@TweetCreatedDate", MySqlDbType.DateTime),
new MySqlParameter("@AccountAge", MySqlDbType.VarChar, 50),
new MySqlParameter("@FollowersCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@FriendsCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@FavoritesCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@ListedCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@StatusesCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@RetweetCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@FavoriteCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@HashTapsCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@UserMentionsCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@UrlsCount", MySqlDbType.VarChar, 50),
new MySqlParameter("@NumberOfChar", MySqlDbType.VarChar, 50),
new MySqlParameter("@NumberOfDigits", MySqlDbType.VarChar, 50),
new MySqlParameter("@TweetContent", MySqlDbType.MediumText),
new MySqlParameter("@IsSpam", MySqlDbType.VarChar, 20),
new MySqlParameter("@knnResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@kknnResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@naivebayesResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@randomforestResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@c50Result", MySqlDbType.VarChar, 20),
new MySqlParameter("@gbmResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@logisticregressionResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@neuralnetworkResult", MySqlDbType.VarChar, 20),
new MySqlParameter("@ProbabilityOfSpam", MySqlDbType.VarChar, 50),
new MySqlParameter("@ID", MySqlDbType.VarChar, 36)
};
parameters[0].Value = model.StatusID;
parameters[1].Value = model.CreatedByUser;
parameters[2].Value = model.AccountCreatedDate;
parameters[3].Value = model.TweetCreatedDate;
parameters[4].Value = model.AccountAge;
parameters[5].Value = model.FollowersCount;
parameters[6].Value = model.FriendsCount;
parameters[7].Value = model.FavoritesCount;
parameters[8].Value = model.ListedCount;
parameters[9].Value = model.StatusesCount;
parameters[10].Value = model.RetweetCount;
parameters[11].Value = model.FavoriteCount;
parameters[12].Value = model.HashTapsCount;
parameters[13].Value = model.UserMentionsCount;
parameters[14].Value = model.UrlsCount;
parameters[15].Value = model.NumberOfChar;
parameters[16].Value = model.NumberOfDigits;
parameters[17].Value = model.TweetContent;
parameters[18].Value = model.IsSpam;
parameters[19].Value = model.knnResult;
parameters[20].Value = model.kknnResult;
parameters[21].Value = model.naivebayesResult;
parameters[22].Value = model.randomforestResult;
parameters[23].Value = model.c50Result;
parameters[24].Value = model.gbmResult;
parameters[25].Value = model.logisticregressionResult;
parameters[26].Value = model.neuralnetworkResult;
parameters[27].Value = model.ProbabilityOfSpam;
parameters[28].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
