Ejemplo n.º 1
0
 public void Update(M_LbCategory model)
 {
     SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@Name", SqlDbType.NVarChar), new SqlParameter("@ParentID", SqlDbType.Int), new SqlParameter("@Desc", SqlDbType.NVarChar), new SqlParameter("@LbCategoryID", SqlDbType.Int) };
     commandParameters[0].Value = model.Name;
     commandParameters[1].Value = model.ParentID;
     commandParameters[2].Value = model.Desc;
     commandParameters[3].Value = model.LbCategoryID;
     SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_LbCategory_Update", commandParameters);
 }
Ejemplo n.º 2
0
 public int Add(M_LbCategory model)
 {
     SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("Name", SqlDbType.NVarChar), new SqlParameter("ParentID", SqlDbType.Int), new SqlParameter("Desc", SqlDbType.NVarChar), new SqlParameter("@LbCategoryID", SqlDbType.Int, 4) };
     commandParameters[0].Value = model.Name;
     commandParameters[1].Value = model.ParentID;
     commandParameters[2].Value = model.Desc;
     commandParameters[3].Direction = ParameterDirection.Output;
     SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "UP_LbCategory_ADD", commandParameters);
     return (int) commandParameters[3].Value;
 }
Ejemplo n.º 3
0
 public M_LbCategory GetLabeCategoryIdData(int lbCategoryId)
 {
     SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@LbCategoryID", SqlDbType.Int) };
     commandParameters[0].Value = lbCategoryId;
     DataTable table = SqlHelper.ExecuteTable(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_LbCategory_GetIdData", commandParameters);
     if (table.Rows.Count > 0)
     {
         M_LbCategory category = new M_LbCategory();
         category.Name = table.Rows[0]["Name"].ToString();
         category.Desc = table.Rows[0]["Desc"].ToString();
         return category;
     }
     return null;
 }
Ejemplo n.º 4
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            M_LbCategory m_LbCategory = new M_LbCategory();
            m_LbCategory.Name = txtLabelTypeName.Text.Trim();
            m_LbCategory.ParentID = int.Parse(dropLabelType.SelectedValue.ToString());
            m_LbCategory.Desc = txtExplain.Text.Trim();
            B_LbCategory b_Lbcategory = new B_LbCategory();
            B_KyCommon bllCom = new B_KyCommon();
            bool flag = false;
            flag = bllCom.CheckHas(m_LbCategory.Name, "Name", "KyLbCategory");
            if (btnSave.Text == "修改类别")
            {
                m_LbCategory.LbCategoryID=int.Parse(Request.QueryString["lbCategoryId"].ToString());
                B_LbCategory bll = new B_LbCategory();
                bll.Update(m_LbCategory);
                Response.Redirect(SkipPageUrl);
            }
            else
            {
                if (!flag)
                {
                    b_Lbcategory.Add(m_LbCategory);
                    Response.Redirect(SkipPageUrl);
                }
                else
                    Response.Write("<script>alert('己存在此标签名称')</script>");
            }

        }
        catch
        {
            Response.Write("<script>alert('操作有误')</script>");
        }
    }
Ejemplo n.º 5
0
 public void Update(M_LbCategory model)
 {
     this.ilbcategory.Update(model);
 }
Ejemplo n.º 6
0
 public int Add(M_LbCategory model)
 {
     return this.ilbcategory.Add(model);
 }