private void btnQuery_Click(object sender, EventArgs e)
{
try
{
string voyageNo = txtVoyage.Text.Trim();
if (string.IsNullOrWhiteSpace(voyageNo))
{
MessageBox.Show("请先输入总运单号");
return;
}
AddMessage("开始读取数据...总运单号：" + voyageNo);
string userName = txtUserName.Text.Trim();
string pwd = txtPwd.Text.Trim();
string code = txtCode.Text.Trim();
DataSet ds = ServiceHelper.GetData(voyageNo, userName, pwd, code);
// ds.ReadXml("d:\\20181201.xml");
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
dgvHead.DataSource = ds.Tables[0];
dgvList.DataSource = ds.Tables[1];
AddMessage(string.Format("读取数据成功!表头数据:{0}条,表体数据{1}条", ds.Tables[0].Rows.Count, ds.Tables[1].Rows.Count));
if (!db.CheckVoyageExist(voyageNo))
{
int rs = AddData(ds.Tables[0]);
AddMessage("成功插入" + rs + "条数据");
}
else
{
AddMessage("总运单号：" + voyageNo + "在数据库中已存在！");
}
}
else
{
AddMessage("未读取到数据");
}
}
catch (Exception ex)
{
FileHelper.WriteLog(ex.ToString());
AddMessage("执行错误，错误信息：" + ex.Message);
}
}
