Ejemplo n.º 1
0
        /// <summary>
        /// 逐条插入
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="t"></param>
        /// <returns></returns>
        public bool InsertData <T>(T t)
        {
            Type   type   = typeof(T);
            string strsql = GeneratorInsertSql(type);

            if (strsql == null)
            {
                return(false);
            }
            PropertyInfo[] pinfos    = type.GetProperties();
            Hashtable      hashTable = new Hashtable();

            foreach (PropertyInfo pinfo in pinfos)
            {
                DataAttr pdataAttr = (DataAttr)pinfo.GetCustomAttribute(typeof(DataAttr), false);
                if (pdataAttr == null)
                {
                    continue;
                }
                if (pdataAttr.IsIdentity)
                {
                    continue;
                }
                string para  = "@" + pdataAttr.QueryStr;
                object value = pinfo.GetValue(t);
                hashTable.Add(para, value);
            }
            return(ExecuteNonQuery(strsql, hashTable));
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 批量插入
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="lisT">要插入的对象List</param>
        /// <returns></returns>
        public bool InsertData <T>(List <T> lisT)
        {
            Type      type     = typeof(T);
            DataTable dtSource = ConvertListToDataTable(lisT);

            if (dtSource == null)
            {
                return(false);
            }
            DataAttr dataAttr = (DataAttr)type.GetCustomAttribute(typeof(DataAttr), false);

            if (dataAttr == null || dataAttr.Type == QueryType.QuerySql)
            {
                return(false);
            }
            using (SqlBulkCopy sqlBC = new SqlBulkCopy(Connection as SqlConnection))
            {
                sqlBC.DestinationTableName = dataAttr.QueryStr;
                try
                {
                    //导入到数据库
                    sqlBC.WriteToServer(dtSource);
                }
                catch (Exception ex)
                {
                    return(false);
                }
                sqlBC.WriteToServer(dtSource);
                sqlBC.Close();
            }
            return(true);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 更新根据Key
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public bool UpdateByID(object data)
        {
            Type          type                 = data.GetType();
            DataAttr      dataAttr             = (DataAttr)type.GetCustomAttribute(typeof(DataAttr), false);
            StringBuilder sb                   = new StringBuilder();
            Dictionary <string, object> keyDic = new Dictionary <string, object>();

            sb.Append("UPDATE  ");
            sb.Append(dataAttr.QueryStr);
            sb.Append(" Set ");
            PropertyInfo[] propertyInfos = type.GetProperties();
            foreach (PropertyInfo info in propertyInfos)
            {
                DataAttr infoAttr = (DataAttr)info.GetCustomAttribute(typeof(DataAttr), false);
                if (infoAttr == null)
                {
                    continue;
                }
                if (infoAttr.IsKey)
                {
                    keyDic.Add(infoAttr.QueryStr, info.GetValue(data));
                }
                else
                {
                    sb.Append(infoAttr.QueryStr + " =@" + infoAttr.QueryStr + " ,");
                }
            }
            sb.Remove(sb.Length - 1, 1);//移除 多余的 ","
            sb.Append(" WHERE ");
            foreach (string key in keyDic.Keys)
            {
                sb.Append(key + " =@" + key + " AND ");
            }
            sb.Remove(sb.Length - 5, 5);//移除多余的 'AND'

            Hashtable hashTable = new Hashtable();

            for (int i = 0; i < propertyInfos.Length; ++i)
            {
                PropertyInfo info     = propertyInfos[i];
                DataAttr     infoAttr = (DataAttr)info.GetCustomAttribute(typeof(DataAttr), false);
                if (infoAttr == null)
                {
                    continue;
                }
                string strPara = "@" + infoAttr.QueryStr;
                object value   = info.GetValue(data);
                hashTable.Add(strPara, value);
            }
            return(ExecuteNonQuery(sb.ToString(), hashTable));
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 生成插入的sql语句
        /// </summary>
        /// <param name="type"></param>
        /// <param name="errorStr"></param>
        /// <returns></returns>
        private string GeneratorInsertSql(Type type)
        {
            StringBuilder strb     = new StringBuilder();
            DataAttr      dataAttr = (DataAttr)type.GetCustomAttribute(typeof(DataAttr), false);

            if (dataAttr == null)
            {
                return(null);
            }

            if (dataAttr.Type == QueryType.Name)
            {
                strb.Append("insert into [" + dataAttr.QueryStr + "] (");
            }
            PropertyInfo[] pinfos = type.GetProperties();
            foreach (PropertyInfo pinfo in pinfos)
            {
                DataAttr pdataAttr = (DataAttr)pinfo.GetCustomAttribute(typeof(DataAttr), false);
                if (pdataAttr == null)
                {
                    continue;
                }
                if (pdataAttr.IsIdentity)
                {
                    continue;
                }
                strb.Append(pdataAttr.QueryStr + ",");
            }
            strb.Remove(strb.Length - 1, 1);
            strb.Append(") values (");
            foreach (PropertyInfo pinfo in pinfos)
            {
                DataAttr pdataAttr = (DataAttr)pinfo.GetCustomAttribute(typeof(DataAttr), false);
                if (pdataAttr == null)
                {
                    continue;
                }
                if (pdataAttr.IsIdentity)
                {
                    continue;
                }
                strb.Append("@" + pdataAttr.QueryStr + ",");
            }
            strb.Remove(strb.Length - 1, 1);
            strb.Append(")");
            return(strb.ToString());
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 查询
        /// </summary>
        /// <typeparam name="T">对象</typeparam>
        /// <returns>返回的对象List</returns>
        public List <T> SelectData <T>(SearchCondition searchCondition)
        {
            string   strsql   = "";
            Type     type     = typeof(T);
            List <T> listT    = new List <T>();
            DataAttr dataAttr = (DataAttr)type.GetCustomAttribute(typeof(DataAttr), false);

            if (dataAttr.Type == QueryType.Name)
            {
                strsql = "select * from [" + dataAttr.QueryStr + "]" + searchCondition.BuildConditionSql();
            }
            else
            {
                strsql = dataAttr.QueryStr + searchCondition.BuildConditionSql();
            }
            MySqlDataReader sdr = (MySqlDataReader)ExecuteReader(strsql);

            PropertyInfo[] pinfos = type.GetProperties();
            while (sdr.Read())
            {
                T t = Activator.CreateInstance <T>();
                foreach (PropertyInfo pinfo in pinfos)
                {
                    DataAttr pdataAttr = (DataAttr)pinfo.GetCustomAttribute(typeof(DataAttr), false);
                    if (pdataAttr == null)
                    {
                        continue;
                    }
                    for (int i = 0; i < sdr.FieldCount; ++i)
                    {
                        if (sdr[pdataAttr.QueryStr] == DBNull.Value)
                        {
                            pinfo.SetValue(t, null);
                        }
                        else
                        {
                            pinfo.SetValue(t, sdr[pdataAttr.QueryStr]);
                        }
                    }
                }
                listT.Add(t);
            }
            return(listT);
        }
Ejemplo n.º 6
0
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="type">数据类型</param>
        /// <param name="errorStr"></param>
        /// <returns>List<Object></returns>
        public override List <object> SelectData(Type type)
        {
            string        strsql   = "";
            List <object> listT    = new List <object>();
            DataAttr      dataAttr = (DataAttr)type.GetCustomAttribute(typeof(DataAttr), false);

            if (dataAttr.Type == QueryType.Name)
            {
                strsql = "select * from [" + dataAttr.QueryStr + "]";
            }
            else
            {
                strsql = dataAttr.QueryStr;
            }
            MySqlDataReader sdr = (MySqlDataReader)ExecuteReader(strsql);

            PropertyInfo[] pinfos = type.GetProperties();
            while (sdr.Read())
            {
                object t = new object();
                foreach (PropertyInfo pinfo in pinfos)
                {
                    DataAttr pdataAttr = (DataAttr)pinfo.GetCustomAttribute(typeof(DataAttr), false);
                    if (pdataAttr == null)
                    {
                        continue;
                    }
                    for (int i = 0; i < sdr.FieldCount; ++i)
                    {
                        if (sdr[pdataAttr.QueryStr] == DBNull.Value)
                        {
                            pinfo.SetValue(t, null);
                        }
                        else
                        {
                            pinfo.SetValue(t, sdr[pdataAttr.QueryStr]);
                        }
                    }
                }
                listT.Add(t);
            }
            return(listT);
        }
Ejemplo n.º 7
0
        /// <summary>
        /// 将List转换成DataTable
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="listT"></param>
        /// <returns></returns>
        public static DataTable ConvertListToDataTable <T>(List <T> listT)
        {
            DataTable dtSource = new DataTable();
            Type      type     = typeof(T);

            PropertyInfo[] pinfos = type.GetProperties();
            foreach (PropertyInfo pinfo in pinfos)
            {
                DataAttr dataAttr = (DataAttr)pinfo.GetCustomAttribute(typeof(DataAttr), false);
                if (dataAttr == null)
                {
                    continue;;
                }
                DataColumn dc = new DataColumn(dataAttr.QueryStr, pinfo.PropertyType);
                dtSource.Columns.Add(dc);
            }
            foreach (T t in listT)
            {
                object[] objs = new object[dtSource.Columns.Count];
                for (int i = 0; i < dtSource.Columns.Count; ++i)
                {
                    DataColumn dc = dtSource.Columns[i];
                    foreach (PropertyInfo pinfo in pinfos)
                    {
                        DataAttr pdataAttr = (DataAttr)pinfo.GetCustomAttribute(typeof(DataAttr), false);
                        if (pdataAttr == null)
                        {
                            continue;
                        }
                        if (pdataAttr.QueryStr == dc.ColumnName)
                        {
                            objs[i] = pinfo.GetValue(t);
                        }
                    }
                }
                dtSource.Rows.Add(objs);
            }
            return(dtSource);
        }
Ejemplo n.º 8
0
        /// <summary>
        /// 将DataRow 转 T
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="dr"></param>
        /// <returns></returns>
        public static T ConvertDataRowToT <T>(DataRow dr)
        {
            Type type = typeof(T);
            T    t    = (T)Activator.CreateInstance(type);

            PropertyInfo[] pInfos = type.GetProperties();
            foreach (DataColumn dc in dr.Table.Columns)
            {
                foreach (PropertyInfo info in pInfos)
                {
                    DataAttr infoAttr = (DataAttr)info.GetCustomAttribute(typeof(DataAttr), false);
                    if (infoAttr == null)
                    {
                        continue;
                    }
                    if (infoAttr.QueryStr.Equals(dc.ColumnName))
                    {
                        if (info.PropertyType.Name.Equals("String"))
                        {
                            if (dr[dc.ColumnName] == DBNull.Value)
                            {
                                info.SetValue(t, "");
                            }
                            else
                            {
                                info.SetValue(t, dr[dc.ColumnName]);
                            }
                        }
                        else
                        {
                            info.SetValue(t, dr[dc.ColumnName]);
                        }
                    }
                }
            }
            return(t);
        }