示例#1
0
        public NV_Menu_ChiTiet GetById(int id)
        {
            using (SqlConnection myConnection = new SqlConnection(ConnectionString))
            {
                using (SqlCommand myCommand = new SqlCommand("NV_Menu_getByID", myConnection))
                {
                    myCommand.CommandType = CommandType.StoredProcedure;

                    SqlParameter pID = new SqlParameter("@id", SqlDbType.Int);
                    pID.Value = id;
                    myCommand.Parameters.Add(pID);

                    DataTable       dt;
                    NV_Menu_ChiTiet model = new NV_Menu_ChiTiet();

                    myConnection.Open();
                    using (SqlDataAdapter mData = new SqlDataAdapter(myCommand))
                    {
                        dt = new DataTable();
                        mData.Fill(dt);
                    }
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        model = new NV_Menu_ChiTiet(dt);
                    }
                    return(model);
                }
            }
        }
示例#2
0
        public NV_Menu_ChiTiet GetByUrl(string url)
        {
            string          sql  = "select top 1 *,dbo.getUrl(MenuID,'Menu',null) as UrlFull from Menu where Duyet=1 and TenUrl='" + url + "'";
            DataTable       dt   = Sys_Common.getDataByQuery(sql);
            NV_Menu_ChiTiet menu = new NV_Menu_ChiTiet();

            if (dt != null && dt.Rows.Count > 0)
            {
                menu = new NV_Menu_ChiTiet(dt);
            }
            return(menu);
        }
示例#3
0
 public int getLevel(int menuCha)
 {
     try
     {
         NV_Menu_ChiTiet ct = GetById(menuCha);
         return(ct.Level + 1);
     }
     catch
     {
         return(1);
     }
 }
示例#4
0
        public bool update(NV_Menu_ChiTiet model)
        {
            using (SqlConnection myConnection = new SqlConnection(ConnectionString))
            {
                using (SqlCommand myCommand = new SqlCommand("NV_Menu_update", myConnection))
                {
                    myCommand.CommandType = CommandType.StoredProcedure;

                    SqlParameter pID = new SqlParameter("@MenuID", SqlDbType.Int);
                    pID.Value = model.MenuID;
                    myCommand.Parameters.Add(pID);

                    SqlParameter pTenMenu = new SqlParameter("@TenMenu", SqlDbType.NVarChar, 250);
                    pTenMenu.Value = model.TenMenu;
                    myCommand.Parameters.Add(pTenMenu);

                    SqlParameter pFrameViewID = new SqlParameter("@ChucNangID", SqlDbType.Int);
                    pFrameViewID.Value = model.ChucNangID;
                    myCommand.Parameters.Add(pFrameViewID);

                    SqlParameter pUrl = new SqlParameter("@Url", SqlDbType.NVarChar, 250);
                    pUrl.Value = model.Url;
                    myCommand.Parameters.Add(pUrl);

                    SqlParameter pTenUrl = new SqlParameter("@TenUrl", SqlDbType.NVarChar, 250);
                    pTenUrl.Value = model.TenUrl;
                    myCommand.Parameters.Add(pTenUrl);

                    SqlParameter pDuyet = new SqlParameter("@Duyet", SqlDbType.Bit);
                    pDuyet.Value = model.Duyet;
                    myCommand.Parameters.Add(pDuyet);

                    SqlParameter pNoiBat = new SqlParameter("@NoiBat", SqlDbType.Bit);
                    pNoiBat.Value = model.NoiBat;
                    myCommand.Parameters.Add(pNoiBat);

                    SqlParameter pStt = new SqlParameter("@Stt", SqlDbType.Int);
                    pStt.Value = model.Stt;
                    myCommand.Parameters.Add(pStt);

                    SqlParameter pVitri = new SqlParameter("@Vitri", SqlDbType.Int);
                    pVitri.Value = model.Vitri;
                    myCommand.Parameters.Add(pVitri);

                    SqlParameter pLevel = new SqlParameter("@Level", SqlDbType.Int);
                    pLevel.Value = model.Level;
                    myCommand.Parameters.Add(pLevel);

                    SqlParameter pParentID = new SqlParameter("@ParentID", SqlDbType.Int);
                    pParentID.Value = model.ParentID;
                    myCommand.Parameters.Add(pParentID);

                    SqlParameter pPageTitle = new SqlParameter("@PageTitle", SqlDbType.NVarChar, 200);
                    pPageTitle.Value = model.PageTitle;
                    myCommand.Parameters.Add(pPageTitle);

                    SqlParameter pMetaKeyword = new SqlParameter("@MetaKeyword", SqlDbType.NVarChar, 200);
                    pMetaKeyword.Value = model.MetaKeyword;
                    myCommand.Parameters.Add(pMetaKeyword);

                    SqlParameter pMetaDescription = new SqlParameter("@MetaDescription", SqlDbType.NVarChar, 300);
                    pMetaDescription.Value = model.MetaDescription;
                    myCommand.Parameters.Add(pMetaDescription);

                    SqlParameter pMota = new SqlParameter("@Mota", SqlDbType.NVarChar, 300);
                    pMota.Value = model.Mota;
                    myCommand.Parameters.Add(pMota);

                    SqlParameter pHinhAnh = new SqlParameter("@HinhAnh", SqlDbType.Int, 300);
                    pHinhAnh.Value = model.HinhAnh;
                    myCommand.Parameters.Add(pHinhAnh);

                    SqlParameter pLang = new SqlParameter("@Lang", SqlDbType.VarChar);
                    pLang.Value = model.Lang;
                    myCommand.Parameters.Add(pLang);


                    try
                    {
                        myConnection.Open();
                        myCommand.ExecuteNonQuery();
                        return(true);
                    }
                    catch
                    {
                        return(false);
                    }
                }
            }
        }