public static Boolean IsQx(string sMenuID)
{
if (Program.sOperID.Trim() == "admin")
{
return(true);
}
try
{
DataView dv = dtQx.DefaultView;
dv.RowFilter = " MenuID='" + sMenuID + "'";
if (CommonInfo.CBoolean(dv.ToTable().Rows[0]["IsQx"].ToString()))
{
return(true);
}
else
{
return(false);
}
}
catch { return(false); }
}
private void grdLeft_FocusedViewChanged(object sender, DevExpress.XtraGrid.ViewFocusEventArgs e)
{
string sError = " ";
string strSql = "SELECT cast(0 AS bit) AS IsQx,* FROM TQx_Menu WHERE State='使用' order by MenuID ";
DataTable dt = SqlHelper.RunQuery(CommandType.Text, strSql, null, out sError);
string sRoleID = gridViewLeft.GetDataRow(gridViewLeft.FocusedRowHandle)["RoleID"].ToString();
strSql = "SELECT * FROM TQx_RoleQx WHERE RoleID='" + sRoleID + "' ";
DataTable dtQx = SqlHelper.RunQuery(CommandType.Text, strSql, null, out sError);
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
DataView dv = dtQx.DefaultView;
dv.RowFilter = " MenuID='" + dt.Rows[i]["MenuID"].ToString() + "'";
dt.Rows[i]["IsQx"] = CommonInfo.CBoolean(dv.ToTable().Rows[0]["IsQx"].ToString());
}
catch { }
}
grdQx.DataSource = dt;
}