protected void btnSave2_Click(object sender, EventArgs e)
{
DataTable dt = ULCode.QDA.XSql.GetDataTable("select ID from TE_Duties where CompanyID=11");
for (int i = 0; i < dt.Rows.Count; i++)
{
string sSql = String.Format("if exists(Select * from TE_MenusInDuties where MenuId={0} and DutyId={1})"
+ " update TE_MenusInDuties set Flag={2} where MenuId={0} and DutyId={1}"
+ " else "
+ " insert into TE_MenusInDuties(MenuId,DutyId,Flag) values({0},{1},{2})", WX.Request.rMenuId, dt.Rows[i]["ID"], 1);
ULCode.QDA.XSql.Execute(sSql);
string menustr = new WX.Json.BuildUserMenus(Convert.ToInt32(dt.Rows[i]["ID"].ToString())).GetUserMenu();
if (menustr != "-1")
{
WX.Model.Duty.MODEL model = WX.Model.Duty.NewDataModel(dt.Rows[i]["ID"]);
List <WX.Json.UserMenu> l_u = WX.Json.JsonConvert.GetJsonObject <List <WX.Json.UserMenu> >(menustr, false);
if (l_u != null)
{
model.Menus.set(menustr);
if (model.Update() == 0)
{
model.RestoreInitial();
}
}
}
}
}
protected void Button3_Click(object sender, EventArgs e)
{
int id = WX.Request.rDutyId;
string menustr = new WX.Json.BuildUserMenus(id).GetUserMenu();
//menustr = "\"menus\":" + menustr;
if (menustr == "-1")
{
Response.Write("参数错误或您没有权限，数据找不到！");
Response.End();
return;
}
ui_Htmls.Value = menustr;
}
