Ejemplo n.º 1
0
 protected void btnEnable_Click(object sender, EventArgs e)
 {
     if (DepTreeList.SelectionCount <= 0)
     {
         JSHelper.Alert("请至少选择一条记录!", this);
     }
     else
     {
         List <string> list = new List <string>();//建立事务列表
         foreach (var item in DepTreeList.GetSelectedNodes())
         {
             list.Add(string.Format("update department set deptstatus='1' where deptnumber='{0}'", item.Key));
         }
         try
         {
             OracleHelper.ExecuteSqlTran(list);
             InitData();
             DepTreeList.UnselectAll();
             JSHelper.Alert("更新成功!", this);
         }
         catch (Exception ex)
         {
             JSHelper.Alert("出现异常,更新失败!请与管理员联系!", this);
         }
     }
 }