コード例 #1
0
        void queryData(string strQuery, string Env)
        {
            dtParam = this.GetParam(strQuery);
            DataSet ds = new DataSet();

            if (dtParam != null && dtParam.Rows.Count > 0)
            {
                frmSqlExcuteParam frm = new frmSqlExcuteParam();
                frm.dtParam = this.dtParam;
                frm.ssql    = strQuery;
                DialogResult dis = frm.ShowDialog();
                if (dis.Equals(DialogResult.OK))
                {
                    this.dtParam = frm.dtParam;
                    OracleCommand cmd = new OracleCommand();
                    cmd.CommandText = strQuery;
                    if (dtParam != null & dtParam.Rows.Count > 0)
                    {
                        foreach (DataRow dr in dtParam.Rows)
                        {
                            if (string.IsNullOrEmpty(dr["Param"].ToString().Trim()))
                            {
                                continue;
                            }

                            cmd.Parameters.Add(new OracleParameter(dr["Param"].ToString(), dr["Value"]));
                        }
                    }

                    if (Env.ToUpper().Equals("PROD"))
                    {
                        ds = oraProdEnv.GetDataSet(cmd);
                        dgvProdEnv.DataSource = ds.Tables[0];
                    }
                    else
                    {
                        ds = oraTestEnv.GetDataSet(cmd);
                        dgvTestEnv.DataSource = ds.Tables[0];
                    }
                }
            }
            else
            {
                if (Env.ToUpper().Equals("PROD"))
                {
                    ds = oraProdEnv.GetDataSet(strQuery);
                    dgvProdEnv.DataSource = ds.Tables[0];
                }
                else
                {
                    ds = oraTestEnv.GetDataSet(strQuery);
                    dgvTestEnv.DataSource = ds.Tables[0];
                }
            }
        }
コード例 #2
0
        private DataSet GetCustomQueryDetail(OracleHelpMes ora, string queryid, string version)
        {
            string ssql = @"SELECT QUERYID,
       VERSION,
       QUERYSTRING,
       OLDQUERYSTRING,
       DESCRIPTION,
       LASTEVENTUSER,
       LASTEVENTDATE
  FROM CT_CUSTOMQUERY
 WHERE NVL (QUERYID, ' ') LIKE :QUERYID AND NVL (VERSION, ' ') LIKE :VERSION";

            OracleCommand cmd = new OracleCommand();

            cmd.CommandText = ssql;
            if (string.IsNullOrEmpty(queryid))
            {
                queryid = "%";
            }

            cmd.Parameters.Add(new OracleParameter("QUERYID", queryid));
            cmd.Parameters.Add(new OracleParameter("VERSION", version + "%"));

            DataSet ds = ora.GetDataSet(cmd);

            return(ds);
        }
コード例 #3
0
        private List <string> GetCustomQueryList(OracleHelpMes ora)
        {
            List <string> lstStr = new List <string>();

            string  ssql = "SELECT DISTINCT(QUERYID)  FROM CT_CUSTOMQUERY order by QUERYID";
            DataSet ds   = ora.GetDataSet(ssql);

            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    lstStr.Add(dr["QUERYID"].ToString());
                }
            }

            return(lstStr);
        }