// 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);
}
}
