Ejemplo n.º 1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(VAN_OA.Model.OA.tb_File model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into tb_File(");
            strSql.Append("fileName,fileURL,fileFullName,createTime,createPer");
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append("'" + model.fileName + "',");
            strSql.Append("'" + model.fileURL + "',");
            strSql.Append("'" + model.fileFullName + "',");
            strSql.Append("'" + model.createTime + "',");
            strSql.Append("'" + model.createPer + "'");
            strSql.Append(")");
            strSql.Append(";select @@IDENTITY");

            int    result;
            object obj = DBHelp.ExeScalar(strSql.ToString());           // db.ExecuteScalar(dbCommand);

            if (!int.TryParse(obj.ToString(), out result))
            {
                return(0);
            }
            return(result);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 查询文件夹 包括子文件夹下的所有文件
        /// </summary>
        /// <param name="dir"></param>
        public void ExploreDirectory(DirectoryInfo dir)
        {
            for (int i = 0; i < indentLevel; i++)
            {
                Console.WriteLine(" ");
            }
            Console.WriteLine("[{0}][{1}][{2}]\n", indentLevel, dir.Name, dir.LastAccessTime);
            FileInfo[] filesInDir = dir.GetFiles();

            foreach (FileInfo file in filesInDir)
            {
                for (int i = 0; i < indentLevel + 1; i++)
                {
                    Console.Write(" ");
                }
                tb_File file1 = new tb_File();
                file1.fileURL  = file.FullName;
                file1.fileName = file.Name;
                Files.Add(file1);
                fileCounter++;
            }
            DirectoryInfo[] directories = dir.GetDirectories();
            foreach (DirectoryInfo newDir in directories)
            {
                dirCounter++;
                ExploreDirectory(newDir);
            }
            indentLevel--;
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 只查询指定文件夹下面的文件
        /// </summary>
        /// <param name="dir"></param>
        public void ExploreDirectory_2(DirectoryInfo dir)
        {
            FileInfo[] filesInDir = dir.GetFiles();

            foreach (FileInfo file in filesInDir)
            {
                tb_File file1 = new tb_File();
                file1.fileURL  = file.FullName;
                file1.fileName = file.Name;
                Files.Add(file1);
            }
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(VAN_OA.Model.OA.tb_File model)
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("update tb_File set ");
                strSql.Append("fileName='" + model.fileName + "',");
                strSql.Append("fileURL='" + model.fileURL + "',");
                strSql.Append("fileFullName='" + model.fileFullName + "',");
                strSql.Append("createTime='" + model.createTime + "',");
                strSql.Append("createPer='" + model.createPer + "'");
                strSql.Append(" where id=" + model.id + " ");

                DBHelp.ExeCommand(strSql.ToString());
                return(true);
            }
            catch (Exception)
            {
                return(false);
            }
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 对象实体绑定数据
        /// </summary>
        public VAN_OA.Model.OA.tb_File ReaderBind(IDataReader dataReader)
        {
            VAN_OA.Model.OA.tb_File model = new VAN_OA.Model.OA.tb_File();
            object ojb;

            ojb = dataReader["id"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.id = (int)ojb;
            }
            model.fileName     = dataReader["fileName"].ToString();
            model.fileURL      = dataReader["fileURL"].ToString();
            model.fileFullName = dataReader["fileFullName"].ToString();
            ojb = dataReader["createTime"];
            if (ojb != null && ojb != DBNull.Value)
            {
                model.createTime = (DateTime)ojb;
            }
            model.createPer = dataReader["createPer"].ToString();
            return(model);
        }
Ejemplo n.º 6
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public VAN_OA.Model.OA.tb_File GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select   ");
            strSql.Append(" * ");
            strSql.Append(" from tb_File ");
            strSql.Append(" where id=" + id + " ");

            VAN_OA.Model.OA.tb_File model = null;
            using (SqlConnection conn = DBHelp.getConn())
            {
                conn.Open();
                SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
                using (SqlDataReader objReader = objCommand.ExecuteReader())
                {
                    if (objReader.Read())
                    {
                        model = ReaderBind(objReader);
                    }
                }
            }
            return(model);
        }
Ejemplo n.º 7
0
 public bool show(tb_File file)
 {
     return(this.id == file.id);
 }
Ejemplo n.º 8
0
 public bool ifCon(tb_File file)
 {
     return(file.fileName.Contains(this.fileName));
 }