后台方庄List razor 循环

时间:2023-03-08 18:00:39

后台:

//1.查询所有年卡类型
                StringBuilder sqlStr = new StringBuilder();
                sqlStr.Append(string.Format("  select  Id,TypeName  from tb_yearcard_cardtype where MerchantCode='{0}' ",this.Base_Code));
                DataTable dt = Shove.Database.MySQL.Select(sqlStr.ToString());
                List<YearcardCardType> y_List = new List<YearcardCardType>();

                ViewBag.YearCarEditType = 1;//操作类别
                ViewBag.yearCardCardType = y_List;//列表

视图:

头部引用     @using EquipmentPay.Areas.Web.Models;

@foreach (YearcardCardType data in @ViewBag.yearCardCardType as List<YearcardCardType>)
                                    {    
                                        <option value='@data.Id'>@data.TypeName</option>
                                    }