protected void Button1_Click(object sender, EventArgs e) { //添加 //保存图片 string strsql; string NewID = ""; string img_url = UploadPicFile(FileUpload1); if (img_url == "") { img_url = "nopic.jpg"; //不上传图片,默认为无图片 } strsql = string.Format("insert Into T_films (PathID,Film_name,Other_name,Film_director,Film_Player," + "Film_class,Film_classID,Film_from,film_Level,film_clear,film_money,film_Pic,film_gut," + "playtype,filmisseq,Filmisgood1," + "filmisGood2,FilePhyPath,FileFolder,AllowDown,ShowType,SearchKey) values ({0},'{1}','{2}','{3}','{4}'," + "'{5}',{6},{7},{8},{9},{10},'{11}','{12}'," + "{13},{14},{15}," + "{16},'{17}','{18}',{19},{20},'{21}')", DwPath.SelectedValue, TbFilmname.Text, TbOthername.Text, TbDirector.Text, TbPlayer.Text, DwClass.SelectedItem.Text, DwClass.SelectedItem.Value, DwFrom.SelectedItem.Value, DwLevel.Text, DwClear.Text, (TbMoney.Text == "" ? "0" : TbMoney.Text), img_url, TbGut.Text.Replace("'", "''"), Rbfilmtype.Text, RbIsReq.Text, (CkbBest.Items[0].Selected ? 1 : 0), (CkbBest.Items[1].Selected ? 1 : 0), TbFilmPhyPath.Text, uppath.Value, Rb_AllowDown.Text, Rb_Showtype.Text, (Tb_SearchKey.Text == "" ? TbFilmname.Text : Tb_SearchKey.Text)); try { if (DBFun.ExecuteUpdate(strsql)) { NewID = DBFun.SearchValue("select Max(ID) from T_films"); int ijs = 0; for (int i = 1; i <= Convert.ToInt32(upjs.Value); i++) { strsql = string.Format("Insert Into [T_film_detail] (filename,filmid) values ('{0}',{1})", Request["urla" + i], NewID); if (DBFun.ExecuteUpdate(strsql)) { ijs++; } } strsql = string.Format("update T_films Set film_num = {0} where id={1}", ijs, NewID); DBFun.ExecuteSql(strsql); Response.Write("<script>alert('影片添加成功!');window.location.href='film_edit.aspx?Action=Edit&ID=" + NewID + "';</script>"); } } catch { Response.Write("<script>alert('影片添加失败!请确认填写正确!');</script>"); } }
protected void btn_Ok_Click(object sender, EventArgs e) { //保存 if (btn_Ok.Text == "添加") { try { string strsql = string.Format("Insert into T_class(Caption,ListImg,Listpagesize,ListSamePageSize,Cidx," + "CIsOpen,ListsortType,NotLoginIn,CSort) " + " values('{0}','{1}',{2},{3},{4},{5},{6},{7},{8})", tb_Caption.Text, tb_ListImg.Text, tb_ListPageSize.Text, tb_ListSamePageSize.Text, tb_Cidx.Text, rbl_CIsOpen.Text, rbl_ListSortType.Text, rbl_NotLogin.Text, tb_CSort.Text); if (DBFun.ExecuteUpdate(strsql)) { Response.Write("<script>alert('数据添加成功!');window.location.href='film_classAddEdit.aspx?Action=Edit&id=" + DBFun.SearchValue("select Max(id) from T_class") + "';</script>"); } else { Response.Write("<scritp>alert('添加失败!请检查是否填写正确。');</script>"); } } catch (Exception ex) { Response.Write(@"<script>alert('添加失败!请检查是否填写正确!" + ex.Message + "');</script>"); } } else if (btn_Ok.Text == "确认修改") { try { string strsql = string.Format("Update T_class Set Caption='{0}',ListImg='{1}',Listpagesize={2},ListSamePageSize={3},Cidx={4}," + "CIsOpen={5},ListsortType={6},NotLoginIn={7} ,Csort={8} where id={9}", tb_Caption.Text, tb_ListImg.Text, tb_ListPageSize.Text, tb_ListSamePageSize.Text, tb_Cidx.Text, rbl_CIsOpen.Text, rbl_ListSortType.Text, rbl_NotLogin.Text, tb_CSort.Text, Request.QueryString["ID"]); if (DBFun.ExecuteUpdate(strsql)) { Response.Write("<script>alert('数据修改成功!');document.reload();</script>"); } else { Response.Write("<scritp>alert('保存失败!请检查是否填写正确。');</script>"); } } catch { Response.Write("<script>alert('保存失败!请检查是否填写正确!');</script>"); } } }