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