/// <summary> /// 是否忽略检查字段 /// </summary> /// <param name="field"></param> /// <param name="rangle"></param> /// <param name="ranglefieldnames"></param> /// <returns></returns> private bool IsIgnoreCheckField( IDataFieldModel field, FieldSelectRange rangle, IEnumerable <string> ranglefieldnames) { if (field == null) { return(true); } if (field.IsRowVersion()) { return(true); } if (field.IsSoftDeleteField()) { return(true); } if (field.GetDbGeneratedDefine() != null) { return(true); } switch (rangle) { case FieldSelectRange.IgnoreFields: //忽略指定的字段 { //指定字段是否是忽略的字段 return(ranglefieldnames != null && ranglefieldnames.FirstOrDefault(f => string.Equals(f, field.Name, StringComparison.OrdinalIgnoreCase)) != null); } case FieldSelectRange.OnlyFields: //仅检测指定的字段 { //指定的字段是否在指定字段中 //如果不在则返回true,否则返回false if (ranglefieldnames == null) { return(true); } return(ranglefieldnames.FirstOrDefault(f => string.Equals(f, field.Name, StringComparison.OrdinalIgnoreCase)) == null); } } return(false); }
/// <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())); }
/// <summary> /// 创建字段定义的SQL /// </summary> /// <param name="field">字段模型</param> /// <param name="tablesourcename">表名称</param> /// <param name="stringcollatename">字符排序</param> /// <returns></returns> private static string CreateTableFieldSql( IDataFieldModel field, string tablesourcename, string stringcollatename) { StringBuilder xx = new StringBuilder(); //添加 "[fieldname]" xx.Append(MsSqlServerHelper.GetFeildNameInSqlExpress(field.Name)); if (field.IsRowVersion()) { xx.Append(" [timestamp] NULL"); } else { //添加 " [dbtype]" -> "[fieldname] [dbtype]" xx.AppendFormat(" [{0}]", DbTypeToSqlDbType(field.FieldDbType).ToString().ToLower()); switch (field.FieldDbType) { case System.Data.DbType.AnsiString: case System.Data.DbType.String: { int size = field.GetFieldSize(); if (size <= 0) { size = 50; } if (size == int.MaxValue) { xx.AppendFormat("(max) COLLATE {0}", stringcollatename); } else { xx.AppendFormat("({0}) COLLATE {1}", size, stringcollatename); } //添加 "(size) COLLATE ....." -> "[fieldname] [dbtype](size) COLLATE...." break; } case System.Data.DbType.Decimal: { int l = 18; int dot = 4; var d = field.GetDecimalDefine(); if (d != null) { l = d.DecimalLength; dot = d.DotLength; if (l <= 0) { l = 18; } if (dot < 0) { dot = 0; } } //添加 "(length,dotlength)" -> "[fieldname] [dbtype](length,dotlength)" xx.AppendFormat("({0},{1})", l, dot); break; } case System.Data.DbType.Int16: case System.Data.DbType.Int32: case System.Data.DbType.Int64: { var g = field.GetDbGeneratedDefine(); if (g != null) { //添加 " IDENTITY(start,step)" -> "[fieldname] [dbtype]IDENTITY(start,step)" xx.AppendFormat(" IDENTITY({0},{1})", g.StartValue, g.Step); } break; } } if (field.CanbeNull()) { xx.Append(" NULL"); } else { xx.Append(" NOT NULL"); } string defaultvalue = field.GetDefaultValue(); if (!string.IsNullOrEmpty(defaultvalue)) { xx.AppendFormat(" CONSTRAINT [DF_{0}_{1}_defaultvalue] DEFAULT ({2})", tablesourcename, field.Name, defaultvalue); } } return(xx.ToString()); }