/// <summary> /// 移除[删除]OPSx /// </summary> /// <param name="LK_OBJT"></param> /// <param name="LK_OBJT_ID"></param> /// <param name="tran"></param> public void RemoveOPSx(int LK_OBJT, int LK_OBJT_ID, QDbTran tran) { OPSxM o = new OPSxM(); o.Where(o.LK_OBJT == LK_OBJT) .And(o.LK_OBJT_ID == LK_OBJT_ID) .UsingFilter(false) .Delete(tran); }
/// <summary> /// 获取OPSx /// </summary> /// <param name="LK_OBJT"></param> /// <param name="LK_OBJT_ID"></param> /// <param name="tags"></param> /// <returns></returns> public string GetOPSx(int LK_OBJT, int LK_OBJT_ID, string tags) { OPSxM o = new OPSxM(); o.Where(o.LK_OBJT == LK_OBJT).And(o.LK_OBJT_ID == LK_OBJT_ID); if (tags != null) { o.And(o.Tags.Like("%" + tags + "%")); } return(o.SelectValue <string>(o.OPSx, "")); }
/// <summary> /// 设置OPSx /// </summary> /// <param name="LK_OBJT"></param> /// <param name="LK_OBJT_ID"></param> /// <param name="tags"></param> /// <param name="opsXml"></param> /// <param name="tran"></param> public void SetOPSx(int LK_OBJT, int LK_OBJT_ID, string tags, string opsXml, QDbTran tran) { OPSxM o = new OPSxM(); o.LK_OBJT.Value = LK_OBJT; o.LK_OBJT_ID.Value = LK_OBJT_ID; o.Tags.Value = tags; o.OPSx.Value = opsXml; o.Where(o.LK_OBJT == LK_OBJT) .And(o.LK_OBJT_ID == LK_OBJT_ID) .And(o.Tags == tags) .UsingFilter(false); if (o.Update(tran) == false) { o.Insert(tran); } }