/// <summary> /// 查询内容(权限窗体) /// </summary> /// <param name="userid"></param> /// <param name="sexid"></param> /// <param name="closeid"></param> /// <param name="confirmstatus"></param> /// <param name="dtTime"></param> /// <returns></returns> public DataTable Admin_Searchdtldt(int userid, int sexid, string closeid, string confirmstatus, DateTime dtTime) { var resultdt = new DataTable(); DataTable tempdt; string sqlscript; try { //创建临时表(当没有查询到值时使用) tempdt = dlDtList.Get_Admindtl(); //获取SQL语句 sqlscript = sqlList.Admindtl(userid, sexid, closeid, confirmstatus, dtTime); //执行SQL语句,并返回DT var dt = GetData(sqlscript); resultdt = dt.Rows.Count == 0 ? tempdt : dt; } catch (Exception) { resultdt.Rows.Clear(); resultdt.Columns.Clear(); throw; } return(resultdt); }