protected void Button6_Click(object sender, EventArgs e)
{
SateInfo sateInfo = new SateInfo();
int qw = BLL.UserMessage.SelectSate();
if (qw == 0)
{
string dt = GetNetDateTime();
sateInfo.SateDate = Convert.ToDateTime(dt).ToString("yyyy-MM-dd HH:mm:ss");
sateInfo.SateBgin = Convert.ToDateTime(dt).ToString("yyyy-MM-dd HH:mm:ss");
sateInfo.SateEnd = "";
sateInfo.SateRmarks = "";
sateInfo.SateState = 1;
if (BLL.UserMessage.UPdateSate(sateInfo) == 1)
{
Button6.Text = "结束";
}
}
if (qw == 1)
{
string dt = GetNetDateTime();
sateInfo.SateDate = Convert.ToDateTime(dt).ToString("yyyy-MM-dd HH:mm:ss");
sateInfo.SateEnd = Convert.ToDateTime(dt).ToString("yyyy-MM-dd HH:mm:ss");
sateInfo.SateBgin = "";
sateInfo.SateRmarks = "";
sateInfo.SateState = 0;
if (BLL.UserMessage.UPdateSate(sateInfo) == 1)
{
Button6.Text = "开始";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SateInfo sateInfo = new SateInfo();
int qw = BLL.UserMessage.SelectSate();
if (qw == 0)
{
Button6.Text = "开始";
}
if (qw == 1)
{
Button6.Text = "结束";
}
}
/// <summary>
/// 修改开奖状态
/// </summary>
/// <param name="invitelInfo"></param>
/// <returns></returns>
public static int UPdateSate(SateInfo sateInfo)
{
string sqltext = "insert into SateInfo(SateDate,SateBgin,SateEnd,SateState,SateRmarks) values(@SateDate,@SateBgin,@SateEnd,@SateState,@SateRmarks)";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@SateDate", sateInfo.SateDate),
new SqlParameter("@SateBgin", sateInfo.SateBgin),
new SqlParameter("@SateEnd", sateInfo.SateEnd),
new SqlParameter("@SateState", sateInfo.SateState),
new SqlParameter("@SateRmarks", sateInfo.SateRmarks)
};
return((int)SqlHelper.ExecuteNonQuery(connection, CommandType.Text, sqltext, para));
}
/// <summary>
/// 彩票开关
/// </summary>
private void StutsForLottery()
{
SateInfo sateInfo = new SateInfo();
int qw = BLL.UserMessage.SelectSate();
if (qw == 0)
{
this.status.Text = "关闭";
Button6.Text = "开启";
}
if (qw == 1)
{
this.status.Text = "开启";
Button6.Text = "关闭";
}
}
public static int UPdateSate(SateInfo sateInfo)
{
return(DAL.UserServer.UPdateSate(sateInfo));
}
