예제 #1
0
 /// <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));
 }
예제 #2
0
 /// <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>");
            }
        }