/// <summary>
/// 获得个人文件
/// </summary>
/// <returns></returns>
public List <JJFujianInfo> GetGerenwenjian(string kw)
{
List <JJFujianInfo> list = new List <JJFujianInfo>();
string str = $"select * from jjdbrenwutaizhang.附件信息表 " +
$"where 文件名 like '%{kw}%' " +
$"and 删除 = 0 and 创建人='{JJLoginInfo._huaming}' " +
$"and 类型='个人'";
DataTable mydt = _mysql.ExecuteDataTable(str);
foreach (DataRow dr in mydt.Rows)
{
JJFujianInfo info = new JJFujianInfo()
{
_wenjianming = dr["文件名"].ToString(),
_chuangjianren = dr["创建人"].ToString(),
_chuangjianshijian = dr["创建时间"].ToString(),
_quanlujing = dr["全路径"].ToString(),
_xiazaicishu = Convert.ToInt32(dr["下载次数"].ToString()),
_leixing = dr["类型"].ToString(),
_kejian = dr["可见"].ToString()
};
list.Add(info);
}
return(list);
}
/// <summary>
/// 判断文件名是否存在于服务器
/// </summary>
/// <param name="filename"></param>
/// <returns></returns>
public bool InsertFile(JJFujianInfo info)
{
string str_sql = $"insert into jjdbrenwutaizhang.附件信息表 values('{info._wenjianming}','{info._chuangjianren}'," +
$"'{info._chuangjianshijian}','{info._quanlujing}',{info._xiazaicishu},0,'{string.Empty }','{info._leixing}')";
int num = _mysql.ExecuteNonQuery(str_sql);
return(num > 0 ? true : false);
}
/// <summary>
/// 修改附件的可见范围
/// </summary>
/// <returns></returns>
private bool UpdateKejian(JJFujianInfo info)
{
string str_sql = $"update jjdbrenwutaizhang.附件信息表 " +
$"set 可见='{info._kejian}' " +
$"where 文件名='{info._wenjianming}' and 创建人='{info._chuangjianren}' " +
$"and 删除=0";
int num = _mysql.ExecuteNonQuery(str_sql);
return(num > 0 ? true : false);
}
private async void pb_shangchuan_Click(object sender, EventArgs e)
{
pb_shangchuangongxiang.Visible = true;
pb_shangchuangeren.Visible = false;
//上传共享文件
OpenFileDialog ofd = new OpenFileDialog();
if (ofd.ShowDialog() == DialogResult.OK)
{
string file = Path.GetFileName(ofd.FileName);
JJFujianInfo info = new JJFujianInfo()
{
_wenjianming = file,
_chuangjianren = JJLoginInfo._shiming,
_quanlujing = $"{uripath}/{file}",
_chuangjianshijian = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"),
_xiazaicishu = 0,
_kejian = string.Empty,
_leixing = "共享"
};
//添加控件，显示正在上传
UCfujianInfo myuc = new UCfujianInfo(info)
{
Dock = DockStyle.Top
};
panel_fujian.Controls.Add(myuc);
Application.DoEvents();
//开始上传
myuc.lbl_info.Visible = true;
myuc.lbl_info.Text = "正在上传……";
Application.DoEvents();
//UpSound_Request(uripath, ofd.FileName, "xxx.zip", progressBar1);
await JJMethod.UpLoadFile(ofd.FileName, uripath, false);
InsertFile(info);
//上传完之后，不显示正在上传
myuc.lbl_info.Text = string.Empty;
myuc.lbl_info.Visible = false;
}
}
private async void UCfujianInfo_Load(object sender, EventArgs e)
{
if (_myinfo == null)
{
//判断文件是否存在，如果不存在上传，显示已上传，如果已经存在，直接显示已上传
bool exist = ExistFile(path);
lbl_wenjianming.Text = file;
if (!exist)
{
JJFujianInfo info = new JJFujianInfo()
{
_wenjianming = file,
_chuangjianren = JJLoginInfo._shiming,
_leixing = "共享",
_quanlujing = path,
_chuangjianshijian = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"),
_xiazaicishu = 0,
};
InsertFile(info);
lbl_info.Text = "正在上传……";
await JJMethod.UpLoadFile(_filename, uripath, false);
}
lbl_info.Text = "已上传!";
}
else
{
lbl_wenjianming.Text = _myinfo._wenjianming;
lbl_chuangjianren.Text = _myinfo._chuangjianren;
lbl_chuangjianren.Visible = true;
lbl_shijian.Text = _myinfo._chuangjianshijian;
lbl_shijian.Visible = true;
lbl_xiazai.Visible = true;
lbl_info.Visible = false;
pb_guanbi.Visible = false;
//共享文件可以看见垃圾桶,非共享文件可以
if (!_myinfo._leixing.Equals("共享"))
{
pb_shanchu.Visible = true;
}
//创建人上传的共享任务可以设置可见范围，显示眼睛
if (JJLoginInfo._shiming.Equals(_myinfo._chuangjianren) && _myinfo._leixing.Equals("共享"))
{
pb_kejian.Visible = true;
}
}
}
public UCfujianInfo(JJFujianInfo info)
{
InitializeComponent();
_myinfo = info;
}
