com_dropds.asmx.cs

来自「ASP.NET的一些开发实例,有论坛管理系统等」· CS 代码 · 共 458 行

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;

namespace ERPWebService.BdStudioSoft
{
	/// <summary>
	/// COM_DropDs 的摘要说明。
	/// </summary>
	public class COM_DropDs : System.Web.Services.WebService
	{
		protected sysbase.COM_BASE COM_BASE = new sysbase.COM_BASE();	
		private WhiteForumServer.BdStudioSoft.Gfunction COMFunction=new WhiteForumServer.BdStudioSoft.Gfunction();

		public COM_DropDs()
		{
			//CODEGEN：该调用是 ASP.NET Web 服务设计器所必需的
			InitializeComponent();
		}

		#region Component Designer generated code
		
		//Web 服务设计器所必需的
		private IContainer components = null;
				
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if(disposing && components != null)
			{
				components.Dispose();
			}
			base.Dispose(disposing);		
		}
		
		#endregion

		// WEB 服务示例
		// HelloWorld() 示例服务返回字符串 Hello World
		// 若要生成，请取消注释下列行，然后保存并生成项目
		// 若要测试此 Web 服务，请按 F5 键

//		[WebMethod]
//		public string HelloWorld()
//		{
//			return "Hello World";
//		}

		[WebMethod]
		public DataSet DsClient(string WhereString,string AllString)
		{
			DataSet ds = new DataSet();
			string strSql =string.Empty;
			if (WhereString != null )
			{
				if (WhereString.Trim() == string.Empty)
				{
					strSql = string.Format(" select c_num,c_name from system_client ");
				}
				else
				{
					strSql = string.Format(" select c_num,c_name from system_client where {0} ",WhereString);
				}				
				try
				{
					ds = this.COM_BASE.CreateDataSetFromSql(strSql);
				}
				catch
				{}                
			}
			if (AllString == "所有客户")
			{
				DataRow dr = ds.Tables[0].NewRow();
				dr["c_num"] = " ";
				dr["c_name"] = "所有客户";
				ds.Tables[0].Rows.InsertAt(dr,0);
			}
			return ds;
		}

		[WebMethod]
		public DataSet DsModule(string WhereString,string AllString)
		{
			DataSet ds = new DataSet();
			string strSql =string.Empty;
			if (WhereString != null )
			{
				if (WhereString.Trim() == string.Empty)
				{
					strSql = string.Format(" select m_num,m_name from system_module ");
				}
				else
				{
					strSql = string.Format(" select m_num,m_name from system_module where {0} ",WhereString);
				}				
				try
				{
					ds = this.COM_BASE.CreateDataSetFromSql(strSql);
				}
				catch
				{}                
			}
			if (AllString == "所有模板")
			{
				DataRow dr = ds.Tables[0].NewRow();
				dr["m_num"] = 0;
				dr["m_name"] = "所有模板";
				ds.Tables[0].Rows.InsertAt(dr,0);
			}
			return ds;
		}



		[WebMethod]
		public DataSet DsProject(string WhereString,string AllString)
		{
			DataSet ds = new DataSet();
			string strSql = string.Empty;
			if (WhereString != null )
			{
				if (WhereString.Trim() == string.Empty)
				{
					strSql = string.Format(" select p_num,p_name from system_project where is_lock <>  '1' and is_close <>  '1' ");
				}
				else
				{
					 strSql = string.Format(" select p_num,p_name from system_project where is_lock <>  '1' and is_close <>  '1' and {0}",WhereString);
				}				
				try
				{
					ds = this.COM_BASE.CreateDataSetFromSql(strSql);
				}
				catch
				{}                
			}
			if (AllString == "所有项目")
			{
				DataRow dr = ds.Tables[0].NewRow();
				dr["p_num"] = " ";
				dr["p_name"] = "所有项目";
				ds.Tables[0].Rows.InsertAt(dr,0);
			}
			return ds;
		}

		[WebMethod]
		public DataSet DsInformation(string ItemNum)
		{
			DataSet ds = new DataSet();
			string strSql = string.Format(" select i_title,i_value from system_information where isnull(i_up,0) <>  0 and i_name = '{0}'",ItemNum);
			try
			{
				ds = this.COM_BASE.CreateDataSetFromSql(strSql);
			}
			catch
			{}                
			return ds;
		}

		[WebMethod]
		public DataSet DsAccount(string WhereString,string AllString)
		{
			DataSet ds = new DataSet();
			string strSql = string.Empty;
			if (WhereString != null )
			{
				if (WhereString.Trim() == string.Empty)
				{
					strSql = string.Format(" select acc_num,acc_name,acc_emp from system_account ");
				}
				else
				{
					strSql = string.Format(" select acc_num,acc_name,acc_emp from system_account where {0} ",WhereString);
				}				
				try
				{
					ds = this.COM_BASE.CreateDataSetFromSql(strSql);
				}
				catch
				{}                
			}
			if (AllString == "所有帐户")
			{
				DataRow dr = ds.Tables[0].NewRow();
				dr["acc_num"] = " ";
				dr["acc_name"] = "所有帐户";
				ds.Tables[0].Rows.InsertAt(dr,0);
			}
			return ds;
		}

		[WebMethod]
		public DataSet DsDd(string WhereString,string AllString)
		{
			DataSet ds = new DataSet();
			string strSql = string.Empty;
			if (WhereString != null )
			{
				if (WhereString.Trim() == string.Empty)
				{
					strSql = string.Format(" select t_num,t_name,t_title from system_dd ");
				}
				else
				{
					strSql = string.Format(" select t_num,t_name,t_title from system_dd where {0} ",WhereString);
				}				
				try
				{
					ds = this.COM_BASE.CreateDataSetFromSql(strSql);
				}
				catch
				{}                
			}
			if (AllString == "所有数据字典")
			{
				DataRow dr = ds.Tables[0].NewRow();
				dr["t_num"] = 0;
				dr["t_name"] = "所有数据字典";
				ds.Tables[0].Rows.InsertAt(dr,0);
			}
			return ds;
		}

		[WebMethod]
		public DataSet DsInfo(string WhereString,string AllString)
		{
			DataSet ds = new DataSet();
			string strSql = string.Empty;
			if (WhereString != null )
			{
				if (WhereString.Trim() == string.Empty)
				{
					strSql = string.Format(" select i_num,i_name,i_title from system_information ");
				}
				else
				{
					strSql = string.Format(" select i_num,i_name,i_title from system_information where {0} ",WhereString);
				}				
				try
				{
					ds = this.COM_BASE.CreateDataSetFromSql(strSql);
				}
				catch
				{}                
			}
			if (AllString == "所有基础信息")
			{
				DataRow dr = ds.Tables[0].NewRow();
				dr["i_num"] = 0;
				dr["i_name"] = "所有基础信息";
				ds.Tables[0].Rows.InsertAt(dr,0);
			}
			return ds;
		}

		[WebMethod]
		public DataSet DsUserdd(string WhereString,string AllString)
		{
			DataSet ds = new DataSet();
			string strSql = string.Empty;
			if (WhereString != null )
			{
				if (WhereString.Trim() == string.Empty)
				{
					strSql = string.Format(" select u_num,t_name,t_title from system_userdd ");
				}
				else
				{
					strSql = string.Format(" select u_num,t_name,t_title from system_userdd where {0} ",WhereString);
				}				
				try
				{
					ds = this.COM_BASE.CreateDataSetFromSql(strSql);
				}
				catch
				{}                
			}
			if (AllString == "所有界面")
			{
				DataRow dr = ds.Tables[0].NewRow();
				dr["u_num"] = 0;
				dr["t_name"] = "所有界面";
				ds.Tables[0].Rows.InsertAt(dr,0);
			}
			return ds;
		}

		[WebMethod]
		public DataSet DsProjectfile(string WhereString,string AllString)
		{
			DataSet ds = new DataSet();
			string strSql = string.Empty;
			if (WhereString != null )
			{
				if (WhereString.Trim() == string.Empty)
				{
					strSql = string.Format(" select f_num,f_name,f_title from system_projectfile where f_share = '1' and f_close <>  '1' ");
				}
				else
				{
					strSql = string.Format(" select f_num,f_name,f_title from system_projectfile where f_share = '1' and f_close <>  '1' and {0}",WhereString);
				}				
				try
				{
					ds = this.COM_BASE.CreateDataSetFromSql(strSql);
				}
				catch
				{}                
			}
			if (AllString == "所有项目文件")
			{
				DataRow dr = ds.Tables[0].NewRow();
				dr["f_num"] = " ";
				dr["f_name"] = "所有项目文件";
				ds.Tables[0].Rows.InsertAt(dr,0);
			}
			return ds;
		}
		/////////////////////////以下是具体项目数据集////////////////////////////////////////////////
		[WebMethod]
		public DataSet DsForumCategory(string WhereString,string AllString)
		{
			DataSet ds = new DataSet();
			string strSql = string.Empty;
			if (WhereString != null )
			{
				if (WhereString.Trim() == string.Empty)
				{
					strSql = string.Format(" select cat_id,cat_name from forum_category where cat_status = '01'");
				}
				else
				{
					strSql = string.Format(" select cat_id,cat_name from forum_category where cat_status = '01' and {0}",WhereString);
				}				
				try
				{
					ds = this.COM_BASE.CreateDataSetFromSql(strSql);
				}
				catch
				{}                
			}
			if (AllString == "所有论坛分类")
			{
				DataRow dr = ds.Tables[0].NewRow();
				dr["cat_id"] = " ";
				dr["cat_name"] = "所有论坛分类";
				ds.Tables[0].Rows.InsertAt(dr,0);
			}
			return ds;
		}

		[WebMethod]
		public DataSet DsDepartment(string WhereString,string AllString)
		{
			DataSet ds = new DataSet();
			string strSql = string.Empty;
			if (WhereString != null )
			{
				if (WhereString.Trim() == string.Empty)
				{
					strSql = string.Format(" select dep_num,dep_name from system_department ");
				}
				else
				{
					strSql = string.Format(" select dep_num,dep_name from system_department where {0}",WhereString);
				}				
				try
				{
					ds = this.COM_BASE.CreateDataSetFromSql(strSql);
				}
				catch
				{}                
			}
			if (AllString == "上级部门")
			{
				DataRow dr = ds.Tables[0].NewRow();
				dr["dep_num"] = "0";
				dr["dep_name"] = "无上级部门";
				ds.Tables[0].Rows.InsertAt(dr,0);
			}
			return ds;
		}
		
		[WebMethod]
		public DataSet DsTreeViewFromDataSet(DataSet ds,string sWhereForLevelOne,string DataTextField,string DataValueField,string sUpFieldName)
		{
			//DataSet ds,
			//DataSet ds=this.COM_BASE.CreateDataSetFromSql("select * from system_module where m_type<>'3'");
			DataTable dt=new DataTable();
			DataRow dr;
			DataColumnCollection myCols=ds.Tables[0].Columns;
			foreach(DataColumn col in  myCols)
			{
				dt.Columns.Add(new DataColumn(col.ColumnName,typeof(string)));
			}
			DataRow[] CurrentRow=ds.Tables[0].Select(sWhereForLevelOne,null,DataViewRowState.CurrentRows);
			foreach(DataRow row in CurrentRow)
			{
				dr=dt.NewRow();
				foreach(DataColumn col in  myCols)
				{
					dr[col.ColumnName]=row[col.ColumnName].ToString();
				}
				dt.Rows.Add(dr);
				CreateDataSetForTreeView(ref ds,ref dt,myCols,DataTextField,DataValueField,sUpFieldName,row[DataValueField].ToString(),0);
			}
			DataSet ds1=new DataSet();
			ds1.Tables.Add(dt);
			return ds1;
		}

		private void CreateDataSetForTreeView(ref DataSet ds,ref DataTable dt,DataColumnCollection cols,string DataTextField,string DataValueField,string sUpFieldName,string sUpFieldValue,int iLevel)
		{
			iLevel++;
			string s_where=sUpFieldName+"='"+sUpFieldValue+"'";
			DataRow dr;
			DataRow[] CurrentRow=ds.Tables[0].Select(s_where,null,DataViewRowState.CurrentRows);
			if(CurrentRow.Length>0)
			{
				foreach(DataRow row in CurrentRow)
				{
					dr=dt.NewRow();
					//					dr[DataTextField]=COMFunction.f_space(iLevel,"--")+row[DataTextField].ToString();
					//					dr[DataValueField]=row[DataValueField].ToString();
					foreach(DataColumn col in  cols)
					{
						if(col.ColumnName==DataTextField)
						{
							dr[col.ColumnName]=COMFunction.f_space(iLevel,"&nbsp;&nbsp;&nbsp;&nbsp;")+row[col.ColumnName].ToString();
						}
						else
						{
							dr[col.ColumnName]=row[col.ColumnName].ToString();
						}
					}
					dt.Rows.Add(dr);
					CreateDataSetForTreeView(ref ds,ref dt,cols,DataTextField,DataValueField,sUpFieldName,row[DataValueField].ToString(),iLevel);
				}
			}
		}
	}
}