public static int DeleteT_OE_ColumnConfig(int columnConfig_IDX) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_OE_COLUMNCONFIG r = new T_OE_COLUMNCONFIG(); r = (from c in ctx.T_OE_COLUMNCONFIG where c.COLUMNCONFIG_IDX == columnConfig_IDX select c).FirstOrDefault(); ctx.DeleteObject(r); ctx.SaveChanges(); return 1; } catch { return 0; } } }
public static int InsertOrUpdateT_OE_ColumnConfig(global::System.Int32? cOLUMNCONFIG_IDX, global::System.String cOLUMN_NAME, global::System.String uNIT, global::System.Double mAXVALUE, global::System.Double mINVALUE, global::System.Boolean cOLUMNDONTSEND) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { Boolean insInd = false; try { T_OE_COLUMNCONFIG a = new T_OE_COLUMNCONFIG(); if (cOLUMNCONFIG_IDX != null) a = (from c in ctx.T_OE_COLUMNCONFIG where c.COLUMNCONFIG_IDX == cOLUMNCONFIG_IDX select c).FirstOrDefault(); if (cOLUMNCONFIG_IDX == null) //insert case { a = new T_OE_COLUMNCONFIG(); insInd = true; } if (cOLUMN_NAME != null) a.COLUMN_NAME = cOLUMN_NAME; if (uNIT != null) a.UNIT = uNIT; a.MAX_VALUE = mAXVALUE; a.MIN_VALUE = mINVALUE; a.COLUMN_DONT_SEND = cOLUMNDONTSEND; if (insInd) //insert case { // a.CREATE_USERID = cREATE_USER.ToUpper(); // a.CREATE_DT = System.DateTime.Now; ctx.AddToT_OE_COLUMNCONFIG(a); } else { // a.UPDATE_USERID = cREATE_USER.ToUpper(); // a.UPDATE_DT = System.DateTime.Now; } ctx.SaveChanges(); return a.COLUMNCONFIG_IDX; } catch (Exception ex) { return 0; } } }
/// <summary> /// Create a new T_OE_COLUMNCONFIG object. /// </summary> /// <param name="cOLUMNCONFIG_IDX">Initial value of the COLUMNCONFIG_IDX property.</param> public static T_OE_COLUMNCONFIG CreateT_OE_COLUMNCONFIG(global::System.Int32 cOLUMNCONFIG_IDX) { T_OE_COLUMNCONFIG t_OE_COLUMNCONFIG = new T_OE_COLUMNCONFIG(); t_OE_COLUMNCONFIG.COLUMNCONFIG_IDX = cOLUMNCONFIG_IDX; return t_OE_COLUMNCONFIG; }
/// <summary> /// Deprecated Method for adding a new object to the T_OE_COLUMNCONFIG EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToT_OE_COLUMNCONFIG(T_OE_COLUMNCONFIG t_OE_COLUMNCONFIG) { base.AddObject("T_OE_COLUMNCONFIG", t_OE_COLUMNCONFIG); }