public void Add() { if(Id == 0) { try { Dictionary<string, object> param = new Dictionary<string, object> { }; param.Add("employee", EmployeeId); param.Add("machine", StationId); param.Add("date", TaskDate); Database db = new Database("addTask", param); List<Dictionary<string, object>> data = db.FetchProcedure(); jobId = (int)data[0]["id"]; } catch { // Error occur during Database processing } } }
public static List<Order> GetOrders(int id) { Database db = new Database("getOrder"); db.Bind("id", id); List<Dictionary<string, object>> data = db.FetchProcedure(); if (data != null) { List<Order> orders = new List<Order> { }; foreach (Dictionary<string, object> item in data) { int oid = (int)item["id"]; int cid = (int)item["customerId"]; DateTime oDate = (DateTime)item["orderDate"]; DateTime eDate = (DateTime)item["expectDate"]; DateTime? dDate = item["deliverDate"] as DateTime?; orders.Add(new Order(oid, cid, oDate, eDate, dDate)); } return orders; } else { return null; } }
private void Load() { Database db = new Database("getItemProp"); db.Bind("id", itemId); List<Dictionary<string,object>> datalist = db.FetchProcedure(); if(datalist != null) { foreach (Dictionary<string,object> item in datalist) { int id = (int)item["machineId"]; int num = (int)item["amount"]; machines.Add(id, num); } } }
public static List<OrderLine> GetOrderLine(int order) { try { Database db = new Database("getOrderLine"); db.Bind("id", order); List<Dictionary<string,object>> datalist = db.FetchProcedure(); if(datalist != null) { List<OrderLine> items = new List<OrderLine> { }; foreach(Dictionary<string, object> item in datalist) { int oid = (int)item["orderId"]; int iid = (int)item["itemId"]; int num = (int)item["quantity"]; items.Add(new OrderLine(oid, iid, num, true)); } return items; } else { return null; } } catch(Exception exc) { Log.Record(exc); return null; } }