private void button1_Click(object sender, EventArgs e)
{
string amin1 = "({Print_Karkard;1.idgroup}=" + id_group + ") AND ({Print_Karkard;1.idyear}=" + id_year + ") AND ({Print_Karkard;1.idmoon}=" + id_moon + ") AND ({Print_Karkard;1.type1}=" + personel_type1 + ")";
Pey4_CrystalReports.AllPrint f = new Pey4_CrystalReports.AllPrint();
f.selkar = "Report_Karkard";
f.recore_sel = amin1;
if (personel_type1 == "1")
{
f.sarbarg = "T";
}
else
{
f.sarbarg = "G";
}
f.Show();
}
private void button1_Click(object sender, EventArgs e)
{
if (checkBox1.Checked == true)
{
if (textBox1.Text == "")
{
MessageBox.Show("لطفا از کد پرسنلی را تکمیل نمایید", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
textBox1.Focus();
return;
}
if (textBox2.Text == "")
{
MessageBox.Show("لطفا تا کد پرسنلی را تکمیل نمایید", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
textBox2.Focus();
return;
}
}
if (checkBox3.Checked == true)
{
if (maskedTextBox1.ToString().IndexOf("_").ToString() != "-1")
{
MessageBox.Show("لطفا از تاریخ را تکمیل نمایید", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
maskedTextBox1.Focus();
return;
}
if (maskedTextBox2.ToString().IndexOf("_").ToString() != "-1")
{
MessageBox.Show("لطفا تا تاریخ را تکمیل نمایید", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
maskedTextBox2.Focus();
return;
}
}
if (checkBox2.Checked == true)
{
if ((comboBox1.SelectedIndex == -1))
{
MessageBox.Show("لطفا مرکز هزینه را انتخاب نمایید", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
comboBox1.Focus();
return;
}
}
button1.Enabled = false;
//2
//دوره ای
if (selectprint == "Report_Groupby_List")
{
string amin1 = "";
if (selectprint_noe == "T")
{
amin1 = "({Print_Process;1.idgroup}=" + id_group + ") AND ({Print_Process;1.type1}=1) AND ({Print_Process;1.list2}=true)";
}
else if (selectprint_noe == "G")
{
amin1 = "({Print_Process;1.idgroup}=" + id_group + ") AND ({Print_Process;1.type1}=2) AND ({Print_Process;1.list1}=true)";
}
if (checkBox1.Checked == true)
{
amin1 += " AND ({Print_Process;1.code} >= '" + textBox1.Text + "') AND ({Print_Process;1.code} <= '" + textBox2.Text + "')";
}
if (checkBox2.Checked == true)
{
amin1 += " AND ({Print_Process;1.tmpid(1)}=" + comboBox1.SelectedValue + ")";
}
if (checkBox3.Checked == true)
{
amin1 += " AND ({Print_Process;1.idyear} >= " + maskedTextBox1.Text.ToString().Substring(0, 4) + ") AND ({Print_Process;1.idyear} <= " + maskedTextBox2.Text.ToString().Substring(0, 4) + ")";
amin1 += " AND ({Print_Process;1.idmoon} >= " + maskedTextBox1.Text.ToString().Substring(5, 2) + ") AND ({Print_Process;1.idmoon} <= " + maskedTextBox2.Text.ToString().Substring(5, 2) + ")";
}
Pey4_CrystalReports.AllPrint f = new Pey4_CrystalReports.AllPrint();
f.selkar = "Report_Groupby_List";
f.recore_sel = amin1;
f.sarbarg = selectprint_noe;
f.Show();
}
//3
//فیش جدید
if (selectprint == "Report_Fish_2_Hoghogh")
{
string amin1 = "";
if (selectprint_noe == "T")
{
amin1 = "({Print_salary;1.idgroup}=" + id_group + ")AND ({Print_salary;1.idyear}=" + id_year + ") AND ({Print_salary;1.idmoon}=" + id_moon + ") AND ({Print_salary;1.type1}=1) AND ({Print_salary;1.list2}=true)";
}
else if (selectprint_noe == "G")
{
amin1 = "({Print_salary;1.idgroup}=" + id_group + ")AND ({Print_salary;1.idyear}=" + id_year + ") AND ({Print_salary;1.idmoon}=" + id_moon + ") AND ({Print_salary;1.type1}=2) AND ({Print_salary;1.list1}=true)";
}
if (checkBox1.Checked == true)
{
amin1 += " AND ({Print_salary;1.code} >= '" + textBox1.Text + "') AND ({Print_salary;1.code} <= '" + textBox2.Text + "')";
}
if (checkBox2.Checked == true)
{
amin1 += " AND ({Print_salary;1.tmpid(1)}=" + comboBox1.SelectedValue + ")";
}
if (checkBox3.Checked == true)
{
amin1 += " AND ({Print_salary;1.idyear} >= " + maskedTextBox1.Text.ToString().Substring(0, 4) + ") AND ({Print_salary;1.idyear} <= " + maskedTextBox2.Text.ToString().Substring(0, 4) + ")";
amin1 += " AND ({Print_salary;1.idmoon} >= " + maskedTextBox1.Text.ToString().Substring(5, 2) + ") AND ({Print_salary;1.idmoon} <= " + maskedTextBox2.Text.ToString().Substring(5, 2) + ")";
}
Pey4_CrystalReports.AllPrint f = new Pey4_CrystalReports.AllPrint();
f.selkar = "Report_Fish_2_Hoghogh";
f.recore_sel = amin1;
f.sarbarg = selectprint_noe;
f.Show();
}
//4
//قرارداد کار
if (selectprint == "Report_Garardad")
{
string amin1 = "({Print_Process;1.idgroup}=" + id_group + ")AND ({Print_Process;1.idyear}=" + id_year + ") AND ({Print_Process;1.idmoon}=" + id_moon + ") AND ({Print_list;1.type1}=2) AND ({Print_list;1.list1}=true)";
if (checkBox1.Checked == true)
{
amin1 += " AND ({Print_Process;1.code} >= '" + textBox1.Text + "') AND ({Print_Process;1.code} <= '" + textBox2.Text + "')";
}
if (checkBox2.Checked == true)
{
amin1 += " AND ({Print_Process;1.tmpid}=" + comboBox1.SelectedValue + ")";
}
Pey4_CrystalReports.AllPrint f = new Pey4_CrystalReports.AllPrint();
f.selkar = "Report_Garardad";
f.recore_sel = amin1;
f.Show();
}
//5
//لیست حقوق
if (selectprint == "Report_List_1_Hoghogh")
{
string amin1 = "";
if (selectprint_noe == "T")
{
amin1 = "({Print_list;1.idgroup}=" + id_group + ")AND ({Print_list;1.idyear}=" + id_year + ") AND ({Print_list;1.idmoon}=" + id_moon + ") AND ({Print_list;1.type1}=1) AND ({Print_list;1.list2}=true)";
}
else if (selectprint_noe == "G")
{
amin1 = "({Print_list;1.idgroup}=" + id_group + ")AND ({Print_list;1.idyear}=" + id_year + ") AND ({Print_list;1.idmoon}=" + id_moon + ") AND ({Print_list;1.type1}=2) AND ({Print_list;1.list1}=true)";
}
if (checkBox1.Checked == true)
{
amin1 += " AND ({Print_list;1.code} >= '" + textBox1.Text + "') AND ({Print_list;1.code} <= '" + textBox2.Text + "')";
}
if (checkBox2.Checked == true)
{
amin1 += " AND ({Print_list;1.tmpid(1)}=" + comboBox1.SelectedValue + ")";
}
Pey4_CrystalReports.Form2 f = new Pey4_CrystalReports.Form2();
f.report_List_Hoghogh1.RecordSelectionFormula = amin1;
f.sarbarg = selectprint_noe;
f.Show();
}
//6
//دوره ای
if (selectprint == "Report_Groupby_Moon")
{
string amin1 = "";
if (selectprint_noe == "T")
{
amin1 = "({Print_Process;1.idgroup}=" + id_group + ") AND ({Print_Process;1.type1}=1) AND ({Print_Process;1.list2}=true)";
}
else if (selectprint_noe == "G")
{
amin1 = "({Print_Process;1.idgroup}=" + id_group + ") AND ({Print_Process;1.type1}=2) AND ({Print_Process;1.list1}=true)";
}
if (checkBox1.Checked == true)
{
amin1 += " AND ({Print_Process;1.code} >= '" + textBox1.Text + "') AND ({Print_Process;1.code} <= '" + textBox2.Text + "')";
}
if (checkBox2.Checked == true)
{
amin1 += " AND ({Print_Process;1.tmpid(1)}=" + comboBox1.SelectedValue + ")";
}
if (checkBox3.Checked == true)
{
amin1 += " AND ({Print_Process;1.idyear} >= " + maskedTextBox1.Text.ToString().Substring(0, 4) + ") AND ({Print_Process;1.idyear} <= " + maskedTextBox2.Text.ToString().Substring(0, 4) + ")";
amin1 += " AND ({Print_Process;1.idmoon} >= " + maskedTextBox1.Text.ToString().Substring(5, 2) + ") AND ({Print_Process;1.idmoon} <= " + maskedTextBox2.Text.ToString().Substring(5, 2) + ")";
}
Pey4_CrystalReports.AllPrint f = new Pey4_CrystalReports.AllPrint();
f.selkar = "Report_Groupby_Moon";
f.recore_sel = amin1;
f.sarbarg = selectprint_noe;
f.Show();
}
//7
//نمودار
if (selectprint == "Report_Groupby_Moon_Chart")
{
string amin1 = "";
if (selectprint_noe == "T")
{
amin1 = "({Print_Process;1.idgroup}=" + id_group + ") AND ({Print_Process;1.type1}=1) AND ({Print_Process;1.list2}=true)";
}
else if (selectprint_noe == "G")
{
amin1 = "({Print_Process;1.idgroup}=" + id_group + ") AND ({Print_Process;1.type1}=2) AND ({Print_Process;1.list1}=true)";
}
if (checkBox1.Checked == true)
{
amin1 += " AND ({Print_Process;1.code} >= '" + textBox1.Text + "') AND ({Print_Process;1.code} <= '" + textBox2.Text + "')";
}
if (checkBox2.Checked == true)
{
amin1 += " AND ({Print_Process;1.tmpid(1)}=" + comboBox1.SelectedValue + ")";
}
if (checkBox3.Checked == true)
{
amin1 += " AND ({Print_Process;1.idyear} >= " + maskedTextBox1.Text.ToString().Substring(0, 4) + ") AND ({Print_Process;1.idyear} <= " + maskedTextBox2.Text.ToString().Substring(0, 4) + ")";
amin1 += " AND ({Print_Process;1.idmoon} >= " + maskedTextBox1.Text.ToString().Substring(5, 2) + ") AND ({Print_Process;1.idmoon} <= " + maskedTextBox2.Text.ToString().Substring(5, 2) + ")";
}
Pey4_CrystalReports.AllPrint f = new Pey4_CrystalReports.AllPrint();
f.selkar = "Report_Groupby_Moon_Chart";
f.recore_sel = amin1;
f.sarbarg = selectprint_noe;
f.Show();
}
button1.Enabled = true;
}
