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 Delete(string QQ, XResult rst)
{
QqnumInfo ins = new QQNUM(QQ).INNER;
this.usp_QQNUM(ins, DataOPerType.DELETE, rst);
return true;
}
public bool UpdateDB(DataTable dt, XResult rst)
{
SqlCommand _comm = DbHelper.Provider.CreateCommand() as SqlCommand;
SqlConnection _conn = DbHelper.NewConnection as SqlConnection;
_conn.Open();
_comm.Connection = _conn;
_comm.Transaction = _conn.BeginTransaction();
try
{
foreach (DataRow dr in dt.Rows)
{
switch (dr.RowState)
{
case DataRowState.Added:
{
this.usp_QQNUM(dr, DataOPerType.INSERT, rst);
if (rst.ErrCode != OPerErrType.SUCCESS) return false;
break;
}
case DataRowState.Modified:
{
this.usp_QQNUM(dr, DataOPerType.UPDATE, rst);
if (rst.ErrCode != OPerErrType.SUCCESS) return false;
break;
}
case DataRowState.Deleted:
{
this.usp_QQNUM(dr, DataOPerType.DELETE, rst);
if (rst.ErrCode != OPerErrType.SUCCESS) return false;
break;
}
}
}
_comm.Transaction.Commit();
return true;
}
catch (Exception ex)
{
_comm.Transaction.Rollback();
return false;
}
}
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 Update(QqnumInfo ins, XResult rst)
{
this.usp_QQNUM(ins, DataOPerType.UPDATE, rst);
return true;
}
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);
}
//???????
public bool Delete(string QQ, XResult rst)
{
return dal.Delete(QQ,rst);
}
