kdbaaaaa.a

人事管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using MODEL;
using DBManage;
using IDAL;


namespace SQLServerDAL
{
    public class FileInfoService : IFileInfoService
    {
        #region IBaseService<FileInfo> 成员


        private static List<FileInfo> GetModelsFromDataSet(DataSet ds)
        {
            List<FileInfo> ls = new List<FileInfo>();
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                FileInfo model = new FileInfo();
                model.FileId= Convert.ToInt32(row[0]);
                model.FileName = Convert.ToString(row[1]);
                model.FileType = Convert.ToInt32(row[2]);
                model.Remark = Convert.ToString(row[3]);
                model.FileOwner = Convert.ToString(row[4]);
                model.CreateDate = Convert.ToString(row[5]);
                model.ParentId = Convert.ToInt32(row[6]);
                model.FilePath = Convert.ToString(row[7]);
                model.IfDelete = Convert.ToInt32(row[8]);
                ls.Add(model);
            }
            return ls;
        }

        public int AddModel(FileInfo model)
        {
            string sql = string.Format("insert into FileInfo values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')",   model.FileName ,model.FileType,
                model.Remark ,
                model.FileOwner,
                model.CreateDate,
                model.ParentId,
                model.FilePath,
                model.IfDelete);
            return DBOperate.UpdateModel(sql);
        }

        public int DeleteModelById(int id)
        {
            string where = " FileId=" + id;
            return DeleteModelByWhere(where);
        }

        public int DeleteModelByWhere(string where)
        {
            string sql = string.Format("delete FileInfo");
            if (!string.IsNullOrEmpty(where))
            {
                sql = sql + " where " + where;
            }
            return DBOperate.UpdateModel(sql);
        }

        public int UpdateModel(FileInfo model)
        {
            string something = string.Format(" FileName='{0}',FileType='{1}',Remark='{2}',FileOwner='{3}',FileOwner='{4}',CreateDate='{5}',ParentId='{6}',FilePath='{7}', IfDelete='{8}'", model.FileName, model.FileType,
                model.Remark,
                model.FileOwner,
                model.CreateDate,
                model.ParentId,
                model.FilePath,
                model.IfDelete);
            string where = string.Format(" FileId={0} ", model.FileId);
            return UpdateSomethingByWhere(something, where);
        }

        public int UpdateSomethingByWhere(string something, string where)
        {
            string sql = "update FileInfo set " + something;
            if (!string.IsNullOrEmpty(where))
            {
                sql = sql + " where " + where;
            }
            return DBOperate.UpdateModel(sql);
        }

        public List<FileInfo> GetAllModels()
        {
            DataSet ds = DBOperate.GetModels("FileInfo", "");
            return GetModelsFromDataSet(ds);
        }

        public FileInfo GetModelById(int id)
        {
            DataSet ds = DBOperate.GetModels("FileInfo", "FileId=" + id);
            return GetModelsFromDataSet(ds)[0];
        }

        public List<FileInfo> GetModelByForeignKey(int ForeignKeyID)
        {
            throw new Exception("The method or operation is not implemented.");
        }

        public List<FileInfo> GetModels(string strWhere)
        {
            DataSet ds = DBOperate.GetModels("FileInfo", strWhere);
            return GetModelsFromDataSet(ds);
        }

        public List<FileInfo> GetModels(int pageIndex, int pageSize, string orderColumnsName, string strWhere)
        {
            DataSet ds = DBOperate.GetModels("FileInfo", pageIndex, pageSize, orderColumnsName, strWhere);
            return GetModelsFromDataSet(ds);
        }

        public List<FileInfo> GetModels(int pageIndex, int pageSize, string orderColumnsName)
        {
            return GetModels(pageIndex, pageSize, orderColumnsName, "");
        }

        public List<FileInfo> GetModels(int pageIndex, string orderColumnsName)
        {
            return GetModels(pageIndex, 10, orderColumnsName, "");
        }

        public List<FileInfo> GetModels(int pageIndex, int pageSize)
        {
            return GetModels(pageIndex, pageSize, "FileId", "");
        }

        public List<FileInfo> GetModels(int pageIndex)
        {
            return GetModels(pageIndex, 10, "FileId", "");
        }

        #endregion
    }
}