protected void btnEdit_Click(object sender, System.EventArgs e) { string Isuse = ""; try { Isuse = Shove._Web.Utility.FilteSqlInfusion(tbIsuse.Text.Trim()); } catch { } if (Isuse == "") { Shove._Web.JavaScript.Alert(this.Page, "期号不能为空!"); return; } DataTable dt = new DAL.Tables.T_Isuses().Open("[ID]", "[Name]='" + Isuse + "' and LotteryID=" + Shove._Web.Utility.FilteSqlInfusion(tbLotteryID.Text) + " and [ID] <> " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), ""); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.Page.GetType().BaseType.FullName); return; } if (dt.Rows.Count > 0) { Shove._Web.JavaScript.Alert(this.Page, "期号已经存在,请不要输入重名期号!"); return; } System.DateTime StartTime, EndTime; object time = PF.ValidLotteryTime(tbStartTime.Text); if (time == null) { Shove._Web.JavaScript.Alert(this.Page, "开始时间格式输入错误!"); return; } StartTime = (DateTime)time; time = PF.ValidLotteryTime(tbEndTime.Text); if (time == null) { Shove._Web.JavaScript.Alert(this.Page, "截止时间格式输入错误!"); return; } EndTime = (DateTime)time; if (EndTime <= StartTime) { Shove._Web.JavaScript.Alert(this.Page, "截止时间应该在开始时间之后!"); return; } string AdditionasXml = ""; if ((tbLotteryID.Text == SLS.Lottery.SFC.sID || tbLotteryID.Text == SLS.Lottery.ZCSFC.sID || tbLotteryID.Text == SLS.Lottery.ZCRJC.sID) && (BuildAdditionasXmlForSFC(ref AdditionasXml) < 0)) { return; } if ((tbLotteryID.Text == SLS.Lottery.JQC.sID) && (BuildAdditionasXmlForJQC(ref AdditionasXml) < 0)) { return; } if ((tbLotteryID.Text == SLS.Lottery.LCBQC.sID) && (BuildAdditionasXmlForLCBQC(ref AdditionasXml) < 0)) { return; } if ((tbLotteryID.Text == SLS.Lottery.LCDC.sID) && (BuildAdditionasXmlForLCDC(ref AdditionasXml) < 0)) { return; } if ((tbLotteryID.Text == SLS.Lottery.ZCDC.sID) && (BuildAdditionasXmlForZCDC(ref AdditionasXml) < 0)) { return; } long IsuseID = long.Parse(tbIsuseID.Text); int ReturnValue = -1; string ReturnDescription = ""; int Result = DAL.Procedures.P_IsuseEdit(IsuseID, Isuse, StartTime, EndTime, AdditionasXml, ref ReturnValue, ref ReturnDescription); if (Result < 0) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.Page.GetType().BaseType.FullName); return; } if (ReturnValue < 0) { PF.GoError(ErrorNumber.Unknow, ReturnDescription, this.Page.GetType().BaseType.FullName); return; } if (tbTestNumber.Text.Trim() != "") { DAL.Tables.T_TestNumber t_TestNumber = new DAL.Tables.T_TestNumber(); t_TestNumber.TestNumber.Value = tbTestNumber.Text.Trim(); t_TestNumber.IsuseID.Value = IsuseID.ToString(); if (Shove._Convert.StrToLong(hidID.Value, 0) > 0) { t_TestNumber.Update("ID=" + hidID.Value); } else { t_TestNumber.Insert(); } } if (tbMoney.Text.Trim() != "") { DAL.Tables.T_TotalMoney t_TotalMoney = new DAL.Tables.T_TotalMoney(); t_TotalMoney.TotalMoney.Value = tbMoney.Text.Trim(); t_TotalMoney.IsuseID.Value = tbIsuseID.Text; if (Shove._Convert.StrToLong(moneyID.Value, 0) > 0) { t_TotalMoney.Update("ID=" + moneyID.Value); } else { t_TotalMoney.Insert(); } } Shove._Web.Cache.ClearCache(CacheKey.LotteryCalendar); Shove._Web.Cache.ClearCache(DataCache.IsusesInfo + tbLotteryID.Text.Trim()); this.Response.Redirect("Isuse.aspx?LotteryID=" + tbLotteryID.Text, true); }
private void BindData() { DataTable dt = new DAL.Tables.T_Isuses().Open("", "[ID]=" + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), ""); if ((dt == null) || (dt.Rows.Count < 1)) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.Page.GetType().BaseType.FullName); return; } tbIsuse.Text = dt.Rows[0]["Name"].ToString(); tbStartTime.Text = Shove._Convert.StrToDateTime(dt.Rows[0]["StartTime"].ToString(), "0000-00-00 00:00:00").ToString("yyyy-MM-dd HH:mm:ss"); tbEndTime.Text = Shove._Convert.StrToDateTime(dt.Rows[0]["EndTime"].ToString(), "0000-00-00 00:00:00").ToString("yyyy-MM-dd HH:mm:ss"); if (tbLotteryID.Text == SLS.Lottery.SFC.sID || tbLotteryID.Text == SLS.Lottery.ZCSFC.sID || tbLotteryID.Text == SLS.Lottery.ZCRJC.sID) { dt = new DAL.Tables.T_IsuseForSFC().Open("", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "[No]"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.Page.GetType().BaseType.FullName); return; } if (dt.Rows.Count != 14) { return; } for (int i = 0; i < 14; i++) { TextBox tb = (TextBox)this.FindControl("tbSFC" + (i + 1).ToString()); TextBox tb_1 = (TextBox)this.FindControl("tbSFC" + (i + 1).ToString() + "_1"); TextBox tb_2 = (TextBox)this.FindControl("tbSFC" + (i + 1).ToString() + "_2"); tb.Text = dt.Rows[i]["HostTeam"].ToString(); tb_1.Text = dt.Rows[i]["QuestTeam"].ToString(); tb_2.Text = dt.Rows[i]["DateTime"].ToString(); } } if (tbLotteryID.Text == SLS.Lottery.JQC.sID) { dt = new DAL.Tables.T_IsuseForJQC().Open("", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "[No]"); if ((dt == null) || (dt.Rows.Count < 8)) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.Page.GetType().BaseType.FullName); return; } for (int i = 0; i < 8; i++) { TextBox tb = (TextBox)this.FindControl("tbJQC" + (i + 1).ToString()); TextBox tb_2 = (TextBox)this.FindControl("tbJQC" + (i + 1).ToString() + "_2"); tb.Text = dt.Rows[i]["Team"].ToString(); tb_2.Text = dt.Rows[i]["DateTime"].ToString(); } } if (tbLotteryID.Text == SLS.Lottery.LCBQC.sID) { dt = new DAL.Tables.T_IsuseForLCBQC().Open("", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "[No]"); if ((dt == null) || (dt.Rows.Count < 6)) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.Page.GetType().BaseType.FullName); return; } for (int i = 0; i < 6; i++) { TextBox tb = (TextBox)this.FindControl("tbLCBQC" + (i + 1).ToString()); TextBox tb_1 = (TextBox)this.FindControl("tbLCBQC" + (i + 1).ToString() + "_1"); TextBox tb_2 = (TextBox)this.FindControl("tbLCBQC" + (i + 1).ToString() + "_2"); tb.Text = dt.Rows[i]["HostTeam"].ToString(); tb_1.Text = dt.Rows[i]["QuestTeam"].ToString(); tb_2.Text = dt.Rows[i]["DateTime"].ToString(); } } if (tbLotteryID.Text == SLS.Lottery.LCDC.sID) { dt = new DAL.Tables.T_IsuseForLCDC().Open("", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), "[No]"); if ((dt == null) || (dt.Rows.Count < 1)) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.Page.GetType().BaseType.FullName); return; } for (int i = 0; i < 1; i++) { TextBox tb = (TextBox)this.FindControl("tbLCDC" + (i + 1).ToString()); TextBox tb_1 = (TextBox)this.FindControl("tbLCDC" + (i + 1).ToString() + "_1"); TextBox tb_2 = (TextBox)this.FindControl("tbLCDC" + (i + 1).ToString() + "_2"); tb.Text = dt.Rows[i]["HostTeam"].ToString(); tb_1.Text = dt.Rows[i]["QuestTeam"].ToString(); tb_2.Text = dt.Rows[i]["DateTime"].ToString(); } } DataTable dtTestNumber = new DAL.Tables.T_TestNumber().Open("", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), ""); DataTable dtTotalMoney = new DAL.Tables.T_TotalMoney().Open("", "IsuseID= " + Shove._Web.Utility.FilteSqlInfusion(tbIsuseID.Text), ""); if (dtTestNumber == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.Page.GetType().BaseType.FullName); return; } if (dtTotalMoney == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.Page.GetType().BaseType.FullName); return; } if (dtTestNumber.Rows.Count > 0) { tbTestNumber.Text = dtTestNumber.Rows[0]["TestNumber"].ToString(); hidID.Value = dtTestNumber.Rows[0]["ID"].ToString(); } if (dtTotalMoney.Rows.Count > 0) { tbMoney.Text = dtTotalMoney.Rows[0]["TotalMoney"].ToString(); moneyID.Value = dtTotalMoney.Rows[0]["ID"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dtFc = BindNewWinNumber(6);//福彩3D if (dtFc.Rows.Count > 0 && dtFc != null) { lblFC3D.Text = dtFc.Rows[0]["Name"].ToString(); spFCWinNumber.InnerHtml = "<font class='redfont'>" + dtFc.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; DataTable dtTestNumber = new DAL.Tables.T_TestNumber().Open("", "IsuseID=" + dtFc.Rows[0]["ID"].ToString(), ""); if (dtTestNumber == null) { return; } if (dtTestNumber.Rows.Count > 0) { spFCTest.InnerHtml = dtTestNumber.Rows[0]["TestNumber"].ToString(); } } DataTable dtSSQ = BindNewWinNumber(5);//双色球 if (dtSSQ.Rows.Count > 0 && dtSSQ != null) { lbSSQ.Text = dtSSQ.Rows[0]["Name"].ToString(); spSSQWinNumber.InnerHtml = "<font class='redfont'>" + dtSSQ.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; } DataTable dtQLC = BindNewWinNumber(13);//七乐彩 if (dtQLC.Rows.Count > 0 && dtQLC != null) { lbQLC.Text = dtQLC.Rows[0]["Name"].ToString(); spQLCWinNumber.InnerHtml = "<font class='redfont'>" + dtQLC.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; } DataTable dtHNFC22X5 = BindNewWinNumber(69);//河南福彩22选5 if (dtHNFC22X5.Rows.Count > 0 && dtHNFC22X5 != null) { lbHNFC22X5.Text = dtHNFC22X5.Rows[0]["Name"].ToString(); spHNFC22X5WinNumber.InnerHtml = "<font class='redfont'>" + dtHNFC22X5.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; } DataTable dtTCDTL = BindNewWinNumber(39);//超级大透乐 if (dtTCDTL.Rows.Count > 0 && dtTCDTL != null) { lbTCDTL.Text = dtTCDTL.Rows[0]["Name"].ToString(); spTCDTLWinNumber.InnerHtml = "<font class='redfont'>" + dtTCDTL.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; } DataTable dtPL3 = BindNewWinNumber(63);//排列3 if (dtPL3.Rows.Count > 0 && dtPL3 != null) { lbPl3.Text = dtPL3.Rows[0]["Name"].ToString(); spPl3WinNumber.InnerHtml = "<font class='redfont'>" + dtPL3.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; } DataTable dtPL5 = BindNewWinNumber(64);//排列5 if (dtPL5.Rows.Count > 0 && dtPL5 != null) { lbPl5.Text = dtPL5.Rows[0]["Name"].ToString(); spPl5WinNumber.InnerHtml = "<font class='redfont'>" + dtPL5.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; } DataTable dtQxC = BindNewWinNumber(3);//七星彩 if (dtQxC.Rows.Count > 0 && dtQxC != null) { lbQxC.Text = dtQxC.Rows[0]["Name"].ToString(); spQxCWinNumber.InnerHtml = "<font class='redfont'>" + dtQxC.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; } DataTable dtTC22_5 = BindNewWinNumber(9);//体彩22选5 if (dtTC22_5.Rows.Count > 0 && dtTC22_5 != null) { lbTC22_5.Text = dtTC22_5.Rows[0]["Name"].ToString(); spTC22_5WinNumber.InnerHtml = "<font class='redfont'>" + dtTC22_5.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; } DataTable dtSFCRJ = BindNewWinNumber(74);//胜负彩(任九) if (dtSFCRJ.Rows.Count > 0 && dtSFCRJ != null) { lblSFCRJ.Text = dtSFCRJ.Rows[0]["Name"].ToString(); spSFCRJWinNumber.InnerHtml = "<font class='redfont'>" + dtSFCRJ.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; } DataTable dtLCBQC = BindNewWinNumber(15);//六场半全场 if (dtLCBQC.Rows.Count > 0 && dtLCBQC != null) { lblLCBQC.Text = dtLCBQC.Rows[0]["Name"].ToString(); spLCBQCWinNumber.InnerHtml = "<font class='redfont'>" + dtLCBQC.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; } DataTable dtSCJQC = BindNewWinNumber(2);//四场进球彩 if (dtSCJQC.Rows.Count > 0 && dtSCJQC != null) { lblSCJQC.Text = dtSCJQC.Rows[0]["Name"].ToString(); spSCJQC.InnerHtml = "<font class='redfont'>" + dtSCJQC.Rows[0]["WinLotteryNumber"].ToString() + "</font>"; } } }