/// <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>
/// <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 BindSysCodeBase(string fcode, int cengji, bool valuetype, bool bl)
{
string sql = "sc_DeleteStateCode=0 and sc_CengJ=" + cengji + " and sc_BianM Like '" + fcode + "%' order by sc_BianM asc";
var syscode = new BLL.SysCodeBase().GetModelList(sql);
List<SelectListItem> items = new List<SelectListItem>();
if (bl)
{
items.Add(new SelectListItem() { Text = "--请选择--", Value = "", Selected = true });
}
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 });
}
}
}
return new SelectList(items, "Value", "Text");
}
/// <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());
}
public ActionResult ProductConsultMsg()
{
ViewData["IsHasFunRole"] = _roleManager.IsHasFunRole(EmployeeBase.e_ID, "001002001"); //是否拥有管理的权限
List<Model.SysCodeBase> modelType = new BLL.SysCodeBase().GetModelList(" substring(sc_BianM,0,5)='0004' and len(sc_BianM)=8 and sc_DeleteStateCode=0");
List<SelectListItem> selectType = new List<SelectListItem>();
selectType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "0" } };
for (int i = 0; i < modelType.Count; i++)
{
selectType.Add(new SelectListItem
{
Value = modelType[i].sc_BianM.ToString(),
Text = modelType[i].sc_MingCh
});
}
ViewData["selectType"] = new SelectList(selectType, "Value", "Text", "请选择");
return View();
}
