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; } }
public bool Update(QqnumInfo ins) { throw new NotImplementedException(); }
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 }
public bool Update(QqnumInfo ins, XResult rst) { this.usp_QQNUM(ins, DataOPerType.UPDATE, rst); return true; }
public bool Insert(QqnumInfo ins) { throw new NotImplementedException(); }
public bool Insert(QqnumInfo ins, XResult rst) { this.usp_QQNUM(ins, DataOPerType.INSERT, rst); return true; }
public bool Update(QqnumInfo ins, XResult rst) { return dal.Update(ins,rst); }
public bool Insert(QqnumInfo ins, XResult rst) { return dal.Insert(ins,rst); }