public static int DeleteT_WQX_REF_CHAR_ORG(string orgName, string charName)
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
try
{
T_WQX_REF_CHAR_ORG r = new T_WQX_REF_CHAR_ORG();
r = (from c in ctx.T_WQX_REF_CHAR_ORG
where c.ORG_ID == orgName
&& c.CHAR_NAME == charName
select c).FirstOrDefault();
ctx.DeleteObject(r);
ctx.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)
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
try
{
Boolean insInd = true;
T_WQX_REF_CHAR_ORG a = new T_WQX_REF_CHAR_ORG();
if (ctx.T_WQX_REF_CHAR_ORG.Any(o => o.CHAR_NAME == cHAR_NAME && o.ORG_ID == oRG_NAME))
{
//update case
a = (from c in ctx.T_WQX_REF_CHAR_ORG
where c.CHAR_NAME == cHAR_NAME
&& c.ORG_ID == oRG_NAME
select c).FirstOrDefault();
insInd = false;
}
a.CHAR_NAME = cHAR_NAME;
a.ORG_ID = oRG_NAME;
if (dEFAULT_DETECT_LIMIT != null) a.DEFAULT_DETECT_LIMIT = dEFAULT_DETECT_LIMIT;
if (dEFAULT_UNIT != null) a.DEFAULT_UNIT = dEFAULT_UNIT;
if (dEFAULT_ANAL_METHOD_IDX != null) a.DEFAULT_ANAL_METHOD_IDX = dEFAULT_ANAL_METHOD_IDX;
if (dEFAULT_SAMP_FRACTION != null) a.DEFAULT_SAMP_FRACTION = dEFAULT_SAMP_FRACTION;
if (dEFAULT_RESULT_STATUS != null) a.DEFAULT_RESULT_STATUS = dEFAULT_RESULT_STATUS;
if (dEFAULT_RESULT_VALUE_TYPE != null) a.DEFAULT_RESULT_VALUE_TYPE = dEFAULT_RESULT_VALUE_TYPE;
if (insInd) //insert case
{
a.CREATE_DT = System.DateTime.Now;
a.CREATE_USERID = cREATE_USER_ID;
ctx.AddToT_WQX_REF_CHAR_ORG(a);
}
ctx.SaveChanges();
return 1;
}
catch (Exception ex)
{
return 0;
}
}
}
/// <summary>
/// Create a new T_WQX_REF_CHAR_ORG object.
/// </summary>
/// <param name="cHAR_NAME">Initial value of the CHAR_NAME property.</param>
/// <param name="oRG_ID">Initial value of the ORG_ID property.</param>
public static T_WQX_REF_CHAR_ORG CreateT_WQX_REF_CHAR_ORG(global::System.String cHAR_NAME, global::System.String oRG_ID)
{
T_WQX_REF_CHAR_ORG t_WQX_REF_CHAR_ORG = new T_WQX_REF_CHAR_ORG();
t_WQX_REF_CHAR_ORG.CHAR_NAME = cHAR_NAME;
t_WQX_REF_CHAR_ORG.ORG_ID = oRG_ID;
return t_WQX_REF_CHAR_ORG;
}
/// <summary>
/// Deprecated Method for adding a new object to the T_WQX_REF_CHAR_ORG EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToT_WQX_REF_CHAR_ORG(T_WQX_REF_CHAR_ORG t_WQX_REF_CHAR_ORG)
{
base.AddObject("T_WQX_REF_CHAR_ORG", t_WQX_REF_CHAR_ORG);
}
