//Процедура выгрузки public void UploadData(String strSQL, Boolean moveToArh) { String stringSQL = null; String stringSQL1 = null; String stringSQL2 = null; //spec stringSQL = "SELECT * FROM spec WHERE id IN (" + strSQL + ")"; DataTable dt = sqlConSrc.GetDataTable("spec", stringSQL); stringSQL1 = "SELECT DISTINCT edu_id FROM spec WHERE id IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_edu WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_edu", stringSQL2); stringSQL1 = "SELECT DISTINCT nation_id FROM spec WHERE id IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_nation WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_nation", stringSQL2); stringSQL1 = "SELECT DISTINCT mstatus_id FROM spec WHERE id IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_mstatus WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_mstatus", stringSQL2); stringSQL1 = "SELECT DISTINCT mstatus_id FROM spec WHERE id IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_mstatus WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_mstatus", stringSQL2); stringSQL1 = "SELECT DISTINCT profession_id FROM spec WHERE id IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_profession WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_profession", stringSQL2); //party_number //stringSQL1 = "SELECT DISTINCT party_id FROM spec WHERE id IN (" + strSQL + ")"; //stringSQL2 = "SELECT * FROM spr_party_number WHERE id IN (" + stringSQL1 + ")"; stringSQL2 = "SELECT * FROM spr_party_number"; sqlConSrc.GetDataTable("spr_party_number", stringSQL2); //relations stringSQL = "SELECT * FROM relations WHERE id_spec IN (" + strSQL + ")"; sqlConSrc.GetDataTable("relations", stringSQL); stringSQL1 = "SELECT DISTINCT degree_id FROM relations WHERE id_spec IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_degree WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_degree", stringSQL2); //bonus stringSQL = "SELECT * FROM bonus WHERE id_spec IN (" + strSQL + ")"; sqlConSrc.GetDataTable("bonus", stringSQL); stringSQL1 = "SELECT DISTINCT bonus_type_id FROM bonus WHERE id_spec IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_bonus_type WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_bonus_type", stringSQL2); stringSQL1 = "SELECT DISTINCT performer_id FROM bonus WHERE id_spec IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_performers WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_performers", stringSQL2); //penalty stringSQL = "SELECT * FROM penalty WHERE id_spec IN (" + strSQL + ")"; sqlConSrc.GetDataTable("penalty", stringSQL); stringSQL1 = "SELECT DISTINCT penalty_type_id FROM penalty WHERE id_spec IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_penalty_type WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_penalty_type", stringSQL2); //party stringSQL = "SELECT * FROM party WHERE id_spec IN (" + strSQL + ")"; sqlConSrc.GetDataTable("party", stringSQL); /* * stringSQL1 = "SELECT DISTINCT party_number_id FROM party WHERE id IN (" + strSQL + ")"; * stringSQL2 = "SELECT * FROM spr_party_number WHERE id IN (" + stringSQL1 + ")"; * sqlConSrc.GetDataTable("spr_party_number2", stringSQL2); */ //spec_psycho stringSQL = "SELECT * FROM spec_psycho WHERE id_spec IN (" + strSQL + ")"; sqlConSrc.GetDataTable("spec_psycho", stringSQL); //psycho_char stringSQL = "SELECT * FROM psycho_char WHERE id_spec IN (" + strSQL + ")"; sqlConSrc.GetDataTable("psycho_char", stringSQL); //prev_conv stringSQL = "SELECT * FROM prev_conv WHERE id_spec IN (" + strSQL + ")"; sqlConSrc.GetDataTable("prev_conv", stringSQL); stringSQL1 = "SELECT DISTINCT release_reason_id FROM prev_conv WHERE id_spec IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_release_reason WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_release_reason", stringSQL2); //profilact_ychet stringSQL = "SELECT * FROM profilact_ychet WHERE id_spec IN (" + strSQL + ")"; sqlConSrc.GetDataTable("profilact_ychet", stringSQL); stringSQL1 = "SELECT DISTINCT id_profilact_ychet FROM profilact_ychet WHERE id_spec IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_profilact_ychet WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_profilact_ychet", stringSQL2); //ivr stringSQL = "SELECT * FROM ivr WHERE id_spec IN (" + strSQL + ")"; sqlConSrc.GetDataTable("ivr", stringSQL); stringSQL1 = "SELECT DISTINCT employee_id FROM ivr WHERE id_spec IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM employee WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("employee", stringSQL2); stringSQL1 = "SELECT DISTINCT work_type FROM ivr WHERE id_spec IN (" + strSQL + ")"; stringSQL2 = "SELECT * FROM spr_work_type WHERE id IN (" + stringSQL1 + ")"; sqlConSrc.GetDataTable("spr_work_type", stringSQL2); //resolution stringSQL = "SELECT * FROM resolution WHERE id_spec IN (" + strSQL + ")"; sqlConSrc.GetDataTable("resolution", stringSQL); //system stringSQL = "SELECT * FROM system"; sqlConSrc.GetDataTable("system", stringSQL); //results stringSQL = "SELECT * FROM results WHERE id_spec IN (" + strSQL + ")"; sqlConSrc.GetDataTable("results", stringSQL); DirectoryInfo dir = new DirectoryInfo(tempDir); dir.Create(); CopyFoto(GetDBDirPath(), tempDir, dt); DataSet ds = sqlConSrc.GetDataSet(); ds.WriteXml(tempDir + @"\" + dataFile, XmlWriteMode.WriteSchema); Boolean svResult = SaveFile(tempDir); if (!svResult) { return; } if (moveToArh) { sqlConSrc.DoQuery("UPDATE spec SET is_present = false WHERE id IN (" + strSQL + ")"); } }