private void button1_Click(object sender, RoutedEventArgs e)
{
string search_amin = "";
if ((textBox1.Text != "") && (textBox2.Text != ""))
{
search_amin = search_amin + " ({Crystal_Rusty_Customers;1.S1_idshobe} >= '" + textBox1.Text + "') AND ({Crystal_Rusty_Customers;1.S1_idshobe} <= '" + textBox2.Text + "') AND ";
}
if ((persianDatePicker1.Text != "") && (persianDatePicker2.Text != ""))
{
search_amin = search_amin + " ({Crystal_Rusty_Customers;1.datesabt} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_Customers;1.datesabt} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND ";
}
if (search_amin != "")
{
search_amin = search_amin.Substring(1, search_amin.Length - 5);
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "گزارش ایجاد مشتری";
f1.selkar = "Crystal_Rusty_Customers";
f1.rec_sel_for = search_amin;
f1.Show();
}
}
private void button3_Click(object sender, RoutedEventArgs e)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "صدور حواله تحویل خودرو قرارداد شماره : " + id_Contract;
f1.selkar = "Crystal_Leasing_02_Havalehe_Tahvil";
f1.id_Contract = id_Contract;
f1.Show();
}
private void button3_Click(object sender, RoutedEventArgs e)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "قرارداد حق العمل کاری فرسوده شماره : " + id_Contract;
f1.selkar = "Crystal_Rusty_01_hagholamal_kari";
f1.id_Contract = id_Contract;
f1.Show();
}
private void button5_Click(object sender, RoutedEventArgs e)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "برچسب قرارداد شماره : " + id_Contract;
f1.selkar = "Crystal_Rusty_01_Lablel";
f1.id_Contract = id_Contract;
f1.Show();
}
private void button3_Click(object sender, RoutedEventArgs e)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "سند صدور چک قرارداد شماره : " + id_Contract;
f1.selkar = "Crystal_Rusty_11_resid";
f1.id_Contract = id_Contract;
f1.Show();
}
private void button3_Click(object sender, RoutedEventArgs e)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "قرارداد خرید نقد و اقساط اعتباری شماره : " + id_Contract;
f1.selkar = "Crystal_Cash_and_installment_sales_01_Haghol_Vekaleh";
f1.id_Contract = id_Contract;
f1.Show();
}
private void MenuItem_Click_3(object sender, RoutedEventArgs e)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "چاپ رسید هزینه";
f1.selkar = "Crystal_Financial_Cost";
f1.id_Contract = sel_tmpid;
f1.Show();
}
private void button18_Click(object sender, RoutedEventArgs e)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "عملکرد کاربران در قرارداد : " + id_Contract;
f1.selkar = "Crystal_Rusty_User";
f1.id_Contract = id_Contract;
f1.Show();
}
private void button19_Click(object sender, RoutedEventArgs e)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "چاپ روند کاری فرسوده شماره : " + id_Contract;
f1.selkar = "Crystal_Rusty_All_Ravandkar";
f1.id_Contract = id_Contract;
f1.Show();
}
private void button3_Click(object sender, RoutedEventArgs e)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "قرارداد حق العمل کاری اجاره به شرط تملیک شماره : " + id_Contract;
f1.selkar = "Crystal_Leasing_01_Haghol_Vekaleh";
f1.id_Contract = id_Contract;
f1.Show();
}
private void button4_Click(object sender, RoutedEventArgs e)
{
if (selkar == "5")
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "قرارداد خرید و فروش نقدی شماره : " + id_Contract;
f1.selkar = "Crystal_Sell_Buy_01_Gholnameh";
f1.id_Contract = id_Contract;
f1.Show();
}
}
private void button4_Click(object sender, RoutedEventArgs e)
{
if (radioButton1.IsChecked == true)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "قرارداد اقرارنامه فرسوده شماره : " + id_Contract;
f1.selkar = "Crystal_Rusty_01_Eghrar1";
f1.id_Contract = id_Contract;
f1.Show();
}
if (radioButton2.IsChecked == true)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "قرارداد اقرارنامه فرسوده شماره : " + id_Contract;
f1.selkar = "Crystal_Rusty_01_Eghrar2";
f1.id_Contract = id_Contract;
f1.Show();
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
string search_amin = "";
if ((persianDatePicker1.Text != "") && (persianDatePicker2.Text != ""))
{
search_amin = search_amin + " ({Crystal_Rusty_02_vekalatnameh;1.s3_2_1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_02_vekalatnameh;1.s3_2_1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND ";
}
if (search_amin != "")
{
search_amin = search_amin.Substring(1, search_amin.Length - 5);
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = this.Title;
f1.selkar = "Rusty_PPrint_04_hesab";
f1.rec_sel_for = search_amin;
f1.date1 = u_set.control_date_end(persianDatePicker1.Text);
f1.date2 = u_set.control_date_end(persianDatePicker2.Text);
f1.Show();
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
string search_amin = "";
if (comboBox3.SelectedIndex != -1)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S1_idshobe} = '" + comboBox3.SelectedValue + "') AND ";
}
if (comboBox1.SelectedIndex != -1)
{
if (persianDatePicker1.Text == "")
{
MessageBox.Show("لطفا تاریخ از را تکمیل نمایید", "", MessageBoxButton.OK, MessageBoxImage.Error);
persianDatePicker1.Focus();
return;
}
if (persianDatePicker2.Text == "")
{
MessageBox.Show("لطفا تاریخ تا را تکمیل نمایید", "", MessageBoxButton.OK, MessageBoxImage.Error);
persianDatePicker2.Focus();
return;
}
if (comboBox5.SelectedIndex == 0)
{
if (comboBox1.SelectedIndex == 0)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.udate(1)} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.udate(1)} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S3_datet})) AND ";
}
if (comboBox1.SelectedIndex == 1)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S3_datet} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S3_datet} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.s3_2_3})) AND ";
}
//if (comboBox1.SelectedIndex == 2)
// search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.s3_2_1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.s3_2_1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S4_2_1})) AND ";
//if (comboBox1.SelectedIndex == 3)
// search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.s3_2_1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.s3_2_1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S4_2_1})) AND ";
if (comboBox1.SelectedIndex == 4)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S4_2_1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S4_2_1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S6_datefarakhan})) AND ";
}
if (comboBox1.SelectedIndex == 5)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S6_datefarakhan} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S6_datefarakhan} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S4_3_1})) AND ";
}
if (comboBox1.SelectedIndex == 6)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S4_3_1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S4_3_1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S4_4_1})) AND ";
}
if (comboBox1.SelectedIndex == 7)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S4_4_1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S4_4_1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S9_date2})) AND ";
}
if (comboBox1.SelectedIndex == 8)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S9_date2} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S9_date2} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S5_datemoshtari})) AND ";
}
if (comboBox1.SelectedIndex == 9)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S5_datemoshtari} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S5_datemoshtari} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S5_ersalkhodro})) AND ";
}
if (comboBox1.SelectedIndex == 10)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S5_ersalkhodro} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S5_ersalkhodro} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S5_Dateend})) AND ";
}
if (comboBox1.SelectedIndex == 11)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S5_Dateend} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S5_Dateend} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND ";
}
}
else
{
if (comboBox1.SelectedIndex == 0)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.udate(1)} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.udate(1)} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S3_datet})) AND ";
}
if (comboBox1.SelectedIndex == 1)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S3_datet} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S3_datet} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.s3_2_3})) AND ";
}
//if (comboBox1.SelectedIndex == 2)
// search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.s3_2_1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.s3_2_1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S4_2_1})) AND ";
//if (comboBox1.SelectedIndex == 3)
// search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.s3_2_1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.s3_2_1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S4_2_1})) AND ";
if (comboBox1.SelectedIndex == 4)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S4_2_1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S4_2_1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S6_datefarakhan})) AND ";
}
if (comboBox1.SelectedIndex == 5)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S6_datefarakhan} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S6_datefarakhan} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S4_3_1})) AND ";
}
if (comboBox1.SelectedIndex == 6)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S4_3_1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S4_3_1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S4_4_1})) AND ";
}
if (comboBox1.SelectedIndex == 7)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S4_4_1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S4_4_1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S9_2_date1})) AND ";
}
if (comboBox1.SelectedIndex == 8)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S9_2_date1} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S9_2_date1} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND (ISNull({Crystal_Rusty_All_Ravandkar_Main;1.S5_datevariz})) AND ";
}
if (comboBox1.SelectedIndex == 9)
{
search_amin = search_amin + " ({Crystal_Rusty_All_Ravandkar_Main;1.S5_datevariz} >= '" + u_set.control_date_end(persianDatePicker1.Text) + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S5_datevariz} <= '" + u_set.control_date_end(persianDatePicker2.Text) + "') AND ";
}
}
}
if (textBox3.Text != "" && textBox4.Text != "")
{
search_amin += " ({Crystal_Rusty_All_Ravandkar_Main;1.model} >= '" + textBox3.Text + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.model} <= '" + textBox4.Text + "') AND ";
}
if (textBox5.Text != "" && textBox6.Text != "")
{
search_amin += " ({Crystal_Rusty_All_Ravandkar_Main;1.S4_3_2} >= '" + textBox5.Text + "') AND ({Crystal_Rusty_All_Ravandkar_Main;1.S4_3_2} <= '" + textBox6.Text + "') AND ";
}
if (comboBox2.SelectedIndex > 0)
{
search_amin += " ({Crystal_Rusty_All_Ravandkar_Main;1.s1_enseraf} = '" + comboBox2.Text + "') AND ";
}
if (comboBox4.SelectedIndex > 0)
{
search_amin += " ({Crystal_Rusty_All_Ravandkar_Main;1.s3_2_3} = '" + comboBox4.Text + "') AND ";
}
if (search_amin != "")
{
search_amin = search_amin.Substring(1, search_amin.Length - 5);
if (comboBox5.SelectedIndex == 0)
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "گزارش پیشرفت روند فرسوده";
f1.selkar = "Crystal_Rusty_All_Ravandkar_Main";
f1.rec_sel_for = search_amin;
f1.prompt = comboBox1.Text;
f1.Show();
}
else
{
CrystalReportWpf_AlborzAutomobile.Window1 f1 = new CrystalReportWpf_AlborzAutomobile.Window1();
f1.Title = "گزارش پیشرفت روند فرسوده";
f1.selkar = "Crystal_Rusty_All_Ravandkar_Main_naghd";
f1.rec_sel_for = search_amin;
f1.prompt = comboBox1.Text;
f1.Show();
}
}
}