config.cs

勇敢者论坛全部源代码。 支持SQL2000/Access数据库

		/// <param name="Frame">单击树节点时连接的目标框架</param>
		/// <param name="Url">单击时连接网页名</param>
		/// <param name="TreeView1">TreeView控件id值</param>
		public void  BindTreeView1(string f_key,string f_parentkey,string location,string f_text,string str_Sql,string Frame,string Url,Label lbl_Curnodeid,TreeView TreeView1)
		{
			GetTable(str_Sql); // 获得树的内存表
			TreeView1.Nodes.Clear(); // 清空树
			TreeNode rootnode=new TreeNode();
			rootnode.Text=dt.Rows[0][f_text].ToString(); // 给节点绑定显示值
			rootnode.NodeData=dt.Rows[0][f_key].ToString(); // 给节点绑定key值
			lbl_Curnodeid.Text=dt.Rows[0][f_key].ToString(); //　保存选中key值
			rootnode.Expanded=true; //　默认根结点为展开
			rootnode.Target = Frame;
			rootnode.NavigateUrl = Url+"?"+location+"=" + dt.Rows[0][location].ToString();
			TreeView1.Nodes.Add(rootnode);
			string parentid=dt.Rows[0][f_parentkey].ToString()+dt.Rows[0][f_key].ToString()+"_"; //　他子节点的parentid字段值
			CreateNode1(f_key,f_parentkey,location,f_text,Frame,Url,parentid,rootnode);//　加入所有根结点以下的结点　												
		}
		/// <summary>
		/// 重载2：绑定树控件并显示——>节点有连接,连接传递一个参数,传递的参数是location
		/// </summary>
		/// <param name="f_key">数据库表关键字key值名</param>
		/// <param name="f_parentkey">数据库表保存父节点id值字段名</param>
		/// <param name="f_text">节点显示文字树数据库表字段名</param>
		/// <param name="str_Sql">Select-SQL语句</param>
		/// <param name="Frame">单击树节点时连接的目标框架</param>
		/// <param name="Url">单击时连接网页名</param>
		/// <param name="TreeView1">TreeView控件id值</param>
		
		public void CreateNode1(string f_key,string f_parentkey,string location,string f_text,string Frame,string Url,string parentid,TreeNode parentnode)
		{
			DataRow [] drs = dt.Select(f_parentkey +"= '" + parentid + "'");//　选出所有子节点
			//遍历所有子节点
			foreach( DataRow r in drs )
			{
				TreeNode tempnode = new TreeNode();
				tempnode.Text = r[f_text].ToString();
				tempnode.NodeData = r[f_key].ToString();
				parentnode.Nodes.Add(tempnode);
				tempnode.Expanded=true;
				tempnode.Target = Frame;
				tempnode.NavigateUrl = Url+"?"+location+"=" + r[location].ToString();
				parentid=r[f_parentkey].ToString()+r[f_key].ToString()+"_";
				CreateNode1(f_key,f_parentkey,location,f_text,Frame,Url,parentid,tempnode);
			}
		}

		/// <summary>
		/// 增加子节点
		/// </summary>
		/// <param name="nodeid">数据库表关键字key值字段</param>
		/// <param name="parentid">数据库表保存父节点id值字段名</param>
		/// <param name="text">节点显示文字树数据库表字段名</param>
		/// <param name="tablename">数据库表名</param>
		/// <param name="lbl_Curnodeid">当前节点nodeid值</param>
		/// <param name="myText">要增加兄弟节点的文字TextBox控件Text值</param>
		/// <param name="lbl_Error">显示错误提示文字说明Label控件Text值</param>
		public void AddChildNode(string nodeid,string parentid,string location,string text,string tablename,Label lbl_Curnodeid,TextBox myText,Label lbl_Error)
		{
			if(myText.Text!="")
			{
				string str_Sql="select max("+nodeid+") from  "+tablename;
				GetRowRecord(str_Sql);
				string str_MaxId=(int.Parse(dr[0].ToString())+1).ToString();
				str_Sql="select * from "+tablename+" where "+nodeid+"="+lbl_Curnodeid.Text;
				GetRowRecord(str_Sql);
				string str_=dr[parentid]+lbl_Curnodeid.Text+"_";
				string str_Location=str_+str_MaxId+"_";
				string str_Sql1="INSERT INTO "+tablename+"("+nodeid+","+parentid+","+location+","+text+") VALUES ("+str_MaxId+",'"+str_+"','"+str_Location+"','"+myText.Text.Replace(" ","")+"')";
				ExeSql(str_Sql1);
			}
			else
			{
				JsIsNull("请填写节点内容",lbl_Error);
			}
		}
		/// <summary>
		/// 增加兄弟节点
		/// </summary>
		/// <param name="nodeid">数据库表关键字key值字段</param>
		/// <param name="parentid">数据库表保存父节点id值字段名</param>
		/// <param name="text">节点显示文字树数据库表字段名</param>
		/// <param name="tablename">数据库表名</param>
		/// <param name="lbl_Curnodeid">当前节点nodeid值</param>
		/// <param name="myText">要增加兄弟节点的文字TextBox控件Text值</param>
		/// <param name="lbl_Error">显示错误提示文字说明Label控件Text值</param>
		public void AddBrotherNode(string nodeid,string parentid,string location,string text,string tablename,Label lbl_Curnodeid,TextBox myText,Label lbl_Error)
		{
			if(myText.Text!="")
			{
				string str_Sql="select max("+nodeid+") from  "+tablename;
				GetRowRecord(str_Sql);
				string str_MaxId=(int.Parse(dr[0].ToString())+1).ToString();
				str_Sql="select * from "+tablename+" where nodeid="+lbl_Curnodeid.Text;
				GetRowRecord(str_Sql);
				string str_=dr[parentid].ToString();
				string str_Location=str_+str_MaxId+"_";
				str_Sql="INSERT INTO "+tablename+"("+nodeid+","+parentid+","+location+","+text+") VALUES ("+str_MaxId+",'"+str_+"','"+str_Location+"','"+myText.Text.Replace(" ","")+"')";
				ExeSql(str_Sql);
			}
			else
			{
				JsIsNull("请填写节点内容",lbl_Error);
			}
		}

		/// <summary>
		/// 增加子节点
		/// </summary>
		/// <param name="nodeid">数据库表关键字key值字段</param>
		/// <param name="parentid">数据库表保存父节点id值字段名</param>
		/// <param name="text">节点显示文字树数据库表字段名</param>
		/// <param name="tablename">数据库表名</param>
		/// <param name="lbl_Curnodeid">当前节点nodeid值</param>
		/// <param name="myText">要增加兄弟节点的文字TextBox控件Text值</param>
		/// <param name="lbl_Error">显示错误提示文字说明Label控件Text值</param>
		public void AddChildNode(string nodeid,string order_id,string parentid,string location,string text,string tablename,Label lbl_Curnodeid,TextBox myText,Label lbl_Error)
		{
			if(myText.Text!="")
			{
				string str_Sql="select max("+nodeid+") from  "+tablename;
				GetRowRecord(str_Sql);
				string str_MaxId=(int.Parse(dr[0].ToString())+1).ToString();
				str_Sql="select * from "+tablename+" where "+nodeid+"="+lbl_Curnodeid.Text;
				GetRowRecord(str_Sql);
				string str_=dr[parentid]+lbl_Curnodeid.Text+"_";
				string str_Location=str_+str_MaxId+"_";
				string str_Sql1="INSERT INTO "+tablename+"("+nodeid+","+order_id+","+parentid+","+location+","+text+") VALUES ("+str_MaxId+","+str_MaxId+",'"+str_+"','"+str_Location+"','"+myText.Text.Replace(" ","")+"')";
				ExeSql(str_Sql1);
			}
			else
			{
				JsIsNull("请填写节点内容",lbl_Error);
			}
		}
		/// <summary>
		/// 增加兄弟节点
		/// </summary>
		/// <param name="nodeid">数据库表关键字key值字段</param>
		/// <param name="parentid">数据库表保存父节点id值字段名</param>
		/// <param name="text">节点显示文字树数据库表字段名</param>
		/// <param name="tablename">数据库表名</param>
		/// <param name="lbl_Curnodeid">当前节点nodeid值</param>
		/// <param name="myText">要增加兄弟节点的文字TextBox控件Text值</param>
		/// <param name="lbl_Error">显示错误提示文字说明Label控件Text值</param>
		public void AddBrotherNode(string nodeid,string order_id,string parentid,string location,string text,string tablename,Label lbl_Curnodeid,TextBox myText,Label lbl_Error)
		{
			if(myText.Text!="")
			{
				string str_Sql="select max("+nodeid+") from  "+tablename;
				GetRowRecord(str_Sql);
				string str_MaxId=(int.Parse(dr[0].ToString())+1).ToString();
				str_Sql="select * from "+tablename+" where nodeid="+lbl_Curnodeid.Text;
				GetRowRecord(str_Sql);
				string str_=dr[parentid].ToString();
				string str_Location=str_+str_MaxId+"_";
				str_Sql="INSERT INTO "+tablename+"("+nodeid+","+order_id+","+parentid+","+location+","+text+") VALUES ("+str_MaxId+","+str_MaxId+",'"+str_+"','"+str_Location+"','"+myText.Text.Replace(" ","")+"')";
				ExeSql(str_Sql);
			}
			else
			{
				JsIsNull("请填写节点内容",lbl_Error);
			}
		}
		/// <summary>
		/// 删除树节点
		/// </summary>
		/// <param name="nodeid">数据库表关键字key值字段</param>
		/// <param name="parentid">数据库表保存父节点id值字段名</param>
		/// <param name="tablename">数据库表名</param>
		/// <param name="lbl_Curnodeid">当前节点nodeid值</param>
		public void DelTreeViewNode(string nodeid,string parentid,string tablename,Label lbl_Curnodeid)
		{
			string str_Sql="delete from "+tablename+" where "+nodeid+"="+lbl_Curnodeid.Text+" or "+parentid +" like '%"+lbl_Curnodeid.Text+"%'";
			ExeSql(str_Sql);
		}



		// 4——————————————————上传文件函数—————————————————————

		/// <summary>
		/// 普通文件上传,限制：文件大小不能超过2M
		/// </summary>
		/// <param name="path">上传文件路径,相对路径,比如:downloads/wufeng/</param>
		/// <param name="fl_Name">选择上传文件HtmlInputFile控件id号</param>
		/// <param name="lbl_Error">上传提示错误Label控件id号</param>
		/// <returns>返回文件名</returns>
		public string UpFile(string path,HtmlInputFile fl_Name,Label lbl_Error)
		{
			if(fl_Name.PostedFile.contentLength>2000000)
			{
				lbl_Error.Text="<script language=\"javascript\">alert(\"文件大小限定在2MB以内\");</"+"script>"; 
				throw(new Exception());
			}
			if(File.Exists(Server.MapPath(path+Path.GetFileName(fl_Name.PostedFile.FileName))))
			{
				lbl_Error.Text="<script language=\"javascript\">alert(\"该文件已经存在,请改名再上传\");</"+"script>"; 
				throw(new Exception());
			}
			string strFullPath=Server.MapPath(path+Path.GetFileName(fl_Name.PostedFile.FileName));
			fl_Name.PostedFile.SaveAs(strFullPath);
			return Path.GetFileName(fl_Name.PostedFile.FileName);
		}
		/// <summary>
		/// 把上传文件名变换为16位随机数上传,限制：文件大小不能超过2M
		/// </summary>
		/// <param name="path">上传文件路径,相对路径,比如:downloads/wufeng/</param>
		/// <param name="fl_Name">选择上传文件HtmlInputFile控件id号</param>
		/// <param name="lbl_Error">上传提示错误Label控件id号</param>
		/// <returns>返回文件名</returns>
		public string UpFileRandom(string path,HtmlInputFile fl_Name,Label lbl_Error)
		{
			if(fl_Name.PostedFile.contentLength>2000000)
			{
				lbl_Error.Text="<script language=\"javascript\">alert(\"文件大小限定在2MB以内\");</"+"script>"; 
				throw(new Exception());
			}
			string strPath=Server.MapPath(path);
			filename=GetdataRandom();
			filename=filename+"."+GetLastStr(fl_Name.PostedFile.FileName,".");
			string strFullPath=strPath+filename;
			if(File.Exists(strFullPath))
			{
				lbl_Error.Text="<script language=\"javascript\">alert(\"该文件已经存在,请改名再上传\");</"+"script>"; 
				throw(new Exception());
			}
			fl_Name.PostedFile.SaveAs(strFullPath);
			return filename;
		}
		/// <summary>
		/// 限制文件大小上传,限制：文件大小不能超过filesize值,文件不能重名
		/// </summary>
		/// <param name="filesize">上传文件大小,于kb计算,比如2000,就是2MB</param>
		/// <param name="path">上传文件路径,相对路径,比如:downloads/wufeng/</param>
		/// <param name="fl_Name">选择上传文件HtmlInputFile控件id号</param>
		/// <param name="lbl_Error">上传提示错误Label控件id号</param>
		/// <returns>返回文件名</returns>
		public string UpFileSize(int filesize,string path,HtmlInputFile fl_Name,Label lbl_Error)
		{
			if(fl_Name.PostedFile.contentLength>filesize)
			{
				lbl_Error.Text="<script language=\"javascript\">alert(\"文件大小限定在"+filesize.ToString()+"MB以内\");</"+"script>"; 
				throw(new Exception());
			}
			if(File.Exists(Server.MapPath(path+Path.GetFileName(fl_Name.PostedFile.FileName))))
			{
				lbl_Error.Text="<script language=\"javascript\">alert(\"该文件已经存在,请改名再上传\");</"+"script>"; 
				throw(new Exception());
			}
			string strFullPath=Server.MapPath(path+Path.GetFileName(fl_Name.PostedFile.FileName));
			fl_Name.PostedFile.SaveAs(strFullPath);
			return Path.GetFileName(fl_Name.PostedFile.FileName);
		}
		/// <summary>
		/// 限制文件大小,把上传文件名变换为16位随机数上传,限制：文件大小不能超过filesize值,文件不能重名
		/// </summary>
		/// <param name="filesize">上传文件大小,于kb计算,比如2000,就是2MB</param>
		/// <param name="path">上传文件路径,相对路径,比如:downloads/wufeng/</param>
		/// <param name="fl_Name">选择上传文件HtmlInputFile控件id号</param>
		/// <param name="lbl_Error">上传提示错误Label控件id号</param>
		/// <returns>返回文件名</returns>
		public string UpFileRandomSize(int filesize,string path,HtmlInputFile fl_Name,Label lbl_Error)
		{
			if(fl_Name.PostedFile.contentLength>filesize)
			{
				lbl_Error.Text="<script language=\"javascript\">alert(\"文件大小限定在"+filesize.ToString()+"MB以内\");</"+"script>"; 
				throw(new Exception());
			}
			string strPath=Server.MapPath(path);
			filename=GetdataRandom();
			filename=filename+"."+GetLastStr(fl_Name.PostedFile.FileName,".");
			string strFullPath=strPath+filename;
			if(File.Exists(strFullPath))
			{
				lbl_Error.Text="<script language=\"javascript\">alert(\"该文件已经存在,请改名再上传\");</"+"script>"; 
				throw(new Exception());
			}
			fl_Name.PostedFile.SaveAs(strFullPath);
			return filename;
		}
		/// <summary>
		/// 限制文件类型,限制：文件大小不能超过2MB,文件类型,文件不能重名上传文件
		/// </summary>
		/// <param name="filetype">限制文件类型，比如："rar,zip"</param>
		/// <param name="path">上传文件路径,相对路径,比如:downloads/wufeng/</param>
		/// <param name="fl_Name">选择上传文件HtmlInputFile控件id号</param>
		/// <param name="lbl_Error">上传提示错误Label控件id号</param>
		/// <returns>返回文件名</returns>
		public string UpFileType(string filetype,string path,HtmlInputFile fl_Name,Label lbl_Error)
		{
			if(GetStrCount(filetype,GetLastStr(fl_Name.PostedFile.FileName,".").ToLower())==0)
			{
				lbl_Error.Text="<script language=\"javascript\">alert(\"请上传"+filetype+"文件格式文件\");</"+"script>"; 
				throw(new Exception());
			}
			if(fl_Name.PostedFile.contentLength>2000000)
			{
				lbl_Error.Text="<script language=\"javascript\">alert(\"文件大小限定在2MB以内\");</"+"script>"; 
				throw(new Exception());
			}
			if(File.Exists(Server.MapPath(path+Path.GetFileName(fl_Name.PostedFile.FileName))))
			{
				lbl_Error.Text="<script language=\"javascript\">alert(\"该文件已经存在,请改名再上传\");</"+"script>"; 
				throw(new Exception());
			}