protected void btnInportDepts_Click(object sender, EventArgs e)
{
ApolloOaDataContext ctx = new ApolloOaDataContext(ConfigurationManager.ConnectionStrings["SqlConnectionString"].ConnectionString);
var depts = ctx.ExecuteQuery<_tempClass>(@"select a.Text Text1,b.Text Text2 from Depts a,Depts b where a.Pid=b.Id;");
try
{
foreach (_tempClass v in depts)
{
DeptManagerObj.AddDept(v.Text1, v.Text2); //添加部门,如果用户没有上级部门，txtParentDept不需填写，为空即可
}
}
catch (COMException ex)
{
Response.Write(ex.Message);
}
Response.Write("部门导入成功");
}
protected void btnInportUsers_Click(object sender, EventArgs e)
{
ApolloOaDataContext ctx = new ApolloOaDataContext(ConfigurationManager.ConnectionStrings["SqlConnectionString"].ConnectionString);
var depts = ctx.ExecuteQuery<_tempClass>(@"with t as(select EmpId,MIN(PosId) posId from EmpDepPositions group by EmpId)
select e.JobNo Text1,d.Text Text2 from EmpDepPositions a,t,Depts d,Employee e
where a.EmpId=t.EmpId and a.PosId=t.posId and a.DeptId=d.Id and a.EmpId=e.Id and e.LeaveDate is null;");
foreach (_tempClass v in depts)
{
string jobNo = v.Text1.ToUpper();
try
{
UserManagerObj.AddUser(jobNo, 0);
UserManagerObj.SetUserPwd(jobNo, "123456");
DeptManagerObj.AddUserToDept(jobNo, null, v.Text2, false); //添加用户进某个部门,如果用户没有所属部门，源部门名为null即可。
}
catch (COMException ex)
{
Response.Write(ex.Message + "_" + jobNo + "_" + v.Text2 + "<br/>");
}
}
Response.Write("用户导入成功");
}
