车辆资产管理系统：用人员档案表DRIVER_BASIC_INFO抽取数据导入BPMS_USER表和分配BPMS_USERROLE（里程登记员角色）

2017-09-29 09:25:04  访问(1423) 赞(0) 踩(0)

  • 
        /// <summary>
        /// 
        /// </summary>
        /// <param name="str"></param>
        /// <param name="xdbHelper"></param>
        /// <returns></returns>
        protected bool UserIsExist(string str, DBHelper xdbHelper)
        {
            bool theResult = true;

            bool bIsCreate = true;

            if (xdbHelper == null)
            {
                xdbHelper
                    =
                    SlowX.DAL.Helpers.DBHelper.CreateDBHelper
                    (
                        DEFAULT_CONN,
                        SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.Oracle,
                        1
                    );
            }
            else
            {
                // 没有打开链接 //
                bIsCreate = xdbHelper.IsNotOpen();
            }

            try
            {
                if (bIsCreate)
                    xdbHelper.OpenDBHelper();

                 
                eKing.EkVehicleLib.Business.CommonModule.User.BPMS_USER
                    bll
                    =
                    eKing.EkVehicleLib.Business.CommonModule.User.BPMS_USER.instance;


                eKing.EkVehicleLib.Entity.CommonModule.User.BPMS_USER
                    entity
                    =
                    new eKing.EkVehicleLib.Entity.CommonModule.User.BPMS_USER();

                IQueryDriver iq = entity;
                iq.AddIQueryItemSearchText(entity._Account, true, false, str.Trim().ToLower());

                theResult = bll.IsExist(entity, xdbHelper);

                if (bIsCreate)
                    xdbHelper.EndDBHelper();

            }
            catch (Exception err)
            {
                if (bIsCreate)
                    xdbHelper.TranDBHelper();

                throw err;
            }
            finally
            {
                if (bIsCreate)
                    xdbHelper.FinallyDBHelper();
            }

            return theResult;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        protected string ToPwd(string str)
        {
            eKingEkVehicleLibHelper
              ch
              =
              eKingEkVehicleLibHelper.cInstance;

            return ch.PasswordToMd5(str, DEFAULT_PWD);
        }


        /// <summary>
        /// 
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        protected string ToSecretkey()
        {
            eKingEkVehicleLibHelper
              ch
              =
              eKingEkVehicleLibHelper.cInstance;

            return ch.CreateNo();
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        protected string ToName(string str)
        {
            if (str == null)
                return "";

            return str.Trim().Replace(" ", "");

        }

        
        /// <summary>
        /// 
        /// </summary>
        /// <param name="model"></param>
        /// <param name="xdbHelper"></param>
        /// <returns></returns>
        protected int SaveUserRole
            (
                string userId,
                DBHelper xdbHelper
            )
        {
            int theResult = 0;

            bool bIsCreate = true;

            if (xdbHelper == null)
            {
                xdbHelper
                    =
                    SlowX.DAL.Helpers.DBHelper.CreateDBHelper
                    (
                        DEFAULT_CONN,
                        SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.Oracle,
                        1
                    );
            }
            else
            {
                // 没有打开链接 //
                bIsCreate = xdbHelper.IsNotOpen();
            }

            try
            {
                if (bIsCreate)
                    xdbHelper.OpenDBHelper();

                string pkId = System.Guid.NewGuid().ToString();

                string sql = @"insert into BPMS_USERROLE 
(
USERROLEID,USERID, 
ROLEID,
CREATEDATE,
CREATEUSERID,
CREATEUSERNAME
)
values
(
'" + pkId + "','" + userId + "','" + DEFAULT_ROLE + @"',sysdate,'System','管理员'
)";

                theResult = xdbHelper.ExecuteNonQuery(sql);

                if (bIsCreate)
                    xdbHelper.EndDBHelper();

            }
            catch (Exception err)
            {
                if (bIsCreate)
                    xdbHelper.TranDBHelper();

                throw err;
            }
            finally
            {
                if (bIsCreate)
                    xdbHelper.FinallyDBHelper();
            }

            return theResult;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="model"></param>
        /// <param name="xdbHelper"></param>
        /// <returns></returns>
        protected int SaveUser
            (
                eKing.EkVehicleLib.Model.CommonModule.DriverRoll.DRIVER_BASIC_INFO model,
                DBHelper xdbHelper
            )
        {
            int theResult = 0;

            bool bIsCreate = true;

            if (xdbHelper == null)
            {
                xdbHelper
                    =
                    SlowX.DAL.Helpers.DBHelper.CreateDBHelper
                    (
                        DEFAULT_CONN,
                        SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.Oracle,
                        1
                    );
            }
            else
            {
                // 没有打开链接 //
                bIsCreate = xdbHelper.IsNotOpen();
            }

            try
            {
                if (bIsCreate)
                    xdbHelper.OpenDBHelper();


                string newId = System.Guid.NewGuid().ToString();

                eKing.EkVehicleLib.Business.CommonModule.User.BPMS_USER
                    bll
                    =
                    eKing.EkVehicleLib.Business.CommonModule.User.BPMS_USER.instance;


                eKing.EkVehicleLib.Entity.CommonModule.User.BPMS_USER
                    entity
                    =
                    new eKing.EkVehicleLib.Entity.CommonModule.User.BPMS_USER();


                ISaveDriver isave = entity;

                isave.AddISaveItem(entity._Account, model.EName);
                isave.AddISaveItem(entity._CreateDate, DateTime.Now);
                isave.AddISaveItem(entity._CreateUserId, "System");
                isave.AddISaveItem(entity._DeleteMark, 0);
                // e2107b46-ece9-4da3-b6f3-663af91dea1a == 车辆保障部 //
                isave.AddISaveItem(entity._DepartmentId, "e2107b46-ece9-4da3-b6f3-663af91dea1a");
                isave.AddISaveItem(entity._Description, "");
                isave.AddISaveItem(entity._DutyId, "");
                isave.AddISaveItem(entity._Email, model.Mail);
                isave.AddISaveItem(entity._Enabled, 1);
                isave.AddISaveItem(entity._FirstVisit, DateTime.Now);
                isave.AddISaveItem(entity._H_Phone, model.H_Phone);
                isave.AddISaveItem(entity._IpAddress, "127.0.0.1");
                isave.AddISaveItem(entity._IsOutUser, 0);
                isave.AddISaveItem(entity._Lastvisit, DateTime.Now);
                isave.AddISaveItem(entity._LogonCount, 0);
                isave.AddISaveItem(entity._MacAddress, "127.0.0.1");
                isave.AddISaveItem(entity._Mobile, model.M_Phone);
                isave.AddISaveItem(entity._ModifyDate, DateTime.Now);
                isave.AddISaveItem(entity._ModifyUserId, "System");

                isave.AddISaveItem(entity._Password, ToPwd(model.EName));
                isave.AddISaveItem(entity._Previousvisit, DateTime.Now);
                isave.AddISaveItem(entity._RealName, ToName(model.Name));
                // 随便给的一个值，意义不大 //
                isave.AddISaveItem(entity._RoleId, "88b66e5d-832d-4f70-b524-69ce87d4f8d4");
                isave.AddISaveItem(entity._SecretKey, ToSecretkey());
                isave.AddISaveItem(entity._SortCode, 99);
                isave.AddISaveItem(entity._Telephone, model.W_Phone);
                isave.AddISaveItem(entity._UserId, newId);


                theResult = bll.Insert(entity, xdbHelper);

                SaveUserRole(newId, xdbHelper);

                if (bIsCreate)
                    xdbHelper.EndDBHelper();

            }
            catch (Exception err)
            {
                if (bIsCreate)
                    xdbHelper.TranDBHelper();

                throw err;
            }
            finally
            {
                if (bIsCreate)
                    xdbHelper.FinallyDBHelper();
            }

            return theResult;
        }



        /// <summary>
        /// 
        /// </summary>
        /// <param name="xdbHelper"></param>
        /// <returns></returns>
        protected string ImportClick(DBHelper xdbHelper)
        {
            int iCount = 0;
            string theResult = "";
            int addResult = 0;

            bool bIsCreate = true;

            if (xdbHelper == null)
            {
                xdbHelper
                    =
                    SlowX.DAL.Helpers.DBHelper.CreateDBHelper
                    (
                        DEFAULT_CONN,
                        SlowX.DAL.Enums.DataBaseHelper.EmDataBaseHelper.Oracle,
                        1
                    );
            }
            else
            {
                // 没有打开链接 //
                bIsCreate = xdbHelper.IsNotOpen();
            }

            try
            {
                if (bIsCreate)
                    xdbHelper.OpenDBHelper();

                eKing.EkVehicleLib.Business.CommonModule.DriverRoll.DRIVER_BASIC_INFO
                    bll
                    =
                    eKing.EkVehicleLib.Business.CommonModule.DriverRoll.DRIVER_BASIC_INFO.instance;


                eKing.EkVehicleLib.Entity.CommonModule.DriverRoll.DRIVER_BASIC_INFO
                    entity
                    =
                    new eKing.EkVehicleLib.Entity.CommonModule.DriverRoll.DRIVER_BASIC_INFO();

                IQueryDriver iq = entity;
                iq.WhereAddInt(entity._EmDriverStatusV, (int)eKing.EkVehicleLib.Enums.DriverStatus.EmDriverStatus.在职);
                iq.WhereAddInt(entity._EmWorkerRoleV, (int)eKing.EkVehicleLib.Enums.WorkerRole.EmWorkerRole.正式工);

                List<BaseModel>
                    theList = bll.ListBaseModel(entity, xdbHelper);

                foreach (eKing.EkVehicleLib.Model.CommonModule.DriverRoll.DRIVER_BASIC_INFO model in theList)
                {
                    if (model == null)
                        continue;

                    if (UserIsExist(model.EName,xdbHelper))
                    {
                        continue;
                    }

                    addResult = SaveUser(model, xdbHelper);

                    if (addResult == 0)
                        continue;

                    iCount += addResult;

                    theResult += model.Name + "<br />";


                }

                if (bIsCreate)
                    xdbHelper.EndDBHelper();

            }
            catch (Exception err)
            {
                if (bIsCreate)
                    xdbHelper.TranDBHelper();

                throw err;
            }
            finally
            {
                if (bIsCreate)
                    xdbHelper.FinallyDBHelper();
            }

            return iCount.ToString() + "<br />" + theResult;

        }

        protected void btn_ImportUser_Click(object sender, EventArgs e)
        {
            try
            {
                string str = ImportClick(null);

                Response.Write(str);


            }
            catch (Exception err)
            {
                Response.Write(err.Message);
            }
        }


  • 
        #region 自动生成日期编号

        /// <summary>
        /// 自动生成编号  201008251145409865
        /// </summary>
        /// <returns></returns>
        public string CreateNo()
        {
            Random random = new Random();
            string strRandom = random.Next(1000, 10000).ToString(); //生成编号 
            string code = DateTime.Now.ToString("yyyyMMddHHmmss") + strRandom;//形如
            return code;
        }

        #endregion


  • 
        /// <summary>
        /// 
        /// </summary>
        /// <param name="userName"></param>
        /// <param name="pwd"></param> 
        /// <returns></returns>
        public string PasswordToMd5(string userName, string pwd)
        {
            if (userName == null)
                userName = "";
            else
                userName = userName.Trim().ToLower();

            string str = userName + pwd;

            return GetGB2312MD5(str);
        }

上一条：

下一条：


 

相关评论

评论加载中……
 

发表评论

类型：
内容：
  (Alt+Enter)
 
  ┈全部┈  
 
（显示全部分类）