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>";
}
}
}
