public String Xml(XmlReader reader, ContentZn contentparam)
{
valid = true;
XmlReaderSettings settings = new XmlReaderSettings();
settings.ValidationType = ValidationType.Schema;
settings.Schemas = contentparam.XmlCol;
settings.ConformanceLevel = ConformanceLevel.Auto;
settings.ValidationFlags |= XmlSchemaValidationFlags.ProcessInlineSchema;
settings.ValidationFlags |= XmlSchemaValidationFlags.ReportValidationWarnings;
settings.ValidationEventHandler += ValidationCallBack; //Задание на проверку данных
XmlReader readererror = XmlReader.Create(reader, settings);
readererror.Read();
return(valid == true ? readererror.LocalName : null);
}
public static void PathSeat(object sender, ComboBox item, RoutedEventArgs e)
{
var dir = new DirectoryInfo(Config.Config.TemplateDirectory);
var path = new ContentZn {
PathTemplate = new ObservableCollection <ContentZn>()
};
var dirs = dir.GetFiles();
foreach (var param in dirs)
{
path.PathTemplate.Add(new ContentZn
{
NameTemplate = param.Name,
Icontemplate = ExecuteIcon.Extrfile(param.FullName),
Sqlt = SQLTemplate.SqlSelect.SqlSelect.SqlCom(param.Name),
Fullname = param.FullName,
Xmlcol = SQLTemplate.SqlSelect.XmlSelect.SqlCom(param.Name)
});
}
item.ItemsSource = path.PathTemplate;
}
public static Word.Document SelectDocument(Word.Application oWord, String inn, String god, ContentZn contentparam)
{
ValidationXml validate = new ValidationXml();
Word.Document oDoc = oWord.Documents.Add(contentparam.FullName);
XmlDocument xml = new XmlDocument();
var i = 0;
foreach (var sql in contentparam.SqlT)
{
try
{
using (var con = new SqlConnection(Config.Config.Connection))
{
using (var cmd = new SqlCommand(sql.ToString(), con))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@INN", inn);
cmd.Parameters.AddWithValue("@GOD", god);
con.Open();
using (XmlReader dr = cmd.ExecuteXmlReader())
{
string namexsd = validate.Xml(dr, contentparam);
if (namexsd == "")
{
con.Close();
return(null);
}
oDoc = CreateReportWord.CreateWords.ReportWordsGenerate(oDoc, namexsd, dr);
}
con.Close();
i++;
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
return(oDoc);
}
