public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
SalesBillCRD rpt = new SalesBillCRD();
rpt.Site = this.Site;
return(rpt);
}
private void QueryBTN_Click(object sender, EventArgs e)
{
SalesBillCRD SalesRep = new SalesBillCRD();
ParameterFields SalesParam = new ParameterFields();
ParameterField BillType = new ParameterField();
ParameterDiscreteValue BillValue = new ParameterDiscreteValue();
ParameterField FromDate = new ParameterField();
ParameterDiscreteValue FromDatevalue = new ParameterDiscreteValue();
ParameterField ToDate = new ParameterField();
ParameterDiscreteValue ToDatevalue = new ParameterDiscreteValue();
ParameterField BillNo = new ParameterField();
ParameterDiscreteValue BillNovalue = new ParameterDiscreteValue();
ParameterField RbF = new ParameterField();
ParameterDiscreteValue RbFvalue = new ParameterDiscreteValue();
ParameterField BillIdP = new ParameterField();
ParameterDiscreteValue BillIdPFvalue = new ParameterDiscreteValue();
ParameterField AgentId = new ParameterField();
ParameterDiscreteValue AgentIdvalue = new ParameterDiscreteValue();
BillIdPFvalue.Value = 0;
// RbFvalue.Value = 7;
BillType.Name = "BillType";
if (OperType.SelectedIndex == 0)
{
BillValue.Value = "'SEL'";
}
else
{
BillValue.Value = "'REF'";
}
BillType.CurrentValues.Add(BillValue);
FromDate.Name = "fromDate";
FromDatevalue.Value = FromDateTB.Text;
ToDate.Name = "ToDate";
ToDatevalue.Value = ToDateTB.Text;
RbF.Name = "RbF";
BillIdP.Name = "BillId";
if (fat_id_rdbtn.Checked)
{
if (BillIdTB.Text != "")
{
BillIdPFvalue.Value = BillIdTB.Text.Trim();
}
else
{
BillIdPFvalue.Value = 0;
MessageBox.Show("لايوجد رقم فاتورة سوف يتم عرض اخر فاتورة");
}
}
AgentId.Name = "AgentId";
if (AgentQCB.Items.Count > 0)
{
AgentIdvalue.Value = AgentQCB.SelectedValue;
}
else
{
AgentIdvalue.Value = 0;
}
if (fat_id_rdbtn.Checked)
{
if (BillIdTB.Text != "")
{
RbFvalue.Value = 3;
}
else
{
RbFvalue.Value = 2;
}
}
else if (DateRB.Checked == true && AgentCHB.Checked == false)
{
RbFvalue.Value = 0;
}
else if (BillCounterRB.Checked == true && AgentCHB.Checked == false)
{
RbFvalue.Value = 1;
}
else if (FinalBillRB.Checked == true && AgentCHB.Checked == false)
{
RbFvalue.Value = 2;
}
else if (DateRB.Checked == true && AgentCHB.Checked == true)
{
RbFvalue.Value = 4;
}
else if (BillCounterRB.Checked == true && AgentCHB.Checked == true)
{
RbFvalue.Value = 5;
}
else if (FinalBillRB.Checked == true && AgentCHB.Checked == true)
{
RbFvalue.Value = 6;
}
else
{
RbFvalue.Value = 2;
}
AgentId.CurrentValues.Add(AgentIdvalue);
BillIdP.CurrentValues.Add(BillIdPFvalue);
FromDate.CurrentValues.Add(FromDatevalue);
BillIdP.CurrentValues.Add(BillIdPFvalue);
BillNo.Name = "BillNo";
BillNovalue.Value = BillNoTB.Value;
BillNo.CurrentValues.Add(BillNovalue);
ToDate.CurrentValues.Add(ToDatevalue);
RbF.CurrentValues.Add(RbFvalue);
SalesParam.Add(BillType);
SalesParam.Add(ToDate);
SalesParam.Add(RbF);
SalesParam.Add(BillIdP);
//SalesParam.Add();
SalesParam.Add(AgentId);
SalesParam.Add(FromDate);
SalesParam.Add(BillNo);
SalesCRV.ReportSource = SalesRep;
SalesCRV.ParameterFieldInfo = SalesParam;
}
private void Print_Load(object sender, EventArgs e)
{
try
{
SalesBillCRD SalesRep = new SalesBillCRD();
SalesSmallBillCRD SaleSmallRep = new SalesSmallBillCRD();
ParameterFields SalesParam = new ParameterFields();
ParameterField BillType = new ParameterField();
ParameterDiscreteValue BillValue = new ParameterDiscreteValue();
ParameterField FromDate = new ParameterField();
ParameterDiscreteValue FromDatevalue = new ParameterDiscreteValue();
ParameterField ToDate = new ParameterField();
ParameterDiscreteValue ToDatevalue = new ParameterDiscreteValue();
ParameterField BillNo = new ParameterField();
ParameterDiscreteValue BillNovalue = new ParameterDiscreteValue();
ParameterField RbF = new ParameterField();
ParameterDiscreteValue RbFvalue = new ParameterDiscreteValue();
ParameterField BillIdP = new ParameterField();
ParameterDiscreteValue BillIdPFvalue = new ParameterDiscreteValue();
ParameterField AgentId = new ParameterField();
ParameterDiscreteValue AgentIdvalue = new ParameterDiscreteValue();
BillType.Name = "BillType";
BillValue.Value = "'SEL'";
AgentId.Name = "AgentId";
AgentIdvalue.Value = 0;
SalesParam.Add(AgentId);
AgentId.CurrentValues.Add(AgentIdvalue);
BillType.CurrentValues.Add(BillValue);
SalesParam.Add(BillType);
FromDate.Name = "fromDate";
FromDatevalue.Value = DateTime.Now;
ToDate.Name = "ToDate";
ToDatevalue.Value = DateTime.Now;
RbF.Name = "RbF";
RbFvalue.Value = 2;
if (billId != 0)
{
RbFvalue.Value = 3;
}
else
{
RbFvalue.Value = 2;
}
BillIdP.Name = "BillId";
BillIdPFvalue.Value = billId;
SalesParam.Add(BillIdP);
BillIdP.CurrentValues.Add(BillIdPFvalue);
FromDate.CurrentValues.Add(FromDatevalue);
SalesParam.Add(FromDate);
ToDate.CurrentValues.Add(ToDatevalue);
SalesParam.Add(ToDate);
RbF.CurrentValues.Add(RbFvalue);
SalesParam.Add(RbF);
SalesParam.Add(BillIdP);
BillIdP.CurrentValues.Add(BillIdPFvalue);
BillNo.Name = "BillNo";
BillNovalue.Value = 3;
BillNo.CurrentValues.Add(BillNovalue);
SalesParam.Add(BillNo);
SalesCRV.ReportSource = SalesRep;
SalesCRV.ParameterFieldInfo = SalesParam;
}
catch (Exception hh)
{
MessageBox.Show(hh.Message);
}
}
