public void Update(bll_subRoute bllcreate) { try { cmd = "EXEC Update_subRoute '" + bllcreate.SUBROUTEID + "','" + bllcreate.SUBROUTECODE + "' ,'" + bllcreate.SUBROUTENAMEBAN + "' ,'" + bllcreate.SUBROUTENAME + "' ,'" + bllcreate.ROUTENAME + "' ,'" + bllcreate.PRESS + "' ,'" + bllcreate.SORTINGORDER + "' ,'" + bllcreate.STARTPOINT + "' ,'" + bllcreate.ENDPOINT + "' ,'" + bllcreate.DEPARTTIME + "' ,'" + bllcreate.ARRIVTIME + "' ,'" + bllcreate.LOCATION + "' ,'" + bllcreate.AUDITUSER + "' ,'" + bllcreate.CREATEDATE + "' "; dataProvider.ExecuteCommand(cmd); } catch (Exception e) { } }
public void Delete(bll_subRoute bllcreate) { try { cmd = "EXEC Delete_subRoute '" + bllcreate.SUBROUTEID + "'"; dataProvider.ExecuteCommand(cmd); } catch (Exception e) { //Use label to print an error >> lbl.text = e.Message; } }