//错误表
//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);
}
