public void Insert(IDbConnection cn, YZMessageVote vote) { using (OracleCommand cmd = new OracleCommand()) { cmd.Connection = cn as OracleConnection; cmd.BindByName = true; cmd.CommandText = "SELECT BPMSEQ_YZAPPCOMMUNICATIONVOTE.NEXTVAL FROM DUAL"; vote.id = System.Convert.ToInt32(cmd.ExecuteScalar()); StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO YZAPPCOMMUNICATIONVOTE("); sb.Append("ID,"); sb.Append("MESSAGEID,"); sb.Append("\"UID\","); sb.Append("\"DATE\") "); sb.Append("VALUES("); sb.Append(":ID,"); sb.Append(":MESSAGEID,"); sb.Append(":PM_UID,"); sb.Append(":DATE1)"); cmd.CommandText = sb.ToString(); cmd.Parameters.Add(":ID", OracleDbType.Int32).Value = vote.id; cmd.Parameters.Add(":MESSAGEID", OracleDbType.NVarchar2).Value = vote.messageid; cmd.Parameters.Add(":PM_UID", OracleDbType.NVarchar2).Value = this.Convert(vote.uid, false); cmd.Parameters.Add(":DATE1", OracleDbType.Date).Value = this.Convert(vote.date, false); cmd.ExecuteNonQuery(); } }
public virtual object Praise(HttpContext context) { YZRequest request = new YZRequest(context); int messageid = request.GetInt32("messageid"); string uid = YZAuthHelper.LoginUserAccount; using (IYZDbProvider provider = YZDbProviderManager.DefaultProvider) { using (IDbConnection cn = provider.OpenConnection()) { if (SocialManager.HasVoted(provider, cn, messageid, uid)) { SocialManager.DeleteVote(provider, cn, messageid, uid); } else { YZMessageVote vote = new YZMessageVote(); vote.messageid = messageid; vote.uid = uid; vote.date = DateTime.Today; SocialManager.Insert(provider, cn, vote); } return(new { Praised = SocialManager.GetVotePraisedCount(provider, cn, messageid) }); } } }
public void Insert(IDbConnection cn, YZMessageVote vote) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cn as SqlConnection; StringBuilder sb = new StringBuilder(); sb.Append("SET NOCOUNT ON;"); sb.Append("INSERT INTO YZAppCommunicationVote("); sb.Append("messageid,"); sb.Append("uid,"); sb.Append("date) "); sb.Append("VALUES("); sb.Append("@messageid,"); sb.Append("@uid,"); sb.Append("@date);"); sb.Append("SELECT SCOPE_IDENTITY()"); cmd.CommandText = sb.ToString(); cmd.Parameters.Add("@messageid", SqlDbType.NVarChar).Value = vote.messageid; cmd.Parameters.Add("@uid", SqlDbType.NVarChar).Value = this.Convert(vote.uid, false); cmd.Parameters.Add("@date", SqlDbType.DateTime).Value = this.Convert(vote.date, false); vote.id = System.Convert.ToInt32(cmd.ExecuteScalar()); } }