OA.DAL/Email_shoujianService.cs

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

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

//============================================================
// Producnt name:		TenXiang.Code
// Coded by:			hotboart
// Auto generated at: 	2014-3-20 15:36:02
//============================================================



using System;						
using System.Collections.Generic;	
using System.Text;					
using System.Data;					
using System.Data.SqlClient;		
using OA.Models;



namespace OA.DAL
{								

	public static partial class Email_shoujianService
	{	
		//Add Mothed Start
		public static readonly string InsertSql = "INSERT Email_shoujian (shoujianId, emailId, time, State, IsDel)VALUES (@shoujianId, @emailId, @time, @State, @IsDel)";
		public static readonly string UpdateSql = "Update Email_shoujian set shoujianId=@shoujianId, emailId=@emailId, time=@time, State=@State, IsDel=@IsDel where Id=@Id";
		public static readonly string DeleteSql = "Delete FROM Email_shoujian  where Id=@Id";
		public static readonly string SelectSql = "Select * FROM Email_shoujian";
		public static readonly string SelectSqlById = "Select * FROM Email_shoujian where Id =@Id";
	    public static int AddEmail_shoujian(Email_shoujian email_shoujian)
	    {								
			string sql = InsertSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@shoujianId",email_shoujian.ShoujianId), new SqlParameter("@emailId",email_shoujian.EmailId), new SqlParameter("@time",email_shoujian.Time), new SqlParameter("@State",email_shoujian.State), new SqlParameter("@IsDel",email_shoujian.IsDel)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}  
		public static int UpdateEmail_shoujian(Email_shoujian email_shoujian)
	    {								
			string sql = UpdateSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@id",email_shoujian.Id), new SqlParameter("@shoujianId",email_shoujian.ShoujianId), new SqlParameter("@emailId",email_shoujian.EmailId), new SqlParameter("@time",email_shoujian.Time), new SqlParameter("@State",email_shoujian.State), new SqlParameter("@IsDel",email_shoujian.IsDel)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}  
		public static int DelEmail_shoujian(Email_shoujian email_shoujian)
	    {								
			string sql = DeleteSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@id",email_shoujian.Id)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}
		public static IList< Email_shoujian > GetAllList()
		{
            string sql = SelectSql + " where isdel=0 order by time desc";
    	    return GetListBySql(sql);
		}