using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using Pub_Class;
|
|
namespace OAM
|
{
|
public partial class frm_ModlueEdit : Form
|
{
|
public string sCondition; //¹ýÂËÌõ¼þ
|
TreeNode CurNode = new TreeNode();
|
public frm_ModlueEdit()
|
{
|
InitializeComponent();
|
}
|
|
|
//¼ÓÔØÊ÷ÐÎ
|
public static void LoadTree(TreeView tv, ImageList imageList1, string Text)//Lock
|
{
|
try
|
{
|
tv.Nodes.Clear();
|
tv.ImageList = imageList1;
|
TreeNode sNode = tv.Nodes.Add("T0", Text, 0, 1);
|
LoadAllNodes(sNode);
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("¼ÓÔØÊ÷ÐÍʧ°Ü£¡" + e.Message, "Ìáʾ");
|
}
|
}
|
public static void LoadAllNodes(TreeNode sNode) //huan
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
if (sNode != null)
|
{
|
try
|
{
|
string BillName2 = "OA_UserModule";
|
long sName = Convert.ToInt64(sNode.Name.Substring(1, sNode.Name.Length - 1));
|
sNode.Nodes.Clear();
|
DataSet Ds = oCn.RunProcReturn("select FileName,ModuleID,FileCode,isgroup from OA_UserModule where parentid='" + sName + "' and username='" + DBUtility.ClsPub.CurUserName + "' order by ModuleID", "OA_UserModule", ref ClsPub.sExeReturnInfo);
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
TreeNode oNode = sNode.Nodes.Add("T" + Ds.Tables[0].Rows[i]["ModuleID"].ToString(), Ds.Tables[0].Rows[i]["FileName"].ToString(), 0, 1);
|
}
|
sNode.Expand();
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("¼ÓÔØ×ÓÏîĿʧ°Ü£¡" + e.Message, "Ìáʾ");
|
}
|
}
|
|
}
|
private void cmdOk2_Click(object sender, EventArgs e)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
if (CurNode.Text == "")
|
{
|
MessageBox.Show("δѡÖÐÕýÈ·µÄÏî");
|
|
}
|
else
|
{
|
string parentid = CurNode.Name.Substring(1);
|
if (DBUtility.ClsPub.isStrNull(txtFilePath.Text) == "")
|
{
|
MessageBox.Show("Èí¼þ·¾¶²»ÄÜΪ¿Õ£¡", "Ìáʾ");
|
return;
|
}
|
if (DBUtility.ClsPub.isStrNull(txtFileName2.Text) == "")
|
{
|
MessageBox.Show("Èí¼þÃû³Æ²»ÄÜΪ¿Õ£¡", "Ìáʾ");
|
return;
|
}
|
oCn.RunProc("Insert into OA_UserModule " +
|
" (FileName,parentid,UserName,FileCode,isgroup,prjname) " +
|
" Values('" + txtFileName2.Text.Trim() + "','" + parentid + "','" + Pub_Class.ClsPub.CurUserName + "','" + txtFilePath.Text.Trim() + "'," + 0 + ",'" + "" + "')", ref DBUtility.ClsPub.sExeReturnInfo);
|
|
LoadTree(TreeView, imageList1, this.Text);
|
MessageBox.Show("ÐÂÔö³É¹¦");
|
}
|
}
|
|
private void cmdFilePath_Click(object sender, EventArgs e)
|
{
|
OpenFileDialog fileDialog = new OpenFileDialog();
|
fileDialog.Multiselect = true;
|
fileDialog.Title = "ÇëÑ¡ÔñÎļþ";
|
fileDialog.Filter = "ËùÓÐÎļþ(*.*)|*.*";
|
if (fileDialog.ShowDialog() == DialogResult.OK)
|
{
|
txtFilePath.Text = fileDialog.FileName;
|
}
|
}
|
|
private void cmdCanCel2_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void jz_Click(object sender, EventArgs e)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
if (DBUtility.ClsPub.isStrNull(txtName.Text) == "")
|
{
|
MessageBox.Show("Ìí¼Ó×éÃû²»ÄÜΪ¿Õ£¡", "Ìáʾ");
|
return;
|
|
}
|
else
|
{
|
if (CurNode.Name == "")
|
{
|
|
MessageBox.Show("δѡÖÐÕýÈ·µÄÏî");
|
}
|
else
|
{
|
|
string parentid = CurNode.Name.Substring(1);
|
DialogResult dr = MessageBox.Show("È·¶¨ÒªÔÚ¡¾" + CurNode.Text + "¡¿ÏÂÌí¼ÓÒ»¸öÃûΪ¡¾" + txtName.Text + "¡¿µÄÐÂ×éÂð£¿", "Ìáʾ", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
|
if (dr == DialogResult.Yes)
|
{
|
oCn.RunProc("Insert into OA_UserModule " +
|
" (FileName,parentid,UserName,FileCode,isgroup,prjname) " +
|
" Values('" + txtName.Text.Trim() + "','" + parentid + "','" + Pub_Class.ClsPub.CurUserName + "','" + "" + "'," + 0 + ",'" + "" + "')", ref DBUtility.ClsPub.sExeReturnInfo);
|
|
LoadTree(TreeView, imageList1, this.Text);
|
MessageBox.Show("ÐÂÔö³É¹¦");
|
}
|
else
|
{
|
}
|
|
}
|
}
|
}
|
|
private void frm_ModlueEdit_Load(object sender, EventArgs e)
|
{
|
txtEmp.Text = Pub_Class.ClsPub.CurUserName;
|
LoadTree(TreeView, imageList1, this.Text);
|
}
|
|
private void TreeView_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
|
{
|
CurNode = e.Node;
|
if (CurNode != null)
|
{
|
if (CurNode.Nodes.Count == 0)
|
LoadAllNodes(CurNode);
|
//ÕÒµ½Ñ¡Öнáµã
|
}
|
}
|
|
private void sz_Click(object sender, EventArgs e)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
if (CurNode != null)
|
{
|
if (CurNode.Name == "T0")
|
{
|
|
MessageBox.Show("´Ë½Úµã²»¿Éɾ³ý£¡");
|
}
|
else
|
{
|
DialogResult dr = MessageBox.Show("È·¶¨ÒªÉ¾³ý´ËĿ¼Âð£¿", "Ìáʾ", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
|
if (dr == DialogResult.Yes)
|
{
|
string parentid = CurNode.Name.Substring(1);
|
oCn.RunProc("DELETE FROM OA_UserModule WHERE ModuleID =" + parentid + " ", ref DBUtility.ClsPub.sExeReturnInfo);
|
LoadTree(TreeView, imageList1, this.Text);
|
MessageBox.Show("×é" + "¡¾" + CurNode.Text + "¡¿" + "ÒÑɾ³ý");
|
}
|
else
|
{
|
}
|
}
|
}
|
else
|
{
|
MessageBox.Show("δѡÖÐÕýÈ·µÄÏî");
|
}
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
|
|
|
}
|
}
|
