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);
}
}
}
