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() });
}