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);
}