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);
}