private void Print_Click(object sender, EventArgs e)
{
try
{
Stimulsoft.Report.StiReport rpt = new Stimulsoft.Report.StiReport();
string startupPath = System.IO.Path.GetDirectoryName(System.Windows.Forms.Application.ExecutablePath);
rpt.Load(startupPath + "\\Reports\\GoodsReport.mrt");
rpt.Dictionary.Variables["today"].Value = DateTodayFullChar();
rpt.RegBusinessObject("Goods", (List <Connection.Services.GoodsService>)dataGridView1.DataSource);
rpt.Render();
rpt.Show();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
}
}
private void printPerson()
{
if (comboreshte2.Text == "" || dataGridViewX2.RowCount == 0)
{
return;
}
string sqlperson = "SELECT person.family + ' ' + person.name[name], person.father, person.tarikht[tavalod], " +
" person.codeMeli[meli], person.shsh, person.sadere, [P&R].nomreN[nazari],[P&R].nomreA[amali], [P&R].shGovahi[govahiname] " +
" FROM person INNER JOIN [P&R] ON person.codeMeli = [P&R].PID WHERE ([P&R].Rname = N'" + comboreshte2.Text + "')AND(person.codeMeli = N'" + textBoxX1.Text + "') ORDER BY name";
string sqlVariable = "SELECT reshte.code[codeEstandard], reshte.name[nameReshte], reshte.date[DateAzmoon], reshte.onvan[onvanReshte], reshte.dateShoroo[DateShoroo], [P&R].dateSodoor[DateSodoor] " +
"FROM reshte INNER JOIN [P&R] ON reshte.code = [P&R].RID WHERE (reshte.name = N'" + comboreshte2.Text + "')";
string str = Application.StartupPath + "\\rep\\perrep.mrt";
DataManagement.DT = DataManagement.Search(sqlperson);
try
{
Stimulsoft.Report.StiReport stikol = new Stimulsoft.Report.StiReport();
stikol.Load(str);
stikol.RegData("person", DataManagement.DT);
stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT;
DataManagement.DT = DataManagement.Search(sqlVariable);
DataManagement.DT.Columns.Add("number");
DataManagement.DT.Columns.Add("nameMarkaz");
DataManagement.DT.Columns.Add("nahiye");
DataManagement.DT.Columns.Add("sal");
DataManagement.DT.Columns.Add("nobat");
//DataManagement.DT.Rows[0]["number"] = dataGridViewX1.RowCount.ToString();
//DataManagement.DT.Rows[0]["nameMarkaz"] = txtNameMarkaz.Text;
//DataManagement.DT.Rows[0]["nahiye"] = txtNahiye.Text;
//DataManagement.DT.Rows[0]["sal"] = txtSal.Text;
//DataManagement.DT.Rows[0]["nobat"] = txtNobat.Text;
stikol.Load(str);
stikol.RegData("variable", DataManagement.DT);
stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT;
stikol.Show();
}
catch
{
FMessegeBox.FarsiMessegeBox.Show("مشکل در چاپ اطلاعات", "اخطار");
}
}
private void toolStripButtonPrint_Click(object sender, EventArgs e)
{
if (treeViewReports.SelectedNode.Index != -1)
{
using (Stimulsoft.Report.StiReport report = new Stimulsoft.Report.StiReport())
{
report.Load(ReportsPath + treeViewReports.SelectedNode.Text + ".mrt");
report.Dictionary.Databases.Clear();
report.RegData("Demo", "Demo", dataSetInvoice);
report.Compile();
report.Show(true);
}
}
else
{
MessageBox.Show("Select invoice first to proceed!");
}
}
private void btnfaragir_Click(object sender, EventArgs e)
{
string sqlselectperson = "SELECT codeMeli, name, family, father, shsh, tarikht, sadere, mtavalod, sal, mah, mobile " +
" FROM person WHERE(codeMeli = N'" + dataGridViewX2.CurrentRow.Cells[3].Value.ToString() + "')";
string sqlselectreshte = "SELECT name, onvan, vamali, vnazari FROM reshte WHERE (name = N'" + comboreshte2.Text + "')";
string sqlRP = "SELECT [P&R].PID, reshte.name, reshte.onvan, reshte.vamali, reshte.vnazari " +
" FROM [P&R] INNER JOIN reshte ON [P&R].RID = reshte.code " +
" WHERE([P&R].PID = N'" + dataGridViewX2.CurrentRow.Cells[3].Value.ToString() + "') AND (reshte.name = N'" + comboreshte2.Text + "')";
try
{
string str = Application.StartupPath + "\\rep\\Sabtnam.mrt";
Stimulsoft.Report.StiReport stikol = new Stimulsoft.Report.StiReport();
Stimulsoft.Report.StiReport stitmp = new Stimulsoft.Report.StiReport();
stitmp.Load(str);
//DataSet ds = new DataSet();
DataTable dt1 = DataManagement.Search(sqlselectperson);
//ds.Tables.Add(dt1);
DataTable dt2 = DataManagement.Search(sqlRP);
//ds.Tables.Add(dt2);
//ds.Tables[0].TableName = "khate1";
//ds.Tables[1].TableName = "variable1";
stitmp.RegData("khate1", dt1);
stitmp.RegData("variable1", dt2);
//stikol.Report = stitmp;
stikol.Show(this);
//stikol.Dictionary.DataSources.Items[0].Dictionary.DataSources = ds;
//stikol.RegData("variable1", dtPerson);
//stikol.Dictionary.DataSources.Items[1].DataTable = dtPerson;
}
catch (Exception ex) { FMessegeBox.FarsiMessegeBox.Show(ex.Message); }
}
private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
report.Show();
}
private void printPerson()
{
if (comboreshte1.Text == "" || dataGridViewX1.RowCount == 0 || comboonvan1.Text == "")
{
return;
}
string sqlperson = "SELECT person.family + ' ' + person.name[name], person.father, person.tarikht[tavalod], " +
" person.codeMeli[meli], person.shsh, person.sadere, [P&R].nomreN[nazari],[P&R].nomreA[amali], [P&R].shGovahi[govahiname] " +
" FROM person INNER JOIN [P&R] ON person.codeMeli = [P&R].PID WHERE ([P&R].Rname = N'" + comboreshte1.Text + "'){0}{1}{2} ORDER BY name";
string.Format(sqlperson, (comboonvan1.Text == "" ? "" : "AND([P&R].Ronvan = N'" + comboreshte1.Text + "')"), (combosal1.Text == "" ? "" : "AND(person.sal = N'" + combosal1.Text + "')")
, (combomah1.Text == "" ? "" : "AND(person.mah = N'" + combomah1.Text + "')"));
string sqlVariable = "SELECT reshte.code[codeEstandard], reshte.name[nameReshte], reshte.date[DateAzmoon], reshte.onvan[onvanReshte], reshte.dateShoroo[DateShoroo], [P&R].dateSodoor[DateSodoor] " +
"FROM reshte INNER JOIN [P&R] ON reshte.code = [P&R].RID WHERE (reshte.name = N'" + comboreshte1.Text + "')AND(reshte.onvan = N'" + comboonvan1.Text + "')";
string str = Application.StartupPath + "\\rep\\perrep.mrt";
DataManagement.DT = DataManagement.Search(sqlperson);
try
{
for (int i = 0; i < DataManagement.DT.Rows.Count; i++)
{
bool x = false;
int j = 0;
for (; j < dataGridViewX1.SelectedRows.Count; j++)
{
if (dataGridViewX1.SelectedRows[j].Cells[0].Value.ToString()
== DataManagement.DT.Rows[i][0].ToString())
{
x = true;
break;
}
}
if (x)
{
continue;
}
DataManagement.DT.Rows.RemoveAt(i);
i--;
}
Stimulsoft.Report.StiReport stikol = new Stimulsoft.Report.StiReport();
stikol.Load(str);
stikol.RegData("person", DataManagement.DT);
stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT;
DataManagement.DT = DataManagement.Search(sqlVariable);
DataManagement.DT.Columns.Add("number");
DataManagement.DT.Columns.Add("nameMarkaz");
DataManagement.DT.Columns.Add("nahiye");
DataManagement.DT.Columns.Add("sal");
DataManagement.DT.Columns.Add("nobat");
DataManagement.DT.Rows[0]["number"] = dataGridViewX1.RowCount.ToString();
DataManagement.DT.Rows[0]["nameMarkaz"] = txtNameMarkaz.Text;
DataManagement.DT.Rows[0]["nahiye"] = txtNahiye.Text;
DataManagement.DT.Rows[0]["sal"] = txtSal.Text;
DataManagement.DT.Rows[0]["nobat"] = txtNobat.Text;
stikol.Load(str);
stikol.RegData("variable", DataManagement.DT);
stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT;
stikol.Show();
}
catch
{
FMessegeBox.FarsiMessegeBox.Show("مشکل در چاپ اطلاعات", "اخطار");
}
}
private void printGovahi(string type)
{
string CodeMeli = "", NameReshte = "";
string sqlGovahi = "";
string str = Application.StartupPath + "\\rep\\govarpt.mrt";
Stimulsoft.Report.StiReport stikol = new Stimulsoft.Report.StiReport();
try
{
stikol.Load(str);
}
catch (Exception ex)
{
FMessegeBox.FarsiMessegeBox.Show(ex.Message);
}
if (type == "one")
{
CodeMeli = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
NameReshte = comboreshte1.Text;
sqlGovahi = "SELECT person.codeMeli AS meli, person.name + ' ' + person.family AS name, person.father, person.shsh, person.tarikht AS tavalod, person.sadere, [P&R].nomreA, " +
"[P&R].nomreN, [P&R].dateSodoor AS sodoor, [P&R].shGovahi AS govahi, person.mtavalod AS shahr, [P&R].RID AS codeStandard FROM person INNER JOIN [P&R] ON person.codeMeli = [P&R].PID " +
"WHERE (person.codeMeli = N'" + CodeMeli + "') AND ([P&R].Rname = N'" + dataGridViewX1.CurrentRow.Cells[12].Value.ToString() +
"')AND([P&R].Ronvan = N'" + dataGridViewX1.CurrentRow.Cells[11].Value.ToString() + "')";
//sqlGovahi = "SELECT person.codeMeli[meli], person.name + ' ' + person.family[name], person.father, person.shsh, person.tarikht[tavalod], person.sadere, [P&R].nomreA, " +
// "[P&R].nomreN, [P&R].dateSodoor[sodoor], [P&R].shGovahi[govahi], reshte.onvan, reshte.date[azmon], reshte.modat, reshte.code[codeStandard], person.mtavalod[shahr] " +
// "FROM person INNER JOIN [P&R] ON person.codeMeli = [P&R].PID INNER JOIN reshte ON [P&R].RID = reshte.code " +
// "WHERE (person.codeMeli = N'" + CodeMeli + "') AND ([P&R].Rname = N'" + comboBoxEx1.SelectedItem.ToString() +
// "')AND([P&R].Ronvan = N'" + comboBoxEx2.Text + "')";
DataManagement.DT = DataManagement.Search(sqlGovahi);
try
{
stikol.RegData("variable", DataManagement.DT);
DataManagement.DT.Columns.Add("mahal");
DataManagement.DT.Columns.Add("onvan");
DataManagement.DT.Columns.Add("azmon");
DataManagement.DT.Columns.Add("modat");
DataManagement.DT.Rows[0]["mahal"] = txtNameMarkaz.Text;
DataManagement.DT.Rows[0]["onvan"] = txtOnvan.Text;
DataManagement.DT.Rows[0]["azmon"] = txtAzmoon.Text;
DataManagement.DT.Rows[0]["modat"] = txtModat.Text;
stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT;
stikol.Show(this);
}
catch (Exception ex)
{
FMessegeBox.FarsiMessegeBox.Show(ex.Message, "اخطار");
}
}/*
* else
* {
* NameReshte = comboBoxEx1.Text;
*
* for (int i = 0; i< dataGridViewX1.RowCount; i++)
* {
* CodeMeli = dataGridViewX1.Rows[i].Cells[0].Value.ToString();
* sqlGovahi = "SELECT person.codeMeli[meli], person.name + ' ' + person.family[name], person.father, person.shsh, person.tarikht[tavalod], person.sadere, [P&R].nomreA, " +
* "[P&R].nomreN, [P&R].dateSodoor[sodoor], [P&R].shGovahi[govahi], reshte.onvan, reshte.date[azmon], reshte.modat, reshte.code[codeStandard], person.mtavalod[shahr] " +
* "FROM person INNER JOIN [P&R] ON person.codeMeli = [P&R].PID INNER JOIN reshte ON [P&R].RID = reshte.code " +
* "WHERE (person.codeMeli = N'" + CodeMeli + "') AND (reshte.name = N'" + NameReshte + "')";
*
* DataManagement.DT = DataManagement.Search(sqlGovahi);
* try
* {
*
* DataManagement.DT.Columns.Add("mahal");
* DataManagement.DT.Columns.Add("onvan");
* DataManagement.DT.Columns.Add("azmon");
* DataManagement.DT.Columns.Add("modat");
* DataManagement.DT.Rows[0]["mahal"] = txtNameMarkaz.Text;
* DataManagement.DT.Rows[0]["onvan"] = txtOnvan.Text;
* DataManagement.DT.Rows[0]["azmon"] = txtAzmoon.Text;
* DataManagement.DT.Rows[0]["modat"] = txtModat.Text;
*
* stikol.RegData("variable", DataManagement.DT);
* stikol.Dictionary.DataSources.Items[0].DataTable = DataManagement.DT;
*
* stikol.Print();
* }
* catch(Exception ex)
* {
* FMessegeBox.FarsiMessegeBox.Show(ex.Message, "اخطار");
* break;
* }
* }
* }*/
}
