private M_T_PAYMENT GetPayInfo(int id) { CRUD dbiz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, false); try { Clause c = new Clause(); c.Add(" paymentid", id.ToString()); List <M_T_PAYMENT> list = dbiz.Retrieve <M_T_PAYMENT>(c.Get()); return(list[0]); } catch (Exception) { throw; } }
private List <Model.M_Sys_Login_Account> GetLogUser() { CRUD biz01 = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, false); try { Clause c = new Clause(); c.Add("trim(LoginName)", this.req.data.userid); List <Model.M_Sys_Login_Account> etyLst = biz01.Retrieve <Model.M_Sys_Login_Account>(c.Get()); biz01.Commit(); return(etyLst); } catch (Exception err) { biz01.Abort(); throw err; } }