/// <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); } }