/// <summary> /// 加载系统代码中的数据 /// </summary> /// <param name="type">父【上级】编码</param> /// <param name="type">需要类型的层级</param> /// <param name="valuetype">value 值是否显示为名称(true 保存名称,false 保存编码)</param> /// <param name="bl">是否显示“请选择”项(true 显示请选择项,false 隐藏请选择项)</param> /// <param name="c_id">公司信息</param> /// <returns></returns> public SelectList BindSysCodeBaseForCheckBoxList(string fcode, int cengji, bool valuetype) { BLL.SysCodeBase db = new BLL.SysCodeBase(); var sysCode = db.GetModelList("sc_DeleteStateCode=0 and sc_CengJ=" + cengji + " and sc_BianM Like '" + fcode + "%' order by sc_BianM asc"); //var syscode = EnergyContext.Database.SqlQuery<SysCodeBase>("select * from dbo.SysCodeBase where sc_DeleteStateCode=0 and sc_CengJ=" + cengji + " and sc_BianM Like '" + fcode + "%' order by sc_BianM asc"); List<SelectListItem> items = new List<SelectListItem>(); if (sysCode != null) { foreach (var item in sysCode) { if (valuetype) { items.Add(new SelectListItem() {Text = item.sc_MingCh, Value = item.sc_MingCh, Selected = false}); } else { items.Add(new SelectListItem() {Text = item.sc_MingCh, Value = item.sc_BianM, Selected = false}); } } } SelectList list = new SelectList(items, "Value", "Text"); return list; }
/// <summary> /// 绑定咨询分类 /// </summary> /// <returns></returns> public ActionResult bindSelType() { StringBuilder strHtml = new StringBuilder(); BLL.SysCodeBase bll = new BLL.SysCodeBase(); List<Model.SysCodeBase> list = bll.GetModelList(" substring(sc_BianM,0,5)='0004' and length(sc_BianM)=8 and sc_DeleteStateCode=0"); foreach (Model.SysCodeBase model in list) { strHtml.AppendFormat("<option value='{0}'>{1}</option>", model.sc_BianM, model.sc_MingCh); } return Content(strHtml.ToString()); }