public void Save(Context context) { if (context.ExportMode || updateAttr[Constants.updateAttrCreated]) { GmCommand cmd = context.TargetConn.CreateCommandById("insertIntoGisRanges"); cmd.AddInt("Id", id); cmd.AddInt("TypeId", type.Id); context.Buf.SetRect(cmd.AddBinary("Code"), bounds); cmd.ExecuteNonQuery(); if (!context.ExportMode) { updateAttr = 0; } } if (context.Filter == null) { return; } if (!context.Filter.Includes(BatchLevel.Object)) { return; } if (objects != null) { foreach (GObject obj in objects) { obj.Save(context); } } }
public void Save(Context context) { if (this.IsOverall) { return; } if (context.ExportMode || updateAttr[Constants.updateAttrCreated]) { GmCommand cmd = context.TargetConn.CreateCommandById("insertIntoGisViews"); cmd.AddInt("Id", id); cmd.AddInt("Attr", attr); cmd.AddString("Name", name, MaxLength.Name); context.Buf.SetIntArray(cmd.AddBinary("Code"), GetIntArray()); cmd.ExecuteNonQuery(); } else if (updateAttr.NonEmpty) { GmCommand cmd = context.Conn.CreateCommand(); string cmdText = ""; if (updateAttr[(int)ViewField.Attr]) { cmdText += "Attr= @Attr,"; cmd.AddInt("Attr", attr); } if (updateAttr[(int)ViewField.Name]) { cmdText += "Name= @Name,"; cmd.AddString("Name", name, MaxLength.Name); } if (updateAttr[(int)ViewField.Code]) { cmdText += "Code= @Code,"; context.Buf.SetIntArray(cmd.AddBinary("Code"), this.GetIntArray()); } Geomethod.StringUtils.RemoveLastChar(ref cmdText); cmd.CommandText = "update gisViews set " + cmdText + " where Id= @Id"; cmd.AddInt("Id", id); cmd.ExecuteNonQuery(); } if (!context.ExportMode) { updateAttr = 0; } }
public void Save(GmConnection conn) { GmCommand cmd = conn.CreateCommand(); cmd.AddInt("Id", id); cmd.AddString("Name", name); cmd.AddBinary("Permissions", permissions.GetBytes()); cmd.AddInt("WatchingGroupId", watchingGroupId); if (id == 0) { cmd.CommandText = "insert into Roles values (@Name,@Permissions,@WatchingGroupId) select @@Identity"; id = (int)(decimal)cmd.ExecuteScalar(); } else { cmd.CommandText = "update Roles set Name=@Name, Permissions=@Permissions, WatchingGroupId=@WatchingGroupId where Id=@Id"; cmd.ExecuteNonQuery(); } }
public void Save(GmConnection conn) { GmCommand cmd = conn.CreateCommand(); cmd.AddInt("Id", id); cmd.AddString("Name", name); cmd.AddInt("RoleId", roleId); cmd.AddString("Login", login); cmd.AddString("Password", password); cmd.AddBinary("Permissions").Value = permissions.Count == 0 ? (object)DBNull.Value : (object)permissions.GetBytes(); if (id == 0) { cmd.CommandText = "insert into Users values (@Name,@RoleId,@Login,@Password,@Permissions) select @@Identity"; id = (int)(decimal)cmd.ExecuteScalar(); } else { string pswCmdText = password.Trim().Length == 0 ? "" : ",Password=@Password"; cmd.CommandText = string.Format("update Users set Name=@Name,RoleId=@RoleId,Login=@Login{0},Permissions=@Permissions where Id=@Id", pswCmdText); cmd.ExecuteNonQuery(); } }
public void Save(Context context) { if (context.ExportMode || updateAttr[Constants.updateAttrCreated]) { GmCommand cmd = context.TargetConn.CreateCommandById("insertIntoGisLib"); cmd.AddInt("Id", id); cmd.AddInt("Attr", attr); cmd.AddString("Name", name, MaxLength.Name); cmd.AddString("Style", styleStr, MaxLength.Style); // DZ 14.01.08 // if( defaultStyleStr == "" ) // cmd.AddString( "DefaultStyle", /*defaultStyleStr*/ " ", MaxLength.Style ); // else cmd.AddString("DefaultStyle", defaultStyleStr, MaxLength.Style); cmd.AddInt("SMin", smin); cmd.AddInt("SMax", smax); cmd.AddBinary("Code", context.Buf.SetRect(bounds)); cmd.AddBinary("IndexerCode", context.Buf.SetIntArray(indexer.ToIntArray())); cmd.AddBinary("Scales", context.Buf.SetIntArray(scales.Values)); cmd.ExecuteNonQuery(); } else if (updateAttr.NonEmpty) { GmCommand cmd = context.Conn.CreateCommand(); string cmdText = ""; if (updateAttr[(int)LibField.Attr]) { cmdText += "Attr= @Attr,"; cmd.AddInt("Attr", attr); } if (updateAttr[(int)LibField.Name]) { cmdText += "Name= @Name,"; cmd.AddString("Name", name, MaxLength.Name); } if (updateAttr[(int)LibField.Style]) { cmdText += "Style= @Style,"; cmd.AddString("Style", styleStr, MaxLength.Style); } if (updateAttr[(int)LibField.DefaultStyle]) { cmdText += "DefaultStyle= @DefaultStyle,"; cmd.AddString("DefaultStyle", defaultStyleStr, MaxLength.Style); } if (updateAttr[(int)LibField.SMin]) { cmdText += "SMin= @SMin,"; cmd.AddInt("SMin", smin); } if (updateAttr[(int)LibField.SMax]) { cmdText += "SMax= @SMax,"; cmd.AddInt("SMax", smax); } if (updateAttr[(int)LibField.Code]) { cmdText += "Code= @Code,"; cmd.AddBinary("Code", context.Buf.SetRect(bounds)); } if (updateAttr[(int)LibField.IndexerCode]) { cmdText += "IndexerCode= @IndexerCode,"; cmd.AddBinary("IndexerCode", context.Buf.SetIntArray(indexer.ToIntArray())); } if (updateAttr[(int)LibField.Scales]) { cmdText += "Scales= @Scales,"; cmd.AddBinary("Scales", context.Buf.SetIntArray(scales.Values)); } Geomethod.StringUtils.RemoveLastChar(ref cmdText); cmd.CommandText = "update gisLib set " + cmdText + " where Id= @Id"; cmd.AddInt("Id", id); cmd.ExecuteNonQuery(); } if (!context.ExportMode) { updateAttr = 0; } if (context.Filter != null && context.Filter.Includes(BatchLevel.Type)) { if (types != null) { foreach (GType type in types) { type.Save(context); } } } if (context.ExportMode) { idGenerator.Save(context.TargetConn); } colors.Save(context); layers.Save(context); views.Save(context); bgImages.Save(context); customTables.Save(context); }
public void Save(Context context) { if (context.ExportMode || updateAttr[Constants.updateAttrCreated]) { GmCommand cmd = context.TargetConn.CreateCommandById("insertIntoGisBg"); cmd.AddInt("Id", id); cmd.AddInt("Attr", attr); cmd.AddString("Style", styleStr, MaxLength.Style); cmd.AddString("TextAttr", textAttr, MaxLength.TextAttr); cmd.AddString("FilePath", filePath, MaxLength.FilePath); cmd.AddInt("SMin", smin); cmd.AddInt("SMax", smax); context.Buf.SetIntArray(cmd.AddBinary("Code"), GetIntArray()); cmd.ExecuteNonQuery(); } else if (updateAttr.NonEmpty) { GmCommand cmd = context.Conn.CreateCommand(); string cmdText = ""; if (updateAttr[(int)BgImageField.Attr]) { cmdText += "Attr= @Attr,"; cmd.AddInt("Attr", attr); } if (updateAttr[(int)BgImageField.Style]) { cmdText += "Style= @Style,"; cmd.AddString("Style", styleStr, MaxLength.Style); } if (updateAttr[(int)BgImageField.TextAttr]) { cmdText += "TextAttr= @TextAttr,"; cmd.AddString("TextAttr", textAttr, MaxLength.TextAttr); } if (updateAttr[(int)BgImageField.FilePath]) { cmdText += "FilePath= @FilePath,"; cmd.AddString("FilePath", filePath, MaxLength.FilePath); } if (updateAttr[(int)BgImageField.SMin]) { cmdText += "SMin= @SMin,"; cmd.AddInt("SMin", smin); } if (updateAttr[(int)BgImageField.SMax]) { cmdText += "SMax= @SMax,"; cmd.AddInt("SMax", smax); } if (updateAttr[(int)BgImageField.Code]) { cmdText += "Code= @Code,"; context.Buf.SetIntArray(cmd.AddBinary("Code"), this.GetIntArray()); } Geomethod.StringUtils.RemoveLastChar(ref cmdText); cmd.CommandText = "update gisBg set " + cmdText + " where Id= @Id"; cmd.AddInt("Id", id); cmd.ExecuteNonQuery(); } if (!context.ExportMode) { updateAttr = 0; } }
public void Save(Context context) { if (!context.ExportMode && range.NotSaved) { range.Save(context); } if (context.ExportMode || updateAttr[Constants.updateAttrCreated]) { GmCommand cmd = context.TargetConn.CreateCommandById("insertIntoGisObjects"); cmd.AddInt("Id", id); cmd.AddInt("TypeId", range.Type.Id); cmd.AddInt("RangeId", range.Id); cmd.AddInt("Attr", attr); cmd.AddString("Name", name, MaxLength.Name); cmd.AddString("Caption", caption, MaxLength.Caption); cmd.AddString("Style", styleStr, MaxLength.Style); cmd.AddString("TextAttr", textAttr, MaxLength.TextAttr); SetCode(context, cmd.AddBinary("Code")); cmd.ExecuteNonQuery(); } else if (updateAttr.NonEmpty) { GmCommand cmd = context.Conn.CreateCommand(); string cmdText = ""; if (updateAttr[(int)ObjectField.TypeId]) { cmdText += "TypeId= @TypeId,"; cmd.AddInt("TypeId", range.Type.Id); } if (updateAttr[(int)ObjectField.RangeId]) { cmdText += "RangeId= @RangeId,"; cmd.AddInt("RangeId", range.Id); } if (updateAttr[(int)ObjectField.Attr]) { cmdText += "Attr= @Attr,"; cmd.AddInt("Attr", attr); } if (updateAttr[(int)ObjectField.Name]) { cmdText += "Name= @Name,"; cmd.AddString("Name", name, MaxLength.Name); } if (updateAttr[(int)ObjectField.Caption]) { cmdText += "Caption= @Caption,"; cmd.AddString("Caption", caption, MaxLength.Caption); } if (updateAttr[(int)ObjectField.Style]) { cmdText += "Style= @Style,"; cmd.AddString("Style", styleStr, MaxLength.Style); } if (updateAttr[(int)ObjectField.TextAttr]) { cmdText += "TextAttr= @TextAttr,"; cmd.AddString("TextAttr", textAttr, MaxLength.TextAttr); } if (updateAttr[(int)ObjectField.Code]) { cmdText += "Code= @Code,"; SetCode(context, cmd.AddBinary("Code")); } Geomethod.StringUtils.RemoveLastChar(ref cmdText); cmd.CommandText = "update gisObjects set " + cmdText + " where Id= @Id"; cmd.AddInt("Id", id); cmd.ExecuteScalar(); } if (!context.ExportMode) { updateAttr = 0; } }