2019/09/23 工作总结

1.bootstrap的uibModal如何在子控制器和母控制器之间双向传值：

先展示工作中的一个实例：

public CreateAnswerKey() {
        var $ctrl = this;
        var choosenumberofdistractors = this.$uibModal.open({
            backdrop: true,
            templateUrl: "template/ChooseNumberOfDistractors.html",
            controller: "ChooseNumberOfDistractorsCtrl",
            controllerAs: "ctrl",
            resolve: {
                numberofDistractors: () => this.numberofDistractors
            }
        });
        choosenumberofdistractors.result.then(function (numberofDistractors) {
            $ctrl.numberofDistractors = numberofDistractors;
            $ctrl.AnswerKeySelectedForm = "Form 1";
            $ctrl.QuestionAnswer = new Array(numberofDistractors);
            $ctrl.FormList = new Array($ctrl.numberOfKeyForm);
            for (var j = 0; j < $ctrl.numberOfKeyForm; j++) {
                $ctrl.FormList[j] = "Form " + (j + 1);
                for (var i = 0; i < $ctrl.numberofQuestions; i++) {
                    $ctrl.QuestionAnswer[i + j * $ctrl.numberofQuestions] = (numberofDistractors == 5) ? { A: false, B: false, C: false, D: false, E: false, F: null, G: null, H: null, I: null, J: null, FormID: $ctrl.FormList[j] } :
                        { A: false, B: false, C: false, D: false, E: false, F: false, G: false, H: false, I: false, J: false, FormID: $ctrl.FormList[j] };
                    }
                }
        });
    }

 

export class ChooseNumberOfDistractorsCtrl {
    static readonly $inject = [
        "numberofDistractors",
        "$http",
        "routeConfig",
        "$uibModalInstance",
        "errorHandler",
    ];

    constructor(
        public numberofDistractors: number, 
        private $http: IHttpService,
        private routeConfig: RouteConfig,
        private $uibModalInstance: IModalServiceInstance,
        private errorHandler: ErrorHandler) { }

    FiveDistractors() {
        this.numberofDistractors = 5;
        this.$uibModalInstance.close(this.numberofDistractors);
    }

    TenDistractors() {
        this.numberofDistractors = 10;
        this.$uibModalInstance.close(this.numberofDistractors);
    }
}

 

<div class="col-xs-3" ng-show="ctrl.selectedExam.Id || ctrl.newExamId">
      <button type="button" class="btn-default btn" ng-click="ctrl.CreateAnswerKey()"
              ng-disabled="!ctrl.numberofQuestions || !ctrl.numberOfKeyForm || (ctrl.numberOfKeyForm > 99)">Create AnswerKey</button>
    </div>

 

<script type="text/ng-template" id="template/ChooseNumberOfDistractors.html">
  <div class="modal-header">
    <h3 class="modal-title">Choose number of Distractor</h3>
  </div>
  <div class="modal-body">
    <p>How many distractors do you need for this new answerkey?</p>
  </div>
  <div class="modal-footer">
    <button class="btn btn-primary" ng-click="ctrl.FiveDistractors()">5: A~E</button>
    <button class="btn btn-primary" ng-click="ctrl.TenDistractors()">10: A~J</button>
    <button class="btn btn-default" ng-click="$dismiss()">Cancel</button>
  </div>
</script>

 

（1）首先通过uibModal参数中的resolve将值从母控制器传进子控制器。

（2）子控制器中操作完毕后，通过this.$uibModalInstance.close()来将小括号内的参数传回母控制器。

（3）在uibModal的result.then中用function（）来得到小括号内传回的参数。注意此时仍在子控制器中，如果要调用母控制器的作用域内的参数而使用this的话会和子控制器作用域内的this冲突，因此需要在母控制器中用一个其他名字的变量来指向this，这样就可以在子控制器使用该新变量了。

 

2.在本地数据库中对表结构进行了修改或者增删了表时，需要更新线上数据库。此时我们在Data.CSharp的Migrations文件夹中新建一个C#文件，将对数据库的修改写入这个文件中即可，下面给出一个新增表的例子：

[Migration(56, "CreateTableArchive")]

public class CreateTableArchive : Migration
    {
        public override IEnumerable<IMigrationOperation> Up() => new MigrationBuilder()
                .When(c => !c.TableExists("archive"),
                    m =>
                    {
                        m.CreateTable("archive", c =>
                        {
                            c.Define(@"CREATE TABLE `archive` (
                                      `RecNo` int(15) NOT NULL  AUTO_INCREMENT,
                                      `archivesetdate` date NOT NULL,
                                      `timestamp` date NOT NULL,
                                      `user` int(15) NOT NULL,
                                      PRIMARY KEY (`RecNo`)
                                    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;");
                        });
                    })
                    .Build();
    }