Exemplo n.º 1
0
 protected void LoadFromReader(IDataReader reader)
 {
     if (reader != null && !reader.IsClosed)
     {
         inner = new QqnumInfo();
         if (!reader.IsDBNull(0)) inner.ID = reader.GetInt32(0);
         if (!reader.IsDBNull(1)) inner.QQ = reader.GetString(1);
         if (!reader.IsDBNull(2)) inner.PASS = reader.GetString(2);
         if (!reader.IsDBNull(3)) inner.MD5PASS = reader.GetString(3);
         if (!reader.IsDBNull(4)) inner.SP0X0825_BYTES = reader.GetString(4);
         if (!reader.IsDBNull(5)) inner.SP0X0825 = reader.GetString(5);
         if (!reader.IsDBNull(6)) inner.RP0X0825_BYTES = reader.GetString(6);
         if (!reader.IsDBNull(7)) inner.RP0X0825 = reader.GetString(7);
         if (!reader.IsDBNull(8)) inner.SP0X0826_BYTES = reader.GetString(8);
         if (!reader.IsDBNull(9)) inner.SP0X0826 = reader.GetString(9);
         if (!reader.IsDBNull(10)) inner.VERIFYKEY = reader.GetString(10);
         if (!reader.IsDBNull(11)) inner.RP0X0826_BYTES = reader.GetString(11);
         if (!reader.IsDBNull(12)) inner.RP0X0826 = reader.GetString(12);
         if (!reader.IsDBNull(13)) inner.SP0X0828_BYTES = reader.GetString(13);
         if (!reader.IsDBNull(14)) inner.SP0X0828 = reader.GetString(14);
         if (!reader.IsDBNull(15)) inner.RP0X0828_BYTES = reader.GetString(15);
         if (!reader.IsDBNull(16)) inner.RP0X0828 = reader.GetString(16);
     }
     else
     {
         inner = null;
     }
 }
Exemplo n.º 2
0
 public bool Update(QqnumInfo ins)
 {
     throw new NotImplementedException();
 }
Exemplo n.º 3
0
 public bool usp_QQNUM(QqnumInfo ins, DataOPerType dot, XResult rst)
 {
     SqlCommand _comm = DbHelper.Provider.CreateCommand() as SqlCommand;
     SqlConnection _conn = DbHelper.NewConnection as SqlConnection;
     _comm.Connection = _conn;
     _comm.CommandType = CommandType.StoredProcedure;
     _comm.CommandText = "usp_QQNUM";
     _conn.Open();
     _comm.Parameters.Add(DbHelper.CreateParameter("@ID", DbType.Int32, ins.ID));
     _comm.Parameters.Add(DbHelper.CreateParameter("@QQ", DbType.AnsiString, ins.QQ));
     _comm.Parameters.Add(DbHelper.CreateParameter("@PASS", DbType.AnsiString, ins.PASS));
     _comm.Parameters.Add(DbHelper.CreateParameter("@MD5PASS", DbType.AnsiString, ins.MD5PASS));
     _comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0825_BYTES", DbType.AnsiString, ins.SP0X0825_BYTES));
     _comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0825", DbType.AnsiString, ins.SP0X0825));
     _comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0825_BYTES", DbType.AnsiString, ins.RP0X0825_BYTES));
     _comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0825", DbType.AnsiString, ins.RP0X0825));
     _comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0826_BYTES", DbType.AnsiString, ins.SP0X0826_BYTES));
     _comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0826", DbType.AnsiString, ins.SP0X0826));
     _comm.Parameters.Add(DbHelper.CreateParameter("@VERIFYKEY", DbType.AnsiString, ins.VERIFYKEY));
     _comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0826_BYTES", DbType.AnsiString, ins.RP0X0826_BYTES));
     _comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0826", DbType.AnsiString, ins.RP0X0826));
     _comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0828_BYTES", DbType.AnsiString, ins.SP0X0828_BYTES));
     _comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0828", DbType.AnsiString, ins.SP0X0828));
     _comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0828_BYTES", DbType.AnsiString, ins.RP0X0828_BYTES));
     _comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0828", DbType.AnsiString, ins.RP0X0828));
     _comm.Parameters.Add(DbHelper.CreateParameter("@DataOPerType", DbType.Int16, dot));
     _comm.Parameters.Add(DbHelper.CreateParameter("@ErrCode", DbType.Int16, rst.ErrCode, 2, ParameterDirection.Output));
     _comm.Parameters.Add(DbHelper.CreateParameter("@ErrMsg", DbType.AnsiString, rst.ErrMsg, 1000, ParameterDirection.Output));
     _comm.ExecuteNonQuery();
     rst.ErrCode = (OPerErrType)Enum.ToObject(typeof(OPerErrType), _comm.Parameters["@ErrCode"].Value);
     rst.ErrMsg = _comm.Parameters["@ErrMsg"].Value.ToString();
     return true; //return
 }
Exemplo n.º 4
0
 public bool Update(QqnumInfo ins, XResult rst)
 {
     this.usp_QQNUM(ins, DataOPerType.UPDATE, rst);
     return true;
 }
Exemplo n.º 5
0
 public bool Insert(QqnumInfo ins)
 {
     throw new NotImplementedException();
 }
Exemplo n.º 6
0
 public bool Insert(QqnumInfo ins, XResult rst)
 {
     this.usp_QQNUM(ins, DataOPerType.INSERT, rst);
     return true;
 }
Exemplo n.º 7
0
 public bool Update(QqnumInfo ins, XResult rst)
 {
     return dal.Update(ins,rst);
 }
Exemplo n.º 8
0
 public bool Insert(QqnumInfo ins, XResult rst)
 {
     return dal.Insert(ins,rst);
 }