userpingjia.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data.SqlClient;
using System.Data;

public partial class userpingjia : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        string fenshu = "";
        if (this.RadioButton1.Checked == true) 
        {
            fenshu = "好评";
        }
        if (this.RadioButton2.Checked == true)
        {
            fenshu = "中评";
        }
        if (this.RadioButton3.Checked == true)
        {
            fenshu = "差评";
        }
            //设置Sql
            StringBuilder strSql = new StringBuilder();
            strSql.Append(@"insert into ProductAssess (bid,oid,lname,memo,fenshu,atime ) ");
            strSql.Append(@" values (@bid,@oid,@lname,@memo,@fenshu,@atime)");

            //设置参数
            SqlParameter[] parameters = new SqlParameter[] {
            new SqlParameter("@bid", SqlDbType.Int,4),
            new SqlParameter("@oid", SqlDbType.VarChar,50),
            new SqlParameter("@lname", SqlDbType.VarChar,50),
            new SqlParameter("@memo", SqlDbType.VarChar,500),
                        new SqlParameter("@fenshu", SqlDbType.VarChar,50),
            new SqlParameter("@atime", SqlDbType.DateTime,8)        };

            parameters[0].Value = Request.QueryString["bid"];
            parameters[1].Value = Session["oid"].ToString();
            parameters[2].Value = Session["lname"].ToString();
            parameters[3].Value = txt_memo.Text;
            parameters[4].Value = fenshu;
            parameters[5].Value = DateTime.Now;

            //提交到数据库
            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            DbHelperSQL.ExecuteSql("update ordersMore set Flag='已评价' where  id=" + Request.QueryString["id"] + "  ");

        MessageBox.ShowAndRedirect(this, " 评价成功！", "userOrderInfo.aspx?id=" + Session["oid"].ToString() + "");
    }
}