Exemple #1
0
        /// <summary>
        /// 生成修改数据的Sql表达式
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="updateItem"></param>
        /// <param name="updaterange"></param>
        /// <param name="updatefields"></param>
        /// <param name="paramet"></param>
        /// <returns></returns>
        internal static string GetUpdateSql <T>(
            T updateItem,
            FieldSelectRange updaterange,
            IEnumerable <string> updatefields,
            out IEnumerable <IDataParamet> paramet)
            where T : class
        {
            paramet = null;
            if (updateItem == null)
            {
                throw new ObjectIsNullException(LocalResource.UpdateItem);
            }
            StringBuilder       wheresql = new StringBuilder();
            StringBuilder       setsql   = new StringBuilder();
            List <IDataParamet> paramets = new List <IDataParamet>();
            IDataModel          model    = typeof(T).GetDataModel();
            string namehz = GetIdKeyStringValues(updateItem, model);
            int    c      = 0;

            foreach (var k in model.PrimaryKeys)
            {
                IDataFieldModel f = model.Fields[k.Name];
                DataParamet     p = AppendParamet(paramets, namehz, f, updateItem);
                if (c == 0)
                {
                    wheresql.Append(string.Format("[{0}]={1}", f.Name, p.Name));
                }
                else
                {
                    wheresql.Append(string.Format(" AND [{0}]={1}", f.Name, p.Name));
                }
                c++;
            }
            if (wheresql.Length == 0) //没有任何主键信息
            {
                throw new NotFoundPrimaryKeyException(typeof(T));
            }
            IDataFieldModelCollection fields = model.Fields;

            c = 0;
            foreach (var f in fields)
            {
                if (f.IsRowVersion())
                {
                    continue;
                }
                if (f.GetDbGeneratedDefine() != null)
                {
                    continue;
                }
                if (f.IsPrimaryKey() != null)
                {
                    continue;
                }
                switch (updaterange)
                {
                case FieldSelectRange.All: break;

                case FieldSelectRange.OnlyFields:
                {
                    if (updatefields == null)
                    {
                        continue;
                    }
                    if (updatefields.FirstOrDefault(
                            ff => string.Equals(ff, f.Name, StringComparison.OrdinalIgnoreCase)) == null)
                    {
                        continue;
                    }
                    break;
                }

                case FieldSelectRange.IgnoreFields:
                {
                    if (updatefields != null)
                    {
                        if (updatefields.FirstOrDefault(
                                ff => string.Equals(ff, f.Name, StringComparison.OrdinalIgnoreCase)) != null)
                        {
                            continue;
                        }
                    }
                    break;
                }
                }
                DataParamet p = AppendParamet(paramets, namehz, f, updateItem);
                if (c == 0)
                {
                    setsql.AppendLine(string.Format("[{0}]={1}", f.Name, p.Name));
                }
                else
                {
                    setsql.AppendLine(string.Format(",[{0}]={1}", f.Name, p.Name));
                }
                c++;
            }
            if (setsql.Length == 0)
            {
                return(null);
            }

            paramet = paramets.ToArray();
            return(string.Format("UPDATE [{0}] SET {1} WHERE {2}", model.Name, setsql.ToString(), wheresql.ToString()));
        }
Exemple #2
0
        /// <summary>
        /// 生成添加数据的Sql表达式
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="newitem"></param>
        /// <param name="par"></param>
        /// <returns></returns>
        internal static string GetAddNewSql <T>(
            T newitem, out AddNewSqlExpressOutputParamet par)
            where T : class
        {
            par = null;
            if (newitem == null)
            {
                throw new ObjectIsNullException(LocalResource.AddNewItem);
            }
            StringBuilder             cols     = new StringBuilder();
            StringBuilder             values   = new StringBuilder();
            StringBuilder             setIdsql = new StringBuilder();
            IDataModel                model    = typeof(T).GetDataModel();
            string                    namehz   = GetIdKeyStringValues(newitem, model);
            List <IDataParamet>       paramets = new List <IDataParamet>();
            List <string>             outputGenerateFieldNames = new List <string>();
            IDataFieldModelCollection fields = model.Fields;
            int c = 0;

            foreach (var f in fields)
            {
                if (f.IsRowVersion())
                {
                    continue;
                }
                if (f.GetDbGeneratedDefine() != null)
                {
                    if (f.IsPrimaryKey() != null)
                    {
                        DataParamet p = AppendParamet(paramets, namehz, f, newitem);
                        p.Direction = System.Data.ParameterDirection.InputOutput;
                        outputGenerateFieldNames.Add(f.Name);
                        if (setIdsql.Length == 0)
                        {
                            setIdsql.AppendFormat("SET {0} = SCOPE_IDENTITY()", p.Name);
                        }
                        else
                        {
                            setIdsql.AppendFormat("\r\n SET {0} = SCOPE_IDENTITY()", p.Name);
                        }
                    }
                    continue;
                }
                DataParamet fieldvalue = AppendParamet(paramets, namehz, f, newitem);
                if (c == 0)
                {
                    cols.Append(string.Format("[{0}]", f.Name));
                    values.Append(fieldvalue.Name);
                }
                else
                {
                    cols.AppendFormat(",[{0}]", f.Name);
                    values.AppendFormat(",{0}", fieldvalue.Name);
                }
                c++;
            }
            par = new AddNewSqlExpressOutputParamet(
                outputGenerateFieldNames.ToArray(),
                paramets.ToArray(),
                namehz);
            if (setIdsql.Length == 0)
            {
                return(string.Format("INSERT INTO [{0}] ({1}) \r\n VALUES({2})", model.Name, cols.ToString(), values.ToString()));
            }
            else
            {
                return(string.Format("INSERT INTO [{0}] ({1}) \r\n VALUES({2}) \r\n {3}", model.Name, cols.ToString(), values.ToString(), setIdsql.ToString()));
            }
        }