private void button6_Click(object sender, EventArgs e) { dataGridView1.DataSource = null; EXtools etool = new Exercise_form.EXtools(); List <featurehelp> lfea = null; // List<helpsimilar> hsl = new List<Exercise_form.helpsimilar>(); hsl.Clear(); lfea = etool.checkfeature(4, pp); foreach (featurehelp fp in lfea) { helpsimilar hs = new Exercise_form.helpsimilar(); hs.id = fp.id; hs.qid = fp.qid; hs.sim = -1; hs.str = fp.featurestr; hs.type1 = fp.type1; hsl.Add(hs); } for (int i = 0; i < hsl.Count() - 1; i++) { for (int j = i + 1; j < hsl.Count(); j++) { if (hsl[j].sim == -1) { if (EXtools.degreeofsimilarity(hsl[i].str, hsl[j].str) > 0.9) { hsl[j].sim = hsl[i].qid; } } } } dataGridView1.DataSource = hsl; }
private void button1_Click(object sender, EventArgs e) { var q1 = from o in pp.context.mchoiceQues select o; List <mchoiceQues> lmq = null; EXtools etool = new Exercise_form.EXtools(); List <featurehelp> lfea = null; if (q1.Count() > 0) { lfea = etool.checkfeature(0, pp); lmq = q1.ToList <mchoiceQues>(); List <mchoiceQues> lmq2 = new List <mchoiceQues>(lmq.ToArray()); foreach (mchoiceQues mq in lmq2) { bool fexist = true; if (lfea != null) { var q2 = from k in lfea where k.qid == mq.id && k.type1 == 0 select k; if (q2.Count() > 0) { fexist = false; } } richTextBox1.Text = ""; System.IO.MemoryStream mstream = new System.IO.MemoryStream(mq.question, false); this.richTextBox1.LoadFile(mstream, RichTextBoxStreamType.RichText); string strq = richTextBox1.Text; string fstr = null; if (fexist) { if (strq.Length < 21) { fstr = strq; } else { fstr = strq.Substring(0, 20).Trim(); } featurehelp fhelp = new featurehelp(); /// fhelp.con = mq.con; fhelp.objective = mq.objective; fhelp.diff = mq.diff; fhelp.courseid = mq.courseid; //// fhelp.qid = mq.id; fhelp.type1 = 0; fhelp.featurestr = fstr.ToString(); pp.context.AddTofeaturehelp(fhelp); } } pp.context.SaveChanges(); } //////////////////////////////////////////////////////////////////////////////////////// var q11 = from o in pp.context.TFQues select o; List <TFQues> lTF = null; //EXtools etool = new Exercise_form.EXtools(); if (q11.Count() > 0) { lfea = etool.checkfeature(1, pp); lTF = q11.ToList <TFQues>(); List <TFQues> lmq2 = new List <TFQues>(lTF.ToArray()); foreach (TFQues mq in lmq2) { bool fexist = true; if (lfea != null) { var q2 = from k in lfea where k.qid == mq.id && k.type1 == 1 select k; if (q2.Count() > 0) { fexist = false; } } richTextBox1.Text = ""; System.IO.MemoryStream mstream = new System.IO.MemoryStream(mq.question, false); this.richTextBox1.LoadFile(mstream, RichTextBoxStreamType.RichText); string strq = richTextBox1.Text; string fstr = null; if (fexist) { if (strq.Length < 21) { fstr = strq; } else { fstr = strq.Substring(0, 20).Trim(); } featurehelp fhelp = new featurehelp(); /// fhelp.con = mq.con; fhelp.objective = mq.objective; fhelp.diff = mq.diff; fhelp.courseid = mq.courseid; //// fhelp.qid = mq.id; fhelp.type1 = 1; fhelp.featurestr = fstr.ToString(); pp.context.AddTofeaturehelp(fhelp); } } pp.context.SaveChanges(); } ///////////////////////////////////////////////////// var q12 = from o in pp.context.eQues select o; List <eQues> le = null; //EXtools etool = new Exercise_form.EXtools(); if (q12.Count() > 0) { lfea = etool.checkfeature(2, pp); le = q12.ToList <eQues>(); List <eQues> lmq2 = new List <eQues>(le.ToArray()); foreach (eQues mq in lmq2) { bool fexist = true; if (lfea != null) { var q2 = from k in lfea where k.qid == mq.id && k.type1 == 2 select k; if (q2.Count() > 0) { fexist = false; } } richTextBox1.Text = ""; System.IO.MemoryStream mstream = new System.IO.MemoryStream(mq.question, false); this.richTextBox1.LoadFile(mstream, RichTextBoxStreamType.RichText); string strq = richTextBox1.Text; string fstr = null; if (fexist) { if (strq.Length < 21) { fstr = strq; } else { fstr = strq.Substring(0, 20).Trim(); } featurehelp fhelp = new featurehelp(); /// fhelp.con = mq.con; fhelp.objective = mq.objective; fhelp.diff = mq.diff; fhelp.courseid = mq.courseid; //// fhelp.qid = mq.id; fhelp.type1 = 2; fhelp.emnum = mq.emnum; fhelp.featurestr = fstr.ToString(); pp.context.AddTofeaturehelp(fhelp); } } pp.context.SaveChanges(); } ///////////////////////////////////////////////////////////////////////////////////////////////////////// var q13 = from o in pp.context.SQues select o; List <SQues> ls = null; //EXtools etool = new Exercise_form.EXtools(); if (q13.Count() > 0) { lfea = etool.checkfeature(3, pp); ls = q13.ToList <SQues>(); List <SQues> lmq2 = new List <SQues>(ls.ToArray()); foreach (SQues mq in lmq2) { bool fexist = true; if (lfea != null) { var q2 = from k in lfea where k.qid == mq.id && k.type1 == 3 select k; if (q2.Count() > 0) { fexist = false; } } richTextBox1.Text = ""; System.IO.MemoryStream mstream = new System.IO.MemoryStream(mq.question, false); this.richTextBox1.LoadFile(mstream, RichTextBoxStreamType.RichText); string strq = richTextBox1.Text; string fstr = null; if (fexist) { if (strq.Length < 31) { fstr = strq; } else { fstr = strq.Substring(0, 30).Trim(); } featurehelp fhelp = new featurehelp(); /// fhelp.con = mq.con; fhelp.objective = mq.objective; fhelp.diff = mq.diff; fhelp.courseid = mq.courseid; //// fhelp.qid = mq.id; fhelp.type1 = 3; fhelp.featurestr = fstr.ToString(); pp.context.AddTofeaturehelp(fhelp); } } pp.context.SaveChanges(); } /////////////////////////////////////////////////////////////////////////////////////// var q14 = from o in pp.context.AQues select o; List <AQues> lA = null; //EXtools etool = new Exercise_form.EXtools(); if (q14.Count() > 0) { lfea = etool.checkfeature(4, pp); lA = q14.ToList <AQues>(); List <AQues> lmq2 = new List <AQues>(lA.ToArray()); foreach (AQues mq in lmq2) { bool fexist = true; if (lfea != null) { var q2 = from k in lfea where k.qid == mq.id && k.type1 == 4 select k; if (q2.Count() > 0) { fexist = false; } } richTextBox1.Text = ""; System.IO.MemoryStream mstream = new System.IO.MemoryStream(mq.question, false); this.richTextBox1.LoadFile(mstream, RichTextBoxStreamType.RichText); string strq = richTextBox1.Text; string fstr = null; if (fexist) { int ll = strq.Length; if (ll < 21) { fstr = strq.Trim(); } else { if (ll < 41) { fstr = strq.Substring(ll - 21, 20).Trim(); } else { fstr = strq.Substring(10, 20).Trim(); } } featurehelp fhelp = new featurehelp(); /// fhelp.con = mq.con; fhelp.objective = mq.objective; fhelp.diff = mq.diff; fhelp.courseid = mq.courseid; //// fhelp.qid = mq.id; fhelp.type1 = 4; fhelp.featurestr = fstr.ToString(); pp.context.AddTofeaturehelp(fhelp); } } pp.context.SaveChanges(); } MessageBox.Show("ok"); }