using System;
using System.Data;
using System.IO;
using System.Windows.Forms;
using Cyberpipe.PATM_logicfile;
using Cyberpipe.udfiles;
using DevComponents.DotNetBar;
namespace Cyberpipe.PATM_Forms
{
public partial class F_PATMFiles : Office2007Form
{
public F_PATMFiles()
{
InitializeComponent();
}
#region 公共变量
PATM_Affair PATMAClass = new PATM_Affair();//实例化ModuleClass文件夹下的FrmAffairClass公共类
//PATM_logicfile.PATM_Database PATM_dataclass = new PATM_logicfile.PATM_Database();//实例化ModuleClass文件夹下的DataClass公共类
//string Imadir = "";
PictureBox PB;
#endregion
public F_PATMFiles(PictureBox _PB)
{
InitializeComponent();
PB = _PB;
}
private void F_PATMFiles_Load(object sender, EventArgs e)
{
bool show_bool = true;
if (int.Parse(Tag.ToString()) == 0)
show_bool = true;
else
show_bool = false;
LV_PATMfileDir.Visible = show_bool;
BT_ADD.Visible = show_bool;
BT_DEL.Visible = show_bool;
TB_PATMfilename.Visible = !show_bool;
LB_PATMfilename.Visible = !show_bool;
//panel_Title.BackgroundImage = Image.FromFile(photoDir + "\\Image\\" + ModuleClass.FrmAffairClass.Redact_T + this.Tag.ToString() + ".JPG");
switch (int.Parse(Tag.ToString()))
{
case 0:
{
LV_PATMfileDir.Items.Clear();//清空所有项的集合
LV_PATMfileDir.Columns.Clear();//清空所有列的集合
LV_PATMfileDir.GridLines = true;//在各数据之间形成网格线
LV_PATMfileDir.View = View.Details;//显示列名称
LV_PATMfileDir.FullRowSelect = true;//在单击某项时，对其进行选中
LV_PATMfileDir.Columns.Add("文件路径", LV_PATMfileDir.Width - 5, HorizontalAlignment.Center);//设置列标头的名称及大小
break;
}
case 1:
case 2:
{
if (int.Parse(Tag.ToString()) == 1)
{
LB_PATMfilename.Text = "文件名称：";
TB_PATMfilename.Text = PATM_Affair.Redact_N;
}
if (int.Parse(Tag.ToString()) == 2)
{
TB_PATMfilename.Visible = show_bool;
LB_PATMfilename.Text = "是否删除该文件?";
}
break;
}
}
}
private void Cancel_Click(object sender, EventArgs e)
{
Close();
}
private void F_PATMFiles_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == '\r')
OK_Click(sender, e);
}
private void OK_Click(object sender, EventArgs e)
{
string sdir = "";//原目录
string ddir = "";//目的目录
int m = int.Parse(Tag.ToString());//当前操作的标识
int n = -1;//是否修改成功
int PID = int.Parse(PATM_Affair.Redact_M);//操用节点的ID号
switch (m)
{
case 0:
{
if (LV_PATMfileDir.Items.Count > 0)
{
PATM_Affair.ADD_LV.Items.Clear();//清空所有项的集合
PATM_Affair.ADD_LV.Columns.Clear();//清空所有列的集合
PATM_Affair.ADD_LV.GridLines = true;//在各数据之间形成网格线
PATM_Affair.ADD_LV.View = View.Details;//显示列名称
PATM_Affair.ADD_LV.Columns.Add("文件名", 80, HorizontalAlignment.Center);//设置列标头的名称及大小
for (int i = 0; i < LV_PATMfileDir.Items.Count; i++)
{
sdir = LV_PATMfileDir.Items[i].Text;
ddir = PATM_Affair.Redact_D + "\\" + PATMAClass.Files_Name(sdir, m);
string filepath = ddir.Substring(0,ddir.IndexOf("\\"));
string foldddir = Utility.uploadpath + "\\" + PATM_Affair.tablename + "\\" + ddir;
//添加文件
FileStream fs = File.OpenRead(sdir); //文件转为byte[]
byte[] buffer = new byte[fs.Length];
fs.Read(buffer, 0, buffer.Length);
UpDownFile upfolder = new UpDownFile(Utility.udserviceurl);
n = upfolder.UploadFiles(foldddir, buffer);
//n = PATMAClass.Folder_Handle(foldddir, sdir, "", m);
switch (n)
{
case 0:
sdir = "insert into " + PATM_Affair.tablename
+ " (NodePID,NodeName,NodePath,NodeType,NodeSign) values(" + PID
+ ",'" + PATMAClass.Files_Name(sdir, m) + "','" + filepath + "',"
+ m + ",'" + Utility.userName + "')";
OledbHelper.getsqlcom(sdir);
DataSet DS = OledbHelper.getDataSet("select max(NODEID) from " + PATM_Affair.tablename, PATM_Affair.tablename);
ListViewItem lvi = new ListViewItem(PATMAClass.Files_Name(ddir, m));//实例化一个项
lvi.Tag = int.Parse(DS.Tables[0].Rows[0][0].ToString());
PATM_Affair.ADD_LV.Items.Add(lvi);//添加列信息
break;
case 1:
LV_PATMfileDir.Items[i].Remove(); break;
case 2:
if (MessageBox.Show("文件夹下有同名文件，是否替换?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
n = upfolder.UploadFilesDir(foldddir, buffer);
else
{ ;}
if (n == 0)
MessageBox.Show("文件添加成功！");
else
MessageBox.Show("文件添加失败！");
break;
}
DialogResult = DialogResult.OK;//将当前窗体的对话框返回值设为OK
}
}
else
{
MessageBox.Show("添加的文件不能为空。");
}
break;
}
case 1:
{
ddir = Application.StartupPath + "\\Files\\" + PATM_Affair.tablename+"\\"
+ PATM_Affair.Redact_D + "\\" + PATM_Affair.Redact_N;
//sdir = PATMAClass.UpAndDown_Dir(Cyberpipe.PATM_logicfile.PATM_Affair.Redact_D) + "\\" + TB_PATMfilename.Text.Trim();
sdir = TB_PATMfilename.Text.Trim();
string tablename = PATM_Affair.tablename;
sdir = "update " + tablename + " set "+tablename+".\"NODENAME\"='" + TB_PATMfilename.Text
+ "',"+tablename+".\"NODEPATH\"='" + PATM_Affair.Redact_D
+ "' where "+tablename+".\"NODEID\"='" + PATM_Affair.Redact_M + "'";
break;
}
case 2:
{
//ddir = Cyberpipe.PATM_logicfile.PATM_Affair.Redact_D;
ddir = Application.StartupPath + "\\Files\\" + PATM_Affair.tablename + "\\"
+ PATM_Affair.Redact_D + "\\" + PATM_Affair.Redact_N;
string tablename = PATM_Affair.tablename;
sdir = "delete " + tablename + " where "+tablename+".\"NODEID\"="
+ PATM_Affair.Redact_M;
break;
}
}
if (m > 0)
{
UpDownFile upfolder = new UpDownFile(Utility.udserviceurl);
string filenameurl = Utility.uploadpath + "\\" + PATM_Affair.tablename +"\\"+ PATM_Affair.Redact_D
+ "\\" + PATM_Affair.Redact_N;
n = upfolder.File_Handle(filenameurl, "", TB_PATMfilename.Text.Trim(), m);
//n = PATMAClass.Folder_Handle(ddir, "", TB_PATMfilename.Text.Trim(), m);
if (n == 1)
{
DialogResult = DialogResult.Cancel;//将当前窗体的对话框返回值设为Cancel
}
else
{
OledbHelper.getsqlcom(sdir);
if (m == 1)
PATM_Affair.Redact_N = TB_PATMfilename.Text;
DialogResult = DialogResult.OK;//将当前窗体的对话框返回值设为OK
}
}
Close();
}
private void BT_ADD_Click(object sender, EventArgs e)
{
OFD_ADDFile.Filter = "所有文件(*.*)|*.*";
if (OFD_ADDFile.ShowDialog() == DialogResult.OK)
{
string Fdir = OFD_ADDFile.FileName;
for (int i = 0; i < LV_PATMfileDir.Items.Count; i++)
{
if (Fdir == LV_PATMfileDir.Items[i].Text)
{
MessageBox.Show("该文件已存在，无法添加。");
return;
}
}
ListViewItem lvi = new ListViewItem(Fdir);//实例化一个项
LV_PATMfileDir.Items.Add(lvi);//添加列信息
if (Fdir.Length > LV_PATMfileDir.Width)
LV_PATMfileDir.Width = Fdir.Length;
}
}
private void BT_DEL_Click(object sender, EventArgs e)
{
if (LV_PATMfileDir.SelectedItems.Count > 0)
{
ListViewItem HLVI = LV_PATMfileDir.SelectedItems[0];
HLVI.Remove();
}
else
{
MessageBox.Show("请选择要删除的文件。");
}
}
}
}
