common.cs

报刊广告管理系统。CSharp编写

using System;

namespace WWAM.DBA
{
	public class Common
	{
		public static SqlConn GetDB()
		{
			string srv = XMLConfig.GetNodeValue("DBServer");
			string db = XMLConfig.GetNodeValue("DBDatabase");
			string user = XMLConfig.GetNodeValue("DBUser");
			string pass = XMLConfig.GetNodeValue("DBPassword");
			return new SqlConn(srv,db,user,pass);
		}

		public static int DBAccess(int loginid, SqlConn db)
		{
			return db.RunSPGetInt("lUserAccess",new SqlPara(loginid),0);
		}

		public static int DBLogin(string userCode, string userPass, string ipAddress, SqlConn db)
		{
			string[] names = new string[]{"UserCode","UserPass","IPAddress"};
			object[] values = new object[]{userCode,userPass,ipAddress};
			return db.RunSPGetInt("lUserLogin",new SqlPara(names,values),0);
		}

		public static int DBLogout(int loginid, SqlConn db)
		{
			return logout(loginid , "正常退出", db);
		}

		private static int logout(int loginid, string describe ,SqlConn db)
		{
			string[] names = new string[]{"Loginid","Describe"};
			object[] values = new object[]{loginid,describe};
			return db.RunSPGetInt("lUserLogout",new SqlPara(names,values),0);
		}

		public static int DBReLogin(int loginid, string userCode, string userPass, string ipAddress, SqlConn db)
		{
			int rv = DBLogin(userCode,userPass,ipAddress,db);
			if(rv > 0)
			{
				logout(loginid ,"更换为"+userCode, db);
			}
			return rv;
		}
	}
}