public bool GetThreadRollingMachine(ThreadRollingModel threadrolling)
{
try
{
DDFLAT_THREAD_ROLL_MAC ddRolling = (from o in DB.DDFLAT_THREAD_ROLL_MAC
where o.COST_CENT_CODE == threadrolling.COST_CENT_CODE
select o).FirstOrDefault <DDFLAT_THREAD_ROLL_MAC>();
if (ddRolling != null)
{
threadrolling.COST_CENT_CODE = ddRolling.COST_CENT_CODE;
threadrolling.MAX_THREAD_DIA = ddRolling.MAX_THREAD_DIA;
threadrolling.MAX_THREAD_LEN = ddRolling.MAX_THREAD_LEN;
threadrolling.MAX_SHANK_LEN = ddRolling.MAX_SHANK_LEN;
threadrolling.MOVING_DIE_LEN = ddRolling.MOVING_DIE_LEN;
threadrolling.MOVING_DIE_WIDTH = ddRolling.MOVING_DIE_WIDTH;
threadrolling.MOVING_DIE_HEIGHT = ddRolling.MOVING_DIE_HEIGHT;
threadrolling.FIXED_DIE_LEN = ddRolling.FIXED_DIE_LEN;
threadrolling.FIXED_DIE_WIDTH = ddRolling.FIXED_DIE_WIDTH;
threadrolling.FIXED_DIE_HEIGHT = ddRolling.FIXED_DIE_HEIGHT;
threadrolling.DIE_POCKET_DEPTH = ddRolling.DIE_POCKET_DEPTH;
threadrolling.MAX_HARDNESS = ddRolling.MAX_HARDNESS;
threadrolling.MIN_HARDNESS = ddRolling.MIN_HARDNESS;
threadrolling.COOLANT = ddRolling.COOLANT;
threadrolling.FEED_METHOD = ddRolling.FEED_METHOD;
threadrolling.FEEDING_MECHANISH = ddRolling.FEEDING_MECHANISH;
threadrolling.MOTOR_POWER = ddRolling.MOTOR_POWER;
threadrolling.REMARKS = ddRolling.REMARKS;
return(true);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex.LogException();
}
}
public bool UpdateThreadRollingMachine(ThreadRollingModel threadrolling)
{
string mode = "";
bool _status = false;
DDFLAT_THREAD_ROLL_MAC ddRolling = (from o in DB.DDFLAT_THREAD_ROLL_MAC
where o.COST_CENT_CODE == threadrolling.COST_CENT_CODE
select o).SingleOrDefault <DDFLAT_THREAD_ROLL_MAC>();
try
{
if (ddRolling == null)
{
ddRolling = new DDFLAT_THREAD_ROLL_MAC();
mode = "New";
ddRolling.COST_CENT_CODE = threadrolling.COST_CENT_CODE;
}
ddRolling.COST_CENT_CODE = threadrolling.COST_CENT_CODE;
ddRolling.MAX_THREAD_DIA = threadrolling.MAX_THREAD_DIA;
ddRolling.MAX_THREAD_LEN = threadrolling.MAX_THREAD_LEN;
ddRolling.MAX_SHANK_LEN = threadrolling.MAX_SHANK_LEN;
ddRolling.MOVING_DIE_LEN = threadrolling.MOVING_DIE_LEN;
ddRolling.MOVING_DIE_WIDTH = threadrolling.MOVING_DIE_WIDTH;
ddRolling.MOVING_DIE_HEIGHT = threadrolling.MOVING_DIE_HEIGHT;
ddRolling.FIXED_DIE_LEN = threadrolling.FIXED_DIE_LEN;
ddRolling.FIXED_DIE_WIDTH = threadrolling.FIXED_DIE_WIDTH;
ddRolling.FIXED_DIE_HEIGHT = threadrolling.FIXED_DIE_HEIGHT;
ddRolling.DIE_POCKET_DEPTH = threadrolling.DIE_POCKET_DEPTH;
ddRolling.MAX_HARDNESS = threadrolling.MAX_HARDNESS;
ddRolling.MIN_HARDNESS = threadrolling.MIN_HARDNESS;
ddRolling.COOLANT = threadrolling.COOLANT;
ddRolling.FEED_METHOD = threadrolling.FEED_METHOD;
ddRolling.FEEDING_MECHANISH = threadrolling.FEEDING_MECHANISH;
ddRolling.MOTOR_POWER = threadrolling.MOTOR_POWER;
ddRolling.REMARKS = threadrolling.REMARKS;
if (mode == "New")
{
ddRolling.ROWID = Guid.NewGuid();
DB.DDFLAT_THREAD_ROLL_MAC.InsertOnSubmit(ddRolling);
}
DB.SubmitChanges();
ddRolling = 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.DDFLAT_THREAD_ROLL_MAC.DeleteOnSubmit(ddRolling);
}
else
{
DB.DDFLAT_THREAD_ROLL_MAC.Context.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, ddRolling);
}
}
return(_status);
}
