/// <summary> /// 设置页面信息 /// </summary> /// <param name="id">ID</param> private void SetPage(string id) { DataTable dt = bll.GetDataTableInfoBySQL("select * from [dbo].[TR_DishesMethods] where id=" + id); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; ddltype.SelectedValue = dr["MType"].ToString(); txt_typename.Text = dr["TypeName"].ToString(); txt_name.Text = dr["Name"].ToString(); txt_money.Text = dr["Money"].ToString(); } }
public string GetMenuTable(string discode) { DataTable dt = bll.GetDataTableInfoBySQL("select * from TR_DishesMethods"); DataTable dtRoleFunctions = bll.GetDataTableInfoBySQL("select * from TR_DishesMethods where discode like('," + discode + ",')"); //查询出所有的功能,并显示。 StringBuilder html = new StringBuilder(256); List <string> listTypes = new List <string>(); foreach (DataRow dr in dt.Rows) { string typename = dr["typename"].ToString(); if (!listTypes.Contains(typename)) { listTypes.Add(typename); } } html.Append("<table class=\"list\" cellpadding=\"0\" cellspacing=\"1\" width=\"100%\">"); html.Append("<tr class=\"list_line\">"); html.Append("<td style=\"width:5%;\">"); string choose = ""; if (Request["id"] != null) { choose = "checked=\"checked\""; } //html.AppendFormat("<input id=\"chkAll\" type=\"checkbox\" " + choose + " onclick=\"CheckAll(this);\"/>"); html.Append("</td>"); html.Append("<td style=\"width:25%;\">"); html.Append("分类"); html.Append("</td>"); html.Append("<td style=\"width:70%;\">"); html.Append("规格"); html.Append("</td>"); html.Append("</tr>"); foreach (string typename in listTypes) { html.Append("<tr>"); html.Append("<td>"); html.Append(" "); html.Append("</td>"); html.Append("<td>"); //html.AppendFormat("<input id=\"m{0}\" onclick=\"setMenuuMain(this);\" type=\"checkbox\" value='{0}' {1}/>","0", Check(dr1["id"].ToString(), dtRoleFunctions)); html.AppendFormat("╋{0}", typename); html.Append("</td>"); html.Append("<td>"); html.Append(" "); html.Append("</td>"); html.Append("</tr>"); DataRow[] drTwo = dt.Select("typename='" + typename + "'", "");//二级菜单 foreach (DataRow dr2 in drTwo) { html.Append("<tr>"); html.Append("<td>"); html.Append(" "); html.Append("</td>"); html.Append("<td>"); html.AppendFormat(" <input id=\"m{0}_{1}\" onclick=\"setMenuuMain(this);\" type=\"checkbox\" value='{1}' {2}/>", "0", dr2["id"], Check(dr2["id"].ToString(), dtRoleFunctions)); html.AppendFormat("┝{0}", dr2["name"]); html.Append("</td>"); html.Append("<td>"); html.Append(" "); html.Append("</td>"); html.Append("</tr>"); html.Append("</td>"); html.Append("</tr>"); } } html.Append("</table>"); return(html.ToString()); }