private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "") { MessageBox.Show("用户名或密码为空!"); } else { string username = textBox1.Text.Replace("-", "").Trim(); string pwd = textBox2.Text.Replace("-", "").Trim(); string sqlstr = string.Format("SELECT count(Id) FROM AI_listenUser WHERE UserName='******' AND Pwd='{1}'", username, pwd); //int a =SQLHelper.GetSingleResult(sqlstr); int a = Convert.ToInt32(MySqlHelper.ExecuteScalar(CommandType.Text, sqlstr)); if (a > 0) { string sqlstr1 = string.Format("SELECT * FROM AI_listenUser WHERE UserName='******' AND Pwd='{1}'", username, pwd); DataSet dataset = MySqlHelper.GetDataSet(CommandType.Text, sqlstr1); AI_listenUser lu1 = dataset.Tables[0].ToModels <AI_listenUser>().First(); session.listenuser = lu1; session.user = username; this.DialogResult = DialogResult.OK; } else { MessageBox.Show("账号密码错误!!!"); } } }
private void query_combo(object sender, EventArgs e) { session.batchno = Convert.ToInt32(cbopici.SelectedValue); var quesnolist = MySqlHelper.GetDataSet(CommandType.Text, string.Format("SELECT itemno FROM AI_listenScore WHERE batchno={0} and validflag='2' GROUP BY itemno ORDER BY itemno", session.batchno)).Tables[0]; cboitemno.DataSource = quesnolist; cboitemno.DisplayMember = "itemno"; querydata(); }
private void refreshgui() { var batchlist = MySqlHelper.GetDataSet(CommandType.Text, "SELECT batchno,batchdesc FROM AI_listenScore where validflag='2' GROUP BY batchno,batchdesc ORDER BY batchno").Tables[0]; cbopici.DataSource = batchlist; cbopici.DisplayMember = "batchdesc"; cbopici.ValueMember = "batchno"; session.batchno = Convert.ToInt32(cbopici.SelectedValue); cbopici.SelectedValueChanged += query_combo; var quesnolist = MySqlHelper.GetDataSet(CommandType.Text, string.Format("SELECT itemno FROM AI_listenScore WHERE batchno={0} and validflag='2' GROUP BY itemno ORDER BY itemno", session.batchno)).Tables[0]; comboBox1.DisplayMember = "papercode"; cboitemno.DataSource = quesnolist; cboitemno.DisplayMember = "itemno"; querydata(); }
private void getonedata() { try { string sqlstr = string.Format("SELECT * FROM AI_listenScore WHERE itemno='{1}' and validflag='2' AND Statu='0' and batchno={0} order by papercode,itemno limit 1", Convert.ToInt32(cbopici.SelectedValue), cboitemno.Text.Trim()); List <AI_listenScore> singlerecord1 = MySqlHelper.GetDataSet(CommandType.Text, sqlstr).Tables[0].ToModels <AI_listenScore>(); AI_listenScore singlerecord = MySqlHelper.GetDataSet(CommandType.Text, sqlstr).Tables[0].ToModels <AI_listenScore>().First(); session.listenScore = singlerecord; string sql_upd = string.Format("UPDATE AI_listenScore SET statu='9',listenDT=now(),listener='{1}' WHERE Id={0}", singlerecord.Id, session.listenuser.UserName); MySqlHelper.ExecuteScalar(CommandType.Text, sql_upd); label8.Text = singlerecord.papercode; label9.Text = singlerecord.itemno; label14.Text = singlerecord.Score1; label15.Text = singlerecord.Score2; setbtn(); voice_path = session.filead + singlerecord.filename; Id = singlerecord.Id; button2.Text = string.Format("试卷号:{0} | 题目号:{1}", singlerecord.papercode, singlerecord.itemno); if (voice_path != "") { awmp.URL = voice_path; awmp.Ctlcontrols.play(); } querydata(); try { string sqltxt = string.Format("SELECT t1.itemno,t2.papercode,t1.itemtext,t1.answertext,t1.modeltext FROM AI_item t1, AI_paper t2 WHERE t1.itemno='{0}' AND t2.papercode='{1}' AND t1.paperid=t2.paperid", session.listenScore.itemno, session.listenScore.papercode); item item1 = MySqlHelper.GetDataSet(CommandType.Text, sqltxt).Tables[0].ToModels <item>().First(); textBox1.Text = item1.itemtext; textBox2.Text = item1.answertext; } catch (Exception) { MessageBox.Show("取不到题目对应信息!!!"); } session.taskIdlist.Add(Id); } catch (Exception) { MessageBox.Show("取不到题目了!!"); } }
//public static string IP = SQLHelper.config.AppSettings.Settings["IP"].Value; private void Form1_Load(object sender, EventArgs e) { string Version = Assembly.GetExecutingAssembly().GetName().Version.ToString(); this.Text = this.Text + " v" + Version; var batchlist = MySqlHelper.GetDataSet(CommandType.Text, "SELECT batchno,batchdesc FROM AI_listenScore where validflag='2' GROUP BY batchno,batchdesc ORDER BY batchno").Tables[0]; cbopici.DataSource = batchlist; cbopici.DisplayMember = "batchdesc"; cbopici.ValueMember = "batchno"; session.batchno = Convert.ToInt32(cbopici.SelectedValue); cbopici.SelectedValueChanged += query_combo; var quesnolist = MySqlHelper.GetDataSet(CommandType.Text, string.Format("SELECT itemno FROM AI_listenScore WHERE batchno={0} and validflag='2' GROUP BY itemno ORDER BY itemno", session.batchno)).Tables[0]; cboitemno.DataSource = quesnolist; cboitemno.DisplayMember = "itemno"; querydata(); cboitemno.SelectedValueChanged += query_data; button2.Enabled = false; awmp.BeginInit(); this.Controls.Add(awmp); awmp.uiMode = "Full"; awmp.EndInit(); if (session.listenuser.type != "1") { tsmi_data.Enabled = false; } timer1.Interval = 100; timer1.Tick += Timer1_Tick; timer1.Start(); progressBar1.MouseClick += ProgressBar1_Click; label14.MouseClick += Label_MouseClick; label15.MouseClick += Label_MouseClick; cbopici.SelectedValueChanged += Cbopici_SelectedValueChanged; setbtn(cbopici.Text, 1); }
private void tsmijdxq_Click(object sender, EventArgs e) { List <AI_listenScore> pcjd = MySqlHelper.GetDataSet(CommandType.Text, string.Format("select * from AI_listenScore where validflag='2'")).Tables[0].ToModels <AI_listenScore>(); var pcjdlist = pcjd.GroupBy(a => a.batchdesc).Select(b => new { b.First().batchdesc, totalcount = b.Count(), ycount = b.Where(c => c.Statu == "9").Count(), wcount = b.Where(c => c.Statu == "0").Count() }); }