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