DAL/procate.cs

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

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

using System;
using System.Collections.Generic;

using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
   public class procate
    {
       public int Insert(Model.procate model)
       {


           StringBuilder sql = new StringBuilder();

           sql.Append("insert into procate ");

           sql.Append(" values (");

           sql.Append("@catename,@fathercateid");

           sql.Append(")");

           SqlParameter[] par = {
                              new SqlParameter("@catename",SqlDbType.VarChar,50),
                              new SqlParameter("@fathercateid",SqlDbType.Int,4),
                             
                             
                             };


           par[0].Value = model.catename;
           par[1].Value = model.fathercateid;
         





           return Common.DbHelperSQL.ExecuteSql(sql.ToString(), par);

       }
       public DataSet dataset()
       {
           StringBuilder sql = new StringBuilder();

           sql.Append("select * from procate");

           return Common.DbHelperSQL.Query(sql.ToString());
 
       }
       public DataSet data_set()
       {
           StringBuilder sql = new StringBuilder();

           sql.Append("select * from procate,fathercate where procate._fathercateid=fathercate._fathercateid");

           return Common.DbHelperSQL.Query(sql.ToString());