填写下拉列表来自另一个下拉列表的值

我有一个 issuedate 的下拉列表这些日期填写了我的下拉列表，在http get方法中应用了一些过滤器

ViewBag.PMID1 = new SelectList(db.PRIMKT_MAST.Where(z => z.PRODUCT_ID == j && z.REC_VERIFIED == 0 && z.VERIFY_LOCK == 0 && z.TRTYPE == i), "PMID", "ISSUE_DATE");

这是我的下拉列表 .
@ Html.LabelFor（model => model.ISSUE_DATE，new {@class = "control-label col-md-2"}）@ Html.DropDownList（"PMID1"，null，new {@onchange = "FillTenor()"}）@ Html.ValidationMessageFor（model => model.ISSUE_DATE）
现在我想在一个表格中选择 AUCTIONID ，这个下拉列表根据发行日期填写如 select auctionid where issuedate = dropdown selected value

当我们得到 auctionid 我想拿这个 auctionid 并在其他表中搜索并在此基础上填充另一个下拉列表 auctionid 如 select Tenors(i want to select this value) where auctionid is (whatever we get from dropdown) 这是我要填写的第二个Dropdownt列表

<div class="form-group">
            @Html.LabelFor(model => model.TENOR_ID, "TENOR_ID", new { @class     = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.DropDownListFor(m => m.TENOR_ID,
new SelectList(Enumerable.Empty<SelectListItem>(), "AUCDT_ID", "TENOR_ID"),
              "Select Tenors",
              new { @class = "form-control" })
                @Html.ValidationMessageFor(model => model.BRANCH_ID)
            </div>
        </div>

This is my Controller
  public ActionResult Create()
        {
            ViewBag.AUCTION_ID = new SelectList(db.AUCTION_DATA, "AUCTION_ID", "PRODUCT_ID");
            ViewBag.CUSTOMER_ID = new SelectList(db.CUSTOMERs, "CUSTOMER_ID", "CUSTOMER_NAME");
            ViewBag.PMID = new SelectList(db.PRIMKT_MAST, "PMID", "PRODUCT_ID");
            ViewBag.BRANCH_ID = new SelectList(db.BRANCHes, "BRANCH_ID", "BRANCH_DESC");
           //ViewData["ListofIssueDate"] = db.PRIMKT_MAST.Where(z => z.PRODUCT_ID == Session["Product_Id"] && z.REC_VERIFIED == 0 && z.VERIFY_LOCK == 0 && z.TRTYPE == Convert.ToInt32(Session["Trtype"])).Select(z => z.ISSUE_DATE);
            int i = Convert.ToInt32(Session["Trtype"]);
            string j =Convert.ToString( Session["Product_Id"]);
            ViewBag.PMID1 = new SelectList(db.PRIMKT_MAST.Where(z => z.PRODUCT_ID == j && z.REC_VERIFIED == 0 && z.VERIFY_LOCK == 0 && z.TRTYPE == i), "ISSUE_DATE", "ISSUE_DATE");
            return View();
        }

我的Ajax电话..

@section script {
    <script>
        function FillTenor() {
            var IssueDate = $('#PMID1').val();
            $.ajax({
                url: '@Url.Action("FillCity", "PrimaryMarket")',
                type: "GET",
                dataType: "JSON",
                data: { IssueDate: $("#PMID1").val() },
                success: function (Tenor) {
                    $("#TENOR_ID").html(""); // clear before appending new list
                    $.each(Tenor, function (i, AUCDATA_TENORS) {
                        $("#TENOR_ID").append(
                            $('<option></option>').val(AUCDATA_TENORS.AUCDT_ID).html(AUCDATA_TENORS.TENOR_ID));
                    });
                }
            });
        }
    </script>
}


My onchange Method
 [HttpGet]
        public ActionResult FillTenor(DateTime? IssueDate)
        {
            var auctionid = db.PRIMKT_MAST.Where(c => c.ISSUE_DATE == IssueDate).Select(c=>c.AUCTION_ID).ToList();
            var Tenor = db.AUCDATA_TENORS.Where(c => c.AUCTION_ID ==( auctionid[0])).Select(c => c.TENOR_ID);

            return Json(Tenor, JsonRequestBehavior.AllowGet);
        }

Exception