/// <summary> /// ī�װ�� �ڵ带 �����´� /// </summary> /// <param name="lcode">��з� �ڵ� ������� -1</param> /// <returns></returns> public static CategoryCodeModel GetCategoryCodes(int lCode) { SqlParameter[] param = { CreateInParam("@LCode", SqlDbType.Int,4, lCode) }; SqlCommand cmd = GetSpCommand("UBI_GetCategoryCodes", param); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); CategoryCodeModel code = new CategoryCodeModel(); while (reader.Read()) { code.Add( new CategoryCodeModel( (int)reader["CategoryLCode"], reader["CategoryLTitle"].ToString())); } if (reader.NextResult()) { code.CreateCategoryMCode(); while (reader.Read()) { code.CategoryMCode.Add(new CategoryCodeModel( (int)reader["CategoryMCode"], reader["CategoryMTitle"].ToString())); } } ReleaseCommand(cmd); return code; }
public void Add(CategoryCodeModel code) { items.Add(code); }
public CategoryCodeModel CreateCategoryMCode() { _categoryMCode = new CategoryCodeModel(); return(_categoryMCode); }
public CategoryCodeModel CreateCategoryMCode() { _categoryMCode = new CategoryCodeModel(); return _categoryMCode; }
public void Add(CategoryCodeModel code ) { items.Add( code ); }
private void bind() { txtCategoryTitle.Text = string.Empty; treePreviewMenu.Nodes.Clear(); lbCategory.Items.Clear(); modelTree.Bind( treePreviewMenu ); modelList = CategoryManager.GetInstance().GetMyCategorys(typeof(CategoryListBox)); modelList.Bind( lbCategory ); ddlCategory.Items.Clear(); ddlCategory.Items.Add( new ListItem("---선택---", "-1") ); for (int i = 0; i < modelList.Count; i++) { if( modelList[i].CategoryStep == 1) ddlCategory.Items.Add( new ListItem(modelList[i].CategoryTitle, modelList[i].CategoryGroup.ToString() )); } lCodeIndex = lbCategory.SelectedIndex; cateCode = CategoryManager.GetInstance().GetCategoryCodes( lCodeIndex); ddlCategoryL.Items.Clear(); ddlCategoryL.Items.Add(new ListItem("---대분류---", "-1")); for (int i = 0; i < cateCode.Count; i++) ddlCategoryL.Items.Add(new ListItem(cateCode[i].CategoryTitle, cateCode[i].CategoryCode.ToString())); ddlCategoryM.Items.Clear(); ddlCategoryM.Items.Add(new ListItem("---중분류---", "-1")); for (int i = 0; i < cateCode.CategoryMCode.Count; i++) ddlCategoryM.Items.Add(new ListItem(cateCode.CategoryMCode[i].CategoryTitle, cateCode.CategoryMCode[i].CategoryCode.ToString())); }