private void NavigationPage_Loaded(object sender, RoutedEventArgs e)
{
using (DarkFieldContext dfc = new DarkFieldContext())
{
this.ASPNET.ItemsSource = dfc.ItemBank.Select(o => o).ToList <ItemBank>();
}
}
private void NavigationPage_Loaded(object sender, RoutedEventArgs e)
{
using (DarkFieldContext dfc = new DarkFieldContext())
{
this.ZoneWhone.ItemsSource = dfc.ItemBank.Select(o => o).ToList <ItemBank>();
// this.Zone1.ItemsSource = dfc.Questions.Where(o =>o.QuestionGenre =="Picture").ToList<Question>();
listTemp = dfc.ItemBank.ToList <ItemBank>();
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
if (this.ASPNET.SelectedItems != null)
{
using (DarkFieldContext dfc = new DarkFieldContext())
{
List <ItemBank> listSelected = new List <ItemBank>();
foreach (var item in this.ASPNET.SelectedItems)
{
ItemBank t = item as ItemBank;
if (t != null)
{
var person = dfc.ItemBank.Where(m => m.ItemBankId == t.ItemBankId).FirstOrDefault();
dfc.ItemBank.Remove(person);
}
//移除各个分区试题中的对应项
foreach (var quesIndex in dfc.ZoneItemBank.ToList())
{
// string[] temIndex = null;
var temIndex = quesIndex.QuesIndexes.Split(',').ToList();
for (int i = 0; i < temIndex.Count; i++)
{
if (t.ItemBankId.ToString() == temIndex[i])
{
temIndex.RemoveAt(i);
i--;
}
}
quesIndex.QuesIndexes = "";
for (int i = 0; i < temIndex.Count; i++)
{
if (quesIndex.QuesIndexes != "")
{
quesIndex.QuesIndexes = quesIndex.QuesIndexes + "," + temIndex[i];
}
else
{
quesIndex.QuesIndexes = temIndex[i];
}
}
}
;
}
dfc.SaveChanges();
this.ASPNET.ItemsSource = dfc.ItemBank.Select(o => o).ToList <ItemBank>();
}
}
}
private void zoneB_Click(object sender, RoutedEventArgs e)
{
this.currentZone.Text = "当前选中的区域为B";
string[] sArray;
List <int> listIndex = new List <int>();
using (DarkFieldContext dfc = new DarkFieldContext())
{
ZoneItemBank zone1 = dfc.ZoneItemBank.Where(o => o.ZoneCode == "Zone B").FirstOrDefault();
if (zone1 != null)
{
ExportString = zone1.QuesIndexes;
if (ExportString != String.Empty)
{
sArray = ExportString.Split(',');
foreach (string i in sArray)
{
listIndex.Add(int.Parse(i));
}
//顺序问题
List <ItemBank> seqQuestions = new List <ItemBank>();
for (int i = 0; i < listIndex.Count(); i++)
{
seqQuestions.Add(listTemp.First(o => o.ItemBankId == listIndex[i]).Clone());
}
this.Zone1.ItemsSource = seqQuestions;
}
else
{
this.Zone1.ItemsSource = null;
}
}
else
{
ZoneItemBank zoneAA = new ZoneItemBank();
zoneAA.ZoneCode = "Zone B";
zoneAA.QuesIndexes = "";
dfc.ZoneItemBank.Add(zoneAA);
dfc.SaveChanges();
}
}
}
private void ImageButton_Click_1(object sender, RoutedEventArgs e)
{
using (DarkFieldContext dfc = new DarkFieldContext())
{
ItemBank question = new ItemBank();
if (radioText.IsChecked == true)
{
question.ItemGenre = "String";
question.QBody = System.Text.Encoding.Default.GetBytes(this.body.Text.ToString());
}
else if (radioPicture.IsChecked == true)
{
question.ItemGenre = "Picture";
question.QBody = TaskConstructor.Utility.GlobalHelper.BitmapImageToByteArray(this.demoImage.Source as BitmapImage);
question.QPathVideoOrPics = pathVideo;
}
else if (radioVideo.IsChecked == true)
{
question.ItemGenre = "Video";
question.QBody = System.Text.Encoding.Default.GetBytes(this.body.Text.ToString());
question.QPathVideoOrPics = pathVideo;
}
// byte[] imageBuffer = System.IO.File.ReadAllBytes(@"H:\DarkField\TaskConstructor\TaskConstructor\Resources\images\查询_0.png");
// question.QBody = imageBuffer;
// question.TaskKind = comboPlan.SelectedValue.ToString();
question.TaskKind = comboPlan.Text;
question.QAnswer = this.rightAnswer.Text.ToString();
question.QHead = this.title.Text.ToString();
// question.QBody = System.Text.Encoding.Default.GetBytes(this.body.Text.ToString());
question.QOption = this.options.Text.ToString();
dfc.ItemBank.Add(question);
dfc.SaveChanges();
}
}
private void btnDel_Click(object sender, RoutedEventArgs e)
{
using (DarkFieldContext dfc = new DarkFieldContext())
{
switch (this.currentZone.Text)
{
case "当前选中的区域为A":
List <ItemBank> aList = Zone1.ItemsSource.OfType <ItemBank>().ToList();
ZoneItemBank zone1 = dfc.ZoneItemBank.Where(o => o.ZoneCode == "Zone A").First();
if (this.Zone1.SelectedItems != null)
{
foreach (var item in this.Zone1.SelectedItems.OfType <ItemBank>().ToList())
{
ItemBank t = item as ItemBank;
if (t != null)
{
aList.Remove(t);
Zone1.ItemsSource = aList;
//Zone1.ItemsSource
// this.Zone1.Items.RemoveAt(Zone1.SelectedIndex);
}
}
}
else
{
}
if (aList.Count > 0)
{
ofoIds = "";
for (int i = 0; i < aList.Count(); i++)
{
ofoIds = ofoIds + aList[i].ItemBankId.ToString() + ",";
}
ofoIds = ofoIds.Remove(ofoIds.Length - 1, 1);
zone1.QuesIndexes = ofoIds;
dfc.SaveChanges();
}
else
{
zone1.QuesIndexes = "";
dfc.SaveChanges();
}
break;
case "当前选中的区域为B":
List <ItemBank> aListB = Zone1.ItemsSource.OfType <ItemBank>().ToList();
ZoneItemBank zoneB = dfc.ZoneItemBank.Where(o => o.ZoneCode == "Zone B").First();
if (this.Zone1.SelectedItems != null)
{
foreach (var item in this.Zone1.SelectedItems.OfType <ItemBank>().ToList())
{
ItemBank t = item as ItemBank;
if (t != null)
{
aListB.Remove(t);
Zone1.ItemsSource = aListB;
//Zone1.ItemsSource
// this.Zone1.Items.RemoveAt(Zone1.SelectedIndex);
}
}
}
else
{
}
if (aListB.Count > 0)
{
ofoIds = "";
for (int i = 0; i < aListB.Count(); i++)
{
ofoIds = ofoIds + aListB[i].ItemBankId.ToString() + ",";
}
ofoIds = ofoIds.Remove(ofoIds.Length - 1, 1);
zoneB.QuesIndexes = ofoIds;
dfc.SaveChanges();
}
else
{
zoneB.QuesIndexes = "";
dfc.SaveChanges();
}
break;
default:
break;
}
}
}
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
// if (this.ZoneWhone.SelectedItems != null && this.Zone1.ItemsSource !=null)
if (this.ZoneWhone.SelectedItems != null)
{
List <ItemBank> sourceList = new List <ItemBank>();
List <ItemBank> destList = new List <ItemBank>();
if (this.ZoneWhone.SelectedItems != null)
{
sourceList = this.ZoneWhone.SelectedItems.OfType <ItemBank>().ToList();
}
if (this.Zone1.ItemsSource != null)
{
destList = this.Zone1.ItemsSource.OfType <ItemBank>().ToList();
}
using (DarkFieldContext dfc = new DarkFieldContext())
{
switch (this.currentZone.Text)
{
case "当前选中的区域为A":
ZoneItemBank zoneA = dfc.ZoneItemBank.Where(o => o.ZoneCode == "Zone A").FirstOrDefault();
if (zoneA == null)
{
ZoneItemBank zoneAA = new ZoneItemBank();
zoneAA.ZoneCode = "Zone A";
zoneAA.QuesIndexes = "";
dfc.ZoneItemBank.Add(zoneAA);
dfc.SaveChanges();
}
zoneA = dfc.ZoneItemBank.Where(o => o.ZoneCode == "Zone A").FirstOrDefault();
foreach (var item in sourceList)
{
ItemBank t = item as ItemBank;
if (t != null)
{
destList.Add(t);
if (zoneA.QuesIndexes != "")
{
zoneA.QuesIndexes = zoneA.QuesIndexes + "," + t.ItemBankId;
}
else
{
zoneA.QuesIndexes = t.ItemBankId.ToString();
}
// Zone1.ItemsSource = aList;
//Zone1.ItemsSource
// this.Zone1.Items.RemoveAt(Zone1.SelectedIndex);
}
}
dfc.SaveChanges();
Zone1.ItemsSource = destList;
break;
case "当前选中的区域为B":
// ZoneItemBank zoneB = dfc.ZoneItemBank.Where(o => o.ZoneCode == "Zone B").First();
ZoneItemBank zoneB = dfc.ZoneItemBank.Where(o => o.ZoneCode == "Zone B").FirstOrDefault();
if (zoneB == null)
{
ZoneItemBank zoneAA = new ZoneItemBank();
zoneAA.ZoneCode = "Zone B";
zoneAA.QuesIndexes = "";
dfc.ZoneItemBank.Add(zoneAA);
dfc.SaveChanges();
}
zoneB = dfc.ZoneItemBank.Where(o => o.ZoneCode == "Zone B").FirstOrDefault();
foreach (var item in sourceList)
{
ItemBank t = item as ItemBank;
if (t != null)
{
destList.Add(t);
if (zoneB.QuesIndexes != "")
{
zoneB.QuesIndexes = zoneB.QuesIndexes + "," + t.ItemBankId;
}
else
{
zoneB.QuesIndexes = t.ItemBankId.ToString();
}
}
}
dfc.SaveChanges();
Zone1.ItemsSource = destList;
break;
}
}
}
}
