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