/// <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);
}
// 카테고리 중분류를 바인딩
private void CategoryMCodeBind(int mCode)
{
ddlCategoryM.Items.Clear();
ddlCategoryM.Items.Add(new ListItem("---중분류---", "-1"));
if (mCode == -1)
{
return;
}
CategoryCodeModel cateCode = CategoryManager.GetInstance().GetCategoryCodes(mCode);
for (int i = 0; i < cateCode.CategoryMCode.Count; i++)
{
ddlCategoryM.Items.Add(new ListItem(cateCode.CategoryMCode[i].CategoryTitle, cateCode.CategoryMCode[i].CategoryCode.ToString()));
}
CategoryModel cateModel = modelTree[lbCategory.SelectedIndex];
ddlCategoryM.SelectedValue = cateModel.CategoryMCode.ToString();
}
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()));
}
}
