public bool GetGrinMachine(GrinmachineModel grinMachine) { try { DDGRINDING_MAC ddnloc = (from o in DB.DDGRINDING_MAC where o.COST_CENT_CODE == grinMachine.COST_CENT_CODE select o).FirstOrDefault <DDGRINDING_MAC>(); if (ddnloc != null) { grinMachine.MIN_PROD_DIA = ddnloc.MIN_PROD_DIA; grinMachine.MAX_PROD_DIA = ddnloc.MAX_PROD_DIA; grinMachine.MAX_LEN_IN_PLUNGE = ddnloc.MAX_LEN_IN_PLUNGE; grinMachine.MAX_GWHEEL_OD = ddnloc.MAX_GWHEEL_OD; grinMachine.MAX_GWHEEL_THICKNESS = ddnloc.MAX_GWHEEL_THICKNESS; grinMachine.GWHEEL_BORE = ddnloc.GWHEEL_BORE; grinMachine.MAX_CWHEEL_OD = ddnloc.MAX_CWHEEL_OD; grinMachine.CWHEEL_THICKNESS = ddnloc.CWHEEL_THICKNESS; grinMachine.CWHEEL_BORE = ddnloc.CWHEEL_BORE; grinMachine.MAX_WHEEL_TILT = ddnloc.MAX_WHEEL_TILT; grinMachine.GWHEEL_CAM_REF_LEN = ddnloc.GWHEEL_CAM_REF_LEN; grinMachine.CWHEEL_CAM_REF_LEN = ddnloc.CWHEEL_CAM_REF_LEN; grinMachine.GWHEEL_CAM_LEN = ddnloc.GWHEEL_CAM_LEN; grinMachine.CWHEEL_CAM_LENGTH = ddnloc.CWHEEL_CAM_LENGTH; grinMachine.AUTO_DRESSING = ddnloc.AUTO_DRESSING; grinMachine.FEED_SYSTEM = ddnloc.FEED_SYSTEM; return(true); } else { return(true); } } catch (Exception ex) { throw ex.LogException(); } }
public bool UpdateGrinMachine(GrinmachineModel grinMachine) { string mode = ""; bool _status = false; DDGRINDING_MAC ddnloc = (from o in DB.DDGRINDING_MAC where o.COST_CENT_CODE == grinMachine.COST_CENT_CODE select o).FirstOrDefault <DDGRINDING_MAC>(); try { if (ddnloc == null) { ddnloc = new DDGRINDING_MAC(); mode = "New"; ddnloc.COST_CENT_CODE = grinMachine.COST_CENT_CODE; } ddnloc.MIN_PROD_DIA = grinMachine.MIN_PROD_DIA; ddnloc.MAX_PROD_DIA = grinMachine.MAX_PROD_DIA; ddnloc.MAX_LEN_IN_PLUNGE = grinMachine.MAX_LEN_IN_PLUNGE; ddnloc.MAX_GWHEEL_OD = grinMachine.MAX_GWHEEL_OD; ddnloc.MAX_GWHEEL_THICKNESS = grinMachine.MAX_GWHEEL_THICKNESS; ddnloc.GWHEEL_BORE = grinMachine.GWHEEL_BORE; ddnloc.MAX_CWHEEL_OD = grinMachine.MAX_CWHEEL_OD; ddnloc.CWHEEL_THICKNESS = grinMachine.CWHEEL_THICKNESS; ddnloc.CWHEEL_BORE = grinMachine.CWHEEL_BORE; ddnloc.MAX_WHEEL_TILT = grinMachine.MAX_WHEEL_TILT; ddnloc.GWHEEL_CAM_REF_LEN = grinMachine.GWHEEL_CAM_REF_LEN; ddnloc.CWHEEL_CAM_REF_LEN = grinMachine.CWHEEL_CAM_REF_LEN; ddnloc.GWHEEL_CAM_LEN = grinMachine.GWHEEL_CAM_LEN; ddnloc.CWHEEL_CAM_LENGTH = grinMachine.CWHEEL_CAM_LENGTH; ddnloc.AUTO_DRESSING = grinMachine.AUTO_DRESSING; ddnloc.FEED_SYSTEM = grinMachine.FEED_SYSTEM; if (mode == "New") { ddnloc.ROWID = Guid.NewGuid(); DB.DDGRINDING_MAC.InsertOnSubmit(ddnloc); } DB.SubmitChanges(); ddnloc = null; _status = true; } catch (System.Data.Linq.ChangeConflictException) { DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges); } catch (Exception ex) { ex.LogException(); if (mode == "New") { DB.DDGRINDING_MAC.DeleteOnSubmit(ddnloc); } else { DB.DDGRINDING_MAC.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddnloc); } _status = false; } return(_status); }