/// <summary>
/// 调用存储过程,可等待较长时间
/// </summary>
/// <exception cref="Exception"></exception>
public static void Conn()
{
SqlConnection myConnection = new SqlConnection(@"server=.;uid=sa;pwd=密码;database=数据名称;Trusted_Connection=no");
SqlCommand MyCommand = new SqlCommand("proc_A_0_Main", myConnection); //定义一个数据库操作指令
MyCommand.CommandType = CommandType.StoredProcedure;//设置该语句是读取存储过程的
SqlDataAdapter SelectAdapter = new SqlDataAdapter();//定义一个数据适配器
SelectAdapter.SelectCommand = MyCommand;//定义数据适配器的操作指令
SelectAdapter.SelectCommand.CommandTimeout = 1800000;
try
{
myConnection.Open();//打开数据库连接
SelectAdapter.SelectCommand.ExecuteNonQuery();//执行数据库查询指令
myConnection.Close();//关闭数据库
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
}
/// <summary>
/// 指定Url 请求Post
/// </summary>
/// <param name="url"></param>
/// <param name="parameters"></param>
/// <returns></returns>
public static string Post(string url, Dictionary<string, object> parameters)
{
string jsonString = JsonConvert.SerializeObject(parameters);
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
request.Method = "POST";
request.ContentType = "application/json";
using (StreamWriter dataStream = new StreamWriter(request.GetRequestStream()))
{
dataStream.Write(jsonString);
dataStream.Close();
}
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
string encoding = response.ContentEncoding;
if (encoding == null || encoding.Length < 1)
{
encoding = "UTF-8"; //默认编码
}
StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.GetEncoding(encoding));
var retString = reader.ReadToEnd();
return System.Text.RegularExpressions.Regex.Unescape(retString); //处理返回的字符比如unicode转为中文
}
using Nancy.Json;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;
namespace HttpWeb
{
public class Program
{
static void Main(string[] args)
{
Dictionary<string, object> d_conn = new Dictionary<string, object>();//字典
d_conn.Add("hello", "welcome");//Http协议Post参数(字典键值对类型)
try
{
var js_Conn = Post("http://10.20.20.28:1234/hanlp/sayhello/", d_conn);//Http协议请求是否可以连接
if (js_Conn.Contains("welcome"))
{
#region//Http通许Post请求Web接口
Dictionary<string, object> d = new Dictionary<string, object>();
d.Add("HanlpThreeAtomStr", "《日照日报》是中共日照市委机关报,其前身《日照红旗》创刊于1958年7月1 日,是新中国成立后中共日照县委主办的第一张县级党报。");
try
{
var js = Post("http://10.20.20.28:1234/hanlp/Threeatom/", d);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + "-----通讯失败,请联系技术!");
}
#endregion
}
else
{
Console.WriteLine("-----通讯失败,请联系技术!");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message,"-----通讯失败,请联系技术!");
}
Console.ReadKey();
}
/// <summary>
/// Post请求
/// </summary>
/// <param name="url">URL</param>
/// <param name="parameters">字典键值对</param>
/// <returns></returns>
public static string Post(string url, Dictionary<string, object> parameters)
{
string jsonString = JsonConvert.SerializeObject(parameters);
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
request.Method = "POST";
request.ContentType = "application/json";
using (StreamWriter dataStream = new StreamWriter(request.GetRequestStream()))
{
dataStream.Write(jsonString);
dataStream.Close();
}
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
string encoding = response.ContentEncoding;
if (encoding == null || encoding.Length < 1)
{
encoding = "UTF-8"; //默认编码
}
StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.GetEncoding(encoding));
var retString = reader.ReadToEnd();
return System.Text.RegularExpressions.Regex.Unescape(retString); //处理返回的字符比如unicode转为中文
}
}
}