private void btn_CreateImage(object sender, EventArgs e) { DataTable ManListInfo; OracleHelper newhelp = new OracleHelper(); string sql = @"SELECT T.RECORD_ID, T.ID_NO,T.ID_PREFIX, T.NAME, T.USED_NAME, T.CREATE_DATE FROM cimc_lbr_idcard_read_trans_vie T WHERE TO_DATE(T.CREATE_DATE,'YYYY-MM-DD') BETWEEN TO_DATE('2013-03-22','YYYY-MM-DD') AND TO_DATE('2013-03-22','YYYY-MM-DD')"; try { ManListInfo = newhelp.GetDataTable(sql); } catch (System.Exception ex) { MessageBox.Show(ex.Message); return; } string mPath = "D:\\ICCARD_PHOTO\\2013\\03\\22\\"; for (int i = 0; i < ManListInfo.Rows.Count; i++) { string ICCard = ManListInfo.Rows[i]["USED_NAME"].ToString(); if (ICCard==string.Empty) { continue; } string filename = mPath + ICCard + ".jpg"; File.Create(filename); } MessageBox.Show("done"); }
private void btn_CopyByIC_Click(object sender, EventArgs e) { if (this.dTime_start.Value.Date > this.dTime_end.Value.Date) { MessageBox.Show("截止日期应不小于起始日期!"); return; } string StartTime = this.dTime_start.Value.ToString().Split(' ')[0]; string EndTime = this.dTime_end.Value.ToString().Split(' ')[0]; string mDate, Year, Month, Day; string RecordID, IDSuffixNum, ICCard, Name; DataTable ManListInfo; OracleHelper newhelp = new OracleHelper(); string sql = @"SELECT T.RECORD_ID, T.ID_NO,T.ID_PREFIX, T.NAME, T.USED_NAME, T.CREATE_DATE FROM cimc_lbr_idcard_read_trans_vie T WHERE TO_DATE(T.CREATE_DATE,'YYYY-MM-DD') BETWEEN TO_DATE('" + StartTime + "','YYYY-MM-DD') AND TO_DATE('" + EndTime + "','YYYY-MM-DD')"; try { ManListInfo = newhelp.GetDataTable(sql); } catch (System.Exception ex) { MessageBox.Show(ex.Message); return; } if (ManListInfo.Rows.Count == 0) { MessageBox.Show("数据库中未查到此时间段人员信息"); return; } this.dGV_infolist.DataSource = ManListInfo; for (int i = 0; i < ManListInfo.Rows.Count; i++) { RecordID = ManListInfo.Rows[i]["RECORD_ID"].ToString(); ICCard = ManListInfo.Rows[i]["USED_NAME"].ToString(); Name = ManListInfo.Rows[i]["Name"].ToString(); IDSuffixNum = ManListInfo.Rows[i]["ID_PREFIX"].ToString(); string mPath = "D:\\ICCARD_PHOTO\\"; mDate = ManListInfo.Rows[i]["CREATE_DATE"].ToString(); Year = mDate.Split('-')[0]; Month = mDate.Split('-')[1]; Day = mDate.Split('-')[2]; if (this.textPath.Text == string.Empty) { mPath += Year + "\\" + Month + "\\" + Day + "\\"; if (!Directory.Exists(mPath)) { MessageBox.Show("入职日期的路径不存在, 请手动选择或建立相应文件夹"); return; } } else { mPath = this.textPath.Text+"\\"; } if (!Directory.Exists(mPath + "NAME")) { Directory.CreateDirectory(mPath + "NAME"); } string JpgName = mPath + ICCard + ".jpg"; if (File.Exists(JpgName)) { //Name if (Name == string.Empty) { CallProce(RecordID, "0", "0", "Name Not Exists in database"); continue; } if (!Directory.Exists(mPath + "NAME")) { try { Directory.CreateDirectory(mPath + "NAME"); } catch (System.Exception ex) { CallProce(RecordID, "0", "0", "Can not create Name dir: " + mPath + "NAME" + ex.Message); continue; } } else { if (File.Exists(mPath + "NAME\\" + Name + ".jpg")) { try { File.Copy(JpgName, mPath + "NAME\\" + Name + "_" + IDSuffixNum + ".jpg", true); CallProce(RecordID, "0", "1", ICCard + ".jpg Copy Succeed"); continue; } catch (System.Exception err) { CallProce(RecordID, "1", "0", err.Message); continue; } } try { File.Copy(JpgName, mPath + "NAME\\" + Name + ".jpg", true); CallProce(RecordID, "0", "1", ICCard + ".jpg Copy Succeed"); } catch (System.Exception ex) { CallProce(RecordID, "0", "0", ex.Message); continue; } } } } MessageBox.Show("复制完毕"); }
private void btn_CopyByIC_Click(object sender, EventArgs e) { if (this.dTime_start.Value.Date > this.dTime_end.Value.Date) { MessageBox.Show("截止日期应不小于起始日期!"); return; } string StartTime = this.dTime_start.Value.ToString().Split(' ')[0]; string EndTime = this.dTime_end.Value.ToString().Split(' ')[0]; string mDate, Year, Month, Day; string RecordID, IDSuffixNum, ICCard, Name; DataTable ManListInfo; OracleHelper newhelp = new OracleHelper(); string sql = @"SELECT T.RECORD_ID, T.ID_NO,T.ID_PREFIX, T.NAME, T.USED_NAME, T.CREATE_DATE FROM cimc_lbr_idcard_read_trans_vie T WHERE TO_DATE(T.CREATE_DATE,'YYYY-MM-DD') BETWEEN TO_DATE('" + StartTime + "','YYYY-MM-DD') AND TO_DATE('" + EndTime + "','YYYY-MM-DD')"; try { ManListInfo = newhelp.GetDataTable(sql); } catch (System.Exception ex) { MessageBox.Show(ex.Message); return; } if (ManListInfo.Rows.Count == 0) { MessageBox.Show("数据库中未查到此时间段人员信息"); return; } this.dGV_infolist.DataSource = ManListInfo; for (int i = 0; i < ManListInfo.Rows.Count; i++) { RecordID = ManListInfo.Rows[i]["RECORD_ID"].ToString(); ICCard = ManListInfo.Rows[i]["USED_NAME"].ToString(); Name = ManListInfo.Rows[i]["Name"].ToString(); IDSuffixNum = ManListInfo.Rows[i]["ID_PREFIX"].ToString(); string mPath = "D:\\ICCARD_PHOTO\\"; mDate = ManListInfo.Rows[i]["CREATE_DATE"].ToString(); Year = mDate.Split('-')[0]; Month = mDate.Split('-')[1]; Day = mDate.Split('-')[2]; if (this.textPath.Text == string.Empty) { mPath += Year + "\\" + Month + "\\" + Day + "\\"; if (!Directory.Exists(mPath)) { MessageBox.Show("入职日期的路径不存在, 请手动选择或建立相应文件夹"); return; } } else { mPath = this.textPath.Text + "\\"; } if (!Directory.Exists(mPath + "NAME")) { Directory.CreateDirectory(mPath + "NAME"); } string JpgName = mPath + ICCard + ".jpg"; if (File.Exists(JpgName)) { //Name if (Name == string.Empty) { CallProce(RecordID, "0", "0", "Name Not Exists in database"); continue; } if (!Directory.Exists(mPath + "NAME")) { try { Directory.CreateDirectory(mPath + "NAME"); } catch (System.Exception ex) { CallProce(RecordID, "0", "0", "Can not create Name dir: " + mPath + "NAME" + ex.Message); continue; } } else { if (File.Exists(mPath + "NAME\\" + Name + ".jpg")) { try { File.Copy(JpgName, mPath + "NAME\\" + Name + "_" + IDSuffixNum + ".jpg", true); CallProce(RecordID, "0", "1", ICCard + ".jpg Copy Succeed"); continue; } catch (System.Exception err) { CallProce(RecordID, "1", "0", err.Message); continue; } } try { File.Copy(JpgName, mPath + "NAME\\" + Name + ".jpg", true); CallProce(RecordID, "0", "1", ICCard + ".jpg Copy Succeed"); } catch (System.Exception ex) { CallProce(RecordID, "0", "0", ex.Message); continue; } } } } MessageBox.Show("复制完毕"); }