static void Main(string[] args)
{
OD od = new OD();
od.jisuan();
suanfa suan = new suanfa(od);
suan.read();
suan.solutionMainsuanfa();
suan.Write("result.txt");
// od.read();
//遍历距离OD（数据字典）
// od.foreachDis();
//od.write();
// od.getTime("200001", "200122");
//输出距离
// double dis = od.getDistance("100011", "900001");
// Console.WriteLine("距离="+dis);
//输出时间
// Console.WriteLine("时间=" + od.getTime("900001","100141"));
Console.ReadKey();
}
public void GenRoute()
{
pathList = new List <Route>();
Dictionary <OD, List <Route> > dic = new Dictionary <OD, List <Route> >();
foreach (MarketSegment ms in mar)
{
OD temp = dic.Keys.FirstOrDefault(i => i.OriSta == ms.OriSta && i.DesSta == ms.DesSta);
if (temp == null)
{
temp = new OD()
{
OriSta = ms.OriSta, DesSta = ms.DesSta
};
var a = FindPath(temp, 1, 60, 5).ToList();
dic.Add(temp, a);
pathList.AddRange(a);
}
foreach (Route r in dic[temp])
{
if (r.Count <= ms.Transfer + 1)
{
if (r.Count == 1)
{
ms.ConsiderationDic.Add(r, 8);
}
else if (r.Count > 1)
{
ms.ConsiderationDic.Add(r, 2);
}
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
OD.ShowDialog();
System.IO.FileStream fs = new System.IO.FileStream(OD.FileName, System.IO.FileMode.Open);
System.Runtime.Serialization.Formatters.Binary.BinaryFormatter BF = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();
PacketProxy.PacketContainer pc = new PacketProxy.PacketContainer();
PacketProxy.PacketContainer.Instance = (PacketProxy.PacketContainer)BF.Deserialize(fs);
fs.Close();
if (radioButton1.Checked)
{
currentList = PacketProxy.PacketContainer.Instance.packets;
}
else
{
currentList = PacketProxy.PacketContainer.Instance.packets2;
}
currentIndex = 0;
showPacket();
list.Items.Clear();
foreach (SagaLib.Packet i in currentList)
{
string tmp = string.Format("0x{0:X4}", i.ID);
if (list.Items.Contains(tmp))
{
continue;
}
list.Items.Add(tmp, CheckState.Checked);
}
}
private void OnBtnLoad(object sender, EventArgs e)
{
session?.Dispose();
if (txtPath.Text == "")
{
if (OD.ShowDialog() == DialogResult.OK)
{
Properties.Settings.Default["assembly_path"] = txtPath.Text = OD.FileName;
Properties.Settings.Default.Save();
}
else
{
return;
}
}
try
{
Properties.Settings.Default["assembly_path"] = txtPath.Text;
Properties.Settings.Default.Save();
session = new TestSession();
session.Load(txtPath.Text, cbEnableRegVM.Checked);
_isLoadAssembly = true;
LoadTest();
UpdateBtnState();
}
catch (Exception ex)
{
MessageBox.Show("[Error:]" + ex);
}
}
private void btnOpenFile_Click(object sender, EventArgs e)
{
if (OD.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
lastFile = OD.FileName;
IWorkbook workbook = WorkbookFactory.Create(lastFile);
ISheet sheet = workbook.GetSheetAt(0);
string[] names = sheet.SheetName.Split('|');
if (names.Length < 2 || names[1] != "ScenarioConfig")
{
MessageBox.Show("请打开剧情表", "文件错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
lbScripts.Items.Clear();
for (int i = 4; i < sheet.LastRowNum; i++)
{
IRow row = sheet.GetRow(i);
int sn = GetIntFromCell(row, 0);
int repID = GetIntFromCell(row, 1);
int type = GetIntFromCell(row, 2);
int param1 = GetIntFromCell(row, 3);
int param2 = GetIntFromCell(row, 4);
int param3 = GetIntFromCell(row, 5);
bool firstOnly = GetBooleanFromCell(row, 6);
bool canSkip = GetBooleanFromCell(row, 7);
int delay = GetIntFromCell(row, 9);
string content = GetStringFromCell(row, 10);
GOEGame.ConfScenarioConfig conf = new GOEGame.ConfScenarioConfig(sn, repID, type, param1, param2, param3, firstOnly, canSkip, delay, content);
lbScripts.Items.Add(conf.Script);
}
}
}
private void repFaktura_Load(object sender, EventArgs e)
{
DTstatistika = dSstatistike.DTstatistika;
string zemljaFilter = "";
if (zemlja != null && zemlja != "")
{
zemljaFilter = " AND unos_gosta.id_drzava='" + zemlja + "' ";
}
string sql = "SELECT zemlja.zemlja,unos_gosta.datum_dolaska,unos_gosta.datum_odlaska,unos_gosta.iznos_bor_pristojbe FROM unos_gosta" +
" LEFT JOIN zemlja ON zemlja.country_code=unos_gosta.id_drzava WHERE " +
" unos_gosta.vrijeme_unosa>='" + OD.ToString("yyyy-MM-dd H:mm:ss") + "' AND unos_gosta.vrijeme_unosa<='" + DO.ToString("yyyy-MM-dd H:mm:ss") + "'" + zemljaFilter +
"";
DataTable DT = RemoteDB.select(sql, "unos_gosta").Tables[0];
string nas = "STATISTIČKI PRIKAZ DOLAZAKA I NOĆENJA GOSTIJU\r\nza period od " + OD.ToString("yyyy-MM-dd H:mm:ss") + " do " + DO.ToString("yyyy-MM-dd H:mm:ss") + "";
foreach (DataRow row in DT.Rows)
{
int broj_dana = Funkcije.ReturnDaysFromDate(Convert.ToDateTime(row["datum_dolaska"].ToString()), Convert.ToDateTime(row["datum_odlaska"].ToString()));
SetTable(row["zemlja"].ToString(), 1, 1 * broj_dana, (Convert.ToDouble(row["iznos_bor_pristojbe"].ToString()) * broj_dana), nas);
}
this.reportViewer1.RefreshReport();
}
public ActionResult DeleteConfirmed(int id)
{
OD od = db.OD.Single(o => o.id_od == id);
db.OD.DeleteObject(od);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private HashSet <Route> FindPath(OD od, int TransitUpperBound, int TransitMinutes_UB, int TransitMinutes_LB)
{
HashSet <Route> PathSet = new HashSet <Route>();
//TODO:An A-Star Aglorithm to Find Out Feasible Paths.
//If there is zero/one transit
List <Train> tlo = tt.Where(i => i.StaList.Exists(j => j.StationName == od.OriSta)).ToList();
List <Train> tld = tt.Where(i => i.StaList.Exists(j => j.StationName == od.DesSta)).ToList();
foreach (Train a in tlo)
{
if (a.PassStation(od.DesSta))
{
Product p = FindProduct(proset, a, od.OriSta, od.DesSta);
if (p != null)
{
PathSet.Add(CreatePath(od, new List <Product>()
{
FindProduct(proset, a, od.OriSta, od.DesSta)
}));
}
}
else if (TransitUpperBound >= 1)
{
foreach (Train b in tld)
{
if (a.Equals(b))
{
continue;
}
if (b.PassStation(od.OriSta))
{
continue;
}
List <string> list = a.InteractWith(b);
foreach (string s in list)
{
if (s != od.OriSta && s != od.DesSta &&
(b.getDepTime(s) - a.getArrTime(s)).TotalMinutes <= TransitMinutes_UB &&
(b.getDepTime(s) - a.getArrTime(s)).TotalMinutes >= TransitMinutes_LB
)
{
Product p1 = FindProduct(proset, a, od.OriSta, s);
Product p2 = FindProduct(proset, b, s, od.DesSta);
if (p1 != null && p2 != null)
{
PathSet.Add(CreatePath(od, new List <Product>()
{
p1, p2
}));
}
}
}
}
}
}
return(PathSet);
}
private void btnBrowse_Click(object sender, EventArgs e)
{
OD.InitialDirectory = Application.StartupPath;
if (OD.ShowDialog(this) == DialogResult.OK)
{
txtTemplateFile.Text = OD.FileName;
txtPDF.Text = System.IO.Path.GetFileNameWithoutExtension(OD.FileName) + ".pdf";
}
}
private void LoadMainProjectAssemblyClick(object sender, EventArgs e)
{
var targetPath = sourcePath1.Text;
if (targetPath == "")
{
if (OD.ShowDialog() != DialogResult.OK)
{
return;
}
Properties.Settings.Default["assembly_path"] = OD.FileName;
Properties.Settings.Default.Save();
sourcePath1.Text = targetPath = OD.FileName;
}
_adaptorAttrName = adaptorTxt.Text;
_delegateAttrName = delegateTxt.Text;
if (string.IsNullOrEmpty(_adaptorAttrName) || string.IsNullOrEmpty(_delegateAttrName))
{
Print("[Error] Adaptor Export Attribute or DelegateAttribute is Empty");
return;
}
var assembly = Assembly.LoadFrom(targetPath);
if (assembly == null)
{
return;
}
//types
var types = assembly.GetTypes();
_adptorAttr = assembly.GetType(_adaptorAttrName);
_delegateAttr = assembly.GetType(_delegateAttrName);
foreach (var type in types)
{
//load ad
var attr = type.GetCustomAttribute(_adptorAttr, false);
if (attr != null)
{
Print("[adaptor]" + type.FullName);
LoadAdaptor(type);
continue;
}
//load delegate
var attr1 = type.GetCustomAttribute(_delegateAttr, false);
if (attr1 != null)
{
Print("[delegate convertor]" + type.FullName);
LoadDelegateConvertor(type);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
Google.API.Translate.TranslateClient client = new Google.API.Translate.TranslateClient("http://www.sagaeco.com");
int counter = 0;
int total = 0;
if (OD.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
XmlDocument xml = new XmlDocument();
xml.Load(OD.FileName);
XmlElement root = xml["text"];
XmlNodeList list = root.ChildNodes;
total = list.Count;
foreach (object j in list)
{
if (j.GetType() != typeof(XmlElement))
{
continue;
}
XmlElement i = (XmlElement)j;
if (i.Name == "Entry")
{
XmlNodeList childre = i.ChildNodes;
string name = string.Empty;
foreach (object l in childre)
{
if (l.GetType() != typeof(XmlElement))
{
continue;
}
XmlElement k = (XmlElement)l;
switch (k.Name)
{
case "Name":
name = k.InnerText;
break;
case "Value":
if (name.Contains("UI.") && !name.Contains("UI.Chat.Sy") && k.InnerText.Length < 1000 && !string.IsNullOrEmpty(k.InnerText))
{
k.InnerText = client.Translate(k.InnerText, Google.API.Translate.Language.Korean, Google.API.Translate.Language.Japanese);
System.Threading.Thread.Sleep(1000);
}
break;
}
}
}
counter++;
pb.Value = (counter * 100) / total;
Application.DoEvents();
}
xml.Save(OD.FileName);
}
}
private void OnBtnLoad(object sender, EventArgs e)
{
if (txtPath.Text == "")
{
if (OD.ShowDialog() == DialogResult.OK)
{
Properties.Settings.Default["assembly_path"] = txtPath.Text = OD.FileName;
Properties.Settings.Default.Save();
}
else
{
return;
}
}
try
{
using (FileStream fs = new FileStream(txtPath.Text, FileMode.Open, FileAccess.Read))
{
var path = Path.GetDirectoryName(txtPath.Text);
var name = Path.GetFileNameWithoutExtension(txtPath.Text);
var pdbPath = Path.Combine(path, name) + ".pdb";
if (!File.Exists(pdbPath))
{
name = Path.GetFileName(txtPath.Text);
pdbPath = Path.Combine(path, name) + ".mdb";
}
using (var fs2 = new System.IO.FileStream(pdbPath, FileMode.Open))
{
Mono.Cecil.Cil.ISymbolReaderProvider symbolReaderProvider = null;
if (pdbPath.EndsWith(".pdb"))
{
symbolReaderProvider = new Mono.Cecil.Pdb.PdbReaderProvider();
}
else if (pdbPath.EndsWith(".mdb"))
{
symbolReaderProvider = new Mono.Cecil.Mdb.MdbReaderProvider();
}
_app.LoadAssembly(fs, fs2, symbolReaderProvider);
_isLoadAssembly = true;
}
ILRuntimeHelper.Init(_app);
ILRuntime.Runtime.Generated.CLRBindings.Initialize(_app);
LoadTest();
UpdateBtnState();
}
}
catch (Exception ex)
{
MessageBox.Show("[Error:]" + ex);
}
}
public void ODchange_to_finish(Ordered_Dish od)
{
foreach (XElement OD in OrderedDishes_Root.Elements())
{
if (OD.Element("OrderedDish_Number").Value == od.OrderedDish_Number.ToString())
{
OD.Element("OrderedDish_Situation").Value = OrderedDish_Situation.FINISH.ToString();
}
}
OrderedDishes_Root.Save(OrderedDishes_Path);
}
private void button1_Click(object sender, EventArgs e)
{
OD.Filter = Functions.AllFormats.GetFilter();
foreach (MoleculeFormat MF in Functions.Formats)
{
OD.Filter += $" | {MF.GetFilter()}";
}
OD.ShowDialog();
textBox1.Text = OD.FileName;
OpenStructure(textBox1.Text);
}
/// <summary>
/// 获取一个OD的所有可行路径
/// </summary>
/// <param name="od"></param>
/// <param name="luDuans"></param>
/// <param name="nodes"></param>
/// <returns></returns>
public static List<LuJing> GetAllPath(OD od, List<LuDuan> luDuans, List<Node> nodes)
{
var lujings = new List<LuJing>();
var stack = new Stack<Node>();
var lujingNos = new List<List<int>>();
stack.Push(nodes.NumOf(od.Start));
while (stack.Count > 0)
{
var neighbor = GetNeighbor(stack, luDuans, nodes);
if (neighbor != null)
{
nodes.NumOf(stack.Peek().No).NextUsed.Add(neighbor);
stack.Push(neighbor);
if (neighbor.No == od.End)
{
var lujing = OutPutLuJing(stack);
lujings.Add(lujing);
lujingNos.Add(lujing.Nodes.Select(p => p.No).ToList());
nodes.NumOf(stack.Peek().No).NextUsed = new List<Node>();
stack.Pop();
}
else
continue;
}
else
{
var peekNode = stack.Peek().No;
nodes.NumOf(stack.Peek().No).NextUsed = new List<Node>();
var show = stack.Select(n => n.No).ToList();
stack.Pop();
if (stack.Count > 0)
{
nodes.NumOf(stack.Peek().No).NextUsed.Add(nodes.NumOf(peekNode));
}
}
}
GetLuduansByNode(luDuans, lujings);
#region 筛选路阻函数最小的几条路径
luDuans.ChangeLtcLtb();
var busLujing = lujings.OrderBy(e => e.LuDuans.Sum(ld => ld.ltb)).Take(Varias.LuJingCount).ToList();
var carLujing = lujings.OrderBy(e => e.LuDuans.Sum(ld => ld.ltc)).Take(Varias.LuJingCount).ToList();
var result = new List<LuJing>();
result.AddRange(busLujing);
foreach (var clj in carLujing)
{
//去重
if (!result.Any(lj => string.Join(",", lj.Nodes.Select(n => n.No)) == string.Join(",", clj.Nodes.Select(n => n.No))))
{
result.Add(clj);
}
}
#endregion
return result;
}
private void btOpen_Click(object sender, EventArgs e)
{
if (OD.ShowDialog() == DialogResult.OK && OD.FileName.Length > 0)
{
if (Util.DecompressRAR(OD.FileName, Application.StartupPath + "\\WinRar.exe", savePath))
{
tbFile.Text = OD.FileName;
btOK.Enabled = true;
}
}
}
private void btnDosyaSec_Click(object sender, EventArgs e)
{
if (OD.ShowDialog() == System.Windows.Forms.DialogResult.OK)//Dosya seçmek için
{
secilenDosya = OD.FileName;
yeni_Durum("Seçilen Dosya : " + secilenDosya);
btnGonder.Enabled = true;
txtPort.Enabled = true;
txtIP.Enabled = true;
}
}
public List <StudentViewModel> ListStudentLockByClass(int ClassID)
{
StudentTable = db.GetTable <Student>();
StudentParentTable = db.GetTable <StudentParent>();
StudentClassTable = db.GetTable <Student_Class>();
ClassTable = db.GetTable <Class>();
EthnicGroupTable = db.GetTable <EthnicGroup>();
LocationTable = db.GetTable <Location>();
ReligionTable = db.GetTable <Religion>();
PreferredTable = db.GetTable <Preferred>();
var query = from S in StudentTable
join SP in StudentParentTable
on S.StudentID equals SP.StudentID
into OD
from SP in OD.DefaultIfEmpty()
join SC in StudentClassTable
on S.StudentID equals SC.StudentID
join C in ClassTable
on SC.ClassID equals C.ClassID
join L in LocationTable
on S.LocationID equals L.LocationID
where SC.ClassID == ClassID && S.Status == false
select new StudentViewModel
{
StudentID = S.StudentID,
StudentCode = S.StudentCode,
FirstName = S.FirstName,
LastName = S.LastName,
HomeName = S.HomeName,
Birthday = S.Birthday,
DateStudy = S.DateStudy,
Gender = S.Gender,
AdressDetail = S.AdressDetail,
Hobby = S.Hobby,
Talen = S.Talent,
FatherName = SP.FatherName,
FatherJob = SP.FatherJob,
MotherName = SP.MotherName,
MotherJob = SP.MotherJob,
Password = SP.Password,
Image = S.Image == null ? null : S.Image.ToArray(),
Note = S.Note,
StudentClassNote = SC.Note,
Status = S.Status,
LocationID = S.LocationID,
LocationDetail = new LocationDAO().GetFullNameLocaion(S.LocationID),
ClassID = SC.ClassID,
ClassName = C.Name
};
List <StudentViewModel> list = query.ToList();
return(list);
}
public Ordered_Dish get_OrderedDish(int num)
{
Ordered_Dish od = new Ordered_Dish();
XElement OrderedDish_Element = (from OD in OrderedDishes_Root.Elements()
where Convert.ToInt32(OD.Element("OrderedDish_Number").Value) == num
select OD).First();
od.AmountSameDishes = int.Parse(OrderedDish_Element.Element("AmountSameDishes").Value);
od.DishNumber = int.Parse(OrderedDish_Element.Element("DishNumber").Value);
od.ODS = (OrderedDish_Situation)Enum.Parse(typeof(OrderedDish_Situation), (OrderedDish_Element.Element("OrderedDish_Situation").Value));
od.OrderedDish_Number = int.Parse(OrderedDish_Element.Element("OrderedDish_Number").Value);
od.OrderNumber = int.Parse(OrderedDish_Element.Element("OrderNumber").Value);
return(od);
}
public ActionResult Create(OD od)
{
if (ModelState.IsValid)
{
db.OD.AddObject(od);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_odnad = new SelectList(db.OD, "id_od", "Naziv", od.id_odnad);
ViewBag.id_voditelj = new SelectList(db.Zaposlenici.OrderBy(z => z.ImePrezime), "id_zaposlenici", "ImePrezime", od.id_voditelj);
ViewBag.id_IzvSur = new SelectList(db.Zaposlenici.OrderBy(z => z.ImePrezime), "id_zaposlenici", "ImePrezime", od.id_IzvSur);
return(View(od));
}
private void menuOpen_Click(object sender, EventArgs e)
{
//打开任务文件
if (OD.ShowDialog() == DialogResult.OK && OD.FileName.Length != 0)
{
if (Util.DecompressRAR(OD.FileName, Application.StartupPath + "\\WinRar.exe", Util.curPath)) //解压缩cur年报文件
{
if (NeedSetNB())
{
frmSet form1 = new frmSet(Util.comPath);
form1.ShowDialog();
curFilePath = OD.FileName;
}
}
RWOpened();
}
}
private void LoadILScriptAssemblyClick(object sender, EventArgs e)
{
var targetPath = sourcePath2.Text;
if (targetPath == "")
{
if (OD.ShowDialog() != DialogResult.OK)
{
return;
}
Properties.Settings.Default["assembly_path1"] = OD.FileName;
Properties.Settings.Default.Save();
sourcePath2.Text = targetPath = OD.FileName;
}
using (var testFs = File.Open(targetPath, FileMode.Open))
{
var module = ModuleDefinition.ReadModule(testFs);
foreach (var typeDefinition in module.Types)
{
foreach (var methodDefinition in typeDefinition.Methods)
{
foreach (var instruction in methodDefinition.Body.Instructions)
{
if (instruction.OpCode != OpCodes.Newobj || instruction.Previous == null ||
instruction.Previous.OpCode != OpCodes.Ldftn)
{
continue;
}
var type = instruction.Operand as MethodReference;
if (type == null ||
(!type.DeclaringType.Name.Contains("Action") &&
!type.DeclaringType.Name.Contains("Func")))
{
continue;
}
Print("[delegate register]" + type.DeclaringType.FullName);
LoadDelegateRegister(type.DeclaringType.FullName, type.DeclaringType);
}
}
}
}
}
public void GetAllPath()
{
var od = new OD()
{
Start = 3,
End = 5
};
var fullUri = string.Format($"{Environment.CurrentDirectory}\\OD.xlsx");
var result = ReadExcel.LuDuan(fullUri);
result = result.OrderBy(l => l.No).ToList();
var luduans = ReadExcel.LuduanAndPoint(result, fullUri);
var nodes = ReadExcel.Nodes(fullUri);
var result2 = GenarateLuJing.GetAllPath(od, luduans, nodes);
Assert.AreEqual(1, 1);
}
//
// GET: /OD/Edit/5
public ActionResult Edit(int id)
{
try
{
OD od = db.OD.Single(o => o.id_od == id);
var od1 = (from d in db.OD select new { d.id_od, Naziv = d.Oznaka + " " + d.Naziv }).OrderBy(d => d.Naziv);
ViewBag.id_odnad = new SelectList(od1, "id_od", "Naziv", od.id_odnad);
ViewBag.id_voditelj = new SelectList(db.Zaposlenici.OrderBy(z => z.ImePrezime), "id_zaposlenici", "ImePrezime", od.id_voditelj);
ViewBag.id_IzvSur = new SelectList(db.Zaposlenici.OrderBy(z => z.ImePrezime), "id_zaposlenici", "ImePrezime", od.id_IzvSur);
return(View(od));
}
catch (Exception ex)
{
return(Error(ex.ToString()));
}
}
private void btnLoadCompare_Click(object sender, EventArgs e)
{
if (File.Exists(txtCompare.Text))
{
OD.FileName = txtCompare.Text;
}
DialogResult dr = OD.ShowDialog(this);
if (dr == DialogResult.Cancel)
{
return;
}
compare.FileName = OD.FileName;
txtCompare.Text = OD.FileName;
lblCompareInfo.Text = String.Format("New File: House Type: {0}, House ID {1}, Items: {2}", compare.HouseType, compare.HouseID, compare.HouseItems.Rows.Count.ToString("#,###"));
if (source.FileLoaded)
{
Compare();
}
}
private void OnBtnLoad(object sender, EventArgs e)
{
if (txtPath.Text == "")
{
if (OD.ShowDialog() == DialogResult.OK)
{
Properties.Settings.Default["assembly_path"] = txtPath.Text = OD.FileName;
Properties.Settings.Default.Save();
}
else
{
return;
}
}
try
{
using (FileStream fs = new FileStream(txtPath.Text, FileMode.Open, FileAccess.Read))
{
var path = Path.GetDirectoryName(txtPath.Text);
var name = Path.GetFileNameWithoutExtension(txtPath.Text);
using (var fs2 = new System.IO.FileStream($"{path}\\{name}.pdb", FileMode.Open))
{
_app.LoadAssembly(fs, fs2, new Mono.Cecil.Pdb.PdbReaderProvider());
_isLoadAssembly = true;
}
ILRuntimeHelper.Init(_app);
_app.RegisterValueTypeBinder(typeof(TestVector3), new TestVector3Binder());
_app.RegisterValueTypeBinder(typeof(TestVectorStruct), new TestVectorStructBinder());
_app.RegisterValueTypeBinder(typeof(TestVectorStruct2), new TestVectorStruct2Binder());
LoadTest();
UpdateBtnState();
}
}
catch (Exception ex)
{
MessageBox.Show("[Error:]" + ex);
}
}
private void btnTK_SanPhamBanChay_Click(object sender, EventArgs e)
{
grvTK_SPBanChay.Visible = true;
using (DBKhoHangDataContext db = new DBKhoHangDataContext())
{
grvTK_SPBanChay.DataSource = from sp in db.HANGHOAs
join ctbh in db.CT_PHIEUXUATs
on sp.id_hanghoa equals ctbh.id_hanghoa
join bh in db.PHIEUXUATs on ctbh.id_phieuxuat equals bh.id_phieuxuat
where bh.ngayxuat >= dtpTK_NgayBatDau.Value && bh.ngayxuat <= dtp_NgayKetThuc.Value
group ctbh by new { ctbh.id_hanghoa, sp.tenhanghoa } into OD
select new
{
ID_Product = OD.Key.id_hanghoa,
Name_Product = OD.Key.tenhanghoa,
Quantity = OD.Sum(n => n.soluongxuat)
} into ODD
orderby ODD.Quantity descending
select ODD;
// grvTK_SPBanChay.DataSource = rs;
}
}
public void AddToOrder(Order order, OrderDetails orderDetails)
{
bool isOrderExist = false;
foreach (Order O in OrderList)
{
if (O.Equals(order))
{
isOrderExist = true;
}
}
if (isOrderExist)
{
bool first_time = true;
foreach (OrderDetails OD in order.DetailList)
{
if (OD.Equals(orderDetails))
{
first_time = false;
}
}
if (first_time)
{
order.DetailList.Add(orderDetails);
Console.WriteLine("添加成功");
}
else
{
Console.WriteLine("此订单已有该商品");
}
}
else
{
Console.WriteLine("不存在此订单");
}
}
public ActionResult Index()
{
try
{
string wp = new WindowsPrincipal((WindowsIdentity)HttpContext.User.Identity).Identity.Name;
Zaposlenici idzap = (from z in db.Zaposlenici where z.ad == wp select z).FirstOrDefault();
if (idzap == null)
{
// Redirect("../../Shared/Error.aspx");
return(Error("Niste prijavljeni na sistem"));
}
OD od = (from o in db.OD where o.id_voditelj == idzap.id_zaposlenici select o).FirstOrDefault();
if (od == null)
{
IOrderedQueryable <Telefonija> telefonija =
(from i in db.Telefonija.Include("Operateri").Include("Zaposlenici").Include("Tip_Telefona")
where i.Zaposlenici.ad == wp
orderby i.Zaposlenici.ImePrezime
select i);
return(View(telefonija.ToList()));
}
else
{
ObjectResult <Telefonija> telefonija = db.spPregledTelOD(idzap.id_zaposlenici);
return(View(telefonija.ToList()));
}
}
catch (Exception ex)
{
return(Error(ex.ToString()));
}
}
public void DeleteFromOrder(Order order, OrderDetails orderDetails)
{
bool isOrderExist = false;
foreach (Order O in OrderList)
{
if (O.Equals(order))
{
isOrderExist = true;
}
}
if (isOrderExist)
{
bool belongsTo = false;
foreach (OrderDetails OD in order.DetailList)
{
if (OD.Equals(orderDetails))
{
belongsTo = true;
}
}
if (belongsTo)
{
order.DetailList.Remove(orderDetails);
Console.WriteLine("成功删除");
}
else
{
Console.WriteLine("删除失败：该商品不属于此订单");
}
}
else
{
Console.WriteLine("不存在此订单");
}
}
