//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);
}
