www.pudn.com > startprepare.rar > SysSupManager.cs
using System;
using System.Data.OracleClient;
using System.Data.SqlClient;
namespace DS.EMIS.StartPrepare
{
///
/// SysSupManager 的摘要说明。
///
public class SysSupManager
{
public SysSupManager()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
///
/// 创建超级用户
///
public void CreateSupUser(DtbT_XT_XTCZTXX operateInfo,DtbT_XT_XTCZZDXX terminalinfo,DtbT_XT_XTYHXX userInfo)
{
OracleConnection dstCnt = DBAccess.DstConnection;
dstCnt.Open();
#region 密码加密
if(userInfo.YHDLMM.Trim() == string.Empty)
{
userInfo.YHDLMM = GlobalUtility.EmptyPassword;
}
else
{
userInfo.YHDLMM = GlobalUtility.EncryptPWD(userInfo.YHDLMM);
}
#endregion
#region 判断前置信息是否存在
try
{
//operateInfo.ZZBH = this.GetZZBH();
terminalinfo.CZZDLX = this.GetCZZDLX();
}
catch(Exception ex)
{
dstCnt.Close();
throw ex;
}
#endregion
//获取sequence序号
operateInfo.CZTBH = DBAccess.GetNextVal(operateInfo.TableName);
terminalinfo.XTZDBH = DBAccess.GetNextVal(terminalinfo.TableName);
terminalinfo.CZTBH = operateInfo.CZTBH;
userInfo.XTYHBH = DBAccess.GetNextVal(userInfo.TableName);
OracleTransaction tran = DBAccess.DstConnection.BeginTransaction();
try
{
operateInfo.InsertRecord(tran);
terminalinfo.InsertRecord(tran);
userInfo.InsertRecord(tran);
tran.Commit();
}
catch (SqlException ex)
{
tran.Rollback();
throw ex;
}
finally
{
dstCnt.Close();
}
}
private int GetZZBH()
{
string cmdStr = string.Format("select MIN(ZZBH) from T_ZZ_ZZXX");
OracleCommand cmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
try
{
return Convert.ToInt32(cmd.ExecuteScalar());
}
catch
{
throw new Exception("缺少根组织信息!");
}
finally
{
cmd.Dispose();
}
}
private int GetCZZDLX()
{
string cmdStr = string.Format("select CZZDLX from T_XT_DM_CZZDLX where MS like '%系统管理%'");
OracleCommand cmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
try
{
return Convert.ToInt32(cmd.ExecuteScalar());
}
catch
{
throw new Exception("缺少操作终端类型代码!");
}
finally
{
cmd.Dispose();
}
}
}
///
/// 操作场所信息
///
public class DtbT_XT_CZCSXX
{
public string TableName = "";
protected OracleCommand _deleteCmd;
protected OracleCommand _selectCmd;
protected OracleCommand _insertCmd;
protected OracleCommand _updateCmd;
protected OracleDataReader _reader;
#region Table Members
public int CZCSBH = -1; //CZCSBH NUMBER(4) NOT NULL,
public int ZZBH = -1; //ZZBH NUMBER(8),
public string CSMC = ""; //CSMC VARCHAR2(50 BYTE),
public string CZTBJT=""; //CZTBJT VARCHAR2(3000 BYTE),
public string BZ= ""; //BZ VARCHAR2(200 BYTE),
public DateTime ZCSJ = DateTime.MinValue; //ZCSJ DATE,
public DateTime XSJ = DateTime.MinValue; //XSJ DATE
#endregion
public DtbT_XT_CZCSXX()
{
this.TableName = "DtbT_XT_CZCSXX";
}
protected void InsertRecord(OracleTransaction tran)
{
// if(_insertCmd == null)
// {
// string cmdStr = "insert into DtbT_XT_CZCSXX(CZCSBH,ZZBH,CSMC,CZTBJT,CZTCZWZ,CZTMC,BZ,ZCSJ,XSJ) values(:CZTBH,:CZCSBH,:ZZBH,:CZTSPWZ,:CZTCZWZ,:CZTMC,:CZTH,:ZCSJ,:ZXSJ)";
// _insertCmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
// _insertCmd.Parameters.Add(":CZTBH",OracleType.Number,4);
// _insertCmd.Parameters.Add(":CZCSBH",OracleType.Number,4);
// _insertCmd.Parameters.Add(":ZZBH",OracleType.Number,8);
// _insertCmd.Parameters.Add(":CZTSPWZ",OracleType.Number,8);
// _insertCmd.Parameters.Add(":CZTCZWZ",OracleType.Number,8);
// _insertCmd.Parameters.Add(":CZTMC",OracleType.VarChar,20);
// _insertCmd.Parameters.Add(":CZTH",OracleType.VarChar,8);
// _insertCmd.Parameters.Add(":ZCSJ",OracleType.DateTime);
// _insertCmd.Parameters.Add(":ZXSJ",OracleType.DateTime);
// }
// _insertCmd.Parameters[":CZTBH"].Value = this.CZTBH;
// _insertCmd.Parameters[":CZCSBH"].Value = GlobalUtility.IntToOracleKey(this.CZCSBH);
// _insertCmd.Parameters[":ZZBH"].Value = GlobalUtility.IntToOracleKey(this.ZZBH);
// _insertCmd.Parameters[":CZTSPWZ"].Value = GlobalUtility.FloatToOracleKey(this.CZTSPWZ);
// _insertCmd.Parameters[":CZTCZWZ"].Value = GlobalUtility.FloatToOracleKey(this.CZTCZWZ);
// _insertCmd.Parameters[":CZTMC"].Value = this.CZTMC;
// _insertCmd.Parameters[":CZTH"].Value = this.CZTH;
// _insertCmd.Parameters[":ZCSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZCSJ);
// _insertCmd.Parameters[":ZXSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZXSJ);
// _insertCmd.ExecuteNonQuery();
// _insertCmd.Transaction = tran;
}
}
///
/// 系统操作台信息
///
public class DtbT_XT_XTCZTXX
{
public string TableName = "";
protected OracleCommand _deleteCmd;
protected OracleCommand _selectCmd;
protected OracleCommand _insertCmd;
protected OracleCommand _updateCmd;
protected OracleDataReader _reader;
#region Table Members
public int CZTBH = -1; // NUMBER 4 N 操作台编号
public int CZCSBH = -1; // NUMBER 4 操作场所编号
public int ZZBH = -1; // NUMBER 8 组织编号
public float CZTSPWZ = -1; // NUMBER 4,4 操作台水平位置
public float CZTCZWZ = -1; // NUMBER 4,4 操作台垂直位置
public string CZTMC = ""; // VARCHAR2 20 操作台名称
public string CZTH = ""; // VARCHAR2 8 操作台号
public DateTime ZCSJ = DateTime.MinValue; // DATE 注册时间
public DateTime ZXSJ = DateTime.MinValue; // DATE 注销时间
#endregion
public DtbT_XT_XTCZTXX()
{
this.TableName = "T_XT_XTCZTXX";
}
public void UpdateSequence()
{
this.UpdateSequence("CZTBH");
}
protected void UpdateSequence(string key)
{
string maxStr = string.Format("select max({0}) from {1}",key,this.TableName);
OracleCommand maxCmd = new OracleCommand(maxStr,DBAccess.DstConnection);
object obj = maxCmd.ExecuteScalar();
decimal maxVal = 0;
if(obj != DBNull.Value)
{
maxVal = (decimal)obj;
}
string nextStr = string.Format("SELECT S_{0}.NEXTVAL FROM DUAL",this.TableName);
OracleCommand nextCmd = new OracleCommand(nextStr,DBAccess.DstConnection);
decimal nextVal = 0;
do
{
nextVal = (decimal)nextCmd.ExecuteScalar();
}
while(nextVal <= maxVal);
maxCmd.Dispose();
nextCmd.Dispose();
}
protected bool RecordExists()
{
if(_selectCmd == null)
{
string cmdStr = "select count(*) from T_XT_XTCZTXX where CZTBH=:CZTBH";
_selectCmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
_selectCmd.Parameters.Add(":CZTBH",OracleType.Number,4);
}
_selectCmd.Parameters[":CZTBH"].Value = this.CZTBH;
decimal count = (decimal)_selectCmd.ExecuteScalar();
return (count > 0);
}
public bool Read()
{
if(_reader.Read())
{
this.CZTBH = Convert.ToInt32(_reader["CZTBH"]);
this.CZCSBH = GlobalUtility.OracleKeyToInt(_reader["CZCSBH"]);
this.ZZBH = GlobalUtility.OracleKeyToInt(_reader["ZZBH"]);
this.CZTSPWZ = GlobalUtility.OracleKeyToFloat(_reader["CZTSPWZ"]);
this.CZTCZWZ = GlobalUtility.OracleKeyToFloat(_reader["CZTCZWZ"]);
this.CZTMC = _reader["CZTMC"].ToString();
this.CZTH = _reader["CZTH"].ToString();
this.ZCSJ = GlobalUtility.OracleKeyToDateTime(_reader["ZCSJ"]);
this.ZXSJ = GlobalUtility.OracleKeyToDateTime(_reader["ZXSJ"]);
return true;
}
else
{
return false;
}
}
protected void InsertRecord()
{
if(_insertCmd == null)
{
string cmdStr = "insert into T_XT_XTCZTXX(CZTBH,CZCSBH,ZZBH,CZTSPWZ,CZTCZWZ,CZTMC,CZTH,ZCSJ,ZXSJ) values(:CZTBH,:CZCSBH,:ZZBH,:CZTSPWZ,:CZTCZWZ,:CZTMC,:CZTH,:ZCSJ,:ZXSJ)";
_insertCmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
_insertCmd.Parameters.Add(":CZTBH",OracleType.Number,4);
_insertCmd.Parameters.Add(":CZCSBH",OracleType.Number,4);
_insertCmd.Parameters.Add(":ZZBH",OracleType.Number,8);
_insertCmd.Parameters.Add(":CZTSPWZ",OracleType.Number,8);
_insertCmd.Parameters.Add(":CZTCZWZ",OracleType.Number,8);
_insertCmd.Parameters.Add(":CZTMC",OracleType.VarChar,20);
_insertCmd.Parameters.Add(":CZTH",OracleType.VarChar,8);
_insertCmd.Parameters.Add(":ZCSJ",OracleType.DateTime);
_insertCmd.Parameters.Add(":ZXSJ",OracleType.DateTime);
}
_insertCmd.Parameters[":CZTBH"].Value = this.CZTBH;
_insertCmd.Parameters[":CZCSBH"].Value = GlobalUtility.IntToOracleKey(this.CZCSBH);
_insertCmd.Parameters[":ZZBH"].Value = GlobalUtility.IntToOracleKey(this.ZZBH);
_insertCmd.Parameters[":CZTSPWZ"].Value = GlobalUtility.FloatToOracleKey(this.CZTSPWZ);
_insertCmd.Parameters[":CZTCZWZ"].Value = GlobalUtility.FloatToOracleKey(this.CZTCZWZ);
_insertCmd.Parameters[":CZTMC"].Value = this.CZTMC;
_insertCmd.Parameters[":CZTH"].Value = this.CZTH;
_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_XTCZTXX(CZTBH,CZCSBH,ZZBH,CZTSPWZ,CZTCZWZ,CZTMC,CZTH,ZCSJ,ZXSJ) values(:CZTBH,:CZCSBH,:ZZBH,:CZTSPWZ,:CZTCZWZ,:CZTMC,:CZTH,:ZCSJ,:ZXSJ)";
_insertCmd = new OracleCommand(cmdStr,DBAccess.DstConnection,tran);
_insertCmd.Parameters.Add(":CZTBH",OracleType.Number,4);
_insertCmd.Parameters.Add(":CZCSBH",OracleType.Number,4);
_insertCmd.Parameters.Add(":ZZBH",OracleType.Number,8);
_insertCmd.Parameters.Add(":CZTSPWZ",OracleType.Number,8);
_insertCmd.Parameters.Add(":CZTCZWZ",OracleType.Number,8);
_insertCmd.Parameters.Add(":CZTMC",OracleType.VarChar,20);
_insertCmd.Parameters.Add(":CZTH",OracleType.VarChar,8);
_insertCmd.Parameters.Add(":ZCSJ",OracleType.DateTime);
_insertCmd.Parameters.Add(":ZXSJ",OracleType.DateTime);
}
_insertCmd.Parameters[":CZTBH"].Value = this.CZTBH;
_insertCmd.Parameters[":CZCSBH"].Value = GlobalUtility.IntToOracleKey(this.CZCSBH);
_insertCmd.Parameters[":ZZBH"].Value = GlobalUtility.IntToOracleKey(this.ZZBH);
_insertCmd.Parameters[":CZTSPWZ"].Value = GlobalUtility.FloatToOracleKey(this.CZTSPWZ);
_insertCmd.Parameters[":CZTCZWZ"].Value = GlobalUtility.FloatToOracleKey(this.CZTCZWZ);
_insertCmd.Parameters[":CZTMC"].Value = this.CZTMC;
_insertCmd.Parameters[":CZTH"].Value = this.CZTH;
_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_XTCZTXX set CZCSBH=:CZCSBH,ZZBH=:ZZBH,CZTSPWZ=:CZTSPWZ,CZTCZWZ=:CZTCZWZ,CZTMC=:CZTMC,CZTH=:CZTH,ZCSJ=:ZCSJ,ZXSJ=:ZXSJ where CZTBH=:CZTBH";
_updateCmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
_updateCmd.Parameters.Add(":CZTBH",OracleType.Number,4);
_updateCmd.Parameters.Add(":CZCSBH",OracleType.Number,4);
_updateCmd.Parameters.Add(":ZZBH",OracleType.Number,8);
_updateCmd.Parameters.Add(":CZTSPWZ",OracleType.Number,8);
_updateCmd.Parameters.Add(":CZTCZWZ",OracleType.Number,8);
_updateCmd.Parameters.Add(":CZTMC",OracleType.VarChar,20);
_updateCmd.Parameters.Add(":CZTH",OracleType.VarChar,8);
_updateCmd.Parameters.Add(":ZCSJ",OracleType.DateTime);
_updateCmd.Parameters.Add(":ZXSJ",OracleType.DateTime);
}
_updateCmd.Parameters[":CZTBH"].Value = this.CZTBH;
_updateCmd.Parameters[":CZCSBH"].Value = GlobalUtility.IntToOracleKey(this.CZCSBH);
_updateCmd.Parameters[":ZZBH"].Value = GlobalUtility.IntToOracleKey(this.ZZBH);
_updateCmd.Parameters[":CZTSPWZ"].Value = GlobalUtility.FloatToOracleKey(this.CZTSPWZ);
_updateCmd.Parameters[":CZTCZWZ"].Value = GlobalUtility.FloatToOracleKey(this.CZTCZWZ);
_updateCmd.Parameters[":CZTMC"].Value = this.CZTMC;
_updateCmd.Parameters[":CZTH"].Value = this.CZTH;
_updateCmd.Parameters[":ZCSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZCSJ);
_updateCmd.Parameters[":ZXSJ"].Value = GlobalUtility.DateTimeToOracleKey(this.ZXSJ);
_updateCmd.ExecuteNonQuery();
}
}
///
/// 系统操作终端信息
///
public class DtbT_XT_XTCZZDXX
{
public string TableName = "";
protected OracleCommand _deleteCmd;
protected OracleCommand _selectCmd;
protected OracleCommand _insertCmd;
protected OracleCommand _updateCmd;
protected OracleDataReader _reader;
#region Table Members
public int XTZDBH = -1; // NUMBER 4 N 系统终端编号
public int CZZDLX = -1; // NUMBER 4 N 操作终端类型
public int CZTBH = -1; // NUMBER 4 N 操作台编号
public string ZDMC = ""; // VARCHAR2 20 终端名称
public string ZDIPDZ = ""; // VARCHAR2 50 终端IP地址
public string ZDMACDZ = ""; // VARCHAR2 50 终端MAC地址
public int ZDJSZT = 0; // INTEGER 终端枷锁状态
public DateTime ZCSJ = DateTime.MinValue; // DATE 注册时间
public DateTime ZXSJ = DateTime.MinValue; // DATE 注销时间
public string DQBBH = ""; // VARCHAR2 50 当前版本号
#endregion
public DtbT_XT_XTCZZDXX()
{
this.TableName = "T_XT_XTCZZDXX";
}
public void UpdateSequence()
{
//base.UpdateSequence("XTZDBH");
}
protected bool RecordExists()
{
if(_selectCmd == null)
{
string cmdStr = "select count(*) from T_XT_XTCZZDXX where XTZDBH=:XTZDBH";
_selectCmd = new OracleCommand(cmdStr,DBAccess.DstConnection);
_selectCmd.Parameters.Add(":XTZDBH",OracleType.Number,4);
}
_selectCmd.Parameters[":XTZDBH"].Value = this.XTZDBH;
decimal count = (decimal)_selectCmd.ExecuteScalar();
return (count > 0);
}
public bool Read()
{
if(_reader.Read())
{
this.XTZDBH = Convert.ToInt32(_reader["XTZDBH"]);
this.CZZDLX = Convert.ToInt32(_reader["CZZDLX"]);
this.CZTBH = Convert.ToInt32(_reader["CZTBH"]);
this.ZDMC = _reader["ZDMC"].ToString();
this.ZDIPDZ = _reader["ZDIPDZ"].ToString();
this.ZDMACDZ = _reader["ZDMACDZ"].ToString();
this.ZDJSZT = GlobalUtility.OracleKeyToInt(_reader["ZDJSZT"]);
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();
}
}
///
/// 系统用户信息
///
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;
}
}
}