c#1.1代码（三）
if(Dt.Rows.Count > 0)
{
//ComFgroupfID;
ComFgroupfID.DataSource = Dt;
ComFgroupfID.DisplayMember = Dt.Columns["fname"].ToString();
ComFgroupfID.ValueMember = Dt.Columns["fid"].ToString();
PbaseUpdate Pbase = new PbaseUpdate();
private void FMachineGroup_Load(object sender, System.EventArgs e)
{
#region treeview
TreeNode Root = new TreeNode("系统角色列表");
Root.Tag=0;
this.treeVSystem.Nodes.Add(Root);
string sql = "select fid,fname from dnc_sys_plant where fid like '"+CGlobe.GFplantfid+"%'";
DataTable Dt = Pbase.GetDatetable(null,sql);
if(Dt.Rows.Count>0)
{
for(int i=0;i<Dt.Rows.Count;i++)
{
TreeNode PlantNode = new TreeNode(Dt.Rows[i][1].ToString());
PlantNode.ImageIndex = 1;
PlantNode.SelectedImageIndex = 1;
PlantNode.Tag= Dt.Rows[i][0].ToString();
Root.Nodes.Add(PlantNode);
sql = "select fid,fname from dnc_sys_role where fplantfid like '"+ Dt.Rows[i][0].ToString()+"%'";
DataTable dt = Pbase.GetDatetable(null,sql);
if(dt.Rows.Count>0)
{
for(int ii=0;ii<dt.Rows.Count;ii++)
{
TreeNode NodeMachGr = new TreeNode(dt.Rows[ii][1].ToString());
NodeMachGr.Tag = dt.Rows[ii][0].ToString();
PlantNode.Nodes.Add(NodeMachGr);
}
}
dt.Dispose();
}
}
Dt.Dispose();
#endregion treeview
}
private void treeVSystem_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
{
Nbase nbase = new Nbase();
// if(CGlobe.GFrolefID == "%" || nbase.Popedom("AddMachineGroup",CGlobe.Gfrole))
// {
Point point = new Point(e.X,e.Y);
TreeNode node = this.treeVSystem.GetNodeAt(point);
if(node == null)return;
WatchNode(node);
// }
}
private void WatchNode( TreeNode node)
{
///
listView2.Items.Clear();
listView1.Items.Clear();
string FRoleFid = node.Tag .ToString();
if(FRoleFid == "0")return;
string sql = "select fid,fname from dnc_sys_employee where frolefid like '%"
+ FRoleFid+"%'";
DataTable dt = Pbase.GetDatetable(null,sql);
for(int i=0;i<dt.Rows.Count;i++)
{
ListViewItem li = new ListViewItem(dt.Rows[i]["fname"].ToString(),3);
li.Tag = dt.Rows[i]["fid"];
this.listView2.Items.Add(li);
}
sql = "select fid,fcontent from dnc_sys_role where fid='"
+FRoleFid+"'";
dt = Pbase.GetDatetable(null,sql);
if(dt.Rows.Count <= 0)return;
string RoleMenum = dt.Rows[0]["fcontent"].ToString();
string[] EachMenum = RoleMenum.Split('|');
sql = "select * from dnc_sys_menu";
dt = Pbase.GetDatetable(null,sql);
for(int ii=0;ii<dt.Rows.Count;ii++)
{
for(int j = 0;j<EachMenum.Length;j++)
{
if(dt.Rows[ii]["fmenu"].ToString() == EachMenum[j])
{
string[] LColounm = new string[4]
{
dt.Rows[ii]["forder"].ToString(),
dt.Rows[ii]["fname"].ToString(),
dt.Rows[ii]["fdesc"].ToString(),
dt.Rows[ii]["fremark"].ToString()
};
ListViewItem li = new ListViewItem(LColounm,4);
this.listView1.Items.Add(li);
}
}
}
}
------------------------------------------------------------------------------------------------------
private void GroupSel()
{
ObjClear();
if(ComFProgram.Items.Count <= 0)return;
if(ComFgroupfID.Items.Count <= 0)return;
string Fplantfid=this.ComFgroupfID.SelectedValue.ToString();
if(Fplantfid == null || Fplantfid.Length <= 0)return;
string Fcode= this.ComFProgram.SelectedValue.ToString();
string sql="select fdetail,FNAME,FID from dnc_sys_programset where fcode = '"
+ Fcode+"' and fgroupfid='"+Fplantfid+"' and fplantfid='"
+ CGlobe.GFplantfid+"'";
DataTable Dt = Pbase.GetDatetable(null,sql);
if(Dt.Rows.Count>0)// != null)
{
string StrObj = Dt.Rows[0][0].ToString();
string[] str= StrObj.Split('|');
if(str[0] != "" && str[0].Length>0)
txtname.Text = Dt.Rows[0][1].ToString();
if(str[0] != "" && str[0].Length>0)
txtbegsign.Text=str[0].ToString();
if(str[1] != "" && str[1].Length >0 )
this.txtEndsign.Text=str[1].ToString();
if(str[2] != "" && str[2].Length>0)
this.txtIgnorsign.Text= str[2].ToString();
if(str[3] != "" && str[3].Length>0)
this.txtline.Text = str[3].ToString();
if(str[4] != "" && str[4].Length>0)
this.txtlenmax.Text= str[4].ToString();
if(str[5] != "" && str[5].Length>0)
this.txtlenmin.Text = str[5].ToString();
fid = Dt.Rows[0][2].ToString();
}
else
fid = "";
Exemple.Text = txtchange();
this.Customer.Text = txtname.Text.Trim();
}
private void ComFProgramItemAdd()
{
//ComFProgram
DataColumn DClo = new DataColumn("Fname");
DClo.DataType = System.Type.GetType("System.String");
DataTable Dt = new DataTable();
Dt.Columns.Add(DClo);
DataColumn DClos = new DataColumn("Fcode");
DClos.DataType = System.Type.GetType("System.String");
Dt.Columns.Add(DClos);
DataRow Dr = Dt.NewRow();
//
Dr[0]="Program";
Dr[1] ="程序名";
Dt.Rows.Add(Dr);
//
DataRow Drs = Dt.NewRow();
Drs[0]="Customer";
Drs[1] ="客户";
Dt.Rows.Add(Drs);
//
DataRow Drt = Dt.NewRow();
Drt[0]="Drawing";
Drt[1] ="图号";
Dt.Rows.Add(Drt);
//
DataRow Drf = Dt.NewRow();
Drf[0]="Part";
Drf[1] ="工步";
Dt.Rows.Add(Drf);
//
DataRow Drfif = Dt.NewRow();
Drfif[0]="Desc";
Drfif[1] ="备注";
Dt.Rows.Add(Drfif);
//
ComFProgram.DataSource = Dt ;
ComFProgram.DisplayMember = Dt.Columns["Fcode"].ToString();
ComFProgram.ValueMember = Dt.Columns["Fname"].ToString();
--------------------------------------------------------------------------------------
private void q_FPWD_KeyUp(object sender, System.Windows.Forms.KeyEventArgs e)
{
if(e.KeyCode == Keys.Enter || e.KeyCode == Keys.Tab)
{
if(this.q_FPWD.Text.Trim() != this.t_FPWD.Text.Trim())
{
MessageBox.Show("用户登录口令验证错误！请校正。",CGlobe.Gmsg);
return;
}
}
}
int Treewidth;
private void treeView1_Resize(object sender, System.EventArgs e)
{
if(this.treeView1.Width < 215 && this.treeView1.Width > 100)
{
Treewidth=this.treeView1.Width;
}
else
this.treeView1.Width = Treewidth;
}
private void TreeBind()
{
this.treeView1.Nodes.Clear();
// string sql = "select fid,fname from DNC_SYS_MACHINEGROUP where FPLANTFID='"
// +CGlobe.GFplantfid+"'";
// //
// WindControl.FileReslove Fs = new WindControl.FileReslove(CGlobe.GFplantfid,CGlobe.Gfname,CGlobe.Gfid);
// string FRoleGroup = Fs.GetRoleMachineGroup(CGlobe.GFrolefID);
// if(FRoleGroup != "%")
// {
// if(FRoleGroup.Length == 0)
// return;
// else
// {
// FRoleGroup = FRoleGroup.Replace("|","','");
// FRoleGroup = "'" + FRoleGroup +"'";
// sql = "select fid,fname from dnc_sys_machinegroup where fplantfid='"
// +CGlobe.GFplantfid + "' and fid in ('"
// + FRoleGroup + "')";
// }
// }
//
WindControl.FileReslove Fs = new FileReslove(CGlobe.GFplantfid,CGlobe.Gfname,CGlobe.Gfid);
string sql=Fs.GetRoleMachineGroupSql(CGlobe.GFrolefID);
if(sql == "")return;
//
DataTable dt = Pbase.GetDatetable(null,sql);
TreeNode root = new TreeNode("机床组分组情况列表",0,0);
this.treeView1.Nodes.Add(root);
if(dt.Rows.Count>0)
{
for(int i=0;i<dt.Rows.Count;i++)
{
TreeNode Group = new TreeNode(dt.Rows[i]["fname"].ToString(),1,2);
Group.Tag = dt.Rows[i]["fid"].ToString();
root.Nodes.Add(Group);
sql = "select fid,fname from DNC_SYS_MACHINE where FGROUPFID='"+
dt.Rows[i]["fid"].ToString()+"'";
DataTable Dt = Pbase.GetDatetable(null,sql);
if(Dt.Rows.Count > 0)
{
for(int ii = 0 ;ii<Dt.Rows.Count;ii++)
{
TreeNode Machine = new TreeNode(Dt.Rows[ii]["fname"].ToString(),1,2);
Machine.Tag = Dt.Rows[ii]["fid"];
Group.Nodes.Add(Machine);
}
}
}
}
}
TreeNode SelNode;
private void treeView1_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
{
if(SelNode != null)SelNode.BackColor = System.Drawing.SystemColors.Window;
TreeNode node = this.treeView1.GetNodeAt(e.X,e.Y);
if(node == null)return;
if(node.Parent== null)return;
if(node.Parent.Parent == null)return;
if(node.Nodes.Count > 0)return;
SelNode = node;
SelNode.BackColor = Color.Silver;
string sql = "select * from DNC_SYS_MACHINE where fid='"
+ node.Tag.ToString()+"'";
DataRow dr = Pbase.GetDatetable(null,sql).Rows[0];
CombFind(ref FGROUPFID,dr["FGROUPFID"].ToString(),true);
CombFind(ref FRMARTSTART,dr["FRMARTSTART"].ToString(),false);
CombFind(ref FRMARTEND,dr["FRMARTEND"].ToString(),false);
FRMARTROW.Text= dr["FRMARTROW"].ToString();
FNAME.Text = dr["FNAME"].ToString();
FDESC.Text = dr["FDESC"].ToString();
string FProgramExpl,FProgramReturn;
FProgramExpl = dr["FProgramExpl"].ToString();
FProgramReturn = dr["FProgramReturn"].ToString();
if(FProgramExpl == "1")ProgramExpl.Checked=true;
else ProgramExpl.Checked=false;
if(FProgramReturn == "1")ProgramReturn.Checked = true;
else ProgramReturn.Checked = false;
this.Fid = node.Tag.ToString();
}
private void button2_Click(object sender, System.EventArgs e)
{
if(SelNode == null)
{
MessageBox.Show("对不起，您没有选择到机床，系统无法删除！",CGlobe.Gmsg);
return;
}
FNAME.ForeColor = Color.Black;
string sql = "select fid from dnc_productprogram where fmachinefid='"
+ SelNode.Tag.ToString()+"'";
DataTable dt = Pbase.GetDatetable(null,sql);
if(dt.Rows.Count > 0)
{
MessageBox.Show("对不起，您所要删除的机床已经添加数据，系统不允许删除！",CGlobe.Gmsg);
return;
}
DialogResult Result = MessageBox.Show("确定删除操作？",
CGlobe.Gmsg,MessageBoxButtons.OKCancel,MessageBoxIcon.Question,MessageBoxDefaultButton.Button2);
if(Result == DialogResult.OK)
{
sql = "delete from DNC_SYS_MACHINE where fid='"
+ SelNode.Tag.ToString()+"'";
Pbase.ExecuteSql(null,sql,rulebase.SqlResultEnum.Have);
SelNode.Remove();
}
}
------------------------------------------------------------------------------------------
private void FMachineSel_Load(object sender, System.EventArgs e)
{
PbaseUpdate Pbase = new PbaseUpdate();
TreeNode Root1 = new TreeNode("机床选择",0,1);
Root1.Tag=0;
this.treeView1.Nodes.Add(Root1);
string sql = "";
sql="select Fid,Fname from dnc_sys_plant where fid like '"+CGlobe.GFplantfid+"%'";
DataTable Dt = Pbase.GetDatetable(null,sql);
if(Dt.Rows.Count > 0)
{
for(int i=0;i<Dt.Rows.Count;i++)
{
TreeNode Pnode = new TreeNode(Dt.Rows[i][1].ToString(),4,4);
Pnode.Tag = Dt.Rows[i][0].ToString();
Root1.Nodes.Add(Pnode);
//
WindControl.FileReslove Fs = new WindControl.FileReslove(CGlobe.GFplantfid,CGlobe.Gfname,CGlobe.Gfid);
sql=Fs.GetRoleMachineGroupSql(CGlobe.GFrolefID);
if(sql == "")return;
DataTable DtGroup = Pbase.GetDatetable(null,sql);
if(DtGroup.Rows.Count>0)
{
for(int ii = 0 ;ii< DtGroup.Rows.Count;ii++)
{
TreeNode Gnode = new TreeNode(DtGroup.Rows[ii][1].ToString(),4,4);
Gnode.Tag = DtGroup.Rows[ii][0].ToString();
Pnode.Nodes.Add(Gnode);
sql = "select fid,fname from dnc_sys_machine where fgroupfid like '" + Gnode.Tag.ToString()+"%'";
DataTable DtM = Pbase.GetDatetable(null,sql);
if(DtM.Rows.Count > 0)
{
for(int iii =0;iii<DtM.Rows.Count;iii++)
{
TreeNode Mnode = new TreeNode(DtM.Rows[iii][1].ToString(),4,4);
Mnode.Tag = DtM.Rows[iii][0].ToString();
Gnode.Nodes.Add(Mnode);
}
}
DtM.Dispose();
}
}
DtGroup.Dispose();
}
}
Dt.Dispose();
---------------------------------------------------------------------------------------------
private void treeView1_DoubleClick(object sender, System.EventArgs e)
{
TreeNode Selnode = this.treeView1.SelectedNode;
this.label1.Text = Selnode.FullPath;
}
TreeNode Mnode;
private void treeView1_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
{
Point point = new Point(e.X,e.Y);
Mnode = this.treeView1.GetNodeAt(point);
if(Mnode == null)return;
string[] str = CGlobe.GParm.Split('|');
if(str.Length<0)return;
if(str.Length>1)
{
if(Mnode.Parent == null || Mnode.Parent.Tag.ToString() != "2")return;
if(CGlobe.GParm == "")return;//CGlobe.GParm
if(e.Button == MouseButtons.Right)
{
this.treeView1.ContextMenu = this.contextMenu1;
}
}
else
{
if(Mnode.Parent==null)return;
if(Mnode.Parent.Parent==null)return;
if(Mnode.Parent.Parent.Parent == null)return;
if(e.Button == MouseButtons.Right)
{
this.treeView1.ContextMenu = this.contextMenu1;
}
}
}
---------------------------------------------------------------------------------
sql="select * from DNC_SYS_MACHINEGROUP where FPLANTFID='"
+ CGlobe.GFplantfid+"' and fid like '"
+ fgroup+"'";
DataTable Dt = Pbase.GetDatetable(null,sql);
if(Dt.Rows.Count<=0)
{
MessageBox.Show("请先维护机床组，目前系统目有机床组！",CGlobe.Gmsg);
return;
}
else
{
for(int i =0;i<Dt.Rows.Count;i++)
{
string[] itemGroup = new string[4]{
i.ToString(),
Dt.Rows[i]["FNAME"].ToString(),
Dt.Rows[i]["FDESC"].ToString(),
Dt.Rows[i]["FTIME"].ToString()
};
ListViewItem lig = new ListViewItem(itemGroup);
lig.Tag = Dt.Rows[i]["FID"].ToString();
lig.ImageIndex= 0;
lig.StateImageIndex=0;
this.listView1.Items.Add(lig);
}
}
--------------------------------------------------------------------------------------
bool SysSet = false;
private void FMachineGroup_Load(object sender, System.EventArgs e)
{
#region treeview
TreeNode Root = new TreeNode("机床组设置");
Root.Tag=0;
PbaseUpdate Pbase = new PbaseUpdate();
this.treeVSystem.Nodes.Add(Root);
string sql = "select fid,fname from dnc_sys_plant where fid like '"+CGlobe.GFplantfid+"%'";
DataTable Dt = Pbase.GetDatetable(null,sql);
if(Dt.Rows.Count>0)
{
for(int i=0;i<Dt.Rows.Count;i++)
{
TreeNode PlantNode = new TreeNode(Dt.Rows[i][1].ToString());
PlantNode.ImageIndex = 1;
PlantNode.SelectedImageIndex = 2;
PlantNode.Tag= Dt.Rows[i][0].ToString();
Root.Nodes.Add(PlantNode);
//
WindControl.FileReslove Fs = new FileReslove(CGlobe.GFplantfid,CGlobe.Gfname,CGlobe.Gfid);
sql=Fs.GetRoleMachineGroupSql(CGlobe.GFrolefID);
if(sql == "")return;
//
DataTable dt = Pbase.GetDatetable(null,sql);
if(dt.Rows.Count>0)
{
for(int ii=0;ii<dt.Rows.Count;ii++)
{
TreeNode NodeMachGr = new TreeNode(dt.Rows[ii][1].ToString());
NodeMachGr.Tag = dt.Rows[ii][0].ToString();
PlantNode.Nodes.Add(NodeMachGr);
}
}
dt.Dispose();
}
}
Dt.Dispose();
//
RDncManager.PManager PM = new RDncManager.PManager();
string FValue = "0";
PM.GetSysConfig(CGlobe.GFplantfid,"T_ProgramSendMuti",ref FValue);
if(FValue == "0")
SysSet = false;
else
SysSet = true;
//
#endregion treeview
}
private void treeVSystem_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
{
if(e.Button == MouseButtons.Right)
{
Nbase nbase = new Nbase();
if(CGlobe.GFrolefID == "%" || nbase.Popedom("AddMachineGroup",CGlobe.Gfrole))
{
this.treeVSystem.ContextMenu = this.contextMenu1;
Point point = new Point(e.X,e.Y);
node = this.treeVSystem.GetNodeAt(point);
if(node == null)return;
}
else
return;
}
}
TreeNode node;
Groupnodelable formnode;
private void menuItemClick(object sender, System.EventArgs e)
{
if(CGlobe.GFrolefID == "%")
{
MessageBox.Show("抱歉超级用户不允许添加机床组！",CGlobe.Gmsg);
return;
}
MenuItem Mitem = (MenuItem)sender;
switch(Mitem.MergeOrder)
{
case 4:
CreateGroup();
break;
case 1:
EditGroup();
break;
case 2:
DelGroup();
break;
case 3:
ConnToMachine();
break;
default:
break;
}
}
private void CreateGroup()
{
if(node == null)return;
if(node.Parent == null )return;
if(node.Parent.Parent != null)return;
TreeNode trnode = new TreeNode();
trnode.Tag = Guid.NewGuid().ToString();
TreeNode Gnode = GetNode("",trnode);
if(Gnode == null) return;
SortedList sl = new SortedList();
sl.Add("FID",Gnode.Tag.ToString());
string FName = "",FIPAddress = "";
if(CGlobe.GParm.Split('|').Length > 1)
{
FName = CGlobe.GParm.Split('|')[0];
FIPAddress = CGlobe.GParm.Split('|')[1];
}
else
FName = CGlobe.GParm;
sl.Add("Fname",FName);
sl.Add("FServiceIP",FIPAddress);
sl.Add("Fplantfid",node.Tag.ToString());
PbaseUpdate Pbase = new PbaseUpdate();
if(Pbase.Save(null,sl,EntityTypeEnum.DNC_Sys_MachineGroup,"FID",SaveOptionEnum.Insert))
{
listView1.ForeColor = Color.Silver;
node.Nodes.Add(Gnode);
string[] str = new string[2]
{
Gnode.Text,DateTime.Now.ToString()
};
ListViewItem li = new ListViewItem(str,0);
li.ImageIndex=3;
li.ForeColor = Color.SlateGray;
li.Tag = sl["FID"].ToString();
this.listView1.Items.Add(li);
}
}
private void DelGroup()
{
if(node.Parent==null)return;
if(node.Parent.Parent == null) return;
string sql = "delete from dnc_sys_machinegroup where fid='"+node.Tag.ToString()+"'";
PbaseUpdate Pbase = new PbaseUpdate();
if(Pbase.ExecuteSql(null,sql,SqlResultEnum.No) != System.DBNull.Value)
{
for(int i=0;i<this.listView1.Items.Count;i++)
{
ListViewItem li = this.listView1.Items[i];
if(li.Tag == node.Tag)
{
li.Remove();
}
}
node.Remove();
}
}
private void treeVSystem_DoubleClick(object sender, System.EventArgs e)
{
TreeNode Selnode = this.treeVSystem.SelectedNode;
this.listView1.Items.Clear();
PbaseUpdate Pbase = new PbaseUpdate();
string Condition = CGlobe.GFplantfid;
if(Selnode.Parent==null)
{
Condition = CGlobe.GFplantfid;
}
if(Selnode.Parent != null)
Condition = Selnode.Tag.ToString();
WindControl.FileReslove Fs = new FileReslove(CGlobe.GFplantfid,CGlobe.Gfname,CGlobe.Gfid);
string sql=Fs.GetRoleMachineGroupSql(CGlobe.GFrolefID);
if(sql == "")return;
//
DataTable dt =Pbase.GetDatetable(null,sql);
if(dt.Rows.Count>0)
{
for(int i=0;i<dt.Rows.Count;i++)
{
ListViewItem li = new ListViewItem(dt.Rows[i][1].ToString());
li.ImageIndex=1;
li.Tag = dt.Rows[i][0].ToString();
this.listView1.Items.Add(li);
}
return;
}
dt.Dispose();
if(Selnode.Parent==null)return;
if(Selnode.Parent.Parent != null)
{
ListViewItem li = new ListViewItem(Selnode.Text);
li.ImageIndex=1;
li.Tag = Selnode.Tag;
this.listView1.Items.Add(li);
}
}
private void listView1_DoubleClick(object sender, System.EventArgs e)
{
ListViewItem li = this.listView1.SelectedItems[0];
this.listView2.Items.Clear();
string sql="select fname,ftime from dnc_sys_machine where fgroupfid like '"+li.Tag+"%'";
PbaseUpdate Pbase = new PbaseUpdate();
DataTable dt = Pbase.GetDatetable(null,sql);
if(dt.Rows.Count>0)
{
for(int i=0;i<dt.Rows.Count;i++)
{
string[] str = new string[2]
{
dt.Rows[i][0].ToString(),
dt.Rows[i][1].ToString()
};
ListViewItem list = new ListViewItem(str);
list.ImageIndex=3;
list.ForeColor = Color.Green;
this.listView2.Items.Add(list);
}
}
}
------------------------------------------------------------------------------------------------------
TreeNode Root = new TreeNode("用户权限设置");
Root.Tag=0;
this.TreeSysRole.Nodes.Add(Root);
sql = "select fid,fname from dnc_sys_plant where fid like '"+CGlobe.GFplantfid+"%'";
DataTable Dt = Pbase.GetDatetable(null,sql);
if(Dt.Rows.Count>0)
{
for(int i=0;i<Dt.Rows.Count;i++)
{
TreeNode PlantNode = new TreeNode(Dt.Rows[i][1].ToString());
PlantNode.Tag= Dt.Rows[i][0].ToString();
Root.Nodes.Add(PlantNode);
sql = "select Fid,Fname from dnc_sys_role where fplantfid like '"+Dt.Rows[i][0].ToString()+"%'";
DataTable DtRole = Pbase.GetDatetable(null,sql);
if(DtRole.Rows.Count>0)
{
for(int ii=0;ii<DtRole.Rows.Count;ii++)
{
TreeNode RoleNode = new TreeNode(DtRole.Rows[ii][1].ToString());
RoleNode.Tag = DtRole.Rows[ii][0].ToString();
if(RoleFid.IndexOf(RoleNode.Tag.ToString())!= -1)
RoleNode.BackColor = Color.Red;
PlantNode.Nodes.Add(RoleNode);
}
}
DtRole.Dispose();
}
}
Dt.Dispose();
-----------------------------------------------------------------------------------------
private void Dnc_sys_menu_bind(ListView listv)
{
PbaseUpdate Pbase = new PbaseUpdate();
string sql = "select Forder,Fname,Fdesc,Fmenu from dnc_sys_menu ";
DataTable Dt = Pbase.GetDatetable(null,sql);
listv.BackColor = Color.Silver;
if(Dt.Rows.Count>0)
{
for(int i=0;i<Dt.Rows.Count;i++)
{
string[] Lstview = new string[3]
{
Dt.Rows[i][0].ToString(),
Dt.Rows[i][1].ToString(),
Dt.Rows[i][2].ToString()
};
ListViewItem li = new ListViewItem(Lstview,1);
li.Tag=Dt.Rows[3].ToString();
li.Checked = true;
listv.Items.Add(li);
}
}
Dt.Dispose();
}
private void RoleBind(string RoleFid)
{
this.listViewOwn.Items.Clear();
PbaseUpdate Pbase = new PbaseUpdate();
string[] GroRoleFid = RoleFid.Split('|');
for(int ii=0;ii< GroRoleFid.Length;ii++)
{
string sql = "select fcontent from dnc_sys_role where fid like '" + GroRoleFid[ii] + "%'";
Object obj= Pbase.ExecuteSql(null,sql,SqlResultEnum.Have);
string Role ="";
if(obj == null) continue;
Role= Convert.ToString(obj);
string[] RoleName = Role.Split('|');
if(RoleName.Length>0)
{
this.listViewOwn.CheckBoxes = true;
// this.listViewOwn.BackColor = Color.Silver;
// PbaseUpdate Pbase = new PbaseUpdate();
DataTable Dt;
for(int i=0;i<RoleName.Length;i++)
{
sql = "select Forder,Fname,Fdesc from dnc_sys_menu where Fmenu='"+RoleName[i]+"'";
Dt = Pbase.GetDatetable(null,sql);
if(Dt.Rows.Count>0)
{
string[] Lstview = new string[3]
{
Dt.Rows[0][0].ToString(),
Dt.Rows[0][1].ToString(),
Dt.Rows[0][2].ToString()
};
ListViewItem li = new ListViewItem(Lstview,1);
li.Tag=RoleName[i];
li.Checked = true;
this.listViewOwn.Items.Add(li);
}
Dt.Dispose();
}
}
}
}
TreeNode node;
private void TreeSysRole_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
{
Nbase MenuBase = new Nbase();
if(e.Button==MouseButtons.Right)
{
if(MenuBase.Popedom("Btn_Role",CGlobe.Gfrole) || CGlobe.Gfrole == "%")
{
this.TreeSysRole.ContextMenu=this.contextMenu1;
Point point=new Point(e.X,e.Y);
node=this.TreeSysRole.GetNodeAt(point);
}
else
{
MessageBox.Show("对不起，你没有角色定制权限！",CGlobe.Gmsg);
return;
}
}
}
private void menuItem1_Click(object sender, System.EventArgs e)
{
if(node==null)
{
return;
}
else
{
if(node.Parent == null)return;
if(node.Nodes.Count != 0 || node.Parent.Parent == null)
{
MessageBox.Show("对不起，你所选择的不是角色，请重新选择！",CGlobe.Gmsg);
return;
}
else
{
PbaseUpdate Pbase = new PbaseUpdate();
string NRoleFid = node.Tag.ToString();
string sql = "select frolefid from dnc_sys_employee where fid='"
+ CGlobe.GParm+"'";
DataTable dt = Pbase.GetDatetable(null,sql);
if(dt.Rows[0][0].ToString().Trim().Length > 0 )
NRoleFid = NRoleFid+"|" + dt.Rows[0][0].ToString().Trim();
if(NRoleFid.Length > 150 )
{
MessageBox.Show("对不起,系统禁止为同一用户赋予的角色超过了四个!",CGlobe.Gmsg);
return;
}
sql="update dnc_sys_employee set frolefid = '"+ NRoleFid
+"' where fid='"+CGlobe.GParm+"'";
if(Pbase.ExecuteSql(null,sql,SqlResultEnum.No) != System.DBNull.Value)
{
MessageBox.Show("角色分配成功！",CGlobe.Gmsg);
this.TreeSysRole.Nodes.Clear();
this.listViewOwn.Items.Clear();
this.listViewSys.Items.Clear();
WinSysInit();
return;
}
}
}
}
private void TreeSysRole_DoubleClick(object sender, System.EventArgs e)
{
TreeNode SelNode = this.TreeSysRole.SelectedNode;
if(SelNode != null)
{
RoleBind(SelNode.Tag.ToString());
}
}
private void menuItem4_Click(object sender, System.EventArgs e)
{
PbaseUpdate Pbase = new PbaseUpdate();
string sql="update dnc_sys_employee set frolefid = '' where fid='"+CGlobe.GParm+"'";
if(Pbase.ExecuteSql(null,sql,SqlResultEnum.No) != System.DBNull.Value)
{
MessageBox.Show("角色清除成功成功！",CGlobe.GParm);
this.TreeSysRole.Nodes.Clear();
this.listViewOwn.Items.Clear();
this.listViewSys.Items.Clear();
WinSysInit();
return;
}
}
---------------------------------------------------------------------------------------------------------
DialogResult DLG = MessageBox.Show("确定删除所选日期以前的操作日志?",CGlobe.Gmsg,System.Windows.Forms.MessageBoxButtons.OKCancel);
if(DLG == DialogResult.Cancel)return;
DateTime dtime = this.dateTimePicker1.Value;
string StatTime = String.Format("{0:yyyy-MM-dd}",dtime);
if(dt.Rows.Count > 0 )
{
for(int i=0;i<dt.Rows.Count;i++)
{
string datatype="数控程序";
if(dt.Rows[i][5].ToString() == "1" )
datatype = "刀具清单";
if(dt.Rows[i][5].ToString() == "2")
datatype = "其他";
string[] str = new string[6]
{
dt.Rows[i][2].ToString(),
dt.Rows[i][1].ToString(),
dt.Rows[i][4].ToString(),
dt.Rows[i][3].ToString(),
datatype,
li.SubItems[2].Text.Trim()
};
ListViewItem list = new ListViewItem(str);
list.ImageIndex = 1;
list.Tag = dt.Rows[i][0].ToString();
this.listView2.Items.Add(list);
}
}
}
private void listView1_DoubleClick(object sender, System.EventArgs e)
{
listvdbclick();
}
/// <summary>
/// 第二个listView显示的数据
/// </summary>
private void listvdbclick()
{
ListViewItem li = this.listView1.SelectedItems[0];
if( li == null)return;
if(li != null)
{
WindControl.CSystemWorkLog CSysLog = (WindControl.CSystemWorkLog)li.Tag;
this.listView1.BringToFront();
listView2.Items.Clear();
if(li == null )return;
string sql = "select fid,FCREATENAME,FPROGRAME,FEDITION,FTIME,FSIGN from DNC_PRODUCTPROGRAM_VIEW where "
+"FPROGRAMFID = '" + CSysLog.FProgramId
+"' and fisdelete = 0 order by FEDITION desc";
DataTable dt = Pbase.GetDatetable(null,sql);
if(dt.Rows.Count > 0 )
{
for(int i=0;i<dt.Rows.Count;i++)
{
string datatype="数控程序";
if(dt.Rows[i][5].ToString() == "1" )
datatype = "刀具清单";
if(dt.Rows[i][5].ToString() == "2")
datatype = "其他";
string[] str = new string[6]
{
dt.Rows[i][2].ToString(),
dt.Rows[i][1].ToString(),
dt.Rows[i][4].ToString(),
dt.Rows[i][3].ToString(),
datatype,
li.SubItems[2].Text.Trim()
};
ListViewItem list = new ListViewItem(str);
list.ImageIndex = 1;
list.Tag = dt.Rows[i][0].ToString();
this.listView2.Items.Add(list);
}
}
}
}
private void btnTrue_Click(object sender, System.EventArgs e)
{
try
{
TreeNode SelNode =TrPruductStruct.SelectedNode;
if(SelNode==null)
{
MessageBox.Show("对不起，您没有选中节点，系统无法确认，请重新选择！",CGlobe.Gmsg);
return;
}
////////////////
if(SelNode.Parent == null)
{
MessageBox.Show("对不起，根节点不允许添加程序！",CGlobe.Gmsg);
return;
}
string FStructFid = SelNode.Tag.ToString();
string TempMachine = FStructFid;
PManager Pmanager = new PManager();
bool NodeJudge = Pmanager.JudgeMachine(ref TempMachine);
if(!NodeJudge)
{
string FValue ="";
Pmanager.GetSysConfig(CGlobe.GFplantfid,"T_MachineProgram",ref FValue);
if(FValue == "1")
{
MessageBox.Show("对不起,您所选择的不是机床节点,系统禁止在非机床节点上进行程序添加!",CGlobe.Gmsg);
return;
}
}
//////////////////
string[] StrP = CGlobe.GParm.Split('|');
CGlobe.GParm= "1";
string sql="";
if(StrP.Length < 3)
{
return;
}
if(StrP[0]=="011")
{
sql="update DNC_PRODUCTTRANSLIST set FDISPOSESIGN=5 where fid='"
+StrP[1]+"'";
Pbase.ExecuteSql(null,sql,rulebase.SqlResultEnum.Have);
SelNode.Remove();
}
else
{
try
{
if(StrP[0] == "010")//手工编程
{
sql = "select FPROGRAMFID from DNC_PRODUCTTRANSLIST where fid='"
+StrP[1]+"'";
Object Obj = Pbase.ExecuteSql(null,sql,rulebase.SqlResultEnum.Have);
if(Obj== null)return;
StrP[2] = StrP[2].Substring(0,StrP[2].IndexOf('['));
string FProgramFid=Obj.ToString();
SortedList sl = new SortedList();
string Fid = Guid.NewGuid().ToString();
sl.Add("FID",Fid);
sl.Add("FNAME",StrP[2]);
sl.Add("FPLANTFID",CGlobe.GFplantfid);
sl.Add("FSTRUCTFID",SelNode.Tag.ToString());
sl.Add("FEDITION",0);
sl.Add("FCREATEFID",CGlobe.Gfid);
sl.Add("FCREATENAME",CGlobe.Gfname);
sl.Add("FISIMPORT",0);///11月3日修改
sl.Add("FSIGN",1);////11月3日修改
if(NodeJudge)
{
sl.Add("FMACHINEFID",TempMachine.Split('|')[0]);//07年3月26日改
sl.Add("FMACHINE",TempMachine.Split('|')[1]);//07年3月26日改
}
sl.Add("FISDELETE",0);
FileReslove FS = new FileReslove(CGlobe.GFplantfid,CGlobe.Gfname,CGlobe.Gfid);
sl.Add("FTIME",DateTime.Now);
sl.Add("FCOMPUTERNAME",FS.GetTcpip().ToString());
sl.Add("FPROGRAMNAME",StrP[2]);
if(Pbase.Save(null,sl,rulebase.EntityTypeEnum.DNC_ProductProgram,"FID",rulebase.SaveOptionEnum.Insert))
{
sql="update DNC_PRODUCTPROGRAM_VIEW set FPROGRAMFID='"
+Fid+"', FSTRUCTFID='"
+SelNode.Tag.ToString()+"' where fid='"
+FProgramFid + "'";
Obj = Pbase.ExecuteSql(null,sql,rulebase.SqlResultEnum.No);
sql="update DNC_PRODUCTTRANSLIST set FPROGRAMFID='"
+Fid+"',FDISPOSESIGN=3 where fid='"
+StrP[1]+"'";
Pbase.ExecuteSql(null,sql,rulebase.SqlResultEnum.No);
CGlobe.GParm = "0";
}
}
----------------------------------------------------------------------------------------
private void btnTrue_Click(object sender, System.EventArgs e)
{
try
{
TreeNode SelNode =TrPruductStruct.SelectedNode;
if(SelNode==null)
{
MessageBox.Show("对不起，您没有选中节点，系统无法确认，请重新选择！",CGlobe.Gmsg);
return;
}
////////////////
if(SelNode.Parent == null)
{
MessageBox.Show("对不起，根节点不允许添加程序！",CGlobe.Gmsg);
return;
}
string FStructFid = SelNode.Tag.ToString();
string TempMachine = FStructFid;
PManager Pmanager = new PManager();
bool NodeJudge = Pmanager.JudgeMachine(ref TempMachine);
if(!NodeJudge)
{
string FValue ="";
Pmanager.GetSysConfig(CGlobe.GFplantfid,"T_MachineProgram",ref FValue);
if(FValue == "1")
{
MessageBox.Show("对不起,您所选择的不是机床节点,系统禁止在非机床节点上进行程序添加!",CGlobe.Gmsg);
return;
}
}
//////////////////
string[] StrP = CGlobe.GParm.Split('|');
CGlobe.GParm= "1";
string sql="";
if(StrP.Length < 3)
{
return;
}
if(StrP[0]=="011")
{
sql="update DNC_PRODUCTTRANSLIST set FDISPOSESIGN=5 where fid='"
+StrP[1]+"'";
Pbase.ExecuteSql(null,sql,rulebase.SqlResultEnum.Have);
SelNode.Remove();
}
else
{
try
{
if(StrP[0] == "010")//手工编程
{
sql = "select FPROGRAMFID from DNC_PRODUCTTRANSLIST where fid='"
+StrP[1]+"'";
Object Obj = Pbase.ExecuteSql(null,sql,rulebase.SqlResultEnum.Have);
if(Obj== null)return;
StrP[2] = StrP[2].Substring(0,StrP[2].IndexOf('['));
string FProgramFid=Obj.ToString();
SortedList sl = new SortedList();
string Fid = Guid.NewGuid().ToString();
sl.Add("FID",Fid);
sl.Add("FNAME",StrP[2]);
sl.Add("FPLANTFID",CGlobe.GFplantfid);
sl.Add("FSTRUCTFID",SelNode.Tag.ToString());
sl.Add("FEDITION",0);
sl.Add("FCREATEFID",CGlobe.Gfid);
sl.Add("FCREATENAME",CGlobe.Gfname);
sl.Add("FISIMPORT",0);///11月3日修改
sl.Add("FSIGN",1);////11月3日修改
if(NodeJudge)
{
sl.Add("FMACHINEFID",TempMachine.Split('|')[0]);//07年3月26日改
sl.Add("FMACHINE",TempMachine.Split('|')[1]);//07年3月26日改
}
sl.Add("FISDELETE",0);
FileReslove FS = new FileReslove(CGlobe.GFplantfid,CGlobe.Gfname,CGlobe.Gfid);
sl.Add("FTIME",DateTime.Now);
sl.Add("FCOMPUTERNAME",FS.GetTcpip().ToString());
sl.Add("FPROGRAMNAME",StrP[2]);
if(Pbase.Save(null,sl,rulebase.EntityTypeEnum.DNC_ProductProgram,"FID",rulebase.SaveOptionEnum.Insert))
{
sql="update DNC_PRODUCTPROGRAM_VIEW set FPROGRAMFID='"
+Fid+"', FSTRUCTFID='"
+SelNode.Tag.ToString()+"' where fid='"
+FProgramFid + "'";
Obj = Pbase.ExecuteSql(null,sql,rulebase.SqlResultEnum.No);
sql="update DNC_PRODUCTTRANSLIST set FPROGRAMFID='"
+Fid+"',FDISPOSESIGN=3 where fid='"
+StrP[1]+"'";
Pbase.ExecuteSql(null,sql,rulebase.SqlResultEnum.No);
CGlobe.GParm = "0";
}
}
}
catch(Exception ex)
{
throw ex;
}
this.Close();
this.Dispose();
}
}
catch(Exception ex)
{
throw ex;
}
}
----------------------------------------------------------------------------------------------------------
