/// <summary>
/// 获取物资仓库的ID 和Name
/// </summary>
/// <returns></returns>
public IList <CheckModelExt> GetStorage()
{
using (AKSHManageEntities dbContext = new AKSHManageEntities())
{
string list = @"select ID =t.StorageID,Name =t.Name from dbo.I_Storage t";
//IList<CheckModelExt>只是一个模型，获取的list，以<M_CheckModel>模型对应的字段传给Templist list需要与（<M_CheckModel>）模型的属性，一一对应，名称和类型也要相同，必要是需要转换(int 转string)。
IList <CheckModelExt> Templist = dbContext.Database.SqlQuery <CheckModelExt>(list).ToList();
return(Templist);
}
}
/// <summary>
/// 根据字典表上级编码来获取管理库字典表信息(物资分类，细分类使用) 朱传海 2015-3-27
/// </summary>
/// <param name="parentID"></param>
/// <returns></returns>
public IList <M_CheckModel> GetCheckBoxModelByparentID(string parentID)
{
using (AKSHManageEntities dbContext = new AKSHManageEntities())
{
string list = @"select Id =t.Name,Name =t.Name,Tags =t.Name from dbo.TDictionary t where t.IsActive =1 and t.ParentID='" + parentID + "' order by t.SN";
//<M_CheckModel>只是一个模型，获取的list，以<M_CheckModel>模型对应的字段传给Templist list需要与（<M_CheckModel>）模型的属性，一一对应，名称和类型也要相同，必要是需要转换(int 转string)。
IList <M_CheckModel> Templist = dbContext.Database.SqlQuery <M_CheckModel>(list).ToList();
return(Templist);
}
}
