Sry.Solution.Data/PurviewsData.Designer.cs

（开头部分） 5KB

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

using System.Data.SqlClient;
using System.Data;
using Sry.Entity;
using Sry.Framework.Dal;
namespace Sry.Data{
   /// <summary>
   /// IPurviewsData接口 author:Sry
   /// </summary>
   public partial interface IPurviewsData{
       int Add(Purviews instance);
       bool Delete(Purviews instance, int option);
       bool Update(Purviews instance, int option);
       DataSet Select(Purviews instance, int option, ref QueryParams pageParam);
       Purviews Get(Purviews instance, int option);
   }
   public partial class PurviewsData{
      public int Add(Purviews instance){
         
         string sql = @"insert into [Purviews] (
         [pur_FatherID],[pur_Name],[pur_MenuURL])
          values (@pur_FatherID,@pur_Name,@pur_MenuURL);
         select SCOPE_IDENTITY()";
         SqlParameter[] sps = new SqlParameter[] {
            new SqlParameter("@pur_FatherID",instance.pur_FatherID),
            new SqlParameter("@pur_Name",instance.pur_Name),
            new SqlParameter("@pur_MenuURL",instance.pur_MenuURL)};
         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(Purviews instance,int option) {
         
         SqlParameter[] sps = null;
         string sql = string.Empty;
         switch (option){
            case 0:
                sps = new SqlParameter[] { new SqlParameter("@pur_ID",instance.pur_ID) };
                sql = "delete from [Purviews] where [pur_ID] = @pur_ID";
            break;

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

              if (size < 1) {
                   
                   return false;
              }
          }
          catch(SqlException ex) {
后面还有 100 行代码，购买后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。