コード例 #1
0
 /// <summary>
 /// Deprecated Method for adding a new object to the T_ATTAINS_ASSESS_UNITS_MLOC EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToT_ATTAINS_ASSESS_UNITS_MLOC(T_ATTAINS_ASSESS_UNITS_MLOC t_ATTAINS_ASSESS_UNITS_MLOC)
 {
     base.AddObject("T_ATTAINS_ASSESS_UNITS_MLOC", t_ATTAINS_ASSESS_UNITS_MLOC);
 }
コード例 #2
0
 /// <summary>
 /// Create a new T_ATTAINS_ASSESS_UNITS_MLOC object.
 /// </summary>
 /// <param name="aTTAINS_ASSESS_UNIT_IDX">Initial value of the ATTAINS_ASSESS_UNIT_IDX property.</param>
 /// <param name="mONLOC_IDX">Initial value of the MONLOC_IDX property.</param>
 public static T_ATTAINS_ASSESS_UNITS_MLOC CreateT_ATTAINS_ASSESS_UNITS_MLOC(global::System.Int32 aTTAINS_ASSESS_UNIT_IDX, global::System.Int32 mONLOC_IDX)
 {
     T_ATTAINS_ASSESS_UNITS_MLOC t_ATTAINS_ASSESS_UNITS_MLOC = new T_ATTAINS_ASSESS_UNITS_MLOC();
     t_ATTAINS_ASSESS_UNITS_MLOC.ATTAINS_ASSESS_UNIT_IDX = aTTAINS_ASSESS_UNIT_IDX;
     t_ATTAINS_ASSESS_UNITS_MLOC.MONLOC_IDX = mONLOC_IDX;
     return t_ATTAINS_ASSESS_UNITS_MLOC;
 }
コード例 #3
0
        //***************************** ATTAINS_ASSESS_UNITS_MLOC **************************************
        public static int InsertOrUpdateATTAINS_ASSESS_UNITS_MLOC(int aSSESS_UNIT_IDX, int mONLOC_IDX, String cREATE_USER = "******")
        {
            using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
            {
                Boolean insInd = false;
                try
                {
                    T_ATTAINS_ASSESS_UNITS_MLOC a = (from c in ctx.T_ATTAINS_ASSESS_UNITS_MLOC
                         where c.ATTAINS_ASSESS_UNIT_IDX == aSSESS_UNIT_IDX
                         && c.MONLOC_IDX == mONLOC_IDX
                         select c).FirstOrDefault();

                    if (a == null)
                    {
                        a = new T_ATTAINS_ASSESS_UNITS_MLOC();
                        insInd = true;
                    }

                    a.ATTAINS_ASSESS_UNIT_IDX = aSSESS_UNIT_IDX;
                    a.MONLOC_IDX = mONLOC_IDX;

                    if (insInd) //insert case
                    {
                        a.CREATE_USERID = cREATE_USER.ToUpper();
                        a.CREATE_DT = System.DateTime.Now;
                        ctx.AddToT_ATTAINS_ASSESS_UNITS_MLOC(a);
                    }

                    ctx.SaveChanges();

                    return 1;
                }
                catch (Exception ex)
                {
                    return 0;
                }
            }
        }