private void button1_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("Id");
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
if (!dataGridView1.Columns[i].HeaderCell.Value.ToString().Equals("Id"))
{
dt.Columns.Add(dataGridView1.Columns[i].HeaderCell.Value.ToString(), typeof(String));
}
}
dt.Columns.Add("供方");
dt.Columns.Add("需方");
dt.Columns.Add("合同号");
dt.Columns.Add("签约时间");
dt.Columns.Add("签约地点");
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (dataGridView1.Rows[i].Cells[6].Value != null)
{
dt.Rows.Add(dataGridView1.Rows[i].Cells[0].Value, dataGridView1.Rows[i].Cells[1].Value, dataGridView1.Rows[i].Cells[2].Value, dataGridView1.Rows[i].Cells[3].Value, dataGridView1.Rows[i].Cells[4].Value, dataGridView1.Rows[i].Cells[5].Value, dataGridView1.Rows[i].Cells[6].Value, dataGridView1.Rows[i].Cells[7].Value, dataGridView1.Rows[i].Cells[8].Value, dataGridView1.Rows[i].Cells[9].Value, dataGridView1.Rows[i].Cells[10].Value, txt_gongfang.Text, txt_XuFang.Text, txt_hetonghao.Text, txt_shijian.Text, txt_didian.Text);
}
}
cal.SaveMianFuliaoDingGouDan(dt);
MessageBox.Show("保存成功！");
}
catch (Exception ex)
{
//throw ex;
MessageBox.Show(ex.Message);
}
}
