private void button3_Click(object sender, EventArgs e) { var task = Task.Run(() => { string sql = "select * from BaiduUpload_info"; DataTable dt = SqlHelper.SqlHelper.ExcuteDataTable(sql); foreach (DataRow item in dt.Rows) { try { var contSign = item["cont_sign"].ToString(); var client = new Baidu.Aip.ImageSearch.ImageSearch(API_KEY, SECRET_KEY); var result = client.ProductDeleteBySign(contSign); Console.WriteLine(result); setList fc = new setList(Settext); string sql2 = "delete from BaiduUpload_info where cont_sign=@cont_sign"; SqlParameter[] parameters2 = new SqlParameter[] { new SqlParameter("@cont_sign", contSign) }; SqlHelper.SqlHelper.ExcuteNonQuery(sql2, parameters2); this.BeginInvoke(fc, contSign + "已删除");//调用代理 } catch (Exception EX) { Console.WriteLine(EX); Console.WriteLine("--------删除失败----------"); } System.Threading.Thread.Sleep(500); } MessageBox.Show("全部删除"); }); }
private void handle(string contSign, string path, string fGoodsCode) { //删除百度 var client = new Baidu.Aip.ImageSearch.ImageSearch(API_KEY, SECRET_KEY); var result = client.ProductDeleteBySign(contSign); //上传百度 var image = File.ReadAllBytes(path); // 如果有可选参数 var options = new Dictionary <string, object> { { "brief", "{\"fGoodsCode\":\"" + fGoodsCode + "\"}" }, { "url", path } }; var res = client.ProductAdd(image, options); if (res.Count == 2) { //上传成功更新数据库 string sql2 = "update BaiduUpload_info set cont_sign=@cont_sign where fGoodsCode=@fGoodsCode"; SqlParameter[] parameters2 = new SqlParameter[] { new SqlParameter("@cont_sign", res["cont_sign"].ToString()), new SqlParameter("@fGoodsCode", fGoodsCode) }; int count = SqlHelper.SqlHelper.ExcuteNonQuery(sql2, parameters2); if (count > 0) { sw.WriteLine(fGoodsCode + "更新成功" + DateTime.Now.ToString("yyyy-MM-dd")); } else { string sql3 = "insert into BaiduUpload_info values(@fGoodsCode,@cont_sign)"; SqlParameter[] p = new SqlParameter[] { new SqlParameter("@cont_sign", res["cont_sign"].ToString()), new SqlParameter("@fGoodsCode", fGoodsCode) }; int row = SqlHelper.SqlHelper.ExcuteNonQuery(sql3, p); if (row > 0) { sw.WriteLine(fGoodsCode + "新增成功" + DateTime.Now.ToString("yyyy-MM-dd")); } } } else { string error = res["error_code"].ToString(); string id = Guid.NewGuid().ToString(); string sql_text = "insert into BaiduUpload_err values(@id,@fGoodSCode,@flieName,@cont_same,@upLoadDate,@err_Code)"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@id", id), new SqlParameter("@fGoodSCode", fGoodsCode), new SqlParameter("@flieName", path), new SqlParameter("@cont_same", res["cont_sign"].ToString()), new SqlParameter("@upLoadDate", DateTime.Now), new SqlParameter("@err_Code", error), }; int count = SqlHelper.SqlHelper.ExcuteNonQuery(sql_text, parameters); if (count > 0) { sw.WriteLine(fGoodsCode + "更新失败" + DateTime.Now); } } }