/// <summary> /// 通过personId查询文件 /// </summary> /// <param name="personId">personId</param> /// <returns>文件信息</returns> public List <person_file> GetByPersonId(int personId) { List <person_file> personFileList = new List <person_file>(); string sql = "select * from person_file where person_id=" + personId; try { DataTable dataTable = SqlHelper.ExecuteDataset(ConStr, CommandType.Text, sql).Tables[0]; for (int i = 0; i < dataTable.Rows.Count; i++) { DataRow row = dataTable.Rows[i]; person_file personFile = new person_file { id = (int)row["id"], person_id = (int)row["person_id"], filename = (string)row["filename"], filetype = (string)row["filetype"], create_time = (DateTime)row["create_time"], modify_time = (DateTime)row["modify_time"] }; personFileList.Add(personFile); } } catch (Exception e) { Console.WriteLine(e.Message); } return(personFileList); }
private void BtnDelFile_Click(object sender, EventArgs e) { DialogResult res = MessageBoxCustom.Show("确认删除", "提示", MessageBoxButtons.YesNo, this); if (res == DialogResult.Yes) { int id = 0; person_file file = new person_file(); /*file.id = 0*/; file.person_id = 0; List <person_file> pf = new List <person_file>(); pf = new PersonFileBLL().GetByPersonId(PersonBasic.id); List <int> file1 = new List <int>(); foreach (var file2 in pf) { file1.Add(file2.id); } Result result = new PersonFileBLL().Del(id); if (result.Code == RES.OK) { MessageBoxCustom.Show("删除成功", "提示", MessageBoxButtons.OK, this); Close(); } else if (result.Code == RES.ERROR) { MessageBoxCustom.Show("删除失败", "提示", MessageBoxButtons.OK, this); } } }
private void BtnUpdateFile_Click(object sender, EventArgs e) { person_file A = new person_file(); A.filename = LblFileName.Text; A.filename = TxtNewFileName.Text; PersonFileBLL set = new PersonFileBLL(); Result res = new Result(); res = set.Update(A.filename, A.id); if (res.Message == "修改成功!") { MessageBoxCustom.Show("修改成功", "提示", this); } else { MessageBoxCustom.Show("修改失败", "提示", this); } }
/// <summary> /// 添加文件 /// </summary> /// <param name="pesonId">人员编号</param> /// <param name="fullFileName">文件名</param> /// <returns>person_file</returns> public person_file SetFile(int pesonId, string fullFileName) { byte[] fileContent = ReadFile(fullFileName); if (fileContent == null) { return(null); } person_file file = new person_file { filename = GetFileName(fullFileName), file = fileContent, filetype = GetFileType(fullFileName), person_id = pesonId, create_time = DateTime.Now, modify_time = DateTime.Now }; return(file); }
/// <summary> /// 文件添加 /// </summary> /// <param name="file">文件信息</param> /// <returns>添加条数</returns> public int Add(person_file file) { int res = 0; String sql = "insert into person_file(person_id,[file],filename,filetype,create_time,modify_time) values(@p1,@p2,@p3,@p4,@p5,@p6)"; SqlParameter sqlParameter1 = new SqlParameter("@p1", file.person_id); SqlParameter sqlParameter2 = new SqlParameter("@p2", file.file); SqlParameter sqlParameter3 = new SqlParameter("@p3", file.filename); SqlParameter sqlParameter4 = new SqlParameter("@p4", file.filetype); SqlParameter sqlParameter5 = new SqlParameter("@p5", file.create_time); SqlParameter sqlParameter6 = new SqlParameter("@p6", file.modify_time); try { res = SqlHelper.ExecuteNonQuery(ConStr, CommandType.Text, sql, sqlParameter1, sqlParameter2, sqlParameter3, sqlParameter4, sqlParameter5, sqlParameter6); } catch (Exception e) { Console.WriteLine(e.Message); } return(res); }
/// <summary> /// 文件查询 /// </summary> /// <param name="conditions"></param>id</param> /// <returns>通过输入id查询到的文件信息</returns> public person_file GetById(int id) { string sql = "select * from person_file where id = '" + id + "'"; person_file file = new person_file(); try { DataSet ds = SqlHelper.ExecuteDataset(ConStr, CommandType.Text, sql); file.id = (int)ds.Tables[0].Rows[0][nameof(person_file.id)]; file.person_id = (int)ds.Tables[0].Rows[0][nameof(person_file.person_id)]; file.filename = (string)ds.Tables[0].Rows[0][nameof(person_file.filename)]; file.file = (byte[])ds.Tables[0].Rows[0][nameof(person_file.file)]; file.filetype = (string)ds.Tables[0].Rows[0][nameof(person_file.filetype)]; file.create_time = (DateTime)ds.Tables[0].Rows[0][nameof(person_file.create_time)]; file.modify_time = (DateTime)ds.Tables[0].Rows[0][nameof(person_file.modify_time)]; } catch (Exception e) { Console.WriteLine(e.Message); } return(file); }