批量导入用户和组织的功能有吗？ - 问题互助

阅读：4710 回复：8 余滨伟 8 帖子 15 跟帖 1091 积分中级榴莲加关注写私信	[综合]批量导入用户和组织的功能有吗？楼主^# 更多只看楼主倒序阅读发布于：2017-01-18 16:48 如题，有这个功能吗？如果有，有模板么？在哪里导入？
	喜欢0 最新喜欢：回复

武汉技术支持团队

40

帖子

1181

跟帖

3860

积分

论坛版主

加关注写私信

1楼^#

发布于：2017-01-22 14:06

帖内置顶 – H3BPM – 2017-02-09 09:52

有Excel导入组织架构的模板和关键代码

前台代码：

<div>

   <asp:FileUpload ID="FileUpload7" runat="server" Width="200px" /><div>


   组织信息导入
   <asp:TextBox runat="server" ID="TextBox3" Width="100px"/>
  <asp:Button ID="Button7" runat="server" Text="导入" Width="100px" OnClick="Button7_Click" />
   </div>
   </div>

后台代码：
protected void Button7_Click(object sender, EventArgs e)
   {
   IWorkbook workbook = null;
   if (FileUpload7.HasFile)
   {
   string upfile = Server.MapPath("") + "/Temp/" + FileUpload7.PostedFile.FileName;
   if (!Directory.Exists(Server.MapPath("") + "/Temp/"))
   {
   Directory.CreateDirectory(Server.MapPath("") + "/Temp/");
   }
   FileUpload7.PostedFile.SaveAs(upfile);

   string newpath = upfile;

   using (FileStream fs = File.OpenRead(newpath)) //打开myxls.xls文件
   {
   if (FileUpload7.PostedFile.FileName.IndexOf(".xlsx") > 0) // 2007版本
   workbook = new XSSFWorkbook(fs);
   else if (FileUpload7.PostedFile.FileName.IndexOf(".xls") > 0) // 2003版本
   workbook = new HSSFWorkbook(fs);

   #region 导入组织信息

   ISheet sheet = workbook.GetSheetAt(0); //读取当前表数据
   for (int j = 1; j <= sheet.LastRowNum; j++) //LastRowNum 是当前表的总行数
   {
   IRow row = sheet.GetRow(j); //读取当前行数据
   if (row != null&&row.Cells.Count>0)
   {

   #region 导入单位信息

   var code = row.Cells[0].StringCellValue.Trim();
   var parentid = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.Company.CompanyID;
   var name = row.Cells[2].StringCellValue.Trim();

   var unit = new OThinker.Organization.OrganizationUnit()
   {
   ObjectID = Guid.NewGuid().ToString(),
   Code = code,
   CompanyID = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.Company.CompanyID,
   Name = name,
   ParentID = parentid,
   // Sort Key
   SortKey = j,
   // 类型
   CategoryID = null

   };
   // 写入服务器
   var result = OThinker.Organization.HandleResult.SUCCESS;

   if (OThinker.H3.WorkSheet.AppUtility.Engine.Organization.GetUnitByCode(code) != null)
   {
   result = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.UpdateUnit(null, unit);
   }
   else
   {
   result = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.AddUnit(null, unit);

   }
   if (result != OThinker.Organization.HandleResult.SUCCESS)
   {
   OThinker.H3.WorkSheet.AppUtility.Engine.LogWriter.Write(name);

   }

   #endregion

   }
   }

   #endregion

   #region 导入用户信息
   sheet = workbook.GetSheetAt(1); //读取当前表数据
   for (int j = 1; j <= sheet.LastRowNum; j++) //LastRowNum 是当前表的总行数
   {
   IRow row = sheet.GetRow(j); //读取当前行数据
   if (row != null && row.Cells.Count > 0)
   {

   #region 导入单位信息

   var oucode = row.Cells[0].StringCellValue.Trim();

   var code = row.Cells[1].StringCellValue.Trim();
   var parentou = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.GetUnitByCode(oucode);

   var name = row.Cells[2].StringCellValue.Trim();
   var employeenumber = row.Cells[3].ToString().Trim().Replace(" ", "");
   var birthday = row.Cells[4].DateCellValue;

   var email = row.Cells[5].ToString().Trim();
   var officemobile = row.Cells[6]==null?"": row.Cells[6].ToString().Trim();

   var unit = new OThinker.Organization.User()
   {
   ObjectID = Guid.NewGuid().ToString(),
   Code = code,
   CompanyID = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.Company.CompanyID,
   Name = name,
   ParentID = parentou == null ? OThinker.H3.WorkSheet.AppUtility.Engine.Organization.Company.CompanyID :
   parentou.ObjectID,
   // Sort Key
   SortKey = j,
   // 类型
   CategoryID = null,
   EmployeeNumber = employeenumber,
   OfficePhone = officemobile,
   Email = email,
   Birthday = birthday

   };
   // 写入服务器
   OThinker.Organization.HandleResult result = OThinker.Organization.HandleResult.SUCCESS;

   if (OThinker.H3.WorkSheet.AppUtility.Engine.Organization.GetUserByEmployeeNumber(code) != null)
   {
   result = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.UpdateUnit(null, unit);
   }
   else
   {
   result = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.AddUnit(null, unit);

   }
   if (result != OThinker.Organization.HandleResult.SUCCESS)
   {
   OThinker.H3.WorkSheet.AppUtility.Engine.LogWriter.Write(name);

   }

   #endregion

   }
   }
   #endregion

   File.Delete(upfile);
   }
   }

   }

回复喜欢

H3BPM

655

帖子

2504

跟帖

46410

积分

管理员

加关注写私信

2楼^#

发布于：2017-01-18 17:03

@H3产品支持_开心 @武汉技术支持团队

10月签到活动奖励发放啦：http://bbs.h3bpm.com/read.php?tid=5377&fid=5

回复喜欢

秦始皇 167 帖子 1099 跟帖 19415 积分论坛版主加关注写私信	3楼^# 发布于：2017-01-20 16:05 进入后台管理，点开组织机构下面的同步设置。
	回复(0) 喜欢(1)

秦始皇 167 帖子 1099 跟帖 19415 积分论坛版主加关注写私信	4楼^# 发布于：2017-01-20 16:07 如果没有现成的AD用户，就做个EXCEL表导入数据到数据库。
	回复(1) 喜欢(1)

H3BPM

655

帖子

2504

跟帖

46410

积分

管理员

加关注写私信

5楼^#

发布于：2017-01-20 16:09

秦始皇：如果没有现成的AD用户，就做个EXCEL表导入数据到数据库。回到原帖

10月签到活动奖励发放啦：http://bbs.h3bpm.com/read.php?tid=5377&fid=5

回复喜欢

武汉技术支持团队 40 帖子 1181 跟帖 3860 积分论坛版主加关注写私信	6楼^# 发布于：2017-01-22 10:09 2楼的方法可行！
	回复(0) 喜欢(0)

武汉技术支持团队

40

帖子

1181

跟帖

3860

积分

论坛版主

加关注写私信

7楼^#

发布于：2017-01-22 14:06

有Excel导入组织架构的模板和关键代码

前台代码：

<div>

   <asp:FileUpload ID="FileUpload7" runat="server" Width="200px" /><div>


   组织信息导入
   <asp:TextBox runat="server" ID="TextBox3" Width="100px"/>
  <asp:Button ID="Button7" runat="server" Text="导入" Width="100px" OnClick="Button7_Click" />
   </div>
   </div>

后台代码：
protected void Button7_Click(object sender, EventArgs e)
   {
   IWorkbook workbook = null;
   if (FileUpload7.HasFile)
   {
   string upfile = Server.MapPath("") + "/Temp/" + FileUpload7.PostedFile.FileName;
   if (!Directory.Exists(Server.MapPath("") + "/Temp/"))
   {
   Directory.CreateDirectory(Server.MapPath("") + "/Temp/");
   }
   FileUpload7.PostedFile.SaveAs(upfile);

   string newpath = upfile;

   using (FileStream fs = File.OpenRead(newpath)) //打开myxls.xls文件
   {
   if (FileUpload7.PostedFile.FileName.IndexOf(".xlsx") > 0) // 2007版本
   workbook = new XSSFWorkbook(fs);
   else if (FileUpload7.PostedFile.FileName.IndexOf(".xls") > 0) // 2003版本
   workbook = new HSSFWorkbook(fs);

   #region 导入组织信息

   ISheet sheet = workbook.GetSheetAt(0); //读取当前表数据
   for (int j = 1; j <= sheet.LastRowNum; j++) //LastRowNum 是当前表的总行数
   {
   IRow row = sheet.GetRow(j); //读取当前行数据
   if (row != null&&row.Cells.Count>0)
   {

   #region 导入单位信息

   var code = row.Cells[0].StringCellValue.Trim();
   var parentid = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.Company.CompanyID;
   var name = row.Cells[2].StringCellValue.Trim();

   var unit = new OThinker.Organization.OrganizationUnit()
   {
   ObjectID = Guid.NewGuid().ToString(),
   Code = code,
   CompanyID = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.Company.CompanyID,
   Name = name,
   ParentID = parentid,
   // Sort Key
   SortKey = j,
   // 类型
   CategoryID = null

   };
   // 写入服务器
   var result = OThinker.Organization.HandleResult.SUCCESS;

   if (OThinker.H3.WorkSheet.AppUtility.Engine.Organization.GetUnitByCode(code) != null)
   {
   result = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.UpdateUnit(null, unit);
   }
   else
   {
   result = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.AddUnit(null, unit);

   }
   if (result != OThinker.Organization.HandleResult.SUCCESS)
   {
   OThinker.H3.WorkSheet.AppUtility.Engine.LogWriter.Write(name);

   }

   #endregion

   }
   }

   #endregion

   #region 导入用户信息
   sheet = workbook.GetSheetAt(1); //读取当前表数据
   for (int j = 1; j <= sheet.LastRowNum; j++) //LastRowNum 是当前表的总行数
   {
   IRow row = sheet.GetRow(j); //读取当前行数据
   if (row != null && row.Cells.Count > 0)
   {

   #region 导入单位信息

   var oucode = row.Cells[0].StringCellValue.Trim();

   var code = row.Cells[1].StringCellValue.Trim();
   var parentou = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.GetUnitByCode(oucode);

   var name = row.Cells[2].StringCellValue.Trim();
   var employeenumber = row.Cells[3].ToString().Trim().Replace(" ", "");
   var birthday = row.Cells[4].DateCellValue;

   var email = row.Cells[5].ToString().Trim();
   var officemobile = row.Cells[6]==null?"": row.Cells[6].ToString().Trim();

   var unit = new OThinker.Organization.User()
   {
   ObjectID = Guid.NewGuid().ToString(),
   Code = code,
   CompanyID = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.Company.CompanyID,
   Name = name,
   ParentID = parentou == null ? OThinker.H3.WorkSheet.AppUtility.Engine.Organization.Company.CompanyID :
   parentou.ObjectID,
   // Sort Key
   SortKey = j,
   // 类型
   CategoryID = null,
   EmployeeNumber = employeenumber,
   OfficePhone = officemobile,
   Email = email,
   Birthday = birthday

   };
   // 写入服务器
   OThinker.Organization.HandleResult result = OThinker.Organization.HandleResult.SUCCESS;

   if (OThinker.H3.WorkSheet.AppUtility.Engine.Organization.GetUserByEmployeeNumber(code) != null)
   {
   result = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.UpdateUnit(null, unit);
   }
   else
   {
   result = OThinker.H3.WorkSheet.AppUtility.Engine.Organization.AddUnit(null, unit);

   }
   if (result != OThinker.Organization.HandleResult.SUCCESS)
   {
   OThinker.H3.WorkSheet.AppUtility.Engine.LogWriter.Write(name);

   }

   #endregion

   }
   }
   #endregion

   File.Delete(upfile);
   }
   }

   }

回复喜欢

武汉技术支持团队 40 帖子 1181 跟帖 3860 积分论坛版主加关注写私信	8楼^# 发布于：2017-01-22 14:10 Excel整理模板图片：QQ截图20170122141110.png
	回复(1) 喜欢(0)

东门之菀 9 帖子 47 跟帖 1438 积分黄金榴莲加关注写私信	9楼^# 发布于：2018-05-27 08:35 武汉技术支持团队：Excel整理模板回到原帖请问下，我是小白，关键代码有了要怎么弄，完全不会啊，谢谢
	回复(0) 喜欢(0)

您需要登录后才可以回帖，登录或者注册

[综合]批量导入用户和组织的功能有吗 ？

最新喜欢：

[综合]批量导入用户和组织的功能有吗？