private void TVib_Click(object sender, EventArgs e)
{
my.Szap = " and Period >= '" + d1.SelectedValue.ToString() + "' and Period <= '" + d2.SelectedValue.ToString() + "' ";
switch (Nbut)
{
case 1:
my.Szap = " '" + d1.SelectedValue.ToString() + "','" + d2.SelectedValue.ToString() + "'";
ModOffice.ReportExGrafikActs(NMGrafik, 2, my.Szap, IdEntpr, IdDep); break;
case 2:
my.Szap = " '" + d1.SelectedValue.ToString() + "','" + d2.SelectedValue.ToString() + "'";
ModOffice.ReportExOstSmSt(NMGrafik, 2, my.Szap, d1.SelectedValue.ToString(), d2.SelectedValue.ToString(), IdEntpr, IdDep);
break;
case 43:
my.Szap = " and Forma2.Period >= '" + d1.SelectedValue.ToString() + "' and Forma2.Period <= '" + d2.SelectedValue.ToString() + "' ";
if (!my.isFormInMdi("frmSprZapros", my.Nbut, this))
{
my.showSprZapros(my.Nbut, false, true);
}
break;
default:
if (!my.isFormInMdi("frmSprZapros", my.Nbut, this))
{
my.showSprZapros(my.Nbut, false, true);
}
break;
}
}
private void TVib_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
//ModOffice.GrafikTPNew("дд", 0, d2.Value.ToShortDateString(), dend.Value.ToShortDateString(), idgrafik.ToString(), StrDate.SelectedValue.ToString());
ModOffice.GrafikTPNew("exec Grafik.dbo.sProjACTP " + idgrafik + ",'','" + d2.Value.ToShortDateString() + "','" + dend.Value.ToShortDateString() + "','" + NMEnt.SelectedValue + "',0,'" + StrDate.SelectedValue + "'", Convert.ToDouble(ind.Text.ToString()), d2.Value.ToShortDateString(), dend.Value.ToShortDateString(), idgrafik.ToString(), StrDate.SelectedValue.ToString(), IdEntpr, IdDep);
Cursor = Cursors.Default;
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
NMPlan.Focus();
DataView dv = new DataView();
dv.Table = ds.Tables[0];
ModOffice.TP(idplan, this, dv);
}
private void TVib_Click(object sender, EventArgs e)
{
if (Nbut == 1)
{
ModOffice.ReportExGrafik(idgrafik.ToString(), 1, StrDate.SelectedValue.ToString(), NMGrafik, IdEntpr, IdDep);
}
if (Nbut == 2)
{
ModOffice.ReportExGrafikObor(idgrafik.ToString(), 1, StrDate.SelectedValue.ToString(), NMGrafik, IdEntpr, IdDep);
}
}
private void TVib_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
string szap = " and " + nm1.SelectedValue.ToString() + " <= ''" + d2.Value.ToString() + "'' and " + nm2.SelectedValue.ToString() + " >= ''" + d1.Value.ToString() + "''";
string szap2 = "";
if (checkBox1.Checked)
{
szap2 = " and user_field_6680 = ''" + nm3.SelectedValue.ToString() + "''";
}
ModOffice.GrafikTP("exec Grafik.dbo.sTemPlan '" + NMGrafik + "','" + szap + "','TP'," + (chAllWrk.Checked ? 1 : 0).ToString() + "," + idcomplex.ToString() + ",'" + szap2 + "'", d1.Value, d2.Value);
Cursor = Cursors.Default;
}
private void toolStripButton1_Click_1(object sender, EventArgs e)
{
NMPlan.Focus();
ModOffice.TPRep(idplan, this);
}
private void button2_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
ModOffice.GrafikPdf("exec Grafik.dbo.sGrafikPr '" + NMGrafik.SelectedValue + "','proj','',null," + idcomplex.ToString());
Cursor = Cursors.Default;
}
private void button1_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
ModOffice.GrafikRep("exec Grafik.dbo.sGrafikPr '" + NMGrafik.SelectedValue + "','Projuser_field_6678','',null," + idcomplex.ToString(), idcomplex);
Cursor = Cursors.Default;
}
private void TVib_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
ModOffice.GrafikTPRep("exec Grafik.dbo.sProjACTPRep " + idgrafik + ",'" + d1.Value.ToShortDateString() + "','" + d2.Value.ToShortDateString() + "'," + IdEntpr.ToString() + "," + IdDep.ToString());
Cursor = Cursors.Default;
}