public void Remove()
{
DBaction db = new DBaction();
db.RemoveFailGroup(this.Id);
db.Close();
}
public void Rename()
{
DBaction db = new DBaction();
db.UpdateFailure(this.Id, this.Name);
db.Close();
}
public void UpdateFailureForFailrecord(int old, int newFail)
{
DBaction db = new DBaction();
db.UpdateFailureForFailRecord(old, newFail);
db.Close();
}
public void Rename(String oldName)
{
DBaction db = new DBaction();
db.UpdateFailure(oldName, this.Name);
db.Close();
}
//action
public void AddGroup()
{
DBaction db = new DBaction();
db.AddFailGroup(this.GroupName);
db.Close();
}
public void Remove(int id)
{
DBaction db = new DBaction();
db.RemoveFailRecord(id);
db.Close();
}
public void Add()
{
DBaction db = new DBaction();
db.AddFailure(this.Name, this.groupId);
db.Close();
}
public void Rename()
{
DBaction db = new DBaction();
db.UpdateFailGroup(this.Id, this.GroupName);
db.Close();
}
public void AddEquip(String name)
{
DBaction db = new DBaction();
db.AddEquipment(name);
db.Close();
}
public void RemoveEquip(int id)
{
DBaction db = new DBaction();
db.RemoveEquipment(id);
db.Close();
}
//action
public void AddLine()
{
DBaction db = new DBaction();
db.AddLine(this.lineId, this.lineName);
db.Close();
}
public void UpdateTimteResume()
{
DBaction db = new DBaction();
db.UpdateTimeResume();
db.Close();
}
public void UpdateStatus(String reporter, String comment)
{
DBaction db = new DBaction();
db.UpdateStatus(this.Id, this.status, reporter, comment);
db.Close();
}
public DataTable getEquipmentDataTable()
{
DBaction db = new DBaction();
DataTable dt = db.GetEquipDataTable();
db.Close();
return(dt);
}
public void UpdateLineName()
{
DBaction db = new DBaction();
db.UpdateLineName(this.lineId, this.lineName);
db.Close();
}
public void Remove()
{
DBaction db = new DBaction();
db.RemoveLine(this.lineId);
db.Close();
}
public DataTable GetFailAndGroup()
{
DBaction db = new DBaction();
DataTable result = db.getFailAndGroup();
db.Close();
return(result);
}
public String getFailGroupNameById(int id)
{
DBaction db = new DBaction();
String r = db.getFailGroupNameById(id);
db.Close();
return(r);
}
public int GetLastRecordId()
{
DBaction db = new DBaction();
int d = db.GetLastRecordId();
db.Close();
return(d);
}
public int QuickGetStatus(int id)
{
DBaction db = new DBaction();
int d = db.getStatus(id);
db.Close();
return(d);
}
public int GetDate()
{
DBaction db = new DBaction();
int d = db.GetDate(this.Id);
db.Close();
return(d);
}
public int GetCountFailByStatus(String l, int stt)
{
DBaction db = new DBaction();
int d = db.getCountFailByStatus(l, stt);
db.Close();
return(d);
}
public double GetSumDuration(String l, String from, String to)
{
DBaction db = new DBaction();
double d = db.getSumDuration(l, from, to);
db.Close();
return(d);
}
public List <Item> getSumfail(String fr, String to, String line)
{
DBaction db = new DBaction();
List <Item> kind = db.getSumFail(fr, to, line);
db.Close();
return(kind);
}
public String getFailGroup(String failName)
{
DBaction db = new DBaction();
String g = db.GetFailGroup(failName);
db.Close();
return(g);
}
public DataTable GetFailRecordList(String from, String to, String line, int stt)
{
DBaction db = new DBaction();
DataTable data = db.getFailRecord(from, to, line, stt);
db.Close();
return(data);
}
public bool changeDept()
{
bool result = false;
DBaction db = new DBaction();
result = (db.ChangeDept(this.opCode, this.dept) > 0) ? true : false;
db.Close();
return(result);
}
public List <String> getAllLine()
{
List <String> l = new List <string>();
DBaction db = new DBaction();
l = db.getAllLineCode();
db.Close();
return(l);
}
public bool changeEmail()
{
bool result = false;
DBaction db = new DBaction();
result = (db.ChangeEmail(this.opCode, this.email) > 0) ? true : false;
db.Close();
return(result);
}
public static DateTime current()
{
DateTime t = new DateTime();
DBaction db = new DBaction();
t = db.getCurrentTime();
db.Close();
return(t);
}