根据类生成数据库连接

最新推荐文章于 2023-05-11 09:06:23 发布

weixin_30369087

最新推荐文章于 2023-05-11 09:06:23 发布

阅读量62

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/change4now/p/9176690.html

版权

/// <summary>
        /// 根据类生成数据库连接
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="model"></param>
        /// <param name="tableName">如果为空设置为类名</param>
        /// <param name="needUrlEncode"></param>
        /// <returns></returns>
        public static string GetSql<T>(T model, string tableName = "", bool needUrlEncode = false) where T : class
        {
            try
            {
                if (model == null) return "";
                if (string.IsNullOrEmpty(tableName)) tableName = typeof(T).Name.ToString();
                var sql = "INSERT INTO   " + tableName + " ({0}) VALUES ({1});";
                var prop = model.GetType().GetProperties();
                var fields = "";
                var values = "";
                foreach (var info in prop)
                {

                    fields += string.Format("`{0}`,", info.Name);

                    if (info.PropertyType == typeof(int) || info.PropertyType == typeof(double) ||
                        info.PropertyType == typeof(float) || info.PropertyType == typeof(decimal))
                    {
                        values += string.Format("{0},", Convert.ChangeType(info.GetValue(model), info.PropertyType));
                    }
                    else if (info.PropertyType == typeof(DateTime) || info.PropertyType == typeof(DateTime?))
                    {
                        var v = info.GetValue(model);
                        if (v == null)
                        {
                            values += string.Format("'{0}',", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                        }
                        else
                        {

                            values += string.Format("'{0}',", (Convert.ToDateTime(v)).ToString("yyyy-MM-dd HH:mm:ss"));
                        }
                    }
                    else
                    {
                        var v = (info.GetValue(model) ?? "").ToString();
                        values += string.Format("'{0}',", needUrlEncode ? HttpUtility.UrlEncode(v) : v);
                    }

                }

                return string.Format(sql, fields.TrimEnd(','), values.TrimEnd(','));

            }
            catch (Exception ex)
            {
                LogHelper.Error("根据类生成sql 异常：" + ex.Message);
                return "";
            }

        }