protected void ProcessAllInfoForOnePub(int publicationId) { ProcessPub.ProcessAllInfoForOnePubId(publicationId, false); int confirmId = ProcessPub.ConfirmOnePubByAuthorInitial(publicationId); ProcessPub.UpdateNameConfirm(publicationId, confirmId); }
protected void TreatInfoForOnePubId(int publicationId) { //string pmidStr = pmid.ToString(); string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString; SqlConnection myConnection = new SqlConnection(connectionStr); string sqlStatement; sqlStatement = "select count(*) as cnt from publication_processing where publication_id = " + publicationId.ToString(); SqlCommand commandFromProcessing = new SqlCommand(sqlStatement, myConnection); myConnection.Open(); int cnt = (int)commandFromProcessing.ExecuteScalar(); myConnection.Close(); if (cnt == 0) { ProcessPub.ProcessAllInfoForOnePubId(publicationId, false); int confirmId = ProcessPub.ConfirmOnePubByAuthorInitial(publicationId); ProcessPub.UpdateNameConfirm(publicationId, confirmId); } else if (cnt == 1) { ProcessPub.UpdateAllProcessInfoForOnePubId(publicationId); int confirmId = ProcessPub.ConfirmOnePubByAuthorInitial(publicationId); ProcessPub.UpdateNameConfirm(publicationId, confirmId); } else { //error } }
protected void btnProcessPmid_Click(object sender, EventArgs e) { string msg = ""; string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString; SqlConnection conn = new SqlConnection(connectionStr); string sqlStatement = "select publication_id from publication where pmid = " + txtPmid.Text; SqlCommand command = new SqlCommand(sqlStatement, conn); conn.Open(); int pubId = 0; object pubIdObj = (object)command.ExecuteScalar(); if (pubIdObj != null) { pubId = Convert.ToInt32(pubIdObj); } else { conn.Close(); msg = "Not found publication in database."; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + msg + "');", true); return; } conn.Close(); ProcessPub.ProcessAllInfoForOnePubId(pubId, true); msg = "processed."; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + msg + "');", true); }
protected void btnProcess_Click(object sender, EventArgs e) { //List<int> pubIdList = GetPubIdList(lastPubId).ToList(); List <int> pubIdList = GetNotProcessedPubIdList().ToList(); //ProcessPubList(pubIdList); //ConfirmByName(pubIdList); int totalConfirmedCnt = 0; int totalConflictCnt = 0; int totalUnknownCnt = 0; int confirmId = 0; foreach (int publicationId in pubIdList) { ProcessPub.ProcessAllInfoForOnePubId(publicationId, false); confirmId = ProcessPub.ConfirmOnePubByAuthorInitial(publicationId); ProcessPub.UpdateNameConfirm(publicationId, confirmId); if (confirmId == 1) { totalConfirmedCnt++; } else if (confirmId == 2) { totalConflictCnt++; } else { totalUnknownCnt++; } } int pubCnt = pubIdList.Count; string msg = "Among " + pubCnt.ToString() + " pubs, " + totalConfirmedCnt + " are name (initial) confirmed, " + totalConflictCnt.ToString() + " are name (initial) conflict, and " + totalUnknownCnt.ToString() + " are unknown."; ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + msg + "');", true); }