예제 #1
0
        public void TestSQLite()
        {
            string dbPath = ".\\Example.db3";
            //如果不存在改数据库文件,则创建该数据库文件 
            if (!System.IO.File.Exists(dbPath))
            {
                CreateDB(dbPath);
            }

            var u = new ExUsers();
            u.Name = "张三";
            u.Age = 23;
            u.Email = "*****@*****.**";
            u.Status = 2;
            //OyEngine<ExUsers>.Insert(u);

            var cd = new OyCondition(ExUsers.sTatus, ConditionOperator.NotEqual, 9)
                & new OyCondition(ExUsers.aGe, ConditionOperator.Greater, 1);
            var mp = new MPager { PageIndex = 1, PageSize = 2 };
            var us = OyEngine<ExUsers>.Filter(cd, mp);
            if (us != null && us.Count > 0)
            {
                u = us[0];
            }

            OyEngine<ExUsers>.Update(
                new OyValue(ExUsers.nAme, "张山是个好名字")
                & new OyValue(ExUsers.eMail, "*****@*****.**")
                , new OyCondition(ExUsers.iD, u.Id));
        }
예제 #2
0
        public ActionResult Index(CxActivitySendOy cxact = null, decimal ysmin = 0, decimal ysmax = 0)
        {
            return View();
            var cond = new OyCondition(CxActivitySendOy.sTatus, ConditionOperator.NotEqual, -1);
            if (cxact != null)
            {
                if (!string.IsNullOrEmpty(cxact.ActivityType) && cxact.ActivityType != "-1")
                {
                    cond &= new OyCondition(CxActivitySendOy.aCtivityType, cxact.ActivityType);
                }
                if (!string.IsNullOrEmpty(cxact.ActivityName))
                {
                    cond &= new OyCondition(CxActivitySendOy.aCtivityName, ConditionOperator.Like, cxact.ActivityName);
                }
                if (!string.IsNullOrEmpty(cxact.CxDiscount))
                {
                    cond &= new OyCondition(CxActivitySendOy.cXDiscount, ConditionOperator.Like, cxact.CxDiscount);
                }
                if (ysmin > 0 && ysmax > 0)
                {
                    cond &= (new OyCondition(CxActivitySendOy.aCtivityBudget, ConditionOperator.GreaterThanOrEqual, ysmin)
                        & new OyCondition(CxActivitySendOy.aCtivityBudget, ConditionOperator.Less, ysmax));
                }
                else
                {
                    if (ysmax > 0)
                    {
                        cond &= new OyCondition(CxActivitySendOy.aCtivityBudget, ConditionOperator.Less, ysmax);
                    } if (ysmin > 0)
                    {
                        cond &= new OyCondition(CxActivitySendOy.aCtivityBudget, ConditionOperator.GreaterThanOrEqual, ysmin);
                    }
                }
            }
            var _mp = ViewData["_MP"] as MPager;
            _mp = _mp == null ? new MPager { PageSize = 20, PageIndex = 1 } : _mp;

            var ls = OyEngine<CxActivitySendOy>.Filter(cond, _mp);


            return View();
        }
예제 #3
0
 public OyCondition(OyCondition left, ConditionOperator op, OyCondition right)
     : base(left, op, right)
 {
 }