/// <summary>
/// 报表文件
/// </summary>
/// <param name="vo"></param>
/// <returns></returns>
public int SaveReportFile(EntitySysReport vo)
{
int affectRows = 0;
SqlHelper svc = null;
try
{
svc = new SqlHelper(EnumBiz.onlineDB);
affectRows = svc.Commit(svc.GetUpdateParm(vo, new List <string> {
EntitySysReport.Columns.rptFile
}, new List <string> {
EntitySysReport.Columns.rptId
}));
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
affectRows = -1;
}
finally
{
svc = null;
}
return(affectRows);
}
/// <summary>
/// 主信息
/// </summary>
/// <param name="vo"></param>
/// <returns></returns>
public int SaveReport(ref EntitySysReport vo)
{
int affectRows = 0;
SqlHelper svc = null;
try
{
svc = new SqlHelper(EnumBiz.onlineDB);
if (vo.rptId <= 0)
{
affectRows = svc.Commit(svc.GetInsertParm(vo));
}
else
{
affectRows = svc.Commit(svc.GetUpdateParm(vo, new List <string> {
EntitySysReport.Columns.rptNo, EntitySysReport.Columns.rptName, EntitySysReport.Columns.pyCode,
EntitySysReport.Columns.wbCode, EntitySysReport.Columns.rptSql
},
new List <string> {
EntitySysReport.Columns.rptId
}));
}
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
affectRows = -1;
}
finally
{
svc = null;
}
return(affectRows);
}
/// <summary>
/// SetMainInfo
/// </summary>
/// <param name="vo"></param>
void SetMainInfo(EntitySysReport vo)
{
uiHelper.BeginLoading(Viewer);
if (vo == null)
{
Viewer.txtRptNo.Tag = null;
Viewer.txtRptNo.Text = string.Empty;
Viewer.txtRptName.Text = string.Empty;
Viewer.txtSql.Text = string.Empty;
}
else
{
Viewer.txtRptNo.Tag = vo;
Viewer.txtRptNo.Text = vo.rptNo;
Viewer.txtRptName.Text = vo.rptName;
Viewer.txtSql.Text = vo.rptSql;
}
Viewer.txtSql.Refresh();
xr = new XtraReport();
if (vo != null && vo.rptFile != null && vo.rptFile.Length > 0)
{
MemoryStream stream = new MemoryStream(vo.rptFile);
xr.LoadLayout(stream);
xr.DataSource = GetDataSource();
}
this.Viewer.ucPrintControl.PrintingSystem = xr.PrintingSystem;
xr.CreateDocument();
Viewer.ValueChanged = false;
uiHelper.CloseLoading(Viewer);
}
/// <summary>
/// Delete
/// </summary>
internal void Delete()
{
EntitySysReport reportVo = Viewer.txtRptNo.Tag as EntitySysReport;
if (reportVo == null || reportVo.rptId == 0)
{
return;
}
if (DialogBox.Msg("是否删除当前报表？", MessageBoxIcon.Question) == DialogResult.Yes)
{
using (ProxyFrame proxy = new ProxyFrame())
{
int ret = proxy.Service.DeleteReport(reportVo.rptId);
if (ret > 0)
{
SetMainInfo(null);
Viewer.tvRport.Nodes.Remove(Viewer.tvRport.FocusedNode);
DialogBox.Msg("删除成功！");
}
else
{
DialogBox.Msg("删除失败。");
}
}
}
}
/// <summary>
/// 报表文件
/// </summary>
/// <param name="vo"></param>
/// <returns></returns>
public int SaveReportFile(EntitySysReport vo)
{
using (BizFormDesign biz = new BizFormDesign())
{
return(biz.SaveReportFile(vo));
}
}
/// <summary>
/// 报表文件
/// </summary>
/// <param name="vo"></param>
/// <returns></returns>
public int SaveReportFile(EntitySysReport vo)
{
int affectRows = 0;
SqlHelper svc = null;
try
{
svc = new SqlHelper(EnumBiz.onlineDB);
affectRows = svc.Commit(svc.GetUpdateParm(vo, new List <string> {
EntitySysReport.Columns.rptFile
}, new List <string> {
EntitySysReport.Columns.rptId
}));
}
catch (Exception ex)
{
ExceptionLog.OutPutException(Function.GetExceptionCaption(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message));
affectRows = -1;
}
finally
{
svc = null;
}
return(affectRows);
}
/// <summary>
/// GetXR
/// </summary>
/// <returns></returns>
XtraReport GetXR(decimal rptId)
{
EntitySysReport rptVo = null;
using (ProxyCommon proxy = new ProxyCommon())
{
rptVo = proxy.Service.GetReport(this.rptId);
}
XtraReport xr = new XtraReport();
if (rptVo != null)
{
MemoryStream ms = new MemoryStream();
ms.Write(rptVo.rptFile, 0, rptVo.rptFile.Length);
xr.LoadLayout(ms);
}
xr.DataSource = this.gcData.DataSource as List <EntityYgInpatStat>;
XRControl xc; //报表上的组件
xc = xr.FindControl("lblDate", true);
if (xc != null)
{
(xc as XRLabel).Text = " " + dateScope;
}
xr.CreateDocument();
return(xr);
}
/// <summary>
/// 获取报表文件
/// </summary>
/// <param name="rptId"></param>
/// <returns></returns>
public EntitySysReport GetReport(decimal rptId)
{
SqlHelper svc = null;
try
{
EntitySysReport vo = new EntitySysReport();
vo.rptId = rptId;
svc = new SqlHelper(EnumBiz.onlineDB);
List <EntitySysReport> lstRpt = EntityTools.ConvertToEntityList <EntitySysReport>(svc.Select(vo, new List <string> {
EntitySysReport.Columns.rptId
}));
if (lstRpt != null && lstRpt.Count > 0)
{
return(lstRpt[0]);
}
}
catch (Exception ex)
{
ExceptionLog.OutPutException(Function.GetExceptionCaption(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message));
}
finally
{
svc = null;
}
return(null);
}
/// <summary>
/// 报表文件
/// </summary>
/// <param name="vo"></param>
/// <returns></returns>
public int SaveReportFile(EntitySysReport vo)
{
using (BizFrame biz = new BizFrame())
{
return(biz.SaveReportFile(vo));
}
}
public frmReportDesigner(EntitySysReport _reportVo)
{
InitializeComponent();
if (!DesignMode)
{
((ctlReportDesigner)Controller).rptTypeId = 1;
((ctlReportDesigner)Controller).reportVo = _reportVo;
}
}
/// <summary>
/// Refresh
/// </summary>
internal void Refresh()
{
LoadDataSource();
EntitySysReport reportVo = Viewer.txtRptNo.Tag as EntitySysReport;
if (reportVo != null)
{
Viewer.tvRport.FocusedNode = Viewer.tvRport.FindNodeByKeyID(reportVo.rptId);
}
}
/// <summary>
/// LoadDeptInfo
/// </summary>
/// <param name="node"></param>
void LoadRptInfo(TreeListNode node)
{
if (node == null)
{
return;
}
uiHelper.BeginLoading(Viewer);
try
{
EntitySysReport rptVo = (EntitySysReport)Viewer.tvRport.GetDataRecordByNode(node);
SetMainInfo(rptVo);
}
finally
{
uiHelper.CloseLoading(Viewer);
}
}
/// <summary>
/// Init
/// </summary>
void Init()
{
#region 参数
List <EntityRptEventParm> EventParmData = null;
using (ProxyEntityFactory proxy = new ProxyEntityFactory())
{
EventParmData = EntityTools.ConvertToEntityList <EntityRptEventParm>(proxy.Service.SelectFullTable(new EntityRptEventParm()));
}
#endregion
#region xr
decimal printId = 0;
EntitySysReport rptVo = null;
if (EventParmData != null)
{
if (EventParmData.Any(t => t.eventId == "12" && t.keyId == "printId"))
{
printId = Function.Dec(EventParmData.FirstOrDefault(t => t.eventId == "12" && t.keyId == "printId").keyValue);
}
}
if (printId > 0)
{
using (ProxyCommon proxy = new ProxyCommon())
{
rptVo = proxy.Service.GetReport(printId);
}
}
else
{
return;
}
xr = new XtraReport();
if (rptVo != null)
{
MemoryStream ms = new MemoryStream();
ms.Write(rptVo.rptFile, 0, rptVo.rptFile.Length);
xr.LoadLayout(ms);
}
this.ucPrintControl.PrintingSystem = xr.PrintingSystem;
xr.CreateDocument();
#endregion
this.Stat();
}
/// <summary>
/// Init
/// </summary>
void InitXr()
{
#region xr
decimal printId = 9;
EntitySysReport rptVo = null;
using (ProxyCommon proxy = new ProxyCommon())
{
rptVo = proxy.Service.GetReport(printId);
}
xr = new XtraReport();
if (rptVo != null)
{
MemoryStream ms = new MemoryStream();
ms.Write(rptVo.rptFile, 0, rptVo.rptFile.Length);
xr.LoadLayout(ms);
}
xr.CreateDocument();
#endregion
}
/// <summary>
/// init
/// </summary>
void init()
{
string[] arrStr = null;
string strTmp = string.Empty;
DateTime dtmNow = DateTime.Now;
this.dteDateStart.DateTime = new DateTime(dtmNow.Year, dtmNow.Month, 1);
this.dteDateEnd.DateTime = dtmNow;
using (ProxyAnaReport proxy = new ProxyAnaReport())
{
strTmp = proxy.Service.GetSysParamStr("3069");
if (!string.IsNullOrEmpty(strTmp))
{
arrStr = strTmp.Split('*');
foreach (string str in arrStr)
{
JyStr += "'" + str + "'" + ",";
}
JyStr = "(" + JyStr.TrimEnd(',') + ")";
}
}
decimal printId = 23;
EntitySysReport rptVo = null;
using (ProxyCommon proxy = new ProxyCommon())
{
rptVo = proxy.Service.GetReport(printId);
}
xr = new XtraReport();
if (rptVo != null)
{
MemoryStream ms = new MemoryStream();
ms.Write(rptVo.rptFile, 0, rptVo.rptFile.Length);
xr.LoadLayout(ms);
}
this.ucPrintControl.PrintingSystem = xr.PrintingSystem;
xr.CreateDocument();
}
/// <summary>
/// Design
/// </summary>
internal void Design()
{
EntitySysReport rptVo = Viewer.txtRptNo.Tag as EntitySysReport;
if (rptVo == null)
{
DialogBox.Msg("请保存报表。");
return;
}
if (string.IsNullOrEmpty(rptVo.rptSql))
{
DialogBox.Msg("请书写报表数据源(Sql)");
return;
}
if (Viewer.ValueChanged)
{
if (this.Save() == false)
{
return;
}
}
DataTable dt = GetDataSource();
if (dt == null)
{
DialogBox.Msg("书写的Sql不能正确构造出数据源，请检查Sql是否正确。");
return;
}
rptVo.dataSource = dt;
using (frmReportDesigner frm = new frmReportDesigner(rptVo))
{
frm.ShowDialog();
if (frm.IsSave)
{
int index = (Viewer.tvRport.DataSource as List <EntitySysReport>).FindIndex(t => t.rptId == rptVo.rptId);
(Viewer.tvRport.DataSource as List <EntitySysReport>)[index] = rptVo;
SetMainInfo(rptVo);
}
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="rptId"></param>
/// <returns></returns>
public int DeleteReport(decimal rptId)
{
int affectRows = 0;
SqlHelper svc = null;
try
{
svc = new SqlHelper(EnumBiz.onlineDB);
EntitySysReport vo = new EntitySysReport();
vo.rptId = (int)rptId;
affectRows = svc.Commit(svc.GetDelParmByPk(vo));
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
affectRows = -1;
}
finally
{
svc = null;
}
return(affectRows);
}
/// <summary>
/// Save
/// </summary>
internal void Save()
{
uiHelper.BeginLoading(Viewer);
try
{
MemoryStream ms = new MemoryStream();
Viewer.xrDesignPanel.Report.SaveLayout(ms);
ms.Seek(0, SeekOrigin.Begin);
byte[] bytData = new byte[ms.Length];
ms.Read(bytData, 0, bytData.Length);
ms.Close();
if (this.rptTypeId == 1)
{
this.reportVo.rptFile = ms.ToArray();
using (ProxyFormDesign proxy = new ProxyFormDesign())
{
EntitySysReport updateVo = new EntitySysReport();
updateVo.rptId = this.reportVo.rptId;
updateVo.rptFile = this.reportVo.rptFile;
if (proxy.Service.SaveReportFile(updateVo) > 0)
{
Viewer.IsSave = true;
Viewer.xrDesignPanel.ReportState = DevExpress.XtraReports.UserDesigner.ReportState.Saved;
DialogBox.Msg("保存成功！");
}
else
{
DialogBox.Msg("保存失败。");
}
}
}
else if (this.rptTypeId == 2)
{
this.templateVo.templateFile = ms.ToArray();
using (ProxyFormDesign proxy = new ProxyFormDesign())
{
object obj = this.templateVo.dataSource;
this.templateVo.dataSource = null;
if (proxy.Service.UpdateFormPrintTemplate(this.templateVo) > 0)
{
Viewer.IsSave = true;
Viewer.xrDesignPanel.ReportState = DevExpress.XtraReports.UserDesigner.ReportState.Saved;
DialogBox.Msg("保存成功！");
}
else
{
DialogBox.Msg("保存失败。");
}
this.templateVo.dataSource = obj;
}
}
}
catch (Exception ex)
{
DialogBox.Msg(ex.Message);
}
finally
{
uiHelper.CloseLoading(Viewer);
}
}
/// <summary>
/// Save
/// </summary>
internal bool Save()
{
if (isSave)
{
return(false);
}
isSave = true;
try
{
bool isNew = false;
EntitySysReport reportVo = null;
if (Viewer.txtRptNo.Tag == null)
{
reportVo = new EntitySysReport();
reportVo.creatorId = GlobalLogin.objLogin.EmpNo;
reportVo.createDate = Utils.ServerTime();
isNew = true;
}
else
{
reportVo = Viewer.txtRptNo.Tag as EntitySysReport;
}
reportVo.rptNo = Viewer.txtRptNo.Text.Trim();
reportVo.rptName = Viewer.txtRptName.Text.Trim();
reportVo.rptSql = Viewer.txtSql.Text.Trim();
if (string.IsNullOrEmpty(reportVo.rptNo))
{
DialogBox.Msg("请输入报表编号。");
Viewer.txtRptNo.Focus();
return(false);
}
if (string.IsNullOrEmpty(reportVo.rptName))
{
DialogBox.Msg("请输入报表名称。");
Viewer.txtRptName.Focus();
return(false);
}
reportVo.pyCode = SpellCodeHelper.GetPyCode(reportVo.rptName);
reportVo.wbCode = SpellCodeHelper.GetWbCode(reportVo.rptName);
reportVo.type = 1;
reportVo.status = 1;
using (ProxyFrame proxy = new ProxyFrame())
{
if (proxy.Service.SaveReport(ref reportVo) > 0)
{
Viewer.txtRptNo.Tag = reportVo;
if (isNew)
{
(Viewer.tvRport.DataSource as List <EntitySysReport>).Add(reportVo);
Viewer.tvRport.RefreshDataSource();
Viewer.tvRport.FocusedNode = Viewer.tvRport.FindNodeByKeyID(reportVo.rptId);
}
else
{
int index = (Viewer.tvRport.DataSource as List <EntitySysReport>).FindIndex(t => t.rptId == reportVo.rptId);
(Viewer.tvRport.DataSource as List <EntitySysReport>)[index] = reportVo;
Viewer.tvRport.RefreshDataSource();
}
DialogBox.Msg("保存报表成功！");
}
else
{
DialogBox.Msg("保存报表失败。");
}
}
Viewer.ValueChanged = false;
}
catch (Exception ex)
{
DialogBox.Msg(ex.Message);
return(false);
}
finally
{
isSave = false;
}
return(true);
}
