/// <summary>发布菜单的数据添加 /// 发布菜单的数据添加 /// </summary> /// <param name="caidan"></param> /// <returns></returns> public static bool Addfabucaidan(fabucaidan caidan) { SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@yuanchuang", caidan.Yuanchuang), new SqlParameter("@biaoti", caidan.Biaoti), new SqlParameter("@gongyi", caidan.Gongyi), new SqlParameter("@kowei", caidan.Kowei), new SqlParameter("@nandu", caidan.Nandu), new SqlParameter("@zunbeishijian", caidan.Zunbeishijian), new SqlParameter("@penrenshijian", caidan.Penrenshijian), new SqlParameter("@renshu", caidan.Renshu), new SqlParameter("@chengpintupian", caidan.Chengpintupian), new SqlParameter("@fenxiangxinqin ", caidan.Fenxiangxinqin), new SqlParameter("@zhuliaomingcheng", caidan.Zhuliaomingcheng), new SqlParameter("@zhuliaoyongliang", caidan.Zhuliaoyongliang), new SqlParameter("@fuliaomingcheng", caidan.Fuliaomingcheng), new SqlParameter("@fuliaoyongliang", caidan.Fuliaoyongliang), new SqlParameter("@buzoutupian", caidan.Buzoutupian), new SqlParameter("@buzoumiaosu ", caidan.Buzoumiaosu), new SqlParameter("@zuizhongxiaoguotu", caidan.Zuizhongxiaoguotu), new SqlParameter("@fabushijian", caidan.Fabushijian), new SqlParameter("@caiputitle", caidan.Caiputitle), new SqlParameter("@userid", caidan.Userid), new SqlParameter("@renqi", caidan.Renqi) }; return(DBHelper.Excute("pro_fabucaidanADD", parm)); }
/// <summary>发布菜单的数据添加 /// 发布菜单的数据添加 /// </summary> /// <param name="caidan"></param> /// <returns></returns> public static bool Addfabucaidan(fabucaidan caidan) { return(fabucaidanDAL.Addfabucaidan(caidan)); }
protected void Button11_Click(object sender, EventArgs e) { fabucaidan fb = new fabucaidan(); fb.Biaoti = this.TextBox1.Text; fb.Yuanchuang = int.Parse(this.DropDownList1.SelectedValue); fb.Gongyi = int.Parse(this.DropDownList2.SelectedValue); fb.Kowei = int.Parse(this.DropDownList3.SelectedValue); fb.Nandu = int.Parse(this.DropDownList4.SelectedValue); fb.Zunbeishijian = int.Parse(this.DropDownList5.SelectedValue); fb.Penrenshijian = int.Parse(this.DropDownList6.SelectedValue); fb.Renshu = int.Parse(this.DropDownList7.SelectedValue); string tupisn1 = Session["tupian1"].ToString(); string tupisn2 = Session["tupian2"].ToString(); string tupisn3 = Session["tupian3"].ToString(); string tupisn4 = Session["tupian4"].ToString(); string tupisn5 = Session["tupian5"].ToString(); string tupisn6 = Session["tupian6"].ToString(); string tupisn7 = Session["tupian7"].ToString(); string tupisn8 = Session["tupian8"].ToString(); string tupisn9 = Session["tupian9"].ToString(); string tupisn10 = Session["tupian10"].ToString(); fb.Chengpintupian = tupisn1; fb.Buzoutupian = tupisn2 + "," + tupisn3 + "," + tupisn4 + "," + tupisn5 + "," + tupisn6; fb.Zuizhongxiaoguotu = tupisn7 + "," + tupisn8 + "," + tupisn9 + "," + tupisn10; fb.Fenxiangxinqin = this.TextBox2.Text; //主料 string zhuliaomc1 = this.TextBox3.Text; string zhuliaomc2 = this.TextBox5.Text; string zhuliaomc3 = this.TextBox7.Text; string zhuliaoyl1 = this.TextBox4.Text; string zhuliaoyl2 = this.TextBox6.Text; string zhuliaoyl3 = this.TextBox8.Text; fb.Zhuliaomingcheng = zhuliaomc1 + "," + zhuliaomc2 + "," + zhuliaomc3; fb.Zhuliaoyongliang = zhuliaoyl1 + "," + zhuliaoyl2 + "," + zhuliaoyl3; //辅料 string fuliaomc1 = this.TextBox9.Text; string fuliaomc2 = this.TextBox11.Text; string fuliaomc3 = this.TextBox13.Text; string fuliaoyl1 = this.TextBox10.Text; string fuliaoyl2 = this.TextBox12.Text; string fuliaoyl3 = this.TextBox14.Text; fb.Fuliaomingcheng = fuliaomc1 + "," + fuliaomc2 + "," + fuliaomc3; fb.Fuliaoyongliang = fuliaoyl1 + "," + fuliaoyl2 + "," + fuliaoyl3; fb.Buzoumiaosu = this.TextBox15.Text + "," + this.TextBox16.Text + "," + this.TextBox17.Text + "," + this.TextBox18.Text + "," + this.TextBox19.Text; fb.Fabushijian = Convert.ToDateTime(DateTime.Now.ToString()); fb.Caiputitle = this.TextBox21.Text; fb.Userid = int.Parse(Session["userid"].ToString()); if (fabucaidanBLL.Addfabucaidan(fb)) { Response.Write("<script>alert('发布菜单成功!')</script>"); } else { Response.Write("<script>alert('发布菜单失败!')</script>"); } }