public void MemoGen() { MemoReport memo = new MemoReport(); // memo.CreateDocument("D:\\Testing\\",null,null); ModelMemoReport memoReport = new ModelMemoReport() { SelectParameterDocument = new SelectParameterDocument() { IdUser = 33, NameDocument = "RR", NumberDocument = 4, TabelNumber = "7751-00-099", TypeDocument = 1 } }; SelectSql select = new SelectSql(); SelectImns selectFrames = new SelectImns(); SqlConnectionType sql = new SqlConnectionType(); XmlReadOrWrite xml = new XmlReadOrWrite(); select.SelectMemoReport(ref memoReport); var commandOrders = string.Format(selectFrames.LastOrder, memoReport.UserDepartment.SmallTabelNumber); var userOrder = sql.XmlString("Data Source=i7751-app020;Initial Catalog=imns51;Integrated Security=True;MultipleActiveResultSets=True", commandOrders); if (userOrder != null) { userOrder = string.Concat("<Orders>", userOrder, "</Orders>"); memoReport.UserDepartment.Orders = ((Orders)xml.ReadXmlText(userOrder, typeof(Orders))); } memo.CreateDocument("D:\\Testing\\", memoReport); }
/// <summary> /// Генерация для служебных записок модель /// </summary> /// <param name="memoReport">Модель для служебных записок</param> public void SelectMemoReport(ref ModelMemoReport memoReport) { try { ModelSelect selectModel = new ModelSelect { LogicaSelect = SqlSelectModel(49) }; memoReport.UserDepartment = Inventory.Database.SqlQuery <UserDepartment>(selectModel.LogicaSelect.SelectUser, new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 1), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], memoReport.SelectParameterDocument.IdUser), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], DBNull.Value), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault(); memoReport.Executor = Inventory.Database.SqlQuery <Executor>(selectModel.LogicaSelect.SelectUser, new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 2), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], memoReport.SelectParameterDocument.IdUser), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], memoReport.SelectParameterDocument.TabelNumber), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault(); memoReport.BossDepartment = Inventory.Database.SqlQuery <BossDepartment>(selectModel.LogicaSelect.SelectUser, new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 3), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], memoReport.SelectParameterDocument.IdUser), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], memoReport.SelectParameterDocument.TabelNumber), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault(); memoReport.BossAgreed = Inventory.Database.SqlQuery <BossAgreed>(selectModel.LogicaSelect.SelectUser, new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 4), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], memoReport.SelectParameterDocument.IdUser), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], memoReport.SelectParameterDocument.TabelNumber), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], memoReport.SelectParameterDocument.TypeDocument)).FirstOrDefault(); memoReport.LeaderOrganization = Inventory.Database.SqlQuery <LeaderOrganization>(selectModel.LogicaSelect.SelectUser, new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 5), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], memoReport.SelectParameterDocument.IdUser), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], DBNull.Value), new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault(); } catch (Exception e) { Loggers.Log4NetLogger.Error(e); } }