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; * } * } * }*/ }