/// <summary> /// 为医院增加一个服务项目 /// </summary> /// <param name="Item"></param> public void AddServiceItemToHospital(ServiceItem Item) { string strWhere = Tables.base_hospital_items.ITEM_ID + oleDb.EuqalTo() + Item.ITEM_ID + oleDb.And() + Tables.base_hospital_items.COMPLEX_ID + oleDb.EuqalTo() + "0"; Model.BASE_HOSPITAL_ITEMS model = BindEntity <Model.BASE_HOSPITAL_ITEMS> .CreateInstanceDAL(oleDb).GetModel(strWhere); if (model == null) { model = new HIS.Model.BASE_HOSPITAL_ITEMS( ); model.ITEM_ID = Item.ITEM_ID; model.COMPLEX_ID = 0; BindEntity <Model.BASE_HOSPITAL_ITEMS> .CreateInstanceDAL(oleDb).Add(model); } }
/// <summary> /// 医院移除一个服务项目 /// </summary> /// <param name="Item"></param> public void RemoveServiceItemFromHospital(ServiceItem Item) { //1、从医院项目中移除 string strWhere = Tables.base_hospital_items.ITEM_ID + oleDb.EuqalTo( ) + Item.ITEM_ID + oleDb.And() + Tables.base_hospital_items.COMPLEX_ID + oleDb.EuqalTo( ) + "0"; Model.BASE_HOSPITAL_ITEMS model = BindEntity <Model.BASE_HOSPITAL_ITEMS> .CreateInstanceDAL(oleDb).GetModel(strWhere); if (model != null) { BindEntity <Model.BASE_HOSPITAL_ITEMS> .CreateInstanceDAL(oleDb).Delete(strWhere); //2、删除执行设置的执行科室 strWhere = Tables.base_item_dept.ITEM_ID + oleDb.EuqalTo() + Item.ITEM_ID + oleDb.And() + Tables.base_item_dept.COMPLEX_ID + oleDb.EuqalTo() + "0"; BindEntity <BASE_ITEM_DEPT> .CreateInstanceDAL(oleDb).Delete(strWhere); } }