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