public void UpdateSql() { string ModuleSyncTableSchema = ConfigHelper.GetValue("ModuleSyncTableSchema", "openData"); string ModuleIDPath = CurrentModuleRule.Sys_Module.First(s => s.ModuleID == ModuleID).ModuleIDPath; MyDataSyncHelper objDataSyncHelper = new MyDataSyncHelper("SevenConnectionString"); string updateQuery = objDataSyncHelper.CreateSyncUpdateQuery(ModuleSyncTableSchema, "Sys_Module", "ModuleIDPath like '" + ModuleIDPath + "%'", "", true); string SqlFileName = "OpenData" + DateTime.Now.ToString("yyyy-MM-dd-hh") + ".sql"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.AppendHeader("Content-Disposition", "attachment;filename=" + SqlFileName); Response.Write(updateQuery); Response.End(); }
public void SyncSql() { MyDataSyncHelper objDataSyncHelper = new MyDataSyncHelper("SevenConnectionString"); string ModuleSyncTableSchema = ConfigHelper.GetValue("ModuleSyncTableSchema", "openData"); System.Text.StringBuilder objStringBuilder = new System.Text.StringBuilder(); objStringBuilder.AppendLine(DataSyncHelper.HeaderQuery); objStringBuilder.AppendLine(DataSyncHelper.BeginTransaction); objStringBuilder.AppendLine(objDataSyncHelper.CreateSyncQuery(ModuleSyncTableSchema, "Sys_ResourceType", "", "", false, false)); objStringBuilder.AppendLine(objDataSyncHelper.CreateSyncQuery(ModuleSyncTableSchema, "Sys_ResourceRestrict", "", "", false, false)); objStringBuilder.AppendLine(objDataSyncHelper.CreateSyncQuery(ModuleSyncTableSchema, "Sys_ResourceRestrictPic", "", "", false, false)); objStringBuilder.AppendLine(DataSyncHelper.EndTransaction); string SqlFileName = "Resource" + DateTime.Now.ToString("yyyy-MM-dd-hh") + ".sql"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.AppendHeader("Content-Disposition", "attachment;filename=" + SqlFileName); Response.Write(objStringBuilder.ToString()); Response.End(); }