public bool GetCopyTurningMac(CopyTurningMacModel copyturning)
{
try
{
DDCOPY_TURN_MAC ddRolling = (from o in DB.DDCOPY_TURN_MAC
where o.COST_CENT_CODE == copyturning.COST_CENT_CODE
select o).SingleOrDefault <DDCOPY_TURN_MAC>();
if (ddRolling != null)
{
copyturning.MACHINE_TYPE = ddRolling.MACHINE_TYPE;
copyturning.WORKHOLDER_TYPE = ddRolling.WORKHOLDER_TYPE;
copyturning.MAX_MANDREL_LEN = ddRolling.MAX_MANDREL_LEN.ToString().ToDecimalValue();
copyturning.MIN_PROD_DIA = ddRolling.MIN_PROD_DIA.ToString().ToDecimalValue();
copyturning.MAX_PROD_DIA = ddRolling.MAX_PROD_DIA.ToString().ToDecimalValue();
copyturning.MAX_PROD_LEN = ddRolling.MAX_PROD_LEN.ToString().ToDecimalValue();
copyturning.MIN_PROD_LEN = ddRolling.MIN_PROD_LEN.ToString().ToDecimalValue();
copyturning.SPINDLE_SPEED = ddRolling.SPINDLE_SPEED.ToString().ToDecimalValue();
copyturning.FEED_RESTRICTIONS = ddRolling.FEED_RESTRICTIONS;
copyturning.TURRET_STATIONS = ddRolling.TURRET_STATIONS.ToString().ToDecimalValue();
copyturning.COOLANT = ddRolling.COOLANT;
return(true);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex.LogException();
}
}
public bool UpdateCopyTurningMac(CopyTurningMacModel copyturning)
{
string mode = "";
bool _status = false;
DDCOPY_TURN_MAC ddRolling = new DDCOPY_TURN_MAC();
try
{
ddRolling = (from o in DB.DDCOPY_TURN_MAC
where o.COST_CENT_CODE == copyturning.COST_CENT_CODE
select o).SingleOrDefault <DDCOPY_TURN_MAC>();
if (ddRolling == null)
{
ddRolling = new DDCOPY_TURN_MAC();
mode = "New";
ddRolling.COST_CENT_CODE = copyturning.COST_CENT_CODE;
}
ddRolling.MACHINE_TYPE = copyturning.MACHINE_TYPE;
ddRolling.WORKHOLDER_TYPE = copyturning.WORKHOLDER_TYPE;
ddRolling.MAX_MANDREL_LEN = copyturning.MAX_MANDREL_LEN.ToString().ToDecimalValue();
ddRolling.MIN_PROD_DIA = copyturning.MIN_PROD_DIA.ToString().ToDecimalValue();
ddRolling.MAX_PROD_DIA = copyturning.MAX_PROD_DIA.ToString().ToDecimalValue();
ddRolling.MAX_PROD_LEN = copyturning.MAX_PROD_LEN.ToString().ToDecimalValue();
ddRolling.MIN_PROD_LEN = copyturning.MIN_PROD_LEN.ToString().ToDecimalValue();
ddRolling.SPINDLE_SPEED = copyturning.SPINDLE_SPEED.ToString().ToDecimalValue();
ddRolling.FEED_RESTRICTIONS = copyturning.FEED_RESTRICTIONS;
ddRolling.TURRET_STATIONS = copyturning.TURRET_STATIONS.ToString().ToDecimalValue();
ddRolling.COOLANT = copyturning.COOLANT;
if (mode == "New")
{
ddRolling.ROWID = Guid.NewGuid();
DB.DDCOPY_TURN_MAC.InsertOnSubmit(ddRolling);
}
DB.SubmitChanges();
_status = true;
}
catch (System.Data.Linq.ChangeConflictException)
{
if (mode == "New")
{
DB.DDCOPY_TURN_MAC.DeleteOnSubmit(ddRolling);
}
else if (mode != "New")
{
DB.DDCOPY_TURN_MAC.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddRolling);
}
DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.KeepChanges);
}
catch (Exception ex)
{
ex.LogException();
if (mode == "New")
{
DB.DDCOPY_TURN_MAC.DeleteOnSubmit(ddRolling);
}
else if (mode != "New")
{
DB.DDCOPY_TURN_MAC.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddRolling);
}
DB.ChangeConflicts.ResolveAll(System.Data.Linq.RefreshMode.OverwriteCurrentValues);
}
return(_status);
}
