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