public IList <EnumValue> GetFormComboBoxValues(BizForm form, BizComboBox comboBox) { var list = new List <EnumValue>(); foreach (var pair in _repositories) { list.AddRange(pair.Value.GetFormComboBoxValues(form, comboBox)); } return(list); }
public List <EnumValue> GetEnumDocumentValues(BizComboBox combo, AttrDef attrDef) { var result = new List <EnumValue>(); foreach (var pair in _repositories.Where(pair => pair.Key.DataType.HasFlag(DataContextType.Document))) { result.AddRange(pair.Value.GetEnumDocumentValues(combo, attrDef)); } return(result); }
private AttrDef GetComboBoxAttrDef(BizForm form, BizComboBox comboBox) { var finder = new FormHelper(Provider, form); var docDef = finder.FindAttributeDocDef(comboBox.AttributeDefId); if (docDef != null) { return(docDef.Attributes.FirstOrDefault(a => a.Id == comboBox.AttributeDefId)); } return(null); }
public IList <EnumValue> GetFormComboBoxValues(BizForm form, BizComboBox comboBox) { /*var masters = new List<BizControl>(); * if (comboBox.Masters != null && comboBox.Masters.Count > 0) * { * var finder = new ControlFinder(form); * foreach (var masterId in comboBox.Masters) * { * var master = finder.Find(masterId); * if (master != null) * masters.Add(master); * } * }*/ return(GetFormComboBoxValues(form, comboBox, GetComboBoxAttrDef(form, comboBox))); }
public string GetComboBoxDetailValue(BizComboBox comboBox, AttrDef attrDef) { if (comboBox.Value == null) { return(null); } if (attrDef == null) { switch (comboBox.Ident) { case SystemIdent.OrgId: case SystemIdent.OrgCode: case SystemIdent.OrgName: return(GetEnumOrganizationValue((Guid)comboBox.Value)); case SystemIdent.UserId: case SystemIdent.UserName: return(GetEnumUserValue((Guid)comboBox.Value)); } return(null); } if (attrDef.Type.Id == (short)CissaDataType.Doc && attrDef.DocDefType != null) { return (_repositories.Where(pair => pair.Key.DataType.HasFlag(DataContextType.Document)) .Select(pair => pair.Value.GetComboBoxDetailValue(comboBox, attrDef)) .FirstOrDefault()); } if (attrDef.Type.Id == (short)CissaDataType.Enum && attrDef.EnumDefType != null) { return(_enumRepo.GetEnumValue(attrDef.EnumDefType.Id, (Guid)comboBox.Value)); } if (attrDef.Type.Id == (short)CissaDataType.Organization) { return(GetEnumOrganizationValue((Guid)comboBox.Value)); } if (attrDef.Type.Id == (short)CissaDataType.User) { return(GetEnumUserValue((Guid)comboBox.Value)); } return(null); }
public IList <EnumValue> GetFormComboBoxValues(BizForm form, BizComboBox comboBox, AttrDef attrDef) { var list = new List <EnumValue>(); if (attrDef == null) { switch (comboBox.Ident) { case SystemIdent.OrgId: case SystemIdent.OrgCode: case SystemIdent.OrgName: return(GetEnumOrganizationValues(comboBox.DetailAttributeId)); case SystemIdent.UserId: case SystemIdent.UserName: return(GetEnumUserValues()); } return(list); } if (attrDef.Type.Id == (short)CissaDataType.Doc && attrDef.DocDefType != null) { foreach (var pair in _repositories.Where(pair => pair.Key.DataType.HasFlag(DataContextType.Document))) { list.AddRange(pair.Value.GetFormComboBoxValues(form, comboBox, attrDef)); } return(list); } if (attrDef.Type.Id == (short)CissaDataType.Enum && attrDef.EnumDefType != null) { return(new List <EnumValue>(_enumRepo.GetEnumItems(attrDef.EnumDefType.Id))); } if (attrDef.Type.Id == (short)CissaDataType.Organization) { return(GetEnumOrganizationValues(attrDef.OrgTypeId)); } if (attrDef.Type.Id == (short)CissaDataType.User) { return(GetEnumUserValues()); } return(list); }
public IList <EnumValue> GetFormComboBoxValues(BizForm form, BizComboBox comboBox) { // return FormRepo.GetFormComboBoxValueList(form, comboBox); return(_comboBoxValueProvider.GetFormComboBoxValues(form, comboBox)); }
public List <EnumValue> GetEnumDocumentValues(BizComboBox combo, DocDef detailDocDef, Guid?userId) { var list = new List <EnumValue>(); if (detailDocDef == null) { return(list); } //var defRepo = new DocDefRepository(context); var docDef = _docDefRepo.DocDefById(detailDocDef.Id); AttrDef detailAttrDef; if (combo.DetailAttributeId != null) { detailAttrDef = docDef.Attributes.FirstOrDefault(ad => ad.Id == combo.DetailAttributeId); } else { detailAttrDef = docDef.Attributes.FirstOrDefault( ad => String.Equals(ad.Name, combo.DetailAttributeName, StringComparison.OrdinalIgnoreCase)); if (detailAttrDef == null) { detailAttrDef = docDef.Attributes.FirstOrDefault( ad => ad.Type.Id == (int)CissaDataType.Text); } } if (detailAttrDef == null) { return(list); } var sqb = _sqlQueryBuilderFactory.Create(); // using (var query = userId != null ? new SqlQuery(context, docDef, (Guid)userId) : new SqlQuery(context, docDef)) // using (var query = sqb.Build(docDef.Id, null, null)) using (var query = sqb.Build(combo, docDef.Id)) { query.AddAttribute("&Id"); query.AddAttribute(detailAttrDef.Id); query.AddOrderAttribute(detailAttrDef.Id); using (var reader = _sqlQueryReaderFactory.Create(query)) //new SqlQueryReader(context, query)) { while (reader.Read()) { var detail = !reader.IsDbNull(1) ? reader.GetString(1) : String.Empty; list.Add(new EnumValue { Id = reader.GetGuid(0), Value = detail, DefaultValue = detail }); } } } return(list); }
public List <EnumValue> GetEnumDocumentValues(BizComboBox combo, AttrDef attrDef) { return(GetEnumDocumentValues(combo, attrDef.DocDefType, UserId)); }
public List <EnumValue> GetEnumDocumentValues(BizComboBox combo, DocDef detailDocDef) { return(GetEnumDocumentValues(combo, detailDocDef, UserId)); }
public string GetComboBoxDetailValue(BizComboBox comboBox, AttrDef attrDef) { if (comboBox.Value == null) { return(null); } if (attrDef == null) { switch (comboBox.Ident) { case SystemIdent.OrgId: case SystemIdent.OrgCode: case SystemIdent.OrgName: return(GetEnumOrganizationValue((Guid)comboBox.Value)); case SystemIdent.UserId: case SystemIdent.UserName: return(GetEnumUserValue((Guid)comboBox.Value)); } return(null); } if (attrDef.Type.Id == (short)CissaDataType.Doc && attrDef.DocDefType != null) { var detailDocDef = _docDefRepo.DocDefById(attrDef.DocDefType.Id); AttrDef detailAttrDef; if (comboBox.DetailAttributeId != null) { detailAttrDef = detailDocDef.Attributes.FirstOrDefault(ad => ad.Id == comboBox.DetailAttributeId); } else { detailAttrDef = detailDocDef.Attributes.FirstOrDefault( ad => String.Equals(ad.Name, comboBox.DetailAttributeName, StringComparison.OrdinalIgnoreCase)) ?? detailDocDef.Attributes.FirstOrDefault(ad => ad.Type.Id == (int)CissaDataType.Text); } if (detailAttrDef == null) { return(null); } var sqlQueryBuilder = _sqlQueryBuilderFactory.Create(); using (var query = sqlQueryBuilder.Build(comboBox, detailDocDef.Id)) { query.AddAttribute("&Id"); query.AddAttribute(detailAttrDef.Id); query.AndCondition("&Id", ConditionOperation.Equal, comboBox.Value); using (var reader = _sqlQueryReaderFactory.Create(query)) { if (reader.Read()) { return(!reader.IsDbNull(1) ? reader.GetString(1) : String.Empty); } } } } else if (attrDef.Type.Id == (short)CissaDataType.Enum && attrDef.EnumDefType != null) { return(_enumRepo.GetEnumValue(attrDef.EnumDefType.Id, (Guid)comboBox.Value)); } else if (attrDef.Type.Id == (short)CissaDataType.Organization) { return(GetEnumOrganizationValue((Guid)comboBox.Value)); } else if (attrDef.Type.Id == (short)CissaDataType.User) { return(GetEnumUserValue((Guid)comboBox.Value)); } return(null); }
public string GetComboBoxDetailValue(BizForm form, BizComboBox comboBox) { var attrDef = GetComboBoxAttrDef(form, comboBox); return(GetComboBoxDetailValue(comboBox, attrDef)); }
public IList <EnumValue> GetFormComboBoxValues(BizForm form, BizComboBox comboBox, AttrDef attrDef) { var list = new List <EnumValue>(); if (attrDef == null) { switch (comboBox.Ident) { case SystemIdent.OrgId: case SystemIdent.OrgCode: case SystemIdent.OrgName: return(GetEnumOrganizationValues(comboBox.DetailAttributeId)); case SystemIdent.UserId: case SystemIdent.UserName: return(GetEnumUserValues()); } return(list); } if (attrDef.Type.Id == (short)CissaDataType.Doc && attrDef.DocDefType != null) { var detailDocDef = _docDefRepo.DocDefById(attrDef.DocDefType.Id); AttrDef detailAttrDef; if (comboBox.DetailAttributeId != null) { detailAttrDef = detailDocDef.Attributes.FirstOrDefault(ad => ad.Id == comboBox.DetailAttributeId); } else { detailAttrDef = detailDocDef.Attributes.FirstOrDefault( ad => String.Equals(ad.Name, comboBox.DetailAttributeName, StringComparison.OrdinalIgnoreCase)) ?? detailDocDef.Attributes.FirstOrDefault(ad => ad.Type.Id == (int)CissaDataType.Text); } if (detailAttrDef == null) { return(list); } var sqlQueryBuilder = _sqlQueryBuilderFactory.Create(); using (var query = sqlQueryBuilder.Build(comboBox, detailDocDef.Id)) { query.AddAttribute("&Id"); query.AddAttribute(detailAttrDef.Id); query.AddOrderAttribute(detailAttrDef.Id); if (form != null) { var helper = new FormHelper(Provider, form); helper.SetQueryParams(query); } using (var reader = _sqlQueryReaderFactory.Create(query)) //new SqlQueryReader(context, query)) { while (reader.Read()) { var detail = !reader.IsDbNull(1) ? reader.GetString(1) : String.Empty; list.Add(new EnumValue { Id = reader.GetGuid(0), Value = detail, DefaultValue = detail }); } } } } else if (attrDef.Type.Id == (short)CissaDataType.Enum && attrDef.EnumDefType != null) { return(new List <EnumValue>(_enumRepo.GetEnumItems(attrDef.EnumDefType.Id))); } else if (attrDef.Type.Id == (short)CissaDataType.Organization) { return(GetEnumOrganizationValues(attrDef.OrgTypeId)); } else if (attrDef.Type.Id == (short)CissaDataType.User) { return(GetEnumUserValues()); } return(list); }
public IList <EnumValue> GetFormComboBoxValues(BizComboBox comboBox, AttrDef attrDef) { return(GetFormComboBoxValues(null, comboBox, attrDef)); }