//public List<MaterialDto> GteAccountList(MaterialDto model) //{ // var query = from a in _materialRepository.Table // select new MaterialDto // { // tb_id = a.tbid, // tb_name_before = a.tbnamebefore, // tb_name_now = a.tbnamenow, // tb_date = a.tbdate, // tb_size = a.tbsize, // tb_username = a.tbusername, // tb_userid = a.tbuserid, // tb_type = a.tbtype, // tb_address = a.tbaddress, // tb_projectid = a.tbprojectid, // tb_project = a.tbproject // }; // if (model.tb_id != null && model.tb_id != Guid.Empty) // query = query.Where(t => t.tb_id == model.tb_id); // //if (!string.IsNullOrWhiteSpace(model.tb_name_before)) // // query = query.Where(t => t.tb_name_before == model.tb_name_before); // //if (!string.IsNullOrWhiteSpace(model.tb_name_now)) // // query = query.Where(t => t.tb_name_now == model.tb_name_now); // //if (model.RolesID != 0) // // query = query.Where(t => t.RolesID == model.RolesID); // //if (model.ID != null && model.ID != Guid.Empty) // // query = query.Where(t => t.ID == model.ID); // //if (!string.IsNullOrWhiteSpace(model.AccountID)) // // query = query.Where(t => t.AccountID == model.AccountID); // //if (model.DepartmentsID != 0) // // query = query.Where(t => t.DepartmentsID == model.DepartmentsID); // //if (model.RolesID != 0) // // query = query.Where(t => t.RolesID == model.RolesID); // //if (model.ID != null && model.ID != Guid.Empty) // // query = query.Where(t => t.ID == model.ID); // //if (!string.IsNullOrWhiteSpace(model.AccountID)) // // query = query.Where(t => t.AccountID == model.AccountID); // //if (model.DepartmentsID != 0) // // query = query.Where(t => t.DepartmentsID == model.DepartmentsID); // return query.ToList(); //} //public FileMange GetAccount() //{ // //方法一:通过主键获得 // var acconnt = _materialRepository.GetById(new Guid("2EA2D746-C57B-47F7-BA74-9E8D73D8D7C1")); // //方法二:通过参数ID查询 // //var acconnt2 = _accountRepository.Find("ID=@ID", new SqlParameter[] { // // new SqlParameter("@ID",new Guid("2EA2D746-C57B-47F7-BA74-9E8D73D8D7C1")) // //}); // //方法三:通过linq查询 // var query = from u in _materialRepository.Table // select u; // //query = query.Where(t => t.AccountID == "admin"); // return query.First(); //} //public bool BatchAdd(DataTable dt) //{ // SqlParameter[] parameters = { // new SqlParameter("@ErrorNo", SqlDbType.Int, 4), // new SqlParameter("@ErrorMsg", SqlDbType.NVarChar, 500), // new SqlParameter("@tpImportAccount", dt) // }; // parameters[0].Direction = ParameterDirection.Output; // parameters[1].Direction = ParameterDirection.Output; // DbHelperSql.RunProcedure(DbHelperSql.DefaultUpdateConn, "sp_BatchImportAccount", parameters, "ds"); // if ((int)parameters[0].Value == 1) // { // return true; // } // else // return false; //} public bool addMaterial(FileMange material) { #region //SqlParameter[] parameters = { // new SqlParameter("@tb_id", SqlDbType.UniqueIdentifier) , // new SqlParameter("@tb_name_before", SqlDbType.VarChar,500), // new SqlParameter("@tb_name_now", SqlDbType.VarChar,500), // new SqlParameter("@tb_date", SqlDbType.VarChar,500) , // new SqlParameter("@tb_size", SqlDbType.Decimal,18) , // new SqlParameter("@tb_username", SqlDbType.VarChar,500) , // new SqlParameter("@tb_userid", SqlDbType.Int) , // new SqlParameter("@tb_type", SqlDbType.Int) , // new SqlParameter("@tb_address", SqlDbType.VarChar,500) , // new SqlParameter("@tb_projectid", SqlDbType.Int) , // new SqlParameter("@tb_project", SqlDbType.VarChar,500), // new SqlParameter("@tb_fileType", SqlDbType.VarChar,500), // new SqlParameter("@tb_fileExplain", SqlDbType.VarChar,500) // }; //parameters[0].Value = material.tbid; //parameters[1].Value = material.tbnamebefore; //parameters[2].Value = material.tbnamenow; //parameters[3].Value = material.tbdate; //parameters[4].Value = material.tbsize; //parameters[5].Value = material.tbusername; //parameters[6].Value = material.tbuserid; //parameters[7].Value = material.tbtype; //parameters[8].Value = material.tbaddress; //parameters[9].Value = material.tbprojectid; //parameters[10].Value = material.tbproject; //parameters[11].Value = material.tbfileType; //parameters[12].Value = material.tbfileExplain; //var dset= DbHelperSql.RunProcedure(DbHelperSql.DefaultUpdateConn, "FileMange_ADD", parameters, "FileMange"); //if (dset != null) //{ // return true; //} //else { // return false; //} #endregion //StringBuilder strSql = new StringBuilder(); //strSql.Append(""); //DbHelperSql.ExecuteSql(DbHelperSql.DefaultUpdateConn, strSql.ToString()); return(false); }
public bool deleteFile(string path, string id) { try { Guid gu = new Guid(id); FileMange fm = _materialRepository.GetById(gu); System.IO.File.Delete(path + fm.NameBefore); List <FileModular> list = _materialRepository_fm.GetFileModular(m => m.RefFIleID == gu, m => m.FileType); foreach (FileModular fmu in list) { _materialRepository_fm.Delete(fmu); } _materialRepository.Delete(fm); return(true); } catch (Exception ex) { return(false); } //SqlParameter[] parameters = { // new SqlParameter("@tb_name_before", SqlDbType.VarChar,500) // }; //parameters[0].Value = name; //var dset = DbHelperSql.RunProcedure(DbHelperSql.DefaultUpdateConn, "FileMange_Delete", parameters, "FileMange"); //if (dset != null) //{ // return true; //} //else //{ // return false; //} }
/// <summary>upload file</summary> /// <param name="file">前端上传文件</param> /// <param name="NameBefore">文件原名称</param> /// <param name="Size">文件大小</param> /// <param name="UserId">用户id</param> /// <param name="FileType">文件后缀类型</param> /// <param name="FilePath">文件路径</param> /// <param name="PeojectId">项目id</param> /// <param name="FileCategory">文件分类</param> /// <param name="FileExplain">文件说明</param> public string UploadFile(HttpPostedFileBase file, string NameBefore, int Size, Guid UserId, string FileType, string FilePath, Guid PeojectId, string FileCategory, string FileExplain, string UserName, string ProjectName) { //"F:\\项目管理平台\\trunk\\code\\XcBIMwebSys.WebCode\\Content\\Temp\\username" //根据用户名创建文件夹 string tPath = FilePath + "\\" + NameBefore; if (System.IO.Directory.Exists(FilePath) == false)//如果不存在就创建file文件夹 { System.IO.Directory.CreateDirectory(FilePath); } if (System.IO.File.Exists(tPath)) { return("文件已存在"); } var gu = Guid.NewGuid(); //文件名修改 string NameNow = NameBefore; string sPath = Path.Combine(FilePath, NameNow); file.SaveAs(sPath); string date = System.DateTime.Now.ToString(); //文件路径加密 FilePath = fileMangeTool.DESEncrypt(FilePath + "\\" + NameNow, "12345678", "87654321"); //文件实体类 FileMange material = new FileMange(); material.FileID = gu; material.NameBefore = NameBefore; material.NameNow = NameNow; material.Date = date; material.Size = Size; material.UserId = UserId; material.FileType = FileType; material.FilePath = FilePath; material.ProjectId = PeojectId; material.FileCategory = FileCategory; material.FileExplain = FileExplain; material.UserName = UserName; material.ProjectName = ProjectName; FileModular fileModular = new FileModular(); var fmu = Guid.NewGuid(); fileModular.FileModularID = fmu; fileModular.FileType = FileCategory; fileModular.RefFIleID = gu; fileModular.RefProjectID = PeojectId; try { _materialRepository.Insert(material); _materialRepository_fm.Insert(fileModular); } catch (Exception e) { return("上传失败"); } //if (addMaterial(material)) //{ // return "上传成功"; //} //else //{ // return "上传失败"; //} return("上传成功"); }
/// <summary> /// 得到一个对象实体 /// </summary> public FileMange DataRowToModel(DataRow row) { FileMange model = new FileMange(); if (row != null) { if (row["FileID"] != null && row["FileID"].ToString() != "") { model.FileID = new Guid(row["FileID"].ToString()); } if (row["NameBefore"] != null && row["NameBefore"].ToString() != "") { model.NameBefore = row["NameBefore"].ToString(); } if (row["NameNow"] != null && row["NameNow"].ToString() != "") { model.NameNow = row["NameNow"].ToString(); } if (row["Date"] != null && row["Date"].ToString() != "") { model.Date = row["Date"].ToString(); } if (row["Size"] != null && row["Size"].ToString() != "") { model.Size = int.Parse(row["Size"].ToString()); } if (row["UserId"] != null && row["UserId"].ToString() != "") { model.UserId = new Guid(row["UserId"].ToString()); } if (row["FileType"] != null && row["FileType"].ToString() != "") { model.FileType = row["FileType"].ToString(); } if (row["FilePath"] != null && row["FilePath"].ToString() != "") { model.FilePath = row["FilePath"].ToString(); } if (row["ProjectId"] != null && row["ProjectId"].ToString() != "") { model.ProjectId = new Guid(row["ProjectId"].ToString()); } if (row["FileCategory"] != null && row["FileCategory"].ToString() != "") { model.FileCategory = row["FileCategory"].ToString(); } if (row["FileExplain"] != null && row["FileExplain"].ToString() != "") { model.FileExplain = row["FileExplain"].ToString(); } if (row["UserName"] != null && row["UserName"].ToString() != "") { model.UserName = row["UserName"].ToString(); } if (row["ProjectName"] != null && row["ProjectName"].ToString() != "") { model.ProjectName = row["ProjectName"].ToString(); } } return(model); }