private void Line_data(string sPath, string sWC) { try { string sOrder = string.Empty; string sSmt = string.Empty; FileInfo fileinfo = null; Dictionary <string, object> dicParam = new Dictionary <string, object>(); var Files = Directory.EnumerateFiles(sPath, "*.xlsx", SearchOption.TopDirectoryOnly); // MessageBox.Show(Files.ToString()); foreach (string currentFile in Files) { // MessageBox.Show(currentFile); try { string s = currentFile; //csv 파일 풀 경로 string sDate = DateTime.Now.ToString("yyyyMMddHHmmssfff"); DGView_Sheet1.Rows.Count = 0; //생성파일에서 마스터 정보만 추출 DataTable dt = Get_Excel_Data(s); //Path.GetFileName(s) //if (DGView_Sheet1.Cells[1, 1].Value.ToString() != "Module") //{ // DGView_Sheet1.DataSource = null; // return; //} if (dt.Rows[1][1].ToString() != "Module") { dt = null; } else { DGView_Sheet1.DataSource = dt; for (int i = 2; i < DGView.ActiveSheet.RowCount; i++) { dicParam = new Dictionary <string, object>(); dicParam.Add("sProcedure", "POP_SCAN_DATA_I100"); dicParam.Add("sSection", "SAMSUNG"); dicParam.Add("sFac_cd", Global.gFac); dicParam.Add("sWc_cd", Global.gWC); dicParam.Add("sEmp_id", ""); dicParam.Add("sV0", DGView_Sheet1.Cells[i, 2].Value.ToString()); dicParam.Add("sV1", DGView_Sheet1.Cells[i, 3].Value.ToString()); dicParam.Add("sV2", DGView_Sheet1.Cells[i, 4].Value.ToString()); dicParam.Add("sV3", DGView_Sheet1.Cells[i, 6].Value.ToString()); dicParam.Add("sV4", sWC + "-" + sDate); dicParam.Add("sV5", DGView_Sheet1.Cells[i, 0].Value.ToString()); dicParam.Add("sV6", DGView_Sheet1.Cells[i, 8].Value.ToString()); dicParam.Add("sV7", DGView_Sheet1.Cells[i, 9].Value.ToString()); dicParam.Add("sV8", DGView_Sheet1.Cells[i, 10].Value.ToString()); dicParam.Add("sV9", Path.GetFileName(s)); sOrder = DGView_Sheet1.Cells[i, 3].Value.ToString(); sSmt = DGView_Sheet1.Cells[i, 10].Value.ToString(); try { UseDirect.GetDataSet_N(ControlUtil.BuildConnStr(Global.gDBTP), "COM_PROCEDURE", dicParam); } catch (Exception EX) { // MessageBox.Show(EX.Message); } } //sLocal_Path = @"D:\SAMSUNG\" + @"\" + sSmt + @"\" + sOrder + @"\"; //DirectoryInfo di = new DirectoryInfo(sLocal_Path); //if (di.Exists == false) //{ // di.Create(); //} //DB에 INSERT 후 [설비 -> 서버]로 파일이동 fileinfo = new FileInfo(s); fileinfo.Delete(); //fileinfo.MoveTo(sLocal_Path + Path.GetFileName(s)); } } catch { } } } catch (Exception ex) { // MSGBOX.Show(ex.Message); } }