C# update join,delete join

C# update join,delete join

 

public static int UpdateJoin(DbFactory factory, string relationKey, string foreignKey, Dictionary<string, object> data, string condition, Joins mode, out string sql)
        {
            int count = data.Count;
            if (count == 0)
            {
                throw new ArgumentException("data");
            }
            string table = relationKey.Substring(0, relationKey.IndexOf(SqlBuilder.JoinSymbol)), foreignTable = foreignKey.Substring(0, foreignKey.IndexOf(SqlBuilder.JoinSymbol));
            count *= 8 + Math.Max(table.Length, foreignTable.Length);
            StringBuilder sb = new StringBuilder(count);
            using (Dictionary<string, object>.Enumerator e = data.GetEnumerator())
            {
                e.MoveNext();
                sb.Append(e.Current.Key).Append("=").AppendValue(e.Current.Value);
                while (e.MoveNext())
                {
                    sb.Append(SqlBuilder.Separator).Append(e.Current.Key).Append("=").AppendValue(e.Current.Value);
                }
            }
            switch (factory.ProviderName)
            {
                case DbProvider.Sql:
                    sql = String.Concat("UPDATE [", table, "] SET ", sb.ToString(), " FROM [", table, "] ", mode.ToString(), " JOIN [", foreignTable, "] ON ", relationKey, "=", foreignKey, SqlBuilder.Space, condition);
                    break;
                case DbProvider.OleDb:
                    sql = String.Concat("UPDATE [", table, "] ", mode.ToString(), " JOIN [", foreignTable, "] ON ", relationKey, "=", foreignKey, " SET ", sb.ToString(), SqlBuilder.Space, condition);
                    break;
                default:
                    throw new NotSupportedException();
            }
            return DbBase.ExecuteNonQuery(factory, sql);
        }

        public static int DeleteJoin(DbFactory factory, string relationKey, string foreignKey, string condition, Joins mode, out string sql)
        {
            string table = relationKey.Substring(0, relationKey.IndexOf(SqlBuilder.JoinSymbol)), foreignTable = foreignKey.Substring(0, foreignKey.IndexOf(SqlBuilder.JoinSymbol));
            switch (factory.ProviderName)
            {
                case DbProvider.Sql:
                    sql = String.Concat("DELETE FROM [", table, "] FROM [", table, "] ", mode.ToString(), " JOIN [", foreignTable, "] ON ", relationKey, "=", foreignKey, SqlBuilder.Space, condition);
                    break;
                case DbProvider.OleDb:
                    sql = String.Concat("DELETE ", table, ".*,", foreignTable, ".* FROM [", table, "] ", mode.ToString(), " JOIN [", foreignTable, "] ON ", relationKey, "=", foreignKey, SqlBuilder.Space, condition);
                    break;
                default:
                    throw new NotSupportedException();
            }
            return DbBase.ExecuteNonQuery(factory, sql);
        }

 

 

posted on 2010-06-16 19:02 RockyLOMO 阅读(...) 评论(...) 编辑 收藏