111,095
社区成员




for (int i = 0; i < dt1.Rows.Count; i++)
{
sa = (string[])ArrayList.Adapter((Array)dt1.Rows[i]["ModuleID"]).ToArray(typeof(string));
string s2 = "select * from ws_system where M_ParentID = " + sa[i] + "";
}
public DataTable Module_SelectByID(string ModuleID)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from ws_system where M_ParentID = " + ModuleID + "");
DataTable dt = new DataTable();
dt = DbHelperSQL.Query(sb.ToString()/*, parameters*/).Tables[0];
if (dt.Rows.Count > 0)
{ return dt; }
else
{ return null; }
}
HtmlInputHidden hidd = (HtmlInputHidden)e.Item.FindControl("Hidden1");
string i = hidd.Value;
c.ID = Session["user"].ToString();
DataTable dt = bll.Module_SelectByID(i.ToString());
if (dt.DefaultView.Count > 0)
{
Repeater LeftSubID = (Repeater)e.Item.FindControl("LeftMenu_Sub");
LeftSubID.DataSource = dt;
LeftSubID.DataBind();
}
else
{
e.Item.Visible = false;
}
string sql2 = "select * from ws_system where M_ParentID in (select ModuleID from ws_system where M_PageCode in (select Pagecode from ws_RolePermission where roleid=(select Power from ws_User where id='" + c.ID + "')))";
public DataTable Module_SelectByID( Userl c)
{
string sql2 = "select ModuleID from ws_system where M_PageCode in (select " + "Pagecode from ws_RolePermission where roleid=(select Power from ws_User where " + "id='" + c.ID + "'))";
DataTable dt1 = DbHelperSQL.Query(sql2.ToString()/*, parameters*/).Tables[0];
string s2 = string.Empty;
for (int i = 0; i < dt1.Rows.Count; i++)
{
string sa = dt1.Rows[i]["ModuleID"].ToString().Trim();
s2 = s2 + sa + ",";
}
s2 = s2.Remove(s2.LastIndexOf(","), 1);//这里是去掉最后一个,号,你也可以用其他方法去掉,号
string sql3 = "select * from ws_system where M_ParentID in (" + s2 + ")";
DataTable dtMenu = DbHelperSQL.Query(sql3).Tables[0];
return dtMenu;
}
public DataTable Module_SelectByID( Userl c)
{
string sql2 = "select ModuleID from ws_system where M_PageCode in (select " + "Pagecode from ws_RolePermission where roleid=(select Power from ws_User where " + "id='" + c.ID + "'))";
DataTable dt1 = DbHelperSQL.Query(sql2.ToString()/*, parameters*/).Tables[0];
string s2 = string.Empty;
for (int i = 0; i < dt1.Rows.Count; i++)
{
string sa = dt1.Rows[i]["ModuleID"].ToString().Trim();
s2 = s2 + sa + ",";
}
s2 = s2.Remove(s2.LastIndexOf(","), 1);//这里是去掉最后一个,号,你也可以用其他方法去掉,号
string sql3 = "select * from ws_system where M_ParentID in (" + s2 + ")";
DataTable dtMenu = DbHelperSQL.Query(sql2.ToString()/*, parameters*/).Tables[0];
return dtMenu;
}
public DataTable Module_SelectByID( Userl c)
{
string sql2 = "select ModuleID from ws_system where M_PageCode in (select Pagecode from ws_RolePermission where roleid=(select Power from ws_User where id='" + c.ID + "'))";
/****************************************************************************************************************/
DataTable dt1 = DbHelperSQL.Query(sql2.ToString()/*, parameters*/).Tables[0];
List<DataTable> ass = new List<DataTable>();
for (int i = 0; i < dt1.Rows.Count; i++)
{
string sa = dt1.Rows[i]["ModuleID"].ToString().Trim();
string s2 = "select * from ws_system where M_ParentID = " + sa + "";
}
if (dt1.Rows.Count > 0)
{ return dt1; }
else
{ return null; }
}
string[] ary = Array.ConvertAll<DataRow,string>(datatable.Rows, r=>r["ModuleID"].ToString());
for (int i = 0; i < dt1.Rows.Count; i++)
{
string sa = dt1.Rows[i]["ModuleID"]).Tostring().trim();
string s2 = "select * from ws_system where M_ParentID = " + sa + "";
}