protected void ImportFromExcelToCreate(DataSet ds) { try { System.Data.DataTable dt = ds.Tables[0]; int nAll = dt.Rows.Count; int nCreate = 0; foreach (System.Data.DataRow dr in dt.Rows) { if (dr["SelectX"].ToString().ToLower() == "x") { string menuid = Guid.NewGuid().ToString(); string menuparentid = lbl_MenuID.Text.Trim(); //string menucode = tbx_MenuCode.Text.Trim(); string menuname = dr["MenuName"].ToString().Trim(); string menudesc = dr["MenuDesc"].ToString().Trim(); int menuisdisplay = int.Parse(dr["MenuIsDisplay"].ToString().Trim()); int menuindex = int.Parse(dr["MenuIndex"].ToString().Trim()); int menutype = int.Parse(dr["MenuType"].ToString().Trim()); string menuurl = dr["MenuURL"].ToString().Trim(); string menugif = dr["MenuGIF"].ToString().Trim(); int menutarget = int.Parse(dr["MenuTarget"].ToString().Trim()); string menugroups = "AA,"; int menuisvalid = int.Parse(dr["MenuIsValid"].ToString().Trim()); string menunote = dr["MenuNote"].ToString().Trim(); string menucreatetime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); string menumodifytime = menucreatetime; KPI_MenuEntity sysMenu = new KPI_MenuEntity(); sysMenu.MenuID = menuid; sysMenu.MenuParentID = menuparentid; //sysMenu.MenuCode = menucode; sysMenu.MenuName = menuname; sysMenu.MenuDesc = menudesc; sysMenu.MenuIsDisplay = menuisdisplay; sysMenu.MenuIndex = menuindex; sysMenu.MenuType = menutype; sysMenu.MenuURL = menuurl; sysMenu.MenuGIF = menugif; sysMenu.MenuTarget = menutarget; sysMenu.MenuGroups = menugroups; sysMenu.MenuIsValid = menuisvalid; sysMenu.MenuNote = menunote; sysMenu.MenuCreateTime = menucreatetime; sysMenu.MenuModifyTime = menumodifytime; if (KPI_MenuDal.Insert(sysMenu)) { nCreate += 1; } } } string strInfor = "菜单总数:{0}个, 创建成功:{1}个。"; strInfor = string.Format(strInfor, nAll, nCreate); MessageBox.popupClientMessage(this.Page, strInfor, "call();"); BindGrid(); return; } catch (Exception) { // //MessageBox.popupClientMessage(this.Page, ee.Message, "call();"); return; } }
/// <summary> /// 添加新的节点到菜单集合 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnMenuAdd_Click(object sender, EventArgs e) { //protected String _MenuID = null; //protected String _MenuParentID = null; //protected String _MenuCode = null; //protected String _MenuName = null; //protected String _MenuDesc = null; //protected int _MenuIsDisplay = int.MinValue; //protected int _MenuType = int.MinValue; //protected String _MenuURL = null; //protected String _MenuGIF = null; //protected int _MenuTarget = int.MinValue; //protected String _MenuGroups = null; //protected int _MenuIsValid = int.MinValue; //protected String _MenuNote = null; //protected String _MenuCreateTime = null; //protected String _MenuModifyTime = null; //strGroupCollections= GetGroupSelected(dtGroups); //lbl_MenuGroups.Text = strGroupCollections; string menuid = ""; // lbl_MenuID.Text.Trim(); string menuparentid = ddl_MenuParentID.Value; string menucode = tbx_MenuCode.Text.Trim(); string menuname = tbx_MenuName.Text.Trim(); string menudesc = tbx_MenuDesc.Text.Trim(); int menuisdisplay = int.Parse(rbl_MenuIsDisplay.SelectedValue); int menuindex = 0; int menutype = int.Parse(rbl_MenuType.SelectedValue); string menuurl = tbx_MenuURL.Text.Trim(); string menugif = tbx_MenuGIF.Text.Trim(); int menutarget = int.Parse(rbl_MenuTarget.SelectedValue); string menugroups = "AA,"; int menuisvalid = int.Parse(rbl_MenuIsValid.SelectedValue); string menunote = tbx_MenuNote.Text.Trim(); string menucreatetime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); string menumodifytime = menucreatetime; if (menuid == "") { menuid = Guid.NewGuid().ToString(); } KPI_MenuEntity sysMenu = new KPI_MenuEntity(); sysMenu.MenuID = menuid; sysMenu.MenuParentID = menuparentid; sysMenu.MenuCode = menucode; sysMenu.MenuName = menuname; sysMenu.MenuDesc = menudesc; sysMenu.MenuIsDisplay = menuisdisplay; sysMenu.MenuIndex = menuindex; sysMenu.MenuType = menutype; sysMenu.MenuURL = menuurl; sysMenu.MenuGIF = menugif; sysMenu.MenuTarget = menutarget; sysMenu.MenuGroups = menugroups; sysMenu.MenuIsValid = menuisvalid; sysMenu.MenuNote = menunote; sysMenu.MenuCreateTime = menucreatetime; sysMenu.MenuModifyTime = menumodifytime; if (KPI_MenuDal.Insert(sysMenu)) { MessageBox.popupClientMessage(this.Page, "添加成功!", "call();"); } else { MessageBox.popupClientMessage(this.Page, "添加错误!", "call();"); } BindGrid(); }