DAL/DALhelp.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;

using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
namespace DAL
{
   public  class DALhelp
    {
       public int inserthelp(Help help)
       {
           StringBuilder sql = new StringBuilder();
           sql.Append("insert into help values(@title,@content,@cateid)");

           SqlParameter[] pra = {
                                new SqlParameter("@title",SqlDbType.VarChar,50),
                                new SqlParameter("@content",SqlDbType.VarChar,0),
                                new SqlParameter("@cateid",SqlDbType.Int,4)
                               };
           pra[0].Value = help.Title;
           pra[1].Value =help.Content;
           pra[2].Value = help.Cateid;

           return Common.DbHelperSQL.ExecuteSql(sql.ToString(), pra);
       
       }

       public DataSet select(int pageindex, int pagesize, string table)
       {
           string sqlstr = "select * from help order by _cateid asc";

           DataSet ds = Common.DB.PagedataSet(sqlstr, pageindex, pagesize, table);
           return ds;
       
       }

       public int delete(Help help)
       {
           StringBuilder sql = new StringBuilder();
           sql.Append("delete from help where _id=@id");

           SqlParameter[] pra = {
                                new SqlParameter("@id",SqlDbType.Int,4)
                                
                                };

           pra[0].Value = help.ID;

           return Common.DbHelperSQL.ExecuteSql(sql.ToString(),pra);
       
       }

        //删除help分类删除对应的help信息
        public int deletebyhcate(Model.Helpcate hcate)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("delete from help where _cateid=@id");