//绑定全部矿
private void bindAllORE()
{
string strsql = "select * from department t where t.deptname like '%矿' and t.deptnumber like'%00000' order by deptname";
DataSet ds = OracleHelper.Query(strsql);
OREcbox.DataSource = ds;
OREcbox.DataBind();
}
//绑定全部矿
private void bindAllORE()
{
if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0"))
{
string strsql = "select * from department t where t.deptname like '%矿' and t.deptnumber like'%00000' order by deptname";
DataSet ds = OracleHelper.Query(strsql);
OREcbox.DataSource = ds;
OREcbox.DataBind();
}
else
{
string strsql = "select * from department t where t.deptnumber like '2417_____' and (t.deptlevel='正科级' or t.deptnumber like '_______00') order by deptname desc";
DataSet ds = OracleHelper.Query(strsql);
OREcbox.DataSource = ds;
OREcbox.DataBind();
}
}