workservice.asmx.cs

ASP.NET的一些开发实例,有论坛管理系统等

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

namespace WorkGroupService.task
{
	public class work
	{
		private string taskNo;
		private string taskExecutor;
		private string econtent;
		private DateTime eDate;
		private string pScan;
		private string taskPromulgator;
		private string pcontent;
		private DateTime pDate;
		private string eScan;

		public work()
		{
			this.taskNo=string.Empty;
			this.taskExecutor=string.Empty;
			this.econtent=string.Empty;
			this.eDate=DateTime.Parse("1900-1-1");
			//this.eDate=Convert.ToDateTime(System.DBNull.Value);
			this.pScan="x";
			this.taskPromulgator=string.Empty;
			this.pcontent=string.Empty;
			this.pDate=DateTime.Parse("1900-1-1");
			//this.pDate=Convert.ToDateTime(System.DBNull.Value);
			this.eScan="x";
		}

		public string tNO
		{
			get
			{
				return this.taskNo;
			}
			set
			{
				this.taskNo=value;
			}
		}

		public string tExecutor
		{
			get
			{
				return this.taskExecutor;
			}
			set
			{
				this.taskExecutor=value;
			}
		}

		public string exContent
		{
			get
			{
				return this.econtent;
			}
			set
			{
				this.econtent=value;
			}
		}

		public DateTime exDate
		{
			get
			{
				return this.eDate;
			}
			set
			{
				this.eDate=value;
			}
		}

		public string prScan
		{
			get
			{
				return this.pScan;
			}
			set
			{
				this.pScan=value;
			}
		}

		public string tPromulgator
		{
			get
			{
				return this.taskPromulgator;
			}
			set
			{
				this.taskPromulgator=value;
			}
		}

		public string prContent
		{
			get
			{
				return this.pcontent;
			}
			set
			{
				this.pcontent=value;
			}
		}

		public DateTime prDate
		{
			get
			{
				return this.pDate;
			}
			set
			{
				this.pDate=value;
			}
		}

		public string exScan
		{
			get
			{
				return this.eScan;
			}
			set
			{
				this.eScan=value;
			}
		}

	}


		
	/// <summary>
	/// WorkService 的摘要说明。
	/// </summary>
	public class WorkService : System.Web.Services.WebService
	{
		public WorkService()
		{
			//CODEGEN：该调用是 ASP.NET Web 服务设计器所必需的
			InitializeComponent();
		}

		private System.Data.OleDb.OleDbConnection oleDbConnection1;
		private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
		private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
		private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
		private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
		private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
		private WorkGroupService.task.DataSet2 dataSet21;
		private WorkGroupService.BaseService bs=new WorkGroupService.BaseService();

		#region Component Designer generated code
		
		//Web 服务设计器所必需的
		private IContainer components = null;
				
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
			this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
			this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
			this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
			this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
			this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
			this.dataSet21 = new WorkGroupService.task.DataSet2();
			((System.ComponentModel.ISupportInitialize)(this.dataSet21)).BeginInit();
			// 
			// oleDbConnection1
			// 
			this.oleDbConnection1.ConnectionString = "Provider=MSDAORA.1;Password=acarsgroup;User ID=acarsgroup;Data Source=NOCDB";
			// 
			// oleDbDataAdapter1
			// 
			this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
			this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
			this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
			this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																										new System.Data.Common.DataTableMapping("Table", "工作记录表", new System.Data.Common.DataColumnMapping[] {
																																																				 new System.Data.Common.DataColumnMapping("任务编号", "任务编号"),
																																																				 new System.Data.Common.DataColumnMapping("执行人", "执行人"),
																																																				 new System.Data.Common.DataColumnMapping("任务内容", "任务内容"),
																																																				 new System.Data.Common.DataColumnMapping("填写时间", "填写时间"),
																																																				 new System.Data.Common.DataColumnMapping("发布人", "发布人"),
																																																				 new System.Data.Common.DataColumnMapping("发布人是否浏览", "发布人是否浏览"),
																																																				 new System.Data.Common.DataColumnMapping("发布人填写时间", "发布人填写时间"),
																																																				 new System.Data.Common.DataColumnMapping("发布人填写内容", "发布人填写内容"),
																																																				 new System.Data.Common.DataColumnMapping("执行人是否浏览", "执行人是否浏览")})});
			this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
			// 
			// oleDbSelectCommand1
			// 
			this.oleDbSelectCommand1.CommandText = "SELECT 任务编号, 执行人, 任务内容, 填写时间, 发布人, 发布人是否浏览, 发布人填写时间, 发布人填写内容, 执行人是否浏览 FROM 工作记录表";
			this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
			//