// Get MatchTickets by Arsenal Matchs public static List <MatchTicket> All() { var mlist = Arsenal_Match.Cache.MatchList; if (mlist != null && mlist.Count > 0) { // Get DataSet of iArsenal_MatchTicket var attr = Repository.GetTableAttr <MatchTicket>(); var sql = $"SELECT * FROM {attr.Name} ORDER BY {attr.Sort}"; var ds = DataAccess.ExecuteDataset(sql); if (ds.Tables[0].Rows.Count > 0) { var dt = ds.Tables[0]; dt.PrimaryKey = new[] { dt.Columns["MatchGuid"] }; } var list = new List <MatchTicket>(); foreach (var m in mlist) { var mt = new MatchTicket { ID = m.ID }; if (ds.Tables[0].Rows.Count > 0) { var dr = ds.Tables[0].Rows.Find(m.ID); mt.Init(dr); } else { mt.Init(); } list.Add(mt); } return(list); } return(null); }
protected void btnDelete_Click(object sender, EventArgs e) { try { if (MatchGuid != Guid.Empty) { var mt = new MatchTicket { ID = MatchGuid }; mt.Delete(); ClientScript.RegisterClientScriptBlock(typeof(string), "succeed", "alert('删除成功');window.location.href='AdminMatchTicket.aspx'", true); } else { throw new Exception("选定的比赛不存在"); } } catch (Exception ex) { ClientScript.RegisterClientScriptBlock(typeof(string), "failed", $"alert('{ex.Message}')", true); } }
// Get MatchTickets by Arsenal Matchs public static List<MatchTicket> All() { var mlist = Arsenal_Match.Cache.MatchList; if (mlist != null && mlist.Count > 0) { // Get DataSet of iArsenal_MatchTicket var attr = Repository.GetTableAttr<MatchTicket>(); var sql = $"SELECT * FROM {attr.Name} ORDER BY {attr.Sort}"; var ds = DataAccess.ExecuteDataset(sql); if (ds.Tables[0].Rows.Count > 0) { var dt = ds.Tables[0]; dt.PrimaryKey = new[] { dt.Columns["MatchGuid"] }; } var list = new List<MatchTicket>(); foreach (var m in mlist) { var mt = new MatchTicket { ID = m.ID }; if (ds.Tables[0].Rows.Count > 0) { var dr = ds.Tables[0].Rows.Find(m.ID); mt.Init(dr); } else { mt.Init(); } list.Add(mt); } return list; } return null; }
protected void btnSubmit_Click(object sender, EventArgs e) { try { var mt = new MatchTicket { ID = MatchGuid }; mt.Single(); DateTime deadline; if (!string.IsNullOrEmpty(tbDeadline.Text.Trim()) && DateTime.TryParse(tbDeadline.Text.Trim(), out deadline)) { mt.Deadline = deadline; } else { mt.Deadline = mt.PlayTime.AddMonths(-2).AddDays(-7); } if (!string.IsNullOrEmpty(tbWaitingDeadline.Text.Trim()) && DateTime.TryParse(tbWaitingDeadline.Text.Trim(), out deadline)) { mt.WaitingDeadline = deadline; } else { mt.WaitingDeadline = mt.PlayTime.AddMonths(-1).AddDays(+7); } if (!string.IsNullOrEmpty(ddlAllowMemberClass.SelectedValue)) { mt.AllowMemberClass = Convert.ToInt16(ddlAllowMemberClass.SelectedValue); } else { mt.AllowMemberClass = null; } mt.IsActive = cbIsActive.Checked; mt.Remark = tbRemark.Text.Trim(); mt.ProductCode = ddlProductCode.SelectedValue; // Check whether MatchTicket Instance in DB if (mt.Any()) { mt.Update(); MatchTicket.Cache.RefreshCache(); ClientScript.RegisterClientScriptBlock(typeof(string), "succeed", "alert('更新成功');window.location.href=window.location.href", true); } else { mt.Create(); MatchTicket.Cache.RefreshCache(); ClientScript.RegisterClientScriptBlock(typeof(string), "succeed", "alert('添加成功');window.location.href = 'AdminMatchTicket.aspx'", true); } } catch (Exception ex) { ClientScript.RegisterClientScriptBlock(typeof(string), "failed", $"alert('{ex.Message}')", true); } }
private void InitForm() { if (MatchGuid != Guid.Empty) { var mt = new MatchTicket { ID = MatchGuid }; mt.Single(); // Get Match Info lblMatchGuid.Text = mt.ID.ToString(); if (mt.LeagueGuid.HasValue && !string.IsNullOrEmpty(mt.LeagueName)) lblLeagueName.Text = $"<em>{mt.LeagueName}</em>"; else lblLeagueName.Text = "无"; lblTeamName.Text = !string.IsNullOrEmpty(mt.TeamName) ? $"<em>{mt.TeamName}</em>" : "无"; lblIsHome.Text = mt.IsHome ? "主场" : "客场"; lblRound.Text = mt.Round?.ToString() ?? "/"; lblPlayTime.Text = $"<em>{mt.PlayTimeLocal.ToString("yyyy-MM-dd HH:mm")}</em>"; lblResultInfo.Text = $"<em>{mt.ResultInfo}</em>"; // Get Ticket Info ddlProductCode.SelectedValue = mt.ProductCode; tbDeadline.Text = mt.Deadline.ToString("yyyy-MM-dd"); tbWaitingDeadline.Text = mt.WaitingDeadline.ToString("yyyy-MM-dd"); ddlAllowMemberClass.SelectedValue = mt.AllowMemberClass?.ToString() ?? string.Empty; cbIsActive.Checked = mt.IsActive; tbRemark.Text = mt.Remark; //Bind MatchOrder data of this MatchTicket BindItemData(); //gvMatchOrder.DataSource = mt.OrderTicketList; //gvMatchOrder.DataBind(); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "succeed", "alert('选定的比赛不存在');window.location.href = 'AdminMatchTicket.aspx'", true); } }