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