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