public static string Parse(TagBindModel model)
{
string[] tag = new string[model.Count];
for(int i=0; i<model.Count; i++)
tag[i] = model[i].TagName;
return string.Join(",", tag);
}
public static string Parse(TagBindModel model)
{
string[] tag = new string[model.Count];
for (int i = 0; i < model.Count; i++)
{
tag[i] = model[i].TagName;
}
return(string.Join(",", tag));
}
/// <summary>
/// �±� ����
/// </summary>
/// <param name="cmd"></param>
/// <param name="articleNo"></param>
/// <param name="bindModel"></param>
/// <returns></returns>
public static bool InsertTag(SqlCommand cmd, int articleNo, TagBindModel bindModel)
{
try
{
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UAT_InsertTag";
foreach( TagModel model in bindModel )
{
cmd.Parameters.Add("@ArticleNo", SqlDbType.Int,4);
cmd.Parameters.Add("@TagName", SqlDbType.VarChar,50);
cmd.Parameters["@ArticleNo"].Value = articleNo;
cmd.Parameters["@TagName"].Value = model.TagName.Trim();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
return true;
}
catch (Exception ex)
{
throw new UmcDataException("UAT_InsertTag ���ν��� ȣ���� ����", ex);
}
}
/// <summary>
/// �±� ����Ʈ�� �����´�.
/// </summary>
/// <returns></returns>
public static TagBindModel GetTagList()
{
SqlCommand cmd = GetSpCommand("UAT_GetTagList");
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
TagBindModel bindModel = null;
try
{
bindModel = new TagBindModel();
while (reader.Read())
{
bindModel.Add(new TagModel(reader["TagName"].ToString()));
}
return bindModel;
}
finally
{
ReleaseCommand(cmd);
}
}
private void init()
{
bindModel = ArticleManager.GetInstance().GetTagList();
}
