• C#实体类模板


    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Data;
    using System.Data.SqlClient;
    
    namespace SNS_Entitys
    {
        public class SNSBlog
        {
            /// <summary>
            /// 空实例化
            /// </summary>
            public SNSBlog(){}
    
            /// <summary>
            /// 使用DataRow实例化
            /// </summary>
            /// <param name="dr"></param>
            public SNSBlog(DataRow dr)
            {
                SetBlog(dr);
            }
    
            /// <summary>
            /// 设置博文数据
            /// </summary>
            /// <param name="dr"></param>
            public void SetBlog(DataRow dr)
            {
                if (dr.Table.Columns.Contains("Id") && dr["Id"] != DBNull.Value && dr["Id"] != null)
                    Id = Convert.ToInt32(dr["Id"]);
                if (dr.Table.Columns.Contains("Topic") && dr["Topic"] != DBNull.Value && dr["Topic"] != null)
                    Topic = dr["Topic"].ToString();
            }
    
            /// <summary>
            /// 将类转化为SQL参数
            /// </summary>
            /// <returns>SQL参数数组</returns>
            public SqlParameter[] ConvertToSqlParamenter()
            {
                SqlParameter[] parameters=new SqlParameter[]{
                    new SqlParameter("@Id",Id)
                    ,new SqlParameter("@Topic",Topic)
                };
                return parameters;
            }
    
    
            #region 博文信息
    
            private string topic = "";
            /// <summary>
            /// 话题
            /// </summary>
            public string Topic
            {
                get { return topic; }
                set { topic = value; }
            }
            
            public long _id = 0;
            /// <summary>
            /// 博文编号
            /// </summary>
            public long Id
            {
                get { return _id; }
                set { _id = value; }
            }
    		
            #endregion
        }
    }
  • 相关阅读:
    RabbitMQ 安装
    redis windows安装
    Python Scrapy 爬取煎蛋网妹子图实例(二)
    Python Scrapy 爬取煎蛋网妹子图实例(一)
    Python pymysql 增删改查封装
    Python Scrapy 爬虫框架实例(一)
    Mac Anaconda 简单介绍 -- 环境管理
    python Scrapy 常见问题记录
    Hive json字符串解析
    大数据
  • 原文地址:https://www.cnblogs.com/henw/p/2632263.html
Copyright © 2020-2023  润新知