public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { RptStyle_StockCard rpt = new RptStyle_StockCard(); rpt.Site = this.Site; return rpt; }
private void STYLE_STOCKCARD() { ReportDocument rpt; SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["IRMSConnectionString"].ConnectionString); //string rptDocCachedKey = "StockCard"; //if (rptDocCachedKey != null) //{ // rpt = (RptStyle_StockCard)Cache[rptDocCachedKey]; //} //else //{ rpt = new RptStyle_StockCard(); // Cache.Insert(rptDocCachedKey, rpt); //} long Balqty = 0; long Balqty1 = 0; long INqty = 0; long OUTqty = 0; bool Firstrec = true; conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "genrptstyle_stockcard '" + System.DateTime.Now.Date + "','" + Request.QueryString["StyleNo"] + "','" + Session["USER_ID"] + "'"; cmd.ExecuteNonQuery(); DataTable ResultSet = new DataTable(); cmd.CommandText = "select * from rptstyle_stockcard where username = '******'"; using (SqlDataAdapter adapter = new SqlDataAdapter()) { adapter.SelectCommand = cmd; adapter.Fill(ResultSet); } foreach (DataRow row in ResultSet.Rows) { if (Firstrec == true) { Balqty = (long)row[6] + (long)row[7] + (long)row[8]; cmd.CommandText = "update rptstyle_stockcard set balance = '" + Balqty + "' where id = '" + (int)row[0] + "' and username = '******'"; cmd.ExecuteNonQuery(); Firstrec = false; } else { INqty = (long)row[6]; OUTqty = (long)row[7]; Balqty1 = Balqty + INqty - OUTqty; Balqty = Balqty1; cmd.CommandText = "update rptstyle_stockcard set balance = '" + Balqty + "' where id = '" + (int)row[0] + "' and username = '******'"; cmd.ExecuteNonQuery(); } } DataBaseLogIn(rpt); ParameterField prmAsOfDate = new ParameterField(); ParameterField prmUserName = new ParameterField(); ParameterFields prmList = new ParameterFields(); prmAsOfDate.ParameterFieldName = "asofdate"; prmUserName.ParameterFieldName = "username"; ParameterDiscreteValue prmAsOfDateValue = new ParameterDiscreteValue(); ParameterDiscreteValue prmUserNameValue = new ParameterDiscreteValue(); prmAsOfDateValue.Value = System.DateTime.Now.Date; prmUserNameValue.Value = Session["USER_ID"]; prmAsOfDate.CurrentValues.Add(prmAsOfDateValue); prmUserName.CurrentValues.Add(prmUserNameValue); prmList.Add(prmAsOfDate); prmList.Add(prmUserName); crvDailyReport.ParameterFieldInfo = prmList; crvDailyReport.ReportSource = rpt; }