?? zzjg_contrl.cs
字號:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using Datamodel;
namespace Data_Contrl
{
/* ****************************************************
重慶杰諾軟件開發工作室
QQ:83898700
EMAIL:gimao@163.com
url:www.gisii.com
***************************************************** */
/// <summary>
/// zzjg_Contrl 的摘要說明。
/// </summary>
public class zzjg_Contrl
{
public zzjg_Contrl()
{
//
// TODO: 在此處添加構造函數邏輯
//
}
/// <summary>
/// 部門維護的樹形菜單
/// </summary>
/// <returns></returns>
public string TreeLoad()
{
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
string strSQL="select * from H_bm order by id asc";
Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
string arr_tree="<DIV class=deeptree>";
arr_tree+="<script lanage=javascript>";
arr_tree+="var a=new TreeView(\'a\',\'main\');";
while(Rs.Read()==true)
{
arr_tree+="a.add("+Rs["id"]+","+Rs["Parentid"]+",\""+Rs["bmnr"].ToString()+"\",\"sys_zzjg.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
}
arr_tree+="document.write(a);";
arr_tree+="a.expandAll();";
arr_tree+="</script>";
arr_tree+="</DIV>";
Rs.Close();
my.CloseConn();
return arr_tree;
}
/// <summary>
/// 設備維護的部門樹
/// </summary>
/// <returns></returns>
public string Sbwf_TreeLoad()
{
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
string strSQL="select * from H_bm order by id asc";
Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
string arr_tree="<DIV class=deeptree>";
arr_tree+="<script lanage=javascript>";
arr_tree+="var a=new TreeView(\'a\',\'main\');";
while(Rs.Read()==true)
{
arr_tree+="a.add("+Rs["id"]+","+Rs["Parentid"]+",\""+Rs["bmnr"].ToString()+"\",\"sbwf.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
}
arr_tree+="document.write(a);";
arr_tree+="a.expandAll();";
arr_tree+="</script>";
arr_tree+="</DIV>";
Rs.Close();
my.CloseConn();
return arr_tree;
}
/// <summary>
/// 維護界面的主部門
/// </summary>
/// <param name="Parentid"></param>
/// <returns></returns>
public string WfTreeinit(int Parentid)
{
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
string strSQL="select * from H_bm where id="+Parentid+" order by id asc";
Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
string arr_tree="<DIV class=deeptree>";
arr_tree+="<script lanage=javascript>";
arr_tree+="var a=new TreeView(\'a\',\'main\');";
while(Rs.Read()==true)
{
arr_tree+="a.add("+Rs["id"]+",0,\""+Rs["bmnr"].ToString()+"\",\"sbwf.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
arr_tree+=WfGetSub(Convert.ToInt32(Rs["id"].ToString()));
}
arr_tree+="document.write(a);";
arr_tree+="a.expandAll();";
arr_tree+="</script>";
arr_tree+="</DIV>";
Rs.Close();
my.CloseConn();
return arr_tree;
}
/// <summary>
/// 維護界面需要的子部門
/// </summary>
/// <param name="Parentid"></param>
/// <returns></returns>
public string WfGetSub(int Parentid)
{
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
string strSQL="select * from H_bm where parentid="+Parentid+" order by id asc";
Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
string arr_tree=string.Empty;
while(Rs.Read()==true)
{
arr_tree+="a.add("+Rs["id"]+","+Rs["Parentid"]+",\""+Rs["bmnr"].ToString()+"\",\"sbwf.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
arr_tree+=WfGetSub(Convert.ToInt32(Rs["id"].ToString()));
}
Rs.Close();
my.CloseConn();
return arr_tree;
}
/// <summary>
/// 生成一個完整的部門樹
/// </summary>
/// <param name="sel"></param>
/// <returns></returns>
public string TreeLoad(string sel)
{
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
string strSQL="select * from H_bm order by id asc";
Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
string arr_tree="<DIV class=deeptree>";
arr_tree+="<script lanage=javascript>";
arr_tree+="var a=new TreeView(\'a\',\'main\');";
while(Rs.Read()==true)
{
arr_tree+="a.add("+Rs["id"]+","+Rs["Parentid"]+",\""+Rs["bmnr"].ToString()+"\",\"\");";
}
arr_tree+="document.write(a);";
arr_tree+="a.expandAll();";
arr_tree+="</script>";
arr_tree+="</DIV>";
Rs.Close();
my.CloseConn();
return arr_tree;
}
/// <summary>
/// 增加主部門
/// </summary>
/// <param name="id"></param>
/// <param name="bmnr"></param>
/// <returns></returns>
public string Tree_Create(int id,string bmnr)
{
string sqlstr="insert into H_bm (Parentid,bmnr) values ("+id+",'"+bmnr+"')";
try
{
CreateDb mydb = new CreateDb();
DBManager my = mydb.Createdb();
my.OpenConn();
my.ExecutenonQuery(my.ExeCommand(sqlstr));
my.CloseConn();
return "增加欄目成功";
}
catch(Exception e)
{
throw (e);
}
}
/// <summary>
/// 刪除部門
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string Tree_Del(int id)
{
try
{
CreateDb mydb = new CreateDb();
DBManager my = mydb.Createdb();
my.OpenConn();
string Sqlstr="select * from H_bm where parentid="+id;
IDataReader Rs=null;
Rs=my.ExecuteCreateReader(my.ExeCommand(Sqlstr));
if(Rs.Read()==true)
{
Rs.Close();
return "不能刪除他下面還有子欄目！";
}
else
{
Rs.Close();
try
{
my.CloseConn();
CreateDb mydb1 = new CreateDb();
DBManager my1 = mydb.Createdb();
my1.OpenConn();
string sqlStr1="delete from H_bm where id="+id;
my1.ExecutenonQuery(my1.ExeCommand(sqlStr1));
my1.CloseConn();
CreateDb mydb2 = new CreateDb();
DBManager my2 = mydb.Createdb();
my2.OpenConn();
string sqlStr2="delete from H_Sb_info where classid="+id;
my2.ExecutenonQuery(my2.ExeCommand(sqlStr2));
my2.CloseConn();
return "刪除欄目成功!";
}
catch
{
return "刪除不成功";
}
}
}
catch
{
return "不能刪除欄目！";
}
}
/// <summary>
/// 修改樹
/// </summary>
/// <param name="TreeList"></param>
public string Tree_Update(int id,string bmnr)
{
try
{
string sqlStr="Update H_bm set bmnr='"+bmnr+"' where id="+id;
CreateDb mydb = new CreateDb();
DBManager my = mydb.Createdb();
my.OpenConn();
my.ExecutenonQuery(my.ExeCommand(sqlStr));
my.CloseConn();
return "欄目修改成功！";
}
catch
{
return "欄目修改不成功！";
}
}
/// <summary>
/// 新增加主類別
/// </summary>
/// <param name="TreeList"></param>
public string Tree_Insert(string bmnr)
{
try
{
string sqlstr="insert into H_bm (Parentid,bmnr) values (0,'"+bmnr+"')";
CreateDb mydb = new CreateDb();
DBManager my = mydb.Createdb();
my.OpenConn();
my.ExecutenonQuery(my.ExeCommand(sqlstr));
my.CloseConn();
return "增加欄目成功！";
}
catch(Exception e)
{
throw (e);
}
}
/// <summary>
/// 顯示部門樹形菜單
/// </summary>
/// <param name="Parentid"></param>
/// <returns></returns>
public string Treeinit(int Parentid)
{
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
string strSQL="select * from H_bm where id="+Parentid+" order by id asc";
Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
string arr_tree="<DIV class=deeptree>";
arr_tree+="<script lanage=javascript>";
arr_tree+="var a=new TreeView(\'a\',\'main\');";
while(Rs.Read()==true)
{
arr_tree+="a.add("+Rs["id"]+",0,\""+Rs["bmnr"].ToString()+"\",\"sys_zzjg.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
arr_tree+=GetSub(Convert.ToInt32(Rs["id"].ToString()));
}
arr_tree+="document.write(a);";
arr_tree+="a.expandAll();";
arr_tree+="</script>";
arr_tree+="</DIV>";
Rs.Close();
my.CloseConn();
return arr_tree;
}
/// <summary>
/// 顯示子部門到樹形菜單中
/// </summary>
/// <param name="Parentid"></param>
/// <returns></returns>
public string GetSub(int Parentid)
{
CreateDb mydb = new CreateDb();
IDataReader Rs=null;
DBManager my = mydb.Createdb();
my.OpenConn();
string strSQL="select * from H_bm where parentid="+Parentid+" order by id asc";
Rs=my.ExecuteCreateReader(my.ExeCommand(strSQL));
string arr_tree=string.Empty;
while(Rs.Read()==true)
{
arr_tree+="a.add("+Rs["id"]+","+Rs["Parentid"]+",\""+Rs["bmnr"].ToString()+"\",\"sys_zzjg.aspx?id="+Rs["id"]+"&NodeName="+Rs["bmnr"]+"\",\"parnent\");";
arr_tree+=GetSub(Convert.ToInt32(Rs["id"].ToString()));
}
Rs.Close();
my.CloseConn();
return arr_tree;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -