/// <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); }
/// <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--; }
/// <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); } }
/// <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); } }
/// <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); }
/// <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); }
public bool show(tb_File file) { return(this.id == file.id); }
public bool ifCon(tb_File file) { return(file.fileName.Contains(this.fileName)); }