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