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);
}
}
