示例#1
0
        public static List <Recomment> GetToUploadList()
        {
            List <Recomment> list = new List <Recomment>();

            try
            {
                ISelectDataSourceFace query = new SelectSQL(TableName.Recomment);
                query.DataBaseAlias = Const.LogConnection;
                query.AddWhere("ImageStatus", ImageStatus.Local);
                DataSet ds = query.ExecuteDataSet();
                if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                {
                    list.AddRange(from DataRow dr in ds.Tables[0].Rows
                                  select new Recomment()
                    {
                        BlogId    = SafeValueHelper.ToInt32(dr["BlogId"]),
                        Category  = (RecommentCategory)SafeValueHelper.ToInt32(dr["Category"]),
                        CoverName = SafeValueHelper.ToString(dr["CoverName"]),
                        Id        = SafeValueHelper.ToInt32(dr["Id"]),
                        Title     = SafeValueHelper.ToString(dr["Title"]),
                    });
                }
            }
            catch (Exception ex)
            {
                Logger.Error(ex);
            }
            return(list);
        }
示例#2
0
        public static List <ImageUrl> GetToUploadList()
        {
            List <ImageUrl> list = new List <ImageUrl>();

            try
            {
                ISelectDataSourceFace query = new SelectSQL(TableName.ImageUrl);
                query.DataBaseAlias = Const.LogConnection;
                query.AddWhere("ImageStatus", ImageStatus.Local);
                DataSet ds = query.ExecuteDataSet();
                if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                {
                    list.AddRange(from DataRow dr in ds.Tables[0].Rows
                                  select new ImageUrl()
                    {
                        BlogId = SafeValueHelper.ToInt32(dr["BlogId"]),
                        Url    = SafeValueHelper.ToString(dr["Url"]),
                        Id     = SafeValueHelper.ToInt32(dr["Id"])
                    });
                }
            }
            catch (Exception ex)
            {
                Logger.Error(ex);
            }
            return(list);
        }
示例#3
0
 private static DataSet GetAccountDataSet()
 {
     try
     {
         ISelectDataSourceFace query = new SelectSQL("UploadAccount");
         query.DataBaseAlias = "LogConnection";
         query.AddWhere("Enabled", true);
         return(query.ExecuteDataSet());
     }
     catch (Exception ex)
     {
         Logger.Error(ex);
         return(null);
     }
 }