private void Export_But_Click(object sender, EventArgs e)
{
if (Place_ChBox.Checked)
{
if (TempDirectory.AllowWork && TempDirectory.ShablonsEnabled)
{
string postfix = DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss");
string filename = "Export-" + postfix + ".xlsx";
string path = TempDirectory.Path + "\\" + filename;
File.Copy(TempDirectory.Path + "\\xls.xlsx", path);
if (File.Exists(path))
{
int row = 4;
int j = 1;
XLS_Class cl = new XLS_Class(path);
cl.set_val(1, 2, DateTime.Now.ToString("D"));
cl.set_val(2, 2, Place2_CmBox.SelectedItem.ToString());
for (int i = 0; i < dgv.RowCount; i++)
{
cl.set_val(row, 0, j.ToString());
cl.set_val(row, 1, dgv.Rows[i].Cells[4].Value.ToString());
cl.set_val(row, 2, dgv.Rows[i].Cells[3].Value.ToString());
cl.set_val(row, 3, dgv.Rows[i].Cells[1].Value.ToString());
cl.set_val(row, 4, dgv.Rows[i].Cells[2].Value.ToString());
cl.set_val(row, 5, dgv.Rows[i].Cells[17].Value.ToString());
cl.set_val(row, 6, dgv.Rows[i].Cells[8].Value.ToString());
row++;
j++;
}
cl.save_as(path);
}
}
}
else
{
MessageBox.Show(
"Для создания инвентаризационного документа по аппаратной включите фильтр по аппаратной (Place2)");
}
}
private void Export_But_Click(object sender, EventArgs e)
{
string bp = "D:\\DocumentAssistant";
if (!Directory.Exists(bp))
{
Directory.CreateDirectory(bp);
}
if (File.Exists(bp + "\\xls.xlsx"))
{
string postfix = DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss");
string filename = "Export-" + postfix + ".xlsx";
string path = bp + "\\" + filename;
File.Copy(bp + "\\xls.xlsx", path);
if (File.Exists(path))
{
int row = 4;
int j = 1;
XLS_Class cl = new XLS_Class(path);
cl.set_val(1, 2, DateTime.Now.ToString("D"));
cl.set_val(2, 2, Place2_CmBox.SelectedItem.ToString());
for (int i = 0; i < dgv.RowCount; i++)
{
cl.set_val(row, 0, j.ToString());
cl.set_val(row, 1, dgv.Rows[i].Cells[4].Value.ToString());
cl.set_val(row, 2, dgv.Rows[i].Cells[3].Value.ToString());
cl.set_val(row, 3, dgv.Rows[i].Cells[1].Value.ToString());
cl.set_val(row, 4, dgv.Rows[i].Cells[2].Value.ToString());
cl.set_val(row, 5, dgv.Rows[i].Cells[17].Value.ToString());
cl.set_val(row, 6, dgv.Rows[i].Cells[8].Value.ToString());
//cl.set_val(j, 7, dgv.Rows[i].Cells[4].Value.ToString());
row++;
j++;
}
cl.save_as(path);
}
}
}
