DAL/KaoShengDAL.cs

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

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

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
namespace DAL
{
   public class KaoShengDAL
    {
       public static ArrayList getSpecKaoShengInfo(int pageNo, int pageSize)
       {
           SQLHelper sqh = new SQLHelper();
           SqlParameter[] para = new SqlParameter[] { new SqlParameter("@pageNo", SqlDbType.Int), new SqlParameter("@pageSize", SqlDbType.Int), new SqlParameter("@recordCount", SqlDbType.Int), new SqlParameter("RowCount", SqlDbType.Int) };
           para[0].Value = pageNo;
           para[1].Value = pageSize;
           para[2].Direction = ParameterDirection.Output;
           para[3].Direction = ParameterDirection.ReturnValue;
           try
           {
               ArrayList  arrylist = sqh.GetArrayList(para, "Pro_selectSpecKaoShengInfo");
               return arrylist;
           }
           catch (Exception ex)
           {
               throw ex;
           }
       }
       public static int deleteKaoShengInfo(string strCode)
       {
           SQLHelper sqh = new SQLHelper();
           SqlParameter[] para = new SqlParameter[] { new SqlParameter("@zkCode", SqlDbType.NVarChar ,20)};
           para[0].Value = strCode;
           try
           {
               int result = sqh.ExecuteNonQuery(para, "Pro_deleteKaoShengInfo");
               return result;
           }
           catch(Exception ex)
           {
               throw ex;
           }
       }
       public static int insertKaoShengInfo(KaoShengMOD ksmod)
       {
           SQLHelper sqh = new SQLHelper();
           SqlParameter[] para = new SqlParameter[] { new SqlParameter("@zkCode", SqlDbType.NVarChar, 20), new SqlParameter("@name", SqlDbType.NVarChar, 20),
           new SqlParameter("@sex", SqlDbType.NVarChar, 2),new SqlParameter("@IDcard", SqlDbType.NVarChar, 20),new SqlParameter("@Tel", SqlDbType.NVarChar, 15),
           new SqlParameter("@address", SqlDbType.NVarChar, 100),new SqlParameter("@photoUrl", SqlDbType.NVarChar, 20),new SqlParameter("@beiZhu", SqlDbType.NVarChar, 100),
           new SqlParameter("@subject", SqlDbType.NVarChar, 100)};
           para[0].Value = ksmod.ZkCode;
           para[1].Value = ksmod.Name;
           para[2].Value = ksmod.Sex;
           para[3].Value = ksmod.IDCard;
           para[4].Value = ksmod.Tel;
           para[5].Value = ksmod.Address;
           para[6].Value = ksmod.PhotoUrl;
           para[7].Value = ksmod.Beizhu;