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