if((actionName == "Submit") && this.Request.ActivityCode == this.Request.WorkflowTemplate.StartActivityCode)
{
// 房号+楼号查重
H3.Data.Filter.Filter filter = new H3.Data.Filter.Filter();
H3.Data.Filter.And and = new H3.Data.Filter.And();
and.Add(new H3.Data.Filter.ItemMatcher("F0000113", H3.Data.ComparisonOperatorType.Equal, this.Request.BizObject["F0000113"])); //等于楼号
and.Add(new H3.Data.Filter.ItemMatcher("F0000123", H3.Data.ComparisonOperatorType.NotEqual, "已退")); // 不等于 退房
and.Add(new H3.Data.Filter.ItemMatcher("Status", H3.Data.ComparisonOperatorType.Equal, "1"));//生效的数据 1.生效 2.作废 0.草稿
and.Add(new H3.Data.Filter.ItemMatcher("F0000118", H3.Data.ComparisonOperatorType.Equal, this.Request.BizObject["F0000118"]));//等于房号
//and.Add(new H3.Data.Filter.ItemMatcher("",H3.Data.ComparisonOperatorType.Equal,contractId));
filter.Matcher = and;
H3.DataModel.BizObject[] objects = H3.DataModel.BizObject.GetList(this.Request.Engine, H3.Organization.User.SystemUserId, this.Request.Schema,
H3.DataModel.GetListScopeType.GlobalAll, filter); //查询
if(objects != null && objects.Length > 0)
{
response.Errors.Add("该房源已经提交过了了,请确认是否重复");
return;
}
}
氚云查重功能
最新推荐文章于 2024-05-26 23:07:40 发布