//后台增加
public int Insert(Culinfo Cull)
{
string sql = "insert into Cull values(@Cull_Name,@Cull_Img,@Cull_Content,@Dyn_ID,@Class_ID)";
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@Cull_Name", Cull.Cull_Name),
new SqlParameter("@Cull_Img", Cull.Cull_Img),
new SqlParameter("@Cull_Content", Cull.Cull_Content),
new SqlParameter("@Dyn_ID", Cull.Dyn_ID),
new SqlParameter("@Class_ID", Cull.Class_ID)
};
return(DBHelper.GetExcuteNonQuery(sql, sp));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (Label2.Text.Trim() == "")
{
Response.Write("<script>alert('照片不能为空!')</script>");
}
else
{
Culinfo Cull = new Culinfo();
Cull.Cull_Name = txtTitle.Text.Trim();
Cull.Cull_Content = CKEditorControl1.Text.Trim();
Cull.Cull_Img = Label2.Text;
//朝代
switch (DropDownList1.SelectedItem.ToString())
{
case "史前时代":
Cull.Dyn_ID = 1;
break;
case "夏商":
Cull.Dyn_ID = 2;
break;
case "春秋战国":
Cull.Dyn_ID = 3;
break;
case "秦汉":
Cull.Dyn_ID = 4;
break;
case "魏晋南北朝":
Cull.Dyn_ID = 5;
break;
case "隋唐":
Cull.Dyn_ID = 6;
break;
case "五代十国":
Cull.Dyn_ID = 7;
break;
case "宋":
Cull.Dyn_ID = 8;
break;
case "元":
Cull.Dyn_ID = 9;
break;
case "明清":
Cull.Dyn_ID = 10;
break;
}
//类别
switch (DropDownList2.SelectedItem.ToString())
{
case "青铜器":
Cull.Class_ID = 1;
break;
case "玉器":
Cull.Class_ID = 2;
break;
case "陶瓷":
Cull.Class_ID = 3;
break;
case "金银器":
Cull.Class_ID = 4;
break;
case "钱币":
Cull.Class_ID = 5;
break;
case "雕塑":
Cull.Class_ID = 6;
break;
case "书画 ":
Cull.Class_ID = 7;
break;
case "漆器":
Cull.Class_ID = 8;
break;
case "家具":
Cull.Class_ID = 9;
break;
case "铜镜 ":
Cull.Class_ID = 10;
break;
case "织绣":
Cull.Class_ID = 11;
break;
case "文房四宝":
Cull.Class_ID = 12;
break;
case "紫砂器":
Cull.Class_ID = 13;
break;
}
int result = CullService.Insert(Cull);
if (result >= 1)
{
Response.Write("<script>alert('发布成功!')</script>");
}
}
}
catch (Exception ex)
{
Response.Write("<script>alert('上传失败');</script> 原因是：" + ex);
}
}
//后台插入
public static int Insert(Culinfo Cull)
{
return(icull.Insert(Cull));
}
