com_forumstat.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;
using System.Data.SqlClient;

namespace WhiteForumServer.forum
{
	/// <summary>
	/// COM_ForumStat 的摘要说明。
	/// </summary>
	public class COM_ForumStat : 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.COMInterface COMInterface=new WhiteForumServer.BdStudioSoft.COMInterface();
		protected WhiteForumServer.BdStudioSoft.Gfunction Gfunction = new WhiteForumServer.BdStudioSoft.Gfunction();
		protected SqlConnection SqlConn;

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

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

		/// <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 void InsertData(string accname,string InsertType,ref string sReturn)
		{
			SqlCommand mySqlCommand = new SqlCommand();
			SqlTransaction myTrans;
			string SqlString = string.Empty;

			this.SqlConn.Open();//启动连接
			myTrans = this.SqlConn.BeginTransaction();//建立事务
			mySqlCommand.Connection = this.SqlConn;//建立sql命令连接
			mySqlCommand.Transaction = myTrans;//绑定事务

			string str_TableName = "forum_stat";
			string str_s_num = string.Empty;
			DataTable dt = new DataTable();
			dt.Columns.Add(new DataColumn("acc_name",typeof(string)));
			dt.Columns.Add(new DataColumn("login_datetime",typeof(string)));
			DataRow dr = dt.NewRow();
			dr["acc_name"] = accname;
			dr["login_datetime"] = this.Gfunction.DataTimeValue(0,2);
			dt.Rows.Add(dr);

			int nErr;
			try
			{
				nErr= this.COM_BASE.InsertTableBase(ref mySqlCommand,ref SqlConn,ref myTrans,str_TableName,dt,ref SqlString);
			}
			catch (Exception e)
			{
				nErr = 1;
			}		
			if (nErr == 1)
			{
				sReturn =  "增加失败";
			}
			else 
			{
				myTrans.Commit();
				this.SqlConn.Close();
				switch (InsertType)
				{
					case "0":
						sReturn = "增加成功";
						break;
					case "1":
						string strSql = string.Format("select s_num from forum_stat ");
						str_s_num = this.COM_BASE.GetID(strSql);
						sReturn = str_s_num;
						break;
				}
			}
		}

		[WebMethod]
		public DataSet DsStat(string[] strSearch)
		{
			DataSet ds = new DataSet();
			string sqlwhere = string.Empty;
			for(int i=0;i<strSearch.Length;i++)
			{
				switch(i)
				{
					case 0:
						if(strSearch[i].Trim() != string.Empty)
						{
							sqlwhere = string.Format("whiteforum.forum_stat.login_datetime >= '{0}'",strSearch[i]);
						}
						break;
					case 1:
						if(strSearch[i].Trim() != string.Empty)
						{
							if(sqlwhere.Trim() != string.Empty)
							{
								sqlwhere = string.Format("{0} and whiteforum.forum_stat.login_datetime <= '{1}'",sqlwhere,strSearch[i]);
							}
							else
							{
								sqlwhere = string.Format("whiteforum.forum_stat.login_datetime <= '{0}'",strSearch[i]);
							}							
						}
						break;
					case 2:
						if(strSearch[i].Trim() != string.Empty)
						{
							//string accname = strSearch[i].Trim().Replace("[","'");
							//accname = accname.Replace("]","'");
							if(sqlwhere.Trim() != string.Empty)
							{
								//sqlwhere = string.Format("{0} and whiteforum.system_account.acc_name in ({1})",sqlwhere,accname);
								sqlwhere = string.Format("{0} and whiteforum.system_account.acc_name like '%{1}%'",sqlwhere,strSearch[i].Trim());
							}
							else
							{
								//sqlwhere = string.Format("whiteforum.system_account.acc_name in ({0})",accname);
								sqlwhere = string.Format("whiteforum.system_account.acc_name like '%{0}%'",strSearch[i].Trim());
							}							
						}
						break;
					case 3:
						if(strSearch[i].Trim() != string.Empty)
						{
							//string accemp = strSearch[i].Trim().Replace("[","'");
							//accemp = accemp.Replace("]","'");
							if(sqlwhere.Trim() != string.Empty)
							{
								//sqlwhere = string.Format("{0} whiteforum.system_account.and acc_emp in ({1})",sqlwhere,accemp);
								sqlwhere = string.Format("{0} whiteforum.system_account.and acc_emp like '%{1}%'",sqlwhere,strSearch[i].Trim());
							}
							else
							{
								//sqlwhere = string.Format("whiteforum.system_account.acc_emp in ({0})",accemp);
								sqlwhere = string.Format("whiteforum.system_account.acc_emp like '%{0}%'",strSearch[i].Trim());
							}							
						}
						break;
				}
			}
			if(sqlwhere.Trim() != string.Empty)
			{
				sqlwhere = string.Format("SELECT whiteforum.system_account.acc_emp, whiteforum.system_account.acc_name,ISNULL(SUM(whiteforum.forum_stat.[count]), 0) AS view_count,ISNULL(whiteforum.system_account.t_topic_count, 0) AS t_topic_count,ISNULL(whiteforum.system_account.t_reply_count, 0) AS t_reply_count FROM whiteforum.forum_stat RIGHT OUTER JOIN whiteforum.system_account ON whiteforum.forum_stat.acc_name = whiteforum.system_account.acc_name WHERE ({0}) GROUP BY whiteforum.system_account.acc_emp,whiteforum.system_account.t_topic_count, whiteforum.system_account.t_reply_count,whiteforum.system_account.acc_name ",sqlwhere);
				ds=this.COM_BASE.CreateDataSetFromSql(sqlwhere);
			}
			else
			{
				sqlwhere = string.Format("SELECT whiteforum.system_account.acc_emp, whiteforum.system_account.acc_name,ISNULL(SUM(whiteforum.forum_stat.[count]), 0) AS view_count,ISNULL(whiteforum.system_account.t_topic_count, 0) AS t_topic_count,ISNULL(whiteforum.system_account.t_reply_count, 0) AS t_reply_count FROM whiteforum.forum_stat RIGHT OUTER JOIN whiteforum.system_account ON whiteforum.forum_stat.acc_name = whiteforum.system_account.acc_name GROUP BY whiteforum.system_account.acc_emp,whiteforum.system_account.t_topic_count, whiteforum.system_account.t_reply_count,whiteforum.system_account.acc_name");
				ds=this.COM_BASE.CreateDataSetFromSql(sqlwhere);
			}
			return ds;
		}
	}
}