public bool DeleteToolInfo(string family_cd, string tool_cd)
{
TOOL_DIMENSION toolDimension = null;
try
{
toolDimension = (from c in DB.TOOL_DIMENSION
where c.FAMILY_CD == family_cd && c.TOOL_CD == tool_cd
select c).FirstOrDefault <TOOL_DIMENSION>();
if (toolDimension != null)
{
DB.TOOL_DIMENSION.DeleteOnSubmit(toolDimension);
DB.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex.LogException();
}
}
//public string buildQuery()
//{
// foreach (DataRow row in DtParaMeterData.ToTable().Rows)
// {
//}
public bool CheckToolCodeEsxists(string toolcode)
{
try
{
TOOL_DIMENSION ddOperMast = (from c in DB.TOOL_DIMENSION
where c.TOOL_CD == toolcode
// && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).SingleOrDefault <TOOL_DIMENSION>();
if (ddOperMast != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
ex.LogException();
// throw ex.LogException();
return(false);
}
}
public bool Save(DataTable dtSave, string familyCode)
{
bool blnAdd = false;
List <TOOL_DIMENSION> lstDimension = (from c in DB.TOOL_DIMENSION
where c.FAMILY_CD == familyCode
// && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).ToList <TOOL_DIMENSION>();
TOOL_DIMENSION updateDimension = null;
try
{
foreach (DataRow drRow in dtSave.Rows)
{
blnAdd = false;
updateDimension = (from c in lstDimension
where c.TOOL_CD.ToUpper().Trim() == drRow["TOOL_CD"].ToValueAsString().Trim().ToUpper()
// && ((Convert.ToBoolean(Convert.ToInt16(c.DELETE_FLAG)) == false) || (c.DELETE_FLAG == null))
select c).FirstOrDefault <TOOL_DIMENSION>();
if (updateDimension == null)
{
updateDimension = new TOOL_DIMENSION();
blnAdd = true;
updateDimension.ROWID = Guid.NewGuid();
}
updateDimension.FAMILY_CD = familyCode;
updateDimension.DESCRIPTION = drRow["DESCRIPTION"].ToValueAsString().Trim();
updateDimension.TOOL_CD = drRow["TOOL_CD"].ToValueAsString().Trim();
updateDimension.P001 = drRow["P001"].ToValueAsString().Trim();
updateDimension.P002 = drRow["P002"].ToValueAsString().Trim();
updateDimension.P003 = drRow["P003"].ToValueAsString().Trim();
updateDimension.P004 = drRow["P004"].ToValueAsString().Trim();
updateDimension.P005 = drRow["P005"].ToValueAsString().Trim();
updateDimension.P006 = drRow["P006"].ToValueAsString().Trim();
updateDimension.P007 = drRow["P007"].ToValueAsString().Trim();
updateDimension.P008 = drRow["P008"].ToValueAsString().Trim();
updateDimension.P009 = drRow["P009"].ToValueAsString().Trim();
updateDimension.P010 = drRow["P010"].ToValueAsString().Trim();
updateDimension.P011 = drRow["P011"].ToValueAsString().Trim();
updateDimension.P012 = drRow["P012"].ToValueAsString().Trim();
updateDimension.P013 = drRow["P013"].ToValueAsString().Trim();
updateDimension.P014 = drRow["P014"].ToValueAsString().Trim();
updateDimension.P015 = drRow["P015"].ToValueAsString().Trim();
updateDimension.P016 = drRow["P016"].ToValueAsString().Trim();
updateDimension.P017 = drRow["P017"].ToValueAsString().Trim();
updateDimension.P018 = drRow["P018"].ToValueAsString().Trim();
updateDimension.P019 = drRow["P019"].ToValueAsString().Trim();
updateDimension.P020 = drRow["P020"].ToValueAsString().Trim();
updateDimension.P021 = drRow["P021"].ToValueAsString().Trim();
updateDimension.P022 = drRow["P022"].ToValueAsString().Trim();
updateDimension.P023 = drRow["P023"].ToValueAsString().Trim();
updateDimension.P024 = drRow["P024"].ToValueAsString().Trim();
updateDimension.P025 = drRow["P025"].ToValueAsString().Trim();
updateDimension.P026 = drRow["P026"].ToValueAsString().Trim();
updateDimension.P027 = drRow["P027"].ToValueAsString().Trim();
updateDimension.P028 = drRow["P028"].ToValueAsString().Trim();
updateDimension.P029 = drRow["P029"].ToValueAsString().Trim();
updateDimension.P030 = drRow["P030"].ToValueAsString().Trim();
updateDimension.P031 = drRow["P031"].ToValueAsString().Trim();
updateDimension.P032 = drRow["P032"].ToValueAsString().Trim();
updateDimension.P033 = drRow["P033"].ToValueAsString().Trim();
updateDimension.P034 = drRow["P034"].ToValueAsString().Trim();
updateDimension.P035 = drRow["P035"].ToValueAsString().Trim();
updateDimension.P036 = drRow["P036"].ToValueAsString().Trim();
updateDimension.P037 = drRow["P037"].ToValueAsString().Trim();
updateDimension.P038 = drRow["P038"].ToValueAsString().Trim();
updateDimension.P039 = drRow["P039"].ToValueAsString().Trim();
updateDimension.P040 = drRow["P040"].ToValueAsString().Trim();
updateDimension.P041 = drRow["P041"].ToValueAsString().Trim();
updateDimension.P042 = drRow["P042"].ToValueAsString().Trim();
updateDimension.P043 = drRow["P043"].ToValueAsString().Trim();
updateDimension.P044 = drRow["P044"].ToValueAsString().Trim();
updateDimension.P045 = drRow["P045"].ToValueAsString().Trim();
updateDimension.P046 = drRow["P046"].ToValueAsString().Trim();
updateDimension.P047 = drRow["P047"].ToValueAsString().Trim();
updateDimension.P048 = drRow["P048"].ToValueAsString().Trim();
updateDimension.P049 = drRow["P049"].ToValueAsString().Trim();
updateDimension.P050 = drRow["P050"].ToValueAsString().Trim();
updateDimension.S001 = drRow["S001"].ToValueAsString().Trim();
updateDimension.S002 = drRow["S002"].ToValueAsString().Trim();
updateDimension.S003 = drRow["S003"].ToValueAsString().Trim();
updateDimension.S004 = drRow["S004"].ToValueAsString().Trim();
updateDimension.S005 = drRow["S005"].ToValueAsString().Trim();
updateDimension.S006 = drRow["S006"].ToValueAsString().Trim();
updateDimension.S007 = drRow["S007"].ToValueAsString().Trim();
updateDimension.S008 = drRow["S008"].ToValueAsString().Trim();
updateDimension.S009 = drRow["S009"].ToValueAsString().Trim();
updateDimension.S010 = drRow["S010"].ToValueAsString().Trim();
if (blnAdd == true)
{
DB.TOOL_DIMENSION.InsertOnSubmit(updateDimension);
}
DB.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex.LogException();
}
}
