public bool Update_AnswerList(Class_AnswerList class_answerList) { if (class_answerList == null) return false; String Sql = ""; Sql += "Update AnswerList Set QuestionSelect_ID = " + class_answerList.QuestionSelect_ID.ToString() + " Where AnswerInfo_ID = " + class_answerList.AnswerInfo_ID.ToString() + " and QuestionList_ID = " + class_answerList.QuestionList_ID.ToString(); OleDbDataAdapter oleDb = new OleDbDataAdapter(Sql, DBConnection.AccessConnection); DataTable dt = new DataTable(); oleDb.Fill(dt); return true; }
public bool Insert_AnswerList(Class_AnswerList class_answerList) { if (class_answerList == null) return false; String Sql = ""; Sql += "Insert Into AnswerList(AnswerInfo_ID,QuestionList_ID,QuestionSelect_ID) Values(" + class_answerList.AnswerInfo_ID.ToString() + "," + class_answerList.QuestionList_ID.ToString() + "," + class_answerList.QuestionSelect_ID.ToString() + ")"; OleDbDataAdapter oleDb = new OleDbDataAdapter(Sql, DBConnection.AccessConnection); DataTable dt = new DataTable(); oleDb.Fill(dt); return true; }
private void Save_Test(int SaveTest) { if (QuestionList_TotalPage > 0) { Hashtable list_answerInfo_Score = new Hashtable(); Hashtable list_answerInfo_Text = new Hashtable(); Panel panel; Control[] panel_controls; //保存 if (SaveTest == 0) { bool Is_Save = false; if (AnswerInfo_ID > 0) Is_Save = true; String Question_Tail = ""; Function_AnswerInfo function_answerInfo = new Function_AnswerInfo(); if (!Is_Save) AnswerInfo_ID = function_answerInfo.Query_AnswerInfo_ID(); for (int i = 1; i <= QuestionList_TotalPage; i++) { panel_controls = Controls.Find("Panel_QuestionList" + i.ToString(), false); if (panel_controls == null || panel_controls.Length == 0) return; if (panel_controls[0] is Panel) panel = (Panel)panel_controls[0]; else return; foreach (Control control_questionList in panel.Controls) { if (control_questionList is Control_QuestionList) { int QuestionList_ListID = (control_questionList as Control_QuestionList).QuestionList_ListID; int QuestionSelect_Score = (control_questionList as Control_QuestionList).QuestionSelect_Score; String QuestionSelect_Text = (control_questionList as Control_QuestionList).QuestionSelect_Text; TextBox TextBox_QuestionList = (control_questionList as Control_QuestionList).TextBox_QuestionList; if (QuestionSelect_Score != -1) { list_answerInfo_Score.Add(QuestionList_ListID, QuestionSelect_Score); list_answerInfo_Text.Add(QuestionList_ListID, QuestionSelect_Text); } if (TextBox_QuestionList != null) { if (TextBox_QuestionList.Name == "ClientInfo_Weight") { if (!String.IsNullOrEmpty(TextBox_QuestionList.Text)) { if (class_clientInfo != null && CommonFunction.IsNumber(TextBox_QuestionList.Text, 2)) class_clientInfo.ClientInfo_Weight = Convert.ToSingle(TextBox_QuestionList.Text); Function_ClientInfo function_clientInfo = new Function_ClientInfo(); function_clientInfo.Update_ClientInfo(class_clientInfo); } } if (TextBox_QuestionList.Name == "ClientInfo_Height") { if (!String.IsNullOrEmpty(TextBox_QuestionList.Text)) { if (class_clientInfo != null && CommonFunction.IsNumber(TextBox_QuestionList.Text, 2)) class_clientInfo.ClientInfo_Height = Convert.ToSingle(TextBox_QuestionList.Text); Function_ClientInfo function_clientInfo = new Function_ClientInfo(); function_clientInfo.Update_ClientInfo(class_clientInfo); } } } Class_AnswerList class_answerList = new Class_AnswerList(); class_answerList.AnswerInfo_ID = AnswerInfo_ID; class_answerList.QuestionList_ID = (control_questionList as Control_QuestionList).QuestionList_ID; class_answerList.QuestionSelect_ID = (control_questionList as Control_QuestionList).QuestionSelect_ID; Function_AnswerList function_answerList = new Function_AnswerList(); if (Is_Save) { if (!function_answerList.Update_AnswerList(class_answerList)) MessageBox.Show("Update_AnswerList更新数据失败", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (!function_answerList.Insert_AnswerList(class_answerList)) MessageBox.Show("Insert_AnswerList插入数据失败", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } } if (control_questionList is TextBox) { TextBox textBox_controls = (TextBox)control_questionList; if (textBox_controls.Name == "Text_Question_Tail") Question_Tail = textBox_controls.Text; } } } Class_AnswerInfo class_answerInfo = new Class_AnswerInfo(); class_answerInfo.AnswerInfo_ID = AnswerInfo_ID; class_answerInfo.ClientInfo_ID = ClientInfo_ID; class_answerInfo.Question_ID = Question_ID; class_answerInfo.Question_Tail = Question_Tail; if (Is_Save) { if (!function_answerInfo.Update_AnswerInfo(class_answerInfo)) MessageBox.Show("Update_AnswerInfo更新数据失败", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (!function_answerInfo.Insert_AnswerInfo(class_answerInfo)) MessageBox.Show("Insert_AnswerInfo插入数据失败", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } MessageBox.Show("已将答卷记录保存到数据库。", "成功", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } //测试 if (SaveTest == 1) { int QuestionList_NoSelect = 0; for (int i = 1; i <= QuestionList_TotalPage; i++) { panel_controls = Controls.Find("Panel_QuestionList" + i.ToString(), false); if (panel_controls == null || panel_controls.Length == 0) return; if (panel_controls[0] is Panel) { panel = (Panel)panel_controls[0]; //panel.Visible = false; } else return; foreach (Control control_questionList in panel.Controls) { if (control_questionList is Control_QuestionList) { int QuestionList_ListID = (control_questionList as Control_QuestionList).QuestionList_ListID; int QuestionSelect_Score = (control_questionList as Control_QuestionList).QuestionSelect_Score; String QuestionSelect_Text = (control_questionList as Control_QuestionList).QuestionSelect_Text; TextBox TextBox_QuestionList = (control_questionList as Control_QuestionList).TextBox_QuestionList; if (TextBox_QuestionList == null) { if (QuestionSelect_Score != -1 && !String.IsNullOrEmpty(QuestionSelect_Text)) { list_answerInfo_Score.Add(QuestionList_ListID, QuestionSelect_Score); list_answerInfo_Text.Add(QuestionList_ListID, QuestionSelect_Text); } else { QuestionList_NoSelect = i; MessageBox.Show("第" + QuestionList_ListID.ToString() + "题没选择", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } else { if (!String.IsNullOrEmpty(TextBox_QuestionList.Text) && CommonFunction.IsNumber(TextBox_QuestionList.Text, 2)) { list_answerInfo_Score.Add(QuestionList_ListID, Convert.ToSingle(TextBox_QuestionList.Text)); list_answerInfo_Text.Add(QuestionList_ListID, QuestionSelect_Text); } else { list_answerInfo_Score.Add(QuestionList_ListID, 0); list_answerInfo_Text.Add(QuestionList_ListID, QuestionSelect_Text); } } } } if (QuestionList_NoSelect > 0) break; } if (QuestionList_NoSelect > 0) { QuestionList_CurrentPage = QuestionList_NoSelect; for (int i = 1; i <= QuestionList_TotalPage; i++) { panel_controls = Controls.Find("Panel_QuestionList" + i.ToString(), false); if (panel_controls == null || panel_controls.Length == 0) return; if (panel_controls[0] is Panel) panel = (Panel)panel_controls[0]; else return; if (i == QuestionList_NoSelect) { Control_Visible(); panel.Visible = true; } else panel.Visible = false; } return; } //Control[] flow_controls = Controls.Find("Panel_Top", false); //if (flow_controls == null || flow_controls.Length == 0) // return; //if (flow_controls[0] is FlowLayoutPanel) //{ // FlowLayoutPanel flow = (FlowLayoutPanel)flow_controls[0]; // flow.Visible = false; //} //label5.Location = new Point(label5.Location.X, pictureBox2.Location.Y + pictureBox2.Height + 10); //label6.Location = new Point(label6.Location.X, pictureBox2.Location.Y + pictureBox2.Height + 10); //panel = new Panel(); //panel.AutoSize = true; ////panel.BorderStyle = BorderStyle.Fixed3D; //panel.Location = new System.Drawing.Point(50, label5.Location.Y + 15); //panel.Name = "Panel_QuestionCase"; //panel.Visible = true; //Controls.Add(panel); //if (Question_ID == 1) //{ // Control_QuestionCase1 control_questionCase = new Control_QuestionCase1(Convert.ToInt32(Question_ID), list_answerInfo_Score); // control_questionCase.Show_Result(); // panel.Controls.Add(control_questionCase); //} //if (Question_ID == 2) //{ // Control_QuestionCase2 control_questionCase = new Control_QuestionCase2(Convert.ToInt32(Question_ID), list_answerInfo_Score, list_answerInfo_Text); // control_questionCase.Show_Result(); // panel.Controls.Add(control_questionCase); //} //choiButton1.Enabled = false; //choiButton1.Visible = false; //choiButton1.Location = new Point(choiButton1.Location.X, panel.Location.Y + panel.Size.Height + 10); //choiButton2.Location = new Point(choiButton2.Location.X, panel.Location.Y + panel.Size.Height + 10); //choiButton3.Location = new Point(choiButton3.Location.X, panel.Location.Y + panel.Size.Height + 10); //IsClose = true; //choiButton2.Text = "打印"; //choiButton3.Text = "关闭"; //this.Refresh(); Form_Result form_Result = new Form_Result(Question_ID, ClientInfo_ID, list_answerInfo_Score, list_answerInfo_Text); form_Result.Show_Result(); form_Result.FormBorderStyle = FormBorderStyle.None; form_Result.StartPosition = FormStartPosition.Manual; form_Result.WindowState = FormWindowState.Maximized; form_Result.Show(); } } }