// ArrayList result = new ArrayList(); public T_menu getByfguid(string fguid) { //string sql = "SELECT muenameen FROM T_menu WHERE guid='" + fguid + "';"; string sql = @" SELECT t1.muenameen,t2.countrows FROM T_menu t1 LEFT JOIN ( SELECT COUNT(muenameen) countrows, fmuid FROM T_menu WHERE fmuid = '" + fguid + @"' GROUP BY fmuid ) t2 ON t1.guid = t2.fmuid WHERE guid = '" + fguid + @"'; "; DataTable dt = SqlHelper.ExcuteTable(sql); T_menu menu = new T_menu(); if (dt.Rows.Count <= 0) { return(null); } else { // result.Add(dt.Rows[0]["muenameen"].ToString(), dt.Rows[0]["countrows"].ToString()); menu.muenameen = dt.Rows[0]["muenameen"].ToString(); menu.muenamech = dt.Rows[0]["countrows"].ToString(); } return(menu); }
public T_menu Tomenu(DataRow row) { T_menu menus = new T_menu(); menus.guid = (Guid)SqlHelper.FromDbValue(row["guid"]); menus.fmuid = (string)SqlHelper.FromDbValue(row["fmuid"]); menus.fmname = (string)SqlHelper.FromDbValue(row["fmname"]); menus.muenameen = (string)SqlHelper.FromDbValue(row["muenameen"]); menus.muenamech = (string)SqlHelper.FromDbValue(row["muenamech"]); return(menus); }
private void btnAddMenu_Click(object sender, EventArgs e) { string muenamech = txtmunnamech.Text; string muenameen = txtmunnameen.Text; muenamech = muenamech.Trim(); muenameen = muenameen.Trim(); if (muenameen.Length <= 0 || muenamech.Length <= 0) { MessageBox.Show("显示菜单名与系统菜单名都不能为空"); return; } //判断是否已有此菜单 DataTable td = rmger.getBySysName(muenameen); if (td.Rows.Count > 0) { MessageBox.Show("系统已有此菜单,无需再添加一个"); txtmunnameen.Text = ""; txtmunnamech.Text = ""; return; } //查找父GUID,名称 string fguid = cbfmune.SelectedValue.ToString(); T_menu menu = new T_menu(); menu = rmger.getByfguid(fguid); if (menu != null) { Guid rouid = Guid.NewGuid(); string fmname = menu.muenameen; string ordernos = menu.muenamech; if (ordernos.Length <= 0) { ordernos = "0"; } int orderno = Convert.ToInt32(ordernos) + 1; int count = rmger.addmune(rouid, fguid, fmname, muenameen, muenamech, orderno); if (count == 0) { MessageBox.Show("添加菜单失败"); return; } MessageBox.Show("添加菜单成功"); // reset(); } }
public T_menu[] getchmenu() { string sql = "select * from T_menu where fmuid <> '0'"; DataTable dt = SqlHelper.ExcuteTable(sql); T_menu[] menus = new T_menu[dt.Rows.Count]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { menus[i] = Tomenu(dt.Rows[i]); } return(menus); } else { return(null); } }