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();
}
public void SyncSql()
{
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.CreateSyncQuery(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();
}