private void loadModuleComment() { using (MB.WinBase.WaitCursor cursor = new MB.WinBase.WaitCursor(this.ParentForm)) { if (_CommentClient == null) { throw new MB.Util.APPException("需要配置 IBfModuleCommentClient 客户端"); } if (string.IsNullOrEmpty(_ViewGridForm.ClientRuleObject.ModuleTreeNodeInfo.PriID)) { throw new MB.Util.APPException("该模块对应的权限 PriID 没有配置,请先配置"); } MB.Util.Common.QueryParameterHelper parHelper = new MB.Util.Common.QueryParameterHelper(); parHelper.AddParameterInfo("APPLICATION_IDENTITY", COMMENT_APPLICATION_IDENTITY, MB.Util.DataFilterConditions.Equal); parHelper.AddParameterInfo("MODULE_IDENTITY", _ViewGridForm.ClientRuleObject.ModuleTreeNodeInfo.PriID, MB.Util.DataFilterConditions.Equal); _LstComments = _CommentClient.GetObjects(parHelper.ToArray()); _LstComments.Sort(new Comparison <MB.Util.Model.BfModuleCommentInfo>(commentCreateDateCompare)); rxtModuleComment.Clear(); foreach (var commentInfo in _LstComments) { appendModuleComment(commentInfo); } } }
private void button7_Click(object sender, EventArgs e) { MB.Util.Common.QueryParameterHelper helper = new MB.Util.Common.QueryParameterHelper(); helper.AddParameterInfo("1", "1", MB.Util.DataFilterConditions.Special); helper.AddParameterInfo("", "ID in(2,2,3,3)", MB.Util.DataFilterConditions.SqlAppend); string sql = MB.Orm.DbSql.SqlShareHelper.Instance.QueryParametersToSqlString(null, helper.ToArray()); MessageBox.Show(sql); }