C# Winform通过URL发送HTTP POST请求访问MES系统（oracle数据库）

花开花折 2018-10-14 11:06:40

需要：C# Winform通过URL发送HTTP POST请求访问MES系统（oracle数据库）

1：URL:http://127.0.0.1:8080/mes/service
2：查询接口：site=3000¶m=[{"name":"get_sfc","data":[{"model_no":"457542","project_no":"xxxx","batch_no":"27RC"}]}]
(1)参数说明：site=3000 工厂站点 param:参数为json格式字符串 name就是服务名称 data业务参数
(2)MES返回数据格式(Json)如下：
{"result":"sucess","message":"","data":
{
"tatal":"1","rows":[{"SFC":"45475454578"}]
}
}
(3)json字段说明：
result:接口交互状态，fail表示交互失败，sucess表示交互成功；message:result为fail有值：

1：我是应该利用HttpWebRequest 来实现与MES系统的对接，（向MES系统发URL+查询接口），类似下面的代码？？？？？

	/// <summary>登录</summary>

        /// <param name="url">请求地址</param>

        /// <param name="date">请求参数</param>

        /// <param name="method">请求方式（不是必需的）</param>

        /// <param name="dataEncoding">编码格式（不是必需的）</param>

        /// <returns></returns>

        public static string loginAPI(string url, string date, method method, dataEncoding dataEncoding)

        {

            string res = string.Empty;//返回请求结果变量

            string encodingType = dataEncoding.ToString() == "UTF8" ? "utf-8" : "GBK";//确定要使用的字符编号

            Encoding encoding = Encoding.GetEncoding(encodingType);

            //请求

            WebRequest webRequest = null;

            Stream postStream = null;

            //响应

            WebResponse webResponse = null;

            StreamReader streamReader = null;

            try

            {

                if (method == util.method.GET)

                {

                    url = url + "?" + date;

                }

                //请求

                webRequest = WebRequest.Create(url);

                webRequest.Method = "GET";

                if (method == util.method.POST)

                {

                    byte[] postDate = encoding.GetBytes(date);

                    webRequest.ContentLength = postDate.Length;

                    postStream = webRequest.GetRequestStream();

                    postStream.Write(postDate, 0, postDate.Length);

                }

                //响应

                webResponse = webRequest.GetResponse();

                streamReader = new StreamReader(webResponse.GetResponseStream(), encoding);

                res = streamReader.ReadToEnd();

            }

            catch (WebException ex)

            {

                using (HttpWebResponse response = (HttpWebResponse)ex.Response)

                {

                    using (Stream responseStream = response.GetResponseStream())

                    {

                        res = new StreamReader(responseStream).ReadToEnd();

                    }

                }

            }

            catch (Exception)

            {

            }

            finally

            {

                if (postStream != null)

                {

                    postStream.Close();

                }

                if (streamReader != null)

                {

                    streamReader.Close();

                }

                if (webResponse != null)

                {

                    webResponse.Close();

                }

            }

            return res;

        }

2：上面那中方式与通过数据库连接字符串访问Oracle的区别？？？？类似如下代码

     string ConnectionString = "Data Source=数据库名;User Id=用户名;Password=密码;Integrated Security=no;";

            //创建一个新连接 

            OracleConnection conn=new  OracleConnection(ConnectionString);

            //以上两句也可以写成 OracleConnection conn=new  OracleConnection "Data Source=数据库名;User Id=用户名;Password=密码;Integrated Security=no;");

            try

            {

                conn.Open();

               //下面这句话，即使是select....返回一个int类型的数，也要按下面这么利用数据集去做

               //不可能用一句话来实现

               //注意从函数外面传递参数到sql语句中的写法

               //比如传递AdNumber

               //"selectyhbh from gspuser where yhbh='" + AdNumber + "'"

                OracleCommand cmd = new OracleCommand("select * from FY", conn);

                OracleDataAdapter oda = new OracleDataAdapter(); 

                oda.SelectCommand = cmd;

                DataSet ds = new DataSet();

                oda.Fill(ds);

               //如果这想要第一行第一列可以这么写ds.Tables[0].Rows[0][0]

                gridControl1.DataSource = ds.Tables[0].DefaultView;

                conn.Close();

            }

            catch (Exception ee)

            {

                //如果有错误，输出错误信息 

                MessageBox.Show(ee.Message);

            }

            finally

            {

                //关闭连接

                conn.Close();