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 usp_QQNUM(DataRow dr, 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, dr.RowState == DataRowState.Deleted ? (object)dr["ID", DataRowVersion.Original]:(object)dr["ID"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@QQ", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["QQ", DataRowVersion.Original]:(object)dr["QQ"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@PASS", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["PASS", DataRowVersion.Original]:(object)dr["PASS"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@MD5PASS", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["MD5PASS", DataRowVersion.Original]:(object)dr["MD5PASS"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0825_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0825_BYTES", DataRowVersion.Original]:(object)dr["SP0X0825_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0825", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0825", DataRowVersion.Original]:(object)dr["SP0X0825"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0825_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0825_BYTES", DataRowVersion.Original]:(object)dr["RP0X0825_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0825", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0825", DataRowVersion.Original]:(object)dr["RP0X0825"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0826_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0826_BYTES", DataRowVersion.Original]:(object)dr["SP0X0826_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0826", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0826", DataRowVersion.Original]:(object)dr["SP0X0826"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@VERIFYKEY", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["VERIFYKEY", DataRowVersion.Original]:(object)dr["VERIFYKEY"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0826_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0826_BYTES", DataRowVersion.Original]:(object)dr["RP0X0826_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0826", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0826", DataRowVersion.Original]:(object)dr["RP0X0826"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0828_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0828_BYTES", DataRowVersion.Original]:(object)dr["SP0X0828_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0828", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0828", DataRowVersion.Original]:(object)dr["SP0X0828"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0828_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0828_BYTES", DataRowVersion.Original]:(object)dr["RP0X0828_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0828", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0828", DataRowVersion.Original]:(object)dr["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 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 usp_QQNUM(DataRow dr, 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, dr.RowState == DataRowState.Deleted ? (object)dr["ID", DataRowVersion.Original]:(object)dr["ID"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@QQ", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["QQ", DataRowVersion.Original]:(object)dr["QQ"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@PASS", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["PASS", DataRowVersion.Original]:(object)dr["PASS"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@MD5PASS", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["MD5PASS", DataRowVersion.Original]:(object)dr["MD5PASS"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0825_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0825_BYTES", DataRowVersion.Original]:(object)dr["SP0X0825_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0825", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0825", DataRowVersion.Original]:(object)dr["SP0X0825"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0825_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0825_BYTES", DataRowVersion.Original]:(object)dr["RP0X0825_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0825", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0825", DataRowVersion.Original]:(object)dr["RP0X0825"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0826_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0826_BYTES", DataRowVersion.Original]:(object)dr["SP0X0826_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0826", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0826", DataRowVersion.Original]:(object)dr["SP0X0826"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@VERIFYKEY", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["VERIFYKEY", DataRowVersion.Original]:(object)dr["VERIFYKEY"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0826_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0826_BYTES", DataRowVersion.Original]:(object)dr["RP0X0826_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0826", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0826", DataRowVersion.Original]:(object)dr["RP0X0826"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0828_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0828_BYTES", DataRowVersion.Original]:(object)dr["SP0X0828_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@SP0X0828", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["SP0X0828", DataRowVersion.Original]:(object)dr["SP0X0828"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0828_BYTES", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0828_BYTES", DataRowVersion.Original]:(object)dr["RP0X0828_BYTES"]));
_comm.Parameters.Add(DbHelper.CreateParameter("@RP0X0828", DbType.AnsiString, dr.RowState == DataRowState.Deleted ? (object)dr["RP0X0828", DataRowVersion.Original]:(object)dr["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
}
