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(); } }