C# (CSharp) Careysoft.Dotnet.Tools.SqlData.Access.Access FactoryT_BASE_UNITTYPEAccess Examples

Example #1

        public static bool UnitTypeAdd(Model.T_BASE_UNITTYPEModel model)
        {
            Access.FactoryT_BASE_UNITTYPEAccess af = new Access.FactoryT_BASE_UNITTYPEAccess();
            int ret = af.Add(model);

            return(ret > 0);
        }

Example #2

 public static List <Model.T_BASE_UNITTYPEModel> GetUnitTypeList(string flxbm = "0")
 {
     Access.FactoryT_BASE_UNITTYPEAccess af = new Access.FactoryT_BASE_UNITTYPEAccess();
     return(af.QueryList("T.SFSC=0 AND T.FLXBM='" + flxbm + "'", "TO_NUMBER(T.BL1)"));
 }

Example #3

 public static List <Model.T_BASE_UNITTYPEModel> GetUnitTypeListFromFl(string fl)
 {
     Access.FactoryT_BASE_UNITTYPEAccess af = new Access.FactoryT_BASE_UNITTYPEAccess();
     return(af.QueryList(" T.FLXBM IN (SELECT LXBM FROM T_BASE_UNITTYPE WHERE SFSC=0 AND FLXBM='0' AND BL2='" + fl + "') AND T.SFSC=0", "TO_NUMBER(T.BL1)"));
 }

Example #4

 public static Model.T_BASE_UNITTYPEModel GetUnitTypeModel(string id)
 {
     Access.FactoryT_BASE_UNITTYPEAccess af = new Access.FactoryT_BASE_UNITTYPEAccess();
     return(af.Query(id));
 }