private DataTable GetUserInfo() { CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, false); try { Clause c = new Clause(); string sql = ""; switch (this.req.data.logintype) //判断登录用户类型 { case "S": sql += "select * from " + M_Sys_Login_System.TableName + " where 1=1 "; sql += " and trim(LoginName)='" + req.data.username + "'"; break; case "L": sql += "select * from " + M_Sys_Login_Lease.TableName + " where 1=1 "; sql += " and trim(LeaseNumber)='" + req.data.username + "'"; break; case "E": case "C": c.Add("trim(LoginName)", req.data.username); break; default: throw new Exception("Unknown login type!"); } DataTable dt = biz.RetrieveDataTable <Model.M_Sys_Login_Account>(c.Get()); biz.Commit(); return(dt); } catch (Exception err) { biz.Abort(); throw err; } }