private void button1_Click(object sender, EventArgs e)
{
if (selexp >= 0)
{
View_class_exp vp = lvce[selexp];
var questionQuery2 = from o in pp.context.exp_q
where (o.idexp == vp.expid)
select o;
exp_q qew = null;
if (questionQuery2.Count <exp_q>() > 0)
{
qew = questionQuery2.First <exp_q>();
}
saveFileDialog1.FileName = qew.docfilename;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string attaDirectory = saveFileDialog1.FileName;
Byte[] Files = qew.expdoc;
BinaryWriter bw = new BinaryWriter(File.Open(attaDirectory, FileMode.OpenOrCreate));
bw.Write(Files);
bw.Close();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
expid = Session["expid"] as String;
Global gb = Session["gb"] as Global;;;
vce = Session["vce"] as View_class_exp;
st = Session["user"] as StudInfo;
pp = gb.pp;
if (expid != null)
{
var questionQuery2 = from o in pp.context.exp_q
where (o.idexp == int.Parse(expid))
select o;
if (questionQuery2.Count <exp_q>() > 0)
{
qew = questionQuery2.First <exp_q>();
}
labcontrol();
}
}
////////////////////////////////////
private void getstate()
{
if (selexp >= 0)
{
View_class_exp vp = lvce[selexp];
DateTime dt = DateTime.Now;
if (dt > vp.starttime && vp.endtime > dt)
{
button3.Enabled = true;
button4.Enabled = (bool)vp.attach;
}
var questionQuery = from o in pp.context.studreport
where (o.classid == clin.classid && o.stid == stin.studentid && o.expid == vp.expid)
select o;
if (questionQuery.Count <studreport>() > 0)
{
if (questionQuery.First <studreport>().rep != null)
{
button5.Enabled = true;
}
else
{
button5.Enabled = false;
}
if (questionQuery.First <studreport>().atta == null)
{
button6.Enabled = false;
}
else
{
button6.Enabled = true;
}
}
else
{
button5.Enabled = false; button6.Enabled = false;
}
var questionQuery2 = from o in pp.context.exp_q
where (o.idexp == vp.expid)
select o;
if (questionQuery2.Count <exp_q>() > 0)
{
exp_q qew = questionQuery2.First <exp_q>();
if (qew.attachment != null)
{
button2.Enabled = true;
}
else
{
button2.Enabled = false;
}
}
}
else
{
MessageBox.Show("请选择表格中的行");
}
}
private void button1_Click(object sender, EventArgs e)
{
bool flagupdata = checkBox1.Checked;
Exercise_form.ServiceReference1.exp_q mcq = new exp_q();
//
if (flagupdata)
{
Exercise_form.ServiceReference1.exp_q mcq2 = (exp_q)LTF[listBox1.SelectedIndex];
// if (!comboBox2.Text.Equals("") && !comboBox4.Text.Equals("") && !fileDirectory.Equals("") && !textBox2.Text.Equals(""))
if (!comboBox2.Text.Equals("") && !comboBox4.Text.Equals("") && !(mcq2 == null) && !textBox2.Text.Equals(""))
{
mcq2.con = Convert.ToInt16(comboBox2.Text);
mcq2.diff = Convert.ToInt16(comboBox4.Text);
// mcq.courseid = cid;
int objectivecount = checkedListBox1.CheckedItems.Count;
string strobj = "";
for (int i = 0; i < objectivecount; i++)
{
strobj = strobj + "|" + checkedListBox1.CheckedItems[i].ToString();
}
mcq2.objective = strobj;
mcq2.exname = textBox2.Text;
//上传实验内容和附件
long intLength = 0; //获取文件内容的长度
byte[] bytContent = null; //定义内容数组
//建立要输入的文件流
System.IO.FileStream fs = null;
//建立二进制读取
System.IO.BinaryReader br = null;
long intLength2 = 0; //获取文件内容的长度
byte[] bytContent2 = null; //定义内容数组
//建立要输入的文件流
System.IO.FileStream fs2 = null;
//建立二进制读取
System.IO.BinaryReader br2 = null;
try
{
if (!attaDirectory.Equals(""))
{
fs2 = new FileStream(attaDirectory, System.IO.FileMode.Open);
br2 = new BinaryReader((Stream)fs2);
intLength2 = fs2.Length;
bytContent2 = new byte[intLength2];
bytContent2 = br2.ReadBytes((int)intLength2);
mcq2.attachment = bytContent2;
String[] fnames = attaDirectory.Split('\\');
String filenamestr = fnames[fnames.Length - 1];
mcq2.attachmentname = filenamestr;
}
if (!fileDirectory.Equals(""))
{
fs = new FileStream(fileDirectory, System.IO.FileMode.Open);
br = new BinaryReader((Stream)fs);
intLength = fs.Length;
bytContent = new byte[intLength];
bytContent = br.ReadBytes((int)intLength);
mcq2.expdoc = bytContent;
String[] fnames = fileDirectory.Split('\\');
String filenamestr = fnames[fnames.Length - 1];
mcq2.docfilename = filenamestr;
// MessageBox.Show(fileDirectory+" "+ filenamestr);
if ((intLength + intLength2) < pp.maxsize)
{
pp.context.UpdateObject(mcq2);
pp.context.SaveChanges();
textBox2.Text = "";
button1.Enabled = false;
}
}
loaditems();
}
catch (Exception ee)
{
MessageBox.Show("文件打开或保存异常！" + ee.Message);
}
//
}
else
{
MessageBox.Show("输入不完整！");
}
textBox2.Text = "";
return;
}
//
if (!comboBox2.Text.Equals("") && !comboBox4.Text.Equals("") && !fileDirectory.Equals("") && !textBox2.Text.Equals(""))
{
mcq.con = Convert.ToInt16(comboBox2.Text);
mcq.diff = Convert.ToInt16(comboBox4.Text);
mcq.courseid = cid;
int objectivecount = checkedListBox1.CheckedItems.Count;
string strobj = "";
for (int i = 0; i < objectivecount; i++)
{
strobj = strobj + "|" + checkedListBox1.CheckedItems[i].ToString();
}
mcq.objective = strobj;
mcq.exname = textBox2.Text;
//上传实验内容和附件
long intLength = 0; //获取文件内容的长度
byte[] bytContent = null; //定义内容数组
//建立要输入的文件流
System.IO.FileStream fs = null;
//建立二进制读取
System.IO.BinaryReader br = null;
long intLength2 = 0; //获取文件内容的长度
byte[] bytContent2 = null; //定义内容数组
//建立要输入的文件流
System.IO.FileStream fs2 = null;
//建立二进制读取
System.IO.BinaryReader br2 = null;
try
{ if (!attaDirectory.Equals(""))
{
fs2 = new FileStream(attaDirectory, System.IO.FileMode.Open);
br2 = new BinaryReader((Stream)fs2);
intLength2 = fs2.Length;
bytContent2 = new byte[intLength2];
bytContent2 = br2.ReadBytes((int)intLength2);
mcq.attachment = bytContent2;
String[] fnames2 = attaDirectory.Split('\\');
String filenamestr2 = fnames2[fnames2.Length - 1];
mcq.attachmentname = filenamestr2;
}
fs = new FileStream(fileDirectory, System.IO.FileMode.Open);
br = new BinaryReader((Stream)fs);
intLength = fs.Length;
bytContent = new byte[intLength];
bytContent = br.ReadBytes((int)intLength);
mcq.expdoc = bytContent;
String[] fnames = fileDirectory.Split('\\');
String filenamestr = fnames[fnames.Length - 1];
mcq.docfilename = filenamestr;
if ((intLength + intLength2) < pp.maxsize)
{
pp.context.AddToexp_q(mcq);
pp.context.SaveChanges();
textBox2.Text = "";
button1.Enabled = false;
}
loaditems(); }
catch (Exception ee)
{
MessageBox.Show("文件打开或保存异常！" + ee.Message);
}
//
}
else
{
MessageBox.Show("输入不完整！");
}
}
