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