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("保存失败"); } }