private SingleClause BuildSingleClause(KeyValuePair <string, string> kv) { SingleClause sc = new SingleClause(); sc.PropertyName = kv.Key; sc.Value = kv.Value; switch (kv.Key) { case "appCode": case "mail": case "fax": case "telefono": case "codiceCanale": case "codiceBackend": case "categoria": sc.Operator = CriteriaOperator.Equal; break; case "contactRef": sc.Operator = CriteriaOperator.StartsWith; break; case "descrBackend": case "descrBackendPlus": sc.Operator = CriteriaOperator.Like; break; } return(sc); }
/// <summary> /// Adds an <see cref="SingleClause" /> element for a join of the form <paramref name="leftSlot" /> = /// <paramref /// name="rightSlot" /> /// . /// </summary> internal void Add( QualifiedSlot leftSlot, MemberPath leftSlotOutputMember, QualifiedSlot rightSlot, MemberPath rightSlotOutputMember) { var singleClause = new SingleClause(leftSlot, leftSlotOutputMember, rightSlot, rightSlotOutputMember); m_singleClauses.Add(singleClause); }
private SingleClause NuildNotNullClause(KeyValuePair <string, string> kv) { SingleClause sc = new SingleClause(); sc.PropertyName = kv.Key; sc.Operator = CriteriaOperator.IsNotNull; return(sc); }
private SingleClause NuildNotNullClause(PropertyInfo pi) { SingleClause sc = new SingleClause(); object[] pa = pi.GetCustomAttributes(typeof(DatabaseFieldAttribute), true); if (pa != null && pa.Length == 1) { DatabaseFieldAttribute dba = (DatabaseFieldAttribute)(pa[0]); if (dba != null && dba.FieldName.Length > 0) { sc.PropertyName = dba.FieldName; } } sc.Operator = CriteriaOperator.IsNotNull; return(sc); }
private SingleClause BuildSingleClause(ContactsApplicationMapping c, PropertyInfo pi) { SingleClause sc = new SingleClause(); object[] pa = pi.GetCustomAttributes(typeof(DatabaseFieldAttribute), true); if (pa != null && pa.Length == 1) { DatabaseFieldAttribute dba = (DatabaseFieldAttribute)(pa[0]); if (dba != null && dba.FieldName.Length > 0) { sc.PropertyName = dba.FieldName; } } sc.Value = pi.GetValue(c, null); switch (sc.PropertyName) { case "APP_CODE": case "MAIL": case "FAX": case "TELEFONO": case "CODICE": case "BACKEND_CODE": case "CATEGORY": case "COM_CODE": case "SOTTOTITOLO_ACTIVE": case "TITOLO_ACTIVE": sc.Operator = CriteriaOperator.Equal; break; case "CONTACT_REF": sc.Operator = CriteriaOperator.StartsWith; break; case "BACKEND_DESCR": case "DESCR_PLUS": sc.Operator = CriteriaOperator.Like; break; } return(sc); }
private string TranslateIClause(IClause clause, DbCommand oCmd, ref int k) { String cmdText = ""; if (clause is SingleClause) { SingleClause sc = clause as SingleClause; if (sc.Operator == CriteriaOperator.IsNull || sc.Operator == CriteriaOperator.IsNotNull) { cmdText += String.Format("({0} {1})", sc.PropertyName, DaoSQLServerDBHelper.TranslateOperator(sc.Operator)); } else { string par = String.Format("p{0}", k++); cmdText += String.Format("({0} {1} :{2})", sc.PropertyName, DaoSQLServerDBHelper.TranslateOperator(sc.Operator), par); try { ObjectParameter p = new ObjectParameter(par, ((SingleClause)clause).Value.ToString()); //oCmd.Parameters.Add(par, ((SingleClause)clause).Value.ToString()); } catch { } } } else if (clause is CombinedClause) { cmdText += "("; CombinedClause cc = clause as CombinedClause; for (int j = 0; j < cc.SubClauses.Count() - 1; j++) { cmdText += String.Format("{0} {1} ", TranslateIClause(cc.SubClauses.ElementAt(j), oCmd, ref k), cc.ClauseType.ToString().ToUpper()); } cmdText += String.Format("{0})", TranslateIClause(cc.SubClauses.Last(), oCmd, ref k)); } return(cmdText); }