cs代码:
public List<string> Get_emp_no() { List<string> emp_no_str = new List<string>(); string str = "select * from staff_dict where emp_no='" + Session["Emp_No"].ToString() + "' or EMPLOYEE_ID='" + Session["Emp_No"].ToString() + "'"; OracleDataAdapter da = new OracleDataAdapter(str, StrConn_Oracle); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { emp_no_str.Add(ds.Tables[0].Rows[i]["emp_no"].ToString()); } } return emp_no_str; } /// <summary> /// 初始数据 /// </summary> public void Init_Data() { string ret_code = ""; string str_ora = "select * from staff_dict where name ='" + Session["UserName"].ToString() + "'"; DataSet ds_ora = DbHelperOralce.Query(str_ora); // 判断是否 有工号 if (ds_ora.Tables[0].Rows.Count > 0) { string strsql = ""; // 判断是否是 护士长 string strqry = ""; if (Get_emp_no().Count > 0) { for (int i = 0; i < Get_emp_no().Count; i++) { strqry += "leader_emp_no like '%" + Get_emp_no()[i] + "%'"+" or "; } int l = strqry.Length; strqry = strqry.Substring(0, l - 3); } string str = " select * from Clinical_Dict where 1=1 and "+strqry+""; DataSet ds = DbHelperSQL.Query(str); if (ds.Tables[0].Rows.Count > 0) { int i = ds.Tables[0].Rows.Count; for (int j = 0; j < i; j++) { ret_code += "'"+ds.Tables[0].Rows[j]["ID"].ToString()+"'" + ","; } int l = ret_code.Length; ret_code = ret_code.Substring(0, l - 1); strsql += " a.dept_code in (" + ret_code +")"; string SqlString = "select distinct a.Title_ID, b.title,a.Dept_Code,a.Dept_Name,a.Ygbh,a.YGXM,a.Test_Type,a.test_date,a.Tester,a.Fee_Read_Flag,a.kaohe_times+1 as kaohe_times ,a.kaohe_times as times,a.Feedback,a.apply_range from KaoHe_FeeBack_Detail a left join subject_title b on a.title_id=b.id where ("+ strsql+") and a.fee_read_flag='0' and a.submit_flag='1' and a.Apply_Range=b.Apply_Range order by a.apply_range,a.kaohe_times desc,a.Test_date desc "; DataSet ds_sql = DbHelperSQL.Query(SqlString); SearchGrird.DataSource = ds_sql.Tables[0];//绑定数据源 SearchGrird.DataBind(); Panel1.Visible = true; } } }