public int ImportStaff(System.Data.IDataReader dataReader, BaseStaffManager staffManager, BaseUserExpressManager sTAFF_EXPRESSManager, BaseUserManager userManager, BaseUserLogOnManager userLogOnManager)
{
int result = 0;
/*
* BaseStaffEntity staffEntity = staffManager.GetObject(dataReader["Id"].ToString());
* if (staffEntity == null)
* {
* staffEntity = new BaseStaffEntity();
* }
* staffEntity.Id = int.Parse(dataReader["Id"].ToString());
* staffEntity.Code = dataReader["EMPLOYEE_CODE"].ToString();
* staffEntity.RealName = dataReader["EMPLOYEE_NAME"].ToString();
* staffEntity.Telephone = dataReader["PHONE"].ToString();
* staffEntity.HomeAddress = dataReader["ADDRESS"].ToString();
* staffEntity.IDCard = dataReader["ID_CARD"].ToString();
*
* // staffEntity.CompanyId = dataReader["OWNER_SITE"].ToString();
* staffEntity.CompanyName = dataReader["OWNER_SITE"].ToString();
* // staffEntity.DepartmentId = dataReader["DEPT_NAME"].ToString();
* staffEntity.DepartmentName = dataReader["DEPT_NAME"].ToString();
* // staffEntity.WorkgroupId = dataReader["GROUP_NAME"].ToString();
* staffEntity.WorkgroupName = dataReader["GROUP_NAME"].ToString();
*
* System.Console.WriteLine("ImportK8Staff:" + staffEntity.Id + ":" + staffEntity.RealName);
* // 02：可以把读取到的数据能写入到用户中心的。
* result = staffManager.UpdateObject(staffEntity);
* if (result == 0)
* {
* staffManager.AddObject(staffEntity);
* }
*/
/*
* BaseUserExpressEntity sTAFF_EXPRESSEntity = sTAFF_EXPRESSManager.GetObject(dataReader["Id"].ToString());
* if (sTAFF_EXPRESSEntity == null)
* {
* sTAFF_EXPRESSEntity = new BaseUserExpressEntity();
* }
* sTAFF_EXPRESSEntity.Id = int.Parse(dataReader["Id"].ToString());
* sTAFF_EXPRESSEntity.OWNER_RANGE = dataReader["OWNER_RANGE"].ToString();
* Decimal tRANSFER_ADD_FEE = 0;
* if (!string.IsNullOrEmpty(dataReader["TRANSFER_ADD_FEE"].ToString()) && ValidateUtil.IsDouble(dataReader["TRANSFER_ADD_FEE"].ToString()))
* {
* tRANSFER_ADD_FEE = Decimal.Parse(dataReader["TRANSFER_ADD_FEE"].ToString());
* }
* sTAFF_EXPRESSEntity.TRANSFER_ADD_FEE = tRANSFER_ADD_FEE;
* Decimal dISPATCH_ADD_FEE = 0;
* if (!string.IsNullOrEmpty(dataReader["DISPATCH__ADD_FEE"].ToString()) && ValidateUtil.IsDouble(dataReader["DISPATCH__ADD_FEE"].ToString()))
* {
* dISPATCH_ADD_FEE = Decimal.Parse(dataReader["DISPATCH__ADD_FEE"].ToString());
* }
* sTAFF_EXPRESSEntity.DISPATCH_ADD_FEE = dISPATCH_ADD_FEE;
*
* System.Console.WriteLine("ImportK8Staffexpress:" + staffEntity.Id + ":" + staffEntity.RealName);
* // 02：可以把读取到的数据能写入到用户中心的。
* result = sTAFF_EXPRESSManager.Update(sTAFF_EXPRESSEntity);
* if (result == 0)
* {
* sTAFF_EXPRESSManager.Add(sTAFF_EXPRESSEntity);
* }
*/
BaseUserEntity userEntity = new BaseUserEntity();
userEntity.Id = dataReader["ID"].ToString();
userEntity.UserFrom = "PDA";
userEntity.Code = dataReader["EMPLOYEE_CODE"].ToString();
userEntity.UserName = dataReader["EMPLOYEE_NAME"].ToString();
userEntity.RealName = dataReader["REAL_NAME"].ToString();
userEntity.Description = dataReader["PHONE"].ToString();
userEntity.CompanyName = dataReader["OWNER_SITE"].ToString();
if (string.IsNullOrEmpty(userEntity.CompanyId))
{
userEntity.CompanyId = BaseOrganizeManager.GetObjectByNameByCache(userEntity.CompanyName).Id.ToString();
if (string.IsNullOrEmpty(userEntity.CompanyId))
{
System.Console.WriteLine("无CompanyId " + userEntity.Id + ":" + userEntity.UserName + ":" + userEntity.RealName);
return(0);
}
}
userEntity.DepartmentName = dataReader["DEPT_NAME"].ToString();
userEntity.WorkgroupName = dataReader["GROUP_NAME"].ToString();
userEntity.HomeAddress = dataReader["ADDRESS"].ToString();
userEntity.IDCard = dataReader["ID_CARD"].ToString();
if (!string.IsNullOrEmpty(dataReader["cardnum"].ToString()))
{
userEntity.IDCard = dataReader["cardnum"].ToString();
}
userEntity.Signature = dataReader["EMPLOYEE_TYPE"].ToString();
userEntity.SortCode = int.Parse(dataReader["ID"].ToString());
if (!userEntity.ModifiedOn.HasValue)
{
userEntity.ModifiedOn = DateTime.Parse(dataReader["UPDATETIME"].ToString());
}
else
{
if (userEntity.ModifiedOn.Value < DateTime.Parse(dataReader["UPDATETIME"].ToString()))
{
userEntity.ModifiedOn = DateTime.Parse(dataReader["UPDATETIME"].ToString());
}
}
// 修改日期需要同步
// result = userManager.UpdateObject(userEntity);
if (result == 0)
{
userManager.AddObject(userEntity);
BaseUserContactEntity userContactEntity = new BaseUserContactEntity();
userContactEntity.Id = dataReader["ID"].ToString();
userContactEntity.Telephone = dataReader["PHONE"].ToString();
new BaseUserContactManager().AddObject(userContactEntity);
BaseUserLogOnEntity userLogOnEntity = new BaseUserLogOnEntity();
userLogOnEntity.Id = dataReader["ID"].ToString();
userLogOnEntity.UserPassword = dataReader["BAR_PASSWORD"].ToString();
userLogOnManager.AddObject(userLogOnEntity);
}
// 处理角色
/*
* string roleName = dataReader["EMPLOYEE_TYPE"].ToString();
* // 看是否在这个角色里，若没有增加上去。
* userManager.AddToRole("PDA", userEntity.Id, roleName);
*
* // 添加用户密码表
* BaseUserLogOnEntity userLogOnEntity = userLogOnManager.GetObject(userEntity.Id);
* if (userLogOnEntity == null)
* {
* userLogOnEntity = new BaseUserLogOnEntity();
* userLogOnEntity.Id = userEntity.Id;
* userLogOnEntity.UserPassword = dataReader["BAR_PASSWORD"].ToString();
* //userLogOnEntity.Salt = dataReader["SALT"].ToString();
* //if (!string.IsNullOrEmpty(dataReader["CHANGEPASSWORDDATE"].ToString()))
* //{
* // userLogOnEntity.ChangePasswordDate = DateTime.Parse(dataReader["CHANGEPASSWORDDATE"].ToString());
* //}
* userLogOnManager.AddObject(userLogOnEntity);
* }
* else
* {
* userLogOnEntity.Id = userEntity.Id;
* userLogOnEntity.UserPassword = dataReader["BAR_PASSWORD"].ToString();
* //userLogOnEntity.Salt = dataReader["SALT"].ToString();
* //if (!string.IsNullOrEmpty(dataReader["CHANGEPASSWORDDATE"].ToString()))
* //{
* // userLogOnEntity.ChangePasswordDate = DateTime.Parse(dataReader["CHANGEPASSWORDDATE"].ToString());
* //}
* result = userLogOnManager.UpdateObject(userLogOnEntity);
* }
*/
return(result);
}
/// <summary>
/// 导入K8系统用户账户
/// </summary>
/// <param name="connectionString">数据库连接</param>
/// <param name="conditional">条件，不需要同步所有的数据</param>
/// <returns></returns>
public int Synchronous(string connectionString = null, string conditional = null)
{
int result = 0;
if (string.IsNullOrEmpty(connectionString))
{
connectionString = ConfigurationHelper.AppSettings("K8Connection", BaseSystemInfo.EncryptDbConnection);
}
if (!string.IsNullOrEmpty(connectionString))
{
// 01：可以从k8里读取公司、用户、密码的。
IDbHelper dbHelper = DbHelperFactory.GetHelper(CurrentDbType.Oracle, connectionString);
string commandText = string.Empty;
BaseStaffManager staffManager = new BaseStaffManager(this.UserInfo);
if (string.IsNullOrEmpty(conditional))
{
// 不不存在的用户删除掉tab_user是远程试图
/*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 10000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 10000 )";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 20000 AND id >= 10000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id <20000 AND id >= 10000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 30000 AND id >= 20000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 30000 AND id >= 20000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 40000 AND id >= 30000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 40000 AND id >= 30000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 50000 AND id >= 40000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 50000 AND id >= 40000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 60000 AND id >= 50000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 60000 AND id >= 50000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 70000 AND id >= 60000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 70000 AND id >= 60000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 80000 AND id >= 70000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 80000 AND id >= 70000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 90000 AND id >= 80000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 90000 AND id >= 80000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 100000 AND id >= 90000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 100000 AND id >= 90000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 110000 AND id >= 100000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 110000 AND id >= 100000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 120000 AND id >= 110000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 120000 AND id >= 110000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 130000 AND id >= 120000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 130000 AND id >= 120000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 200000 AND id >= 130000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 200000 AND id >= 130000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 300000 AND id >= 200000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 300000 AND id >= 200000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 400000 AND id >= 300000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 400000 AND id >= 300000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 600000 AND id >= 400000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 600000 AND id >= 400000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 800000 AND id >= 600000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 800000 AND id >= 600000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*
* commandText = "DELETE FROM " + BaseStaffEntity.TableName + " WHERE id < 1000000 AND id >= 800000 AND id NOT IN (SELECT id FROM TAB_EMPLOYEE WHERE id < 1000000 AND id >= 800000)";
* staffManager.DbHelper.ExecuteNonQuery(commandText);
* System.Console.WriteLine(commandText);
*/
}
// 01：可以从k8里读取公司、用户、密码的。
commandText = "SELECT * FROM TAB_EMPLOYEE WHERE 1=1 ";
if (!string.IsNullOrEmpty(conditional))
{
commandText += conditional + " ORDER BY UPDATETIME DESC";
}
else
{
// 只更新今天有变化的数据就可以了
// commandText += " AND TO_CHAR(SYSDATE, 'yy-mm-dd') = TO_CHAR(UPDATETIME, 'yy-mm-dd') ";
}
System.Console.WriteLine(commandText);
BaseUserExpressManager sTAFF_EXPRESSManager = new BaseUserExpressManager(this.UserInfo);
BaseUserManager userManager = new BaseUserManager(this.UserInfo);
BaseUserLogOnManager userLogOnManager = new BaseUserLogOnManager(this.UserInfo);
using (IDataReader dataReader = DbHelper.ExecuteReader(commandText))
{
while (dataReader.Read())
{
result += ImportStaff(dataReader, staffManager, sTAFF_EXPRESSManager, userManager, userLogOnManager);
}
dataReader.Close();
}
// 设置用户的公司主键，有时候不需要同步所有的账户，只同步增量账户
// 设置用户的公司主键
// commandText = @"UPDATE basestaff SET companyid = (SELECT MAX(Id) FROM baseorganize WHERE baseorganize.fullname = basestaff.companyname AND baseorganize.Id < 1000000) WHERE companyId IS NULL OR companyId = ''";
// 公司名称重复的数据需要找出来
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
}
return(result);
}
/// <summary>
/// 更新K8员工后，同步到中天baseuser表
/// 传入dbhelper 方法调用使用事务 避免部分同步成功
/// </summary>
/// <param name="entity"></param>
/// <param name="userCenterDbHelper"></param>
public void AfterUpdateEmployee(TAB_EMPLOYEEEntity entity, IDbHelper userCenterDbHelper)
{
int count = 0;
BaseUserEntity userEntity = new BaseUserEntity();
userEntity.Id = entity.ID.ToString();
userEntity.UserFrom = "PDA";
userEntity.UserPassword = entity.BAR_PASSWORD;
userEntity.Code = entity.EMPLOYEE_CODE;
userEntity.UserName = entity.EMPLOYEE_NAME;
userEntity.RealName = entity.EMPLOYEE_NAME;
userEntity.Description = entity.PHONE;
userEntity.CompanyName = entity.OWNER_SITE;
// 1、更新baseuser中的所属网点
if (string.IsNullOrEmpty(userEntity.CompanyId))
{
BaseOrganizeEntity organizeEntity = new BaseOrganizeManager(userCenterDbHelper).GetObjectByName(userEntity.CompanyName);
if (organizeEntity != null)
{
userEntity.CompanyId = organizeEntity.Id.ToString();
}
}
userEntity.DepartmentName = entity.DEPT_NAME;
userEntity.WorkgroupName = entity.GROUP_NAME;
userEntity.HomeAddress = entity.ADDRESS;
userEntity.IDCard = entity.ID_CARD;
// 2、员工操作类型，按签名处理
userEntity.Signature = entity.EMPLOYEE_TYPE;
userEntity.SortCode = int.Parse(entity.ID.ToString());
userEntity.ModifiedOn = entity.UPDATETIME;
BaseUserManager userManager = new BaseUserManager(userCenterDbHelper, Utilities.UserInfo);
// if (!userManager.Exists(userEntity.Id))
count = userManager.UpdateObject(userEntity);
if (count == 0)
{
userManager.AddObject(userEntity);
}
// 3、如果有电话，同步到baseusercontact中
BaseUserContactEntity userContactEntity = new BaseUserContactEntity();
userContactEntity.Id = entity.ID.ToString();
userContactEntity.Telephone = entity.PHONE;
BaseUserContactManager userContactManager = new DotNet.Business.BaseUserContactManager(userCenterDbHelper, Utilities.UserInfo);
count = userContactManager.UpdateObject(userContactEntity);
if (count == 0)
{
userContactManager.AddObject(userContactEntity);
}
// 4、新增员工时，同步baseuser员工的密码
BaseUserLogOnEntity userLogOnEntity = new BaseUserLogOnEntity();
userLogOnEntity.Id = entity.ID.ToString();
userLogOnEntity.UserPassword = entity.BAR_PASSWORD;
BaseUserLogOnManager userLogOnManager = new BaseUserLogOnManager(userCenterDbHelper, Utilities.UserInfo);
count = userLogOnManager.UpdateObject(userLogOnEntity);
if (count == 0)
{
userLogOnManager.AddObject(userLogOnEntity);
}
// 5、中转附加费和派件附加费，再确认
BaseUserExpressManager userExpressManager = new BaseUserExpressManager(userCenterDbHelper, Utilities.UserInfo);
BaseUserExpressEntity userExpressEntity = new BaseUserExpressEntity();
userExpressEntity.Id = entity.ID;
userExpressEntity.DISPATCH_ADD_FEE = entity.DISPATCH__ADD_FEE;
userExpressEntity.TRANSFER_ADD_FEE = entity.TRANSFER_ADD_FEE;
userExpressEntity.OWNER_RANGE = entity.OWNER_RANGE;
count = userExpressManager.UpdateObject(userExpressEntity);
if (count == 0)
{
userExpressManager.Add(userExpressEntity, false);
}
}
