//后台增加 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)); }