//path 完整路徑 finame檔名 public static bool StartInsert(string path, string finame) { bool result = true; int i = 0; string line; List <EMP_DATA> empdatas = new List <EMP_DATA>(); EMP_DATA empdata = new EMP_DATA(); try { Common.WriteLog("開始切割 " + finame); FileStream fileStream = File.OpenRead(path); using (StreamReader reader = new StreamReader(fileStream, Encoding.GetEncoding(0))) { line = reader.ReadLine(); while (line != null) { line = new Regex("[\\s]+").Replace(line, " "); if (line == " " || line == "") { line = reader.ReadLine(); continue; } empdata = splitstrng(line); empdatas.Add(empdata); line = reader.ReadLine(); i++; } reader.Close(); } Common.WriteLog("新增DB"); result = InsertToSql(empdatas); Common.WriteLog(finame + "切割完成,一共 " + i + " 筆"); return(result); } catch (Exception e) { Common.WriteLog("EmpDataServices失敗"); Common.WriteLog(e.ToString()); result = false; return(result); } }
//切割字串 public static EMP_DATA splitstrng(string input) { EMP_DATA empdata = new EMP_DATA(); try { //切割符號 //string mark = ConfigurationManager.AppSettings["Mark"]; input = new Regex("[\\s]+").Replace(input, " "); //string[] sArray = Regex.Split(input, @"|"); string[] sArray = input.Split(','); empdata = new EMP_DATA { Emp_No = sArray[0], Login_Name = sArray[1], Emp_Name = sArray[2], Mail_External = sArray[3], Mail_Internal = sArray[4], Entry_Date = sArray[5], Dept_Code = sArray[6], Org_code = sArray[7], Org_NAME = sArray[8], Job_Desc_Eng = sArray[9], Job_Desc_Cht = sArray[10], Direct_Manager = sArray[11], Region = sArray[12], REGION_NAME = sArray[13], TW_sTORE_ID = sArray[14], TW_sTORE_Name = sArray[15], bu = sArray[16], bu_NAME = sArray[17], Job_code = sArray[18], bank_no = sArray[19], on_job = sArray[20], NIGHT_SHIFT = sArray[21], SPEC_TYPE = sArray[22], JOB_TITLE = sArray[23], FT_PT = sArray[24], JOB_LEVEL = sArray[25], STORE_ID = sArray[26], DEPT_ID = sArray[27], MOD_TIME = sArray[28], MOD_USER = sArray[29], MOD_PGM = sArray[30], MOD_WS = sArray[31], STORE_NAME_E = sArray[32], STORE_NAME_C = sArray[33], ID_NO = sArray[34], OUT_DATE = sArray[35], SEX = sArray[36], Birthday = sArray[37] }; return(empdata); } catch (Exception ex) { Common.WriteLog("切割失敗 " + input + " "); Common.WriteLog(ex.ToString()); return(empdata); throw; } }