/// <summary> /// �����Դ /// </summary> /// <param name="resourceInfo">��Դ</param> /// <param name="tags">��Դ�ı�ǩ���ؼ��֣�</param> public void Add(LabMS.Model.Resource resourceInfo, params string[] tags) { resourceInfo.id = base.Add(resourceInfo); LabMS.Model.ResourceTag resourceTagInfo = new LabMS.Model.ResourceTag(); LabMS.Model.Tag tagInfo = new LabMS.Model.Tag(); LabMS.DAL.ResourceTag resourceTag = new LabMS.DAL.ResourceTag(); ExtendBLL.Tag tag = new Tag(); resourceTagInfo.Resource = resourceInfo; // �����ؼ��ֵĶ�Ӧ foreach (string tagName in tags) { if (!string.IsNullOrEmpty(tagName)) { tagInfo = tag.InsertGet(tagName); resourceTagInfo.Tag = tagInfo; resourceTag.AddGet(resourceTagInfo); } } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public LabMS.Model.ResourceTag GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,TagID,ResourceID from ResourceTag "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4)}; parameters[0].Value = ID; LabMS.Model.ResourceTag model = new LabMS.Model.ResourceTag(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["TagID"].ToString() != "") { model.TagID = int.Parse(ds.Tables[0].Rows[0]["TagID"].ToString()); } if (ds.Tables[0].Rows[0]["ResourceID"].ToString() != "") { model.ResourceID = int.Parse(ds.Tables[0].Rows[0]["ResourceID"].ToString()); } return model; } else { return null; } }
/// <summary> /// ������Դ /// </summary> /// <param name="resourceInfo">��Դ</param> /// <param name="tags">��Դ�ı�ǩ���ؼ��֣�</param> public void Update(LabMS.Model.Resource resourceInfo, params string[] tags) { base.Update(resourceInfo); if (tags != null && tags.Length > 0) { LabMS.Model.ResourceTag resourceTagInfo = new LabMS.Model.ResourceTag(); LabMS.Model.Tag tagInfo = new LabMS.Model.Tag(); LabMS.DAL.ResourceTag resourceTag = new LabMS.DAL.ResourceTag(); ExtendBLL.Tag tag = new Tag(); resourceTagInfo.Resource = resourceInfo; resourceTag.Delete(resourceInfo.id, LabMS.DAL.ResourceTag.DeleteType.ByResourceID); // ɾ�����ж�Ӧ��ϵ // �����ؼ��ֵĶ�Ӧ foreach (string tagName in tags) { if (!string.IsNullOrEmpty(tagName)) { tagInfo = tag.InsertGet(tagName); resourceTagInfo.Tag = tagInfo; resourceTag.AddGet(resourceTagInfo); } } } }