private void btn_CopyByIC_Click(object sender, EventArgs e) { string ICCard, Name; string mPath = this.textPath.Text; DirectoryInfo di; try { di = new DirectoryInfo(mPath); } catch (Exception err) { MessageBox.Show(err.Message); } FileInfo[] filelist = di.GetFiles("*.jpg"); foreach (FileInfo fi in filelist) { ICCard = fi.Name.Split('.')[0]; DataTable ManListInfo; OracleHelper newhelp = new OracleHelper(); string sql = @"SELECT T.NAME, T.USED_NAME, T.CREATE_DATE FROM cimc_lbr_idcard_read_trans_vie T WHERE T.USED_NAME='" + ICCard + "'"; try { ManListInfo = newhelp.GetDataTable(sql); } catch (System.Exception ex) { continue; } Name = ManListInfo.Rows[0]["Name"].ToString(); if (Name == string.Empty) { continue; } if (!Directory.Exists(mPath + "\\NAME")) { Directory.CreateDirectory(mPath + "\\NAME"); } if (File.Exists(mPath + "NAME\\" + Name + ".jpg")) { try { File.Copy(fi.Name, mPath + "NAME\\" + Name + "_" + ICCard + ".jpg", true); continue; } catch (System.Exception err) { continue; } } try { File.Copy(fi.Name, mPath + "NAME\\" + Name + ".jpg", true); } catch (System.Exception ex) { continue; } } MessageBox.Show("�������"); }
private void btn_CopyByIC_Click(object sender, EventArgs e) { string ICCard, Name; string mPath = this.textPath.Text; DirectoryInfo di; try { di = new DirectoryInfo(mPath); } catch (Exception err) { MessageBox.Show(err.Message); } FileInfo[] filelist = di.GetFiles("*.jpg"); foreach (FileInfo fi in filelist) { ICCard = fi.Name.Split('.')[0]; DataTable ManListInfo; OracleHelper newhelp = new OracleHelper(); string sql = @"SELECT T.NAME, T.USED_NAME, T.CREATE_DATE FROM cimc_lbr_idcard_read_trans_vie T WHERE T.USED_NAME='" + ICCard + "'"; try { ManListInfo = newhelp.GetDataTable(sql); } catch (System.Exception ex) { continue; } Name = ManListInfo.Rows[0]["Name"].ToString(); if (Name == string.Empty) { continue; } if (!Directory.Exists(mPath + "\\NAME")) { Directory.CreateDirectory(mPath + "\\NAME"); } if (File.Exists(mPath + "NAME\\" + Name + ".jpg")) { try { File.Copy(fi.Name, mPath + "NAME\\" + Name + "_" + ICCard + ".jpg", true); continue; } catch (System.Exception err) { continue; } } try { File.Copy(fi.Name, mPath + "NAME\\" + Name + ".jpg", true); } catch (System.Exception ex) { continue; } } MessageBox.Show("复制完毕"); }