private void btnDCSJ_Selected_Click(object sender, EventArgs e)
{
delPwd DP = new delPwd();
DP.Show();
if (DP.rightYH != "1")
{
return;
}
List <string> listSFZ = new List <string>();
List <int> RowsIndex = new List <int>();//记录选中行的集合
//MessageBox.Show(sqlDataView.SelectedRows[1].Index.ToString());
for (int j = dataGridView1.SelectedRows.Count - 1; j >= 0; j--)
{
RowsIndex.Add(dataGridView1.SelectedRows[j].Index);
}
foreach (int item in RowsIndex)
{
try
{
//listSFZ.Add(dataGridView1[1, item].Value.ToString());
//string sqlguid = "select SJguid from JCRSJXX where JCRsfz='" + dataGridView1[1,item].Value.ToString()+ "'";
//string getGuid = sqlMethod(sqlguid, 1);
listSFZ.Add(dataGridView1[8, item].Value.ToString());
}
catch
{ MessageBox.Show("请勿选择空行", "提示"); return; }
}
string path = "";
SaveFileDialog SFD = new SaveFileDialog();
SFD.Title = "选择存储地址";
SFD.Filter = "Excel文件|*.xls";
bool re = false;
SFD.FileName = DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + "_" +
DateTime.Now.Hour + "_" + DateTime.Now.Minute + "_" + DateTime.Now.Second + "SJ";
//SFD.ShowDialog();
if (SFD.ShowDialog() == DialogResult.Cancel)
{
return;
}
path = SFD.FileName;
re = DCSJ_selected(path, listSFZ);
if (re == true)
{
MessageBox.Show("导出成功!", "提示");
dataGridView1.ClearSelection();
}
else
{
MessageBox.Show("导出失败!", "提示");
dataGridView1.ClearSelection();
}
}
private void btnDCSJ_one_Click(object sender, EventArgs e)
{
delPwd DP = new delPwd();
DP.Show();
if (DP.rightYH != "1")
{
return;
}
//List<int> RowsIndex = new List<int>();
//for (int j = dataGridView1.SelectedRows.Count - 1; j >= 0; j--)
//{
// RowsIndex.Add(dataGridView1.SelectedRows[j].Index);
//}
//获得要导出的对象的身份证集合
List <string> listSFZ = new List <string>();
for (int i = 0; i < dataGridView1.SelectedRows.Count; i++)
{
string sqlguid = "select SJguid from JCRSJXX where JCRsfz='" + dataGridView1[1, dataGridView1.CurrentRow.Index].Value.ToString() + "'";
string getGuid = sqlMethod(sqlguid, 1);
listSFZ.Add(getGuid);
}
string path = "";
SaveFileDialog SFD = new SaveFileDialog();
SFD.Title = "选择存储地址";
SFD.Filter = "Excel文件|*.xls";
bool re = false;
SFD.FileName = DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + "_" +
DateTime.Now.Hour + "_" + DateTime.Now.Minute + "_" + DateTime.Now.Second + "SJ";
//SFD.ShowDialog();
if (SFD.ShowDialog() == DialogResult.Cancel)
{
return;
}
path = SFD.FileName;
re = DCSJ_selected(path, listSFZ);
if (re == true)
{
MessageBox.Show("导出成功!", "提示");
dataGridView1.ClearSelection();
}
else
{
MessageBox.Show("导出失败!", "提示");
dataGridView1.ClearSelection();
}
}
private void DCselected_Click(object sender, EventArgs e)
{
delPwd DP = new delPwd();
DP.Show();
if (DP.rightYH != "1")
{
return;
}
DialogResult DR = MessageBox.Show("导出该对象的全部信息吗？", "提示：选择否则导出部分信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
//获得要导出的对象的身份证集合
List <string> listSFZ = new List <string>();
List <int> RowsIndex = new List <int>();//记录选中行的集合
//MessageBox.Show(sqlDataView.SelectedRows[1].Index.ToString());
for (int j = sqlDataView.SelectedRows.Count - 1; j >= 0; j--)
{
RowsIndex.Add(sqlDataView.SelectedRows[j].Index);
}
foreach (int item in RowsIndex)
{
try
{
listSFZ.Add(sqlDataView[7, item].Value.ToString());
}
catch
{ MessageBox.Show("请勿选择空行", "提示"); return; }
}
//for (int i = 0; i < sqlDataView.SelectedRows.Count; i++)
//{
// try
// {
// listSFZ.Add(sqlDataView[7, sqlDataView.CurrentRow.Index + i].Value.ToString());
// }
// catch
// { MessageBox.Show("请勿选择空行", "提示");return; }
//}
string path = "";
SaveFileDialog SFD = new SaveFileDialog();
SFD.Title = "选择存储地址";
SFD.Filter = "Excel文件|*.xls";
bool re = false;
if (DR == DialogResult.No)
{
SFD.FileName = DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + "_" +
DateTime.Now.Hour + "_" + DateTime.Now.Minute + "_" + DateTime.Now.Second + "_部分基本信息";
//SFD.ShowDialog();
if (SFD.ShowDialog() == DialogResult.Cancel)
{
return;
}
path = SFD.FileName;
re = saveAsExcelMode_MulRows(path, listSFZ.Count, 1, listSFZ);
}
else
{
SFD.FileName = DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + "_" +
DateTime.Now.Hour + "_" + DateTime.Now.Minute + "_" + DateTime.Now.Second + "_全部基本信息";
//SFD.ShowDialog();
if (SFD.ShowDialog() == DialogResult.Cancel)
{
return;
}
path = SFD.FileName;
re = saveAsExcelMode_MulRows(path, listSFZ.Count, 2, listSFZ);
}
if (re == true)
{
MessageBox.Show("导出成功", "提示");
sqlDataView.ClearSelection();
}
else
{
MessageBox.Show("导出失败", "提示");
sqlDataView.ClearSelection();
}
}
//设置线程
public void RunDCinfo()
{
delPwd DP = new delPwd();
DP.Show();
if (DP.rightYH != "1")
{
return;
}
DialogResult DR = MessageBox.Show("导出该对象的全部信息吗？", "提示：选择否则导出部分信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
//获得要导出的对象的身份证集合
List <string> listSFZ = new List <string>();
for (int i = 0; i < sqlDataView.SelectedRows.Count; i++)
{
listSFZ.Add(sqlDataView[7, sqlDataView.CurrentRow.Index].Value.ToString());
}
string path = "";
SaveFileDialog SFD = new SaveFileDialog();
SFD.Title = "选择存储地址";
SFD.Filter = "Excel文件|*.xls";
bool re = false;
if (DR == DialogResult.No)
{
SFD.FileName = DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + "_" +
DateTime.Now.Hour + "_" + DateTime.Now.Minute + "_" + DateTime.Now.Second + "_部分基本信息";
//SFD.ShowDialog();
if (SFD.ShowDialog() == DialogResult.Cancel)
{
return;
}
path = SFD.FileName;
re = saveAsExcelMode_MulRows(path, listSFZ.Count, 1, listSFZ);
}
else
{
SFD.FileName = DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + "_" +
DateTime.Now.Hour + "_" + DateTime.Now.Minute + "_" + DateTime.Now.Second + "_全部基本信息";
// SFD.ShowDialog();
if (SFD.ShowDialog() == DialogResult.Cancel)
{
return;
}
path = SFD.FileName;
re = saveAsExcelMode_MulRows(path, listSFZ.Count, 2, listSFZ);
}
if (re == true)
{
MessageBox.Show("导出成功", "提示");
sqlDataView.ClearSelection();
}
else
{
MessageBox.Show("导出失败", "提示");
sqlDataView.ClearSelection();
}
//持起主线程
Thread.Sleep(0);
//执行线程
mythread.Abort();
}
