private void rpt3_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
if (StoreName != null)
{
xrLabel3.Text = StoreName;
}
string _Date = "";
if (ParamDate.Count == 2)
{
_Date = ParamDate[0].date.ToShortDateString() + " to " + ParamDate[1].date.ToShortDateString();
}
else
{
for (int i = 0; i < ParamDate.Count; i++)
{
_Date += Helpers.ConvertMyDate(ParamDate[i].date) + (i == ParamDate.Count - 1 ? "" : ", ");
}
}
xrLabel2.Text = "Report generated with date range of " + _Date;
//FindControl("xrLabel21", true).DataBindings.Add("Text", this.DataSource, "Name");
//FindControl("xrLabel22", true).DataBindings.Add("Text", this.DataSource, "Quantity");
//FindControl("xrLabel23", true).DataBindings.Add("Text", this.DataSource, "Amount");
//FindControl("xrLabel24", true).DataBindings.Add("Text", this.DataSource, "Percent", "{0:p}");
//FindControl("xrLabel25", true).DataBindings.Add("Text", this.DataSource, "Average", "{0:#,##0.00}");
xrLabel15.DataBindings.Add("Text", this.DataSource, "Name");
xrLabel16.DataBindings.Add("Text", this.DataSource, "Quantity", "{0:#,##0}");
xrLabel17.DataBindings.Add("Text", this.DataSource, "Amount", "{0:#,##0.00}");
xrLabel18.DataBindings.Add("Text", this.DataSource, "Percent", "{0:p}");
//totals ----------
XRLabel lblTotalQty = xrLabel10;
lblTotalQty.Text = TotalQty.ToString("#,##0.00");
XRLabel lblTotalAmt = xrLabel11;
lblTotalAmt.Text = TotalAmt.ToString("#,##0.00");
XRLabel lblTotalPercent = xrLabel14;
lblTotalPercent.Text = TotalPercent.ToString("#,##0.00");
//other calculations ----------
//Discount Total
XRLabel lblDiscntTotalAmt = xrLabel13;
lblDiscntTotalAmt.Text = DiscountAmt.ToString("#,##0.00");
//Net Sales
XRLabel lblNetSales = xrLabel7;
lblNetSales.Text = (Convert.ToDouble(lblTotalAmt.Text) - Convert.ToDouble(lblDiscntTotalAmt.Text)).ToString("#,##0.00");
}
private void SetDefaultValues()
{
try
{
var defaultMembers = from lines in Tables.Lines
where lines.Description == Line && lines.Department == Department
select lines;
var dm = defaultMembers.FirstOrDefault().Members;
decimal.TryParse(dm.ToString(), out var members);
numericUpDown1.Value = members;
dateTimePicker1.Value = DateTimes;
Text = Order + " - " + Line;
if (Text == string.Empty)
{
Text = "Programmation options";
}
lblCommessaBox.Text = Order;
lblArtBox.Text = Article;
lblQtyBox.Text = TotalQty.ToString();
lblCaricoSugg.Text = "Carico: " + Carico.ToString();
if (Carico == 0)
{
checkBox1.Enabled = false;
checkBox1.Checked = true;
ByTotalQty = true;
}
else
{
checkBox1.Checked = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}