syssupmanager.cs

自己编写的基本Orcale的通用的数据库初始化工具。

				this.ZCSJ = GlobalUtility.OracleKeyToDateTime(_reader["ZCSJ"]);
				this.ZXSJ = GlobalUtility.OracleKeyToDateTime(_reader["ZXSJ"]);
				this.DQBBH = _reader["DQBBH"].ToString();
				return true;
			}
			else
			{
				return false;
			}
		}

		protected  void InsertRecord()
		{
			if(_insertCmd == null)
			{
				string cmdStr = "insert into T_XT_XTCZZDXX(XTZDBH,CZZDLX,CZTBH,ZDMC,ZDIPDZ,ZDMACDZ,ZDJSZT,ZCSJ,ZXSJ,DQBBH) values(:XTZDBH,:CZZDLX,:CZTBH,:ZDMC,:ZDIPDZ,:ZDMACDZ,:ZDJSZT,:ZCSJ,:ZXSJ,:DQBBH)";
				_insertCmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
				_insertCmd.Parameters.Add(":XTZDBH",OracleType.Number,4);
				_insertCmd.Parameters.Add(":CZZDLX",OracleType.Number,4);
				_insertCmd.Parameters.Add(":CZTBH",OracleType.Number,4);
				_insertCmd.Parameters.Add(":ZDMC",OracleType.VarChar,20);
				_insertCmd.Parameters.Add(":ZDIPDZ",OracleType.VarChar,50);
				_insertCmd.Parameters.Add(":ZDMACDZ",OracleType.VarChar,50);
				_insertCmd.Parameters.Add(":ZDJSZT",OracleType.Number);
				_insertCmd.Parameters.Add(":ZCSJ",OracleType.DateTime);
				_insertCmd.Parameters.Add(":ZXSJ",OracleType.DateTime);
				_insertCmd.Parameters.Add(":DQBBH",OracleType.VarChar,50);
			}
			_insertCmd.Parameters[":XTZDBH"].Value = this.XTZDBH;
			_insertCmd.Parameters[":CZZDLX"].Value = this.CZZDLX;
			_insertCmd.Parameters[":CZTBH"].Value = this.CZTBH;
			_insertCmd.Parameters[":ZDMC"].Value = this.ZDMC;
			_insertCmd.Parameters[":ZDIPDZ"].Value = this.ZDIPDZ;
			_insertCmd.Parameters[":ZDMACDZ"].Value = this.ZDMACDZ;
			_insertCmd.Parameters[":ZDJSZT"].Value = this.ZDJSZT;
			_insertCmd.Parameters[":ZCSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZCSJ);
			_insertCmd.Parameters[":ZXSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZXSJ);
			_insertCmd.Parameters[":DQBBH"].Value = this.DQBBH;
			_insertCmd.Prepare();
			_insertCmd.ExecuteNonQuery();
		}

		public  void InsertRecord(OracleTransaction tran)
		{
			if(_insertCmd == null)
			{
				string cmdStr = "insert into T_XT_XTCZZDXX(XTZDBH,CZZDLX,CZTBH,ZDMC,ZDIPDZ,ZDMACDZ,ZDJSZT,ZCSJ,ZXSJ,DQBBH) values(:XTZDBH,:CZZDLX,:CZTBH,:ZDMC,:ZDIPDZ,:ZDMACDZ,:ZDJSZT,:ZCSJ,:ZXSJ,:DQBBH)";
				_insertCmd = new OracleCommand(cmdStr,DBAccess.DstConnection,tran);
				_insertCmd.Parameters.Add(":XTZDBH",OracleType.Number,4);
				_insertCmd.Parameters.Add(":CZZDLX",OracleType.Number,4);
				_insertCmd.Parameters.Add(":CZTBH",OracleType.Number,4);
				_insertCmd.Parameters.Add(":ZDMC",OracleType.VarChar,20);
				_insertCmd.Parameters.Add(":ZDIPDZ",OracleType.VarChar,50);
				_insertCmd.Parameters.Add(":ZDMACDZ",OracleType.VarChar,50);
				_insertCmd.Parameters.Add(":ZDJSZT",OracleType.Number);
				_insertCmd.Parameters.Add(":ZCSJ",OracleType.DateTime);
				_insertCmd.Parameters.Add(":ZXSJ",OracleType.DateTime);
				_insertCmd.Parameters.Add(":DQBBH",OracleType.VarChar,50);
			}
			_insertCmd.Parameters[":XTZDBH"].Value = this.XTZDBH;
			_insertCmd.Parameters[":CZZDLX"].Value = this.CZZDLX;
			_insertCmd.Parameters[":CZTBH"].Value = this.CZTBH;
			_insertCmd.Parameters[":ZDMC"].Value = this.ZDMC;
			_insertCmd.Parameters[":ZDIPDZ"].Value = this.ZDIPDZ;
			_insertCmd.Parameters[":ZDMACDZ"].Value = this.ZDMACDZ;
			_insertCmd.Parameters[":ZDJSZT"].Value = this.ZDJSZT;
			_insertCmd.Parameters[":ZCSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZCSJ);
			_insertCmd.Parameters[":ZXSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZXSJ);
			_insertCmd.Parameters[":DQBBH"].Value = this.DQBBH;
			_insertCmd.Prepare();
			_insertCmd.ExecuteNonQuery();
		}

		protected  void UpdateRecord()
		{
			if(_updateCmd == null)
			{
				string cmdStr = "update T_XT_XTCZZDXX set CZZDLX=:CZZDLX,CZTBH=:CZTBH,ZDMC=:ZDMC,ZDIPDZ=:ZDIPDZ,ZDMACDZ=:ZDMACDZ,ZDJSZT=:ZDJSZT,ZCSJ=:ZCSJ,ZXSJ=:ZXSJ,DQBBH=:DQBBH where XTZDBH=:XTZDBH";
				_updateCmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
				_updateCmd.Parameters.Add(":XTZDBH",OracleType.Number,4);
				_updateCmd.Parameters.Add(":CZZDLX",OracleType.Number,4);
				_updateCmd.Parameters.Add(":CZTBH",OracleType.Number,4);
				_updateCmd.Parameters.Add(":ZDMC",OracleType.VarChar,20);
				_updateCmd.Parameters.Add(":ZDIPDZ",OracleType.VarChar,50);
				_updateCmd.Parameters.Add(":ZDMACDZ",OracleType.VarChar,50);
				_updateCmd.Parameters.Add(":ZDJSZT",OracleType.Number);
				_updateCmd.Parameters.Add(":ZCSJ",OracleType.DateTime);
				_updateCmd.Parameters.Add(":ZXSJ",OracleType.DateTime);
				_updateCmd.Parameters.Add(":DQBBH",OracleType.VarChar,50);
			}
			_updateCmd.Parameters[":XTZDBH"].Value = this.XTZDBH;
			_updateCmd.Parameters[":CZZDLX"].Value = this.CZZDLX;
			_updateCmd.Parameters[":CZTBH"].Value = this.CZTBH;
			_updateCmd.Parameters[":ZDMC"].Value = this.ZDMC;
			_updateCmd.Parameters[":ZDIPDZ"].Value = this.ZDIPDZ;
			_updateCmd.Parameters[":ZDMACDZ"].Value = this.ZDMACDZ;
			_updateCmd.Parameters[":ZDJSZT"].Value = this.ZDJSZT;
			_updateCmd.Parameters[":ZCSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZCSJ);
			_updateCmd.Parameters[":ZXSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZXSJ);
			_updateCmd.Parameters[":DQBBH"].Value = this.DQBBH;
			_updateCmd.Prepare();
			_updateCmd.ExecuteNonQuery();
		}
	}

	/// <summary>
	/// 系统用户信息
	/// </summary>
	public class DtbT_XT_XTYHXX 
	{
		public string TableName = "";
		protected OracleCommand _deleteCmd;
		protected OracleCommand _selectCmd;
		protected OracleCommand _insertCmd;
		protected OracleCommand _updateCmd;
		protected OracleDataReader _reader;

		#region Table Members
		public int XTYHBH = -1;		// NUMBER 8 N 系统用户编号
		public int DSRBH = -1;		// NUMBER 8 当事人编号
		public string YHDLM = "";	// VARCHAR2 10 用户登陆名
		public string YHDLMM = "";	// VARCHAR2 160 用户密码
		public int CJZBH = -1;		// NUMBER 8 创建者编号
		public string YHMS = "";	// VARCHAR2 500 用户描述
		public DateTime ZCSJ = DateTime.MinValue;	// DATE 注册时间
		public DateTime ZXSJ = DateTime.MinValue;	// DATE 注销时间
		#endregion

		public DtbT_XT_XTYHXX()
		{
			this.TableName = "T_XT_XTYHXX";
		}

		public  void UpdateSequence()
		{
			//base.UpdateSequence("XTYHBH");
		}

		public  bool Read()
		{
			if(_reader.Read())
			{
				this.XTYHBH = Convert.ToInt32(_reader["XTYHBH"]);
				this.DSRBH = GlobalUtility.OracleKeyToInt(_reader["DSRBH"]);
				this.YHDLM = _reader["YHDLM"].ToString();
				this.YHDLMM = _reader["YHDLMM"].ToString();
				this.CJZBH = GlobalUtility.OracleKeyToInt(_reader["CJZBH"]);
				this.YHMS = _reader["YHMS"].ToString();
				this.ZCSJ = GlobalUtility.OracleKeyToDateTime(_reader["ZCSJ"]);
				this.ZXSJ = GlobalUtility.OracleKeyToDateTime(_reader["ZXSJ"]);
				return true;
			}
			else
			{
				return false;
			}
		}

		protected  bool RecordExists()
		{
			if(_selectCmd == null)
			{
				string cmdStr = "select count(*) from T_XT_XTYHXX where XTYHBH = :XTYHBH";
				_selectCmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
				_selectCmd.Parameters.Add(":XTYHBH",OracleType.Number,8);
			}
			_selectCmd.Parameters[":XTYHBH"].Value = this.XTYHBH;
			decimal count = (decimal)_selectCmd.ExecuteScalar();
			return (count > 0);
		}

		protected  void InsertRecord()
		{
			if(_insertCmd == null)
			{
				string cmdStr = "insert into T_XT_XTYHXX(XTYHBH,DSRBH,YHDLM,YHDLMM,CJZBH,YHMS,ZCSJ,ZXSJ) values(:XTYHBH,:DSRBH,:YHDLM,:YHDLMM,:CJZBH,:YHMS,:ZCSJ,:ZXSJ)";
				_insertCmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
				_insertCmd.Parameters.Add(":XTYHBH",OracleType.Number,8);
				_insertCmd.Parameters.Add(":DSRBH",OracleType.Number,8);
				_insertCmd.Parameters.Add(":YHDLM",OracleType.VarChar,10);
				_insertCmd.Parameters.Add(":YHDLMM",OracleType.VarChar,160);
				_insertCmd.Parameters.Add(":CJZBH",OracleType.Number,8);
				_insertCmd.Parameters.Add(":YHMS",OracleType.VarChar,500);
				_insertCmd.Parameters.Add(":ZCSJ",OracleType.DateTime);
				_insertCmd.Parameters.Add(":ZXSJ",OracleType.DateTime);
			}
			_insertCmd.Parameters[":XTYHBH"].Value = this.XTYHBH;
			_insertCmd.Parameters[":DSRBH"].Value = GlobalUtility.IntToOracleKey(this.DSRBH);
			_insertCmd.Parameters[":YHDLM"].Value = this.YHDLM;
			_insertCmd.Parameters[":YHDLMM"].Value = this.YHDLMM;
			_insertCmd.Parameters[":CJZBH"].Value = GlobalUtility.IntToOracleKey(this.CJZBH);
			_insertCmd.Parameters[":YHMS"].Value = this.YHMS;
			_insertCmd.Parameters[":ZCSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZCSJ);
			_insertCmd.Parameters[":ZXSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZXSJ);
			_insertCmd.ExecuteNonQuery();
			
		}

		public  void InsertRecord(OracleTransaction tran)
		{
			if(_insertCmd == null)
			{
				string cmdStr = "insert into T_XT_XTYHXX(XTYHBH,DSRBH,YHDLM,YHDLMM,CJZBH,YHMS,ZCSJ,ZXSJ) values(:XTYHBH,:DSRBH,:YHDLM,:YHDLMM,:CJZBH,:YHMS,:ZCSJ,:ZXSJ)";
				_insertCmd = new OracleCommand(cmdStr,DBAccess.DstConnection,tran);
				_insertCmd.Parameters.Add(":XTYHBH",OracleType.Number,8);
				_insertCmd.Parameters.Add(":DSRBH",OracleType.Number,8);
				_insertCmd.Parameters.Add(":YHDLM",OracleType.VarChar,10);
				_insertCmd.Parameters.Add(":YHDLMM",OracleType.VarChar,160);
				_insertCmd.Parameters.Add(":CJZBH",OracleType.Number,8);
				_insertCmd.Parameters.Add(":YHMS",OracleType.VarChar,500);
				_insertCmd.Parameters.Add(":ZCSJ",OracleType.DateTime);
				_insertCmd.Parameters.Add(":ZXSJ",OracleType.DateTime);
			}
			_insertCmd.Parameters[":XTYHBH"].Value = this.XTYHBH;
			_insertCmd.Parameters[":DSRBH"].Value = GlobalUtility.IntToOracleKey(this.DSRBH);
			_insertCmd.Parameters[":YHDLM"].Value = this.YHDLM;
			_insertCmd.Parameters[":YHDLMM"].Value = this.YHDLMM;
			_insertCmd.Parameters[":CJZBH"].Value = GlobalUtility.IntToOracleKey(this.CJZBH);
			_insertCmd.Parameters[":YHMS"].Value = this.YHMS;
			_insertCmd.Parameters[":ZCSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZCSJ);
			_insertCmd.Parameters[":ZXSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZXSJ);
			_insertCmd.ExecuteNonQuery();
			
		}

		protected  void UpdateRecord()
		{
			if(_updateCmd == null)
			{
				string cmdStr = "update T_XT_XTYHXX set DSRBH=:DSRBH,YHDLM=:YHDLM,YHDLMM=:YHDLMM,CJZBH=:CJZBH,YHMS=:YHMS,ZCSJ=:ZCSJ,ZXSJ=:ZXSJ where XTYHBH=:XTYHBH";
				_updateCmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
				_updateCmd.Parameters.Add(":XTYHBH",OracleType.Number,8);
				_updateCmd.Parameters.Add(":DSRBH",OracleType.Number,8);
				_updateCmd.Parameters.Add(":YHDLM",OracleType.VarChar,10);
				_updateCmd.Parameters.Add(":YHDLMM",OracleType.VarChar,160);
				_updateCmd.Parameters.Add(":CJZBH",OracleType.Number,8);
				_updateCmd.Parameters.Add(":YHMS",OracleType.VarChar,500);
				_updateCmd.Parameters.Add(":ZCSJ",OracleType.DateTime);
				_updateCmd.Parameters.Add(":ZXSJ",OracleType.DateTime);
			}
			_updateCmd.Parameters[":XTYHBH"].Value = this.XTYHBH;
			_updateCmd.Parameters[":DSRBH"].Value = GlobalUtility.IntToOracleKey(this.DSRBH);
			_updateCmd.Parameters[":YHDLM"].Value = this.YHDLM;
			_updateCmd.Parameters[":YHDLMM"].Value = this.YHDLMM;
			_updateCmd.Parameters[":CJZBH"].Value = GlobalUtility.IntToOracleKey(this.CJZBH);
			_updateCmd.Parameters[":YHMS"].Value = this.YHMS;
			_updateCmd.Parameters[":ZCSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZCSJ);
			_updateCmd.Parameters[":ZXSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZXSJ);
			_updateCmd.ExecuteNonQuery();
		}
	}


	public class GlobalUtility
	{
		public static string CurDisplayDbName = "";
		public static string EmptyPassword = "DA39A3EE5E6B4B0D3255BFEF95601890AFD80709";


		private GlobalUtility()
		{
			
		}

		static GlobalUtility()
		{

		}

		public static int OracleKeyToInt(object obj)
		{
			if(obj==null || obj==System.DBNull.Value)
			{
				return -1;
			}
			else
			{
				string str = obj.ToString();
				if(str == "")
				{
					return -1;
				}
				else
				{
					return Convert.ToInt32(str);
				}
			}
		}

		public static float OracleKeyToFloat(object obj)
		{
			if(obj==null || obj==System.DBNull.Value)
			{
				return -1;
			}
			else
			{
				string str = obj.ToString();
				if(str == "")
				{
					return -1;
				}
				else
				{
					return float.Parse(str);
				}
			}
		}

		public static string OracleKeyToString(object obj)
		{
			if(obj==null || obj==System.DBNull.Value)
			{
				return "";
			}
			else
			{
				return obj.ToString();
			}
		}

		public static DateTime OracleKeyToDateTime(object obj)
		{
			if(obj==null || obj==System.DBNull.Value)
			{
				return DateTime.MinValue;
			}
			else
			{
				return (DateTime)obj;
			}
		}

		public static object DateTimeToOracleKey(DateTime obj)
		{
			if(obj != DateTime.MinValue)
			{
				return obj;
			}
			else
			{
				return System.DBNull.Value;
			}
		}

		public static object IntToOracleKey(int i)
		{
			if(i == -1)
			{
				return System.Data.OracleClient.OracleNumber.Null;
			}
			else
			{
				return i;
			}
		}

		public static object FloatToOracleKey(float f)
		{
			if(f == -1)
			{
				return System.Data.OracleClient.OracleNumber.Null;
			}
			else
			{
				return f;
			}
		}

		public static object StringToOracleKey(string str)
		{
			if(str==null || str.Trim()=="")
			{
				return System.Data.OracleClient.OracleString.Null;
			}
			else
			{
				return str;
			}
		}

		public static string ConfineLength(string str,int length)
		{
			byte[] bytes = System.Text.Encoding.Default.GetBytes(str);
			if(bytes.Length > length)
			{
				return System.Text.Encoding.Default.GetString(bytes,0,length);
			}
			else
			{
				return str;
			}
		}

		public static string EncryptPWD(string PWD)
		{
			string tmpStr = string.Empty;         //中间过度变量
			string desStr = string.Empty; 
			tmpStr=PWD;
			Byte[] dataToHash = System.Text.ASCIIEncoding.ASCII.GetBytes(tmpStr);
			byte[] hashvalue = (new System.Security.Cryptography.SHA1CryptoServiceProvider()).ComputeHash(dataToHash);
			tmpStr = BitConverter.ToString(hashvalue);
			desStr = tmpStr.Replace("-","");

			return desStr;
		}
	}

}