public PaperInfoForm(TestPaper testpaper,string okbtntext="确认")
{
this.testPaper = testpaper;
InitializeComponent();
ClassListAttrible cla = new ClassListAttrible();
xuekeComboBox.Items.AddRange(cla.lists);
this.paperNameTextBox.Text= testPaper.试卷名称;
this.tagTextBox.Text= testPaper.标签 ;
this.xuekeComboBox.Text= testPaper.学科;
this.okButton.Text = okbtntext;
}
private void InitializeForm()
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(Application.StartupPath + "/LoginConfig.xml");
XmlNode address = xmldoc.SelectSingleNode("//address");
//XmlNodeList xnlist = xmldoc.SelectNodes("//Template");
//List<string> classiten = new List<string>();
//for (int i = 0; i < xnlist.Count; i++)
//{
// XmlElement xmle = (XmlElement)xnlist[i];
// //string id = xmle.GetAttribute("id");
// string text = xmle.GetAttribute("text");
// this.toolStripComboBoxClass.Items.Add(text);
// //classiten.Add(text);
//}
try
{
HttpHelper httphelper = new HttpHelper();
string stagexml = httphelper.getHttpRespone("http://" + address.InnerText + "/api/Item/get?token=stage");
XmlDocument xmldocstage = new XmlDocument();
xmldocstage.LoadXml(stagexml.Trim());
xmldocstage.Save(Application.StartupPath + stagefilename);
string sourcexml = httphelper.getHttpRespone("http://" + address.InnerText + "/api/Item/get?token=source");
XmlDocument xmldocsource = new XmlDocument();
xmldocsource.LoadXml(sourcexml.Trim());
xmldocsource.Save(Application.StartupPath + sourcefilename);
string xuekexml = httphelper.getHttpRespone("http://" + address.InnerText + "/api/Item/get?token=xueke");
XmlDocument xmldocxueke = new XmlDocument();
xmldocxueke.LoadXml(xuekexml.Trim());
xmldocxueke.Save(Application.StartupPath + xuekefilename);
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
testpaper = new TestPaper();//初始化试卷属性
foreach (string st in Enum.GetNames(typeof(Subject.SubjecttypeEnum)))
{
System.Windows.Forms.TreeNode treeNode = new System.Windows.Forms.TreeNode(st);
treeNode.Text = st;
this.treeViewSubject.Nodes.Add(treeNode);
}
}
public void InsertTFrom(TestPaper testPaper)
{
if (this.OpenConnection() == true)
{
string query = "INSERT INTO pd_tfrom (id,f_name,txueke_id,f_desc,f_stage,f_year,f_count,f_testcount,f_status,f_entering,f_source,f_number,create_person,created,update_person,f_isdelete,updated) VALUES(?id,?f_name,?txueke_id,?f_desc,?f_stage,?f_year,?f_count,?f_testcount,?f_status,?f_entering,?f_source,?f_number,?create_person,?created,?update_person,?f_isdelete,?updated)";
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query,connection);
cmd.Parameters.AddWithValue("?id",Guid.NewGuid().ToString());
cmd.Parameters.AddWithValue("?f_desc", testPaper.��ǩ);
cmd.Parameters.AddWithValue("?f_name", testPaper.�Ծ�����);
cmd.Parameters.AddWithValue("?txueke_id", testPaper.ѧ��);
cmd.Parameters.AddWithValue("?f_count", testPaper.ѧ��);
cmd.Parameters.AddWithValue("?f_testcount", testPaper.ѧ��);
cmd.Parameters.AddWithValue("?f_status", testPaper.ѧ��);
cmd.Parameters.AddWithValue("?f_entering", testPaper.ѧ��);
cmd.Parameters.AddWithValue("?f_number", testPaper.ѧ��);
cmd.Parameters.AddWithValue("?create_person", testPaper.ѧ��);
cmd.Parameters.AddWithValue("?created", testPaper.ѧ��);
cmd.Parameters.AddWithValue("?f_isdelete", testPaper.ѧ��);
cmd.Parameters.AddWithValue("?updated", testPaper.ѧ��);
cmd.Parameters.AddWithValue("?update_person", testPaper.ѧ��);
//Execute command
cmd.ExecuteNonQuery();
//close connection
this.CloseConnection();
}
}
private bool SetPaperInfo(string okbtnstr = "确认")
{
using (PaperInfoForm paperinfo = new PaperInfoForm(testpaper, okbtnstr))
{
DialogResult dialogresult = paperinfo.ShowDialog();
testpaper = paperinfo.testPaper;
if (dialogresult.Equals(DialogResult.Cancel))
{
return false;
}
}
if (string.IsNullOrEmpty(testpaper.学科) || string.IsNullOrEmpty(testpaper.试卷名称) || string.IsNullOrEmpty(testpaper.标签))
{
return false;
}
return true;
}
