コード例 #1
0
ファイル: MongoDBQuery.cs プロジェクト: zmk523/CRL3
 public override List <TResult> QueryResult <TResult>(LambdaQuery.LambdaQueryBase query, NewExpression newExpression)
 {
     throw new NotSupportedException("MongoDB暂未实现此方法");
 }
コード例 #2
0
ファイル: MongoDBQuery.cs プロジェクト: zmk523/CRL3
 public override List <dynamic> QueryDynamic(LambdaQuery.LambdaQueryBase query)
 {
     throw new NotSupportedException("MongoDB暂未实现此方法");
 }
コード例 #3
0
        /// <summary>
        /// 获取关联删除语句
        /// </summary>
        /// <param name="t1"></param>
        /// <param name="t2"></param>
        /// <param name="condition"></param>
        /// <returns></returns>
        public virtual string GetRelationDeleteSql(string t1, string t2, string condition, LambdaQuery.LambdaQueryBase query)
        {
            string table = string.Format("{0} t1", KeyWordFormat(t1), KeyWordFormat(t2));
            string sql   = string.Format("delete t1 from {0} {1}", table, condition);

            return(sql);
        }
コード例 #4
0
        /// <summary>
        /// 获取关联更新语名
        /// </summary>
        /// <param name="t1"></param>
        /// <param name="t2"></param>
        /// <param name="condition"></param>
        /// <param name="setValue"></param>
        /// <returns></returns>
        public virtual string GetRelationUpdateSql(string t1, string t2, string condition, string setValue, LambdaQuery.LambdaQueryBase query)
        {
            string table = string.Format("{0} t1", KeyWordFormat(t1), KeyWordFormat(t2));
            string sql   = string.Format("update t1 set {0} from {1} {2}", setValue, table, condition);

            return(sql);
        }
コード例 #5
0
        public override string GetRelationUpdateSql(string t1, string t2, string condition, string setValue, LambdaQuery.LambdaQueryBase query)
        {
            //update table1,table2, set a=1 where table1.id=table2.id and  id>2
            string table = string.Format("{0} t1,{1} t2", KeyWordFormat(t1), KeyWordFormat(t2));

            var where = query.__Relations.First().Value.condition;
            if (query.Condition.Length > 0)
            {
                where += string.Format(" and {0}", query.Condition);
            }
            string sql = string.Format(@"UPDATE {0} SET {1} where {2}", table, setValue, where);

            return(sql);
        }
コード例 #6
0
 //public override List<TResult2> QueryDynamic<TModel, TResult, TResult2>(LambdaQuery<TModel> query, Expression<Func<TModel, TResult, TResult2>> resultSelector)
 //{
 //    throw new NotImplementedException();
 //}
 public override List <TResult> QueryResult <TResult>(LambdaQuery.LambdaQueryBase query, NewExpression newExpression)
 {
     throw new NotImplementedException();
 }