Sry.Solution.Data/ManMesData.Designer.cs

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

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

using Sry.Framework.Dal;
using System.Data.SqlClient;
using System.Data;
using Sry.Entity;
namespace Sry.Data{
   /// <summary>
   /// IManMesData接口 author:Sry
   /// </summary>
   public partial interface IManMesData{
       int Add(ManMes instance);
       bool Delete(ManMes instance, int option);
       bool Update(ManMes instance, int option);
       DataSet Select(ManMes instance, int option, ref QueryParams pageParam);
       ManMes Get(ManMes instance, int option);
   }
   public partial class ManMesData{
      public int Add(ManMes instance){
         
         string sql = @"insert into [ManMes] (
         [fatherID],[name],[relation],[sex],[cards],[juzhuYear],[hujiLocal],[isAlways])
          values (@fatherID,@name,@relation,@sex,@cards,@juzhuYear,@hujiLocal,@isAlways);
         select SCOPE_IDENTITY()";
         SqlParameter[] sps = new SqlParameter[] {
            new SqlParameter("@fatherID",instance.fatherID),
            new SqlParameter("@name",instance.name),
            new SqlParameter("@relation",instance.relation),
            new SqlParameter("@sex",instance.sex),
            new SqlParameter("@cards",instance.cards),
            new SqlParameter("@juzhuYear",instance.juzhuYear),
            new SqlParameter("@hujiLocal",instance.hujiLocal),
            new SqlParameter("@isAlways",instance.isAlways)};
         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) {
          throw;
         };
      }
      public bool Delete(ManMes instance,int option) {
         
         SqlParameter[] sps = null;
         string sql = string.Empty;
         switch (option){
            case 0:
                sps = new SqlParameter[] { new SqlParameter("@id",instance.id) };
                sql = "delete from [ManMes] where [id] = @id";
            break;
             case 1:
                 sps = new SqlParameter[] { new SqlParameter("@fatherid",instance.fatherID) };
                 sql = "delete from [ManMes] where [fatherID] = @fatherid";
                 break;
         }
         try