Sry.Solution.Data/DataDicData.Designer.cs

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

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

//------------------------------------------------------------------------------
// <auto-generated>
//     开发人员: Sry
//     代码用途: 数据访问层
//     创建时间：2014年07月24日 05时26分
// </auto-generated>
//------------------------------------------------------------------------------
using System.Data.SqlClient;
using System.Data;
using Sry.Entity;
using Sry.Framework.Dal;
namespace Sry.Data{
   /// <summary>
   /// IDataDicData接口 author:Sry
   /// </summary>
   public partial interface IDataDicData{
       int Add(DataDic instance);
       bool Delete(DataDic instance, int option);
       bool Update(DataDic instance, int option);
       DataSet Select(DataDic instance, int option, ref QueryParams pageParam);
       DataDic Get(DataDic instance, int option);
   }
   public partial class DataDicData{
      public int Add(DataDic instance){
         string sql = @"insert into [DataDic] (
         [dd_FatherID],[dd_Name],[dd_Value],[dd_Active],[dd_Order],[dd_Remark],[dd_IsType])
          values (@dd_FatherID,@dd_Name,@dd_Value,@dd_Active,@dd_Order,@dd_Remark,@dd_IsType);
         select SCOPE_IDENTITY()";
         SqlParameter[] sps = new SqlParameter[] {
            new SqlParameter("@dd_FatherID",instance.dd_FatherID),
            new SqlParameter("@dd_Name",instance.dd_Name),
            new SqlParameter("@dd_Value",instance.dd_Value),
            new SqlParameter("@dd_Active",instance.dd_Active),
            new SqlParameter("@dd_Order",instance.dd_Order),
            new SqlParameter("@dd_Remark",instance.dd_Remark),
            new SqlParameter("@dd_IsType",instance.dd_IsType)
         };
         try{
             int size=0;
             size = int.Parse(SqlHelper.ExecuteScalar(SQLConfig.MainLink,CommandType.Text,sql,sps).ToString().Trim());
             if(size==0){
                 //**result = "-1";
                 return -1;              
             }
             return size;
         }   
         catch{
          throw;
         };
      }
      public bool Delete(DataDic instance,int option) {
         SqlParameter[] sps = null;
         string sql = string.Empty;
         switch (option){
            case 0:
                sps = new SqlParameter[] { new SqlParameter("@dd_ID",instance.dd_ID) };
                sql = "delete from [DataDic] where [dd_ID] = @dd_ID";
            break;
         }
         try