private void btnExport_Click(object sender, EventArgs e)
{
DataBase.DALCBData dalCBData = new DataBase.DALCBData();
DataSet ds = dalCBData.GetList("");
ExportExcel(ds.Tables[0], "D:\\CBData.xls");
}
private void btnSaveToDB_Click(object sender, EventArgs e)
{
StringBuilder sbTDH = new StringBuilder();
StringBuilder sbJLZ = new StringBuilder();
StringBuilder sbSK = new StringBuilder();
StringBuilder sbSKC = new StringBuilder();
StringBuilder sbCKZ = new StringBuilder();
StringBuilder sbYSSJ = new StringBuilder();
StringBuilder sbDT = new StringBuilder();
for (int i = 0; i < dgvData.Rows.Count - 1; i++)
{
if (dgvData.Rows[i].Cells["ColDataType"].Value.ToString() != "线圈")
{
//for (int j = 1; j < dgvData.Columns.Count; j++)
//{
sbTDH.Append(dgvData.Rows[i].Cells["ColTDH"].Value + ",");
sbJLZ.Append(dgvData.Rows[i].Cells["ColJLZ"].Value + ",");
sbSK.Append(dgvData.Rows[i].Cells["ColSK"].Value + ",");
sbSKC.Append(dgvData.Rows[i].Cells["ColSKC"].Value + ",");
sbCKZ.Append(dgvData.Rows[i].Cells["ColCKZ"].Value + ",");
sbDT.Append(dgvData.Rows[i].Cells["ColRecvTime"].Value + ",");
sbYSSJ.Append(dgvData.Rows[i].Cells["ColRecvCode"].Value + ",");
// }
}
}
DataBase.DALCBData dalCBData = new DataBase.DALCBData();
DataBase.CBDataTable tabCBData = new DataBase.CBDataTable();
tabCBData.TDH = sbTDH.ToString();
tabCBData.JLZ = sbJLZ.ToString();
tabCBData.SK = sbSK.ToString();
tabCBData.SKC = sbSKC.ToString();
tabCBData.CKZ = sbCKZ.ToString();
tabCBData.JSSJ = sbDT.ToString();
tabCBData.YSSJ = sbYSSJ.ToString();
if (dalCBData.Add(tabCBData) > 0)
{
MessageBox.Show("保存成功");
dgvData.Rows.Clear();
}
else
{
MessageBox.Show("保存失败");
}
}
