com_systemrolemap.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.IO;
using System.Data.SqlClient;
using System.Xml;

namespace ERPWebService.BdStudio
{
	/// <summary>
	/// COM_SystemRolemap 的摘要说明。
	/// </summary>
	public class COM_SystemRolemap : System.Web.Services.WebService
	{
		protected sysbase.COM_BASE COM_BASE = new sysbase.COM_BASE();
		protected sysbase.COMSoft COMSoft = new sysbase.COMSoft();
		protected SqlConnection SqlConn;

		public COM_SystemRolemap()
		{
			//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 string HelloWorld()
//		{
//			return "Hello World";
//		}

		[WebMethod]
		public DataSet DsMainListForAll(string[] str_FieldValue)
		{
			string[] str_FieldName = {"m_name","m_url","p_num"};
			string[] str_FieldType = {"string","string","string"};
			string str_SearchType = "like";
			DataSet ds = new DataSet();
			string str_Sql = string.Format("select * from system_module ");
			string strWhere = this.COM_BASE.CreateSql(str_FieldValue,str_FieldName,str_SearchType,str_FieldType);
			if (strWhere.Trim() != string.Empty && strWhere != null )
			{
				str_Sql = string.Format(" {0} where {1} ",str_Sql,strWhere);
			}
			else if (strWhere.Trim() == string.Empty)
			{
				str_Sql = string.Format(" {0} ",str_Sql);
			}
			
			ds = this.COM_BASE.CreateDataSetFromSql(str_Sql);			
			return ds;
		}

		[WebMethod]
		public DataSet DsMainFieldListForAll(string ItemId)
		{
			DataSet ds = new DataSet();
			string strSql = string.Format(" select * from system_module where m_up = {0}",ItemId);
			ds = this.COM_BASE.CreateDataSetFromSql(strSql);
			return ds;
		}

		[WebMethod]
		public DataSet DsRoleList(string RoleType)
		{
			DataSet ds = new DataSet();
			string strSql = string.Format(" select role_num,role_name from system_role where role_type = '{0}'",RoleType);
			ds = this.COM_BASE.CreateDataSetFromSql(strSql);
			return ds;
		}

		[WebMethod]
		public DataSet DsEnableRoleList(string m_num)
		{
			DataSet ds = new DataSet();
			DataSet dsData = new DataSet();
			string strSql = string.Format(" select enable_role from system_module where m_num = {0}",m_num);
            ds = this.COM_BASE.CreateDataSetFromSql(strSql);
			if (ds.Tables[0].Rows.Count>0)
			{
				string str_enable_role = ds.Tables[0].Rows[0]["enable_role"].ToString();
				if (str_enable_role.Trim() != string.Empty)
				{
					string[] str_role_num = str_enable_role.Split(new char[]{','});
					string sqlWhere = string.Empty;
					if (str_role_num.Length >0)
					{
						for(int i=0;i<str_role_num.Length;i++)
						{
							sqlWhere = string.Format(" role_num = {0} or {1}",str_role_num[i],sqlWhere);
						}
					}
					sqlWhere = sqlWhere.Remove(sqlWhere.Length-3,3);
					strSql = string.Format(" select * from system_role {0} ",sqlWhere);
					dsData = this.COM_BASE.CreateDataSetFromSql(strSql);					
				}
			}
			
			return dsData;
		}

		[WebMethod]
		public void UpdateRole(string m_num,string str_rolen_num,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 = "system_module";
			string s_pk = "m_num";			

			DataTable dt = new DataTable();
			dt.Columns.Add(new DataColumn("m_num",typeof(int)));
			dt.Columns.Add(new DataColumn("enable_role",typeof(string)));
			DataRow dr = dt.NewRow();
			dr["m_num"] = int.Parse(m_num);
			dr["enable_role"] = str_rolen_num;
			dt.Rows.Add(dr);

			string str_t_num = string.Empty;
			int nErr;
			try
			{
				str_t_num = dt.Rows[0]["m_num"].ToString();
				//dt.Columns.Remove(s_pk);
				nErr = this.COM_BASE.UpdateTableBase(ref mySqlCommand,ref SqlConn,ref myTrans,str_TableName,dt,ref SqlString,ref s_pk);
				
			}
			catch (Exception e)
			{
				nErr = 1;
			}			
			if (nErr == 1)
			{
				sReturn = "修改失败";
			}
			else 
			{
				sReturn = "修改成功";				
			}
			if(nErr != 1)
			{
				myTrans.Commit();
				this.SqlConn.Close();
			}
		}
	}
}