/// <summary> /// 竞赛状态更新 /// </summary> /// <returns></returns> private bool updateTestStatus() { string mediaUrl = txtFile.Text; string usern = txtUserName.Text; string pass = txtPassword.Text; YYTestApi yyTestApi = (YYTestApi)XmlRpcProxyGen.Create(typeof(YYTestApi)); XmlRpcClientProtocol clientProtocol = (XmlRpcClientProtocol)yyTestApi; clientProtocol.Url = mediaUrl; Test[] tests = yyTestApi.getTestStatus(usern, pass); if (tests.Length > 0 && tests[0].isActive == 1) { setActiveTest(tests[0].id, true); cmbTest.Enabled = false; } else { setActiveTest(0, false); cmbTest.Enabled = true; } lblProgressInfor.Text = "竞赛状态更新成功!"; //MessageBox.Show("竞赛状态更新成功!"); return(false); }
/// <summary> /// 参赛者下载 /// </summary> /// <returns></returns> private bool downloadUser() { string mediaUrl = txtFile.Text; string usern = txtUserName.Text; string pass = txtPassword.Text; YYTestApi yyTestApi = (YYTestApi)XmlRpcProxyGen.Create(typeof(YYTestApi)); XmlRpcClientProtocol clientProtocol = (XmlRpcClientProtocol)yyTestApi; clientProtocol.Url = mediaUrl; UserInfo[] users = yyTestApi.getUsers(usern, pass); foreach (UserInfo user in users) { string userName = user.userName; string password = user.password; string birthday = "2016/01/01"; bool sex = true; string mail = user.mail; string tel = user.tel; string address = user.address; int userId = user.id; if (isUserExists(userId)) { string sql = "update [tbl_User] set " + "[UserName] ='" + userName + "'" + ",[Password]='" + password + "'" + ",[Birthday]=" + birthday + "" + ",[Sex]=" + sex + "" + ",[Mail]='" + mail + "'" + ",[Tel]='" + tel + "'" + ",[Address]='" + address + "'" + " where id=" + userId; db.ExeSQL(sql); } else { string sql = "insert into [tbl_User]([id],[UserName],[Password],[Birthday],[Sex],[Mail],[Tel],[Address],[IsAdmin]) values(" + "" + userId + "" + ",'" + userName + "'" + ",'" + password + "'" + "," + birthday + "" + "," + sex + "" + ",'" + mail + "'" + ",'" + tel + "'" + ",'" + address + "'" + ",False)"; db.ExeSQL(sql); } } lblProgressInfor.Text = "参赛者下载成功!"; //MessageBox.Show("参赛者下载成功!"); return(true); }
/// <summary> /// 结束竞赛 /// </summary> /// <returns></returns> private bool EndTest() { int testId = Convert.ToInt32(cmbTest.Text.ToString().Split(':')[0]); string mediaUrl = txtFile.Text; string usern = txtUserName.Text; string pass = txtPassword.Text; YYTestApi yyTestApi = (YYTestApi)XmlRpcProxyGen.Create(typeof(YYTestApi)); XmlRpcClientProtocol clientProtocol = (XmlRpcClientProtocol)yyTestApi; clientProtocol.Url = mediaUrl; return(yyTestApi.setEndTest(usern, pass, testId)); }
/// <summary> /// 参赛者成绩下载 /// </summary> /// <returns></returns> private bool downloadUserTestDetail() { string mediaUrl = txtFile.Text; string usern = txtUserName.Text; string pass = txtPassword.Text; YYTestApi yyTestApi = (YYTestApi)XmlRpcProxyGen.Create(typeof(YYTestApi)); XmlRpcClientProtocol clientProtocol = (XmlRpcClientProtocol)yyTestApi; clientProtocol.Url = mediaUrl; UserTestDetail[] userTestDetails = yyTestApi.getUserTestDetails(usern, pass); foreach (UserTestDetail userTestDetail in userTestDetails) { int id = userTestDetail.id; int userId = userTestDetail.userId; int testId = userTestDetail.testId; int questionId = userTestDetail.QuestionId; int questionType = userTestDetail.QuestionType; string Answer = userTestDetail.Answer; if (isUserTestDetailExists(id)) { string sql = "update [tbl_User_test_detail] set " + "[userId] =" + userId + "" + ",[testId]=" + testId + "" + ",[questionId]=" + questionId + "" + ",[questionType]=" + questionType + "" + ",[Answer]='" + Answer + "'" + " where id=" + id; db.ExeSQL(sql); } else { string sql = "insert into [tbl_User_test_detail]([userId],[testId],[questionId],[QuestionType],[Answer]) values(" + "" + userId + "" + "," + testId + "" + "," + questionId + "" + "," + questionType + "" + ",'" + Answer + "')"; db.ExeSQL(sql); } } lblProgressInfor.Text = "参赛者成绩下载成功!"; //MessageBox.Show("参赛者成绩下载成功!"); return(true); }
/// <summary> /// 试题上传 /// </summary> /// <returns></returns> private bool uploadQuestion() { string mediaUrl = txtFile.Text; string usern = txtUserName.Text; string pass = txtPassword.Text; string sql = "select * from tbl_Question_Single"; DataSet ds = db.ReturnDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { QuestionSingle[] questionSingles = new QuestionSingle[1]; YYTestApi yyTestApi = (YYTestApi)XmlRpcProxyGen.Create(typeof(YYTestApi)); XmlRpcClientProtocol clientProtocol = (XmlRpcClientProtocol)yyTestApi; clientProtocol.XmlEncoding = System.Text.Encoding.UTF8; clientProtocol.Url = mediaUrl; bool result = true; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { questionSingles[0] = new QuestionSingle(); questionSingles[0].id = Convert.ToInt32(ds.Tables[0].Rows[i]["id"]); questionSingles[0].Content = ds.Tables[0].Rows[i]["Content"].ToString(); questionSingles[0].SelectionA = ds.Tables[0].Rows[i]["SelectionA"].ToString(); questionSingles[0].SelectionB = ds.Tables[0].Rows[i]["SelectionB"].ToString(); questionSingles[0].SelectionC = ds.Tables[0].Rows[i]["SelectionC"].ToString(); questionSingles[0].SelectionD = ds.Tables[0].Rows[i]["SelectionD"].ToString(); questionSingles[0].Answer = ds.Tables[0].Rows[i]["Answer"].ToString(); questionSingles[0].Hardness = ds.Tables[0].Rows[i]["Hardness"].ToString(); questionSingles[0].Score = Convert.ToInt32(ds.Tables[0].Rows[i]["Score"]); result = result && yyTestApi.setQuestionSingles(usern, pass, questionSingles); } if (!result) { lblProgressInfor.Text = "试题上传失败!"; //MessageBox.Show("试题上传失败!"); } else { lblProgressInfor.Text = "试题上传成功!"; //MessageBox.Show("试题上传成功!"); } } return(true); }
/// <summary> /// 参赛者排名信息下载 /// </summary> /// <returns></returns> private bool downloadUserTest() { string mediaUrl = txtFile.Text; string usern = txtUserName.Text; string pass = txtPassword.Text; YYTestApi yyTestApi = (YYTestApi)XmlRpcProxyGen.Create(typeof(YYTestApi)); XmlRpcClientProtocol clientProtocol = (XmlRpcClientProtocol)yyTestApi; clientProtocol.Url = mediaUrl; UserTest_[] userTests = yyTestApi.getUserTests(usern, pass); foreach (UserTest_ userTest in userTests) { int id = userTest.id; int userId = userTest.userId; int testId = userTest.testId; int score = userTest.Score; int rank = userTest.Rank; if (isUserTestExists(id)) { string sql = "update [tbl_User_test] set " + "[userId] =" + userId + "" + ",[testId]=" + testId + "" + ",[score]=" + score + "" + ",[rank]=" + rank + "" + " where id=" + id; db.ExeSQL(sql); } else { string sql = "insert into [tbl_User_test]([userId],[testId],[score],[rank]) values(" + "" + userId + "" + "," + testId + "" + "," + score + "" + "," + rank + ")"; db.ExeSQL(sql); } } lblProgressInfor.Text = "赛者排名信息下载成功!"; //MessageBox.Show("赛者排名信息下载成功!"); return(true); }
/// <summary> /// 竞赛上传 /// </summary> /// <returns></returns> private bool uploadTest() { string mediaUrl = txtFile.Text; string usern = txtUserName.Text; string pass = txtPassword.Text; string sql = "select * from tbl_Test"; DataSet ds = db.ReturnDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { Test[] tests = new Test[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { tests[i] = new Test(); tests[i].id = Convert.ToInt32(ds.Tables[0].Rows[i]["id"]); tests[i].testName = ds.Tables[0].Rows[i]["testName"].ToString(); tests[i].userId = Convert.ToInt32(ds.Tables[0].Rows[i]["userId"]); tests[i].testDate = ds.Tables[0].Rows[i]["testDate"].ToString(); tests[i].testAddress = ds.Tables[0].Rows[i]["testAddress"].ToString(); tests[i].Bidati = Convert.ToInt32(ds.Tables[0].Rows[i]["Bidati"]); tests[i].Qiangdati = Convert.ToInt32(ds.Tables[0].Rows[i]["Qiangdati"]); tests[i].isActive = Convert.ToInt32(ds.Tables[0].Rows[i]["isActive"]); } YYTestApi yyTestApi = (YYTestApi)XmlRpcProxyGen.Create(typeof(YYTestApi)); XmlRpcClientProtocol clientProtocol = (XmlRpcClientProtocol)yyTestApi; clientProtocol.XmlEncoding = System.Text.Encoding.UTF8; clientProtocol.Url = mediaUrl; bool result = yyTestApi.setTests(usern, pass, tests); if (!result) { lblProgressInfor.Text = "竞赛上传失败!"; //MessageBox.Show("竞赛上传失败!"); } else { lblProgressInfor.Text = "竞赛上传成功!"; //MessageBox.Show("竞赛上传成功!"); } } return(true); }
/// <summary> /// 用户上传 /// </summary> /// <returns></returns> private bool uploadUsers() { string mediaUrl = txtFile.Text; string usern = txtUserName.Text; string pass = txtPassword.Text; string sql = "select * from tbl_User where id>1"; DataSet ds = db.ReturnDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { UserInfo[] users = new UserInfo[1]; YYTestApi yyTestApi = (YYTestApi)XmlRpcProxyGen.Create(typeof(YYTestApi)); XmlRpcClientProtocol clientProtocol = (XmlRpcClientProtocol)yyTestApi; clientProtocol.XmlEncoding = System.Text.Encoding.UTF8; clientProtocol.Url = mediaUrl; bool result = true; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { users[0] = new UserInfo(); users[0].id = Convert.ToInt32(ds.Tables[0].Rows[i]["id"]); users[0].userName = ds.Tables[0].Rows[i]["userName"].ToString(); users[0].password = ds.Tables[0].Rows[i]["password"].ToString(); users[0].mail = ds.Tables[0].Rows[i]["mail"].ToString(); users[0].tel = ds.Tables[0].Rows[i]["tel"].ToString(); users[0].address = ds.Tables[0].Rows[i]["address"].ToString(); result = result && yyTestApi.setUsers(usern, pass, users); } if (!result) { lblProgressInfor.Text = "用户上传失败!"; } else { lblProgressInfor.Text = "用户上传成功!"; } } return(true); }
/// <summary> /// 竞赛详细上传 /// </summary> /// <returns></returns> private bool uploadTestDetail() { string mediaUrl = txtFile.Text; string usern = txtUserName.Text; string pass = txtPassword.Text; string sql = "select * from tbl_Test_Detail"; DataSet ds = db.ReturnDataSet(sql); if (ds.Tables[0].Rows.Count > 0) { TestDetail[] testDetails = new TestDetail[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { testDetails[i] = new TestDetail(); testDetails[i].id = Convert.ToInt32(ds.Tables[0].Rows[i]["id"]); testDetails[i].testId = Convert.ToInt32(ds.Tables[0].Rows[i]["testId"]); testDetails[i].questionId = Convert.ToInt32(ds.Tables[0].Rows[i]["questionId"]); testDetails[i].questionType = Convert.ToInt32(ds.Tables[0].Rows[i]["questionType"]); } YYTestApi yyTestApi = (YYTestApi)XmlRpcProxyGen.Create(typeof(YYTestApi)); XmlRpcClientProtocol clientProtocol = (XmlRpcClientProtocol)yyTestApi; clientProtocol.Url = mediaUrl; bool result = yyTestApi.setTestDetails(usern, pass, testDetails); if (!result) { lblProgressInfor.Text = "竞赛详细上传失败!"; //MessageBox.Show("竞赛详细上传失败!"); } else { lblProgressInfor.Text = "竞赛详细上传成功!"; //MessageBox.Show("竞赛详细上传成功!"); } } return(true); }
/// <summary> /// 通知 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnInfor_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtInfor.Text)) { MessageBox.Show("请输入通知内容!"); return; } string mediaUrl = txtFile.Text; string usern = txtUserName.Text; string pass = txtPassword.Text; YYTestApi yyTestApi = (YYTestApi)XmlRpcProxyGen.Create(typeof(YYTestApi)); XmlRpcClientProtocol clientProtocol = (XmlRpcClientProtocol)yyTestApi; clientProtocol.Url = mediaUrl; if (yyTestApi.setInfor(usern, pass, txtInfor.Text)) { MessageBox.Show("通知更新成功!"); } else { MessageBox.Show("通知更新失败!"); } }