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