public List <SinoPost> GetPostListInOrg(SinoOrganize CurrentOrg)
{
return(UserManagerFactroy.GetPostListInOrg(CurrentOrg));
}
public bool PastePostToOrg(List <SinoPost> _clipPad, SinoOrganize _org)
{
return(UserManagerFactroy.PastePostToOrg(_clipPad, _org));
}
private List <MD_ReportItem> GetSinoSZDefineReports(DateTime _startDate, DateTime _endDate, List <MD_ReportName> _selectReportNames, SinoOrganize _Org)
{
List <MD_ReportItem> _ret = new List <MD_ReportItem>();
string _rnString = "";
string _fg = "";
foreach (MD_ReportName _rn in _selectReportNames)
{
_rnString += string.Format("{0}{1}", _fg, _rn.ReportName);
_fg = ",";
}
using (OracleConnection cn = OracleHelper.OpenConnection())
{
OracleCommand _cmd = new OracleCommand();
_cmd.CommandText = "zhtj_zdybb.getbbmc";
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Connection = cn;
OracleParameter _p1 = _cmd.Parameters.Add("strtjdw", OracleDbType.Varchar2);
_p1.Value = _Org.DWDM;
OracleParameter _p2 = _cmd.Parameters.Add("dtbegin_p", OracleDbType.Varchar2);
_p2.Value = (_startDate == DateTime.MinValue) ? "" : _startDate.ToString("yyyyMMdd");
OracleParameter _p3 = _cmd.Parameters.Add("dtend_p", OracleDbType.Varchar2);
_p3.Value = (_endDate == DateTime.MaxValue) ? "" : _endDate.ToString("yyyyMMdd");
OracleParameter _p4 = _cmd.Parameters.Add("strbbmc", OracleDbType.Varchar2);
_p4.Value = _rnString;
_cmd.Parameters.Add("recret", OracleDbType.RefCursor, DBNull.Value, ParameterDirection.Output);
OracleDataReader _dr = _cmd.ExecuteReader();
while (_dr.Read())
{
bool _isauth = _dr.IsDBNull(6) ? false : (_dr.GetString(6) == "已审核");
MD_ReportItem _item = new MD_ReportItem(
_dr.IsDBNull(3) ? DateTime.MinValue : _dr.GetDateTime(3),
_dr.IsDBNull(4) ? DateTime.MaxValue : _dr.GetDateTime(4),
new MD_ReportName(_dr.IsDBNull(0) ? "" : _dr.GetString(0), _dr.IsDBNull(5) ? "" : _dr.GetString(5), SinoSZReportType.SinoSZDefineReport),
_dr.IsDBNull(1) ? "" : _dr.GetString(1),
_dr.IsDBNull(2) ? "" : _dr.GetString(2),
_isauth);
_ret.Add(_item);
}
_dr.Close();
cn.Close();
}
return(_ret);
}
public List <MD_ReportItem> GetReports(DateTime _startDate, DateTime _endDate, List <MD_ReportName> _selectReportNames, SinoOrganize _Org, string reportType)
{
switch (reportType)
{
case "RS报表":
return(GetRsReports(_startDate, _endDate, _selectReportNames, _Org));
default:
return(GetSinoSZDefineReports(_startDate, _endDate, _selectReportNames, _Org));
}
return(new List <MD_ReportItem>());
}
private List <MD_ReportItem> GetRsReports(DateTime _startDate, DateTime _endDate, List <MD_ReportName> _selectReportNames, SinoOrganize _Org)
{
string _yearstr = _startDate.Year.ToString();
string _monthstr = _startDate.Month.ToString("D2");
string _sql = "select t.BBMC,t.BBJC,t.TJDW,t.JGMC,t.NF,t.YF, ";
_sql += " (select count(a2.bbmc) from bb_bbjlfjxxb a2 where a2.bbmc = t.bbmc AND a2.tjdw = t.TJDW ";
_sql += " and a2.nf = t.nf and a2.yf = t.yf and a2.tbrq is not null ) ysh ";
_sql += " from BB_BBJLXXST t where T.TJDW = :TJDW";
_sql += " and t.nf = :NF and t.yf = :YF and t.bbmc in (";
string _fg = "";
foreach (MD_ReportName _rn in _selectReportNames)
{
_sql += string.Format(" {0}'{1}'", _fg, _rn.ReportName);
_fg = ",";
}
_sql += ")";
OracleParameter[] _param = { new OracleParameter(":TJDW", OracleDbType.Varchar2, 12),
new OracleParameter(":NF", OracleDbType.Char, 4),
new OracleParameter(":YF", OracleDbType.Char, 2) };
_param[0].Value = _Org.DWDM;
_param[1].Value = _yearstr;
_param[2].Value = _monthstr;
List <MD_ReportItem> _ret = new List <MD_ReportItem>();
OracleDataReader dr = OracleHelper.ExecuteReader(OracleHelper.ConnectionStringProfile, CommandType.Text, _sql, _param);
while (dr.Read())
{
MD_ReportName _mitem = new MD_ReportName(dr.IsDBNull(0) ? "" : dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
SinoSZReportType.ReportingService);
int _year = int.Parse(dr.IsDBNull(4) ? "2000" : dr.GetString(4));
int _month = int.Parse(dr.IsDBNull(5) ? "1" : dr.GetString(5));
DateTime _sDate = new DateTime(_year, _month, 1);
DateTime _eDate = _sDate.AddMonths(1).AddSeconds(-1);
bool _isauth = dr.IsDBNull(6) ? false : (dr.GetDecimal(6) > 0);
MD_ReportItem _ritem = new MD_ReportItem(_sDate, _eDate, _mitem, dr.IsDBNull(2) ? "" : dr.GetString(2), dr.IsDBNull(3) ? "" : dr.GetString(3), _isauth);
_ret.Add(_ritem);
}
dr.Close();
return(_ret);
}
private List <MD_ReportItem> GetSinoSZDefineReports(MD_ReportName _ReportName, SinoOrganize _Org)
{
List <MD_ReportName> _rps = new List <MD_ReportName>();
_rps.Add(_ReportName);
return(GetSinoSZDefineReports(DateTime.MinValue, DateTime.MaxValue, _rps, _Org));
}
public OrgTreeItem()
{
this.children = null;
this.owner = null;
data = new SinoOrganize();
}
public OrgTreeItem(SinoOrganize _data)
{
this.children = null;
this.owner = null;
data = _data;
}
public List <MD_ReportItem> GetReports(DateTime _startDate, DateTime _endDate, List <MD_ReportName> _selectReportNames, SinoOrganize _Org, string reportType)
{
return(ReportFactroy.GetReports(_startDate, _endDate, _selectReportNames, _Org, reportType));
}
public List <MD_ReportItem> GetReports(MD_ReportName _ReportName, SinoOrganize _Org, string reportType)
{
return(ReportFactroy.GetReports(_ReportName, _Org, reportType));
}
public OrgEventArgs(TreeListNode _node, SinoOrganize _org)
{
this.SelectedNode = _node;
this.Organize = _org;
}
virtual protected string ShowTitle(SinoOrganize _dw)
{
return(_dw.Name);
}
private void frmUserDefine_Load(object sender, EventArgs e)
{
this.sinoUC_OrgTree1.LoadOrgList(SessionClass.CurrentSinoUser.QxszDWID);
this._currentOrg = this.sinoUC_OrgTree1.SelectedOrganize;
_initFinished = true;
}
