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