public const string BETDOMAIN_MULTISTRING_GROUP = "BETDOMAIN_MSG"; // BetDomain
public override void FillFromDataRow(DataRow dr)
{
this.MultiStringGroupID = DbConvert.ToInt64(dr, "MultiStringGroupID");
this.MultiStringGroupTag = DbConvert.ToString(dr, "MultiStringGroupTag");
this.Comment = DbConvert.ToString(dr, "Comment");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
this.SvrMultiStringGroupID = DbConvert.ToInt64(dr, "SvrMultiStringGroupID");
}
public override void FillFromDataRow(DataRow dr)
{
this.SportID = DbConvert.ToInt64(dr, "SportID");
this.SvrSportID = DbConvert.ToInt64(dr, "SvrSportID");
this.BtrSportID = DbConvert.ToNullableInt64(dr, "BtrSportID");
this.DefaultName = DbConvert.ToString(dr, "DefaultName");
this.MultiStringID = DbConvert.ToInt64(dr, "MultiStringID");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
}
public override void FillFromDataRow(System.Data.DataRow dr)
{
this.MatchInfoId = DbConvert.ToInt64(dr, "matchinfoid");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
MatchInfosValuesExternalState obj = LineSerializeHelper.StringToObject <MatchInfosValuesExternalState>(DbConvert.ToString(dr, "external_state"));
this.external_state.StatisticValues = obj.StatisticValues;
}
public override void FillFromDataRow(System.Data.DataRow dr)
{
this.TournamentInfoId = DbConvert.ToInt64(dr, "tournamentinfoid");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
TournamentInfosValuesExternalState obj = LineSerializeHelper.StringToObject <TournamentInfosValuesExternalState>(DbConvert.ToString(dr, "external_state"));
this.external_state.CompetitorsContainer = obj.CompetitorsContainer;
}
public override void FillFromDataRow(DataRow dr)
{
this.CategoryID = DbConvert.ToInt64(dr, "CategoryID");
this.SvrCategoryID = DbConvert.ToInt64(dr, "SvrCategoryID");
this.MultiStringID = DbConvert.ToInt64(dr, "MultiStringID");
this.DefaultName = DbConvert.ToString(dr, "DefaultName");
this.Sort = DbConvert.ToInt32(dr, "Sort");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
}
public override void FillFromDataRow(DataRow dr)
{
this.UpdateFileID = DbConvert.ToInt64(dr, "UpdateFileID");
//this.UpdateId = DbConvert.ToInt64(dr, "UpdateId");
this.DataSyncCacheID = DbConvert.ToInt64(dr, "DataSyncCacheID");
this.DataSyncCacheType = DbConvert.ToString(dr, "DataSyncCacheType");
this.FileName = DbConvert.ToString(dr, "FileName");
this.Description = DbConvert.ToString(dr, "Description");
this.CreateDate = DbConvert.ToDateTime(dr, "CreateDate");
}
public override void FillFromDataRow(DataRow dr)
{
this.LanguageID = DbConvert.ToInt64(dr, "LanguageID");
this.ShortName = DbConvert.ToString(dr, "ShortName");
this.MultiStringID = DbConvert.ToInt64(dr, "MultiStringID");
this.Priority = DbConvert.ToNullableInt32(dr, "Priority");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
this.SvrLanguageId = DbConvert.ToInt64(dr, "SvrLanguageId");
this.IsTerminalLanguage = DbConvert.ToInt32(dr, "IsTerminalLanguage");
}
public override void FillFromDataRow(DataRow dr)
{
this.LanguageStringID = DbConvert.ToInt64(dr, "LanguageStringId");
this.Text = DbConvert.ToString(dr, "Text");
this.MultiStringID = DbConvert.ToInt64(dr, "MultiStringID");
this.LanguageID = DbConvert.ToInt64(dr, "LanguageID");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
this.SvrLanguageStringID = DbConvert.ToInt64(dr, "SvrLanguageStringID");
this.IsLiveBet = DbConvert.ToBool(dr, "IsLiveBet");
}
/// <summary>
/// 读取可空日期型值
/// </summary>
/// <param name="row">数据行</param>
/// <param name="columns">列集合</param>
/// <param name="columnName">列名称</param>
/// <returns>日期型结果</returns>
protected DateTime?LoadNullableDateTime(DataRow row, DataColumnCollection columns, String columnName)
{
if (columns.Contains(columnName) && !Convert.IsDBNull(row[columnName]))
{
return(DbConvert.ToDateTime(row[columnName]));
}
else
{
return(null);
}
}
/// <summary>
/// 读取可空日期型值
/// </summary>
/// <param name="args">对象创建参数</param>
/// <param name="columnName">列名称</param>
/// <returns>日期型结果</returns>
protected DateTime?LoadNullableDateTime(EntityCreatingArgs args, String columnName)
{
if (args.Columns.Contains(columnName) && !DbConvert.IsDBNull(args.Row[columnName]))
{
return(DbConvert.ToDateTime(args.Row[columnName]));
}
else
{
return(null);
}
}
public override void FillFromDataRow(System.Data.DataRow dr)
{
this.SuperBtrId = DbConvert.ToInt64(dr, "SuperBtrId");
this.CompetitorInfoId = DbConvert.ToInt64(dr, "CompetitorInfoId");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
this.TshirtAway = DbConvert.ToString(dr, "TshirtAway");
this.TshirtHome = DbConvert.ToString(dr, "TshirtHome");
CompetitorInfosValuesExternalState obj = LineSerializeHelper.StringToObject <CompetitorInfosValuesExternalState>(DbConvert.ToString(dr, "external_state"));
this.external_state.StatisticValues = obj.StatisticValues;
}
public override void FillFromDataRow(DataRow dr)
{
this.UpdateId = DbConvert.ToInt64(dr, "UpdateId");
this.Modified = DbConvert.ToDateTime(dr, "Modified");
string sUpdateType = DbConvert.ToString(dr, "UpdateType");
this.UpdateType = (eUpdateType)Enum.Parse(typeof(eUpdateType), sUpdateType, true);
this.Description = DbConvert.ToString(dr, "Description");
this.ProviderDescription = DbConvert.ToString(dr, "ProviderDescription");
//this.ProviderTag = DbConvert.ToString(dr, "ProviderTag");
}
public override void FillFromDataRow(DataRow dr)
{
this.OddID = DbConvert.ToInt64(dr, "OddID");
this.SvrOddID = DbConvert.ToInt64(dr, "SvrOddID");
this.Value = DbConvert.ToDecimal(dr, "Value");
this.ScanCode = DbConvert.ToString(dr, "ScanCode");
this.Calculated = DbConvert.ToBool(dr, "Calculated");
this.Won = DbConvert.ToBool(dr, "Won");
this.Sort = DbConvert.ToInt32(dr, "Sort");
this.UserID = DbConvert.ToInt64(dr, "UserID");
this.MultiStringID = DbConvert.ToInt64(dr, "MultiStringID");
this.OddTag = DbConvert.ToString(dr, "OddTag");
this.MultiStringID2 = DbConvert.ToInt64(dr, "MultiStringID2");
this.BetDomainID = DbConvert.ToInt64(dr, "BetDomainID");
this.Active = DbConvert.ToBool(dr, "Active");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
this.IsLiveBet = DbConvert.ToBool(dr, "IsLiveBet");
this.Status = DbConvert.ToInt32(dr, "Status");
this.IsLocked = DbConvert.ToBool(dr, "IsLocked");
}
public override void FillFromDataRow(DataRow dr)
{
this.CompetitorID = DbConvert.ToInt64(dr, "CompetitorID");
this.SvrCompetitorID = DbConvert.ToInt64(dr, "SvrCompetitorID");
this.BtrCompetitorID = DbConvert.ToNullableInt64(dr, "BtrCompetitorID");
this.IsLiveBet = DbConvert.ToBool(dr, "IsLiveBet");
this.DefaultName = DbConvert.ToString(dr, "DefaultName");
this.SportID = DbConvert.ToNullableInt64(dr, "SportID");
this.MultiStringID = DbConvert.ToInt64(dr, "MultiStringID");
this.CountryID = DbConvert.ToNullableInt64(dr, "CountryID");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
try
{
this.BtrCompetitorID = DbConvert.ToInt64(dr, "BtrCompetitorID");
}
catch
{
}
}
public async Task <Tuple <List <Users>, int> > GetPage(string dateFrom, string dateTo, string orderBy, int pageSize, int pageNumber)
{
try
{
int rowCount = 0;
DbCommand dbCommand = _dbHelper.GetStoredProcCommand("Users_GetPage");
_dbHelper.AddInParameter(dbCommand, "@UserId", DbType.Int32, UserId);
_dbHelper.AddInParameter(dbCommand, "@UserName", DbType.String, UserName);
_dbHelper.AddInParameter(dbCommand, "@Password", DbType.String, Password);
_dbHelper.AddInParameter(dbCommand, "@FullName", DbType.String, FullName);
_dbHelper.AddInParameter(dbCommand, "@Address", DbType.String, Address);
_dbHelper.AddInParameter(dbCommand, "@Email", DbType.String, Email);
_dbHelper.AddInParameter(dbCommand, "@Mobile", DbType.String, Mobile);
_dbHelper.AddInParameter(dbCommand, "@GenderId", DbType.Byte, GenderId);
_dbHelper.AddInParameter(dbCommand, "@UserStatusId", DbType.Byte, UserStatusId);
_dbHelper.AddInParameter(dbCommand, "@UserTypeId", DbType.Byte, UserTypeId);
_dbHelper.AddInParameter(dbCommand, "@DefaultActionId", DbType.Int16, DefaultActionId);
if (!string.IsNullOrEmpty(dateFrom))
{
_dbHelper.AddInParameter(dbCommand, "@DateFrom", DbType.DateTime, DbConvert.ToDateTime(dateFrom));
}
if (!string.IsNullOrEmpty(dateTo))
{
_dbHelper.AddInParameter(dbCommand, "@DateTo", DbType.DateTime, DbConvert.ToDateTime(dateTo));
}
_dbHelper.AddInParameter(dbCommand, "@OrderBy", DbType.String, orderBy);
_dbHelper.AddInParameter(dbCommand, "@PageSize", DbType.Int32, pageSize);
_dbHelper.AddInParameter(dbCommand, "@PageNumber", DbType.Int32, pageNumber);
_dbHelper.AddOutParameter(dbCommand, "@RowCount", DbType.Int32);
List <Users> list = await _dbHelper.ExecuteListAsync <Users>(dbCommand);
rowCount = Convert.ToInt32(dbCommand.Parameters["@RowCount"].Value ?? "0");
return(new Tuple <List <Users>, int>(list, rowCount));
}
catch (Exception ex)
{
throw ex;
}
}
public override void FillFromDataRow(DataRow dr)
{
this.TournamentID = DbConvert.ToInt64(dr, "TournamentID");
this.SvrTournamentID = DbConvert.ToInt64(dr, "SvrTournamentID");
this.DefaultName = DbConvert.ToString(dr, "DefaultName");
this.BtrTournamentID = DbConvert.ToNullableInt64(dr, "BtrTournamentID");
this.MultiStringID = DbConvert.ToInt64(dr, "MultiStringID");
this.SportID = DbConvert.ToInt64(dr, "SportID");
this.CategoryID = DbConvert.ToNullableInt64(dr, "CategoryID");
this.MaxStakeLigaLimit = DbConvert.ToNullableDecimal(dr, "MaxStakeLigaLimit");
this.MaxStakeTipLimit = DbConvert.ToNullableDecimal(dr, "MaxStakeTipLimit");
this.MinCombination = DbConvert.ToNullableInt32(dr, "MinCombination");
this.Active = DbConvert.ToBool(dr, "Active");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
this.TennisSet = DbConvert.ToNullableInt32(dr, "TennisSets");
this.ShowOnOddSheet = DbConvert.ToBool(dr, "ShowOnOddSheet");
this.Info = DbConvert.ToString(dr, "Info");
this.OutrightType = DbConvert.ToInt32(dr, "OutrightTyp");
this.Sort = DbConvert.ToInt32(dr, "Sort");
this.IsLiveBet = DbConvert.ToBool(dr, "IsLiveBet");
this.IsLocked = DbConvert.ToBool(dr, "IsLocked");
this.LockWithAllOtherTournaments = DbConvert.ToBool(dr, "LockWithAllOtherTournaments");
}