Example #1
0
        public int GetTable(STVPRCPData param, out DataTable table, out string msg)
        {
            int ret = 0;

            msg = null;
            OracleConnection connet = new OracleConnection();

            table = new DataTable("RCPMAIN");

            try
            {
                connet = new OracleConnection(config.connectionstring);
                connet.Open();
                if (connet.State != ConnectionState.Open)
                {
                    log.LogLine(string.Format("No connection to DB Oracle. CS: {0}", config.connectionstring)); return(1);
                }

                string query = string.Format(" SELECT T1.dd,T1.AmountRCP, T2.AmountPC, T1.AmountRCP-T2.AmountPC AS Diff FROM ( SELECT TRUNC(DOCDATE) AS DD, sum(S_DIIS) AS AmountRCP " +
                                             "FROM Rcd.VALID_RCPDATA  WHERE EMTCODETO=300 AND  DOCDATE>=:1 AND DOCDATE<=:2 group by TRUNC(DOCDATE) ) T1 " +
                                             "LEFT JOIN (SELECT PDATE, AMOUNT AS AmountPC FROM Rcd.VALID_AMOUNT_PC WHERE APPCODE=300) T2  ON T1.DD=T2.PDATE order by T1.DD ");

                OracleCommand cmd = new OracleCommand(query, connet);
                cmd.Parameters.Add(crp(OracleType.DateTime, param.dtbegin, "1", false));
                cmd.Parameters.Add(crp(OracleType.DateTime, param.dtend, "2", false));
                OracleDataAdapter da = new OracleDataAdapter(cmd);
                da.Fill(table);
            }
            catch (Exception ex) { log.LogLine("CRcpData.GetTable() " + ex.Message); ret = -1; msg = ex.Message; }
            return(ret);
        }
Example #2
0
        private void RCPViewData_Load(object sender, EventArgs e)
        {
            try
            {
                log         = new XLog();
                log.DirName = config.logpath;
                clWork      = new CRcpData(config);

                param = new STVPRCPData();

                param.dtbegin = new DateTime(2020, 07, 11, 1, 0, 0, 0);
                param.dtend   = DateTime.Now;
                OnPermit("MAINRCP");
            }
            catch (Exception ex) { MessageBox.Show(ex.TargetSite + " " + ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); }
        }
Example #3
0
 private void read_param()
 {
     param = new STVPRCPData();
 }