private MD_ReportVerifyInfo GetRsReportVerifyInof(MD_ReportItem _ritem) { MD_ReportVerifyInfo _ret = null; string _sql = "select TBR,TBRQ,TBDW from BB_BBJLFJXXB where "; _sql += " TJDW =:TJDW AND NF=:NF AND YF=:YF AND BBMC=:BBMC "; OracleParameter[] _param = { new OracleParameter(":TJDW", OracleDbType.Varchar2), new OracleParameter(":NF", OracleDbType.Varchar2), new OracleParameter(":YF", OracleDbType.Varchar2), new OracleParameter(":BBMC", OracleDbType.Varchar2) }; _param[0].Value = _ritem.ReportDWID; _param[1].Value = _ritem.StartDate.Year.ToString(); _param[2].Value = _ritem.StartDate.Month.ToString("D2"); _param[3].Value = _ritem.ReportName.ReportName; OracleDataReader dr = OracleHelper.ExecuteReader(OracleHelper.ConnectionStringProfile, CommandType.Text, _sql, _param); while (dr.Read()) { _ret = new MD_ReportVerifyInfo(dr.IsDBNull(2) ? "" : dr.GetString(2), dr.IsDBNull(0) ? "" : dr.GetString(0), dr.IsDBNull(1) ? DateTime.MinValue : dr.GetDateTime(1)); } dr.Close(); return(_ret); }
private void InitInfoForm(MD_ReportVerifyInfo _info) { this.CB_ORG.EditValue = _info.OrgName; this.CB_USER.EditValue = _info.UserName; this.CB_DATE.EditValue = _info.VerifyDate; this.simpleButton1.Visible = false; this.simpleButton2.Text = "关闭"; this.Text = "报表审核信息"; }
private void ShowVerifyData(MD_ReportItem _ritem) { using (SinoSZClientBase.ReportService.ReportServiceClient _rsc = new SinoSZClientBase.ReportService.ReportServiceClient()) { MD_ReportVerifyInfo _info = _rsc.GetReportVerifyInfo(_ritem, reportType); Dialog_VerifyReport _dialog = new Dialog_VerifyReport(_info); _dialog.ShowDialog(); } }
public Dialog_VerifyReport(MD_ReportVerifyInfo _info) { InitializeComponent(); InitInfoForm(_info); }