public void ReadMembers() { //導入這個的時候其實順帶要導入 部門 ICrm_MemberService crm_memberService = UnityHelper.Get<ICrm_MemberService>(); //導入crm_member var filename = @"D:\members.xls"; var ext = Path.GetExtension(filename); DataSet ds = new DataSet(); if (ext == ".xls") { ds = ExcelHelper.ExcelToDS_XLS(filename, "員工"); } else if (ext == ".xlsx") { ds = ExcelHelper.ExcelToDS_XLSX(filename, "員工"); } var dt = ds.Tables[0]; var cNums = dt.Columns.Count; if (cNums != 4) throw new MsgEx("excel格式錯誤"); if (dt.Rows[0][0] == null || dt.Rows[0][0].ToString() != "登入名稱") { throw new MsgEx("excel格式錯誤"); } List<Crm_Member> memberList = new List<Crm_Member>(dt.Rows.Count - 1); List<ExcelCrmMember> excelMemberList = new List<ExcelCrmMember>(dt.Rows.Count - 1); for (int i = 0; i < dt.Rows.Count; i++) { var row = dt.Rows[i]; ExcelCrmMember excelMember = new ExcelCrmMember(); var firstRow = row[0].ToObjString().Trim(); if (StringHelper.StrToInt(firstRow, 0) == 0) { continue; } excelMember.MemberNo = row[0].ToObjString().Trim(); excelMember.Name = row[1].ToObjString().Trim(); excelMember.PositionName = row[2].ToObjString().Trim(); excelMember.DeptName = row[3].ToObjString().Trim(); excelMemberList.Add(excelMember); } ExcelMemberData excelData = new ExcelMemberData { UserId = 1, ExcelMemberList = excelMemberList, }; Console.WriteLine(crm_memberService.AddList(excelData)); }
public void ReadMembers() { //導入這個的時候其實順帶要導入 部門 ICrm_MemberService crm_memberService = UnityHelper.Get<ICrm_MemberService>(); //導入crm_member var filename = @"D:\members.xlsx"; var dt = ExcelHelper_Npoi.Import(filename); var cNums = dt.Columns.Count; if (cNums != 4) throw new MsgEx("excel格式錯誤"); List<Crm_Member> memberList = new List<Crm_Member>(dt.Rows.Count - 1); List<ExcelCrmMember> excelMemberList = new List<ExcelCrmMember>(dt.Rows.Count - 1); for (int i = 0; i < dt.Rows.Count; i++) { var row = dt.Rows[i]; ExcelCrmMember excelMember = new ExcelCrmMember(); var firstRow = row[0].ToObjString().Trim(); if (StringHelper.StrToInt(firstRow, 0) == 0) { continue; } excelMember.MemberNo = row[0].ToObjString().Trim(); excelMember.Name = row[1].ToObjString().Trim(); excelMember.PositionName = row[2].ToObjString().Trim(); excelMember.DeptName = row[3].ToObjString().Trim(); excelMemberList.Add(excelMember); } ExcelMemberData excelData = new ExcelMemberData { UserId = 1, ExcelMemberList = excelMemberList, }; Console.WriteLine(crm_memberService.AddList(excelData)); }