车辆资产管理系统：批量更新用户密码

2017-09-29 12:03:06  访问(1384) 赞(0) 踩(0)

        /// <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="xdbHelper"></param>
        /// <returns></returns>
        protected string ImportClick(DBHelper xdbHelper)
        {
            int iCount = 0;
            string theResult = "";

            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;
                ISaveDriver isave
                     = entity;

                // 拿到所有的用户数据 //
                List<BaseModel>
                    theList = bll.ListBaseModel(entity, xdbHelper);

                string strPwd = null;
                foreach (eKing.EkVehicleLib.Model.CommonModule.User.BPMS_USER model in theList)
                {
                    // 循环每一条记录 //
                    if (model == null)
                        continue;

                    if (model.UserId == NO_UPDATE_USER_ID)
                        continue;

                    strPwd = ToPwd(model.Account);

                    iq.ClearAllIQueryItem();
                    isave.ClearAllISaveItem();

                    iq.WhereAddStr(entity._UserId, model.UserId);
                    isave.AddISaveItem(entity._Password, strPwd);

                    bll.Update(entity, xdbHelper);

                    ++iCount;

                    theResult += model.RealName + "<br />";
                }

                if (bIsCreate)
                    xdbHelper.EndDBHelper();

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

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

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

        }



        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btn_ImportUser_Click(object sender, EventArgs e)
        {
            try
            {
                string str = ImportClick(null);

                Response.Write(str);


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

上一条：

下一条：

相关评论

发表评论

类型：	留言 建议 疑问
内容：
	(Alt+Enter)