protected void Save_btn_Click(object sender, EventArgs e) { string discode = hidId.Value; if (!string.IsNullOrWhiteSpace(discode)) { string ids = this.HidfunIdStr.Value; ids = ids.TrimStart(','); ids = ids.TrimEnd(','); string sql = "update TR_DishesMethods set discode=replace(discode,'," + discode + ",','');"; sql += "update TR_DishesMethods set discode=discode+'," + discode + ",' where id in(" + ids + ");"; int recnums = bll.ExecuteNonQueryBySQL(sql); if (recnums >= 0) { errormessage.InnerHtml = "操作成功"; } else { errormessage.InnerHtml = "操作失败"; } } else { errormessage.InnerHtml = "你选择菜品"; } }
//保存数据 protected void Save_btn_Click(object sender, EventArgs e) { //获取页面信息 string mtype = ddltype.SelectedValue; string name = txt_name.Text; string typename = txt_typename.Text; string money = txt_money.Text; if (string.IsNullOrWhiteSpace(money)) { money = "0"; } string relmsg = "操作失败"; int recnum = 0; if (hidId.Value.Length == 0 || hidId.Value == "0")//添加信息 { //string dicid = ""; string sql = "insert into [dbo].[TR_DishesMethods]([StoCode] ,[DisCode] ,[MType],[Money] ,[TypeName],[Name]) values('',''," + mtype + "," + money + ",'" + typename + "','" + name + "')"; recnum = bll.ExecuteNonQueryBySQL(sql); //hidId.Value = bll.oResult.Data; this.PageTitle.Operate = "添加"; } else//修改信息 { recnum = bll.ExecuteNonQueryBySQL("update [dbo].[TR_DishesMethods] set [MType]=" + mtype + ",[Money] =" + money + ",[TypeName]='" + typename + "',[Name]='" + name + "' where id=" + hidId.Value); //hidId.Value = bll.oResult.Data; this.PageTitle.Operate = "修改"; } //显示结果 if (recnum >= 0) { relmsg = "操作成功"; } ShowResult(recnum.ToString(), relmsg, errormessage); }