cominterface.asmx.cs

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

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

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

		public COMInterface()
		{
			//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 DataSet DsInterfaceTitle(string m_num,string FaceName)
		{
			DataSet ds=this.COM_BASE.CreateDataSetFromSql("select * from system_userdd where m_num="+m_num+" and t_up='"+FaceName+"' order by t_order");
			return ds;
		}

		[WebMethod]
		public DataSet DsInterfaceData(string m_num,string FaceName)
		{
			DataSet ds;
			//his.COM_BASE.CreateDataSetFromSql("select * from system_userdd where m_num="+m_num+" and t_up='"+FaceName+"' order by t_order");
			string sSqlString=this.CreateSqlFromInterface(m_num,FaceName);
			ds=this.COM_BASE.CreateDataSetFromSql(sSqlString);
			return ds;
		}

		[WebMethod]
		public string CreateSqlFromInterface(string m_num,string FaceName)
		{
			string strSql = "select * from system_userdd where m_num="+m_num+" and t_up='"+FaceName+"' order by t_order";
			DataSet ds=this.COM_BASE.CreateDataSetFromSql(strSql);
			string sTableName="";
			string sFieldName="";
			string sSqlString="";
			foreach(DataRow row in ds.Tables[0].Rows)
			{
				sTableName=row["t_tablename"].ToString();
				COMFunction.StringAdd(ref sFieldName,"",row["t_name"].ToString(),",");
				if(row["table_source"].ToString()!=null&&row["table_source"].ToString()!="")
				{
					sFieldName+="=(select "+row["table_fieldout"].ToString()+" from "+row["table_source"].ToString()+" where "+row["table_fieldin"].ToString()+"="+row["t_name"].ToString()+")";
				}
			}
			sSqlString="select "+sFieldName+" from "+sTableName;
			return sSqlString;
		}



		[WebMethod]
		public DataSet CreateDataSetFromSql(string SqlString)
		{
			DataSet ds=this.COM_BASE.CreateDataSetFromSql(SqlString);
			return ds;
		}

	}
}