public void GenerateCard()
{
ReportCardModel model = new ReportCardModel();
ReportCard report = new ReportCard();
report.CreateDocument("D:\\Testing\\", model, 2021);
}
public void TestOfficialXlsx()
{
ReportCardModel model = new ReportCardModel()
{
SettingParameters = new SettingParameters()
{
TabelNumber = "7751-00-548", Year = 2021, IdDepartment = 8,
Type = new Type()
{
IdType = 1, NameType = "Полный"
},
View = new View()
{
IdView = 0, NameView = "Первичный"
},
Mouth = new Mouth()
{
NumberMouthString = "09", NameMouth = "Сентябрь", NumberMouth = 9
}
}
};
SqlConnectionType sql = new SqlConnectionType();
SelectImns selectFrames = new SelectImns();
XmlReadOrWrite xml = new XmlReadOrWrite();
SelectSql select = new SelectSql();
select.SelectCardModelLeader(ref model);
var command = string.Format(selectFrames.UserReportCard, model.SettingParameters.LeaderD.NameDepartment, $"{model.SettingParameters.Year}-{model.SettingParameters.Mouth.NumberMouthString}-01");
var userReportCard = sql.XmlString("Data Source=i7751-app020;Initial Catalog=imns51;Integrated Security=True;MultipleActiveResultSets=True", command);
userReportCard = string.Concat("<SettingParameters>", userReportCard, "</SettingParameters>");
model.SettingParameters.UsersReportCard = ((SettingParameters)xml.ReadXmlText(userReportCard, typeof(SettingParameters))).UsersReportCard;
foreach (var usersReportCard in model.SettingParameters.UsersReportCard)
{
var commandVacation = string.Format(selectFrames.ItemVacationNew, usersReportCard.Tab_num, $"{model.SettingParameters.Year}", $"{model.SettingParameters.Year}");
var userVacation = sql.XmlString("Data Source=i7751-app020;Initial Catalog=imns51;Integrated Security=True;MultipleActiveResultSets=True", commandVacation);
userVacation = string.Concat("<UsersReportCard>", userVacation, "</UsersReportCard>");
usersReportCard.ItemVacation = ((UsersReportCard)xml.ReadXmlText(userVacation, typeof(UsersReportCard))).ItemVacation;
var commandDisability = string.Format(selectFrames.Disability, usersReportCard.Tab_num, $"{model.SettingParameters.Year}");
var userDisability = sql.XmlString("Data Source=i7751-app020;Initial Catalog=imns51;Integrated Security=True;MultipleActiveResultSets=True", commandDisability);
userDisability = string.Concat("<UsersReportCard>", userDisability, "</UsersReportCard>");
usersReportCard.Disability = ((UsersReportCard)xml.ReadXmlText(userDisability, typeof(UsersReportCard))).Disability;
var commandBusiness = string.Format(selectFrames.Business, usersReportCard.Tab_num, $"{model.SettingParameters.Year}");
var userBusiness = sql.XmlString("Data Source=i7751-app020;Initial Catalog=imns51;Integrated Security=True;MultipleActiveResultSets=True", commandBusiness);
userBusiness = string.Concat("<UsersReportCard>", userBusiness, "</UsersReportCard>");
usersReportCard.Business = ((UsersReportCard)xml.ReadXmlText(userBusiness, typeof(UsersReportCard))).Business;
}
ReportCard report = new ReportCard();
report.CreateDocument("D:\\Testing\\", model);
}
/// <summary>
/// Выбираем людей подписантов табельных номеров
/// </summary>
/// <param name="model">Модель табеля</param>
/// <returns></returns>
public void SelectCardModelLeader(ref ReportCardModel model)
{
try
{
ModelSelect selectModel = new ModelSelect {
LogicaSelect = SqlSelectModel(48)
};
if (model.SettingParameters.IdDepartment != 0)
{
model.SettingParameters.TabelNumber = Inventory.Database.SqlQuery <string>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 5),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], DBNull.Value),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], model.SettingParameters.Mouth.NumberMouth),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], model.SettingParameters.IdDepartment)).FirstOrDefault();
}
model.SettingParameters.LeaderN = Inventory.Database.SqlQuery <LeaderN>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 1),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], DBNull.Value),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], model.SettingParameters.Mouth.NumberMouth),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault();
model.SettingParameters.LeaderD = Inventory.Database.SqlQuery <LeaderD>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 2),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], model.SettingParameters.TabelNumber),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], model.SettingParameters.Mouth.NumberMouth),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3],
model.SettingParameters.IdDepartment != 0 ?
(IConvertible)model.SettingParameters.IdDepartment
: DBNull.Value)).FirstOrDefault();
model.SettingParameters.LeaderKadr = Inventory.Database.SqlQuery <LeaderKadr>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 3),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], DBNull.Value),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], model.SettingParameters.Mouth.NumberMouth),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).FirstOrDefault();
model.SettingParameters.Holidays = Inventory.Database.SqlQuery <Holidays>(selectModel.LogicaSelect.SelectUser,
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[0], 4),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[1], DBNull.Value),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[2], model.SettingParameters.Mouth.NumberMouth),
new SqlParameter(selectModel.LogicaSelect.SelectedParametr.Split(',')[3], DBNull.Value)).ToArray();
}
catch (Exception e)
{
Loggers.Log4NetLogger.Error(e);
}
}
