MyOAExx/OA.DAL/FileInfoService.cs

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

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

//============================================================
// Producnt name:		TenXiang.Code
// Coded by:			hotboart
// Auto generated at: 	2014/1/5 11:45:40
//============================================================



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 FileInfoService
	{	
		//Add Mothed Start
		public static readonly string InsertSql = "INSERT FileInfo (FileName, FileType, Remark, FileOwner, CreateDate, ParentId, FilePath, IfDelete)VALUES (@FileName, @FileType, @Remark, @FileOwner, @CreateDate, @ParentId, @FilePath, @IfDelete)";
		public static readonly string UpdateSql = "Update FileInfo set FileName=@FileName, FileType=@FileType, Remark=@Remark, FileOwner=@FileOwner, CreateDate=@CreateDate, ParentId=@ParentId, FilePath=@FilePath, IfDelete=@IfDelete where FileId=@FileId";
		public static readonly string DeleteSql = "Delete FROM FileInfo  where FileId=@FileId";
		public static readonly string SelectSql = "Select * FROM FileInfo";
		public static readonly string SelectSqlById = "Select * FROM FileInfo where FileId =@FileId";
	    public static int AddFileInfo(FileInfo fileInfo)
	    {								
			string sql = InsertSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@FileName",fileInfo.FileName), new SqlParameter("@FileType",fileInfo.FileType), new SqlParameter("@Remark",fileInfo.Remark), new SqlParameter("@FileOwner",fileInfo.FileOwner), new SqlParameter("@CreateDate",fileInfo.CreateDate), new SqlParameter("@ParentId",fileInfo.ParentId), new SqlParameter("@FilePath",fileInfo.FilePath), new SqlParameter("@IfDelete",fileInfo.IfDelete)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}  
		public static int UpdateFileInfo(FileInfo fileInfo)
	    {								
			string sql = UpdateSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@FileId",fileInfo.FileId), new SqlParameter("@FileName",fileInfo.FileName), new SqlParameter("@FileType",fileInfo.FileType), new SqlParameter("@Remark",fileInfo.Remark), new SqlParameter("@FileOwner",fileInfo.FileOwner), new SqlParameter("@CreateDate",fileInfo.CreateDate), new SqlParameter("@ParentId",fileInfo.ParentId), new SqlParameter("@FilePath",fileInfo.FilePath), new SqlParameter("@IfDelete",fileInfo.IfDelete)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}  
		public static int DelFileInfo(FileInfo fileInfo)
	    {								
			string sql = DeleteSql;
            SqlParameter[] para = new SqlParameter[]
           						  {
										new SqlParameter("@FileId",fileInfo.FileId)
								  }	;									
    	    return DBHelper.ExecNonQuery(sql, para);
		}
		public static IList< FileInfo > GetAllList()
		{								
			string sql = SelectSql;
    	    return GetListBySql(sql);
		}