예제 #1
0
파일: SI35.cs 프로젝트: lizw-hwpg/POneIntf
        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;
            }
        }
예제 #2
0
        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;
            }
        }