public static int DeleteT_WQX_REF_CHAR_ORG(string orgName, string charName) { try { TWqxRefCharOrg r = new TWqxRefCharOrg(); r = (from c in _db.TWqxRefCharOrg where c.OrgId == orgName && c.CharName == charName select c).FirstOrDefault(); _db.TWqxRefCharOrg.Remove(r); _db.SaveChanges(); return(1); } catch { return(0); } }
public static int InsertOrUpdateT_WQX_REF_CHAR_ORG(global::System.String cHAR_NAME, global::System.String oRG_NAME, global::System.String cREATE_USER_ID, string dEFAULT_DETECT_LIMIT, string dEFAULT_UNIT, int?dEFAULT_ANAL_METHOD_IDX, string dEFAULT_SAMP_FRACTION, string dEFAULT_RESULT_STATUS, string dEFAULT_RESULT_VALUE_TYPE, string dEFAULT_LOWER_QUANT_LIMIT, string dEFAULT_UPPER_QUANT_LIMIT) { try { Boolean insInd = true; TWqxRefCharOrg a = new TWqxRefCharOrg(); if (_db.TWqxRefCharOrg.Any(o => o.CharName == cHAR_NAME && o.OrgId == oRG_NAME)) { //update case a = (from c in _db.TWqxRefCharOrg where c.CharName == cHAR_NAME && c.OrgId == oRG_NAME select c).FirstOrDefault(); insInd = false; } a.CharName = cHAR_NAME; a.OrgId = oRG_NAME; if (dEFAULT_DETECT_LIMIT != null) { a.DefaultDetectLimit = dEFAULT_DETECT_LIMIT; } if (dEFAULT_LOWER_QUANT_LIMIT != null) { a.DefaultLowerQuantLimit = dEFAULT_LOWER_QUANT_LIMIT; } if (dEFAULT_UPPER_QUANT_LIMIT != null) { a.DefaultUpperQuantLimit = dEFAULT_UPPER_QUANT_LIMIT; } if (dEFAULT_UNIT != null) { a.DefaultUnit = dEFAULT_UNIT; } if (dEFAULT_ANAL_METHOD_IDX != null) { a.DefaultAnalMethodIdx = dEFAULT_ANAL_METHOD_IDX; } if (dEFAULT_SAMP_FRACTION != null) { a.DefaultSampFraction = dEFAULT_SAMP_FRACTION; } if (dEFAULT_RESULT_STATUS != null) { a.DefaultResultStatus = dEFAULT_RESULT_STATUS; } if (dEFAULT_RESULT_VALUE_TYPE != null) { a.DefaultResultValueType = dEFAULT_RESULT_VALUE_TYPE; } if (insInd) //insert case { a.CreateDt = System.DateTime.Now; a.CreateUserid = cREATE_USER_ID; _db.TWqxRefCharOrg.Add(a); } else { _db.TWqxRefCharOrg.Update(a); } _db.SaveChanges(); return(1); } catch (Exception ex) { return(0); } }