private void btnQuery_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == -1)
{
MessageBox.Show("请选择公司");
comboBox1.Focus();
return;
}
if (dateStart.Value == null || dateStart.Value.ToString() == "")
{
MessageBox.Show("请选择开始日期");
dateStart.Focus();
return;
}
if (dateEnd.Value == null || dateEnd.Value.ToString() == "")
{
MessageBox.Show("请选择开结束日期");
dateEnd.Focus();
return;
}
DataRowView row = comboBox1.SelectedItem as DataRowView;
if (row == null)
{
return;
}
string strNSRSBH = row["NSRSBH"].ToString();
string strSKPBH = row["SKPBH"].ToString();;
string strSKPPwd = row["SKPPwd"].ToString();;
string strCertPwd = row["CertPwd"].ToString();;
string strFPLXDM = "1";//row["FPLXDM"].ToString(); ;
int nQueryType = 1;
string strQueryCondition = dateStart.Value.ToString("yyyyMMdd") + dateEnd.Value.ToString("yyyyMMdd");
int nInvoiceUploadType = 0;
string invoiceXml = string.Empty;
try
{
string s = Invoice.GetInvoices(strNSRSBH, strSKPBH, strSKPPwd, strCertPwd
, strFPLXDM, nQueryType, strQueryCondition, nInvoiceUploadType, sam);
//String str2 = sam.GetInvoiceInfo("500102010001497", "499000116076", "88888888", "12345678", "025", 1, "2016110120161130", 0);
//MessageBox.Show(str2, "系统提示3");
}
catch (Exception ex)
{
MessageBox.Show("获取发票异常：\r\n" + ex.Message);
return;
}
//_DataSet = XmlConvertor.XmlToDataSet(invoiceXml);
_DataSet = XmlConvertor.XmlToDataSet_Hei(textBox1.Text);
dataGridView_Mst.DataSource = _DataSet.Tables["Mst"];
dataGridView2.DataSource = _DataSet.Tables["Item"];
}
private void TbtnImport_HeiXml_Click(object sender, EventArgs e)
{
DataSet dataSet = XmlConvertor.ImportXmlToDataTable_Hei();
if (dataSet != null)
{
dataGridView_Mst.DataSource = dataSet.Tables[0];
dataGridView2.DataSource = dataSet.Tables[1];
toolStripStatusLabel1.Text = string.Format("记录数：{0} 总金额：{1}"
, dataSet.Tables[0].Rows.Count
, dataSet.Tables[0].Compute("sum(jshj)", ""));
}
}
public FormInvoiceExport()
{
InitializeComponent();
InitialToolsTrip();
try
{
sam = new BWJF_SKOP_ATLLib.SKControlLogic();
}
catch (Exception ex)
{
MessageBox.Show("加载税控盘接口失败：\r\n" + ex.Message);
}
comboBox1.DataSource = Company.GetData();
comboBox1.DisplayMember = "company";
comboBox1.ValueMember = "NSRSBH";
dataGridView_Mst.SelectionChanged += DataGridView1_SelectionChanged;
_DataSet = XmlConvertor.InitInvoiceDataTable();
}