Exemplo n.º 1
0
        }/// <summary>

        /// 获取用户列表
        /// </summary>
        /// <param name="userName"></param>
        /// <param name="PageSize"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public ActionResult GetUerList(string userName, int limit, int page)
        {
            Sql sql = new Sql();
            int totalAmount;

            try
            {
                using (var db = new LayUIDemo.Models.DBMall())
                {
                    if (!string.IsNullOrEmpty(userName))
                    {
                        //sql.Append("where UserName=@0", userName);
                        var query = from p in db.Userinfo
                                    where p.UserName == userName
                                    orderby p.CreateTime
                                    select p;
                        totalAmount = query.Count();
                        return(Json(ResultTemp <UserInfo> .OK(query.Skip((page - 1) * limit).Take(limit).ToList(), totalAmount), JsonRequestBehavior.AllowGet));
                    }
                    // var result = db.Page<UserInfo>(page, limit, sql);
                    var result = from p in db.Userinfo
                                 orderby p.CreateTime
                                 select p;
                    totalAmount = result.Count();
                    return(Json(ResultTemp <UserInfo> .OK(result.Skip((page - 1) * limit).Take(limit).ToList(), totalAmount), JsonRequestBehavior.AllowGet));
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// Converts a DataTable to a List&lt;TSource&gt;
        /// </summary>
        /// <typeparam name="TSource"></typeparam>
        /// <param name="dataTable"></param>
        /// <returns></returns>
        public static List <TSource> ToList <TSource>(this DataTable dataTable, bool replaceResourceKeys)
        {
            EnumerableRowCollection <DataRow> EnumerableRowCollectionDataRowObj = dataTable.AsEnumerable();
            List <TSource> ListResult = new List <TSource>();

            if (EnumerableRowCollectionDataRowObj != null)
            {
                string  dtValueOriginal;
                TSource ResultTemp;
                foreach (DataRow dr in EnumerableRowCollectionDataRowObj)
                {
                    ResultTemp = Activator.CreateInstance <TSource>();
                    foreach (var prop in ResultTemp.GetType().GetProperties())
                    {
                        if (dr.Table.Columns.Contains(prop.Name))
                        {
                            var dtValue = dr[prop.Name] is DBNull ? (prop.PropertyType == typeof(string) ? string.Empty : null) : dr[prop.Name];

                            if (dtValue.IsNotNull() && dtValue.GetType() == typeof(string))
                            {
                                dtValue = (dtValue as string).Trim();
                            }

                            //To support the multilingual records it is necessary to use {#itemvalue} in the DB records
                            if (dtValue.IsNotNull() && replaceResourceKeys && dtValue.AsString().StartsWith("{#") && dtValue.AsString().EndsWith("}"))
                            {
                                dtValueOriginal = dtValue.AsString();
                                //dtValue = Strings.ResourceManager.GetString(dtValue.AsString().Substring(2, dtValue.AsString().Length - 3));
                                dtValue = dtValue.AsString().Substring(2, dtValue.AsString().Length - 3).GetStringFromResource();

                                //If the Resource file lookup returns empty then display the original key value
                                if (dtValue.AsString().IsEmptyOrWhiteSpace())
                                {
                                    dtValue = dtValueOriginal;
                                }
                            }
                            ResultTemp.SetPropertyValue(prop.Name, dtValue);
                        }
                    }
                    ListResult.Add(ResultTemp);
                }
            }
            return(ListResult);
        }