XtraReport1 CreateReport()
{
XtraReport1 report = new XtraReport1();
report.dersid.Value = GetSelectedValue(1);
report.CreateDocument();
return report;
}
public override void ExecuteReport()
{
base.ExecuteReport();
var sh = cbShop.Properties.Items.GetCheckedValues();
var tbShop = new DataTable();
tbShop.Columns.Add("Id", typeof(string));
sh.ForEach(x => tbShop.Rows.Add(x));
var sp = cbSupplier.Properties.Items.GetCheckedValues();
var tbSuppl = new DataTable();
tbSuppl.Columns.Add("Id", typeof(string));
sp.ForEach(x => tbSuppl.Rows.Add(x));
var sg = cbGroup.Properties.Items.GetCheckedValues();
var tbGp = new DataTable();
tbGp.Columns.Add("Id", typeof(string));
sg.ForEach(x => tbGp.Rows.Add(x));
string suppl = string.Join(", ", sp);
string group = string.Join(", ", sg);
try
{
Parameter.Connection.Open();
using (
var command = new SqlCommand("rep_sel_OrederByShop", Parameter.Connection)
{CommandType = CommandType.StoredProcedure, CommandTimeout = 60000})
{
command.Parameters.AddWithValue("@dateBeg", dateBeg.DateTime.Date);
command.Parameters.AddWithValue("@dateEnd", dateEnd.DateTime.Date);
command.Parameters.AddWithValue("@ShopCodes", tbShop);
command.Parameters.AddWithValue("@Suppliers", tbSuppl);
command.Parameters.AddWithValue("@GoodGroups", tbGp);
var rep = new XtraReport1() {DataAdapter = new SqlDataAdapter(command)};
rep.Parameters["pDate"].Value = string.Format("Период: {0} по {1}", dateBeg.DateTime.Date.ToShortDateString(), dateEnd.DateTime.Date.ToShortDateString());
rep.Parameters["pGroup"].Value = string.Format("Товарная группа: {0}", string.IsNullOrEmpty(group) ? "Все" : group);
rep.Parameters["pSuppl"].Value = string.Format("Поставщик: {0}", string.IsNullOrEmpty(suppl) ? "Все" : suppl);
var reportPrintTool = new ReportPrintTool(rep) {AutoShowParametersPanel = false};
reportPrintTool.ShowPreviewDialog();
}
}
finally
{
Parameter.Connection.Close();
}
//MessageBox.Show("ExecuteReport " + table.Rows.Count.ToString());
}
protected void ExportarExcel()
{
try
{
EnlazarDatos();
Sesion loSesion = (Sesion)Session["Sesion"];
XtraReport1 objReport = new XtraReport1();
objReport.DataSource = (DataTable)ViewState["loResultado"];
objReport.DataMember = "sqlDataSource1";
#region Asignar permiso de imprimir y guardar
if (Session["Permiso"] == null)
{
foreach (Permiso loPermiso in loSesion.Usuario.Permiso)
{
if (loPermiso.Clave == 14)
{
foreach (Dapesa.Seguridad.Comun.Definiciones.TipoPermiso loTipoEmelento in loPermiso.TipoPermiso)
{
if (loTipoEmelento.ToString() == "Imprimir")
{
#region Eliminar Boton Imprimir
ReportToolbarItem saveItem = null;
foreach (ReportToolbarItem item in xrInforme.ToolbarItems)
{
if (item.ItemKind == ReportToolbarItemKind.PrintReport || item.ItemKind == ReportToolbarItemKind.PrintPage)
{
saveItem = item;
}
}
xrInforme.ToolbarItems.Remove(saveItem);
saveItem = null;
foreach (ReportToolbarItem item in xrInforme.ToolbarItems)
{
if (item.ItemKind == ReportToolbarItemKind.PrintPage || item.ItemKind == ReportToolbarItemKind.PrintPage)
{
saveItem = item;
}
}
xrInforme.ToolbarItems.Remove(saveItem);
#endregion
xrInforme.ToolbarItems.Add(new ReportToolbarButton(ReportToolbarItemKind.PrintPage, true));
xrInforme.ToolbarItems.Add(new ReportToolbarButton(ReportToolbarItemKind.PrintReport, true));
}
}
}
if (loPermiso.Clave == 14)
{
foreach (Dapesa.Seguridad.Comun.Definiciones.TipoPermiso loTipoEmelento in loPermiso.TipoPermiso)
{
if (loTipoEmelento.ToString() == "Guardar")
{
#region Eliminar Boton Guadar
ReportToolbarItem loItem = null;
foreach (ReportToolbarItem item in xrInforme.ToolbarItems)
{
if (item.ItemKind == ReportToolbarItemKind.SaveToDisk || item.ItemKind == ReportToolbarItemKind.SaveToDisk)
{
loItem = item;
}
}
xrInforme.ToolbarItems.Remove(loItem);
#endregion
xrInforme.ToolbarItems.Add(new ReportToolbarButton(ReportToolbarItemKind.SaveToDisk, true));
}
}
}
}
}
#endregion
objReport.CreateDocument();
this.xrInforme.Report = objReport;
Page.Session["loInformeBackOrderPedidos"] = objReport;
}
catch (Exception ex)
{
Session["Excepcion"] = ex;
Response.Redirect("~/Error.aspx", false);
}
}
protected void ASPxCallbackPanel1_Callback(object source, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
XtraReport1.UpdateRecordsState(System.Convert.ToInt32(e.Parameter));
}
public void StampaPrimaNota(IList scritture, string filename)
{
XtraReport1 x = new XtraReport1();
x.DataSource = scritture;
string titleBanca1 = ""; // = TipoBilanco.IsProvinciale ? Properties.Settings.Default.Banca1Nome : Properties.Settings.Default.Banca1NomeRegionale ;
string titleBanca2 = ""; // = TipoBilanco.IsProvinciale ? Properties.Settings.Default.Banca2Nome : Properties.Settings.Default.Banca2NomeRegionale;
string titleBanca3 = ""; // = TipoBilanco.IsProvinciale ? Properties.Settings.Default.Banca3Nome : Properties.Settings.Default.Banca3NomeRegionale;
string titleBanca4 = ""; // = TipoBilanco.IsProvinciale ? Properties.Settings.Default.Banca1Nome : Properties.Settings.Default.Banca1NomeRegionale ;
string titleBanca5 = ""; // = TipoBilanco.IsProvinciale ? Properties.Settings.Default.Banca2Nome : Properties.Settings.Default.Banca2NomeRegionale;
string titleBanca6 = ""; // = TipoBilanco.IsProvinciale ? Properties.Settings.Default.Banca3Nome : Properties.Settings.Default.Banca3NomeRegionale;
_presenter.FillNomiBanca(ref titleBanca1, ref titleBanca2, ref titleBanca3, ref titleBanca4, ref titleBanca5, ref titleBanca6);
//riscrivo i nomi della banca
foreach (ScritturaPrimaNotaDTO item in scritture)
{
if (item.Contropartita == "Banca1" && titleBanca1 != "Banca1")
{
item.ContoContropartita = titleBanca1 + "(Banca1)";
}
else if (item.Contropartita == "Banca2" && titleBanca2 != "Banca2")
{
item.ContoContropartita = titleBanca2 + "(Banca2)";
}
else if (item.Contropartita == "Banca3" && titleBanca3 != "Banca3")
{
item.ContoContropartita = titleBanca3 + "(Banca3)";
}
else if (item.Contropartita == "Banca4" && titleBanca4 != "Banca4")
{
item.ContoContropartita = titleBanca4 + "(Banca4)";
}
else if (item.Contropartita == "Banca5" && titleBanca5 != "Banca5")
{
item.ContoContropartita = titleBanca5 + "(Banca5)";
}
else if (item.Contropartita == "Banca6" && titleBanca6 != "Banca6")
{
item.ContoContropartita = titleBanca6 + "(Banca6)";
}
if (item.Conto.StartsWith("Banca1") && titleBanca1 != "Banca1")
{
item.Conto = item.Conto.Replace("Banca1", titleBanca1 + "(Banca1)");
}
else if (item.Conto.StartsWith("Banca2") && titleBanca2 != "Banca2")
{
item.Conto = item.Conto.Replace("Banca2", titleBanca2 + "(Banca2)");
}
else if (item.Conto.StartsWith("Banca3") && titleBanca3 != "Banca3")
{
item.Conto = item.Conto.Replace("Banca3", titleBanca3 + "(Banca3)");
}
else if (item.Conto.StartsWith("Banca4") && titleBanca4 != "Banca4")
{
item.Conto = item.Conto.Replace("Banca4", titleBanca4 + "(Banca4)");
}
else if (item.Conto.StartsWith("Banca5") && titleBanca5 != "Banca5")
{
item.Conto = item.Conto.Replace("Banca5", titleBanca5 + "(Banca5)");
}
else if (item.Conto.StartsWith("Banca5") && titleBanca5 != "Banca5")
{
item.Conto = item.Conto.Replace("Banca5", titleBanca5 + "(Banca5)");
}
}
x.ExportToPdf(filename);
Process.Start(filename);
}
private void Print()
{
XtraReport report = new XtraReport1();
ReportData = new SignsJobCardReportData();
ReportData.Lines.AddRange(new[]
{
new SignJobCardReportLine
{
Shape = new ImageSource(Properties.Resources.SL),
Size = "750 SL",
Qty = 20,
Unit = "Nos"
},
new SignJobCardReportLine {
Shape = new ImageSource(Properties.Resources.Circle),
Size = "600 Dia",
Qty = 32,
Unit = "Nos"
},
new SignJobCardReportLine {
Shape = new ImageSource(Properties.Resources.HT),
Size = "600 HT",
Qty = 2,
Unit = "Nos"
},
new SignJobCardReportLine {
Shape = new ImageSource(Properties.Resources.R1),
Size = "1200 x 400",
Qty = 16,
Unit = "Nos"
},
new SignJobCardReportLine {
Shape = new ImageSource(Properties.Resources.R2)
},
new SignJobCardReportLine {
Shape = new ImageSource(Properties.Resources.R3)
}
});
var aluminumSheets = SelectedAluminumSheets.Split(',');
ReportData.AluminumSheet2_03MM = aluminumSheets.Contains("2.03mm") ? "P" : "";
ReportData.AluminumSheet3_175MM = aluminumSheets.Contains("3.175mm") ? "P" : "";
ReportData.AluminumSheet3_0MM = aluminumSheets.Contains("3.0mm") ? "P" : "";
ReportData.AluminumSheet2_0MM = aluminumSheets.Contains("2.0mm") ? "P" : "";
ReportData.AluminumSheet1_5MM = aluminumSheets.Contains("1.5mm") ? "P" : "";
ReportData.AluminumSheet1MM = aluminumSheets.Contains("1.0mm") ? "P" : "";
report.DataSource = new List <SignsJobCardReportData> {
ReportData
};
DocumentPreviewWindow window = new DocumentPreviewWindow();
window.PreviewControl.DocumentSource = report;
report.CreateDocument();
window.Show();
}
void OnNavBarItemsClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
{
if (sender != navBarItemExit)
{
RemoveControls();
}
if (sender == navBarItemCheck)
{
//Process prupdate = Process.Start("wyUpdate.exe");
CheckUpdate();
}
//else if (sender == navBarItemHelp)
//{
// //Help.ShowHelp(this, "C:\\Users\\Femmy\\Documents\\Visual Studio 2010\\Projects\\TSS_Oyo\\BankReconciliation\\reconciliation.chm");
//}
else if (sender == navBarItemMergeAgent)
{
tableLayoutPanel2.Controls.Add((new Form1().panelContainer), 1, 0);
Form1.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;
Form1.publicStreetGroup.RefreshForm();
}
else if (sender == navBarItemMergeApproval)
{
tableLayoutPanel2.Controls.Add((new FrmApproval().panelContainer), 1, 0);
FrmApproval.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;
FrmApproval.publicStreetGroup.RefreshForm();
}
else if (sender == navBItmTaxAgent)
{
string strquery = string.Format("SELECT UTINNew ,tblTaxAgent.OrganizationName ,Registration.tblTaxAgentMerge.UTIN ,Registration.tblTaxAgentMerge.OrganizationName FROM Registration.tblTaxAgentMerge JOIN Registration.tblTaxAgent ON UTINNew = tblTaxAgent.UTIN AND TaxAgentReferenceNumberNew = Registration.tblTaxAgent.TaxAgentReferenceNumber");
using (var ds = new System.Data.DataSet())
{
using (SqlDataAdapter ada = new SqlDataAdapter(strquery, Logic.ConnectionString))
{
ada.SelectCommand.CommandTimeout = 0;
ada.Fill(ds, "tables");
}
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count >= 1)
{
var listret = (from DataRow row in ds.Tables[0].Rows
select new ReportsMergi
{
OrganizationNameNew = row["OrganizationName"] as string,
UTINNew = row["UTINNew"] as string,
UTIN = row["UTIN"] as string,
OrganizationName = row["OrganizationName"] as string
}).ToList();
//XtraRepTaxAgentReturnAnnual Annual = new XtraRepTaxAgentReturnAnnual { DataSource = listret, logoPath = Logic.logopth };
//Annual.xrLabel11.Text = string.Format("{0} STATE GOVERNMENT", Program.StateName.ToUpper());
//Annual.xrLabel12.Text = string.Format("Tax Agent Annual returns report for {0} assessmenyt year", oDataRowViewsd.Row["TaxYear"]);
//Annual.ShowPreviewDialog();
XtraReport1 report = new XtraReport1 {
DataSource = listret
};
report.ShowPreviewDialog();
}
else
{
Common.setMessageBox("No Record Found for selected Tax Agent Reconcilied", Program.ApplicationName, 1);
return;
}
}
}
else if (sender == navBarItemExit)
{
Close();
}
//else if (sender == navBarItemDataUpload)
//{
// tableLayoutPanel2.Controls.Add((new FrmTransaction().panelContainer), 1, 0);
// FrmTransaction.publicStreetGroup.Tag = ((sender) as NavBarItem).Tag;
// FrmTransaction.publicStreetGroup.RefreshForm();
//}
}
public override void UpdateChargeGrid(Object _chargeObjects)
{
CalculateChargeClass calculateChargeClass =
(_chargeObjects as Dictionary <string, object>)["第一阶段"] as CalculateChargeClass;
base.UpdateChargeGrid(calculateChargeClass);
if (calculateChargeClass != null)
{
DataRow row = _chargeTable_1.NewRow();
row[0] = calculateChargeClass.MID;
row[1] = "有功（总）";
row[2] = calculateChargeClass.endEnergy.ToString("#0.00");
row[3] = calculateChargeClass.startEnergy.ToString("#0.00");
row[4] = "30";
row[5] = calculateChargeClass.totalPower.ToString("#0.00");
_chargeTable_1.Rows.Add(row);
row = _chargeTable_1.NewRow();
row[0] = calculateChargeClass.MID;
row[1] = "有功（尖峰）";
row[2] = calculateChargeClass.spikeEnergy.ToString("#0.00");
row[4] = "30";
row[5] = calculateChargeClass.spikePower.ToString("#0.00");
_chargeTable_1.Rows.Add(row);
row = _chargeTable_1.NewRow();
row[0] = calculateChargeClass.MID;
row[1] = "有功（峰）";
row[2] = calculateChargeClass.peakEnergy.ToString("#0.00");;
row[4] = "30";
row[5] = calculateChargeClass.peakPower.ToString("#0.00");
_chargeTable_1.Rows.Add(row);
row = _chargeTable_1.NewRow();
row[0] = calculateChargeClass.MID;
row[1] = "有功（谷）";
row[2] = calculateChargeClass.valleyEnergy.ToString("#0.00");;
row[4] = "30";
row[5] = calculateChargeClass.valleyPower.ToString("#0.00");
_chargeTable_1.Rows.Add(row);
row = _chargeTable_1.NewRow();
row[0] = calculateChargeClass.MID;
row[1] = "无功（QI象限）";
row[2] = "";
row[4] = "30";
row[5] = calculateChargeClass.ReactiveQI.ToString("#0.00");
_chargeTable_1.Rows.Add(row);
DataRow row1 = _chargeTable_2.NewRow();
row1[0] = calculateChargeClass.activeCopperLoss.ToString("#0.00");
row1[1] = calculateChargeClass.activeCoreLoss.ToString("#0.00");
row1[2] = calculateChargeClass.activeAll.ToString("#0.00");
row1[3] = calculateChargeClass.reactiveCopperLoss.ToString("#0.00");
row1[4] = calculateChargeClass.reactiveCoreLoss.ToString("#0.00");
row1[5] = calculateChargeClass.reactiveAll.ToString("#0.00");
row1[6] = calculateChargeClass.peakPower.ToString("#0.00");
row1[7] = calculateChargeClass.valleyPower.ToString("#0.00");
row1[8] = calculateChargeClass.spikePower.ToString("#0.00");
_chargeTable_2.Rows.Add(row1);
DataRow row2 = _chargeTable_3.NewRow();
row2[0] = 0;
row2[1] = 0;
row2[2] = 0;
row2[3] = 0;
row2[4] = 0;
row2[5] = 0;
row2[6] = 0;
row2[7] = 0;
row2[8] = 0;
_chargeTable_3.Rows.Add(row2);
DataRow row3 = _chargeTable_4.NewRow();
Double total = 0;
row3[0] = "尖 一般工商";
row3[1] = calculateChargeClass.spikePower.ToString("#0.00");
row3[2] = 0;
row3[3] = "kW.h";
row3[4] =
((_chargeObjects as Dictionary <string, object>)["电量参数"] as List <ElectricityParameter>)[0].PriceSpike;
row3[5] = (Convert.ToDouble(row3[4].ToString()) * Convert.ToDouble(row3[1].ToString())).ToString("#0.00");
total += Convert.ToDouble(row3[5]);
_chargeTable_4.Rows.Add(row3);
row3 = _chargeTable_4.NewRow();
row3[0] = "峰 一般工商";
row3[1] = calculateChargeClass.peakPower.ToString("#0.00");
row3[2] = 0;
row3[3] = "kW.h";
row3[4] =
((_chargeObjects as Dictionary <string, object>)["电量参数"] as List <ElectricityParameter>)[0].PricePeak;
row3[5] = (Convert.ToDouble(row3[4].ToString()) * Convert.ToDouble(row3[1].ToString())).ToString("#0.00");
total += Convert.ToDouble(row3[5]);
_chargeTable_4.Rows.Add(row3);
row3 = _chargeTable_4.NewRow();
row3[0] = "谷 一般工商";
row3[1] = calculateChargeClass.valleyPower.ToString("#0.00");
row3[2] = 0;
row3[3] = "kW.h";
row3[4] =
((_chargeObjects as Dictionary <string, object>)["电量参数"] as List <ElectricityParameter>)[0]
.PriceValley;
row3[5] = (Convert.ToDouble(row3[4].ToString()) * Convert.ToDouble(row3[1].ToString())).ToString("#0.00");
total += Convert.ToDouble(row3[5]);
_chargeTable_4.Rows.Add(row3);
row3 = _chargeTable_4.NewRow();
row3[0] = "合计";
row3[1] = "";
row3[2] = "";
row3[3] = "";
row3[4] = "";
row3[5] = total.ToString("#0.00");
_chargeTable_4.Rows.Add(row3);
gridCharge_1.DataSource = _chargeTable_1;
gridCharge_2.DataSource = _chargeTable_2;
gridCharge_3.DataSource = _chargeTable_3;
gridCharge_4.DataSource = _chargeTable_4;
XtraReport1 report = new XtraReport1();
report.ExportOptions.PrintPreview.DefaultFileName = "国网浙江慈溪市供电公司非居民用户电费复核单据 （一次抄表）" +
DateTime.Now.ToString("D");
documentViewer.DocumentSource = report;
report.SetReportDataSource(_chargeTable_1, _chargeTable_2, _chargeTable_3, _chargeTable_4);
}
}
protected void Page_Load(object sender, EventArgs e)
{
XtraReport1 report = new XtraReport1();
Session["report"] = report;
}
private void button4_Click(object sender, EventArgs e)
{
var R = new XtraReport1();
R.Filling(LR);
var RPT = new DevExpress.XtraReports.UI.ReportPrintTool(R);
RPT.ShowPreview();
}