public virtual void BUAUserSyncToOutside(string ids)
{
SMC_UserDao userDao = new SMC_UserDao(AppConfig.statisticDBKey);
string[] idlist = ids.Split(",".ToCharArray());
List<SMC_User> usersToBeSynced = new List<SMC_User>();
foreach (string uid in idlist)
{
if (String.IsNullOrEmpty(uid))
{
continue;
}
SMC_User u = userDao.GetUser(uid);
if (u != null)
{
usersToBeSynced.Add(u);
}
}
if (usersToBeSynced == null || usersToBeSynced.Count == 0)
return;
SmartBox.Console.Service.ApplicationCenterWS.WebService ws = new Service.ApplicationCenterWS.WebService();
Service.ApplicationCenterWS.SMC_User[] users = new Service.ApplicationCenterWS.SMC_User[usersToBeSynced.Count];
int i = 0;
foreach (SMC_User user in usersToBeSynced)
{
users[i] = new Service.ApplicationCenterWS.SMC_User();
users[i].U_CREATEDDATE = user.U_CREATEDDATE;
users[i].U_ID = user.U_ID;
users[i].U_NAME = user.U_NAME;
users[i].U_PASSWORD = user.U_PASSWORD;
users[i].U_UID = user.U_UID;
users[i].U_UNITCODE = user.U_UNITCODE;
++i;
}
bool result = ws.SMC_UserSync(users);
SMC_BUAUserSyncToOutsideDao buaUserSyncOutDao = new SMC_BUAUserSyncToOutsideDao(AppConfig.statisticDBKey);
int batNo = buaUserSyncOutDao.GetMaxBatNo() + 1;
foreach (SMC_User user in usersToBeSynced)
{
SMC_BUAUserSyncToOutside log = new SMC_BUAUserSyncToOutside();
log.description = "同步" + (result ? "成功" : "失败");
log.sync_bat_no = batNo;
log.sync_status = result;
log.sync_time = DateTime.Now;
log.sync_user_name = "";
log.sync_user_uid = "";
log.user_name = user.U_NAME;
log.user_uid = user.U_UID;
try
{
int maxId = buaUserSyncOutDao.GetMaxId() + 1;
log.buso_id = maxId;
buaUserSyncOutDao.Insert(log);
buaUserSyncOutDao.UpdateMaxId();
}
catch
{
}
}
}
public virtual void BUAUserSyncToInside(string ids, Hashtable result)
{
ServiceFactory factory = Beyondbit.BUA.Client.ServiceFactory.Instance();
IUserService us = factory.GetUserService();
IOrgService os = factory.GetOrgService();
SMC_UserDao userDao = new SMC_UserDao(AppConfig.statisticDBKey);
SMC_BUAUserSyncToInsideDao buaSyncInsideDao = new SMC_BUAUserSyncToInsideDao(AppConfig.statisticDBKey);
GlobalParamDao globalParamDao = new GlobalParamDao(AppConfig.statisticDBKey);
GlobalParam p = globalParamDao.GetGlobalParam("user_default_status");
int batNo = 0;
try
{
batNo = buaSyncInsideDao.GetMaxBatNo();
}
catch (Exception e)
{
}
batNo += 1;
string[] idlist = ids.Split(",".ToCharArray());
foreach (string uid in idlist)
{
if (String.IsNullOrEmpty(uid))
{
continue;
}
Beyondbit.BUA.Client.User _u = null;
try
{
_u = us.GetUserInfo(uid);
}
catch (Exception ex)
{
result["Msg"] += uid + ex.Message;
continue;
}
SMC_BUAUserSyncToInside log = new SMC_BUAUserSyncToInside();
log.sync_bat_no = batNo;
try
{
log.sync_status = true;
log.sync_time = DateTime.Now;
log.sync_user_name = "";
log.sync_user_uid = "";
log.user_name = _u.UserFullName;
log.user_uid = _u.UserUid;
log.description = "同步成功";
log.busi_id = buaSyncInsideDao.GetMaxId() + 1;
SMC_UnitDao unitDao = new SMC_UnitDao(AppConfig.statisticDBKey);
SMC_User u = null;
u = userDao.GetUser(_u.UserUid);
if (u == null)
{
u = new SMC_User();
u.U_NAME = _u.UserFullName;
u.U_PASSWORD = _u.UserPassword;
u.U_UID = _u.UserUid;
int id = userDao.GetMaxId() + 1;
u.U_ID = id;
string unitCode = os.GetUnitCode(ObjectType.User, u.U_UID);
Org unitOrg = os.GetOrgBaseInfo(ObjectType.Org, unitCode);
u.U_UNITCODE = unitCode;
//List<KeyValuePair<string, string>> pars = new List<KeyValuePair<string,string>>();
//pars.Add(new KeyValuePair<string, string>("unit_id",unitCode));
SMC_Unit unit = unitDao.Get(unitCode);
if (unit == null)
{
unit = new SMC_Unit();
unit.Unit_ID = unitCode;
unit.Unit_Name = unitOrg.OrgName;
unit.Unit_Sequence = 0;
unit.Unit_UpdateTime = DateTime.Now;
unit.Unit_CreatedTime = DateTime.Now;
unit.Upper_Unit_ID = "";
unit.Unit_Path = unitCode;
unitDao.Insert(unit);
}
u.u_unitname = unitOrg.OrgName;
u.U_CREATEDDATE = DateTime.Now;
u.u_enable_status = p.ConfigValue == "1" ? UserEnabledStatus.Enabled : UserEnabledStatus.UnAuthed;
u.u_auth_submit_time = DateTime.Now;
u.u_need_sync = false;
userDao.Insert(u);
userDao.UpdateMaxId();
}
else
{
u.U_NAME = _u.UserFullName;
u.U_PASSWORD = _u.UserPassword;
u.U_CREATEDDATE = DateTime.Now;
string unitCode = os.GetUnitCode(ObjectType.User, u.U_UID);
Org unitOrg = os.GetOrgBaseInfo(ObjectType.Org, unitCode);
//List<KeyValuePair<string, string>> pars = new List<KeyValuePair<string, string>>();
//pars.Add(new KeyValuePair<string, string>("unit_id", unitCode));
SMC_Unit unit = unitDao.Get(unitCode);
if (unit == null)
{
unit = new SMC_Unit();
unit.Unit_ID = unitCode;
unit.Unit_Name = unitOrg.OrgName;
unit.Unit_Sequence = 0;
unit.Unit_UpdateTime = DateTime.Now;
unit.Unit_CreatedTime = DateTime.Now;
unit.Upper_Unit_ID = "";
unit.Unit_Path = unitCode;
unitDao.Insert(unit);
}
u.u_unitname = unitOrg.OrgName;
u.U_UNITCODE = unitCode;
u.u_enable_status = p.ConfigValue == "1" ? UserEnabledStatus.Enabled : UserEnabledStatus.UnAuthed;
u.u_auth_submit_time = DateTime.Now;
u.u_need_sync = false;
u.u_update_time = DateTime.Now;
userDao.Update(u);
}
}
catch (Exception ex)
{
log.sync_status = false;
log.description = "同步失败,原因可能是:" + ex.Message + "。\r\nStackTrace:\r\n" + ex.StackTrace;
if (result != null)
{
result["IsSuccess"] = false;
result["Msg"] += log.description;
}
}
try
{
buaSyncInsideDao.Insert(log);
buaSyncInsideDao.UpdateMaxId();
}
catch (Exception ex)
{
}
}
}
public virtual void BUAUserSyncToOutside(string ids)
{
SMC_UserDao userDao = new SMC_UserDao(AppConfig.statisticDBKey);
string[] idlist = ids.Split(",".ToCharArray());
List <SMC_User> usersToBeSynced = new List <SMC_User>();
foreach (string uid in idlist)
{
if (String.IsNullOrEmpty(uid))
{
continue;
}
SMC_User u = userDao.GetUser(uid);
if (u != null)
{
usersToBeSynced.Add(u);
}
}
if (usersToBeSynced == null || usersToBeSynced.Count == 0)
{
return;
}
SmartBox.Console.Service.ApplicationCenterWS.WebService ws = new Service.ApplicationCenterWS.WebService();
Service.ApplicationCenterWS.SMC_User[] users = new Service.ApplicationCenterWS.SMC_User[usersToBeSynced.Count];
int i = 0;
foreach (SMC_User user in usersToBeSynced)
{
users[i] = new Service.ApplicationCenterWS.SMC_User();
users[i].U_CREATEDDATE = user.U_CREATEDDATE;
users[i].U_ID = user.U_ID;
users[i].U_NAME = user.U_NAME;
users[i].U_PASSWORD = user.U_PASSWORD;
users[i].U_UID = user.U_UID;
users[i].U_UNITCODE = user.U_UNITCODE;
++i;
}
bool result = ws.SMC_UserSync(users);
SMC_BUAUserSyncToOutsideDao buaUserSyncOutDao = new SMC_BUAUserSyncToOutsideDao(AppConfig.statisticDBKey);
int batNo = buaUserSyncOutDao.GetMaxBatNo() + 1;
foreach (SMC_User user in usersToBeSynced)
{
SMC_BUAUserSyncToOutside log = new SMC_BUAUserSyncToOutside();
log.description = "同步" + (result ? "成功" : "失败");
log.sync_bat_no = batNo;
log.sync_status = result;
log.sync_time = DateTime.Now;
log.sync_user_name = "";
log.sync_user_uid = "";
log.user_name = user.U_NAME;
log.user_uid = user.U_UID;
try
{
int maxId = buaUserSyncOutDao.GetMaxId() + 1;
log.buso_id = maxId;
buaUserSyncOutDao.Insert(log);
buaUserSyncOutDao.UpdateMaxId();
}
catch
{
}
}
}
public virtual void BUAUserSyncToInside()
{
try
{
ServiceFactory factory = Beyondbit.BUA.Client.ServiceFactory.Instance();
SMC_UserDao userDao = new SMC_UserDao(AppConfig.statisticDBKey);
IUserService us = factory.GetUserService();
IOrgService os = factory.GetOrgService();
Org topOrg = os.GetTopOrg();
Beyondbit.BUA.Client.User[] users = us.QueryUsersByObjectCode(ObjectType.Org, topOrg.OrgCode);
string orgCode = topOrg.OrgCode;
List<Org> orgs = new List<Org>();
GetOrgs(os, orgCode, orgs);
if (orgs.Count > 0)
{
foreach (Org o in orgs)
{
Beyondbit.BUA.Client.User[] user = GetUsers(us, o.OrgCode);
if (users != null && users.Length > 0)
{
foreach (Beyondbit.BUA.Client.User _u in users)
{
SMC_User u = null;
u = userDao.GetUser(_u.UserUid);
if (u == null)
{
u = new SMC_User();
u.U_NAME = _u.UserFullName;
u.U_PASSWORD = _u.UserPassword;
u.U_UID = _u.UserUid;
int id = userDao.GetMaxId() + 1;
u.U_ID = id;
string unitCode = os.GetUnitCode(ObjectType.User, u.U_UID);
Org unitOrg = os.GetOrgBaseInfo(ObjectType.Org, unitCode);
u.u_unitname = unitOrg.OrgName;
u.U_UNITCODE = unitCode;
u.u_enable_status = UserEnabledStatus.UnAuthed;
u.u_auth_submit_time = DateTime.Now;
userDao.Insert(u);
userDao.UpdateMaxId();
}
else
{
u.U_NAME = _u.UserFullName;
u.U_PASSWORD = _u.UserPassword;
string unitCode = os.GetUnitCode(ObjectType.User, u.U_UID);
Org unitOrg = os.GetOrgBaseInfo(ObjectType.Org, unitCode);
u.u_unitname = unitOrg.OrgName;
u.U_UNITCODE = unitCode;
u.u_enable_status = UserEnabledStatus.UnAuthed;
u.u_auth_submit_time = DateTime.Now;
userDao.Update(u);
}
}
}
}
}
}
catch (DalException ex)
{
throw new BOException("同步BUA用户出错", ex);
}
}
public virtual void BUAUserSyncToInside()
{
try
{
ServiceFactory factory = Beyondbit.BUA.Client.ServiceFactory.Instance();
SMC_UserDao userDao = new SMC_UserDao(AppConfig.statisticDBKey);
IUserService us = factory.GetUserService();
IOrgService os = factory.GetOrgService();
Org topOrg = os.GetTopOrg();
Beyondbit.BUA.Client.User[] users = us.QueryUsersByObjectCode(ObjectType.Org, topOrg.OrgCode);
string orgCode = topOrg.OrgCode;
List <Org> orgs = new List <Org>();
GetOrgs(os, orgCode, orgs);
if (orgs.Count > 0)
{
foreach (Org o in orgs)
{
Beyondbit.BUA.Client.User[] user = GetUsers(us, o.OrgCode);
if (users != null && users.Length > 0)
{
foreach (Beyondbit.BUA.Client.User _u in users)
{
SMC_User u = null;
u = userDao.GetUser(_u.UserUid);
if (u == null)
{
u = new SMC_User();
u.U_NAME = _u.UserFullName;
u.U_PASSWORD = _u.UserPassword;
u.U_UID = _u.UserUid;
int id = userDao.GetMaxId() + 1;
u.U_ID = id;
string unitCode = os.GetUnitCode(ObjectType.User, u.U_UID);
Org unitOrg = os.GetOrgBaseInfo(ObjectType.Org, unitCode);
u.u_unitname = unitOrg.OrgName;
u.U_UNITCODE = unitCode;
u.u_enable_status = UserEnabledStatus.UnAuthed;
u.u_auth_submit_time = DateTime.Now;
userDao.Insert(u);
userDao.UpdateMaxId();
}
else
{
u.U_NAME = _u.UserFullName;
u.U_PASSWORD = _u.UserPassword;
string unitCode = os.GetUnitCode(ObjectType.User, u.U_UID);
Org unitOrg = os.GetOrgBaseInfo(ObjectType.Org, unitCode);
u.u_unitname = unitOrg.OrgName;
u.U_UNITCODE = unitCode;
u.u_enable_status = UserEnabledStatus.UnAuthed;
u.u_auth_submit_time = DateTime.Now;
userDao.Update(u);
}
}
}
}
}
}
catch (DalException ex)
{
throw new BOException("同步BUA用户出错", ex);
}
}
public virtual void BUAUserSyncToInside(string ids, Hashtable result)
{
ServiceFactory factory = Beyondbit.BUA.Client.ServiceFactory.Instance();
IUserService us = factory.GetUserService();
IOrgService os = factory.GetOrgService();
SMC_UserDao userDao = new SMC_UserDao(AppConfig.statisticDBKey);
SMC_BUAUserSyncToInsideDao buaSyncInsideDao = new SMC_BUAUserSyncToInsideDao(AppConfig.statisticDBKey);
GlobalParamDao globalParamDao = new GlobalParamDao(AppConfig.statisticDBKey);
GlobalParam p = globalParamDao.GetGlobalParam("user_default_status");
int batNo = 0;
try
{
batNo = buaSyncInsideDao.GetMaxBatNo();
}
catch (Exception e)
{
}
batNo += 1;
string[] idlist = ids.Split(",".ToCharArray());
foreach (string uid in idlist)
{
if (String.IsNullOrEmpty(uid))
{
continue;
}
Beyondbit.BUA.Client.User _u = null;
try
{
_u = us.GetUserInfo(uid);
}
catch (Exception ex)
{
result["Msg"] += uid + ex.Message;
continue;
}
SMC_BUAUserSyncToInside log = new SMC_BUAUserSyncToInside();
log.sync_bat_no = batNo;
try
{
log.sync_status = true;
log.sync_time = DateTime.Now;
log.sync_user_name = "";
log.sync_user_uid = "";
log.user_name = _u.UserFullName;
log.user_uid = _u.UserUid;
log.description = "同步成功";
log.busi_id = buaSyncInsideDao.GetMaxId() + 1;
SMC_UnitDao unitDao = new SMC_UnitDao(AppConfig.statisticDBKey);
SMC_User u = null;
u = userDao.GetUser(_u.UserUid);
if (u == null)
{
u = new SMC_User();
u.U_NAME = _u.UserFullName;
u.U_PASSWORD = _u.UserPassword;
u.U_UID = _u.UserUid;
int id = userDao.GetMaxId() + 1;
u.U_ID = id;
string unitCode = os.GetUnitCode(ObjectType.User, u.U_UID);
Org unitOrg = os.GetOrgBaseInfo(ObjectType.Org, unitCode);
u.U_UNITCODE = unitCode;
//List<KeyValuePair<string, string>> pars = new List<KeyValuePair<string,string>>();
//pars.Add(new KeyValuePair<string, string>("unit_id",unitCode));
SMC_Unit unit = unitDao.Get(unitCode);
if (unit == null)
{
unit = new SMC_Unit();
unit.Unit_ID = unitCode;
unit.Unit_Name = unitOrg.OrgName;
unit.Unit_Sequence = 0;
unit.Unit_UpdateTime = DateTime.Now;
unit.Unit_CreatedTime = DateTime.Now;
unit.Upper_Unit_ID = "";
unit.Unit_Path = unitCode;
unitDao.Insert(unit);
}
u.u_unitname = unitOrg.OrgName;
u.U_CREATEDDATE = DateTime.Now;
u.u_enable_status = p.ConfigValue == "1" ? UserEnabledStatus.Enabled : UserEnabledStatus.UnAuthed;
u.u_auth_submit_time = DateTime.Now;
u.u_need_sync = false;
userDao.Insert(u);
userDao.UpdateMaxId();
}
else
{
u.U_NAME = _u.UserFullName;
u.U_PASSWORD = _u.UserPassword;
u.U_CREATEDDATE = DateTime.Now;
string unitCode = os.GetUnitCode(ObjectType.User, u.U_UID);
Org unitOrg = os.GetOrgBaseInfo(ObjectType.Org, unitCode);
//List<KeyValuePair<string, string>> pars = new List<KeyValuePair<string, string>>();
//pars.Add(new KeyValuePair<string, string>("unit_id", unitCode));
SMC_Unit unit = unitDao.Get(unitCode);
if (unit == null)
{
unit = new SMC_Unit();
unit.Unit_ID = unitCode;
unit.Unit_Name = unitOrg.OrgName;
unit.Unit_Sequence = 0;
unit.Unit_UpdateTime = DateTime.Now;
unit.Unit_CreatedTime = DateTime.Now;
unit.Upper_Unit_ID = "";
unit.Unit_Path = unitCode;
unitDao.Insert(unit);
}
u.u_unitname = unitOrg.OrgName;
u.U_UNITCODE = unitCode;
u.u_enable_status = p.ConfigValue == "1" ? UserEnabledStatus.Enabled : UserEnabledStatus.UnAuthed;
u.u_auth_submit_time = DateTime.Now;
u.u_need_sync = false;
u.u_update_time = DateTime.Now;
userDao.Update(u);
}
}
catch (Exception ex)
{
log.sync_status = false;
log.description = "同步失败,原因可能是:" + ex.Message + "。\r\nStackTrace:\r\n" + ex.StackTrace;
if (result != null)
{
result["IsSuccess"] = false;
result["Msg"] += log.description;
}
}
try
{
buaSyncInsideDao.Insert(log);
buaSyncInsideDao.UpdateMaxId();
}
catch (Exception ex)
{
}
}
}
public virtual string GetUserUnitCode(string useruid)
{
SMC_UserDao udao = new SMC_UserDao(AppConfig.statisticDBKey);
SMC_User u = udao.GetUser(useruid);
if (u == null)
return "";
else
return u.U_UNITCODE;
}
public virtual SelectPagnationExDictionary GetUserRetryLock(string uid, string username, string u_unitcode, string u_lock_time_start, string u_lock_time_end, int lockStatus, string orderby, int pageSize, int pageIndex)
{
SMC_UserDao dao = new SMC_UserDao(AppConfig.statisticDBKey);
return(dao.GetUserRetryLock(uid, username, u_unitcode, u_lock_time_start, u_lock_time_end, lockStatus, orderby, pageSize, pageIndex));
}
public virtual SelectPagnationExDictionary GetSelectUser(string uid, string username, string u_unitcode, string u_auth_submit_time_start, string u_auth_submit_time_end, int deviceAuthStatus, string orderby, int pageSize, int pageIndex)
{
SMC_UserDao dao = new SMC_UserDao(AppConfig.statisticDBKey);
return(dao.GetSelectUser(uid, username, u_unitcode, u_auth_submit_time_start, u_auth_submit_time_end, deviceAuthStatus, orderby, pageSize, pageIndex));
}
