| | |
|---|
| | | { |
|---|
| | | List<MenuLoad> mu = new List<MenuLoad>(); //以父子级结构存放菜单清单信息 |
|---|
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //数据库操作工具 |
|---|
| | | string sql = "select HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HPicNum from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "' order by HItemID"; |
|---|
| | | string sql = "select HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HPicNum from Gy_MenuDefineSet where HMakeName = '" + HMakeName + "' order by HPosition"; |
|---|
| | | ds = oCn.RunProcReturn(sql, "Gy_MenuDefineSet"); //查询当前用户的自定义菜单数据 |
|---|
| | | if (ds.Tables[0]==null || ds.Tables[0].Rows.Count == 0) //判断当前用户是否有设置过自定义信息，若记录数为0，则没有设置过，加载所有的菜单信息 |
|---|
| | | { |
|---|
| | | sql = "Select * from Gy_Menu_1 Order by HItemID "; |
|---|
| | | sql = "Select * from Gy_Menu_1 Order by HPosition "; |
|---|
| | | ds = oCn.RunProcReturn(sql, "Gy_Menu"); |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | int HLevel = int.Parse(ds.Tables[0].Rows[0]["HLevel"].ToString()); |
|---|
| | | string Hurl = ds.Tables[0].Rows[0]["Hurl"].ToString(); |
|---|
| | | string HType = ds.Tables[0].Rows[0]["HType"].ToString(); |
|---|
| | | string HPicNum = ds.Tables[0].Rows[0]["HPicNum"].ToString(); |
|---|
| | | |
|---|
| | | sql = "insert into Gy_MenuDefineSet values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "')"; |
|---|
| | | if(HPartentID == "0" || HPartentID == ds.Tables[0].Rows[0]["HItemID"]) |
|---|
| | | { |
|---|
| | | string HPosition = ds.Tables[0].Rows[0]["HPosition"].ToString(); |
|---|
| | | sql = "insert into Gy_MenuDefineSet(HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HMakeName,HPicNum,HPosition) values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "','" + HPicNum + "','" + HPosition + "')"; |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | sql = "insert into Gy_MenuDefineSet(HItemID,HPartentID,HNumber,HName,HLevel,Hurl,HType,HMakeName,HPicNum,HPosition) values('" + saveDataList[i].HItemID + "','" + HPartentID + "','" + HNumber + "','" + saveDataList[i].HName + "'," + HLevel + ",'" + Hurl + "','" + HType + "','" + HMakeName + "','" + HPicNum + "','z')"; |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //提交数据库操作 |
|---|
| | | oCN.Commit(); |
|---|
