/// <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());
}
