Sry.Solution.Data/RolesData.Designer.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using Sry.Entity;
using Sry.Framework.Dal;
namespace Sry.Data{
   /// <summary>
   /// IRolesData接口 author:Sry
   /// </summary>
   public partial interface IRolesData{
       int Add(Roles instance);
       bool Delete(Roles instance, int option);
       bool Update(Roles instance, int option);
       DataSet Select(Roles instance, int option, ref QueryParams pageParam);
       Roles Get(Roles instance, int option);
   }
   public partial class RolesData{
      public int Add(Roles instance){
         
         string sql = @"insert into [Roles] (
         [roles_Name],[roles_CreateTime])
          values (@roles_Name,@roles_CreateTime);
         select SCOPE_IDENTITY()";
         SqlParameter[] sps = new SqlParameter[] {
            new SqlParameter("@roles_Name",instance.roles_Name),
            new SqlParameter("@roles_CreateTime",instance.roles_CreateTime)};
         try{
             int size=0;
             size = int.Parse(SqlHelper.ExecuteScalar(SQLConfig.MainLink,CommandType.Text,sql,sps).ToString().Trim());
             if(size==0){
                 
                 return -1;              
             }
             return size;
         }   
         catch (SqlException ex) {
          throw;
         };
      }
      public bool Delete(Roles instance,int option) {
         
         SqlParameter[] sps = null;
         string sql = string.Empty;
         switch (option){
            case 0:
                sps = new SqlParameter[] { new SqlParameter("@roles_ID",instance.roles_ID) };
                sql = "delete from [Roles] where [roles_ID] = @roles_ID";
            break;

         }
         try
         {
              int size = SqlHelper.ExecuteNonQuery(SQLConfig.MainLink, System.Data.CommandType.Text, sql, sps);

              if (size < 1) {
                   
                   return false;