Expand|Select|Wrap|Line Numbers
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Windows.Forms;
- using CrystalDecisions.CrystalReports.Engine;
- namespace MK_AUTOCARE
- {
- public partial class crystalReportViewer2 : Form
- {
- public crystalReportViewer2()
- {
- InitializeComponent();
- }
- private TextBox txthcode;
- private DateTime dateTime;
- private DateTime dateTime_2;
- public rptledger(DateTime dateTime,DateTime dateTime_2,TextBox txthcode)
- {
- InitializeComponent();
- // TODO: Complete member initialization
- this.dateTime = dateTime;
- this.dateTime_2 = dateTime_2;
- this.txthcode=txthcode;
- }
- dboperation db = new dboperation();
- db.DateCall(dtpto.Value);
- string s = "select * from grouphead";
- db.exenonquery(s);
- DataTable dt1 = db.exedatatable(s);
- string s = "select * from daybook where trdate between '" + db.SDAT.ToShortDateString() + "' and '" + db.EDAT.ToShortDateString() + "'";
- DataTable dt2 = db.exedatatable(s);
- s = "select * from HEAD";
- DataTable dt3 = db.exedatatable(s);
- s = "delete from OPBALHEAD";
- db.ExecuteSQL(s);
- if (dt2.Rows.Count > 0)
- {
- for (int i = 0; i < dt2.Rows.Count; i++)
- {
- double opbal = 0;
- s = "select sum(credit)-sum(debit) as bal from daybook where trdate <'" + db.SDAT.ToShortDateString() + "' and HCODE='" + dt2.Rows[i]["HCODE"].ToString() + "'";
- DataTable dt5 = db.exedatatable(s);
- if (dt5.Rows[0][0].ToString() != "")
- {
- opbal = Convert.ToDouble(dt5.Rows[0][0].ToString());
- }
- s = "select bal from OPENING where ACYEAR='" + db.SDAT.Year + "' and HCODE='" + dt2.Rows[i]["HCODE"].ToString() + "'";
- DataTable dt6 = db.exedatatable(s);
- if (dt6.Rows.Count > 0)
- {
- opbal = opbal + Convert.ToDouble(dt6.Rows[0][0].ToString());
- }
- s = "insert into OPBALHEAD values('" + dt2.Rows[i]["HCODE"].ToString() + "'," + opbal + ")";
- db.ExecuteSQL(s);
- }
- }
- s = "select * from OPBALHEAD";
- DataTable dt4 = db.exedatatable(s);
- DataSet2 ds = new DataSet2();
- // ds.GROUPHEAD.Clear();
- // ds.GROUPHEAD.Merge(dt1);
- ds.DAYBOOK.Clear();
- ds.DAYBOOK.Merge(dt2);
- ds.HEAD.Clear();
- ds.HEAD.Merge(dt3);
- ds.OPBAL.Clear();
- ds.OPBAL.Merge(dt4);
- daybook rpt = new daybook();
- rpt.SetDataSource(ds);
- TextObject MyText;
- MyText = (TextObject)rpt.ReportDefinition.ReportObjects["Text11"];
- MyText.Text = "Day Book";
- string ss = "select * from defaults";
- string comp = "", addr = "", place = "", dist = "", state = "";
- DataTable dtss = db.exedatatable(ss);
- if (dtss.Rows.Count > 0)
- {
- comp = dtss.Rows[0]["cname"].ToString();
- addr = dtss.Rows[0]["cadd"].ToString();
- place = dtss.Rows[0]["cplace"].ToString();
- dist = dtss.Rows[0]["dist"].ToString();
- state = dtss.Rows[0]["state"].ToString();
- }
- TextObject MyText1;
- MyText1 = (TextObject)rpt.ReportDefinition.ReportObjects["Text12"];
- MyText1.Text = comp;
- TextObject MyText3;
- MyText3 = (TextObject)rpt.ReportDefinition.ReportObjects["Text14"];
- MyText3.Text = addr + " " + place + " " + dist + " " + state;
- TextObject MyText2;
- MyText2 = (TextObject)rpt.ReportDefinition.ReportObjects["Text13"];
- MyText2.Text = "" + db.SDAT.ToShortDateString() + "' to '" + db.EDAT.ToShortDateString() + "' ";
- TextObject MyText4;
- MyText4 = (TextObject)rpt.ReportDefinition.ReportObjects["Text15"];
- MyText4.Text = "" + db.SDAT.Year.ToString() + "-" + db.EDAT.Year.ToString() + "";
- crystalReportViewer1.ReportSource = rpt;
- private void crystalReportViewer1_Load(object sender, EventArgs e)
- {
- }
- }
- }
Error 2 Method must have a return type I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 23 16 MK AUTOCARE
Error 3 Invalid token '(' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 33 23 MK AUTOCARE
Error 4 Invalid token ')' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 33 35 MK AUTOCARE
Error 5 Invalid token '(' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 35 27 MK AUTOCARE
Error 6 Invalid token ')' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 35 29 MK AUTOCARE
Error 7 Invalid token '=' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 39 15 MK AUTOCARE
Error 8 Invalid token '=' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 41 15 MK AUTOCARE
Error 9 Invalid token '(' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 42 26 MK AUTOCARE
Error 10 Invalid token ')' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 42 28 MK AUTOCARE
Error 11 Invalid token '>' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 43 32 MK AUTOCARE
Error 12 Invalid token ';' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 45 51 MK AUTOCARE
Error 13 Syntax error, '>' expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 45 51 MK AUTOCARE
Error 14 Invalid token '++' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 45 54 MK AUTOCARE
Error 15 Invalid token '=' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 49 23 MK AUTOCARE
Error 16 Invalid token '(' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 49 120 MK AUTOCARE
Error 17 Invalid token '[' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 49 151 MK AUTOCARE
Error 18 Invalid token '"HCODE"' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 49 155 MK AUTOCARE
Error 19 Identifier expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 49 155 MK AUTOCARE
Error 20 Method must have a return type I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 49 164 MK AUTOCARE
Error 21 ; expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 49 175 MK AUTOCARE
Error 22 Invalid token 'if' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 52 21 MK AUTOCARE
Error 23 Array size cannot be specified in a variable declaration (try initializing with a 'new' expression) I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 52 34 MK AUTOCARE
Error 24 Array size cannot be specified in a variable declaration (try initializing with a 'new' expression) I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 52 37 MK AUTOCARE
Error 25 Invalid token '.' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 52 39 MK AUTOCARE
Error 26 Method must have a return type I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 52 40 MK AUTOCARE
Error 27 ; expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 52 51 MK AUTOCARE
Error 28 Invalid token '=' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 54 31 MK AUTOCARE
Error 29 Invalid token '(' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 54 49 MK AUTOCARE
Error 30 Array size cannot be specified in a variable declaration (try initializing with a 'new' expression) I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 54 59 MK AUTOCARE
Error 31 Array size cannot be specified in a variable declaration (try initializing with a 'new' expression) I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 54 62 MK AUTOCARE
Error 32 Invalid token '.' in class, struct, or interface member declaration I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 54 64 MK AUTOCARE
Error 33 Method must have a return type I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 54 65 MK AUTOCARE
Error 34 ; expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 54 75 MK AUTOCARE
Error 35 A namespace cannot directly contain members such as fields or methods I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 58 21 MK AUTOCARE
Error 36 Identifier expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 58 113 MK AUTOCARE
Error 37 Identifier expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 62 67 MK AUTOCARE
Error 38 Identifier expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 62 70 MK AUTOCARE
Error 39 A namespace cannot directly contain members such as fields or methods I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 64 21 MK AUTOCARE
Error 40 Identifier expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 64 72 MK AUTOCARE
Error 41 Type or namespace definition, or end-of-file expected I:\MK AUTO CARE FINAL PROJECT3\MK LATEST 3\MK LATEST 2\MK LATEST\MK AUTO CARE NEW\MKAUTOCARE C#\MK AUTOCARE\MK AUTOCARE\rptledger.cs 66 17 MK AUTOCARE