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