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