17,740
社区成员
发帖
与我相关
我的任务
分享
Create function getResult(@ID int,@honghao varchar(50),@lanhao varchar(5))
Returns nvarchar(50)
As
Begin
declare @res varchar(20)
declare @H int
declare @L int
declare @jifen int
declare @UserName varchar(20)
select @UserName=UserName,
@H=
case when charindex(Hong1,@honghao)>0 then 1 else 0 end +
case when charindex(Hong2,@honghao)>0 then 1 else 0 end +
case when charindex(Hong3,@honghao)>0 then 1 else 0 end +
case when charindex(Hong4,@honghao)>0 then 1 else 0 end +
case when charindex(Hong5,@honghao)>0 then 1 else 0 end,
@L=case when Lanqiu=@lanhao then 1 else 0 end from TableName
where ID=@ID
set @res=Convert(nvarchar(2),@H)+'+'+Convert(nvarchar(2),@L)
if(@res='0+1' or @res='1+1' or @res='2+1')
set @jifen=5;
if(@res='4+0' or @res='3+1')
set @jifen=20
if(@res='4+1' or @res='5+0')
set @jifen=100
if(@res='5+1')
set @jifen=300
if(@res='6+0')
set @jifen=500
if(@res='6+1')
set @jifen=1000
Return @res+'积分:'+isNull(convert(varchar(5),@jifen),0)
End
select *,dbo.getResult(ID,'02,11,20,22,24,30','05') as res from tableName
Random rd = new Random();
ArrayList a1 = new ArrayList();
private void button1_Click(object sender, EventArgs e)
{
this.textBox7.Text = rd.Next(1, 16).ToString();
this.textBox14.Text = rd.Next(1, 16).ToString();
this.textBox21.Text = rd.Next(1, 16).ToString();
this.textBox28.Text = rd.Next(1, 16).ToString();
this.textBox35.Text = rd.Next(1, 16).ToString();
while (1 == 1)
{
int f1 = rd.Next(1, 34);
int e1 = rd.Next(1, 34);
int d1 = rd.Next(1, 34);
int c1 = rd.Next(1, 34);
int a1 = rd.Next(1, 34);
int b1 = rd.Next(1, 34);
if (a1 != b1)
{
if ((a1 != c1) && (b1 != c1))
{
if ((d1 != a1) && (d1 != b1) && (d1 != c1))
{
if ((e1 != a1) && (e1 != b1) && (e1 != c1) && (e1 != d1))
{
if ((f1 != a1) && (f1 != b1) && (f1 != c1) && (f1 != d1) && (f1 != e1))
{
int[] z = new int[6];
z[0] = a1;
z[1] = b1;
z[2] = c1;
z[3] = d1;
z[4] = e1;
z[5] = f1;
int i, j, temp;
for (i = 0; i < 6; i++)
{
for (j = 5; j > i; j--)
{
if (z[j] < z[j - 1])
{
temp = 0;
temp = z[j];
z[j] = z[j - 1];
z[j - 1] = temp;
}
}
}
this.textBox1.Text = z[0].ToString();
this.textBox2.Text = z[1].ToString();
this.textBox3.Text = z[2].ToString();
this.textBox4.Text = z[3].ToString();
this.textBox5.Text = z[4].ToString();
this.textBox6.Text = z[5].ToString();
break;
}
}
}
}
}
}
private void RandomOK()
{
List<int> list = GenerateNumber1();
int i = 0;
while (i < list.Count)
{
//如果直接一个控件显示的话,就使用这句代码叠加
//temp += list[i].ToString() + "\n";
i++;
}
//this.Lable1.Text=temp;
if (list[0] < 10)
{
this.TextBox1.Text = "0" + list[0].ToString();
}
else
{
this.TextBox1.Text = list[0].ToString();
}
if (list[1] < 10)
{
this.TextBox2.Text = "0" + list[1].ToString();
}
else
{
this.TextBox2.Text = list[1].ToString();
}
if (list[2] < 10)
{
this.TextBox3.Text = "0" + list[2].ToString();
}
else
{
this.TextBox3.Text = list[2].ToString();
}
if (list[3] < 10)
{
this.TextBox4.Text = "0" + list[3].ToString();
}
else
{
this.TextBox4.Text = list[3].ToString();
}
if (list[4] < 10)
{
this.TextBox5.Text = "0" + list[4].ToString();
}
else
{
this.TextBox5.Text = list[4].ToString();
}
if (list[5] < 10)
{
this.TextBox6.Text = "0" + list[5].ToString();
}
else
{
this.TextBox6.Text = list[5].ToString();
}
int blueBall = GetBlueBall();
if (blueBall < 10)
{
this.TextBox7.Text = ("0" + blueBall).ToString();
}
else
{
this.TextBox7.Text = blueBall.ToString();
}
}
//获取篮球随机号1-16中随机一个数字
private int GetBlueBall()
{
Random rand = new Random();
return rand.Next(1, 17);
}
protected void btnClear_Click(object sender, EventArgs e)
{
//首先清空checkboxList
clearAllBall();
//然后清空textbox
this.TextBox1.Text = null;
this.TextBox2.Text = null;
this.TextBox3.Text = null;
this.TextBox4.Text = null;
this.TextBox5.Text = null;
this.TextBox6.Text = null;
this.TextBox7.Text = null;
count = 0;
}
protected void cblBlueBall_SelectedIndexChanged(object sender, EventArgs e)
{
SelectBlueBallIndexChanged();
}
private int count
{
get { return (int)ViewState["count"]; }
set { ViewState["count"] = value; }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
count = 0;
}
}
/// <summary>
///
/// </summary>功能四
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnCompare_Click(object sender, EventArgs e)
{
//第四个问题
}
/// <summary>
///功能三
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnRandom_Click(object sender, EventArgs e)
{
//首先作第一次清除
clearAllBall();
//调用随机数方法
RandomOK();
//调用选中红球时方法
ShowRedBall();
//调用选中篮球时方法
ShowBlueBall();
count = 6;
}
//当机选的时候,checkboxlist显示机选红球的值
private void ShowRedBall()
{
string[] red = new string[] { this.TextBox1.Text, this.TextBox2.Text, this.TextBox3.Text, this.TextBox4.Text, this.TextBox5.Text, this.TextBox6.Text };
for (int i = 0; i < red.Length; i++)
{
foreach (ListItem li in this.cblRedBall.Items)
{
if (red[i].Contains(li.Value))
{
li.Selected = true;
}
}
}
}
////当机选的时候,checkboxlist显示机选篮球的值
private void ShowBlueBall()
{
string blue = this.TextBox7.Text;
foreach (ListItem li in this.cblBlueBall.Items)
{
if (blue.Contains(li.Value))
{
li.Selected = true;
}
}
}
//清空当前选中的值
private void clearAllBall()
{
cblBlueBall.ClearSelection();
cblRedBall.ClearSelection();
}
/// <summary>
/// 功能二
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void cblRedBall_SelectedIndexChanged(object sender, EventArgs e)
{
SelectRedBallIndexChanged();
}
//用户点击红球选中与取消
private void SelectRedBallIndexChanged()
{
for (int i = 0; i < cblRedBall.Items.Count; i++)
{
if (count <= 6)
{
if (cblRedBall.Items[i].Selected)
{
if (string.IsNullOrEmpty(this.TextBox1.Text) && cblRedBall.Items[i].Value != TextBox3.Text && cblRedBall.Items[i].Value != TextBox2.Text && cblRedBall.Items[i].Value != TextBox4.Text && cblRedBall.Items[i].Value != TextBox5.Text && cblRedBall.Items[i].Value != TextBox6.Text)
{
this.TextBox1.Text = cblRedBall.Items[i].Value;
count++;
}
else if (string.IsNullOrEmpty(this.TextBox2.Text) && cblRedBall.Items[i].Value != TextBox1.Text && cblRedBall.Items[i].Value != TextBox3.Text && cblRedBall.Items[i].Value != TextBox4.Text && cblRedBall.Items[i].Value != TextBox5.Text && cblRedBall.Items[i].Value != TextBox6.Text)
{
this.TextBox2.Text = cblRedBall.Items[i].Value;
count++;
}
else if (string.IsNullOrEmpty(this.TextBox3.Text) && cblRedBall.Items[i].Value != TextBox1.Text && cblRedBall.Items[i].Value != TextBox2.Text && cblRedBall.Items[i].Value != TextBox4.Text && cblRedBall.Items[i].Value != TextBox5.Text && cblRedBall.Items[i].Value != TextBox6.Text)
{
this.TextBox3.Text = cblRedBall.Items[i].Value;
count++;
}
else if (string.IsNullOrEmpty(this.TextBox4.Text) && cblRedBall.Items[i].Value != TextBox1.Text && cblRedBall.Items[i].Value != TextBox2.Text && cblRedBall.Items[i].Value != TextBox3.Text && cblRedBall.Items[i].Value != TextBox5.Text && cblRedBall.Items[i].Value != TextBox6.Text)
{
this.TextBox4.Text = cblRedBall.Items[i].Value;
count++;
}
else if (string.IsNullOrEmpty(this.TextBox5.Text) && cblRedBall.Items[i].Value != TextBox1.Text && cblRedBall.Items[i].Value != TextBox2.Text && cblRedBall.Items[i].Value != TextBox3.Text && cblRedBall.Items[i].Value != TextBox4.Text && cblRedBall.Items[i].Value != TextBox6.Text)
{
this.TextBox5.Text = cblRedBall.Items[i].Value;
count++;
}
else if (string.IsNullOrEmpty(this.TextBox6.Text) && cblRedBall.Items[i].Value != TextBox1.Text && cblRedBall.Items[i].Value != TextBox2.Text && cblRedBall.Items[i].Value != TextBox3.Text && cblRedBall.Items[i].Value != TextBox4.Text && cblRedBall.Items[i].Value != TextBox5.Text)
{
this.TextBox6.Text = cblRedBall.Items[i].Value;
count++;
}
}
else
{
//是否在这里面写呢?问题:去掉一个checkboxlist选框,对应在文本框中的数字也不显示
if (this.cblRedBall.Items[i].Value == this.TextBox1.Text && cblRedBall.Items[i].Value != TextBox3.Text && cblRedBall.Items[i].Value != TextBox2.Text && cblRedBall.Items[i].Value != TextBox4.Text && cblRedBall.Items[i].Value != TextBox5.Text && cblRedBall.Items[i].Value != TextBox6.Text)
{
this.TextBox1.Text = "";
count--;
}
else if (this.cblRedBall.Items[i].Value == this.TextBox2.Text && cblRedBall.Items[i].Value != TextBox1.Text && cblRedBall.Items[i].Value != TextBox3.Text && cblRedBall.Items[i].Value != TextBox4.Text && cblRedBall.Items[i].Value != TextBox5.Text && cblRedBall.Items[i].Value != TextBox6.Text)
{
this.TextBox2.Text = "";
count--;
}
else if (this.cblRedBall.Items[i].Value == this.TextBox3.Text && cblRedBall.Items[i].Value != TextBox1.Text && cblRedBall.Items[i].Value != TextBox2.Text && cblRedBall.Items[i].Value != TextBox4.Text && cblRedBall.Items[i].Value != TextBox5.Text && cblRedBall.Items[i].Value != TextBox6.Text)
{
this.TextBox3.Text = "";
count--;
}
else if (this.cblRedBall.Items[i].Value == this.TextBox4.Text && cblRedBall.Items[i].Value != TextBox1.Text && cblRedBall.Items[i].Value != TextBox2.Text && cblRedBall.Items[i].Value != TextBox3.Text && cblRedBall.Items[i].Value != TextBox5.Text && cblRedBall.Items[i].Value != TextBox6.Text)
{
this.TextBox4.Text = "";
count--;
}
else if (this.cblRedBall.Items[i].Value == this.TextBox5.Text && cblRedBall.Items[i].Value != TextBox1.Text && cblRedBall.Items[i].Value != TextBox2.Text && cblRedBall.Items[i].Value != TextBox3.Text && cblRedBall.Items[i].Value != TextBox4.Text && cblRedBall.Items[i].Value != TextBox6.Text)
{
this.TextBox5.Text = "";
count--;
}
else if (this.cblRedBall.Items[i].Value == this.TextBox6.Text && cblRedBall.Items[i].Value != TextBox1.Text && cblRedBall.Items[i].Value != TextBox2.Text && cblRedBall.Items[i].Value != TextBox3.Text && cblRedBall.Items[i].Value != TextBox4.Text && cblRedBall.Items[i].Value != TextBox5.Text)
{
this.TextBox6.Text = "";
count--;
}
}
}
else
{
Response.Write("<script>alert('不能超过6个数字!');</script>");
//cblRedBall.Items[i].Selected = false;
break;
}
//if (count != 0)
//{
// break;
//}
}
Label1.Text = "";
}
//用户点击篮球时选中与取消
private void SelectBlueBallIndexChanged()
{
int count = 0;
for (int i = 0; i < this.cblBlueBall.Items.Count; i++)
{
if (count < 2)
{
if (this.cblBlueBall.Items[i].Selected == true)
{
if (count == 0)
{
this.TextBox7.Text = this.cblBlueBall.Items[i].Value;
}
count++;
}
else
{
if (this.cblBlueBall.Items[i].Value == this.TextBox7.Text)
{
this.TextBox7.Text = "";
}
}
}
else
{
Response.Write("<script>alert('不能超过2个数字!');</script>");
break;
}
}
}
//红球1-33个数字中选择不重复的6个数字
public List<int> GenerateNumber1()
{
//用于保存返回的结果
List<int> result = new List<int>(6);
Random random = new Random();
int temp = 0;
//如果返回的结果集合中实际的元素个数小于6个
while (result.Count < 6)
{
//在[1,34)区间任意取一个随机整数
temp = random.Next(1, 34);
if (!result.Contains(temp))
{
//如果在结果集合中不存在这个数,则添加这个数
result.Add(temp);
}
}
//对返回结果进行排序
result.Sort();
return result;
}
protected void cblRedBall_SelectedIndexChanged(object sender, EventArgs e)
{
for (int i = 0; i < this.cblRedBall.Items.Count; i++)
{
if (this.cblRedBall.Items[i].Selected == true)
{
//这里面应该怎么写,才可以让选择的红球在下面的框中显示??
//点击第七个红球的时候没反应,最多六个
}
else
{
this.TextBox1.Text = null;
this.TextBox2.Text = null;
this.TextBox3.Text = null;
this.TextBox4.Text = null;
this.TextBox5.Text = null;
this.TextBox6.Text = null;
}
}
}
$("input:checkbox[@name='checkboxName']").each(function(i){
$(this).click(function(){
if($("input:checkbox[@name='checkboxName']:checked").length >0)
return;
});
});