private void createWord()
{
if (textBox1.Text == "")
{
MessageBox.Show("请输入预案名称！");
return;
}
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "All Word file|*.docx;*.docm;*.dotx;*.dotm;*.doc;*.dot"; //设置文件类型
sfd.FileName = textBox1.Text; //设置默认文件名
sfd.DefaultExt = "doc"; //设置默认格式（可以不设）
sfd.AddExtension = true; //设置自动在文件名中添加扩展名
if (sfd.ShowDialog() == DialogResult.OK)
{
using (StreamWriter sw = new StreamWriter(sfd.FileName))
{
sw.WriteLineAsync(textBox2.Text);
Pre_arrangeList temp_Pre_arrangeList = new Pre_arrangeList();
temp_Pre_arrangeList.Pre_arrangedID = Guid.NewGuid();
temp_Pre_arrangeList.Pre_arrangeName = textBox1.Text;
temp_Pre_arrangeList.Pre_arrangeType = int.Parse(comboBox1.Text);
temp_Pre_arrangeList.CreatTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
temp_Pre_arrangeList.PlanPath = sfd.FileName;
List <Pre_arrangeList> pre_arrangeList = new List <Pre_arrangeList>();
pre_arrangeList.Add(temp_Pre_arrangeList);
temp_Pre_Command.Pre_arrangeList_AddData(pre_arrangeList);
MessageBox.Show("预案保存成功！");
temp.DataFresh();
this.Close();
}
}
}
/// <summary>
/// 添加Pre_arrangeList
/// </summary>
/// <param name="_Pre_arrangeList"></param>
/// <returns></returns>
static public int[] AddData(List <Pre_arrangeList> _Pre_arrangeList)
{
int[] i = null;
if (_Pre_arrangeList != null && _Pre_arrangeList.Count > 0)
{
i = new int[_Pre_arrangeList.Count];
for (int j = 0; j < _Pre_arrangeList.Count; j++)
{
Pre_arrangeList tmparmPre_arrangeList = new Pre_arrangeList();
tmparmPre_arrangeList.AlarmDeviceID = _Pre_arrangeList[j].AlarmDeviceID;
tmparmPre_arrangeList.AlarmName = _Pre_arrangeList[j].AlarmName;
tmparmPre_arrangeList.CreatTime = _Pre_arrangeList[j].CreatTime;
tmparmPre_arrangeList.Description = _Pre_arrangeList[j].Description;
tmparmPre_arrangeList.Mark = _Pre_arrangeList[j].Mark;
tmparmPre_arrangeList.PlanPath = _Pre_arrangeList[j].PlanPath;
tmparmPre_arrangeList.Pre_arrangedID = _Pre_arrangeList[j].Pre_arrangedID;
tmparmPre_arrangeList.Pre_arrangeName = _Pre_arrangeList[j].Pre_arrangeName;
tmparmPre_arrangeList.ReviseTime = _Pre_arrangeList[j].ReviseTime;
tmparmPre_arrangeList.Pre_arrangeType = _Pre_arrangeList[j].Pre_arrangeType;
try
{
_tmparmPre_arrangeList.Insert(tmparmPre_arrangeList);
i[j] = 1;
}
catch { i[j] = 2; }
}
}
return(i);
}
public int Delete(Pre_arrangeList entityToInsert)
{
using (Conn)
{
return(Conn.Delete(entityToInsert));
}
}
public Guid Insert(Pre_arrangeList entityToInsert)
{
using (Conn)
{
return(Conn.Insert <Guid>(entityToInsert));
}
}
private void button5_Click(object sender, EventArgs e)
{
button5.Enabled = false;
if (dataGridView1.Rows.Count != 0)
{
int index = dataGridView1.CurrentRow.Index;
//OpenFileDialog ofd = new OpenFileDialog();
//ofd.FileName = dataGridView1.Rows[index].Cells[4].Value.ToString();
Pre_arrangeList temp_Pre_arrangeList = new Pre_arrangeList();
temp_Pre_arrangeList = pre_arrangeList[index];
temp_Pre_arrangeList.ReviseTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
List <Pre_arrangeList> Re_pre_arrangeList = new List <Pre_arrangeList>();
Re_pre_arrangeList.Add(temp_Pre_arrangeList);
temp_Pre_Command.Pre_arrangeList_ReviseData(Re_pre_arrangeList);
}
}
private void button4_Click(object sender, EventArgs e)
{
button2.Enabled = false;
if (dataGridView1.Rows.Count != 0)
{
int index = dataGridView1.CurrentRow.Index;
if (dataGridView1.Rows[index].Cells[4].Value == null)
{
MessageBox.Show("该预案路径不存在");
return;
}
string fileFullPath = dataGridView1.Rows[index].Cells[4].Value.ToString();
Pre_arrangeList temp_Pre_arrangeList = new Pre_arrangeList();
temp_Pre_arrangeList = pre_arrangeList[index];
Guid[] De_pre_arrangeList = new Guid[1];
De_pre_arrangeList[0] = temp_Pre_arrangeList.Pre_arrangedID;
temp_Pre_Command.Pre_arrangeList_DelData(De_pre_arrangeList);
try
{
}
catch
{ }
// 1、首先判断文件或者文件路径是否存在
if (File.Exists(fileFullPath))
{
// 2、根据路径字符串判断是文件还是文件夹
FileAttributes attr = File.GetAttributes(fileFullPath);
// 3、根据具体类型进行删除
if (attr == FileAttributes.Directory)
{
// 3.1、删除文件夹
Directory.Delete(fileFullPath, true);
}
else
{
// 3.2、删除文件
File.Delete(fileFullPath);
}
File.Delete(fileFullPath);
}
button2.Enabled = true;
DataFresh();
}
}
private void button2_Click(object sender, EventArgs e)
{
button2.Enabled = false;
if (dataGridView1.Rows.Count != 0)
{
int index = dataGridView1.CurrentRow.Index;
OpenFileDialog ofd = new OpenFileDialog();
ofd.FileName = dataGridView1.Rows[index].Cells[4].Value.ToString();
Pre_arrangeList temp_Pre_arrangeList = new Pre_arrangeList();
temp_Pre_arrangeList = pre_arrangeList[index];
temp_Pre_arrangeList.ReviseTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
List <Pre_arrangeList> Re_pre_arrangeList = new List <Pre_arrangeList>();
Re_pre_arrangeList.Add(temp_Pre_arrangeList);
temp_Pre_Command.Pre_arrangeList_ReviseData(Re_pre_arrangeList);
m_word = new Microsoft.Office.Interop.Word.Application();
Object filename = dataGridView1.Rows[index].Cells[0].Value;
Object filefullname = dataGridView1.Rows[index].Cells[4].Value.ToString();
Object confirmConversions = Type.Missing;
Object readOnly = Type.Missing;
Object addToRecentFiles = Type.Missing;
Object passwordDocument = Type.Missing;
Object passwordTemplate = Type.Missing;
Object revert = Type.Missing;
Object writePasswordDocument = Type.Missing;
Object writePasswordTemplate = Type.Missing;
Object format = Type.Missing;
Object encoding = Type.Missing;
Object visible = Type.Missing;
Object openConflictDocument = Type.Missing;
Object openAndRepair = Type.Missing;
Object documentDirection = Type.Missing;
Object noEncodingDialog = Type.Missing;
for (int i = 1; i <= m_word.Documents.Count; i++)
{
String str = m_word.Documents[i].FullName.ToString();
if (str == filefullname.ToString())
{
MessageBox.Show("请勿重复打开该文档");
return;
}
}
try
{
m_word.Documents.Open(ref filefullname,
ref confirmConversions, ref readOnly, ref addToRecentFiles,
ref passwordDocument, ref passwordTemplate, ref revert,
ref writePasswordDocument, ref writePasswordTemplate,
ref format, ref encoding, ref visible, ref openConflictDocument,
ref openAndRepair, ref documentDirection, ref noEncodingDialog
);
m_word.Visible = true;
}
catch (System.Exception ex)
{
MessageBox.Show("打开Word文档出错");
}
}
button2.Enabled = true;
}
