请问一个类的写法？

Question

using System;
using System.Data;
using System.Data.SqlClient;namespace backDbAdmin.Components
{
/// <summary>
/// 比赛竞技馆比赛信息类
/// </summary>
public class MatchAthletics
{
public MatchAthletics()
{
//
// TODO: 在此处添加构造函数逻辑
//
connectDB();
} /// <summary>
/// 数据库连接
/// </summary>
private void connectDB()
{
SysConfig.setConnStr("MATCHUSER", "");
} /// <summary>
/// 添加比赛名称
/// </summary>
/// <param name="MatchName"></param>
/// <returns>ErrorNum</returns>
public int CreatGame(string MatchName)
{
int ErrorNum = 0;
SqlParameter[] prams = {
DataAccess.MakeInParam("@MatchName", SqlDbType.VarChar, 50, MatchName),
DataAccess.MakeOutParam("@errorNum", SqlDbType.Int, 4)
   };
DataAccess.ExecutePorcedure("proc_AddMatch", prams);
ErrorNum = Convert.ToInt32(prams[1].Value);
return ErrorNum;
} /// <summary>
/// 修改比赛名称
/// </summary>
/// <param name="MatchNameID"></param>
/// <param name="MatchName"></param>
public int editGameName(string OldMatchName, string MatchName)
{
int ErrorNum = 0;
SqlParameter[] prams = {
DataAccess.MakeInParam("@OldMatchName", SqlDbType.VarChar, 50, OldMatchName),
DataAccess.MakeInParam("@MatchName", SqlDbType.VarChar, 50, MatchName),
DataAccess.MakeOutParam("@errorNum", SqlDbType.Int, 4)
   };
DataAccess.ExecutePorcedure("proc_EditMatch", prams);
ErrorNum = Convert.ToInt32(prams[2].Value);
return ErrorNum;
}

/// <summary>
/// 删除比赛
/// </summary>
/// <param name="MatchNameID"></param>
public void delGame(int MatchNameID)
{
string sqlStr = "delete from DG_MatchList where MatchNameID = "+MatchNameID+"";
DataAccess.ExecuteSql(sqlStr);
} /// <summary>
/// 添加单关摇奖比赛信息
/// </summary>
/// <param name="MatchNameID"></param>
/// <param name="MatchMode"></param>
/// <param name="LogoPic"></param>
/// <param name="LogoUrl"></param>
/// <param name="BillUrl"></param>
/// <param name="MatchPic"></param>
/// <param name="MatchExplain"></param>
/// <param name="SubjectNum"></param>
/// <param name="PassNum"></param>
/// <param name="MatchStartTime"></param>
/// <param name="MatchEndTime"></param>
/// <param name="EmieTime"></param>
/// <param name="JoinNum"></param>
/// <param name="FlashUrl"></param>
/// <param name="PlayUrl"></param>
/// <param name="AwardInfo"></param>
/// <param name="BuoyNum"></param>
/// <param name="OneNum"></param>
/// <param name="TwoNum"></param>
/// <param name="ThreeNum"></param>
/// <param name="FourNum"></param>
/// <param name="FiveNum"></param>
/// <param name="SixNum"></param>
/// <param name="SevenNum"></param>
/// <param name="EightNum"></param>
/// <param name="NineNum"></param>
/// <param name="TenNum"></param>
/// <param name="SpaceTime"></param>
/// <param name="MsgContent"></param>
/// <param name="RoomNum"></param>
/// <param name="LimitTerm1"></param>
/// <param name="LimitLevel1"></param>
/// <param name="LimitTerm2"></param>
/// <param name="LimitLevel2"></param>
/// <param name="MatchID"></param>
/// <returns></returns>
public int addMatchInfo(int MatchNameID, byte MatchMode, byte[] LogoPic, string LogoUrl, 
string BillUrl, byte[] MatchPic, string MatchExplain, Int16 SubjectNum, Int16 PassNum, 
DateTime MatchStartTime, DateTime MatchEndTime, DateTime EmieTime, Int16 JoinNum, 
string FlashUrl, string PlayUrl, string PlayRule, string AwardInfo, Int16 BuoyNum, Int16 OneNum, 
Int16 TwoNum, Int16 ThreeNum, Int16 FourNum, Int16 FiveNum, Int16 SixNum, Int16 SevenNum,
Int16 EightNum, Int16 NineNum, Int16 TenNum, Int16 SpaceTime, string MsgContent, 
Int16 RoomNum, string LimitTerm1, Int16 LimitLevel1, string LimitTerm2, Int16 LimitLevel2, 
int MatchID)
{
int matchID = 0;
SqlParameter[] prams = {
DataAccess.MakeInParam("@MatchNameID", SqlDbType.Int, 4, MatchNameID),
DataAccess.MakeInParam("@MatchMode", SqlDbType.TinyInt, 1, MatchMode),
DataAccess.MakeInParam("@LogoPic", SqlDbType.Image, 16, LogoPic),
DataAccess.MakeInParam("@LogoUrl", SqlDbType.VarChar, 100, LogoUrl),
DataAccess.MakeInParam("@BillUrl", SqlDbType.VarChar, 512, BillUrl),
DataAccess.MakeInParam("@MatchPic", SqlDbType.Image, 16, MatchPic),
DataAccess.MakeInParam("@MatchExplain", SqlDbType.VarChar, 100, MatchExplain),
DataAccess.MakeInParam("@SubjectNum", SqlDbType.SmallInt, 2, SubjectNum),
DataAccess.MakeInParam("@PassNum", SqlDbType.SmallInt, 2, PassNum),
DataAccess.MakeInParam("@MatchStartTime", SqlDbType.DateTime, 8, MatchStartTime),
DataAccess.MakeInParam("@MatchEndTime", SqlDbType.DateTime, 8, MatchStartTime),
DataAccess.MakeInParam("@EmieTime", SqlDbType.DateTime, 8, EmieTime),
DataAccess.MakeInParam("@JoinNum", SqlDbType.SmallInt, 2, JoinNum),
DataAccess.MakeInParam("@FlashUrl", SqlDbType.VarChar, 100, FlashUrl),
DataAccess.MakeInParam("@PlayRule", SqlDbType.VarChar, 300, PlayRule),
DataAccess.MakeInParam("@PlayUrl", SqlDbType.VarChar, 100, PlayUrl),
DataAccess.MakeInParam("@AwardInfo", SqlDbType.VarChar, 100, AwardInfo),
DataAccess.MakeInParam("@BuoyNum", SqlDbType.SmallInt, 2, BuoyNum),
DataAccess.MakeInParam("@OneNum", SqlDbType.SmallInt, 2, OneNum),
DataAccess.MakeInParam("@TwoNum", SqlDbType.SmallInt, 2, TwoNum),
DataAccess.MakeInParam("@ThreeNum", SqlDbType.SmallInt, 2, ThreeNum),
DataAccess.MakeInParam("@FourNum", SqlDbType.SmallInt, 2, FourNum),
DataAccess.MakeInParam("@FiveNum", SqlDbType.SmallInt, 2, FiveNum),
DataAccess.MakeInParam("@SixNum", SqlDbType.SmallInt, 2, SixNum),
DataAccess.MakeInParam("@SevenNum", SqlDbType.SmallInt, 2, SevenNum),
DataAccess.MakeInParam("@EightNum", SqlDbType.SmallInt, 2, EightNum),
DataAccess.MakeInParam("@NineNum", SqlDbType.SmallInt, 2, NineNum),
DataAccess.MakeInParam("@TenNum", SqlDbType.SmallInt, 2, TenNum),
DataAccess.MakeInParam("@SpaceTime", SqlDbType.SmallInt, 2, SpaceTime),
DataAccess.MakeInParam("@MsgContent", SqlDbType.VarChar, 1400, MsgContent),
DataAccess.MakeInParam("@RoomNum", SqlDbType.SmallInt, 2, RoomNum),
DataAccess.MakeInParam("@LimitTerm1", SqlDbType.VarChar, 2, LimitTerm1),
DataAccess.MakeInParam("@LimitLevel1", SqlDbType.SmallInt, 2, LimitLevel1),
DataAccess.MakeInParam("@LimitTerm2", SqlDbType.VarChar, 2, LimitTerm2),
DataAccess.MakeInParam("@LimitLevel2", SqlDbType.SmallInt, 2, LimitLevel2),
DataAccess.MakeOutParam("@MatchID", SqlDbType.Int, 4)
 };
DataAccess.ExecutePorcedure("proc_AddMatchInfo", prams);
matchID = Convert.ToInt32(prams[36].Value);
return matchID;

}

Answer 1

/// <summary>
/// 修改单关摇奖比赛信息
/// </summary>
/// <param name="MatchID"></param>
/// <param name="MatchMode"></param>
/// <param name="LogoPic"></param>
/// <param name="LogoUrl"></param>
/// <param name="BillUrl"></param>
/// <param name="MatchPic"></param>
/// <param name="MatchExplain"></param>
/// <param name="SubjectNum"></param>
/// <param name="PassNum"></param>
/// <param name="MatchStartTime"></param>
/// <param name="MatchEndTime"></param>
/// <param name="EmieTime"></param>
/// <param name="JoinNum"></param>
/// <param name="FlashUrl"></param>
/// <param name="PlayUrl"></param>
/// <param name="AwardInfo"></param>
/// <param name="BuoyNum"></param>
/// <param name="OneNum"></param>
/// <param name="TwoNum"></param>
/// <param name="ThreeNum"></param>
/// <param name="FourNum"></param>
/// <param name="FiveNum"></param>
/// <param name="SixNum"></param>
/// <param name="SevenNum"></param>
/// <param name="EightNum"></param>
/// <param name="NineNum"></param>
/// <param name="TenNum"></param>
/// <param name="SpaceTime"></param>
/// <param name="MsgContent"></param>
/// <param name="RoomNum"></param>
/// <param name="LimitTerm1"></param>
/// <param name="LimitLevel1"></param>
/// <param name="LimitTerm2"></param>
/// <param name="LimitLevel2"></param>
public void editMatchInfo(int MatchID, byte MatchMode, byte[] LogoPic, string LogoUrl, 
string BillUrl, byte[] MatchPic, string MatchExplain, Int16 SubjectNum, Int16 PassNum, 
DateTime MatchStartTime, DateTime MatchEndTime, DateTime EmieTime, Int16 JoinNum, 
string FlashUrl, string PlayUrl, string PlayRule, string AwardInfo, Int16 BuoyNum, Int16 OneNum, 
Int16 TwoNum, Int16 ThreeNum, Int16 FourNum, Int16 FiveNum, Int16 SixNum, Int16 SevenNum,
Int16 EightNum, Int16 NineNum, Int16 TenNum, Int16 SpaceTime, string MsgContent, 
Int16 RoomNum, string LimitTerm1, Int16 LimitLevel1, string LimitTerm2, Int16 LimitLevel2)
{
SqlParameter[] prams = {
 DataAccess.MakeInParam("@MatchID", SqlDbType.Int, 4, MatchID),
 DataAccess.MakeInParam("@MatchMode", SqlDbType.TinyInt, 1, MatchMode),
 DataAccess.MakeInParam("@LogoPic", SqlDbType.Image, 16, LogoPic),
 DataAccess.MakeInParam("@LogoUrl", SqlDbType.VarChar, 100, LogoUrl),
 DataAccess.MakeInParam("@BillUrl", SqlDbType.VarChar, 512, BillUrl),
 DataAccess.MakeInParam("@MatchPic", SqlDbType.Image, 16, MatchPic),
 DataAccess.MakeInParam("@MatchExplain", SqlDbType.VarChar, 100, MatchExplain),
 DataAccess.MakeInParam("@SubjectNum", SqlDbType.SmallInt, 2, SubjectNum),
 DataAccess.MakeInParam("@PassNum", SqlDbType.SmallInt, 2, PassNum),
 DataAccess.MakeInParam("@MatchStartTime", SqlDbType.DateTime, 8, MatchStartTime),
 DataAccess.MakeInParam("@MatchEndTime", SqlDbType.DateTime, 8, MatchStartTime),
 DataAccess.MakeInParam("@EmieTime", SqlDbType.DateTime, 8, EmieTime),
 DataAccess.MakeInParam("@JoinNum", SqlDbType.SmallInt, 2, JoinNum),
 DataAccess.MakeInParam("@FlashUrl", SqlDbType.VarChar, 100, FlashUrl),
 DataAccess.MakeInParam("@PlayRule", SqlDbType.VarChar, 300, PlayRule),
 DataAccess.MakeInParam("@PlayUrl", SqlDbType.VarChar, 100, PlayUrl),
 DataAccess.MakeInParam("@AwardInfo", SqlDbType.VarChar, 100, AwardInfo),
 DataAccess.MakeInParam("@BuoyNum", SqlDbType.SmallInt, 2, BuoyNum),
 DataAccess.MakeInParam("@OneNum", SqlDbType.SmallInt, 2, OneNum),
 DataAccess.MakeInParam("@TwoNum", SqlDbType.SmallInt, 2, TwoNum),
 DataAccess.MakeInParam("@ThreeNum", SqlDbType.SmallInt, 2, ThreeNum),
 DataAccess.MakeInParam("@FourNum", SqlDbType.SmallInt, 2, FourNum),
 DataAccess.MakeInParam("@FiveNum", SqlDbType.SmallInt, 2, FiveNum),
 DataAccess.MakeInParam("@SixNum", SqlDbType.SmallInt, 2, SixNum),
 DataAccess.MakeInParam("@SevenNum", SqlDbType.SmallInt, 2, SevenNum),
 DataAccess.MakeInParam("@EightNum", SqlDbType.SmallInt, 2, EightNum),
 DataAccess.MakeInParam("@NineNum", SqlDbType.SmallInt, 2, NineNum),
 DataAccess.MakeInParam("@TenNum", SqlDbType.SmallInt, 2, TenNum),
 DataAccess.MakeInParam("@SpaceTime", SqlDbType.SmallInt, 2, SpaceTime),
 DataAccess.MakeInParam("@MsgContent", SqlDbType.VarChar, 1400, MsgContent),
 DataAccess.MakeInParam("@RoomNum", SqlDbType.SmallInt, 2, RoomNum),
 DataAccess.MakeInParam("@LimitTerm1", SqlDbType.VarChar, 2, LimitTerm1),
 DataAccess.MakeInParam("@LimitLevel1", SqlDbType.SmallInt, 2, LimitLevel1),
 DataAccess.MakeInParam("@LimitTerm2", SqlDbType.VarChar, 2, LimitTerm2),
 DataAccess.MakeInParam("@LimitLevel2", SqlDbType.SmallInt, 2, LimitLevel2),
 DataAccess.MakeOutParam("@MatchID", SqlDbType.Int, 4)
 };
DataAccess.ExecutePorcedure("proc_EditMatchInfo", prams); } public class MatchInfo
{
private int _MatchID;
private int _MatchNameID;
private byte _MatchMode;
private byte[] _LogoPic;
private string _LogoUrl;
private string _BillUrl;
private byte[] _MatchPic;
private string _MatchExplain;
private Int16 _SubjectNum;
private Int16 _PassNum;
private DateTime _MatchStartTime;
private DateTime _MatchEndTime;
private DateTime _EmieTime;
private Int16 _JoinNum;
private string _FlashUrl;
private string _PlayUrl;
private string _PlayRule;
private string _AwardInfo;
private Int16 _BuoyNum;
private Int16 _OneNum;
private Int16 _TwoNum;
private Int16 _ThreeNum;
private Int16 _FourNum;
private Int16 _FiveNum;
private Int16 _SixNum;
private Int16 _SevenNum;
private Int16 _EightNum;
private Int16 _NineNum;
private Int16 _TenNum;
private Int16 _SpaceTime;
private string _MsgContent;
private Int16 _RoomNum;
private string _LimitTerm1;
private Int16 _LimitLevel1;
private string _LimitTerm2;
private Int16 _LimitLevel2; public int MatchID 
{
get { return _MatchID; }
}
public int MatchNameID
{
get { return _MatchNameID; }
set { _MatchNameID = value; }
}
                            ......
}
}

}
这是我建立的一个类，
其实就是我数据库中一个表中的所有字段做为了属性，增加了添加、修改和删除的方法。
但不全，不知该如何继续了……请大虾们给予指点！谢谢！