protected void Button1_Click(object sender, EventArgs e)
{
int Quality = Convert.ToInt32(DropDownList1.SelectedValue);
int Number = Convert.ToInt32(DropDownList2.SelectedValue);
int Atmosphere = Convert.ToInt32(DropDownList3.SelectedValue);
int Activities = Convert.ToInt32(DropDownList4.SelectedValue);
DtCms.BLL.Societies societies = new DtCms.BLL.Societies();
DtCms.Model.Societies Societiesmodel = new DtCms.Model.Societies();
Societiesmodel = societies.GetModel(Id);
DtCms.Model.Score score = new DtCms.Model.Score();
score.Quality = Quality;
score.Number = Number;
score.Atmosphere = Atmosphere;
score.SocietiesName = Societiesmodel.SocietiesName;
score.Activities = Activities;
DtCms.BLL.Score bll = new DtCms.BLL.Score();
bll.Add(score);
Response.Write("<script>alert('艺术团活动评分成功啦！');</script>");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.Score model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_Score(");
strSql.Append("Quality,Number,Atmosphere,Activities,SocietiesName,AddTime)");
strSql.Append(" values (");
strSql.Append("@Quality,@Number,@Atmosphere,@Activities,@SocietiesName,@AddTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Quality", SqlDbType.Int),
new SqlParameter("@Number", SqlDbType.Int),
new SqlParameter("@Atmosphere", SqlDbType.Int),
new SqlParameter("@Activities", SqlDbType.Int),
new SqlParameter("@SocietiesName", SqlDbType.VarChar),
new SqlParameter("@AddTime", SqlDbType.DateTime)
};
parameters[0].Value = model.Quality;
parameters[1].Value = model.Number;
parameters[2].Value = model.Atmosphere;
parameters[3].Value = model.Activities;
parameters[4].Value = model.SocietiesName;
parameters[5].Value = model.AddTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.Score model)
{
return(dal.Add(model));
}
