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