コード例 #1
0
 public bool deleteProperty(DataProperty dataProperty)
 {
     foreach (DataProperty property in dataProperties)
     {
         if (dataProperty == property)
         {
             dataProperties.Remove(dataProperty);
             break;
         }
     }
     foreach (KeyProperty keyProperty in keyProperties)
     {
         if (keyProperty.keyPropertyName.ToLower() == dataProperty.propertyName.ToLower())
         {
             keyProperties.Remove(keyProperty);
             break;
         }
     }
     return(true);
 }
コード例 #2
0
        public static string FormWhereClause(DataObject objectType, IList <string> identifiers)
        {
            try
            {
                StringBuilder clauseBuilder = new StringBuilder();
                string[]      delim         = new string[] { objectType.keyDelimeter };

                foreach (string id in identifiers)
                {
                    StringBuilder exprBuilder = new StringBuilder();
                    string[]      idParts     = id.Split(delim, StringSplitOptions.None);

                    if (objectType.keyProperties.Count > 1)
                    {
                        idParts = id.Split(delim, StringSplitOptions.None);
                    }
                    else
                    {
                        idParts[0] = id;
                    }



                    for (int i = 0; i < objectType.keyProperties.Count; i++)
                    {
                        string       key  = objectType.keyProperties[i].keyPropertyName;
                        DataProperty prop = objectType.dataProperties.Find(x => x.propertyName.ToLower() == key.ToLower());

                        string expr = string.Empty;

                        if (IsNumeric(prop.dataType))
                        {
                            expr = string.Format("{0} = {1}", key, idParts[i]);
                        }
                        else if (string.IsNullOrEmpty(idParts[i]))
                        {
                            expr = string.Format("({0} = '' OR {0} IS NULL)", key);
                        }
                        else
                        {
                            expr = string.Format("{0} = '{1}'", key, idParts[i]);
                        }

                        if (exprBuilder.Length > 0)
                        {
                            exprBuilder.Append(" AND ");
                        }

                        exprBuilder.Append(expr);
                    }

                    if (clauseBuilder.Length > 0)
                    {
                        clauseBuilder.Append(" OR ");
                    }

                    clauseBuilder.Append("(" + exprBuilder.ToString() + ")");
                }

                if (clauseBuilder.Length > 0)
                {
                    clauseBuilder.Insert(0, " WHERE ");
                }

                return(clauseBuilder.ToString());
            }
            catch (Exception ex)
            {
                string error = "Error forming WHERE clause: " + ex;
                _logger.Error(error);
                throw new Exception(error);
            }
        }
コード例 #3
0
        public static string CreateUpdateSQL(string tableName, DataObject objectType, SerializableDataObject dataObject)
        {
            switch (dataObject.State)
            {
            case ObjectState.Create:
            {
                StringBuilder colsBuilder = new StringBuilder();
                StringBuilder valsBuilder = new StringBuilder();

                foreach (var prop in dataObject.Dictionary)
                {
                    DataProperty dataProp = objectType.dataProperties.Find(x => x.propertyName == prop.Key);
                    colsBuilder.Append("," + prop.Key);

                    if (BaseLightweightDataLayer.IsNumeric(dataProp.dataType))
                    {
                        if (prop.Value != null && prop.Value != "")
                        {
                            valsBuilder.Append("," + prop.Value);
                        }
                        else
                        {
                            valsBuilder.Append("," + "null");
                        }
                    }
                    else if (dataProp.dataType == DataType.Date || dataProp.dataType == DataType.DateTime)
                    {
                        if (prop.Value != "")
                        {
                            DateTime dateTime = Utility.FromXsdDateTime(prop.Value.ToString());
                            valsBuilder.Append("," + prop.Key + "='" + dateTime.ToString() + "'");
                        }
                        else
                        {
                            valsBuilder.Append("," + prop.Key + "= null");
                        }
                    }
                    else
                    {
                        valsBuilder.Append("," + "'" + prop.Value + "'");
                    }
                }

                if (dataObject.HasContent)
                {
                    colsBuilder.Append("," + HAS_CONTENT);
                    valsBuilder.Append("," + "'" + dataObject.HasContent + "'");
                }

                string insertSQL = string.Format(INSERT_SQL_TPL, tableName, colsBuilder.Remove(0, 1), valsBuilder.Remove(0, 1));
                return(insertSQL);
            }

            case ObjectState.Update:
            {
                StringBuilder builder     = new StringBuilder();
                string        whereClause = BaseLightweightDataLayer.FormWhereClause(objectType, dataObject.Id);

                foreach (var prop in dataObject.Dictionary)
                {
                    DataProperty dataProp = objectType.dataProperties.Find(x => x.propertyName == prop.Key);

                    if (BaseLightweightDataLayer.IsNumeric(dataProp.dataType))
                    {
                        if (prop.Value != null && prop.Value != "")
                        {
                            builder.Append("," + prop.Key + "=" + prop.Value);
                        }
                        else
                        {
                            builder.Append("," + prop.Key + "=" + "null");
                        }
                    }
                    else if (dataProp.dataType == DataType.Date || dataProp.dataType == DataType.DateTime)
                    {
                        if (prop.Value != "")
                        {
                            DateTime dateTime = Utility.FromXsdDateTime(prop.Value.ToString());
                            builder.Append("," + prop.Key + "='" + dateTime.ToString() + "'");
                        }
                        else
                        {
                            builder.Append("," + prop.Key + "= null");
                        }
                    }
                    else
                    {
                        builder.Append("," + prop.Key + "='" + prop.Value + "'");
                    }
                }

                if (dataObject.HasContent)
                {
                    builder.Append("," + HAS_CONTENT + "='" + dataObject.HasContent + "'");
                }

                string updateSQL = string.Format(UPDATE_SQL_TPL, tableName, builder.Remove(0, 1), whereClause);
                return(updateSQL);
            }

            case ObjectState.Delete:
            {
                string whereClause = BaseLightweightDataLayer.FormWhereClause(objectType, dataObject.Id);
                string deleteSQL   = string.Format(DELETE_SQL_TPL, tableName, whereClause);
                return(deleteSQL);
            }
            }

            return(string.Empty);
        }