/// <summary>
/// Deprecated Method for adding a new object to the T_WQX_IMPORT_TRANSLATE EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToT_WQX_IMPORT_TRANSLATE(T_WQX_IMPORT_TRANSLATE t_WQX_IMPORT_TRANSLATE)
{
base.AddObject("T_WQX_IMPORT_TRANSLATE", t_WQX_IMPORT_TRANSLATE);
}
/// <summary>
/// Create a new T_WQX_IMPORT_TRANSLATE object.
/// </summary>
/// <param name="tRANSLATE_IDX">Initial value of the TRANSLATE_IDX property.</param>
/// <param name="oRG_ID">Initial value of the ORG_ID property.</param>
/// <param name="cOL_NAME">Initial value of the COL_NAME property.</param>
/// <param name="dATA_FROM">Initial value of the DATA_FROM property.</param>
public static T_WQX_IMPORT_TRANSLATE CreateT_WQX_IMPORT_TRANSLATE(global::System.Int32 tRANSLATE_IDX, global::System.String oRG_ID, global::System.String cOL_NAME, global::System.String dATA_FROM)
{
T_WQX_IMPORT_TRANSLATE t_WQX_IMPORT_TRANSLATE = new T_WQX_IMPORT_TRANSLATE();
t_WQX_IMPORT_TRANSLATE.TRANSLATE_IDX = tRANSLATE_IDX;
t_WQX_IMPORT_TRANSLATE.ORG_ID = oRG_ID;
t_WQX_IMPORT_TRANSLATE.COL_NAME = cOL_NAME;
t_WQX_IMPORT_TRANSLATE.DATA_FROM = dATA_FROM;
return t_WQX_IMPORT_TRANSLATE;
}
public static int InsertOrUpdateWQX_IMPORT_TRANSLATE(int? tRANSLATE_IDX, string oRG_ID, string cOL_NAME, string dATA_FROM, string dATA_TO, string cREATE_USER = "******")
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
Boolean insInd = false;
try
{
T_WQX_IMPORT_TRANSLATE a = null;
if (tRANSLATE_IDX != null)
a = (from c in ctx.T_WQX_IMPORT_TRANSLATE
where c.TRANSLATE_IDX == tRANSLATE_IDX
select c).FirstOrDefault();
if (a == null) //insert case
{
insInd = true;
a = new T_WQX_IMPORT_TRANSLATE();
}
if (oRG_ID != null) a.ORG_ID = oRG_ID;
if (cOL_NAME != null) a.COL_NAME = cOL_NAME;
if (dATA_FROM != null) a.DATA_FROM = dATA_FROM;
if (dATA_TO != null) a.DATA_TO = dATA_TO;
if (insInd) //insert case
{
a.CREATE_DT = DateTime.Now;
a.CREATE_USERID = cREATE_USER;
ctx.AddToT_WQX_IMPORT_TRANSLATE(a);
}
ctx.SaveChanges();
return a.TRANSLATE_IDX;
}
catch (Exception ex)
{
return 0;
}
}
}
