//错误表 //public DataTable dt_error; public SynchronizeClazz() { Token_test = new TokenClazz(txtUrl, "测试账套", "9c1f17bc02ee5aa47c3329918a5b886403248862c7a8dae3"); Token_WXHT = new TokenClazz(txtUrl, "无锡宏拓", "3bfc737f19b0432d3fbf8036e48331af817ff2c5596701cd"); Token_HNHG = new TokenClazz(txtUrl, "湖南宏工", "6e7280885f4cfa95d2c412263431ddf3ef786d058e4ba00c"); //dt_error = new DataTable(); //dt_error.Columns.Add("ID", typeof(Int32)); //dt_error.Columns.Add("JsonText", typeof(string)); }
//private static string txtUrl = @"http://193.1.11.159/K3API"; public TestFrm() { InitializeComponent(); btnGet.Click += BtnGet_Click; btnPost.Click += BtnPost_Click; btnCreateToken.Click += BtnCreateToken_Click; txtUrl.Text = @"http://193.1.11.159/K3API"; txtAuthod.Text = @"9c1f17bc02ee5aa47c3329918a5b886403248862c7a8dae3"; testToken = new TokenClazz(txtUrl.Text, "测试账套", "9c1f17bc02ee5aa47c3329918a5b886403248862c7a8dae3"); }
public void sendData2Db(string urlModel, TokenClazz Token, string jsonText, string id) { //湖南宏工账套项目号不一致 if (Token.CompanyName.Equals("湖南宏工")) { urlModel = urlModel.Replace("ItemClass3003", "ItemClass3002"); } string url = urlModel + Token.getToken(); string httpResponse = string.Empty; byte[] data = System.Text.Encoding.UTF8.GetBytes(jsonText); bool flag = HttpHelper.HttpPost(url, data, out httpResponse, 6000); JObject jo = new JObject(); try { jo = (JObject)JsonConvert.DeserializeObject(httpResponse); }catch (Exception e) { return; } string StatusCode = ""; string Message = ""; string Data = ""; StatusCode = null == jo["StatusCode"] ? "" : jo["StatusCode"].ToString(); Message = null == jo["Message"] ? "" : jo["Message"].ToString(); Data = null == jo["Data"] ? "" : jo["Data"].ToString(); //根据id更新推送状态 string updateSql = string.Format(@" INSERT INTO Synchronize_Log (DbName,SynID,JsonText_Msg,InsDate,SuccessCode,MsgText,DataText) VALUES ( '{0}', {1} , '{2}',CONVERT(VARCHAR(23),GETDATE(),121), '{3}', '{4}', '{5}' ) ", Token.CompanyName, id, jo.ToString(), StatusCode, Message, Data); DBCONN.Query(updateSql); }
private void BtnCreateToken_Click(object sender, EventArgs e) { testToken = new TokenClazz(txtUrl.Text, "测试账套", txtAuthod.Text); }