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