Пример #1
0
        public static bool CheckNickName(string FNickName)
        {
            //判断昵称是否已存在
            bool ExistNickName = ModelOpretion.ScalarDataExist(@" Select * From e_MobileUser
                            where FNickName=@FNickName  ", new { FNickName = FNickName.Trim() });

            return(ExistNickName);
        }
Пример #2
0
        public static bool CheckMobile(string FMobile)
        {
            //判断手机号是否已存在
            bool ExistMobile = ModelOpretion.ScalarDataExist(@" Select * From e_MobileUser
                            where FMobile=@FMobile  ", new { FMobile = FMobile.Trim() });

            return(ExistMobile);
        }
Пример #3
0
        public static bool CheckAccount(string FAccount)
        {
            //用户名是否已存在
            bool ExistAccount = ModelOpretion.ScalarDataExist(@" Select * From e_MobileUser
                            where FAccount=@FAccount  ", new { FAccount = FAccount.Trim() });

            return(ExistAccount);
        }
Пример #4
0
        public TResult Execute <TResult>(Expression expression)
        {
            object obj2;
            var    base2  = ProviderFactory.CreateProvider(dc.dbconn(string.Empty).Reader.DatabaseType);
            var    result = ParseExpression(expression);
            var    type   = typeof(TResult);

            //SqlExecutorBase base3 = base2.CreateSqlExecutor();
            if ((expression.NodeType != ExpressionType.Call) || !type.IsValueType)
            {
                var flag = false;
                if (type.IsGenericType)
                {
                    var reader = ModelOpretion.SearchDataRetunDataTable(result.CommandText,
                                                                        result.SqlQueryParameters, null); //base3.ExecuteReader(result.CommandText, result.Parameters);
                    if (type.GetGenericTypeDefinition() == ReflectorConsts.IEnumerableType)
                    {
                        var   objectType = type.GetGenericArguments()[0];
                        IList list       = null;
                        try
                        {
                            list = EntityMapper.Map(objectType, reader, base2.ObjectPropertyConvertType);
                        }
                        catch
                        {
                            throw new Exception("转化成TResult失败");
                        }


                        return((TResult)list);
                    }
                    if (typeof(Nullable <>).IsAssignableFrom(type))
                    {
                        flag = true;
                    }
                    if (!flag)
                    {
                        throw new Exception();
                    }
                }
                if (type.IsValueType | flag)
                {
                    var obj = ModelOpretion.ScalarBache(result.CommandText, result.SqlQueryParameters, null);
                    if (obj == null)
                    {
                        return(default(TResult));
                    }


                    if (obj == DBNull.Value)
                    {
                        return(default(TResult));
                    }
                    return((TResult)Convert.ChangeType(obj, type));
                }
                if (!EntityConfigurationManager.IsEntity(type))
                {
                    throw new Exception();
                }
                var dataReader = ModelOpretion.SearchDataRetunDataTable(result.CommandText,
                                                                        result.SqlQueryParameters, null);
                IList list2 = null;
                try
                {
                    list2 = EntityMapper.Map(type, dataReader, base2.ObjectPropertyConvertType);
                }
                catch (Exception ex)
                {
                    throw new Exception("TResult:转化成实体失败.");
                }
                finally
                {
                }
                if (list2.Count <= 0)
                {
                    return(default(TResult));
                }
                var entity = list2[0];

                return((TResult)entity);
            }
            //var name = ((MethodCallExpression) expression).Method.Name;
            //if (name != "Any")
            //{
            //    if ((name != "Delete") && (name != "Update"))
            //    {
            //        if ((name != "Average") && (name != "Sum") && (name != "Count"))
            //        {
            //            throw new Exception();
            //        }
            //        obj2 = base3.ExecuteScalar(result.CommandText, result.Parameters);
            //        if (obj2 == DBNull.Value)
            //        {
            //            return default(TResult);
            //        }
            //        var converter1 = new BaseTypeConverter(obj2, type);
            //        converter1.Process();
            //        return (TResult) converter1.Result;
            //    }
            //}
            //else
            //{
            //    DataSet set = base3.ExecuteDataSet(result.CommandText, result.Parameters);
            //    obj2 = set.Tables.Count <= 0 ? 0 : (object) (set.Tables[0].Rows.Count > 0);
            //    return (TResult) obj2;
            //}

            obj2 = ModelOpretion.ScalarBache(result.CommandText,
                                             result.SqlQueryParameters, null);
            return((TResult)obj2);
        }
Пример #5
0
 public List <TElement> FindAs <TElement>(Expression <Func <TElement, bool> > lambdawhere)
 {
     return(ModelOpretion.ModelListInstance <TElement>(lambdawhere));
 }