private void BindGroupTeam(Guid leagueGuid)
{
var rlts = RelationLeagueTeam.QueryByLeagueGuid(leagueGuid);
var query = from rlt in rlts
join t in Team.Cache.TeamList on rlt.TeamGuid equals t.ID
orderby t.TeamEnglishName
select t;
lbLeagueTeam.DataSource = query;
lbLeagueTeam.DataTextField = "TeamDisplayName";
lbLeagueTeam.DataValueField = "ID";
lbLeagueTeam.DataBind();
lbLeagueTeam.Visible = true;
#region Set lbLeagueTeam Selected Items
if (GroupGuid != Guid.Empty)
{
var rgts = RelationGroupTeam.QueryByGroupGuid(GroupGuid);
foreach (ListItem item in lbLeagueTeam.Items)
{
if (rgts.Exists(x => x.TeamGuid.ToString() == item.Value))
{
item.Selected = true;
}
}
}
#endregion
}
public void Execute(object state)
{
var logInfo = new LogInfo
{
MethodInstance = MethodBase.GetCurrentMethod(),
ThreadInstance = Thread.CurrentThread
};
//string _scheduleType = this.GetType().DeclaringType.FullName;
try
{
log.Info("Scheduler Start: (RefreshCache)", logInfo);
Config.UpdateAssemblyInfo(Assembly.GetExecutingAssembly(), ConfigSystem.Arsenal);
ConfigGlobal_Arsenal.Refresh();
RelationLeagueTeam.Clean();
RelationLeagueTeam.Cache.RefreshCache();
RelationGroupTeam.Clean();
RelationLeagueTeam.Cache.RefreshCache();
League.Cache.RefreshCache();
Match.Cache.RefreshCache();
Player.Cache.RefreshCache();
Team.Cache.RefreshCache();
Video.Cache.RefreshCache();
//AcnCasino
CasinoItem.Clean();
ChoiceOption.Clean();
Bet.Clean();
BetDetail.Clean();
// Clean Log
Log.Clean();
log.Info("Scheduler End: (RefreshCache)", logInfo);
}
catch (Exception ex)
{
log.Warn(ex, logInfo);
}
}
protected void gvGroup_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
var g = e.Row.DataItem as Group;
var btnResetGroupTable = e.Row.FindControl("btnResetGroupTable") as LinkButton;
var btnResetGroupMatch = e.Row.FindControl("btnResetGroupMatch") as LinkButton;
if (g != null && btnResetGroupTable != null && btnResetGroupMatch != null)
{
btnResetGroupTable.CommandArgument = g.ID.ToString();
if (!g.IsTable)
{
btnResetGroupMatch.CommandArgument = g.ID.ToString();
}
else
{
btnResetGroupMatch.Visible = false;
}
}
var ltrlGroupTeamInfo = e.Row.FindControl("ltrlGroupTeamInfo") as Literal;
var ltrlGroupMatchInfo = e.Row.FindControl("ltrlGroupMatchInfo") as Literal;
if (g != null && ltrlGroupTeamInfo != null && ltrlGroupMatchInfo != null)
{
ltrlGroupTeamInfo.Text = $"<em>{RelationGroupTeam.QueryByGroupGuid(g.ID).Count}</em>";
List <CasinoMatch> matches;
if (!g.IsTable)
{
matches = _repo.Query <CasinoMatch>(x => x.GroupGuid == g.ID);
}
else
{
matches = _repo.Query <CasinoMatch>(x => x.LeagueGuid == g.LeagueGuid);
}
ltrlGroupMatchInfo.Text = $"<em>{matches.Count(x => x.ResultHome.HasValue && x.ResultAway.HasValue)} / {matches.Count}<em>";
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
using (var conn = new SqlConnection(DataAccess.ConnectString))
{
conn.Open();
var trans = conn.BeginTransaction();
try
{
if (string.IsNullOrEmpty(ddlGroupLeague.SelectedValue) ||
!lbLeagueTeam.Items.Cast <ListItem>().Any(x => x.Selected))
{
throw new Exception("请选择联赛分类与分组球队");
}
var g = new Group();
if (GroupGuid != Guid.Empty)
{
g = _repo.Single <Group>(GroupGuid);
}
else
{
g.ID = new Guid(tbGroupGuid.Text);
}
g.GroupName = tbGroupName.Text;
g.GroupOrder = Convert.ToInt16(tbGroupOrder.Text);
g.RankMethod = (RankMethodType)Enum.Parse(typeof(RankMethodType), rblRankMethod.SelectedValue);
g.IsTable = cbIsTable.Checked;
g.LeagueGuid = new Guid(ddlGroupLeague.SelectedValue);
#region ListBox Multiple Value for RelationGroupTeam
if (GroupGuid != Guid.Empty)
{
var rgts = RelationGroupTeam.QueryByGroupGuid(GroupGuid);
if (rgts.Count > 0)
{
foreach (var rgt in rgts)
{
rgt.Delete(trans);
}
}
}
foreach (ListItem item in lbLeagueTeam.Items)
{
Guid tGuid;
if (item.Selected && Guid.TryParse(item.Value, out tGuid))
{
var gt = new RelationGroupTeam
{
GroupGuid = g.ID,
TeamGuid = tGuid
};
gt.Insert(trans);
}
}
#endregion
if (GroupGuid != Guid.Empty)
{
_repo.Update(g, trans);
trans.Commit();
ClientScript.RegisterClientScriptBlock(typeof(string), "success", "alert('更新分组成功');", true);
}
else
{
_repo.Insert(g, trans);
trans.Commit();
ClientScript.RegisterClientScriptBlock(typeof(string), "success", "alert('添加分组成功');", true);
}
}
catch (Exception ex)
{
trans.Rollback();
ClientScript.RegisterClientScriptBlock(typeof(string), "failed", $"alert('{ex.Message}')", true);
}
}
}
