Exemplo n.º 1
0
        /// <summary>
        /// 批量添加
        /// </summary>
        /// <param name="Model"></param>
        /// <returns></returns>
        public bool GDAddBatch <T>(List <T> ListModel) where T : new()
        {
            List <string>           ListValue     = new List <string>();
            List <SqlParameter>     ListObject    = new List <SqlParameter>();
            List <GDModel.SQLModel> ListParameter = null;
            int n = 0;
            int c = ListModel.Count;

            foreach (var item in ListModel)
            {
                SQLPropertyInfo PropertyInfos = new SQLPropertyInfo();
                ListParameter = PropertyInfos.GDGetPropertys(item, BaseType, n);
                if (ListParameter == null || ListParameter.Count == 0)
                {
                    return(false);
                }
                ListParameter = ListParameter.Where(w => !w.IsIncrease).ToList();
                string[] valuestr = new string[ListParameter.Count];
                for (int i = 0; i < valuestr.Length; i++)
                {
                    valuestr[i] = ListParameter[i].ParameterName;
                    ListObject.Add(ListParameter[i].Parameter as SqlParameter);
                }
                ListValue.Add($"({string.Join(",", valuestr)})");
                n++;
            }
            return(BsExecute($"insert into {typeof(T).Name}({string.Join(",", ListParameter.Select(s => s.Field).ToList())}) values {string.Join(",", ListValue)}", c, ListObject.ToArray()));
        }
Exemplo n.º 2
0
        /// <summary>
        /// 根据Key删除
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="Model"></param>
        /// <returns></returns>
        public bool GDeleteByKey <T>(T Model) where T : new()
        {
            SQLPropertyInfo         PropertyInfos = new SQLPropertyInfo();
            List <GDModel.SQLModel> ListParameter = PropertyInfos.GDGetPropertys(Model, BaseType);
            var Keys = ListParameter.Where(w => w.IsKey).Select(s => new { Field = s.Field, Value = s.Value }).ToList().First();

            return(BsExecute($"DELETE FROM {typeof(T).Name} WHERE {Keys.Field + "=" + Keys.Value.ToValStr()}"));
        }
Exemplo n.º 3
0
        /// <summary>
        /// 根据Key更新
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="Model"></param>
        /// <param name="Exp"></param>
        /// <returns></returns>
        public bool GDUpdateByKey <T>(T Model) where T : new()
        {
            SQLPropertyInfo         PropertyInfos = new SQLPropertyInfo();
            List <GDModel.SQLModel> ListParameter = PropertyInfos.GDGetPropertys(Model, BaseType);
            var Keys     = ListParameter.Where(w => w.IsKey).Select(s => new { Field = s.Field, Value = s.Value }).ToList().First();
            var GetColum = ListParameter.Where(w => !w.IsKey).Select(s => new { Field = (s.Field + "=" + s.ParameterName), Parameter = s.Parameter }).ToList();

            return(BsExecute($"UPDATE {typeof(T).Name} SET {string.Join(",", GetColum.Select(s => s.Field).ToList())} where {Keys.Field + "=" + Keys.Value}", GetColum.Select(s => s.Parameter as SqlParameter).ToArray()));
        }
Exemplo n.º 4
0
        /// <summary>
        /// 更新操作
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="Model"></param>
        /// <param name="Exp"></param>
        /// <returns></returns>
        public bool GDUpdate <T>(T Model, Expression <Func <T, bool> > Exp = null) where T : new()
        {
            string Where = Exp.DealExpress();

            Where = string.IsNullOrEmpty(Where) ? "" : (" and " + Where);
            SQLPropertyInfo         PropertyInfos = new SQLPropertyInfo();
            List <GDModel.SQLModel> ListParameter = PropertyInfos.GDGetPropertys(Model, BaseType);
            var GetColum = ListParameter.Where(w => !w.IsKey).Select(s => new { Field = (s.Field + "=" + s.ParameterName), Parameter = s.Parameter }).ToList();

            return(BsExecute($"UPDATE {typeof(T).Name} SET {string.Join(",", GetColum.Select(s => s.Field).ToList())} where 1=1 {Where}", GetColum.Select(s => s.Parameter as SqlParameter).ToArray()));
        }
Exemplo n.º 5
0
        /// <summary>
        /// 新增
        /// </summary>
        /// <typeparam name="T">实体</typeparam>
        /// <param name="Model">实体</param>
        /// <returns></returns>
        public bool GDAdd <T>(T Model) where T : new()
        {
            SQLPropertyInfo         PropertyInfos = new SQLPropertyInfo();
            List <GDModel.SQLModel> ListParameter = PropertyInfos.GDGetPropertys(Model, BaseType);

            if (ListParameter == null || ListParameter.Count == 0)
            {
                return(false);
            }
            var GetColum = ListParameter.Where(w => !w.IsIncrease).Select(s => new { s.Field, s.Parameter }).ToList();

            return(BsExecute($"insert into {typeof(T).Name}({string.Join(",", GetColum.Select(s => s.Field).ToList())}) VALUES({string.Join(",", GetColum.Select(s => "@" + s.Field).ToList())})", GetColum.Select(s => s.Parameter as SqlParameter).ToArray()));
        }
Exemplo n.º 6
0
        /// <summary>
        /// 获取一条数据
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="Model"></param>
        /// <returns></returns>
        public T GDInfo <T>(T Model, Expression <Func <T, bool> > Exp = null) where T : new()
        {
            T      t     = new T();
            string Where = Exp.DealExpress();

            Where = string.IsNullOrEmpty(Where) ? "" : (" and " + Where);
            SQLPropertyInfo         PropertyInfos = new SQLPropertyInfo();
            List <GDModel.SQLModel> ListParameter = PropertyInfos.GDGetPropertys(Model, BaseType);
            DataRow dr = BsRows($"select * from {typeof(T).Name} where 1=1 {Where}");

            if (dr == null)
            {
                return(t);
            }
            else
            {
                return(dr.ToModel <T>());
            }
        }