public static int UpdateT_WQX_REF_DATAByIDX(global::System.Int32 IDX, global::System.String vALUE, global::System.String tEXT, Boolean ActInd) { try { TWqxRefData a = new TWqxRefData(); a = (from c in _db.TWqxRefData where c.RefDataIdx == IDX select c).FirstOrDefault(); if (vALUE != null) { a.Value = vALUE; } if (tEXT != null) { a.Text = Utils.SubStringPlus(tEXT, 0, 200); } a.UpdateDt = System.DateTime.Now; a.ActInd = ActInd; _db.TWqxRefData.Update(a); _db.SaveChanges(); return(1); } catch (Exception ex) { return(0); } }
//******************REF DATA**************************************** public static int InsertOrUpdateT_WQX_REF_DATA(global::System.String tABLE, global::System.String vALUE, global::System.String tEXT, global::System.Boolean?UsedInd) { try { Boolean insInd = true; TWqxRefData a = new TWqxRefData(); if (_db.TWqxRefData.Any(o => o.Value == vALUE && o.Table == tABLE)) { //update case a = (from c in _db.TWqxRefData where c.Value == vALUE && c.Table == tABLE select c).FirstOrDefault(); insInd = false; } a.Table = tABLE; a.Value = vALUE; a.Text = Utils.SubStringPlus(tEXT, 0, 200); if (UsedInd != null) { a.UsedInd = UsedInd; } a.UpdateDt = System.DateTime.Now; a.ActInd = true; if (insInd) //insert case { if (UsedInd == null) { a.UsedInd = true; } _db.TWqxRefData.Add(a); } else { _db.TWqxRefData.Update(a); } _db.SaveChanges(); return(1); } catch (Exception ex) { return(0); } }