public void Update(WechatMenuInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"UPDATE [WechatMenu] SET [FatherId]=@FatherId,[Name]=@Name,[Type]=@Type,[Key]=@Key,[Url]=@Url,[OrderId]=@OrderId where Id=@Id";
conn.Execute(sql, entity);
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
WechatMenuInfo wechatmenu = new WechatMenuInfo();
wechatmenu.Id = RequestHelper.GetQueryString <int>("ID");
wechatmenu.Name = Name.Text;
wechatmenu.FatherId = Convert.ToInt32(FatherID.Text);
wechatmenu.OrderId = Convert.ToInt32(OrderID.Text);
wechatmenu.Type = this.MenuType.Text;
if (wechatmenu.Type == "click")
{
wechatmenu.Key = MenuKey.Text;
}
else
{
wechatmenu.Url = MenuKey.Text;
}
string alertMessage = ShopLanguage.ReadLanguage("AddOK");
//添加
if (wechatmenu.Id <= 0)
{
if (FatherID.Text == "0" && WechatMenuBLL.ReadRootList().Count >= 3)
{
ScriptHelper.Alert("最多只能添加3个一级菜单");
return;
}
if (FatherID.Text != "0" && WechatMenuBLL.ReadChildList(Convert.ToInt32(FatherID.Text)).Count >= 5)
{
ScriptHelper.Alert("每个一级菜单下最多只能添加5个二级菜单");
return;
}
int id = WechatMenuBLL.Add(wechatmenu);
}
else//修改
{
//如果更改了父级菜单且原先已有3个一级菜单
string _oldFatherId = WechatMenuBLL.Read(wechatmenu.Id).FatherId.ToString();
if (FatherID.Text == "0" && FatherID.Text != _oldFatherId && WechatMenuBLL.ReadRootList().Count >= 3)
{
ScriptHelper.Alert("最多只能添加3个一级菜单");
return;
}
//如果更改了父级菜单且该菜单下原先已有5个二级菜单
if (FatherID.Text != "0" && FatherID.Text != _oldFatherId && WechatMenuBLL.ReadChildList(Convert.ToInt32(FatherID.Text)).Count >= 5)
{
ScriptHelper.Alert("每个一级菜单下最多只能添加5个二级菜单");
return;
}
WechatMenuBLL.Update(wechatmenu);
alertMessage = ShopLanguage.ReadLanguage("UpdateOK");
}
ScriptHelper.Alert(alertMessage, RequestHelper.RawUrl);
}
public int Add(WechatMenuInfo entity)
{
using (var conn = new SqlConnection(connectString))
{
string sql = @"INSERT INTO [WechatMenu]( [FatherId],[Name],[Type],[Key],[Url],[OrderId]) VALUES(@FatherId,@Name,@Type,@Key,@Url,@OrderId);
select SCOPE_IDENTITY()";
return(conn.Query <int>(sql, entity).Single());
}
}
public static void Update(WechatMenuInfo entity)
{
dal.Update(entity);
}
public static int Add(WechatMenuInfo entity)
{
return(dal.Add(entity));
}
